User Account

All Pages

Calculate the internal rate of return for project

Assignment Help Corporate Finance
Reference no: EM13195212

The initial cash outlay (in year 0) and resulting cash inflows for three competing projects are presented below. Calculate the internal rate of return for each project (1-3) below using a formula in Excel. Which project would you choose? What if you only had $12,000 in year 0, and the cost of borrowing additional money was prohibitively high?



Project 1 Project 2 Project 3
Year 0  $               (8,000)  $             (25,000)  $             (10,000)
Year 1  $                3,000  $                1,000  $                1,000
Year 2  $                3,000  $                3,000  $                2,000
Year 3  $                3,000  $                8,000  $                3,000
Year 4  n/a   $              10,000  $                4,000
Year 5  n/a   $              20,000  $                5,000




IRR      




Using the same IRR formula, calculate the internal rate of return for project 4. Why is the result an error?


 Project 4
Year 0  $                5,000
Year 1  $                1,000
Year 2  $                2,000
Year 3  $                3,000
Year 4  $                4,000
Year 5  $                5,000


IRR  

Reference no: EM13195212

Questions Cloud

Current state of valuing intellectual property : Discuss this issue and prepare a 3-4 page management brief for Acme's upper management group on the current state of valuing intellectual property.
Sodium sulfate is dissolved to give a nominal concentration : A solution contains 0.010 M silver ion and 0.0010 M lead(II). Sodium sulfate is dissolved to give a nominal concentration of 0.0010 M sulfate. Does a precipitate form?
How far is the balloon from the western station : Two tracking stations are on the equator 124 miles apart. A weather balloon is located on a bearing of N 34deg E from the western stations and on a bearing of N 16deg E from the easter station. How far is the balloon from the western station?
What is the approximate age of the artifact : ]an artifact is discovered at a certain site. if it has 73% of the carbon 14 it originally contained, what is the approximate age of the artifact? (carbon 14 decays at the rate of .0125% annually)
Calculate the internal rate of return for project : Calculate the internal rate of return for project 4. Why is the result an error - What if you only had $12,000 in year 0, and the cost of borrowing additional money was prohibitively high?
Compute how much work is done in kilojoules : How much work is done in kilojoules when the volume of a cylinder goes from 2L to 3L and stays at 2.5 atm? Are the surroundings doing work on the system or system doing work
What are the dimensions of the second triangle : a 7 ft by 9 ft rectangle is similar to a second rectangle whose perimeter is 260 ft, what are the dimensions of the second triangle?
Describe fractional partsso that a child can understand it : Describe fractional partsso that a child can understand it. What are the two distinct requirements of fractional parts? Explain how children's concepts of partitioning need to be refined to produce a concept of fractional parts.
How tall is the cellphone tower : a 6 ft vertical post casts a 10 in shadow at the same time a nearby cell phone tower casts a 115 ft shadow. How tall is the cellphone tower.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Calculate firms expected fixed assets turnover ratio

Girard Corporation had sales of 1,120,000 dollar past year on fixed assets of $270,000. However, Girard's fixed assets were being used at only 90 percent of capacity.

  List the cash flows paid by the gdp-linked warrants

Compute the overall value of the securities received through the PSI as a percentage of the face value of the "Old Greek Bonds". Would you participate in the Greek debt exchange agreement?

  Multiple choice questions based on asset management

Shanklin Company buys merchandise on terms of 2/15, net 40, & its total gross buys are $800,000 per year. Find the maximum amount of costly trade credit.

  Evaluate what is the value of a put options

Evaluate what is the value of a put options written on the stock with the same exercise price and expiration date as the call option?

  Analyze cost using the cost classifications

Suppose you are working on a big project for the hospital's CFO. Together, you will create a system to justify the full time employees of laboratory department.

  Explain why the issuing corporation charged

On March 31, 2011, Gardner Corporation received authorization to issue $50,000 of 9 percent, 30-year bonds payable. The bonds pay interest on March 31 and September 30. The entire issue was dated March 31, 2011, but the bonds were not issued until..

  Calculate the dollar amount of dividends

Julio purchased a stock one year ago for dollar 27. The stock is now worth $32, & total return to Julio for owning the stock was 37%. Calculate the dollar amount of dividends that he received for owning the stock during the year?

  Explain the tax cost recovery methods

The Internal Revenue Code authorizes decrease for sell or business activities if the espenses is "ordinary and necessary" and also explain the tax cost recovery methods include amortization, depreciation, and depletion.

  Compute the required monthly payment

Suppose Mr. Johnson wants to buy a new home at Sugar Land in June 2010. The sale price of the home is $580,000. He considers paying 20 percent down payments. Compute  the required monthly payment.

  Evaluate leverage

Evaluate Leverage keeping the short-term debt as part of total debt

  Determine your annual tax

Assume you earn taxable income of 100,000 every year. You are subject to an MTR of 50 percent. Currently, your ATR is 35%t. Determine your annual tax and the extra tax that you would pay every year.

  Find all operating expenses

The current grill is being depreciated straight line over its useful life of 10 years after which it will have no salvage value.

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