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.

TemplateFinance

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

TemplateFinance

Break-even analysis calculator

Compare product prices, variable costs, fixed costs, and the units needed to cover those fixed costs.

2 tabs · 246 formulas

TemplateFinance

Cash conversion cycle worksheet

Calculate inventory days, receivable days, payable days, and the cash conversion cycle from consistent period totals.

2 tabs · 306 formulas

TemplateFinance

Debt service coverage ratio calculator

Compare net operating income with annual principal and interest obligations to measure debt service coverage and cash cushion.

2 tabs · 306 formulas

TemplateFinance

Fixed-rate loan comparison

Compare monthly payments and total interest across fixed-rate loan offers with different rates, terms, and upfront fees.

2 tabs · 246 formulas

TemplateFinance

Investment portfolio tracker

Holdings, cost basis, allocation against target weights, rebalancing amounts and dividend income.

4 tabs · 522 formulas

TemplateFinance

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

TemplateFinance

Monthly profit and loss statement

Twelve months of revenue, cost of goods sold, operating expenses, EBITDA, net income and margins.

2 tabs · 265 formulas

TemplateFinance

Project profitability tracker

Compare project revenue with direct labor, materials, and allocated overhead to estimate contribution and margin.

2 tabs · 246 formulas

TemplateFinance

Startup cash runway planner

Estimate monthly net cash burn and cash runway for operating scenarios with specified cash, receipts, and payments.

2 tabs · 246 formulas