Present Value pv(rate, # of periods, payment, fv) Present value of a one-time payment of $1,000 received three years from now, discounted at 10%? Present value of a one-time payment of $1,000 ten years from now, discounted at 5%? Present value of $1,000 received five years from now and another $1,000 received 10 years from now at 5%? Present value of an ordinary annuity -pv(rate, #of periods, payment) Present value of $1,000 payments for three years discounted at 5%? Present value of $1,000 payments for ten years discounted at 10 %? Present value of $1,000 payments for 5 years at 5% and then 5 payments of $1,500 starting in year 6 for 5 years at 6% Present value of a series of payments made at end of each year discounted at 10%; $1,000; $1,500; $2,000; $2,500; $3,000? PV $1,000 PV $1,500 PV $2,000 PV $2,500 PV $3,000 Total

Future Value FV (rate, # of periods, pmt, PV) What's the FV of $1,000 invested at 5% for 5 yrs? What's the FV of $1,000 invested at 10% for 5 yrs? What's the FV of $1,000 invested at 10% for 10 yrs, and then $1,500 invested at 10% for five years starting in yr. 6 FV $1,000 FV $1,500 How would these be different if the interest was compounded quarterly? Future Value of a series of payments (assume ordinary annuity) What's the FV of 5 $1,000 payments invested at 6%? What's the FV of 10 $2,500 payments invested at 8%? What's the FV of 10 $2,000 payments invested for 10 years at 5% plus the FV of 5 $2,500 payments invested for years 6-10 at 6%? FV 5 $2,000 FV 5 $2,500

Calculate a payment =-pmt(rate, # of periods,pv) What's the monthly payment to retire a 30 yr mortgage at 6% if you borrowed $250,000?