Построение финансовой модели стартапа

Business: any sector you wish - bookstore, oil company, online shop of candles, etc. You can take existing business, but I advise to take a start up with initial investments (CAPEX).

Financial model (Excel)

1. View – readable and comfortable for the new model user to understand, no extra zeros in the cells!!! – show in thousands, millions, etc.

2. Assumptions (the most important point)

a. Structure – logical, not too simple and not too complicated

b. Logic of assumptions – logical and sources

c. Sources – for the most important assumptions (prices, technical/production data, macro forecasts, currency rate, etc)

3. Math – calculations

4. Scenarios – basic (conservative) & pessimistic (very conservative)

5. Sensitivity – 2-parameters sensitivity analysis, NPV & IRR (both to equity), two tables for the each scenario

6. Summary (1st sheet) – table with all the major measures (Sales, EBITDA, Net income, FCFE, FCFF, CAPEX, Debt, Equity, etc.)

Presentation (for two scenarios!)

1. Brief description of business (product, place, production/service main figures, and results - NPV (equity), IRR (firm, equity), etc)

2. The most important assumptions only! (1-2 slides)

3. Financial/production measures summary – table with all the major measures (Sales, EBITDA, Net income, FCFE, FCFF, CAPEX, Debt, Equity, etc.) (one slide for each scenario).

4. Sensitivity analysis (one slide for two scenarios, four tables in total - IRR (equity), NPV (equity)