Building a financial plan
From first revenue to the finished Excel file.
Build a financial planStep by step to a bank-ready financial model.
Excel financial plan templateWhat a bank-ready template must contain and why linked formulas matter.
Cash flow forecast template (Excel)Free 12-month template with formulas, plus a month-by-month guide.
Cash flow statementHow your cash changes: operating, investing and financing.
Key figures
The figures the bank looks at first.
Calculate the DSCRThe key figure in credit checks: does your cash flow cover interest and repayment?
Calculate the equity ratioHow solidly your business is financed and what banks expect.
Calculate EBITDAThe operating earnings figure that banks and investors work with.
Business plan and bank
How the bank reads and what your business plan needs.
Business plan for the bankStructure from the bank's view, debt service calculation and a free Word template.
Financials in a business planWhich plans belong in it and how they fit together.
Financial plan for a loan applicationHow the bank reads your financial plan: debt service, rating, collateral, bank meeting.