Valuation Modeling: Excel as a tool
Excel is a powerful tool, but in our zeal to test out its many powers, we often overuse, and spend far too much time thinking about modeling and too little about business and valuation first principles. I do have a base valuation spreadsheet that I use to value almost every non-financial service company, and over time I have added some bells and whistles. That said, at its core it remains a simple spreadsheet, with no macros or Excel functions. In this session, I provide a link to the spreadsheet and how to use in valuing company, going input cell by input cell. (I am sorry if my voice sounds ragged, but I have a scratchy throat (nope.. Not COVID) and just got off a long flight.)
Spreadsheet: pages.stern.nyu.edu/~adamodar...
Пікірлер: 184
Professor Aswath is the best! He is an unsung hero in these times! Everyone trying to charge for every thing they can and he just shares his knowledge for free in humility..
@ramjiYahoo
5 ай бұрын
True he is so generous
@monsterboomer8051
5 ай бұрын
He is the real scholar.
@AshayDoshi
5 ай бұрын
Yes you are right! But he isn't unsung. He is well appreciated worldwide!
What a great guy. Giving away his knowledge just to help others. No ego no charges. Thanks Aswath!
wake up babe, new damodaran video just dropped
@agarpendergrass
5 ай бұрын
lmao
I found the most underrated channel on KZread. Excellent Sir.
No words are enough to thank you for your great support in serving the world and liberating the knowledge sharing. Many thanks professor❤❤
What a time to be alive. I can’t believe we can get this for free! Thank you professor.
Still the best channel in KZread, thanks you so much professor
Thank you professor! I'm not a finance guy, just a computer science nerd and I listen to your new lectures when they come out :)
Thank you sir, others have you pay for such spreadsheets on their patreon. Truly a godsend
I really appreciate the passion that you have for valuation and for all the effort you make in producing these videos and explaining your process. It's really great of you to do this.
Very generous of you to provide these. Thank you, Professor.
Prof Ashwath, From the time you'd featured my earlier company CommerceOne, I've been a keen follower. Thank you for the service you render in spreading knowledge. 🙏🙏
Really thanks for the video and keeping knowledge free at these crucial times.
Thanks to you professor, its an incredibile opportunity to have all of this material to study 🙏
TREMENDOUSLY HELPFUL. THANK YOU Prof.🙏
I have smiled throughout the entirety of this--gold. If I choose to get an MBA, it will certainly be at Stern because of you, professor.
@HunterD510
4 ай бұрын
Sure, if you have an extra $180k to spare.
You are a true educationist Professor!. Thank You🙏
professser, thank you so much for your efforts, no words can express my gratitude towards you.
Thanks a lot professor for share your classes. I do appreciate it. Thanks!
Aswath is a national treasure. All his NYU content is available here FREE... that's crazy. The Ginzu knife commercials were the best!!!! They were great at doing everything!
Aswath you are the second best to no one !
Un privilegio ver estos videos. Thank you
7:30 Iterative calculations on PC: File (top left button) -> Options (near bottom of left bar) -> Formulas -> Calculation options (should be top right)
Always very helpful.. Just remarkable in checking all necessary elements of valuation!!!
Awesome! knowledge philanthropy. bowing down in reverence. Hats off Sir..
@user-dn1cr6nb1c
5 ай бұрын
I like this, knowledge philanthropy!
This is Gold, thank you Professor!
Very clear explanation. Agree with everyone that Prof Damodaran is the best at what he does
Great to get the precious Channel..Thanks Prof Aswath
I valued UBS post merger before Q2 results with this sheet and bought a call option, which helped me incorporate my startup. I value your words more than anyone my uValue Ninja.
@estebangarzonlerma
5 ай бұрын
by "helping me incorporate my startup" what do you mean? You bought the call option, made a return and the profit helped pay for the incorporation of the company or was the trade the first actionable idea for your (trading) startup? Thank you
Top class content for free, many people charge 000s of $$ for a hyped but average and basic valuation courses...Hats off to you Aswath
From Argentina, thank you very much.!!!!! I will use it with WMT tomorrow.
Thank you. You truly are a great professor.
Professor, you are the man! Thank you!
Thanks Aswath, This is worth more than gold.. I hope everyone watches this video before investing in the stock market. God Bless
Great Video Prof. Much appreciated, thanks!
thank you for sharing this guide. I welcome this video...
This is really helpful and informative. Thank you .
Thank you very much as always Professor!!!
Thank you from Argentina Professor !!!!
thank you sir, that was a gold mine of information.
Thank you prof! Using this for my next Seeking Alpha article!
Thank you, don't know much about finance, but your videos do help me a bit on the finance side. I am from the IT field so understand very little about what you are teaching. I still appreciate your knowledge share
This was a great video. I would love to see a video or model on financial services companies. All of your videos are outstanding, though!
Thanks for sharing the work you are doing.... great work!!.... small comment - Ireland marginal tax rate is 15% for large firms from 1st Jan 2024 (after adopting BEPS Pillar 2).
Thanks for sharing professor!
thanks for sharing your knowledge.
Thank you, Professor!
very very useful spreadsheet sir, having all the info in a simple spreadsheet
@Nikhil-qd2qg
2 ай бұрын
Are you able to see spreadsheet? I am not able to open it why?
You are amazing! Thank you, thank you, thank you!
Thanks Prof Damodaran
Spreading this knowledge for free ..❤
THE BEST PROF ASWATH DAMODRAN.
Holy moly, thank you so much.
Thank you professor!
Thank you, you are amazing!
Thank you Professor!
perfect , Thanks Professor
may god bless you sir
I learnt about you through my FR teacher Kalpesh Mehta who teach FR in JKSC CA Final Batch. He claimed Aswath is the best in valuation
Hero in disguise!
thank you sir for your openess.....
Thank you Prof!
ginsu knives analogy.... :Whatta bargain'...... Thank you professor
Thank you so much 🙏
Great video!
Thank you sir!
Very appreciated.
Thank you Prof aswath, i hope you can discuss about the cost and evaluation of mining
thank you professor
24:53 "Well again, I'm a full service operation" Classic lol. Thanks for the laughs professor.
Thank you
I love it
Thanks for this information video! I learn a lot from it. One question I still have after this video is that: what number should I put into "Book value of debt" for a bank. A bank record all various things as interest bearing liabilities. I feel it's not quite right to put $0 here, but don't know which reporting number to look for.
thanks prof!
❤ thank you
Dear Professor, great video sir and your knowledge sharing enlightened me so much. some times I face challenges to estimate the effective tax rate. Any guidance on this?
Thank you sir
2023 was a hell of a year, in the health profession i have made $250,000 before taxes as the sole breadwinner and head of household. This is a great starting point and I’m very aware how blessed we are to be in this position, but I’m always looking ahead on how to improve.
@Paullookman
5 ай бұрын
You want to work with a money coach or financial planner, although a wealth manager will concentrate on long term, a money coach will help you with paying off all of your debts, maximize your cash flow and help you create systems and processes to direct your money proactively.
@xavier_lucas
5 ай бұрын
I have thought about this, but what is the major difference between a money coach & financial advsior?
@Paullookman
5 ай бұрын
A financial planner/wealth managercouls help too to create a more holistic plan for your money. They can assist you in the creation of both short and long-term goal and then help you by giving guidance on the financial decisions and opportunities you are presented with.
@Paullookman
5 ай бұрын
Yeah get you an invaluable adviser, everyone has blind spots when it comes to their finances. I began consulting with mine in NY from WA. I have a plan in place now and began to love spreadsheets making exactly 702 thousand in the past 8 months from barely 400 grand makes me have high hopes for 2023.
@Rachelkkk66
5 ай бұрын
Who is this person you work with? I have tried getting around me and it is practically impossible to get one that doesn’t charge exorbitantly. Can you also share what the fee structure is like?
Hi Good Evening, Thank you so much for your sharing knowledge. The Myanmar Corporate Income Tax rate is 22 percent.
Prof Aswath, thanks for your updated excel which I have been using extensively. Notice that the formula of Reinvestment in Valuation Output has changed due to the new insertion of 'year lag between reinvesting and generating growth from that reinvestment' in cell B56 of Input cell. In previous version, the reinvestment used the revenue difference between next and current year to calculate. However, this updated excel uses revenue difference between previous and current year instead as default (when input 'No' in B56); and between next and current year when year lag is 0 year. May I know whether there is some variable error or it is the correct formula that rectify previous version bug? Should 0 year lag and default assumption (when stated 'No') be using the same revenue numerator variables instead? Tks for your kind advice.
Thank you for this wonderful video & material - a question on R&D Conversion. If a company releases R&D figures where part of the total has already been capitalized, and the proportion is known, should only the OpEx R&D figures go into the converter, as the capitalized portion will already been assumed as part of the other inputs, or does this skew the R&D data without ever considering the already-capitalized expenses? Thanks
Hello, thanks a lot for all of this. About the R&D converter page, if I'm not mistaken the table with estimates for the différents industries doesn't appear on the file I downloaded today (16/02/2024). Regards
@AswathDamodaranonValuation
5 ай бұрын
Fixed it.
Question / comment: Cell B31 Sales to capital ratio for 1-5 years points to years 1 to 4 instead of 1 to 5 on the Valuation output sheet, otherwise great spreadsheet :-)
@AswathDamodaranonValuation
5 ай бұрын
Fixed. Thank you!
Hi, many thanks for the excel model, it's very useful! Just a question, how should I consider in the file dividend payments?
@profaswath ... i would like to ask if it is possible to use this valuation Excel tool to evaluate a business unit or country business entity ? if yes, would it be possible to explain/illustrate how it might be done ? it would be much appreciated.
wait, if I'm doing this in November like you said and I'm using the 3 most recent quarters of 2024 and the last quarter of 2023 as my last 12 months, then the last 10k would be the 2023 annual report? which also includes the last quarter of 2023?
Could you share some more information on the sales to capital ratio? I’m valuing a growing p&c insurer and the standard 1.5 ratio is giving me a negative FCFF. Not too sure what it means and I’d like to understand it better. Thanks!
I love the spreadsheet but there are 2 things I am uncertain about. Is there no need to add capex and depreciation & amortization because of the sales to capital ratio? Because I don’t see depreciation and amortization added to my fcff‘s, and I don’t see an option to add capex. Also, does the beta in the detailed coc variation account for the debt/equity ratio of the company?
Kindly do one for financial services companies like banks please.
Great sir
@ajithreddy533
5 ай бұрын
Sorry to ask sir could you come up with an Indian multi business and different business model because I am not getting the industry average for India
Shouldn't we add D&A to the FCF in the Valuation Output tab? Or I am missing something? Thanks.
If I capitalize r&d, will the spreadsheet account for that with the operating profit? Because if I use the operating profit or ebit from the 10k, r&d is already subtracted, so I don’t want to double count it.
😊 #zomato is still cheap. Your Valuation Video on it made my Conviction Strong. Thanks 😊
@Senor_Avila
5 ай бұрын
Did he valuated again Zomato in recent year
Great video! Just curious as to how you all come up with your sales to capital ratios? I often feel like I’m just pulling a number out of a hat based on this year and previous years.
@AswathDamodaranonValuation
5 ай бұрын
It is the weakest link, since it is purely empirical. That is why I have computed all of the variants of sales to capital ratio (average and marginal) by industry group and for the company.
Can you please make a video elaborating on the reinvestment part in the 'valuation output' sheet? thank you, sir!
Hi Aswath! Are you planning to revisit CART? They had two earning calls after you covered their IPO.
Has anyone got this to work in Google Sheets? One of the first things I noticed was the drop down on the 'Input' sheet for 'Industry' does not pull the data from the 'Industry Averages' sheet because the sheet is trying to pull data from a 'Master data' sheet which I can not locate. Ive opend this file in the free version of Excel but I was not able to find the 'Master data' sheet. Any help or clarification would be appreciated.
Hello Professor Damodaran, I noticed that the cells in the lookup table for Approach 3 on the Cost of Capital Worksheeet is hard coded with various percentages that are added to the risk-free rate. Can you tell us where to find the source data for those percentages? I assume they will change over time. Thank you!
@AswathDamodaranonValuation
5 ай бұрын
They are based upon the histogram of the costs of capital of all publicly traded firms in the world that I update at the start of every year. You should be able to see the most recent year’s update in the data updates at the start of the year.
One semester teaching in a 45 min session. 🎊 🎉
🙌