MyFinancePlatform Logo
CalculatorsFinancial Plan Template

Financial Plan Template

One integrated workbook for Excel and Google Sheets: cash flow, net worth, dated goals, a retirement glide path, insurance need, asset allocation, and a dashboard that tells you what to fix first.

Build a Financial Plan That Fits on One Page

Why One Workbook Beats Nine Spreadsheets

Most households have the pieces of a plan scattered across files: a budget from January, a net worth tab from a blog, a retirement calculator bookmarked somewhere. None of them talk to each other. Change your retirement age in one and nothing else moves. That is not a plan; it is a pile of estimates.

In this workbook every sheet reads the same profile and assumptions. Raise inflation from 3% to 4% and the future cost of every goal, the retirement corpus, and the dashboard statuses all update. Add a goal and the Insurance sheet picks up its funding gap. Lower your savings capacity and the Goals sheet immediately tells you how far short you are.

Key Insight: A financial plan is a set of trade-offs between goals competing for the same monthly surplus. You can only see the trade-offs when the goals sit in the same file and draw from the same capacity number.

The Order of Operations

The sheets are numbered because each one needs the one before it. Work left to right and the plan builds itself.

  1. Profile. Ages, plan-to age, and assumptions. Be conservative here; every optimistic percent compounds through the whole file.
  2. Cash Flow. Take-home income minus real expenses. The result, your savings capacity, is the single most important number in the workbook.
  3. Net Worth. Today's balances. Retirement accounts become the starting balance for the projection; cash becomes your emergency fund; liabilities feed the life insurance need.
  4. Goals. Name it, date it, cost it in today's dollars. The sheet inflates the cost, grows what you have saved, and solves the monthly contribution for each goal.
  5. Retirement. What you need at retirement net of Social Security, the corpus that supports it, and a year-by-year projection with a declining equity glide path.
  6. Insurance. How much term coverage and how much cash the plan above actually requires to survive a death or a job loss.
  7. Asset Allocation. Your goal horizons imply how much should be in stocks. Compare it to what you hold and rebalance with new money first.
  8. Dashboard. Nine measures, each with a status. Fix anything marked Short first.

How the Sheets Connect

Cash Flow to Goals: savings capacity minus your retirement contribution is the budget the goals compete for. The Goals sheet totals the monthly amount every goal needs and reports Funded or Short by a dollar figure.

Net Worth to Retirement: your retirement account balance is the projection's starting point. The projection applies contributions that grow with your salary, a glide path that lowers equity exposure as you approach retirement, and inflation-adjusted withdrawals afterward.

Goals to Insurance: every unfunded goal gap is added to the life insurance need, because those are the promises a survivor would still want to keep.

Everything to the Dashboard: net worth, savings rate, goal funding, retirement progress, how long the money lasts, life cover gap, emergency fund months, debt-to-asset ratio, and portfolio drift, each scored On track, Attention, or Short.

Pro Strategy: Green cells that start with a formula are defaults pulled from another sheet. Overwrite them when you know better. If retirement spending will be 75% of today's, type it; if you want to exclude the mortgage from the insurance need because the survivor will keep paying it from income, delete it.

How Often to Update It

Quarterly, 15 minutes: refresh Net Worth balances and any Cash Flow lines that changed. Glance at the Dashboard.

Annually, an hour: revisit every assumption, re-cost every goal, update Social Security estimates, and re-check insurance coverage against the new need.

After any major event: a new job, a new child, a move, an inheritance, a divorce, or a market fall of 20% or more. These change the plan, not just the numbers.

Avoid These Costly Mistakes

  • ❌ Using gross pay in Cash Flow (everything downstream will be overstated)
  • ❌ Assuming 10% returns and 2% inflation because the numbers look better
  • ❌ Leaving goals undated; a goal without a year cannot be funded
  • ❌ Counting the home as an investable asset on the Allocation sheet
  • ❌ Ignoring a Short status on the Dashboard because the net worth line looks fine
  • ❌ Treating the projection as a forecast; it is a straight-line estimate, not a market prediction

Your First-Session Action Plan

  1. Download the workbook and read the Start Here sheet
  2. Replace the sample household's green cells with your Profile and Cash Flow
  3. Enter today's balances on Net Worth from your latest statements
  4. Add your real goals with a year and a today's-dollar cost
  5. Pull your Social Security estimate from ssa.gov into the Retirement sheet
  6. Read the Dashboard and pick the single Short item to fix this month

Frequently Asked Questions

Six connected pieces: a cash flow statement, a net worth statement, dated and costed goals, a retirement projection, an insurance and emergency fund review, and a target asset allocation. Most people have one or two of these in separate files. The value comes from linking them, so a change in your savings rate or retirement age flows through to every goal and the dashboard at once.
Yes. Every formula uses functions that Excel and Google Sheets share (PMT, FV, NPER, SUMIF, INDEX and MATCH), with no macros or dynamic arrays. Upload the file to Google Drive and open it with Sheets, or use File, then Import. Formatting, frozen panes, and the pre-filled sample household carry over unchanged.
Do a full pass once a year and a quick net worth and cash flow refresh each quarter. Update it immediately after a major change: a new job, a new child, a move, an inheritance, or a market drop of more than 20%. The Dashboard is built so a 15-minute quarterly update is enough to see whether anything has slipped from On track to Attention.
Yes. Enter your email and the download link opens immediately, with no subscription or trial. It is the same file we use for our own planning walkthroughs. If you want the full set of budgeting, debt, and retirement templates in one download, the Personal Finance Suite bundles them.
Not for the mechanics, but a fee-only planner still earns their fee on tax strategy, equity compensation, business sales, and complex estates. The workbook gives you the numbers an advisor would build first, so a meeting starts at the decisions rather than the data gathering. Bring the Dashboard to the first conversation; it will shorten it.
A budget answers where this month's money went; a financial plan answers whether you will reach your goals and what has to change if not. The Cash Flow sheet here is a budget, but it is one input among nine. The Goals, Retirement, and Dashboard sheets convert that monthly surplus into a funded, dated plan with a status on every line.

Continue Your Financial Journey

📄
Wealth Tracking

Personal Financial Statement Template

A standalone balance sheet and cash flow statement, SBA-form ready

Use Calculator
⏳
Retirement

Retirement Withdrawal Calculator

Stress-test the retirement sheet with Monte Carlo and sequence-of-returns risk

Use Calculator
🎯
Savings

Savings Goal Calculator

Solve a single goal quickly before you add it to the plan

Use Calculator