Good news. The initial version of my automated DCF Stock Valuation Excel Model is ready for download. Take it for a spin and let me know what you think.
Model Features
- Quickly and accurately calculate the fundamental value of a company’s shares using a discounted cash flow valuation framework
- Automatically download company financial statement data from the internet with the click of a button
- Automatically download current price information and other background information on the company
- Automatically calculate key financial ratios to rapidly analyse recent trends
- Easily measure changes to fundamental value per share by performing sensitivity analysis on key inputs and assumptions
- The model works on most TSX, NYSE & NASDAQ listed companies
Initial Known Issues / Limitations
- Make sure macros are enabled in Excel or else the model will not pull financial data from the internet
- The model will not work on banking and insurance companies (yet).
- The model will not work on companies without at least a 5 year operating history
Instructions on How To Use The Model
I will follow up over the next couple weeks with tutorials on how to use my DCF Stock Valuation Model and provide example valuations on real companies.
Loading ...
Hi Andrew,
I have been using your spreadsheet and its totally awesome. I have found one issue right now. The tax rate is taxed on EBT and not on the revenue.
Vinay
Hi Andrew. Can you also post some information on real companies. Like IBM say as an example because Buffett has recently bought it and he always buys it at less than its intrinsic value
Hi Vinay,
Good catch on the tax rate. I will fix that.
Yes I plan to post some valuations of real companies shortly. Just need to find the time
.
Hey Andrew,
I was searching for a way to automatically download data from the web. Came across your website. The spreadsheet is fantastic. Could you please tell me the source of the data?
Pingback: Stock Valuation - PotashCorp (POT) | MoneyAndWealth