|
Time Value of Money Financial Tools |
|
The free financial calculators are here in the demo |
Site Information
Confused? It Makes Sense If You Start at the
Home Page Pricing and How to Buy the TVM Tools Are at the Bottom Discounts for Financial Planners and Money Managers New Financial Planner Starter Kit
Buy the
Financial Plan Tools Now Site Info, History, Ordering Security, Privacy, FAQs Questions About Time Value of Money Calculators? Call (800) 658-1824 or Send E-mail About Getting Investment Software Approved by Broker Dealers and FINRA Financial Plan Software Support Testimonials from Financial Planning Software Customers Buy the Financial Plan Tools Now Free Downloads and Money Tools Free Sample Comprehensive Financial Plan Free Downloads, Investing Tips, and Tutorials Links to Other Personal Finance Websites The World's Best Free Retirement Calculator Other Free Retirement Calculators Our Free Financial Calculators Other Free Online Financial Calculators Free Business Owner Calculators Miscellaneous About Portfolio Management Software About Using Monte Carlo with Investment Software About Investment Risk Tolerance About Using a Discount Broker to Manage Your Own Money (and about custodians for advisors) |
A 25-sheet Excel workbook that has all of the usual time value of money calculators, plus several sheets with most all of the smaller financial tools needed when creating personal financial plans. The First Seven Sheets are the Free Financial CalculatorsSheet #1 (free): TVM Calculators All of the usual Time Value of Money calculators: Present value, Future value, Payments, Number of 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, Tax-free yield converter, Compound interest comparator, CD early withdrawal penalty calculators, and more. Most of what's available on free online financial calculator websites are here for free. You can also download the spreadsheet and use them offline. Sheet #2 (free): 360-Cash Flow IRR Calculator Calculate Internal Rate of Return based on a series of 360 cash flow periods. It has a column where you enter cash flow dates and it gives the bottom line rate of return results as is, and also compounded annually. Money Calculator Sheets #3 (free): Compound and Simple Interest Rate Comparators Input and compare the growth (or shrinkage) of money given the three compound interest rates. It has one column for simple interest; one compound interest column has a year-by-year manual override (so you can have a different rate of return every year), and a graph sheet. You can also add new money to the picture every year. Financial Tools Sheet #4 (free): Compound Interest Rate Converter Calculate differences in interest rates given different compounding periods. Two graphs. Financial Planning Sheet #5 (free): Cost of Raising A Child calculator Input data 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). Investment Calculator Sheet #6 (free): Long-term Costs of Having a Family Ruining Monster in Your Household Calculator Most everyone has a "family ruining monster" in their home. You know, the one that won't quit smoking, drinking, gambling, the list goes on ad nauseum. We have one too. Her response to the decades-long whining about the $5 per day on cigarettes and $10 spent on Keno is, "Oh shuuuuuuut uuuuup! It's only a few bucks here and there!!! Goooooooooooooooood ... leave me alone!!!" Well, this adds up to major bucks over time - enough to make or break a family, prevent all kids from going to college, and enough to fund a family's retirement. This is the only such tool that does the job so quick and easy. Now you can show your Family Ruining Monster the true costs of their bad habits and behavior. Money Calculators Sheet #7 (free): Rent vs. Buying a Home Calculator The most comprehensive, flexible, and detailed "Rent vs. Own a Home" calculator ever created. Homeowners prepared to be shocked! The devil is in the details, and the more details you consider, the more you will be surprised. Financial Planning Software Sheet #8: Mutual Fund Calculator and Investment Balance Estimator The most detailed mutual fund investment projector ever created. Input basic parameters, and see details about growth, shrinkage, taxes, capital gains realized and unrealized, basis, costs in percentages, etc. It's the same Non-Tax-Qualified Mutual Fund A-Share sheet carved out of the of the Investment Comparator. Control every number in every year with the manual overrides. Financial Software Sheet #9: 401(k) or 403(b) Calculator The most detailed investor software ever created that shows the growth and payout of 401(k) or 403(b) plans. It's the same thing as sheet #7, but there's two of them, so one uses employee contributions, and the other uses employer contributions. This makes it easy to evaluate the value of employer contributions. It has three charts. Money Tool Sheet #10: Investment Growth and Payout Calculator The most detailed investor software that grows and pays out income. It's the same asset sheet carved out of the Real World Retirement planner (RWR). Assets have nine payout methods to simulate, as closely as possible, life in the Real World. This is the only financial tool that will do payouts this closely to real life (and take into account all of the IRS tax-qualified plan distribution methods). To make a long story short, you have total control over when assets start, how they grow or shrink, how new money is added, how they're taxed, and how they pay out income, down to the dollar in every year. The asset has its own growth rate of return specified by the user (compounded annually), and this rate of return can be manually overridden in each year. If you think an asset will have different rates of return in different years, or even a loss in some years, you can do this. Great for limited partnerships or laddered bond portfolios that have staggered maturities. The asset has a starting year at which monthly contributions to the asset will start and stop. This can be any year, even a year after payout has begun. It can be any number of years too, even just one. You can manually override every contribution amount at every year. For example, you can specify $100 monthly contributions to a 401(k) plan (that even currently doesn't exist because the client hasn't worked there long enough to qualify yet), inflating at 2% annually, with no contributions in the 4th year, a $50 contribution the 6th year, and a $200 withdrawal (or loan) in the 12th year. Years before (or after) the manual income withdrawals use the $100 + 2% growth number as if nothing unusual happens in previous or future years. This is great when someone says they will be eligible for their company 401(k) plan next year (or any future year), and they will start contributing to it then (and even better when they contribute in unequal income need amounts over any number of years). The Nine Asset Payout Methods: 1) Lump Sum: 100% of the assets balance is paid out as a lump sum at any year specified (whether retired or not, or way past the age retirement has already started). You can still use the manual withdrawal column BC to take out amounts before the 100% lump sum year, but you cant use it on the same year, or afterwards. If you attempt to do this, it will ignore any amount you enter into the manual withdrawal column and will not give you an error message. 2) Yield Only: The biggest use for this is when you want to keep the principal intact forever. It has more uses than that, as explained below. For example, to account for individual bonds in the Real World, you can use the manual withdrawal column to lump sum the maturity proceeds. You can also simulate any number of individual bonds maturing on different years by using the manual withdrawal column in conjunction with the rate of return manual override columns. Here you would enter the total market value of all of the bonds into cell A6. Then manually determine the interest rate every year by taking a weighted average, and enter this rate in the rate of return manual override column for that year. Then use the manual withdrawal column and enter the individual maturity proceeds until all the bonds have matured. If you want to get fancy with fluctuating principal (e.g., bonds that self-destruct like GNMAs) you can use the rate of return manual override column to make the market values what you want in every year. Another use of this payout option is simulating assets like bond mutual funds by assuming a total return of 7%, taking out 6% interest income, and having the principal grow by some small amount. Or slowly deplete it by taking out 7% and growing it at 6%. Note: Income generated by assets before retirement (payout age) is assumed to be spent, so its not reinvested or taxed anywhere. 3) Inflation Adjusted Income Stream Generator: This method automatically answers the question, "Whats the most money I can take out of this asset every year, have this income stream keep up with inflation every year, and have it last until Im 100 years old?" All you do is enter a 3 into cell A15 to select third method, and the age when you want the asset to be depleted into cell A25. Everything else is automatic. You should check the numbers on the asset page, as some combinations of rate of returns and depletion ages will result in the asset not depleting in the exact year. You can play with the rate of returns and depletion ages to get the results you want. 4) IRS Required Age 70 & 1/2 Minimum Distributions: It only does it starting at age 70, and it only uses the recalculation with single life method. The joint methods are near impossible to program. Manual withdrawals will work before age 70, but not after. 5) Specific Amounts: This method just disables all of the other eight payout methods, so that only manual withdrawals using the Manual Income Withdrawal column will work. This is located at column BC starting at row 27. In other words, you have to manually enter income payout withdrawals in each year by inputting the year-by-year manual withdrawal amounts. If you enter a number that is larger than the amount of the assets beginning of the year balance, only the beginning of the years balance will be used as income, and you will not get an error message. Numbers entered into this column do not override the normal payout amounts - they are added to them, so they are not "manual overrides" like in most other similar input fields. 6) Single Life Fixed Annuity: This method of paying out income trades the assets market value in for a permanent income stream. This income stream most resembles a single life annuity (or old style defined pension plan). The income stream does not inflate; it wipes out the assets market (principal) value when it starts to pay out, it pays out until death, and cannot be altered once it begins. Note: The assets market value is supposed to vanish when the income stream starts, so this is not a program error. If you really want to use exact numbers from tables, youll need to get the amounts from somewhere else (like the insurance company that holds the annuity) and enter them manually using payout method #5. 7) Inherited IRA or IRS Rule 72(t) Governing Pre-Age-59 ½ Tax-Qualified Plan Distributions: What? To sum this long story up, if you have a tax-qualified plan (e.g., IRA), the IRS has rules to make sure people pay the taxes that they saved during the accumulation phase. There are also rules saying that if you take money out of an IRA before you turn age 59 ½, then you have to pay a 10% premature distribution tax (in addition to ordinary income tax). In 2002, the IRS realized the error of its ways, and made exceptions to these rules in Section 72 of the code. Part "t" makes exceptions to getting these premature distributions, because many people are already retired at ages before 59. Also, people that have inherited IRAs may need the money now. There are three ways to avoid the 10% penalty tax in section 72(t). The three methods are not the only ways to qualify for these exceptions. All the IRS cares about is that you are receiving "substantially equal periodic payments" from the IRA, and thus are paying taxes on this income. Payout method #4 is also a way to do this (but dont use it before getting advice from a tax pro!). Payout method #7 uses the same calculations used for Inherited IRA distributions and the 72(t) method called Life Expectancy. Basically the end of the last years balance is divided by the life expectancy of the owner. These life expectancy numbers go down every year, so the required payments escalate to the point that all of the IRA is distributed over the persons lifetime (assuming that they live until life expectancy). Of the three methods of doing 72(t), this method will result in the lowest annual required minimum distributions from the IRA. 8) IRS Rule 72(t) Governing Pre-Age-59 ½ Tax-Qualified Plan Distributions Using the Fixed Amortization Method: The same story applies as above, but the formula is different. A time value of money formula is used, using life expectancy numbers, end of the last years balance, and an assumed interest rate. This method will result in the highest annual distributions. 9) IRS Rule 72(t) Governing Pre-Age-59 ½ Tax-Qualified Plan Distributions Using the Annuitization Method: The same story as above. This method uses an actuarially determined annuity factor, so be careful! You can get examples from the IRA website: http://irs.gov This method produces about the same annual distributions as payout method #9, but are just a little less. Sheet #11: 25-Year Dollar-Weighted Rate of Return (IRR) Calculator A simple and easy to use, but comprehensive, 25-year investment portfolio IRR calculator that shows the rate of return each year, and averages for multiple years - considering all of the unequal/separate monthly cash flows that happen with portfolios in the Real World: Dividends/capital gains/spent withdrawals, taxes on them, and contributions. Uses the dollar-weighted rate or return methodology (AKA internal rate of return, or IRR). You can change each tax rate every year, and have different tax rates for each type of distribution. It gives you the pre-tax and after-tax IRRs for all 25 years. Finally a simple and easy to use calculator of total returns where all you have to do is input how much money went in and out on a monthly basis. Good for tracking one mutual fund and complex portfolios from numerous accounts/brokers (so you can get a return on everything you own combined). This financial tool will also give returns for sold assets, so you can determine the IRR since way back when you bought them. It also adds up all of the monthly cash flows so you can see what the annual totals are. The point is that it works well for people that just want to input data from their multiple monthly statements, and see how well their investments have done. Sheet #12: 25-Year Time-Weighted Rate of Return Calculator The same concept as sheet #10 but using the time-weighted rate of return methodology. The time-weighted rate of return method of computing investment returns is more accurate because it mostly ignores portfolio cash flows (contributions and withdrawals). So it's the most accurate way to compare the performance of investment managers apples-to-apples. 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. This is because you'd have to input portfolio values every day there was a cash flow, and most investors don't have this data available anyway. It works well for people that just want to input data from their multiple monthly statements, and see how well everything has done combined. The only other way to do this is to buy portfolio management software. This is investment software that will keep track of clients, client portfolios, transactions, portfolio statistics, rates of return, etc. Personal Finance Calculators Sheets 13 - 16: Investment Management Fee Calculators for Investment Advisors These tools help investment advisors working on a fee basis, calculate how much to charge clients. Some advisors have to manually tell their custodian how much in fees to deduct from client accounts, so they can get this amount paid to them on a periodic basis. This tool will do that quickly and easily. Just input your breakpoints, fees, and account values and it totals everything up and gives 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. It has five, four, three, and two tier schedules for advisors with sliding scales. It has input fields for names, account numbers, and account values. In the input fields, you can just reference from another source once, and everything will be automatic from then on. If you have to do this manually, then this will save you tons of time, and will pay for itself the first time you use it. Personal Finance Calculator Sheet #17: Inflation Adjusted Income Stream Generator This is the same thing as payout method #3 on sheet #9 above, but stand-alone. Investment Calculators Sheet #18: Portfolio Yield and Paycheck Calculator For up to 100 assets, it determines: The combined average income/dividend yield on your total portfolio; how much income, or paycheck, your total portfolio will produce on a daily, weekly, monthly, and annual basis; how much as a percent each asset is of the total portfolio; and how much each asset is estimated to pay out on a daily, weekly, monthly, and annual basis. You just enter three data points (asset name, dollar amount of it held, and its annualized estimated yield - get it from the fund's prospectus, website, Morningstar, other source, or guess) into the green shaded areas, and it automatically computes the numbers. Sheets #19: Age 70.5 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 that money back. Some people let their IRA's grow without taking any contributions from them, hoping to escape this. So the IRS requires people to start taking distributions from them starting in the year they turn 70 and a half. They publish tables on their website on how to calculate these minimum amounts. One can take more out, but not less than the minimum. The account balance is just divided by a divisor that decreases every year, resulting in a higher percentage of the account needing to be distributed every year. All of the amounts distributed are then subject to ordinary income tax rates. This sheet won't work using fractional ages, so don't input things like age 59.5. The 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 people that do pass away before the IRA is depleted (at a maximum age of 115), the IRA is passed on their heirs, which are then subject to similar minimum distribution rules. That's why there are two RMD calculators, one for owners, and one for beneficiaries. There used to be different table for male and female, but it was replaced by a unisex life expectancy table a few years ago. So if you see tables or MRDs for male and female, they are out of date, and shouldn't be used. The amounts calculated are estimates based on the tables. To be sure you don't' get dinged penalties for not taking enough out; you may want to round up to the nearest thousand. Input the current IRA values into cell B7 or Q7. Input the current year into the cell below, and the name, if you want, into the cell below. Input the age the person will be at the end of the current year into cell B10 or Q10. Then estimate a tax rate and input that into the cell below. Then estimate an average rate of return into the cell below. The estimated amounts that you'll have to withdraw from the account is shown for each year up until an advanced age that the IRS assumes you will pass away at (currently age 115). These numbers are just estimates because they all depend on the actual tax rate and rate of return the account will grow (or shrink) at. The Inherited IRA calculator is for calculating the amount of minimum required distributions only when someone has an IRA they inherited from someone else. You'll need to scroll down to see the results. Read more about this financial tool Money Tools Sheet #20: IRS 72t IRA Minimum Distribution Calculators 72t is the section of IRS Code that governs how to take money out of tax-qualified plans, like IRAs, before the normal distribution age or 59 and a half, without having to pay premature distribution penalties. Before this code, people that wanted, or needed, to retire before age 60 were hurt unfairly. In 2002, the IRS realized the error of its ways, and made exceptions to these rules in Section 72 of the code. Part "t" makes exceptions to getting these premature distributions, because many people are already retired at ages before 59. Also, people that have inherited IRAs may need the money now. There are three ways to avoid the 10% early distribution penalty tax in section 72(t). The three methods are not the only ways to qualify for these exceptions. All the IRS cares about is that you are receiving "substantially equal periodic payments" from the IRA, and thus are paying taxes on this income. To make a long story short, all the IRS requires is that you start making withdrawals using "substantially equal periodic payments" to qualify. This allows people to retire before age 60 and get retirement income from their retirement plans, without being penalized. The rules make it unfeasible for people to just tap into their retirement plans because they either need the money to pay for something, or want to use it up too fast, and be left with nothing later in life. Even though the IRS will allow most ways of withdrawing "substantially equal periodic payments," they have three set formulas for people to follow that serve as guidelines. These are called 72t Early Distributions. Using the formulas given on the IRS website, the three calculators were constructed. Life Expectancy Method: Basically the end of the last years balance is divided by the life expectancy of the owner. These life expectancy numbers go down every year, so the required payments escalate to the point that all of the IRA is distributed over the persons lifetime (assuming that they live until life expectancy, which most won't be a long shot). Of the three methods of doing 72(t), this method will result in the lowest annual required minimum 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, using life expectancy numbers, end of the last years balance, and an assumed interest rate. This method will result in the highest annual distributions. Annuitization Method: The same story as above. This method uses an actuarially determined annuity factor, so be careful! You can get examples from the IRS website: http://www.irs.gov/ This method produces about the same annual distributions as payout method #9, but are just a little less. Money Calculators Sheet #21: Social Security Calculators There are six calculators to compare and help decide when to start taking Social Security benefits. Input your own data, and compare annual cash flows and ending values between starting benefits at ages 62, 67, and 70. It calculates present values, future values, draw down on assets, and various other scenarios. This debunks the myth that you should wait because benefits go up. Read all about the classic debate, and how this tool resolves it on the Social Security analysis page. Money Tool Sheet #22: Employee Stock Option Calculator Far superior to all of the free online stock option calculators. Calculates most all of the numbers people want to see. Has a ten-year window and works on a quarterly basis. Allows you to see the before- and after- tax value of all of the options combined, less options already exercised. Personal Finance Software Sheets #23: Average Tax Bracket Calculators All four versions of the Average Federal Tax Bracket Calculators (read about them in detail). Investing Calculator Sheet #24: Convertible Bond Calculators An array of the usual convertible bond calculators. Money Calculator Sheet #25: Preferred Stock Yield to Maturity and Yield to Call Calculators Input up to ten preferred stocks and calculate yield to maturity and yield to call on each one. Why aren't you taking advantage of this? Send e-mail and if you have an interesting reason, then you may get a freebie. To download the demo, right click on the link below, and then choose "Save (Target) As..." to save to your hard drive. Then find and open with Excel. Answers to frequently asked demo questions and how to use demos. Download the money tools demo 3.7 MB (it's the same as the 8.2Mb program, but only the first six sheets work) It helps to read the directions as you look at the demo |
Personal Finance Software Modules
Fully Integrated Financial Planning Software Menu of Retirement Planning Software Asset Allocation Overview with Our Historical Returns Asset Allocation Models with Our Historical Returns Monthly Updated Mutual Fund Picks Financial Planning Fact Finders Investment Policy Statement Software Investment Software for Comparing 23 Methods of Investing Buy Term Life Insurance and Invest the Difference in Mutual Funds vs. Whole Life Net Worth CalculatorVariable Annuity Tutorial and Optimizer Services Fee-only Consulting for Consumers, Investors, and Financial Planners Building Custom Investment Benchmark Portfolios Coaching for Financial Planners Buy or Sell an Investment Management or Financial Planning Practice Asset Allocation for 401(k) / 403(b) and Similar Retirement Plans |
Buy now with your Visa or MasterCard by calling (800) 658-1824
Buy now using the secure credit card ordering form
Buy now using PayPal and get 5% off
Money Calculator Prices |
Unsupported: $19 |
E-mail Support: $29 |
© Copyright 1997 - 2009 Tools For Money, All Rights Reserved