Inflation Calculator

You can download an Excel version of Inflation Calculator that lets you see how to use the FV and PV functions to perform some basic inflation calculations.

Credit Card Minimum Payment Calculator

The new Credit Card Payment Calculator lets you see how much it really costs to make minimum payments. Calculate the total interest and time to pay off. Compare to making a fixed monthly payment.

Paycheck Calculator

Use this Paycheck Calculator to estimate the effect of tax withholdings, allowances, 401(k) withholdings, pre-tax deductions, and post-tax deductions on your net take-home pay. It estimates federal tax withholdings using the tables from IRS Publication 15.

Home Equity Line of Credit Calculator

This new Line of Credit Calculator can be used to estimate payments for a Home Equity Line of Credit (HELOC) or other general revolving line of credit account. It is a fairly advanced (dare I say complicated?) spreadsheet with multiple payment options to choose from and a fancy variable rate simulation. Use at your own risk.

Credit Repair

Just finished a new Credit Repair edition of the Debt Reduction Calculator that helps you improve your FICO credit score by reducing debt down to specific balance-to-credit-limit ratios.

GPA Calculator

This new GPA Calculator helps you track your grades from semester to semester and calculates your cumulative GPA. You can also use it for doing what-if scenarios.

Annuity Calculator

This new Annuity Calculator can help you figure out how much you need to have saved for retirement. The Savings Calculator can help you figure out how much you will have saved by making regular contributions for a number of years. Then, the Annuity Calculator can help you figure out how long that savings will last you.

MACRS Depreciation Calculator

This new Depreciation Calculator can be used for basic depreciation calculations including straight-line (SL), sum-of-years' digits (SYOD), and declining balance (DB) methods. It also includes a worksheet for calculating the MACRS depreciation using the approach outlined by the IRS.

College Savings Calculator

This new College Savings Calculator helps you create an educational savings plan for your child. You can specify yearly costs for grades K-12 in additional to college costs. The monthly deposit amount is calculated based upon the costs, yearly deposits, and other deposits that you specify.

IRR and NPV Calculator

This NPV Calculator will show you how to use the NPV, IRR, XNPV, and XIRR functions in Excel.

Simple Loan Calculator

This simple Loan Calculator is meant as an educational tool to see examples of how to use various financial functions in Excel, including the PMT, PV, RATE, and NPER functions.

... more financial calculators

Mortgage Payment Calculator

This free Mortgage Payment Calculator is for comparing various fixed-rate mortgages side-by-side. It can be used for both US (monthly compounding) and Canadian (semi-annual compounding) mortgages and also allows you to enter extra monthly payments.

Break-Even Calculator

This new Break Even Analysis spreadsheet is helpful for analyzing the financial viability of a new venture or product. It calculates the break-even sales (number of sales required to break even), the break-even price, or the payback period. Each scenario is a separate worksheet within the workbook. The download page also includes detailed information about the formulas used to calculate the break-even point.

An Example: If the total fixed costs for the development and advertising of an iPhone application are $5,000 and the variable costs are 30%/unit and the sale price is $1.99, to break-even after 1 year would require about 300 sales per month (or about 10 per day).

Net Worth Calculator

This Net Worth Calculator is a spreadsheet template that I created while I was working on creating some other financial statements. It helps you calculate your personal net worth by providing a ready-to-use list of asset and liability categories.

Interest-Only Mortgage Loan Calculator

By request, I created a new loan calculator specifically for fixed-rate interest-only mortgage loans. It is based on my amortization schedule template, but allows you to enter the IO period in years and make extra payments during that time. At the end of the IO period, the loan is amortized using the current balance and number of years remaining.

Savings Interest Calculator

I just created a new Savings Calculator that estimates the interest earned in a savings account over time. It lets you include monthly and annual deposits, graphs your balance vs. investment, and creates an amortization table showing the interest earned each year.

401(k) Savings Calculator

The new 401k Calculator let's you estimate your future 401(k) balance at retirement. It is very simple to use and let's you include your employer match, annual raise. Perhaps the most unique feature of this spreadsheet is that it let's you specify a random rate of return so you can see how fluctuations in the market might affect your balance.

It also includes a worksheet that calculators Internal Rate of Return (IRR). It can be used to track your 401(k) over time. Any additional suggestions for this worksheet are welcome.

Debt Reduction

This new Debt Reduction Calculator / Debt Snowball Calculator can be used to help plan how to pay off all of your credit card balances, auto loans, student loans, personal loans, consumer loans, etc.

You first list all of your debts, then choose a total monthly payment, and as you pay off your debts, the payment is rolled over to help pay for your next one.

You can choose from a few different strategies, such as debt snowball (lowest balance first) or highest-interest-first, or you can choose the exact order you want to pay off your debts.

The download page includes additional information on the different strategies.

Home Mortgage Calculator

This new home mortgage calculator spreadsheet can be used for adjustable-rate (ARM) mortgages or fixed-rate mortgages. It can also be used to calculate the interest savings when making extra payments, and calculates tax returned based on the tax bracket you enter. As you pay down your loan, you pay less interest, and therefore the tax deduction decreases. Also, there is a big difference between the way a fixed-rate mortgage works vs. an variable-rate mortgage when making extra payments.

Credit Card Payoff Calculator

This is a fairly simple calculator, that lets you figure out how long it will take to pay off a credit card balance based on a particular monthly payment. Or, if you specify when you want to have it paid off, it will calculate what the monthly payment needs to be.