Compute the present value of a stream of cash flows

Reference no: EM131282174

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:

1. Calculate the future value of $100,000 ten years from now based on the following annual interest rates:

a. 2%
b. 5%
c. 8%
d. 10%

2. Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows:

a. Year 1 = $100,000
b. Year 2 = $150,000
c. Year 3 = $200,000
d. Year 4 = $200,000
e. Year 5 = $150,000
f. Years 6-10 = $100,000

3. Calculate the present value of the cash flow stream in problem 2 with the following interest rates:

a. Year 1 = 8%
b. Year 2 = 6%
c. Year 3 = 10%
d. Year 4 = 4%
e. Year 5 = 6%
f. Years 6-10 = 4

Perform your calculations in an Excel spreadsheet.

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.

Reference no: EM131282174

Questions Cloud

Explain and evaluate financial environment at genesis energy : Describe and evaluate the financial environment at Genesis Energy by using ratio analysis of the company. Identify and explain two ways Genesis Energy can improve its strategy.

Trade-offs implied by the triple constraint discussed : How does EVM operationalize or put in to practice the management of trade-offs implied by the triple constraint discussed? Does it allow a balanced appraisal of all three parameters? Why or why not?

Determining the healthcare report model : State clearly the objective, or purpose, of the report. In the healthcare report model, this paragraph might explain how the report demonstrates that a change in the organization or department would be beneficial to the organization. The goal of t..

Explain the concept of working capital and its importance : Explain the concept of working capital and its importance to Genesis Energy. Describe the mechanism and methodology used to ensure that operational needs are met through short-term financing.

Compute 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%. Calculate the present value of the cash flow stream in problem 2 with the following interest rates.

Labor relations strategies : How do you believe that unions (Labor Relations Strategies) would react to each of the strategies discussed in Question #1 above? Explain

Explain the potential costs and benefits of each option : Analyze the potential costs and benefits of each option. Explain how relative risk (from the investor's perspective) impacts the cost of capital for Genesis Energy.

Theories in vocational and technical education : Write on the various importance of curriculum theories in vocational and technical education

Management practices of planning-leading : This assignment focuses on how the management practices of planning, leading, organizing, staffing, and controlling are implemented in your workplace. If you are not currently working, you may use a previous employer. In this assignment, you must:

User Account

All Pages