This calculator works out the projected balance of a loan or investment at a future point, based on the starting amount, the interest rate, and the number of periods. You enter the principal, the annual interest rate, and the term, and the calculator returns the balance after each period and the total interest accrued. The projected balance is the estimated amount you will owe or own at a specific future date, assuming the rate and payments stay constant.
Formula
The projected balance after a certain number of periods is calculated using the compound interest formula for a series of payments:
Balance after k payments = P × (1 + r)^k − PMT × [((1 + r)^k − 1) / r]
Where:
- P = initial principal (loan amount or investment), in dollars.
- r = monthly interest rate, equal to the annual percentage rate divided by 12 (APR/12), expressed as a decimal.
- k = number of months (or periods) after the start.
- PMT = level monthly payment, in dollars, calculated as PMT = P × r / (1 − (1 + r)^(−n)), where n is the total number of months.
For an investment with no payments (a lump sum), the projected balance is simply P × (1 + r)^k.
Worked Example
Using the default values from the calculator: loan amount P = $20,000, annual rate APR = 8%, term = 5 years (60 months).
- Monthly rate r = 8 / 1200 = 0.0066667.
- Number of months n = 5 × 12 = 60.
- Monthly payment PMT = 20000 × 0.0066667 / (1 − (1 + 0.0066667)^(−60)) = 20000 × 0.0066667 / (1 − 0.6712) = 20000 × 0.0066667 / 0.3288 = 20000 × 0.020276 = $405.52 (rounded to the cent).
- Total interest = PMT × n − P = 405.52 × 60 − 20000 = 24331.20 − 20000 = $4,331.20.
The calculator shows a monthly payment of $405.52 and total interest of $4,331.20. The projected balance after, say, 12 months would be: 20000 × (1.0066667)^12 − 405.52 × [((1.0066667)^12 − 1) / 0.0066667] = 21659.99 − 405.52 × 12.419 = 21659.99 − 5036.06 = $16,623.93. This is the amount you would still owe after one year of payments.
Assumptions
- The interest rate is fixed for the entire term; variable rates would change the projected balance.
- Payments are made at the end of each month (ordinary annuity), not at the beginning.
- Interest compounds monthly at a rate of APR/12, which is standard for most loans and savings accounts.
- No fees, taxes, insurance, or penalties are included; those would increase the actual balance.
- For loans, the payment amount is constant and covers both principal and interest; for investments, no additional contributions are assumed unless specified.
How the Projected Balance Is Used
The projected balance is a planning tool. Lenders use it to show borrowers how much they will owe at various points in the loan term, which is why amortization schedules list a balance after each payment. Investors use it to estimate the future value of a lump sum or a series of deposits, helping them set savings goals. Budget planners use it to forecast debt levels or account balances months ahead, which informs cash-flow decisions. The key point is that the projection is only as good as the inputs: if the rate changes, or if you make extra payments, the actual balance will differ from the projection.
How to Choose the Right Term and Rate
When you use the calculator, you are effectively comparing different scenarios. The inputs you control are the loan amount, the interest rate, and the term. For a loan, a longer term reduces the monthly payment but increases the total interest paid; a shorter term does the opposite. For an investment, a longer term increases the projected balance because of compounding, but the rate you assume matters greatly. To get a realistic projection, use the current rate from your lender or financial institution, not a guess. The calculator’s default of 8% is just an example; your actual rate may be higher or lower. You can run multiple scenarios to see how the projected balance changes, but the calculator does not tell you which option is better—that depends on your budget and goals.
Common Mistakes and Misconceptions
- Using the annual rate directly in monthly calculations. Always divide the APR by 12 to get the monthly rate. For example, 8% APR becomes 0.6667% per month.
- Forgetting that payments reduce the balance. For loans, the projected balance is not simply the principal minus payments; interest is added each month before the payment is applied.
- Ignoring the effect of extra payments. If you pay extra, the balance drops faster and the projected balance will be lower than the standard calculation. The calculator assumes you pay exactly the required amount.
- Confusing APR with the nominal rate. APR includes certain fees and reflects the true cost, but the monthly rate is still APR/12 for this arithmetic.
- Rounding too early. If you round the monthly payment to $405.52 and then use that to compute the balance, you get a slightly different result than if you used the unrounded payment. The calculator rounds the payment for display but uses the full precision internally, so your manual check may differ by a few cents.
Limits of the Projection
The projected balance is a mathematical estimate, not a guarantee. Real-world factors can change the outcome: interest rates may adjust (if the loan is variable), you might miss a payment (incurring late fees and changing the balance), or you might make extra payments. The formula also assumes that the payment is made exactly on time every month; a few days’ delay can affect the interest accrual. For investments, the actual rate of return is uncertain, and taxes on interest or capital gains are not included. Therefore, the projected balance should be used as a planning guide, not as a precise prediction. Always check the lender’s amortization schedule or your investment statement for the actual figures.
Frequently Asked Questions
What is the difference between projected balance and current balance?
The current balance is the amount you owe or own right now, at this moment. The projected balance is an estimate of what that balance will be at a future date, assuming a constant interest rate and regular payments. For example, your current loan balance might be $15,000, but the projected balance after 6 more months could be $14,200, based on the amortization schedule.
Does the projected balance include interest?
Yes, for loans, the projected balance includes the interest that has accrued up to that point. The formula adds interest to the remaining principal each month, then subtracts your payment. For investments, the projected balance includes the compounded interest or returns earned on the principal.
How do extra payments affect the projected balance?
Extra payments reduce the principal faster, which means less interest accrues in future months. As a result, the projected balance at any future date will be lower than the standard projection. To see the effect, you would need a calculator that allows extra payments, because the formula here assumes a fixed payment schedule.
Why is the projected balance higher than the original loan amount early on?
In the early months of a loan, most of your payment goes toward interest, not principal. So after the first payment, the balance might be only slightly less than the original amount, and in some cases (if the payment is low relative to the interest), the balance could even increase. This is normal for loans with long terms or high rates.
Can I use the projected balance for a credit card?
Yes, but with caution. Credit cards have variable rates and minimum payments that change, so a single projection is less reliable. You can still use the formula to estimate the balance if you assume a fixed APR and a fixed payment, but the actual balance will likely differ because of new purchases and changing rates.
Is the projected balance the same as the payoff amount?
No. The payoff amount is the exact amount you need to pay today to close the loan, which may include accrued interest, fees, and a per-diem interest charge. The projected balance is a future estimate and does not include any fees or penalties. For a precise payoff figure, you must contact your lender.
This calculator provides an estimate for educational purposes; the exact figures are given in your lender’s disclosure or account statement.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Vanilla Credit Card Balance: What It Is & How to Check$70.00
- VI Credit Card Balance Check: How to See It$50.00
- Triple S Combo Card Balance: How to Check$75.00
- Transfer Credit Card Balance to Another Card? Guide
- Triple O Gift Card Balance: Check It Here
- Toys R Us Gift Card Balance: How to Check It$30.00