Using the Ginzu Spreadsheet in Valuation

  Рет қаралды 54,892

Aswath Damodaran

Aswath Damodaran

7 жыл бұрын

This is a webcast that leads you through the spreadsheet that I use to value most companies, called fcffsimpleginzu.xls. In keeping with my theme of connecting stories to numbers, I use Severstal, a Russian company, to illustrate how I constructed my story and then converted the story into numbers on the spreadsheet.
Slides: www.stern.nyu.edu/~adamodar/pd...
Severstal valuation: www.stern.nyu.edu/~adamodar/pc...
Ginzu Spreadsheet: www.stern.nyu.edu/~adamodar/pc...

Пікірлер: 34
@dineshssairam
@dineshssairam 6 жыл бұрын
It's unbelievable that all of this knowledge is available for free! For someone like me, aspiring to understand the valuation game, this is absolutely amazing. They say 'there's no free lunch', but this a free effing feast, right here! Thank you, Mr. Aswath. Please continue to educate us.
@abdulazizs2978
@abdulazizs2978 7 жыл бұрын
Love and Respect for you Dr.Aswath
@chrisb481
@chrisb481 2 жыл бұрын
Hands down the best there is. Thank you for posting this and walking us through the valuation and the valuation spreadsheet.
@remotaurog
@remotaurog 7 жыл бұрын
Just what I was looking for, great work as always.
@anurakulatunga2918
@anurakulatunga2918 2 жыл бұрын
Amazing - this is so valuable and it is a free course. Thank you Mr. Damodaran and thank you so much for your effort to educate us.
@matt79de
@matt79de 2 жыл бұрын
Thank you. I wish i came across your work earlier in life. 'The little book of valuation' got me started and it went off like a bomb. I am very glad that you keep sharing Your knowledge and findings online like that. Taking the mission of learning and teaching to heart like You do is more than admirable and - at that degree - still a rare find these days. Your work and Your rebellious character are outstanding. (I am really lacking words here, i am just blown away.) I am looking forward to dive deeper into your other materials. To anyone else reading this comment: Keep digging into his experience and wisdom, it will be worth every minute and has a few good laughs along the way...
@moscagabriele
@moscagabriele 2 жыл бұрын
100% agree. You couldn't describe better what I think. Can't wait to meet him once in the future just to say thank you.
@MrWspanialy
@MrWspanialy 2 жыл бұрын
Thank you so much for sharing your knowledge. It is amazing and truly generous of you, tells much about your scientific/educational mission for the society!
@chandrannatarajan6616
@chandrannatarajan6616 Жыл бұрын
Thank you Prof. Be blessed always. On my path to learning.🙏
@alexandergunnar3612
@alexandergunnar3612 7 жыл бұрын
Superb as always!
@wm6549
@wm6549 7 жыл бұрын
Thank you so much for this!
@maxr2663
@maxr2663 6 жыл бұрын
The GOAT of valuation
@RobertBeasy
@RobertBeasy 7 жыл бұрын
Outstanding!
@snygarmeister
@snygarmeister 7 жыл бұрын
Thank You for this exercise!
@imzan3650
@imzan3650 7 жыл бұрын
Valuation Beast!
@DK-mu4sq
@DK-mu4sq Жыл бұрын
Thanks a lot for this content !
@glenborg7884
@glenborg7884 6 жыл бұрын
Thank you!
@bhavishajain
@bhavishajain 7 жыл бұрын
Many Thanks Sir!!
@user-wo6mb5zx5z
@user-wo6mb5zx5z 8 ай бұрын
Admiration Professor Damodaran - every piece of information from you is a blessing for all of us! Not sure if it's only for me but I cannot download the spreadsheet files, anyone else having this issues?
@ahmadnounou5781
@ahmadnounou5781 6 жыл бұрын
Absolute legend
@willem3277
@willem3277 7 жыл бұрын
Legendary.
@anonym8730
@anonym8730 5 жыл бұрын
Thank you for the video and this spreedsheet. Great content! I was wondering if you would advice to use the numbers of yahoo finance or the annual report of the company. Furthermore, I would appreciate if you could comment on the choice of a broker for doing transactions. Besides low fees, what should an investor look for when choosing a broker? Should he or she buy stock with the company directly?
@feiyuanli2577
@feiyuanli2577 2 жыл бұрын
You are the best
@basuoo7
@basuoo7 7 жыл бұрын
Great video sir. I would be grateful if you kindly help us modify the spreadsheet for companies which are not traded in USA stock market but in different country eg: India.
@andrewnelson9570
@andrewnelson9570 7 жыл бұрын
Professor, where are you culling your industry averages data from? I am trying to run through the workbook now, but there seems to be no scraping on the averages sheets and the comparison looks vastly off.
@rahulunni2657
@rahulunni2657 3 жыл бұрын
Rock star teacher
@princesangeluniyal
@princesangeluniyal 6 жыл бұрын
Great video as usual. How often do you update industry averages data?
@mwboy3897
@mwboy3897 4 ай бұрын
i wonder too!
@mergenman7894
@mergenman7894 6 жыл бұрын
Great
@chrishuangcfa8797
@chrishuangcfa8797 3 жыл бұрын
Dear professor,should I add NCC(non-cash-charge) back to EBIT when using this FCFF model? thank u
@SM-lt8yr
@SM-lt8yr 6 жыл бұрын
DEAR DR. ASWATH, Which specific fields shall I delete while valuing the sale/acquisition of a Privately-owned Company in a tax-free city (Dubai which didn't have taxes until Dec 31 2017, then 5% was added as VAT). Thanks, Syed
@GarbageGoober.
@GarbageGoober. Жыл бұрын
How does this spreadsheet account for Capital Expenditures?
@billyblack3816
@billyblack3816 Жыл бұрын
All the spreadsheets are in view only mode....help?
@pranavsharma203
@pranavsharma203 5 жыл бұрын
NO SUCH NEED OF CUMBERSOME WORK..as a layman-I just see earning per share (EPS)of previous year of a company..then compare it's highest and lowest share price...the lowest value of the share in that year is VALUATION of that company.....one has to do this activity for multiple years..to get right..... THANKS
Screening for Stocks on S&P Capital IQ: A Quick Tour
12:58
Aswath Damodaran
Рет қаралды 33 М.
Session 4A: More on the Dark Side of Valuation
1:38:59
Aswath Damodaran
Рет қаралды 4,1 М.
Incredible magic 🤯✨
00:53
America's Got Talent
Рет қаралды 67 МЛН
Вечный ДВИГАТЕЛЬ!⚙️ #shorts
00:27
Гараж 54
Рет қаралды 14 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 34 МЛН
WHO LAUGHS LAST LAUGHS BEST 😎 #comedy
00:18
HaHaWhat
Рет қаралды 18 МЛН
Numbers and Narratives
1:22:29
CFA Society Switzerland
Рет қаралды 81 М.
Knowledge Series | Ep 4: Startup Valuation with Aswath Damodaran
1:45:50
I-Venture @ ISB
Рет қаралды 10 М.
A Tesla Revisit: Story Twists and Turns with Value Consequences
40:21
Aswath Damodaran
Рет қаралды 47 М.
The Dark Side of Valuation: India Business Forum
47:52
NYU Stern
Рет қаралды 144 М.
Session: Closing Session
1:22:39
Aswath Damodaran
Рет қаралды 4,9 М.
Session 23: Private Company Valuation
1:18:42
Aswath Damodaran
Рет қаралды 9 М.
Session 2: The End Game in Business
1:38:08
Aswath Damodaran
Рет қаралды 10 М.
Ses 2: Present Value Relations I
1:15:56
MIT OpenCourseWare
Рет қаралды 885 М.
Session 10: Cash Flows to the firm and Equity & first steps on growth
1:18:10
Incredible magic 🤯✨
00:53
America's Got Talent
Рет қаралды 67 МЛН