The Project Finance Model Template contains the following sheets and sections:
- Project Cash Flow: The spreadsheet shows monthly Revenues and Costs on individual levels and then consolidates the projects into one view. The template also aggregates the output as an annual summary.
- Source of Funding: The model forecasts the contribution of Equity, Debt and Revenues from the existing projects to the overall financing. It also calculates the Returns of the Equity Invested.
- Debt Model: The template contains monthly calculations of principal repayments and interests. The capital expenditure drives the debt amount.
- Sensitivity Analysis with Data Tables: The spreadsheet uses Excel’s data tables to stress-test the model and check the impact of assumptions on the Returns on Investment.
Click on product images for screenshots of the template.
Learn More: How to Create a Project Finance Model in Excel