Free finance template
Cloud cost model
A price list and a monthly bill on two sheets, with reserved discounts, storage tiers and a CDN, and the cost per order.
It opens with this template loaded and runs in your browser. You don't need an account to use it; a free account saves your work and exports it.
The job it does
For a FinOps review, or before a migration: where the money goes and what each lever saves. It comes with its own checks, so after you change it you can see at a glance that it still does the job.
How to use it with your own data
Put your provider's prices on the Prices sheet and your servers, storage and traffic on the Bill sheet.
What's inside
This is the template exactly as the Finance Lab opens it, read-only. Open it to run it, change it and export it.
- 2 sheets
- 11 formulas
- Exports to Excel, CSV and PDF
The Bill sheet looks each instance type up in the Prices sheet with XLOOKUP. Try the levers a FinOps review would: reserve steady servers, move old files to cold storage, send downloads through the CDN. Watch the cost per order.
- No formula errors anywhere
- Bill!E12 is a formula, not a typed number
- Bill!E14 is a formula, not a typed number
| Number | Value |
|---|---|
| Monthly bill | $12,075 |
| Cost per order | $0.01 |
- API servers reserved: 0% (from 0 to 1)
- API servers: 12 (from 4 to 24)
- Data out via CDN (GB): 0 (from 0 to 60000)
| Row | A | B | C |
|---|---|---|---|
| 1 | Instance type | vCPU | $ per hour |
| 2 | small | 2 | $0.09 |
| 3 | medium | 4 | $0.17 |
| 4 | large | 8 | $0.34 |
| 5 | xlarge | 16 | $0.68 |
| 7 | Storage, $ per GB-month | $0.02 | |
| 8 | Cold storage, $ per GB-month | $0.00 | |
| 9 | Data out, $ per GB | $0.09 | |
| 10 | CDN data out, $ per GB | $0.05 | |
| 11 | Hours in a month | 730 | |
| 12 | Reserved discount | 35% |
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Service | Type | Count | Reserved share | $ per month |
| 2 | API servers | large | 12 | 0% | $2,978 (formula =C2*XLOOKUP(B2,Prices!$A$2:$A$5,Prices!$C$2:$C$5)*Prices!$B$11*(1-D2*Prices!$B$12)) |
| 3 | Background workers | medium | 8 | 0% | $993 (formula =C3*XLOOKUP(B3,Prices!$A$2:$A$5,Prices!$C$2:$C$5)*Prices!$B$11*(1-D3*Prices!$B$12)) |
| 4 | Database | xlarge | 2 | 0% | $993 (formula =C4*XLOOKUP(B4,Prices!$A$2:$A$5,Prices!$C$2:$C$5)*Prices!$B$11*(1-D4*Prices!$B$12)) |
| 5 | Search | large | 3 | 0% | $745 (formula =C5*XLOOKUP(B5,Prices!$A$2:$A$5,Prices!$C$2:$C$5)*Prices!$B$11*(1-D5*Prices!$B$12)) |
| 7 | Hot storage (GB) | 42,000 | $966 (formula =C7*Prices!B7) | ||
| 8 | Cold storage (GB) | 0 | $0 (formula =C8*Prices!B8) | ||
| 9 | Data out direct (GB) | 60,000 | $5,400 (formula =C9*Prices!B9) | ||
| 10 | Data out via CDN (GB) | 0 | $0 (formula =C10*Prices!B10) | ||
| 12 | Monthly bill | $12,075 (formula =SUM(E2:E10)) | |||
| 13 | App orders a month | 1,800,000 | |||
| 14 | Cloud cost per order | $0.01 (formula =E12/E13) | |||
| 15 | Compute share | 47.3% (formula =SUM(E2:E5)/E12) |
The lesson behind it
Learn why it works, with a podcast and a quiz for each lesson.
More finance templates
Pricing calculator
A price from cost and target margin, rounded to .99, with demand that falls as the price rises.
Simple DCF
Five years of free cash flow, a terminal value and the enterprise value.
Monthly budget against actual
Budget, actual and the variance in money and percent per line, which lines are over, and the biggest overrun.