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 М.
Aswath Damodaran - The Value of a User
35:15
Gartner for Marketing
Рет қаралды 97 М.
Дибала против вратаря Легенды
00:33
Mr. Oleynik
Рет қаралды 5 МЛН
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 42 МЛН
Valuation and Simple Discounted Cash Flow
6:12
Peak Frameworks
Рет қаралды 57 М.
A Tesla Revisit: Story Twists and Turns with Value Consequences
40:21
Aswath Damodaran
Рет қаралды 47 М.
Session 1 (Val MBAs): Valuation - Broad Themes and Logistical Details
1:24:30
Valuation in Four Lessons | Aswath Damodaran | Talks at Google
1:01:30
Talks at Google
Рет қаралды 1,6 МЛН
Build A Full Discounted Cash Flow Model for a REAL Company
28:52
Kenji Explains
Рет қаралды 229 М.
How to keep your Accounts using a Spreadsheet [in 2023]
10:52
Mr.SpreadSheet
Рет қаралды 39 М.
AI Winners, Losers and Wannabes: Valuing AI's Boost to NVIDIA's Value!
45:16
The Dark Side of Valuation: India Business Forum
47:52
NYU Stern
Рет қаралды 144 М.
Knowledge Series | Ep 4: Startup Valuation with Aswath Damodaran
1:45:50
I-Venture @ ISB
Рет қаралды 10 М.
Дибала против вратаря Легенды
00:33
Mr. Oleynik
Рет қаралды 5 МЛН