Net worth calculator for calculating personal balance sheets.

Personal Net Worth Calculator
(Balance Sheet Software)
- with -
75-year Net Worth Projector

Download the Free Net Worth Calculator Demo Download the Free Net Worth Projector Demo Net Worth Calculator Directions Balance Sheet Report Explanation
Site Information
(is listed below. The financial planning software modules for sale are on the right-side column)

Read About the Black Friday Week Sale!

Confused? It Makes More Sense if You Start at the Home Page

Price List

How to Buy Money Software

Discounts for Financial Advisers

New Financial Planner Starter Kit

Professional Investment Portfolio Building Kit

Financial Plan Software Support

Financial Planning Software Updates

Site Map

Site Info, History, Ordering Security, Privacy, FAQs

Questions About Creating Net Worth Statements? Call (734) 369-0580 or Send E-mail to support@toolsformoney.com

Free Downloads and Money Tools
(are listed below)

Free How-to Money eBook for DIY Investors, Critical Reading for Financial Advisers, and Many Ancient Financial Myths Finally Exposed

Free Sample Comprehensive Financial Plans

Free Financial Software Downloads, Investing Tips, and Tutorials

List of Free Financial Plan Module Demos

Selected Links to Other Relevant Money Websites

Free Retirement Calculator

Other Free Retirement Calculators

Free 401k Calculator

List of Most All Free 401k Calculators

Free Bond Yield to Maturity Calculator

Our Free Financial Calculators

Other Free Online Financial Calculators

Free Family Money Calculators

Free Real Estate Calculators

Free Debt Calculators

Free Investment Calculators

Free Tax Calculators

Free College Calculators

Free Insurance Calculators

Free Business Owner Calculators

Prices and ordering information are at the bottom

People need to know what they have, how much they owe, and what the difference is. The difference between assets and liabilities is called net worth.

This financial plan software shows both a current snapshot, and a long-term forecast of assets, liabilities, and net worth. It does everything you want, and most everything other net worth software does.

There are two programs: The net worth calculator is for just determining a current net worth snapshot for a family (it only shows inputted values for the current year).

The net worth projector then forecasts everything inputted far into the future.

You can control both asset and liability values down to the dollar in every year. Other financial software may allow control of annual asset values, but not liabilities (because they're usually automatically generated and can't be changed).

You can also use Excel's built-in Goal Seek function to perform any "What If" scenario.

Information about calculating your net worth.

First, the Net Worth Calculator

12-sheet Excel spreadsheet

It calculates overall net worth by listing everyone's assets and liabilities, and then shows all of the differences.

It has a generic input sheet for family and asset class information.

Then it has four input sheets for each type of ownership: Client, spouse, jointly held / community property assets, and children's assets.

Each of these four categories has five input areas, for a total of twenty separate accounts. Each account will handle 25 assets. This sums up to a total of 500 assets that can be input (and then projected).

Each of the twenty accounts can have an associated liability.

It has over a dozen charts for graphically showing all of the pertinent information. The bottom lines are then presented in different formats to show different perspectives.

It has an All Assets sheet showing a top-level view of all assets together. It also has an All Liabilities sheet.

Then it has "drill-down" capabilities, so you can see more and more asset and liability detail, as you look deeper into the reports.

It's formatted to look and feel like financial statements from brokerages, 401ks, and other financial custodians. This makes it easier to input data, keep accounts separate, and to display bottom-lines investors are used to seeing.

You can input asset values from up to twelve past time frames. This calculates percent changes of current values from these past time frames in each asset and each account.

This feature allows you to overcome limitations inherent with brokerage statements that don't include assets not held in the account. For example, if you have a stock account, a rental property, and a bank savings account, the rental and savings account will not appear on the brokerage statement.

With this balance sheet software, you can input all three, their past values, and then it will estimate percentage changes over time that include everything.

They are set up to show monthly changes, but you can use them to show annual changes, or any time frame you want.

If you're interested in this function, then there are two sheets on the TVM financial tools that perform this function better.

It has a result sheet for non-qualified assets and another just showing qualified, to keep them separate.

Both allow you to compare current with prior values. This helps plan which assets, or group of assets, to tap first when retiring.

It lists all assets by asset class with dollar amount breakdowns. It also has a pie chart with asset class percentages for each account. This is shown for each person.

You can ignore all of this by not inputting any of the asset class data, and everything else will work fine.

It has a sheet that shows asset values, tax basis, and estimated after-tax values considering both ordinary income and capital gains taxes.

This is for estimating how much would be left after capital gains taxes if you sell assets. This allows you to see net worth with assets held, then net worth estimates assuming assets are sold.

It has a sheet that breaks out liabilities for each account and family member.

You can modify it any way you want, so results will have the most meaning and print well.

To eliminate duplicate input (data entry), you can integrate and share data between financial plan modules.

The Integrated Financial Planner has the Net Worth Projector hard-wired with the Cash Flow Projector, Dual RWR, Life Insurance Calculator, and the Multiple College Planner to eliminate all duplicate input.

Financial advisors: This is a great tool to get "data confirmation" with clients before spending time working on other modules.

Confirming data helps prevent having to redo everything if there's confusion over assets during financial plan presentation, which is common. You'd run this report first, then send it to the client asking if everything is right. They'll usually send it back with corrections. Then you can continue work on the financial plan without having to worry about redoing things because of a mistake.

The 75-Year Net Worth Projector

19-sheet Excel spreadsheet

The net worth projector just takes the data entered into the net worth calculator, and then automatically forecasts everything up to 75 years into the future. It's the same twelve sheets as the net worth calculator, but with seven more sheets that project asset and liability values.

You can ignore all of the detailed input to keep it simple. Just input global rates of growth into each account used, and then everything is automatic. For more precision, you can also control end-of-year values to the dollar by using the manual overrides.

You can also have different annual rates of growth, or shrinkage, by using the annual rate of return manual overrides for each individual asset.

These allow you to account for any oddball situation that's going to happen in the future, like reverse mortgages, buying new investment assets, depreciation, inheritances, etc.

In addition to everything on the Net Worth Calculator, the Net Worth Projector has:

A Results sheets that shows annual end-of-year values for all twenty accounts for 75 years. This is shown both in table and graphic form.

You can also see annual values for all 500 assets.

Assets are shown by all client's qualified assets, all client's personal assets, then total combined assets. Then the same for the spouse, jointly held assets, and children's assets.

Everyone's assets, liabilities, and net worth are shown on an annual basis individually. Then everyone's combined accounts are summed up, and displayed together to show the family's total assets, liabilities, and net worth.

All twenty accounts have automatic liability generators, and a manual override column for each, so you can input exact amortization schedules from bank loan ledgers.

No balance sheet software calculates liabilities correctly. We looked at all of them to see how they do it, so we could do it the same way, but none did it right. This is because there are too many Real World variables.

We made it so you can just use the automatic liability generators to get close enough (as close as other software).

Then you can manually input every year's estimated ending liability from loan ledgers.

So you can skip these details to keep it simple, or you can control all liabilities to the dollar in every year.

There are many charts and graphs that display annual information in different formats.

You can modify it any way you want, so results will have the most meaning and print well.

You can control the amount of integration with other financial planning software modules. For example, you can use annual asset values from retirement planning software. This will then show net worth after accounting for cash flows that come out of assets that provide retirement income.

This allows you to see net worth grow before retirement and shrink afterwards. This is where you can automatically account for assets paying out retirement income, other withdrawals, and adding contributions to them over time.

To download the demos, right click on a link below, and then choose "Save (Target) As..." to save to your hard drive. Then find it and open with Excel.
Answers to frequently asked demo questions and how to use demos.

Be sure to see the sheet that shows what colors should look like.

Download the non-functional Net Worth Calculator Demo

Download the Net Worth Projector Demo

Then read the instructions and follow along with the demo open

Then download the report explanation text

Financial Planning Software Modules For Sale
(are listed below)

Financial Planning Software that's Fully-Integrated

Retirement Planning Software Menu: Something for Everyone

Comprehensive Asset Allocation Calculator

Asset Allocation Models with Investment Track Record

Monthly Updated Mutual Fund Picks

TVM Financial Tools and Free Financial Calculators

Financial Planning Fact Finders

Investment Policy Statement Software

Bond Calculators for Duration, Convexity, YTM, Accretion, and Amortization

Life Insurance Needs Calculator

Rental Real Estate Analysis Software

College Savings Calculator

Financial Planning Marketing

Free Personal Budget Software and 75-year Cash Flow Projector

Our Unique Financial Services
(are listed below)

Portfolio Benchmarking

Coaching for Financial Planners

Outsource RIA Compliance

Buy or Sell a Financial Planning Practice

Miscellaneous Pages of Interest
(are listed below)

Financial Planning Software Reviews

Using Asset Allocation to Manage Money

Download Brokerage Data into Spreadsheets

About Financial Plan Software Integration

CRM and Portfolio Management Software

About Monte Carlo Simulators

Efficient Frontier Portfolio Optimizers

Calculating Your Investment Risk Tolerance

Discount Brokers for DIY Manage Money Management

About 401(k) Plan Management

About 529 College Plan Investing

LTC Insurance and Software

Buy now with your Visa or MasterCard by calling (734) 369-0580

Buy now using the secure credit card ordering form

Send a check in the mail

Use PayPal

Net Worth Software Prices Unsupported With E-mail Support Phone and E-mail Support
Net Worth Calculator $5 $10 $20
Net Worth Calculator with Asset Fact Finder (for advisors gathering detailed asset data from clients) $7 $12 $22
Net Worth Projector (Net Worth Calculator is included) $11 $21 $40
Net Worth Projector with Asset Fact Finder (for advisors gathering detailed asset data from clients) $13 $23 $42
Lifetime Subscription N/A N/A $90

Copyright 1997 - 2014 Tools For Money, All Rights Reserved