Reference no: EM131664148
Assignment: Time Value of Money Calculations
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
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?
|
How to encourage employees to stay longer in the job
: The manager must be able to solve problems, communicate, and lead teams toward the completion of a task.
|
|
Advantage of the human microbiota
: A mutation occurs in Gene A that halts transcription early in the gene. What effect will this have on the levels of proteins produced by Genes A, B, and C?
|
|
Producer of variety of trophies-awards-plaques and medals
: Betty is the President and CEO of ATT Trophies, a producer of a variety of trophies, awards, plaques, medals, etc.
|
|
Analyze results obtained in cash conversion cycle equations
: Analyze the results obtained in the cash conversion cycle equations. Propose strategies to increase the cash flows of the company under study.
|
|
What salary should daughter start to reach her goal
: If your daughter wants to earn $215,000 within the next twenty-three years and salaries grow at 4.45% per year. What salary should she start to reach her goal?
|
|
The current supplier diversification arrangement
: What is the expected monetary value (cost) of the current supplier diversification arrangement?
|
|
Determining the types of media
: Based only on the (made-up) information given about the following types of media, state whether they are selective
|
|
Describe how you feel you improved your knowledge
: Assess the course objectives you still do not understand and suggest how to improve the course to meet those objectives.
|
|
Perform the anal isolation and obtain single colonies
: You perform the anal isolation and obtain single colonies on the EMB agar plate. From this you (CAN/CANNOT) conclude that you have a pure culture.
|