Annuity Calculations in Excel – FV, PV, PMT, N | Simple - Ordinary (END) & Due (BGN)
PROBLEMS SOLVED
Future Value (FV):
Calculate the future value of $3000 invested at the end of each year for 15 years at 8.4% compounded annually.
Present Value (PV):
How much was borrowed at 7.89% compounded quarterly if paid off with $1288 every 3 months for 9 ¼ years?
Periodic Payment (PMT):
What monthly payment will reduce a $17000 loan to $5000 at 6.59% compounded monthly over 6 years?
Number of Payments (N):
How long will it take to repay a $78,000 loan with monthly payments of $1500 if interest is 10.39% compounded monthly?
00:00 Intro
00:21 Future value calculation (FV)
01:58 FV Begin mode & Interest Calculation
02:24 Present value calculation (PV)
04:14 PV Begin mode & Interest Calculation
04:54 Periodic Payment calculation (PMT)
07:14 Number of Payments, N
General Annuities -Calculating FV & PV: • General Annuity Problems Solved in Ex...