A twelve-month financing plan with cash-flow forecast, financing mix and an early-warning dashboard
Combine capital needs, a financing mix of equity, loan, leasing and overdraft, a monthly cash-flow forecast with debt service and a six-indicator early-warning dashboard into one written plan you can show a bank and review every month.
What you will learn
- How to structure a twelve-month financing plan: uses, sources, monthly cash flow, dashboard.
- How to size each financing instrument and match it to the asset it funds.
- How to calculate the annuity, interest split and debt service coverage ratio a bank looks at.
- How to set six early-warning indicators with green, amber and red thresholds.
Explanation
The twelve-month financing plan puts this course into one document you update monthly. It has four parts.
1. Uses of funds (lesson 1's Kapitalbedarfsplan): investments, start-up costs, working capital (revenue per day × planned CCC, lesson 9) and a liquidity reserve. 2. Sources, following the matching rule: long-lived assets financed long-term (equity, investment loan, leasing), fluctuating working capital short-term (overdraft, factoring), the reserve by own cash or a committed undrawn line. Target an equity share of at least 20 to 30 percent; banks and public programmes (lessons 3 and 4) expect it. 3. Monthly cash-flow forecast for twelve months, built like lesson 8's but in monthly buckets, including loan instalments, leasing rates and tax dates. 4. Early-warning dashboard: a few indicators with thresholds, reviewed on a fixed monthly date.
Two figures matter to lenders. The annuity of a loan with annual payments is A = P × r ÷ (1 − (1 + r)^(−n)), where P is principal, r the rate and n the years; each payment splits into interest (balance × r) and repayment (A − interest). The debt service coverage ratio (DSCR) = operating cash flow before interest and repayments ÷ (interest + repayments) for the year. Below 1 the business cannot pay its loans from operations; banks typically want at least 1.2 to 1.3 in a plan.
Six indicators are enough for most small businesses:
| Indicator | Green | Amber | Red |
|---|---|---|---|
| Cash runway (cash + undrawn line, in months of fixed costs) | > 3 months | 1.5–3 | < 1.5 |
| Overdraft utilisation (average drawn ÷ limit) | < 50 % | 50–80 % | > 80 % or limit hit |
| DSO versus payment terms | ≤ terms + 7 days | +8 to +20 | > +20 days |
| Overdue receivables share (over 30 days ÷ total) | < 10 % | 10–20 % | > 20 % |
| Liquidität 2. Grades | ≥ 1.2 | 1.0–1.2 | < 1.0 |
| Forecast accuracy (actual vs forecast receipts) | within ±10 % | −10 to −20 % | worse than −20 % |
Each amber triggers a defined action (chase the ageing list, delay a purchase, talk to the bank); each red triggers the liquidity test of lesson 11 and a call to the Steuerberater. Adapt the thresholds to your business and write down why.
Worked example
Hypothetical example: a founder opens a small workshop. Uses: equipment €50,000, start-up costs €15,000, working capital €35,000, reserve €20,000 = €120,000. Sources: own funds €40,000; an investment loan of €60,000 at a hypothetical 5 percent fixed, five years, annual instalments; leasing for €20,000 of the equipment (48 months at €396 per month, so not a cash use); plus a committed, undrawn overdraft line of €20,000 as second reserve. Cash uses and sources are both €100,000; equity share 40 percent. Fees, taxes and leasing deposits are ignored.
Annuity: A = 60,000 × 0.05 ÷ (1 − 1.05^(−5)) = €13,858 per year. Year 1 interest = €60,000 × 0.05 = €3,000, repayment €10,858, balance €49,142. Year 2: interest €2,457, repayment €11,401, balance €37,740.
The forecast shows operating cash flow before debt service of €24,000 (after owner salary and taxes); the lease rates of €4,752 per year are inside operating costs. DSCR = €24,000 ÷ €13,858 = 1.73. Including the lease gives €24,000 ÷ (€13,858 + €4,752) = 1.29, acceptable but thin: a 25 percent drop in cash flow pushes it below 1.
Dashboard at month 6: cash €26,000 plus undrawn line €20,000 against fixed costs of €14,000 per month = runway 3.3 months (green); overdraft 0 percent (green); DSO 41 days against 30-day terms (amber); overdue share 12 percent (amber); Liquidität 2. Grades 1.4 (green); receipts 8 percent below forecast (green). Two ambers, one cause: apply lesson 9's dunning calendar, not new borrowing.
Common mistake
Practice activity
On paper: a café needs €80,000 (fit-out €45,000, equipment €20,000, working capital €10,000, reserve €5,000). The owner has €20,000 and is offered a €50,000 loan at a hypothetical 6 percent, five years, annual instalments, plus a €10,000 overdraft line. Planned operating cash flow before debt service is €15,000 in year 1. (a) Calculate the equity share of the cash uses. (b) Calculate the annuity and year 1 interest. (c) Calculate the DSCR and judge it. (d) Name one change that improves the ratio without new revenue.
Show solution
(a) €20,000 ÷ €80,000 = 25 percent equity; sources total €70,000, so €10,000 of the uses would sit on the overdraft, a structural weakness.
(b) A = 50,000 × 0.06 ÷ (1 − 1.06^(−5)) = 50,000 × 0.06 ÷ 0.25274 = €11,870 (rounded). Year 1 interest = €3,000; repayment €8,870.
(c) DSCR = €15,000 ÷ €11,870 = 1.26. Borderline: just above 1.2, no room for a weak year, and €10,000 of fixed uses on the overdraft.
(d) Lease the €20,000 of equipment over 48 months (about €4,800 per year in operating costs) and cut the loan to €30,000: annuity about €7,122, DSCR = (€15,000 − €4,800) ÷ €7,122 = 1.43, and the €10,000 gap disappears. Alternatively ask for a repayment-free first year.
Limitations: ignores fees, Disagio, taxes, café seasonality and the bank's rating rules; have a Steuerberater or financing adviser review the plan before submitting it.
Key takeaways
- Write the plan: uses, matched sources, twelve monthly cash flows, dashboard.
- Aim for 20 to 30 percent equity or more; keep the overdraft for peaks and a reserve, not for assets.
- Know your annuity and DSCR before the bank asks; plan for above 1.2 to 1.3 with a buffer.
- Six indicators with thresholds, reviewed monthly, catch problems while there are still solutions.
Next step
This completes "Financing & Cash Management for Small Businesses"; to understand how financial markets work from the trader's side, continue with the course "Trading Foundations".
Self-check
Answer the questions, then check your answers. You can retry as often as you like.
Automatic self-check for your own revision. Your answers are checked in your browser and are not seen or assessed by us. It is not an exam and not a qualification.
Your progress
“Complete” only means you marked the lesson as done. It is not a test of your understanding. Progress and notes are saved only in this browser on this device — not in an account.