Question
Using EXCEL, build a spreadsheet model for each of the following time-value-of-money problems. On your spreadsheet, you will calculate the solution to each problem in
Using EXCEL, build a spreadsheet model for each of the following time-value-of-money problems. On your spreadsheet, you will calculate the solution to each problem in two equivalent ways:
(1) Using the time-value-of-money mathematical formula
(2) Using the EXCEL time-value-of-money function
You must use cell referencing and formulas in your spreadsheet. All of your numbers must have no more than 2 decimal places. All of your work must be your own no sharing of spreadsheets.
For each problem, you will have three sections in your spreadsheet. The first section lists the name of each input and the corresponding numerical amount. The second section is the calculation using the mathematical formula, and the third section is the calculation using the EXCEL function.
Problems:
(1) What is the present value amount that is equivalent to $100 received at the end of 5 years, given a discount rate of 16% (compounded annually)?
(2) What is the present value amount that is equivalent to $100 received at the end of each year for 8 years, given a discount rate of 20%?
(3) Find the future value in 2 years of $100 that is deposited today in an account, which pays 12% compounded monthly.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started