13-week cash flow template with DSCR for Excel
The FoglioPEF Treasury & DSCR Kit is a macro-free Excel toolkit for small businesses: a rolling 13-week cash flow fed by your receivables and payables schedule, a monthly budget vs actual report, a forward-looking DSCR at 6 and 12 months and a month-end checklist. Price: $49.
$49
When paying by card on Gumroad, EU private customers may have their country's VAT added at checkout by Gumroad.
Secure payment on Gumroad
What a 13-week cash flow is
A week-by-week cash forecast for the next three months, built from the receivables and payables you already have, and rolled forward each week.
How DSCR is calculated
Cash available for debt service divided by debt service (principal plus interest) for the period. Above 1 means forecast cash covers the payments. A figure of 12,000 of cash and 10,000 of payments is a DSCR of 1.2: that is the arithmetic of the ratio, not a lender's threshold.
Sample dashboard
What it does not do
The models are calculation tools: they are not financial, tax or legal advice.
Questions
- How is DSCR calculated?
- Cash available for debt service divided by debt service (principal plus interest) for the period; above 1 means forecast cash covers the payments.