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

Net Worth Calculator Demo

Net Worth Projector Demo

Program Directions

Report Explanation

Site Information

Read About the Current Sale!

Confused? It Makes Sense If You Start at the Home Page

Why We're Better

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 everything other net worth software does.

There are two programs: The net worth calculator is for determining a current net worth "snapshot" for a family. The net worth projector then forecasts everything far into the future.

It's more precise than any other balance sheet software, because 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. This is because liabilities are usually automatically generated and can't be changed.

First, the Net Worth Calculator

12-sheet, 4Mb, Excel spreadsheet

· It calculates overall net worth by listing everyone's assets and liabilities, and then shows 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 adds up to a total of 500 assets.

Each of the twenty accounts can have an associated liability. This is how things usually work in the Real World. For example, a brokerage account will have only one margin account associated with it, and a 401(k) will have only one loan against it.

· It has over a dozen charts for graphically showing all pertinent information. The bottom lines are 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, 401(k)s, and other financial custodians. This makes it easier to input data, keep accounts separate, and gives bottom-lines people 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, 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.

· 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, and then net worth estimates assuming assets are sold.

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

The 75-Year Net Worth Projector

19-sheet, 10Mb, Excel spreadsheet

This is by far the most comprehensive financial software for taking the current snapshot of a family's net worth, and then projecting everything in detail up to 75 years into the future

· A results sheet 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 on the projection sheets.

· Assets are shown by all client's qualified assets, all client's personal assets, and 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.

To make this the best balance sheet software ever created, we made it so you can just use the automatic liability generators to get close enough (as close as other software). Or you can manually input every year's ending liability from loan ledgers. 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.

To download a non-functional demo, right click on the link below, then choose "Save (Target) As..." to save to a folder on your hard drive. Then open it with MS Excel. Sometimes the WPP's server doesn't work well with weird browsers, or it just may not work if it's not configured right. Plus you won't be able to print well from your browser. Please send e-mail if you have any problems, and it will be sent to you. Answers to frequently asked demo questions, and how to use demos.

Download the 750KB non-functional Net Worth Calculator "demo." The actual program is 3.5MB

Download the 3MB non-functional Net Worth Projector "demo." The actual program is 10MB

Then read the instructions and follow along with the "demo" open

Then download the report explanation text

A free limited-time trial version is available for qualifying financial planners

Fully Integrated Financial Planning Software
 

Services

Fee-only Financial Planning and Investment Consulting for Consumers, Investors, and Financial Planners
 

Building Custom Investment Benchmark Portfolios

Financial Planner Directory

 

How to Become Your Own RIA

 

Coaching for Financial Planners

 

Asset Allocation for 401(k) / 403(b) and Similar Retirement Plans