13-week cash flow forecast
Weekly receipts and disbursements for one quarter, with a revolver that draws and repays and a variance tab.
3 tabs · 498 formulas
Templates
Financial models built the way analysts build them: inputs kept apart from calculations, consistent signs, no hard-coded numbers hidden inside formulas. Loan schedules use PMT, IPMT and PPMT; the DCF model discounts explicit free cash flows and a terminal value; the 13-week cash flow rolls an opening balance forward week by week.
All figures in the templates are example data. Replace them with your own and the whole model updates.
Weekly receipts and disbursements for one quarter, with a revolver that draws and repays and a variance tab.
3 tabs · 498 formulas
Compare product prices, variable costs, fixed costs, and the units needed to cover those fixed costs.
2 tabs · 246 formulas
Calculate inventory days, receivable days, payable days, and the cash conversion cycle from consistent period totals.
2 tabs · 306 formulas
Estimate monthly gross profit per customer, customer lifetime value, LTV-to-CAC ratio, and payback period by segment.
2 tabs · 306 formulas
Compare net operating income with annual principal and interest obligations to measure debt service coverage and cash cushion.
2 tabs · 306 formulas
Five-year free cash flow, WACC build-up, terminal value by two methods and a sensitivity grid.
5 tabs · 201 formulas
Compare monthly payments and total interest across fixed-rate loan offers with different rates, terms, and upfront fees.
2 tabs · 246 formulas
Holdings, cost basis, allocation against target weights, rebalancing amounts and dividend income.
4 tabs · 522 formulas
Monthly payment, interest and principal for every period of a fixed-rate loan, with optional extra payments.
3 tabs · 3,263 formulas
Twelve months of revenue, cost of goods sold, operating expenses, EBITDA, net income and margins.
2 tabs · 265 formulas
Set a selling price from unit cost and target gross margin, then compare markup with margin.
2 tabs · 246 formulas
Compare project revenue with direct labor, materials, and allocated overhead to estimate contribution and margin.
2 tabs · 246 formulas
Year-by-year balance from saving to retirement and withdrawals, with five return and saving scenarios.
5 tabs · 2,613 formulas
Estimate monthly net cash burn and cash runway for operating scenarios with specified cash, receipts, and payments.
2 tabs · 246 formulas
Calculate current assets, net working capital, current ratio, and quick ratio across periods or operating units.
2 tabs · 306 formulas