Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 27,500, PMT (each payment) = −425, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 10 payments (P/Y) and 12 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 0 because payments come at the end of each period (END)
Solve the equation for the missing N (ln is the natural logarithm): N = ln((PMT·(1 + i·k) − FV·i) ÷ (PMT·(1 + i·k) + PV·i)) ÷ ln(1 + i)
2. PMT: -587.84
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 30,000, PMT (each payment) = −587.84, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 11 payments (P/Y) and 9 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 0 because payments come at the end of each period (END)
Solve the equation for the missing PMT (g is short for (1 + i)^N): PMT = −(PV·g + FV) ÷ ((1 + i·k)·(g − 1) ÷ i)
3. PV: 26,490.49
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 26,490.49, PMT (each payment) = −600, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 16 payments (P/Y) and 10 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 0 because payments come at the end of each period (END)
Solve the equation for the missing PV (g is short for (1 + i)^N): PV = −(FV + PMT·(1 + i·k)·(g − 1) ÷ i) ÷ g
4. I/Y (annual interest rate): -6.924701%
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 31,000, PMT (each payment) = −400, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 13 payments (P/Y) and 14 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing I/Y (g is short for (1 + i)^N): I/Y: the rate that makes PV·g + PMT·(1 + i·k)·(g − 1) ÷ i + FV = 0, found numerically
5. FV: -6,062.58
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 26,000, PMT (each payment) = −450, FV (the amount at the end) = −6,062.58
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 15 payments (P/Y) and 7 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing FV (g is short for (1 + i)^N): FV = −(PV·g + PMT·(1 + i·k)·(g − 1) ÷ i)
6. FV: 8,404.44
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 22,000, PMT (each payment) = −600, FV (the amount at the end) = 8,404.44
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 12 payments (P/Y) and 9 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing FV (g is short for (1 + i)^N): FV = −(PV·g + PMT·(1 + i·k)·(g − 1) ÷ i)
7. I/Y (annual interest rate): 8.664023%
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 18,000, PMT (each payment) = −550, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 11 payments (P/Y) and 13 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 0 because payments come at the end of each period (END)
Solve the equation for the missing I/Y (g is short for (1 + i)^N): I/Y: the rate that makes PV·g + PMT·(1 + i·k)·(g − 1) ÷ i + FV = 0, found numerically
8. N (number of payments): 59.4195
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 25,000, PMT (each payment) = −500, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 9 payments (P/Y) and 11 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing N (ln is the natural logarithm): N = ln((PMT·(1 + i·k) − FV·i) ÷ (PMT·(1 + i·k) + PV·i)) ÷ ln(1 + i)
9. FV: 3,966.53
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 22,500, PMT (each payment) = −560, FV (the amount at the end) = 3,966.53
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 12 payments (P/Y) and 11 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing FV (g is short for (1 + i)^N): FV = −(PV·g + PMT·(1 + i·k)·(g − 1) ÷ i)
10. N (number of payments): 85.6349
Give each amount a sign so the money balances: money you receive is positive, money you pay out is negative. Here PV (today's amount) = 24,000, PMT (each payment) = −325, FV (the amount at the end) = 0
Turn the yearly rate (I/Y) into the rate for one payment period (i), using 15 payments (P/Y) and 14 compounding periods (C/Y) a year
Set up the one equation that ties all five keys together. N is the number of payments, and k = 1 because payments come at the start of each period (BGN)
Solve the equation for the missing N (ln is the natural logarithm): N = ln((PMT·(1 + i·k) − FV·i) ÷ (PMT·(1 + i·k) + PV·i)) ÷ ln(1 + i)