User Account

All Pages

Compute the present value of a stream of cash flows

Assignment Help Financial Management
Reference no: EM131720245

Assignemnt

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.

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

Text Book: Financial Management: Theory and Practice by MICHAEL C. EHRHARDT and EUGENE F. BRIGHAM, THIRTEENTH EDITION.

Reference no: EM131720245

Questions Cloud

Define what punishment purposes should guide : What punishment purposes should guide you in making your decisions
Create an organizational chart to represent ideal structure : You should create an organizational chart to represent ideal structure for your current organization (or one with which you are familiar) and a written report
Follows a normal distribution with a mean : Let x be a continuous random variable that follows a normal distribution with a mean of 254 and a standard deviation of 35.
Major distinction between line and staff units concerns : The formal structures of organizations may be shown in a (n) ____. A major distinction between line and staff units concerns:
Compute the present value of a stream of cash flows : Compute 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.
Community follow a normal distribution with mean : The ages of adults in a certain community follow a normal distribution with mean 38.5 and standard deviation 6.68.
Discuss your findings here on the discussion board : Discuss your findings here on the discussion board. Are there differences in what a word can mean to different people
Prepare kelly and chanelle tax return form : Prepare Kelly and Chanelle's tax return Form 1040 and Schedules A, B, C, D, and SE for the current year. Thurston Co. was declared bankrupt during current year
Discussing a group project with one of your classmates : Assume you lost your temper when discussing a group project with one of your classmates.

Reviews

Write a Review

Financial Management Questions & Answers

  Property that produces an annual NOI

A property that produces an annual NOI of $100,000 was purchased for $1,200,000. Debt service for the year was $95,000 of which $93,400 was interest and the remainder was principal. Annual depreciation is $38,095. What is the taxable income?

  Determine the present worth of geometric gradient series

Determine the present worth of a geometric gradient series with a cash flow of $50,000 in year 1 and increases of 6% each year through year 8.

  Calculate the expected returns for roll and ross by filling

Calculate the expected returns for Roll and Ross by filling in the following table (verify your answer by expressing returns as percentages as well as decimals)

  What must coupon rate be on these bonds

Rhiannon Corporation has bonds on the market with 22.5 years to maturity, a YTM of 6.90 percent, and a current price of $1,057. The bonds make semiannual payments. What must the coupon rate be on these bonds?

  What is the present value of this stream of lease payments

what is the present value of this stream of lease payments?

  Many states prohibited bank branching

Many states prohibited bank branching because of all of the following except:

  Consider when analyzing these alternate investment vehicles

Elaine Tolbert is a 28-year-old management trainee at a large chemical company. She is single and has no plans for marriage. Her annual salary is $34,000 (placing her in the 15 percent tax bracket), and her monthly expenditures come to approximately ..

  Average accounting return-internal rate of return

There are several measures available to financial managers to assist them in deciding whether a specific project should be undertaken for the benefit of the company, including Average Accounting Return, Internal Rate of Return (IRR), Net Present Valu..

  Demonstrate return on the investment

When you anticipate that the facility will demonstrate a return on the investment. Need to see the formula for the ROI and how long will it take for the ROI to be realized.

  Often by issuing speculative or junk

Continuing with the RJR situation - an LBO means that the take-over company borrows an enormous amount of money (often by issuing speculative, or "junk" bonds) and uses those borrowed funds to buy-back the common stock. After the take-over, which of ..

  Relationship between present value and future value

What is the relationship between Present Value and Future Value?

  Firm reduced its net working capital investment

The 2014 balance sheet of Sugarpova's Tennis Shop, Inc., showed long-term debt of $5.9 million, and the 2015 balance sheet showed long-term debt of $6.1 million. Suppose you also know that the firm’s net capital spending for 2015 was $1,440,000, and ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd