Using the Ginzu Spreadsheet in Valuation

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.e...
Severstal valuation: www.stern.nyu.e...
Ginzu Spreadsheet: www.stern.nyu.e...

[@dineshssairam]

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.

[@matt79de]

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]

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.

[@anurakulatunga2918]

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.

[@abdulazizs2978]

Love and Respect for you Dr.Aswath

[@chrisb481]

Hands down the best there is. Thank you for posting this and walking us through the valuation and the valuation spreadsheet.

[@remotaurog]

Just what I was looking for, great work as always.

[@chandrannatarajan6616]

Thank you Prof. Be blessed always. On my path to learning.🙏

[@MrWspanialy]

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!

[@maxr2663]

The GOAT of valuation

[@alexandergunnar3612]

Superb as always!

[@wm6549]

Thank you so much for this!

[@user-wo6mb5zx5z]

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?

[@andrewnelson9570]

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.

[@ahmadnounou5781]

Absolute legend

[@RobertBeasy]

Outstanding!

[@GarbageGoober.]

How does this spreadsheet account for Capital Expenditures?

[@DK-mu4sq]

Thanks a lot for this content !

[@imzan3650]

Valuation Beast!

[@glenborg7884]

Thank you!

[@chrishuangcfa8797]

Dear professor，should I add NCC(non-cash-charge) back to EBIT when using this FCFF model? thank u

[@basuoo7]

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.

[@feiyuanli2577]

You are the best

[@willem3277]

Legendary.

[@snygarmeister]

Thank You for this exercise!

[@anonym8730]

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?

[@bhavishajain]

Many Thanks Sir!!

[@SM-lt8yr]

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

[@rahulunni2657]

Rock star teacher

[@princesangeluniyal]

Great video as usual. How often do you update industry averages data?

[@mwboy3897]

i wonder too!

[@mergenman7894]

Great

[@billyblack3816]

All the spreadsheets are in view only mode....help?

[@pranavsharma203]

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