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
Finance spreadsheet 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.
Discounted cash flow (DCF) valuation model
Five-year free cash flow, WACC build-up, terminal value by two methods and a sensitivity grid.
5 tabs · 201 formulas
Investment portfolio tracker
Holdings, cost basis, allocation against target weights, rebalancing amounts and dividend income.
4 tabs · 522 formulas
Loan amortization schedule
Monthly payment, interest and principal for every period of a fixed-rate loan, with optional extra payments.
3 tabs · 3,263 formulas
Monthly profit and loss statement
Twelve months of revenue, cost of goods sold, operating expenses, EBITDA, net income and margins.
2 tabs · 265 formulas