The Capital Investment Model Template contains the following sheets and sections:
- Financial Model: The Template forecasts monthly Cash Flow and includes Addressable Market and Customer Reach calculations. It also details Headcount numbers by role and links them to average salary inputs to calculate the overall Staff Cost.
- Profit & Loss, Cash Flow and Balance Sheet: The model breaks down the annual Net Income, Assets, and Liabilities. It splits the Cash Flow into Operating, Investing and Financing sections.
- Return on Investment and Sensitivity Analysis: The Template uses EBITDA multiplier to calculate the Terminal Value and its impact on the Equity Returns. It uses Excel’s Data Tables to test the effect of the assumptions on the model’s output.
Click on product images for screenshots of the template.
Learn More: How to Create a Capital Investment Plan in Excel