Complete Dynamic Excel Model (Costco Wholesale)

Description
This Tool is preapred for the purpose of Fundamental analysis of any company. In this Financial model i have explained what are the key parameter that we need to prime related to company, Industry Demand, and Economic Growth. This model is comprised of 12 tabs.
Dashboard
Income Statement
Balance Sheet
Cash Flow
Ratios Analysis
Common Size Income statement
KPIs
PPE & Debt schedule
Cost of capital
Assumptions (Sales Forecast)
Valuations
Working capital scedule
Workings Extra


This model is not any buy or sell recommendation. But the purpose of this tool is spread financial modelling awareness like how you can preopare a model and what are the forecasting assumptions how we forecast cash flow, balance sheet, income statement. What is FCFF and FCFE how do we calculate.
For valuation purpose i have explained 2  valuation methods. DCF and Residual Value. which is very popular nowadays. With the help of this model you can learn ho to create dashboard, Key Ratios, How to do DCF analysis, How to do sales forecast and much more. You can use any company data and put that into the model for its fundamental analysis.
With the help of this model i wanted to explain the forecasting and valuation assumption which should be reasonable in numbers.
# financial Modelling #intrinsic value