ECO NOVA

Financial Projections Template - 5-Year Forecast

Instructions for Completing Financial Projections

  1. All figures should be in USD (United States Dollars)
  2. Enter data in the white input cells only
  3. Gray cells contain formulas and will calculate automatically
  4. Provide conservative, realistic projections based on market research
  5. Include detailed assumptions for all major line items
  6. Ensure consistency between revenue projections and capacity/market analysis

1. Revenue Projections

Revenue Stream Year 1 Year 2 Year 3 Year 4 Year 5
Product/Service Revenue 1
Product/Service Revenue 2
Product/Service Revenue 3
Other Revenue
TOTAL REVENUE SUM SUM SUM SUM SUM

2. Operating Expenses

Expense Category Year 1 Year 2 Year 3 Year 4 Year 5
Direct Costs / Cost of Goods Sold
Raw Materials
Direct Labor
Manufacturing Overhead
Operating Expenses
Salaries & Wages
Rent & Utilities
Marketing & Sales
Administrative Expenses
Insurance
Depreciation
Other Operating Expenses
TOTAL EXPENSES SUM SUM SUM SUM SUM

3. Profitability Analysis

Metric Year 1 Year 2 Year 3 Year 4 Year 5
Gross Profit AUTO AUTO AUTO AUTO AUTO
Operating Profit (EBITDA) AUTO AUTO AUTO AUTO AUTO
Interest Expense
Tax (estimated)
NET PROFIT AUTO AUTO AUTO AUTO AUTO
Net Profit Margin % AUTO AUTO AUTO AUTO AUTO

4. Cash Flow Projections

Cash Flow Item Year 1 Year 2 Year 3 Year 4 Year 5
Operating Activities
Net Income AUTO AUTO AUTO AUTO AUTO
Add: Depreciation AUTO AUTO AUTO AUTO AUTO
Changes in Working Capital
Investing Activities
Capital Expenditures
Financing Activities
Loan Proceeds
Loan Repayments
NET CASH FLOW AUTO AUTO AUTO AUTO AUTO
CUMULATIVE CASH FLOW AUTO AUTO AUTO AUTO AUTO

5. Key Assumptions

Please provide detailed assumptions for your projections:

6. Investment Return Metrics

Metric Value Notes
Internal Rate of Return (IRR) Target minimum 15%
Net Present Value (NPV) @ 10% Should be positive
Payback Period Years to recover investment
Return on Investment (ROI) Total return over project life
Debt Service Coverage Ratio Minimum 1.25x required

This is a web-based template for viewing. For actual use, please download the Excel version.

Certification

I certify that the financial projections presented above have been prepared based on reasonable assumptions and represent our best estimate of future financial performance. All figures are in USD and have been reviewed by our financial team.

Prepared by:

Reviewed by: