Skip to content

View Basket

Capital Investment Model Template cover.
  • Capital Investment Model Template cover.
  • ci1_capital_investment_addressable_market
  • ci2_market_reach_customer_forecast
  • An example of calculating Customer Revenue in a Financial Model.
  • ci4_variable_opex_excel_forecast
  • ci5_fixed_resource_plan_excel
  • An example of a Variable Staff Forecast in Excel.
  • ci7_profit_and_loss_example_excel
  • ci8_depreciation_calculation_sumproduct_excel
  • ci9_cash_flow_operations_example_excel
  • An example of Cash Flow from Investment in Excel.
  • ci11_cash_flow_financing_example_excel
  • An example of calculating assets in a Balance Sheet.
  • An example of forecasting Balance Sheetโ€™s liabilities in a Capital Investment Plan.
  • An example of Capital Investment Planโ€™s annual summary.
  • A graph showing annual Revenue, EBITA, Capital Investment and resulting Cumulative Cash Flow.
  • An example of calculating Return on Capital Investment in a Financial Model.
  • An example of using Excel data tables to stress test a Capital Investment Plan.

Capital Investment Model Template

€36.00

20% off with a purchase of two or more templates*

An Excel template with a Capital Investment Model and a monthly Cash Flow Forecast, Headcount and Staff Cost Projections, Debt and Equity Calculations, Balance Sheet, Return on Investment and Sensitivity Analysis.

The file is in Excel format, but you can convert it to Google Sheets using the instructionsย hereย [external link].

Learn More: How to Create a Capital Investment Plan

Order risk-free with a 30-day Money Back Guarantee

Category: Tag:

The Capital Investment Model Template contains the following Excel 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

Related products

*the 20% discount applies to the entire order with a purchase of two or more templates.