Reference no: EM131570836
Time Value of Money
When the Genesis Energy and Sensible Essential teams held their weekly meeting, the time value of money and its applicability yielded an extremely stimulating discussion.
However, most of the team members from Genesis Energy were very perplexed. Sensible Essentials decided the most expedient way to demonstrate how interest rates as well as time impact the value of money was to use examples.
You have been asked to prepare a report analyzing your findings of the three example calculations listed below.
In this assignment, you will do the following:
Calculate the future value of $100,000 ten years from now based on the following annual interest rates:
2%
5%
8%
10%
Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows:
Year 1 = $100,000
Year 2 = $150,000
Year 3 = $200,000
Year 4 = $200,000
Year 5 = $150,000
Years 6-10 = $100,000
Calculate the present value of the cash flow stream in problem 2 with the following interest rates:
Year 1 = 8%
Year 2 = 6%
Year 3 = 10%
Year 4 = 4%
Year 5 = 6%
Years 6-10 = 4
Perform your calculations in an Excel spreadsheet. Copy the calculations in a Word document. In addition, write a 2- to 3-page executive summary in Word format.
Your summary should reflect a proper analysis of your findings, including a comparison and contrast of data. Apply APA standards to citation of sources.
|
What are the risks for the company
: What are the risks for the company? Provide balanced answer that looks at "big picture" of profit and satisfaction. What change would you suggest for industry?
|
|
Identify a message in advertising
: Identify a message in advertising. Describe how you perceive the message of the advertisement. Try to determine the reality of the advertisement.
|
|
External financing need if sales increase
: The firm pays no dividends. Assume assets, costs and current liabilities vary with sales. What is the external financing need if sales increase by 8 percent?
|
|
Determine the fundamental causes of social problems
: Determine the fundamental causes of social problems such as crime, poverty, or homelessness and then recommend solutions.
|
|
Calculate the present value of a stream of cash flows
: Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows.
|
|
What is the npv of the equipment at 5 percent
: Southside Rehabilitation Center wants to buy a piece of equipment for $20,000 with projected cash flows of $8,000 per year during the equipment's six-year.
|
|
What is the payback period
: Community Hospital wants to buy equipment for $30,000 with projected cash flows of $7,000 per year during the equipment's six-year useful life.
|
|
Percentage change in operating cash flow
: At an output level of 47,000 units, you calculate that the degree of operating leverage is 3.1. The output rises to 53,000 units.
|
|
Further deposits or? withdrawals
: If you make no further deposits or? withdrawals, how much will you have in the account in 5 ?years?
|