
What it does
Lenders and investors want to see two things: that the money covers the plan, and that the business can carry the payments. This kit connects your assumptions — prices, volumes, costs, equipment, loans and timing — to 24 months of monthly projections so every number traces back to an input you can explain. Start with uses of funds (equipment, start-up costs, opening inventory, a working-capital reserve) against sources (owner cash, investor equity, grants and loans) and see the funding gap or surplus. Loans get a full monthly schedule with principal and interest separated, drawdown month and interest-only months.
- Uses of funds and sources of funds with a funding-gap check
- Up to 5 revenue streams: price, volume, growth, start month, direct cost, capacity cap
- 15 operating-expense lines and 8 one-time start-up costs
- 10 capex items with straight-line depreciation
- 2 loans with drawdown, interest-only months and a monthly amortization schedule
- Collection, payment and inventory timing (working capital)
- Owner equity and withdrawals
- Monthly P&L, cash flow and reconciled balance sheet for 24 months, × 3 scenarios
- Annual Summary with DSCR, lowest cash month and charts
- Print-ready Funding Summary and a document checklist
What's inside
Workbook tabs: Start Here · Assumptions · Revenue · Costs · Capex · Loans · Funding · Monthly – Base · Monthly – Conservative · Monthly – Optimistic · Annual Summary · Funding Summary · Checklist. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- Owners preparing for a bank, credit union or BDC/SBA-program conversation, entrepreneurs planning an expansion, and advisers who want a transparent, editable projection.
Frequently asked questions
Will this get my loan approved?
No spreadsheet can promise that. It helps you present clear, connected assumptions; the lender makes its own decision.
How is DSCR calculated?
EBITDA for the period ÷ (interest + principal paid in the same period). Lenders define it differently, so the guide explains the limits.
Can I use it in the U.S.?
Yes. Enter any currency label; no country tax rules are built in.
Does it work in Google Sheets?
It hasn't been tested there yet. It's built for Microsoft Excel.
You might also like

Service Business Cash Runway Planner
A rolling 13-week cash forecast for consultants, agencies and service businesses. Invoices, payroll, owner draws and bills, week by week, with late-payment and downside scenarios. Excel template with a worked example.

Can I Afford My Next Employee?
Enter pay, your employer costs, one-time hiring costs and a productivity ramp. See the monthly cost, revenue needed, 12-month cash impact and when the hire pays back. Includes scenarios and an employee vs contractor comparison.

Contractor Quote & Bid Pricing Planner
Cost a job line by line, set your price by target margin or markup, see your break-even and discount limit, and print a clean quote for your client. Excel template with a worked example.