How much will our account accrue to in given years

Reference no: EM131935211

Question: 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

Calculate the following time value of money problems using Microsoft® Excel®:

1. If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years?

2. What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent?

3. 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?

4. 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?

5. If your daughter wants to earn $215,000 within the next twenty-three years and the salaries grow at 4.45% per year. What salary should she start to reach her goal?

Information related to above question is enclosed below:

Attachment:- FIN419_r6_wk2_Time_Value_of_Money_Template2.rar

Reference no: EM131935211

Questions Cloud

Briefly describe yourself on two personality dimension : Reflecting upon the learning activities you completed in this module, respond to each of the following prompts:

Post the journal entries from the general journal : "Post" the journal entries from the General Journal to the Excel spreadsheet of T-accounts in this file. All necessary T-accounts have been provided.

Individual suffering from parkinson disease : What affect do you think haloperidol would likely have in an individual suffering from Parkinson's disease?

Discuss the logistical implications associated : Discuss the logistical implications associated with the increased emphasis on the convenience associated with a family's shopping experience.

How much will our account accrue to in given years : If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years?

What are your thoughts about the distinction of gender : Analyze the main argument and the evidence. What is being argued? How does the author prove it?

What is the reason sawhill is regularly running out of towel : What is the reason Sawhill is regularly running out of towels? ow will the cycle time change with an additional washer and dryer? Suggest a solution to problem.

Should some levels of T and E fraud be forgiven : Should some levels of T&E fraud be forgiven? If this has happened in your organization, share how this was handled (don't give us the company name)?

Discuss sharing economy from a supply and demand standpoint : Discuss the sharing economy from a supply and demand standpoint. How do companies like Uber and Airbnb affect supply and demand in the markets for shared rides.

User Account

All Pages