Calculate the net present value-internal rate of return

Assignment Help Financial Management
Reference no: EM131599697

You are considering three different projects, both of which will require a $50,000 investment with an 8% cost of capital. The projected income for each project over the next 5 years is outlined below. Year Project A Project B Project C 1 $5,000 $15,000 $15,000 2 $5,000 $25,000 $25,000 3 $15,000 $20,000 $10,000 4 $20,000 $5,000 $15,000 5 $20,000 $5,000 $2,000 a) In Microsoft Excel, Calculate the Net Present Value, Internal Rate of Return and Modified Internal Rate of Return for each of the projects.

Please show the exact formula used for each probelm in excel.

Reference no: EM131599697

Questions Cloud

What is the payback period for this project : Christopher Electronics bought new machinery for $5,015,000 million. What is the payback period for this project?
Find the future value of certificate of deposit : Find the future value of a $195,000 Certificate of Deposit that pays compounded interest every three months at the rate of 8% per year.
Showing the projected cash flows for the investment : Create a table showing the projected cash flows for the investment, assuming the next rental payment occurs one month from today.
Harley-davidson-external and internal analysis : Identify and analyze the major driving forces for change in the external environment of the motorcycle industry.
Calculate the net present value-internal rate of return : Calculate the Net Present Value, Internal Rate of Return and Modified Internal Rate of Return for each of the projects.
What is the year one operating cash flow : You work for the Thibodeaux Drilling Company, What is the Year 1 operating cash flow?
Pay the loan off by making your planned monthly payments : How much faster could you pay the loan off by making your planned monthly payments of $250 with the new card?
What is the optimal capital structure : Dilbert Jones Corporation (DJC) has a projected stable growth rate of 5.5%. What is the optimal capital structure for DJC?
What types of cost sharing in health insurance are effective : What types of cost sharing in health insurance are most effective?

Reviews

Write a Review

Financial Management Questions & Answers

  Evaluate whether this is good use of government funds

The government’s environmental protection agency uses a discount rate of 2% to evaluate whether this is a good use of government funds.

  To evaluate the performance of her portfolio

Susan has 40% of her portfolio invested in a mutual fund to track the S&P 500 and 40% in a mutual fund to track the Dow Jones Industrial Average (DJIA) and 20% in government securities. To evaluate the performance of her portfolio, Susan’s best bench..

  Based on the trade-off theory of capital structure

Suppose that an investor owns 10% of the stock of firm L, and assume that this investor can lend and borrow at the same interest rate as firm L, that is, at 12% (recall the assumption of perfect markets). Based on the trade-off theory of capital stru..

  Investments according to their expected returns

Use the approximate yield formula or a financial calculator to rank the following investments according to their expected returns. Buy a one-year, 5% note for $1,000 (assume that the note has a $1,000 par value and that it will be held to maturity).

  Should the investor exercise the call option or not

The XYZ Company expects stock prices to increase. The current stock price is $37. The company purchases a call option, with an exercise price of $40 and a premium of $2 per share. Assume instead that the stock price was $39 just before the expiration..

  Bond investment problem

Suppose an investor, desiring to earn a higher interest than the average paid by bank on savings, purchases two bonds, say bond A and bond B, and intends to sell them immediately after getting the third coupon payment. The characteristics of the two ..

  What should your first priority of investing be

How would Stephanie's investing decisions be different if she were a single mother of two children?- How would Stephanie's investing decisions be affected if she were 35 years old? If she were 50 years old?

  What was the average nominal risk premium on the stock

What was the average real return on the stock? What was the average nominal risk premium on the stock?

  Accounting break-even unit price unit variable cost

Accounting Break-Even Unit Price Unit Variable Cost Fixed Costs Depreciation

  What would the loan balance be in five years

Say that you purchase a house for $210,000 by getting a mortgage for $185,000 and paying a $25,000 down payment. If you get a 15-year mortgage with a 6 percent interest rate, what are the monthly payments? What would the loan balance be in five years..

  Compare the cross exchange rate with the direct rate

Determine the cross exchange rate between the Japanese yen and the Australian dollar. Compare the cross exchange rate with the direct rate. Are there any differences? Evaluate the significance of your results.

  Estimate total loan amount including interest carry for tag

What will be the release price for each type of lot?- Estimate the total loan amount including interest carry for TAG.

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!

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