Purpose of Assignment
The purpose of this assignment is to allow the students to understand and practice the measurement of present value, future value, and interest rate using Microsoft® Excel®.
Assignment Steps
Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template found in the resources section below.
Calculate the following time value of money problems using Microsoft® Excel®:
If we place $7,564 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 8.5 years?
What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent?
If you bought a stock for $45 dollars and could sell it fifteen years later for three times what you originally paid. What was your return on owning this stock?
Suppose you bought a house for $3,250,000 to make it a nursing home in the future. But you have not committed to the project and will decide in nine years whether to go forward with it or sell off the house. If real estate values increase annually at 1.5%, how much can you expect to sell the house for in nine years if you choose not to proceed with the nursing home project?
If your daughter wants to earn $219,000 within the next 24 years and the salaries grow at 4.45% per year. What salary should she start to reach her goal?
Include functional formulas utilized in Microsoft® Excel® for your answers presented (in other words – do not simply type answers in the spaces required).
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
