Skip to content
Planvik
Back to Knowledge

Build a financial plan

What a bank-ready financial plan consists of

A financial plan consists of several connected components, each on its own, cleanly linked sheet:

Three to five plan years are usual, the first year month by month, plus two to three completed actual years as a basis for comparison. The linked sheets produce the key figures the bank measures the plan against.

The foundation: the assumptions sheet

Every good financial plan starts with an assumptions sheet. It holds all the values you can change: the revenue drivers (prices, volumes, growth), the cost drivers (materials ratio, salaries and staffing needs, fixed costs) and the financial assumptions (interest rate, payment terms, tax rate). All other sheets calculate exclusively from this one sheet.

This cleanly separates what is input from what is calculated from it. And you see the levers at a glance: change one assumption and the effect runs through the whole model.

The mechanics: three linked statements

The projected P&L shows performance, the cash flow statement the real flow of money and the projected balance sheet the stock of assets and capital. The flow is always the same: revenue minus costs gives the result in the P&L. This result flows into the cash flow, adjusted for depreciation and changes in working capital. Cash flow and result change the balance sheet, that is equity, cash and debt. In the end the balance sheet has to balance: assets equal liabilities and equity. If it does not balance, there is an error in the model.

The often underestimated lever is working capital. If you sell on invoice, the revenue is in the P&L, but the money only arrives when the customer pays. As the business grows, rising receivables and inventories continuously tie up capital, while supplier payment terms release part of it. These changes adjust the result to the real cash flow, and you control their size through the payment terms in the assumptions. A plan that ignores this shows profits and still an empty bank account.

Getting this linkage stable is the hard part, especially in Excel, where it depends on hundreds of formulas across several sheets.

The model without Excel tinkering

You fill in guided inputs, Planvik links the P&L, cash flow statement and balance sheet, and the balance sheet balances by design. A bank-ready Excel file in about 15 minutes.

Create your financial plan

Principles for a clean model

Above everything stands traceability: every reviewer, and you yourself after a few weeks, must be able to follow every number in one step. Nested formulas like this one are the opposite:

=IF(B4>0,VLOOKUP(B4,Assumptions!A:F,IF(D4="A",4,5),0)*(1+B7)^E4,0)

It is better to spread the logic across named intermediate steps until a cell reads only =BasePrice * GrowthFactor. In practice, clean modelling means:

Step by step to the finished plan

  1. Record the starting position. For an existing business, the latest balance sheet with equity, assets and current loans; for a start-up, the equity contributed. The projected balance sheet builds on this.
  2. Collect all assumptions. Revenue drivers, cost drivers and financial assumptions on one sheet. Later, these are the only values you touch.
  3. Build up revenue. Bottom-up from price and volume per product, with growth and seasonality. That way every revenue figure can be traced back to a driver.
  4. Plan costs and staff. Derive variable costs from revenue, plan staff by role including employer payroll costs, and set fixed costs such as rent, marketing and IT.
  5. Add investments and financing. Purchases with their depreciation, and the financing from equity, public funding and loans, including the repayment schedule.
  6. Link the three statements. The result flows into the cash flow and from there into the balance sheet. This linkage is what turns separate tables into a model.
  7. Check and iterate. Review the balance sheet check, read off the key figures, calculate a conservative case. Whatever looks implausible, you correct in the assumption, not in the formula.

Checklist before you submit

How to calculate the central key figures and which values are expected is explained in the guides on DSCR, equity ratio and EBITDA.

Frequently asked questions

Excel or a tool: what should I build the plan with?

Excel gives you maximum freedom, but it takes time and is prone to errors when linking the statements. A tool like Planvik delivers the same bank-ready model in about 15 minutes, as an open xlsx file.

Do I need accounting knowledge?

To build it by hand, a basic understanding of the P&L, cash flow and balance sheet helps. With a guided tool, your business figures are enough.

How long does a financial plan take?

By hand in Excel, easily several days; with a guided tool, about 15 minutes for the first version.

How often should I update the plan?

At least once a year, and whenever an important assumption changes, such as the interest rate, prices or a larger order.

Should I plan bottom-up or top-down?

Bottom-up is the standard banks expect: revenue from price times volume per product, costs from concrete drivers. A top-down plan based on market size times a hoped-for market share quickly looks like guesswork and rarely survives critical questions.