# Life Care Plan Cost-Projection Worksheet (XLSX) - Free Download

> A cost-projection worksheet for life care planners: one row per item, with frequency, unit cost and duration, and live annual and lifetime totals. Free.

Canonical page: https://medrecords.ai/content-hub/samples/life-care-plan-cost-projection-worksheet/

---
[Content Hub](https://medrecords.ai/content-hub/) › [Samples](https://medrecords.ai/content-hub/samples/) › Templates & tools

Templates & tools

## Life care plan cost-projection worksheet

A blank cost-projection worksheet for a life care plan: one row per recommended item, with its frequency, unit cost, start age, and duration, and formulas that carry each row to an annual and a lifetime figure. Totals recalculate as you edit, so a changed assumption updates the plan instead of forcing a rebuild.

By [Ahmed Jemaa](https://medrecords.ai/authors/ahmed-jemaa/) , Co-Founder & CEO of Medrecords AI · Published 8 Sep 2026

Spreadsheet — Free — Updated 2026-09-08

### What’s inside

- One row per recommended item, grouped by the standard cost categories
- Frequency, unit cost, start age, and duration as separate inputs you control
- Annual and lifetime columns computed by formula, never typed in
- A category subtotal block and a plan total that recalculate as you edit
- A source column, so every unit cost carries where the figure came from

Built for Life care planners. Every line traces to [Life care plan deliverable](https://medrecords.ai/deliverables/life-care-plan/) , which is published in full on this site, so you can check the tool against the reasoning behind it.

[Download the worksheet ](https://medrecords.ai/assets/lead-magnets/medrecords-life-care-plan-cost-worksheet.xlsx)
XLSX · opens in Excel, Sheets, Numbers

Spreadsheet

### What the file contains

A blank working file. It states no case data and no cost of its own. Built on [Life care plan deliverable](https://medrecords.ai/deliverables/life-care-plan/) .

#### How the sheet is wired

| Blue cells | Yours to fill. Category, item, times per year, unit cost, start age, end age, source. |
| --- | --- |
| Years | Formula: end age minus start age, plus one. Leave both ages blank for a one-off item. |
| Annual cost | Formula: times per year multiplied by unit cost. |
| Lifetime cost | Formula: annual cost multiplied by years. |
| Source / basis | Where the unit cost came from. An uncited cost is the first one challenged. |
| Subtotals | SUMIF over the category column, so a row moves to a new subtotal when you retype its category. |
| What this does not do | It supplies no cost, no duration and no life expectancy. Those are your professional judgment. |

**** **** **** **** **** **** ****
Categories come as a dropdown: medications, therapy and rehabilitation, physician and follow-up care, equipment and supplies, attendant and home care, diagnostics and imaging, surgical and procedural, home and vehicle modification, plus a free row for your own. Subtotals are SUMIF formulas over that column, so retyping a category moves the row to a different subtotal without touching anything else.

### Sources

Nothing in this tool is invented. Every line traces to a page published in full on this site, verified 2026-09-08.

- [Life care plan deliverable](https://medrecords.ai/deliverables/life-care-plan/) — https://medrecords.ai/deliverables/life-care-plan/

### Common questions

#### Does the worksheet supply any costs?

No. It supplies structure and formulas. Every unit cost, duration and life expectancy is yours to research, enter and defend, which is the judgment you are retained for.

#### What does it calculate?

Years from the start and end ages, annual cost from frequency and unit cost, and lifetime cost from the two. Category subtotals and a plan total recalculate as you edit.

#### Can I change the categories?

Yes. They come as a dropdown built on the recurring-care categories we name on the life care plan page, and the subtotals are SUMIF formulas over that column, so your own category names work as soon as you type them.

### How Medrecords AI does this work

The tool above is yours to run by hand. This is what the software does with the same file.

[Product — **Medical Chronology** — The medical timeline that builds itself, synced to every source page. Read more →](https://medrecords.ai/product/chronology/?src=content-hub-samples-life-care-plan-cost-projection-worksheet) [Product — **Verifiable AI citations** — If we can't cite it, we don't say it. Click any line to its source. Read more →](https://medrecords.ai/product/citations/?src=content-hub-samples-life-care-plan-cost-projection-worksheet) [Guide — **Life care plan deliverable** — The published guide every line of this tool was drawn from. Read more →](https://medrecords.ai/deliverables/life-care-plan/)
Test it on a file you already have.
Send one real record set. You get back a cited chronology and decide for yourself whether the read holds up.
[Test a file](https://medrecords.ai/test-a-file/?src=content-hub-samples-life-care-plan-cost-projection-worksheet) [Book a demo](https://medrecords.ai/demo/?src=content-hub-samples-life-care-plan-cost-projection-worksheet)

### More from Templates & tools

[Fillable Medical Chronology Template](https://medrecords.ai/content-hub/samples/medical-chronology-template/) [IME Report Red-Flag Checklist](https://medrecords.ai/content-hub/samples/ime-report-red-flag-checklist/) [HIPAA Vendor Intake Checklist](https://medrecords.ai/content-hub/samples/hipaa-vendor-intake-checklist/) [Workers' Comp IME Prep Checklist](https://medrecords.ai/content-hub/samples/workers-comp-ime-prep-checklist/) [The Chronology Bench Rubric](https://medrecords.ai/content-hub/samples/chronology-bench-rubric/) [Medical Record Review Cost Calculator](https://medrecords.ai/content-hub/samples/medical-record-review-cost-calculator/)
Last verified: 2026-09-08 · [← All samples and tools](https://medrecords.ai/content-hub/samples/)