User Account

All Pages

Compute the future value of the cash flows

Assignment Help Financial Management
Reference no: EM131962448

Given the following data, use Excel's syntax (and show the formulas) to calculate the MIRR for a project with an expected economic life six years and a salvage value of $1,000 (the last data entry). The end-of-period cash flows are expected to increase at the rate of 10% per annum.

Project data:

outlay cost: -$10,000

Estimated end-of-period cash flows: -$2,000, $5,000, $4,000, $3,000, $5,000, and $1,000

To estimate the MIRR, compute the Future Value of the cash flows at the rate of ten per cent and solve for the discount rate that discounts this future value back to the present value of $10,000.

Please explain the process and the results in a written PROFESSIONAL MANNER.

Reference no: EM131962448

Questions Cloud

What is the best estimate of stock current market value : The required return on this stock is 14%. What is the best estimate of the stock’s current market value?
What is the required rate of return on stock : What is the required rate of return on this stock? That is, solve for r.
The dividend is expected to grow at some constant rate : The dividend is expected to grow at some constant rate, g, forever. What is the growth rate (i.e. solve for g)?
What is the stock expected price three years from today : The required rate of return on the stock is 14.4%. What is the stock's expected price 3 years from today (i.e. solve for P3)?
Compute the future value of the cash flows : compute the Future Value of the cash flows at rate of ten per cent and solve for discount rate that discounts future value back to value of $10,000.
Compute the future value of the cash flows : compute the Future Value of the cash flows at rate of ten per cent and solve for discount rate that discounts future value back to value of $10,000.
Lenders take all the interest rate risk : Which of the following is the same synthetic position as short stock, long call? For CAM loans, lenders take all the interest rate risk.
What is beas unlevered beta : What is BEA's unlevered beta? Use market value D/S (which is the same as wd/ws) when unlevering. What are BEA’s WACC and total value of the firm with 45% debt?
What quarterly payment will the friend make on the loan : The deal calls for a 6.92% APR “loan” rate with quarterly compounding. What quarterly payment will the friend make on the loan?

Reviews

Write a Review

Financial Management Questions & Answers

  Trust has been established to fund scholarship in perpetuity

A trust has been established to fund scholarships in perpetuity.

  What is the annual equal amount of money

What is the annual equal amount of money you have to set aside to guarantee yourself an annual income to perpetuity of $65,000 starting in 41 years from now?

  How long would it take for your investment to double

If your investment doubles in 6 3/4 years, what approximate annual rate of return would you have earned? If you could earn an annual rate of 7.50%, approximately how long would it take for your investment to double?

  How do warrants-convertible bonds differ from call options

How do warrants and convertible bonds differ from call options? Why would a corporation issue warrants or convertible bonds?

  What is the most profitable price point

You are hired by the health care provider Parma Group. Your boss says, identify the most profitable price point for a new drug. The facts utilized for proper analysis are as follows: 2 million people are using the drug, a survey says for every yearly..

  What is present value

What is the present value of $2,925 per year, at a discount rate of 8 percent, the last payment is received 23 years from now?

  Using insurance to protect against risk of financial loss

Discuss how people might go about the applying the large loss principle when using insurance to protect against the risk of financial loss.

  Produce after-tax cash flows

You are presented a proposal for a project. The project costs $10 million and will produce after-tax cash flows of $2 million at the end of year 1, $4 million at the end of year 2, and $8 million at the end of year 3. What is the NPV of this project ..

  Company to lease some type of capital equipment

Provide two reasons for a company to lease some type of capital equipment, rather than buying it. Provide three reasons for a company to buy some capital equipment, rather than lease it.

  Which of the authors is correct

One author says that duration is the weighted average life of a financial instrument. A different one says that duration is a measure of elasticity. Which of the authors is correct? Or, are they both correct?

  Fast-growing firm recently paid dividend

A fast-growing firm recently paid a dividend of $0.65 per share. The dividend is expected to increase at a 20 percent rate for the next four years. Afterwards, a more stable 10 percent growth rate can be assumed. If an 11.5 percent discount rate is a..

  How much will balloon payment be in eight years

Audrey Sanborn has just arranged to purchase a $530,000 vacation home in the Bahamas with a 20 percent down payment. The mortgage has a 5.9 percent APR, compounded monthly, and calls for equal monthly payments over the next 30 years. How much will Au..

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