How the model is built
- 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.
- P&L: from revenue to net profit, with margins and a chart.
- 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.
- 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.