FIN 419 help A Clearer path to student success/uophelp.com FIN 419 help A Clearer path to student success/uop | Page 13
This Tutorial comes with a excel sheet
P3-1
Future Value. Fill in the future values for the following table using one of the
three methods below:
a. Use the future value formula, FV = PV*(1+r)n.
b. Use the TVM keys from a calculor.
c. Use the TVM function in a spreadsheet.
P3 – 4
Future Value. Grand opening Bank is offering a one-time
investment opportunity for its new customer. A customer opening a new
checking account can buy a special saving bond for $ 400 today , Which the
bank will compound at 8.5% for the next ten years. The savings bond must be
held for at least five years, but can then be cashed in at end of any year
starting with years five. What is the value of the bond at each cash-in date up
through year ten ?
What is the value of the savings bond at the end of year five ?
a. What is the value of the savings bond at the end of year five ?
b. What is the value of the savings bond at the end of year six?
c. What is the value of the savings bond at the end of year seven?
d. What is the value of the savings bond at the end of year eight?
e. What is the value of the savings bond at the end of year nine?
f. What is the value of the savings bond at the end of year ten?
P 3– 8
a. Use the present value formula, PV = FV*---
b. Use the TVM keys from a calculator.
c. Use the TVM function in a spreadsheet.
P3-15