Tools and calculators
Additional discussions and reviews of these Tools and calculators can be found in the discussion page (tab at top). Caution: Past performance does not guarantee future results.
- Simba's backtesting spreadsheet, a Bogleheads community project. Acting as a reference for historical returns, and enabling the analysis of custom portfolios based on such historical data.
- Portfolio Visualizer, by forum member pvguy. For backtesting, Monte Carlo simulation, tactical asset allocation and optimization, and investment analysis.
- Portfolio Charts, by forum member Tyler9000. Historical data for popular portfolios and interactive calculators for studying your own personal asset allocation from different perspectives.
- Backtest, by forum member yoran. For backtesting of portfolios of index funds and ETFs that are available to European investors.
Find out what your bonds are worth.
- Savings Bond Calculator (from the U.S. Department of Treasury, your tax dollars at work)
- US Savings I Bond Value and Interest Rate Calculator (from Savings-Bond-Advisor)
- Yield to Maturity (from Morningstar) - requires Morningstar membership
- The yield to maturity of a bond is the total return it will earn if held to maturity, assuming all interest is reinvested at that same rate.
- Bond yield calculator, from Money-Zine.com
Those considering a business relationship with an investment adviser should perform due diligence to validate a financial adviser, broker, or investment firm's background credentials and complaints on file. The SEC and FINRA provide free tools to help consumers with this process.
From the IRS, Tax Exempt Organization Search is an on-line search tool that allows users to verify that an organization is tax exempt and check certain information about its federal tax status and filings. You may search for.
- Organizations eligible to receive tax-deductible contributions (Pub. 78 data),
- Organizations whose federal tax exemption was automatically revoked for not filing a Form 990-series return or notice for three consecutive years, or
- Form 990-N (e-Postcard) filers and filings.
College savings planner
- Vanguard College Savings Planner
- College Savings Calculator
- Analyzing 529 College Savings Plan Fees and Expenses, from the Financial Industry Regulatory Authority, Inc. Compare how fees and expenses can reduce returns. Enable browser cookies.
- AnnualCreditReport.com, enable browser cookies
AnnualCreditReport.com is a centralized service for consumers to request free annual credit reports. It was created by the three nationwide consumer credit reporting companies - Equifax, Experian and TransUnion - and is the only service authorized for this purpose. Under the Fair Credit Reporting Act (FCRA), you have the right to obtain one free copy of your credit report from each of the three major credit bureaus every 12 months.
- Department of Labor Consumer Price Index
- Federal Reserve Economic Data (FRED), from the Federal Reserve Bank of St. Louis. 39,000 economic time series from 38 sources. Download, graph, and track economic data. Downloadable tools, such an iPhone/iPad app and an Excel Add-In are available.
Insurance for deposit accounts
Calculate insurance coverage for a group of deposit accounts.
- EDIE, the Electronic Deposit Insurance Estimator, from the Federal Deposit Insurance Corporation (FDIC). Use for qualified banks.
- E-Calculator, the Electronic Share Insurance Calculator, from the National Credit Union Administration (NCUA). Use for members of the NCUA.
Life expectancy calculators
These calculators use historical models to predict your life expectancy based on your lifestyle and family history.
- Living to 100 Life Expectancy Calculator (enable browser cookies)
- Northwestern Mutual
- Social Security Life Expectancy Calculator
IRS life expectancy tables
The IRS also has a view of your life expectancy, which is used solely for determining the Required Minimum Distribution of your IRA. Your age, your spouse's age, and beneficiary status are taken into account.
This Google Docs spreadsheet will calculate your life expectancy (or distribution period) based on Tables I, II, or III in IRS Publication 590 (IRAs):
- Spreadsheet calculator: download as xls, ods, pdf
- Life Expectancy Tables from IRS Publication 590 (view in browser)
Loan and mortgage calculators
A mortgage is a type of loan dedicated for financing the purchase of real estate. You can sometimes find mortgage calculators grouped with other types of loan calculators. The links below contain both dedicated mortgage calculators as well as calculators used for other types of loans.
Key loan parameters are principal, interest rate, periodic payment, and duration. Mortgage calculators can also include parameters such as rate of inflation and taxation. "Rent versus buy" decisions are specialized forms of mortgage calculators.
- On its default setting, note that rent increases 3% per year while homes appreciate at 1% per year. A suggested assumption is for both to increase at the rate of inflation.
- Mortgage Calculators and Financial Calculators (from HSH® Associates, Financial Publishers)
- Contains numerous mortgage and financial calculators both online and download versions (email registration required for download). Includes various loan calculators (amortization, payments, etc.), refinancing, rent vs. buy, PMI with amortization.
- Mortgage Calculators (from the Mortgage Professor)
- An extensive number of mortgage calculators. With one or two mortgages, there's a calculator for: Debt consolidation, extra payments (prepayment), refinancing.
- Also: When to terminate Private Mortgage Insurance, housing affordability, Adjustable Rate Mortgages with / without negative amortization, comparison of fixed-rate versus Adjustable Rate Mortgages (ARMs), points and fees, downpayments, terms, annual percentage rate (APR)
- Caveat - Some calculators only work with Internet Explorer.
- Contains mortgage calculators for just about anything.
- Be sure to check Financial Calculators from DinkyTown.net. There are (claimed to be) 300 financial calculators that should cover just about anything financial.
- This calculator enables you to accurately calculate the tax savings of the mortgage.
- Compare mortgage terms (from the Washington Post)
- Use this calculator to determine the total cost in today's dollars of various mortgage alternatives taking into account your opportunity cost of money.
- A calculator that uses slider bars to graphically show the principal vs. interest breakdown over the period of the mortgage.
- Excel Loan Amortization Application Spreadsheet (from Microsoft)
- Free from Microsoft, for Excel 97 or later. To download, use Internet Explorer with cookies enabled (Firefox will not work). Microsoft will install an ActiveX control. The download will open a new spreadsheet in Excel.
- When you put in the interest rate, points, term, etc. it shows a monthly tally of principle and interest payments. You can then compare what you are paying now with the new loan. It will also show total interest for the term of the loan. For any monthly payment you can enter a lump sum payment to see what happens to the total interest as a result of accelerating your pay schedule.
Mutual fund fee calculators
Fees and expenses are an important consideration in selecting a mutual fund because these charges lower your returns. Compare the fees and expenses of different mutual funds before you invest.
- Effect of Expenses on a Portfolio, to see how investment expenses affect a portfolio over a long investment time horizon.
- Fund Analyzer (from FINRA - Financial Industry Regulatory Authority)
- The Fund Analyzer offers information and analysis on over 18,000 mutual funds, Exchange Traded Funds (ETFs) and Exchange Traded Notes (ETNs). Estimate the value of the funds and impact of fees and expenses on your investment. Look up applicable fees and available discounts for funds. Enable browser cookies to use. Features:
- Real-time online comparison of up to 3 funds. (Use different calculator if the fund is not listed.)
- Expense analysis: Slider bars allow variation of your investment, return and period (duration held).
- Fee/Discount report: View a breakdown of the fund's expenses. If the information is not provided, the field is blank.
- You must accept the Terms and Conditions when you first enter the site (check the box and hit OK).
- Google search for mutual fund fee calculators, for those who want to go further
- Mutual Fund Expense Calculator (from Dinkytown.net)
- An easy to use calculator that graphically shows the impact of fund expenses on your final balance.
- Identical to the calculator from Dinkytown.net
- A Canadian mutual fund expense calculator. It will also work with US equities. Referenced from Finiki, the Bogleheads' affiliated Canadian wiki site.
- The AARP (American Association of Retired Persons) is a popular web site for retirement information. No calculator, just links to calculators from the SEC and FINRA, already mentioned above.
- The basics. It's somewhat lacking from what you would find elsewhere.
Personal finance toolbox
This spreadsheet contains various calculations applicable to personal finance, including
- Tax planning, including many common credits and extra taxes, for both federal and state taxes
- Traditional vs. Roth vs. non-deductible IRA vs. taxable investment choice
- Social Security benefit estimates
- "HDHP plus HSA" vs. "non-HDHP and no HSA" comparison
- Lump sum vs. pension
and others. The first tab in the spreadsheet, Instructions, has more detail about calculations available, and a "quick start" method for the tax calculations.
A notable feature is the marginal tax rate chart it can generate for any of the tax calculation inputs. This has been used for various Bogleheads' wiki articles, and can be useful for people to evaluate their specific situations.
MMM Case Study Spreadsheet updates is a Mr. Money Mustache forum thread in which version changes are posted.
To open the spreadsheet directly in Google docs (from which it can be downloaded into Excel form, where it works best), use the links below.
You can use various utilities to design and manage portfolios that span multiple accounts. Most tools cannot automatically compose your ideal portfolio, but you can use the tools to enter two or three models that you composed, and then you can compare and contrast the results, looking in particular at the blended expense ratios and the totals of each asset class.
Forum member contributions
- Using a Spreadsheet to Maintain a Portfolio: a wiki page with tips and spreadsheets for maintaining your portfolio
- Boglehead David Grabiner's asset allocation worksheet
- Boglehead David Grabiner's worksheet for computing and comparing tax costs
- Optimal lazy portfolio rebalancing calculator: rebalance optimally without making any "backwards" transactions - from forum member Albert Mao (the_one_smiley)
- The Retiree Portfolio Model, an Excel spreadsheet created by forum member BigFoot48, models virtually every aspect of a retiree's financial life.
- Taxable and IRA accounts earnings and withdrawals
- Income from work, pensions and Social Security
- Expenses including future changes
- Inheritances, asset sales and large purchases
- Federal and state income taxes using current rates, brackets and other factors
- Required Minimum Distributions forecasts from owned and inherited IRAs
- Roth conversion modeling with tax bracket impact with instant analysis of results
- Alternative Social Security benefits instant analysis
- All of these are combined with a selected asset allocation and earnings rates to create a complete picture of retirement life for up to 40 years. The spreadsheet and additional details can be found in this Bogleheads® forum topic: .
- Portfolio Toolbox, by forum member Seann. For backtesting; sectors returns in a chart similar to the Callan periodic table of investment returns. A retirement planner and Social Security calculator are also provided.
- Portfolio Visualizer, by forum member pvguy. For backtesting, Monte Carlo simulation, tactical asset allocation and optimization, and investment analysis.
Fidelity has a comprehensive list of tools and calculators which cover investing and retirement.
- Financial Calculators & Tools. An overview.
- All calculators & tools. The complete list - from creating a budget to reviewing your investment strategy.
- The Mutual Fund Evaluator also works with ETFs. There is more than one way to perform the comparison.
- Launch the tool and select 2 funds to compare. Add funds as desired.
- View the first fund's summary page. In the "Hypothetical Growth of $10,000" chart, click on "Compare Chart" to launch the tool with the first fund selected. Add funds as desired.
- Fidelity Guided Portfolio SummarySM. Account owners have access to a comprehensive portfolio analysis tool. A video tutorial is here: Fidelity Guided Portfolio Summary You do not need to invest any money with Fidelity to use this tool. All you need is an account. Here's how:
- Open a brokerage account, which will have a balance of 0.00.
- Go to the account Analysis tab. Click on the drop-down accounts menu, e.g. "1 of 1 accounts selected". A new pop-up window will appear.
- Click on the "Add an Outside Account" link in the top-right corner, then "Add Manually".
- Select the Account Type, such as an IRA, and Institution. Enter the detailed or estimated holdings as desired, then "Save".
- If instead you prefer to add your investments via an online account held at another brokerage, you can use Fidelity's Full View® service. In the "Add an Outside Account" pop-up window, select "Add in Full View".
Morningstar - Requires a free subscription to use.
- Morningstar Instant X-Ray is especially useful for breaking down a portfolio into asset allocations and style boxes. It essentially a pre-built spreadsheet; enter your portfolio and the X-Ray will show its current allocation and other statistics.
- Use a ticker symbol of
CASH$(as shown) to enter cash.
- Asset classes that are not part of a stock style box or bond style box will not appear in the Stock Style Diversification section of the report. The asset class will, however, appear in the Asset Allocation section of the report. Cash is one example, commodities are another. For example "GLD" (SPDR® Gold) will be listed as "other" in the Asset Allocation section and will not appear in the Stock Style Diversification section.
- Use a ticker symbol of
T. Rowe Price
- Investment Planning Tools and Calculators. You can sign up for a free online account and have access to Morningstar tools.
- Compare Mutual Funds. Find possible alternatives for specific mutual funds, CEFs, ETFs or index funds, or choose up to five specific symbols to compare at one time.
- Investment calculators & tools. An overview.
- Compare mutual funds and ETFs. Select up to five mutual funds or ETFs to compare.
- Vanguard Portfolio Watch. A tool in the Vanguard website for Vanguard clients that breaks down portfolio into asset classes; see main article for more information and caveats/limitations of the tool. Bogleheads® forum topic: discusses errors found with this tool.
RMD (Required Minimum Distribution) calculators
The RMD (Required Minimum Distribution) calculators should be checked against the IRS Life Expectancy Tables to be sure that the appropriate table is to be used in your situation. Additional comments in the discussion page (tab at top).
- Required Minimum Distribution (RMD) Calculator - MainStay Investments
- See: Retirement calculators and spending
- See: Retiree Portfolio Model, described in the Portfolio tools section above.
Roth IRA conversion calculators
- Retiree Portfolio Model, described in the Portfolio tools section above, estimates the financial impact of a Roth IRA conversion on your portfolio, income taxes, RMD and other factors.
- Roth IRA Conversion Calculator, by Fidelity.com
- Estimates the potential long-term tax and financial impact of converting to a Roth IRA, based on information you provide and a number of important tax and growth assumptions.
From EmergDoc's Roth Conversion Thread in the forum.
- This web site sells financial calculators for use in web sites. There's no description of how the results are calculated, use with caution.
Security: member contributions contains a list of calculators submitted by Bogleheads forum members.
The ssa.tools third-party online calculator calculates your PIA based on (1) past Social Security earnings record as well as (2) estimated future estimated earnings and number of additional years of earnings. It requires you to gather your earnings record from the ssa.gov site and then copy and paste that info into the tool. It also explains the calculations and the effect or early or delayed claiming.
Social Security Administration
The Social Security Administration maintains several benefit calculators to estimate your potential benefit amounts using different retirement dates and levels of future earnings. In general,
- If your entry for current earnings is greater than zero, it will be used to estimate annual future earnings.
- All earnings are indexed to the national average wage index (AWI). Future earnings are indexed with estimated increases in the AWI. Earnings are indexed only to age 60 (two years prior to the first year of eligibility, 62); later earnings are used at face value. These increases are derived from the "intermediate" assumptions in the OASDI Trustees Report.
- Although Social Security documentation suggests that future benefits are increased with estimated cost-of-living adjustments (COLAs), the estimates from my Social Security, Retirement Estimator, and the default Detailed Calculator (AnyPIA) do not project benefit increases beyond the current year. AnyPIA does offer the following increased benefit options:
- Alternative I (optimistic) assumptions from the most recent OASDI Trustees Report.
- Alternative II (intermediate) assumptions from the Trustees Report.
- Alternative III (pessimistic) assumptions from the Trustees Report.
- No benefit increases after the last known increase (default).
- User-specified benefit increase for each projected year.
- The closer you are to retirement, with a longer work history and fewer future changes, the more accurate your estimates will be.
|Features||Quick Calculator 1||Online Calculator 2||Retirement Estimator 3||Detailed Calculator|
|Past earnings||estimated, but annual entries in past dollars optional; indexed earnings not shown||annual entries in past dollars; indexed earnings not shown||accesses actual Social Security record; indexed earnings not shown||annual entries in past dollars; indexed earnings are shown|
|Future earnings||average annual entry in today's dollars; indexed earnings not shown||average annual entry in today's dollars; indexed earnings not shown||multiple filing ages and average annual entries in today's dollars; indexed earnings not shown||annual entries in today's dollars; indexed earnings are shown|
|Accuracy||rough||better||better; recommended by Social Security||best; recommended by Social Security|
|Survivor or disability estimate||yes||no||no||yes|
|Windfall Elimination Provision (WEP)||no||WEP Version available||no||yes|
1 Estimates past earnings from current with a national average wage index, modified by a relative growth factor. Past earnings can be adjusted by changing the growth factor or editing the annual numbers, but you cannot project future earning changes.
3 You must currently have enough credits to qualify for benefits. You cannot be currently receiving benefits on your own Social Security record, be waiting for a decision about your Social Security or Medicare application, or be 62 or older and receiving benefits on another Social Security record.
You can enter multiple ages to stop work with the "Add a New Estimate" button; future earnings will stop and benefits will start at that age. Benefit filing and stop-work ages cannot be entered separately, but future earnings can be entered as zero. If you enter a stop-work age of less than 62, benefits will be estimated starting at 62, the first year of eligibility. Examples of the new estimate input and output forms are shown below (click on the image for full size):
4 Runs on the following operating systems: Windows 2000/XP/Vista/7/8/10 and Mac OS 10 (up to 10.6, but not later).
- Yahoo! Finance Charts - nice interface, but does not factor in dividend distributions as stockcharts.com are reported to do
- Big Charts
- ClearStation - nice charts, also each stock/fund you chart displays news, user recommendations
- Also worth checking out Google Finance as they are making big strides at last
- Green Street Advisors has a chart of REIT prices vs. their fair value estimate
A Federal income tax spreadsheet calculator that will prepare the form 1040 and many of the supporting 1040 forms. The creator, Glenn Reeves, doesn't guarantee that they meet the formatting requirements of the IRS. He has been providing this model, updated yearly, since 1996.
An Excel spreadsheet providing a quick way to estimate federal and state taxes. Federal calculations include most credits and additional taxes, including ACA and IRMAA effects, and have been very accurate as estimates go. State calculations include brackets but not all state tax laws.
Among the many web-based estimators, this one from mortgagecalculator.org seems the most comprehensive.
See US and state income tax calculator - Bogleheads.org for more discussion.
If an investment is taxable, the yield is after taxes are paid (not before). Use these calculators to find the yield that's equivalent to a tax-exempt investment.
- Vanguard Taxable-Equivalent Yield Calculator
- Boglehead tfb's Bond Fund Yield Calculator, (the full article with instructions)
- You can also use this calculator to compare against a bank savings account, which is a federal and state taxable fund. APY is equivalent to compound yield.
- Bond Calculator, taxable equivalent bond yields (from Morningstar, login required)
- Determine whether you’re better off investing in taxable or municipal bonds.
- Daily Treasury Real Yield Curve Rates - daily rates for 5/7/10/20 year TIPS
- Daily Treasury Rates - daily rates for 1/3/6 month, plus 1/2/3/5/10/20/30 year bonds
- St Louis Fed 10 yr TIPS yield - this is a graph from 2003 to present, from Federal Reserve Economic Data (FRED)at the Federal Reserve Bank of St. Louis. 39,000 economic time series from 38 sources. Download, graph, and track economic data. Downloadable tools, such an iPhone/iPad app and an Excel Add-In are available.
- Bogleheads® forum post: , LadyGeek. August 01, 2021
- Bogleheads® forum post: , Tubes. August 09, 2021 and subsequent posts.