ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Financial model (3 years)
Excel template · Financial model

Financial model template: 3-year forecast

Change the assumptions on revenue growth, margin, expenses, investment and payment terms: the profit and loss, balance sheet and cash flow statements update together.

Updated:
Valtera_Financial_model_EN.xlsx · 19 KB · Sheets: Guide, Assumptions, P&L, Balance sheet, Cash flow
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Financial_model_EN.xlsx — P&L · Preview with sample data
Line item202720282029
Revenue1,200,0001,440,0001,656,000
Cost of sales720,000849,600960,480
Gross profit480,000590,400695,520
Gross margin40.0%41.0%42.0%
Operating expenses240,000262,000284,000
EBITDA240,000328,400411,520
EBITDA margin20.0%22.8%24.9%
Depreciation44,00043,20043,560
Operating profit (EBIT)196,000285,200367,960
Interest expense12,8009,6006,400
Profit before tax183,200275,600361,560
Profit tax36,64055,12072,312
Net profit146,560220,480289,248
Net margin12.2%15.3%17.5%

How the model is built

  1. Assumptions: year 1 revenue, annual growth, cost of goods as a share of revenue, operating expenses, capital expenditure, depreciation rate, receivable/inventory/payable days, tax and loan interest rates, dividend payout and opening balance sheet.
  2. P&L: from revenue to net profit, with margins and a chart.
  3. Balance sheet: receivables, inventory and payables are calculated from payment days, the loan decreases according to its schedule, retained earnings change with net profit and dividends.
  4. Cash flow: indirect method, starting from net profit, then the change in working capital, investing and financing.

The "Check" row on the balance sheet shows 0 every year: assets equal liabilities plus equity. This confirms the model is linked correctly.

Questions the model answers

  • How much cash does growth need? As sales grow, receivables and inventory grow too.
  • Can the loan be repaid? Look at the year-end balance in the cash flow.
  • How much does cutting receivable days from 45 to 35 add to the cash balance?
  • How much can be paid out in dividends?

To assess a project's return: NPV and IRR calculator. For loan payments: loan calculator.

Frequently asked questions

The bank wants a financial model for a loan. Is this template enough?

The template gives you the core structure. Banks usually also ask for a monthly cash flow, collateral and a debt service coverage ratio. Valtera can prepare a bank-ready model with your company's figures.

How do I do scenario analysis?

Make a copy of the file and change the assumptions: for example, base, optimistic (growth +10 percentage points) and pessimistic (growth 0, margin −3 percentage points) scenarios.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.