Time Value of Money Financial Tools
|Financial Calculators Demo||Personal Finance Software Directions|
(is listed below. The financial planning software modules for sale are on the right-side column)
Confused? It Makes More Sense if You Start at the Home Page
Discounts for Financial Advisers
Questions about Personal Finance Software? Call (503) 309-1369 or Send E-mail to firstname.lastname@example.org
Free Downloads and Money Tools
|Price and ordering information are at the bottom
These financial tools are on a 23-sheet Excel workbook. So you'll get all of them on one spreadsheet when you order it, not just select sheets or money calculators.
It has most all of the usual time value of money calculators that free online financial calculator websites have.
It also has several sheets with most all of the smaller financial tools needed when professional financial planners create personal financial plans for their clients.
There are also several money tools for financial planning practice management.
What It Has:
TVM Calculators and Financial Calculators
Most of what's available on free financial calculator websites is on this sheet, so you use them offline.
It has all of the usual time value of money calculators: Present value, future value, payments, number of compounding periods, interest rate, monthly loan amortizer, net present value, life expectancy, estimated capital needed vs. weekly income needs, gross wage calculators, human life value, final expenses calculator, tax-free yield converter, CD early withdrawal penalty calculators, percent change calculators, fixed annuity income eroder, calculate the true yield of a fixed annuity, rule of 72 calculator, a driving time calculator, and more.
360-Cash Flow IRR Calculator
Calculate internal rate of return to five decimal places based on a series of up to 360-cash flow periods.
This is used for determining an overall rate of return on an investment with unequal cash flows.
It has a column where you’d enter cash flow dates and then it gives the bottom-line rate of return results as is, and also compounded annually.
Compound and Simple Interest Rate Comparators
Compare the growth (or shrinkage) of money given three different compound annual interest rates.
It has an additional column for calculating simple interest; and another is a compound interest rate column that has a year-by-year manual override (so you can have a different rate of return every year).
You can also add new money every year.
It has two graphs.
Compound Interest Rate Converter
This calculates differences in periodic interest rates given different compounding periods. It displays a total of 15 interest rates given one input.
This is most useful when taking out bank loans and you want to ensure they're not trying to pull any shenanigans by putting compounding periods less than annual into your contract. So if you think you're getting a loan at 10% APR, then your contract fresh off the printer ends up saying 2.5% quarterly the moment before you sign it, then you're getting ripped off, because 2.5% compounded quarterly is really 10.4% APR. This banking scam happens thousands of times every day.
Long-term Cost of having a "Family Ruining Monster" in Your Household
Financial advisers can use this money calculator to "find hidden money to invest," when the family budget says there's plenty of money (but everyone knows there's really not).
After doing a detailed family budget, if it doesn't match reality by never adding up right, then this is usually the reason why. The family-ruining monster just "forgot" to account for their habits.
Most everyone has a "family-ruining monster" in their home. You know, the one that won't quit smoking, drinking, gambling, buying useless trinkets, the list goes on. We have one too. Her response to the decades-long whining about the $10 a day on cigarettes, $10 spent a day on Keno, and $25 per week on useless trinkets is, "Oh shuuuuut uuuuup! It's only a few bucks here and there! Leave me alone!!!"
Well, these $700 a month habits add up to major bucks over time - enough to make or break a family, prevent kids from going to college, and enough to fund retirement.
This money tool does the job quickly and easily. Now you can prove the true long-term costs of your family-ruining monster to them, to try to get them to change their habits.
It has 20 graphs to show the actual long-term impacts in several different ways.
Input basic life expenses and see how much a child will cost each year, total for each expense category, grand total, and net present value (for each expense category and grand total NPV).
The grand total net present value number displays how much money it would cost today to fully fund a new child. It's usually much more than you think.
Consumer Price Index (AKA CPI) Price Calculator
This cost of living inflation calculator works on a monthly basis and uses raw data from the Department of Labor.
You can input things like old DJIA record highs, so you can see what it would need to be today to be at a real actual inflation-adjusted record high.
With just three inputs, you can see pretty much anything adjusted for inflation over any monthly time frame.
Financial Planning Practice Valuation Calculator
This financial calculator covers most of the bases when you want to estimate how much you may be able to sell your financial advisory practice for today - without having to either do massive amounts of research, or hire an expensive firm that specializes in this market.
You'd just input estimates of your gross incomes, how these will change in the future, how much of a selling-out haircut you'll take; and then input an estimated range of multipliers, and it shows you the bottom-line valuation.
25-Year Dollar-Weighted Rate of Return Calculator
This is a simple, but comprehensive, investment portfolio IRR calculator that shows the rate of return each year, and averages for multiple years - considering all of the unequal monthly cash flows that happen in the Real World: Dividends, capital gains, spent withdrawals, taxes on them, and contributions.
All that's needed is to input end-of-month account values and how much money went in and out of the accounts.
It uses the dollar-weighted rate of return methodology (AKA internal rate of return, or IRR) and then displays pre-tax and after-tax IRRs for all 25 years.
You can change each tax rate every year, and have different tax rates for each type of distribution.
This financial tool will also calculate investment returns for liquidated investments, so you can determine IRR since you bought them years ago.
It also adds up all of the monthly cash flows so you can see what the annual totals are.
It's useful for tracking one mutual fund, or complex portfolios from numerous accounts / brokers. It works well for investors that just want to input data from their multiple monthly statements, and see an estimate of how well all of their investments have done combined.
This financial spreadsheet uses the same concepts and has the same features as the previous sheet, but using the time-weighted rate of return methodology.
The time-weighted rate of return method of calculating investment returns is the most accurate because it ignores the distorting effects of portfolio cash flows (contributions and withdrawals). So it's also the most accurate way to compare the performance of investment managers apples-to-apples. This methodology is used in the CFA Compliant Performance Presentation Standards and all of the expensive portfolio management software programs (e.g., Axys Advent).
It works on a monthly basis, so it's not as accurate as expensive portfolio management software, which accounts for and compounds cash flows daily. You'd have to input portfolio values and cash flows every day, and most investors don't have this data available anyway.
It works well for investors that want to just input data from their multiple monthly statements, and then see how everything has done combined.
The only other way to do this with any accuracy is to buy portfolio management software, which costs several thousand a year (or you could spend 100+ hours making a similar financial spreadsheet).
We have yet to see any money calculator that performs this function in between this and actual portfolio management software (so your choice is a few bucks, Do-It-Yourself, or spend thousands annually).
Investment Management Fee Calculators for Investment Advisors, with Performance Fees
This is not for consumers or investors (unless you want to audit your money adviser).
These money manager fee calculators are the same as the previous sheets, but have the additional feature of being able to calculate investment management performance fees.
These are basically additional rewards for money managers when the investment portfolio performs above and beyond a certain previously-agreed upon level.
Just input a High-water Mark (how much the account has to grow before performance fees start to apply), then a Hurdle Rate (how much as a percent the amount above the High-water Mark has to be before performance fees apply), and then the amount of performance fees.
It then calculates how much the advisor charges the client, both for regular investment management fees and the additional performance fees.
Investment Management Fee Calculators for Investment Advisors
This is not for consumers or investors (unless you want to audit your adviser).
These money tools help investment advisors working on a fee basis, calculate how much to charge their clients to get paid.
Some investment advisors have to manually tell their custodian how much in fees to deduct from client cash accounts, so they can get this amount paid to them on a periodic basis (usually monthly). This money tool will do that quickly and easily.
Just input your breakpoints, fees, and account values and it totals everything up and displays the bottom-line amount you're looking for (annually, quarterly, monthly, weekly, and daily), on a client-by-client basis, for up to 500 clients.
Then it totals everything, so you can see how much you're making (or estimate how much you will or could be making).
It has five, four, three, and two tier schedules for advisers with sliding scales.
It has input fields for names, account numbers, and account values. Here you can just reference this data from another source once, then everything will be semi-automatic from then on when you do your downloads.
If you have to do this manually, then this will save you time, and will more than pay for itself the first time you use it.
Inflation Adjusted Income Stream Generator
This financial spreadsheet is a unique money tool created out of necessity. It's the same thing as payout method #3 on sheet #10 on the current RWR retirement software demo, but stand-alone.
This retirement withdrawal calculation method automatically answers the question, "What's the most retirement withdrawal I can take out of this investment every year, have this retirement income stream keep up with inflation every year, and have it last until I'm 100 years old?"
You'd just input the year it starts to pay out, a life expectancy age, an inflation rate, an assumed rate of return, and it automatically figures out the payments.
So if you have an investment account that needs to last until a certain age, then this will estimate how much you can safely withdraw annually, given those three assumptions (rate of return, inflation, and ending age).
You can also adjust the inflation rate up to account for an average tax rate (if you want to see the payments gross of taxes).
Portfolio Yield and Paycheck Calculator
For up to 100 investments, it calculates: The income / dividend yield on each investment; how much income the total portfolio will produce on a daily, weekly, monthly, semi-annual, and annual basis; the overall annual portfolio yield, and how much as a percent each investment is of the total portfolio.
So it basically allows you to input all of your investments, then estimate how much paycheck everything will produce when combined.
Customers have said they found this financial tool to be sufficient to model bond ladders and bond laddering strategies.
Age 70½ IRS Required Minimum Distribution Calculators
If you have an IRA, or similar tax-qualified retirement plan, where you were able to get tax deductions when you contributed money into the plan, then the IRS wants you to pay those tax savings back when you liquidate.
Some investors let their IRA's grow without taking any withdrawals from them, hoping to escape this taxation forever. So the IRS requires investors to start taking distributions in the year they turn 70½.
All of the amounts distributed are then usually subject to ordinary income tax rates. Investors can take more out, but not less than the minimum annually, without incurring tax penalties.
The IRS publishes tables on their website on how to calculate these minimum withdrawal amounts. The account balance is just divided by a divisor that decreases every year, resulting in a higher percentage of the account needing to be withdrawn.
This process goes by several names, but they're all the same thing: MDIB stands for Minimum Distribution Incidental Benefit, MRD stands for Minimum Required Distribution, and RMD stands for Required Minimum Distribution.
For those investors that pass away before the IRA is depleted (at a maximum age of 115), the IRA is passed on to heirs. Then it's subject to similar minimum distribution rules.
That's why there are two RMD calculators, one for owners, and one for beneficiaries. The inherited IRA calculator is for calculating the amount of minimum required distributions only when someone has an IRA they inherited from someone else.
These tables were different for male and female, but were replaced by a unisex life expectancy table around 2004. So if you see MRD tables for male and female, they're very obsolete, and shouldn't be used.
These future MDIB amounts are just estimates, so even though it calculates far into the future, the actual annual minimum distribution has to be determined using actual values on an actual date.
The future numbers are just to calculate estimates for input into retirement planning software.
These estimated amounts are shown for each year up until an advanced age that the IRS assumes you will pass away at (currently age 115).
Most qualified plan custodians will do this for you, but only when it actually happens. Errors in their work do occur. This calculator can serve as a check on their work (so you won't get penalized for not taking enough out).
72(t) is the section of IRS Code that governs how an investor can withdraw money out of tax-qualified plans, like IRAs, before the normal distribution age of 59½, without having to pay premature distribution penalties.
Before this code change, investors that wanted or needed to retire before age 60 were penalized unfairly. So in 2002, the IRS made exceptions to these premature distribution rules in Section 72 of the code, Part "t".
These rules make it unfeasible for investors to just tap into their retirement plans willy-nilly because they either need the money to pay for something, or want to use it up too fast, then be left with nothing later in life. So this was a compromise that suited all parties.
In a way, 72t works the opposite way MDIB does, because it governs maximum distributions too.
There are three calculation methods in the code to avoid the 10% early distribution penalty tax in section 72(t). These three methods are not the only ways to qualify for these exceptions, so the Inflation Adjusted Income Stream Generator would probably also qualify if you set the ending age to 115.
To make a long story short, all the IRS requires is that you start making withdrawals using "substantially equal periodic payments over your life expectancy;" and thus are not withdrawing "too much," nor too little; and are always paying taxes on this income annually.
This allows investors to retire before age 60 and receive retirement income from their tax-qualified retirement plans, without being penalized. This retirement income is then usually taxed at ordinary income rates, but the point is that there are no 10% penalties (unless you withdraw more than the calculated amounts).
Even though the IRS will allow most ways of withdrawing "substantially equal periodic payments," they publish three set formulas as guidelines. Using the formulas given, these three qualified plan retirement income distribution calculators were constructed:
Life Expectancy Method: The end of the last years balance is divided by a life expectancy divisor, which goes down every year, so the required payments escalate to the point that all of the IRA is distributed over the investors lifetime. Of the three methods of doing 72(t), this will result in the lowest annual distributions from the IRA.
Fixed Amortization Method: The same story applies as above, but the formula is different. A time value of money formula is used, with the same life expectancy divisor, end of the last years balance, and an assumed interest rate. This method will usually result in the highest annual distributions.
Annuitization Method: This also has the same story as above, but this method uses an actuarially determined annuity factor, so be careful. You can get examples of these rates from the IRS website. This produces about the same annual distributions as the amortization method, but just a little less. The main difference is distributions are more level over time than the other methods.
Social Security Calculators
There are six retirement calculators that compare and help you decide when to start collecting Social Security benefits.
Just input your own PIA data (Primary Insurance Amounts, or monthly benefits in dollars), using your actual benefit statement, and then compare annual cash flows and estimated ending investment account values, between starting retirement benefits at ages 62, 67, and 70.
It then estimates future PIAs, present values, future values, draw-downs on side-investments, and various other Real World factors in the scenarios.
This bunks the myth that you should wait as long as you can, just because "benefits go up." You can read about this classic debate, and how this retirement tool finally resolves it forever, on the Social Security analysis page.
This employee benefit tool will calculate the present value of a Golden Handshake offer from your employer. This is the awesome deal where they try to bribe you with an immediate huge lump sum payout to quit your job.
This financial calculator can also be used to compare job offers, deciding whether to go self-employed, take a 1099 "independent contractor" job; and by employers to calculate the present value of employees in general. So you can use it to compare all kinds of employment offers and other similar deals.
Just input the basic parameters of your deal, and in a few minutes it will compare all money coming in with all money going out, to give you a bottom line to evaluate before you sign off on such a risky and permanent deal.
It has all of the usual annual manual override columns, so you can model your situation exactly in as much detail and accuracy as you want to.
Average Tax Bracket Calculators
All four versions of Average Federal Tax Bracket Calculators are here: Single, Married Filing Jointly, Married Filing Separately, and Head of Household.
All you'd do is input your gross income, exemptions, deductions, and it estimates how much as a percent in Federal tax you're paying.
Using marginal tax rates is not correct when inputting global tax rates into retirement and financial planning software. So a simple and easy way to determine average / effective Federal tax rates needed to be invented (for input into retirement planning software).
This is useful for generating input data that goes into financial / retirement planning software. Because these programs are designed to take your total situation into account (income from all sources), and not just the additional (marginal) income from an investment, using marginal tax rates is not correct, and substantially overstates taxes due, especially if you're retired.
Average is the only way to get Real World results.
Taking the total amount of Federal taxes you actually pay, and dividing that amount by your gross income also finds your average Federal tax bracket.
People in 28%+ marginal brackets are surprised to find that their average bracket can be under 15%. In other words, less than 15% of their gross incomes are being paid in Federal taxes.
This tax calculator does not account for state, Social Security, Medicare, Local, nor other taxes.
To download the demo, click on the link below, and then choose "Save (Target) As..." to save to your hard drive. Then find and open with Excel.
Be sure to see the sheet that shows what colors should look like.
It helps to read the directions as you look at the demo
|Financial Planning Software Modules For Sale
(are listed below)
Financial Planning Software that's Fully-Integrated
Goals-Only "Financial Planning Software"
Retirement Planning Software Menu: Something for Everyone
Our Unique Financial Services
Mr. Market Timer's Unique Market-neutral Stock Market Timing Services
Miscellaneous Pages of Interest
Buy now with your Visa or MasterCard by calling (503) 309-1369
|TVM Financial Tools Prices:||Unsupported:||E-mail Support:||Phone and E-mail Support:|
(pay once and never pay again)
You'll get ALL of these financial tools when you order it, not just select sheets
© Copyright 1997 - 2017 Tools For Money, All Rights Reserved