Question

In: Finance

Your firm is considering two projects that are mutually exclusive. Each project will require an initial...

Your firm is considering two projects that are mutually exclusive. Each project will require an initial outlay of $200,000. The forecast yearly cash flows are shown below. Time Project A Project B 0 -200,000 -200,000 1 -25,000 120,000 2 80,000 80,000 3 100,000 40,000 4 140,000 25,000

a) Calculate the payback period (undiscounted) of each project. Include fractional periods (e.g., x.xx years) in your response, if applicable. b) Calculate the IRR of each project. c) Calculate the Modified IRR (MIRR) of each project using an 8% discount rate. d) Calculate the NPV of each project at discount rates of 0%, 4%, 10%, and 16%). e) Calculate the incremental IRR (i.e., the cross-over rate) and construct an NPV profile graph to illustrate how the choice between the projects depends on the discount rate. Indicate when you should accept each project, making sure that you are explicit about the conclusions to be drawn from the NPV profile and provide specific numbers. (Do X if …; do Y if …; do Z if…)

Solutions

Expert Solution

We can calculate the desired results as follows:

Formulas used in the excel sheet are:

A) Payback Period of Project A = 3.32 years

Payback Period of Project B = 2 years

B) IRR of Project A = 12.27%

IRR of Project B = 16.77%

C) MIRR of Project A = 11.21%

MIRR of Project B = 11.82%

D i) NPV of Project A when Discount rate is 0% = $ 95,000

NPV of Project B when Discount rate is 0% = $ 65,000

ii) NPV of Project A when Discount rate is 4% = $ 58,498.26

NPV of Project B when Discount rate is 4% = $ 46,279.07

iii) NPV of Project A when Discount rate is 10% = $ 14,141.79

NPV of Project B when Discount rate is 10% = $ 22,334.54

iv) NPV of Project A when Discount rate is 16% = $ -20,712.17

NPV of Project B when Discount rate is 16% = $ 2,334.89

As there are multiple questions asked, I have solved the first 4 parts which has further sub parts. Please post the question separately for rest parts to be answered.

Hope I am able to solve your concern. If you are satisfied hit a thumbs up !!


Related Solutions

Pepsico is considering two mutually exclusive projects. Both require an initial investment of $10,000, and their...
Pepsico is considering two mutually exclusive projects. Both require an initial investment of $10,000, and their risks are average for the firm. Project X has an expected life of 2 years with after-tax cash inflows of $5,300 and $7,000 at the end of Years 1 and 2, respectively. Project Y has an expected life of 4 years with after-tax cash inflows of $3,700 at the end of each of the next 4 years. The firm's WACC is 8%. Use the...
Wilson Co. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at...
Wilson Co. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at t = 0. Project X has an expected life of 2 years with after-tax cash inflows of $7,000 and $8,500 at the end of Years 1 and 2, respectively. Project Y has an expected life of 4 years with after-tax cash inflows of $4,600 at the end of each of the next 4 years. Each project has a WACC of 11%. What is the...
Wilson Co. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at...
Wilson Co. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at t = 0. Project X has an expected life of 2 years with after-tax cash inflows of $7,000 and $8,000 at the end of Years 1 and 2, respectively. Project Y has an expected life of 4 years with after-tax cash inflows of $5,000 at the end of each of the next 4 years. Each project has a WACC of 10%. What is the...
ST Inc. is considering two mutually exclusive projects. Both require an initial investment of $9100 at...
ST Inc. is considering two mutually exclusive projects. Both require an initial investment of $9100 at t = 0. Project X has an expected life of 2 years with after-tax cash inflows of $5,500 and $8200 at the end of Years 1 and 2, respectively. In addition, Project X can be repeated at the end of Year 2 with no changes in its cash flows. Project Y has an expected life of 4 years with after-tax cash inflows of $4800...
Mulroney Corp. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at...
Mulroney Corp. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at t = 0. Project X has an expected life of 2 years with after-tax cash inflows of $6,000 and $7,800 at the end of Years 1 and 2, respectively. In addition, Project X can be repeated at the end of Year 2 with no changes in its cash flows. Project Y has an expected life of 4 years with after-tax cash inflows of $4,300...
Atlas Corp. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at...
Atlas Corp. is considering two mutually exclusive projects. Both require an initial investment of $10,000 at t = 0. Project S has an expected life of 2 years with after-tax cash inflows of $6,000 and $8,000 at the end of Years 1 and 2, respectively. Project L has an expected life of 4 years with after-tax cash inflows of $4,373 at the end of each of the next 4 years. Each project has a WACC of 9.25%, and Project S...
eBook Haley’s Crockett Designs Inc. is considering two mutually exclusive projects. Both projects require an initial...
eBook Haley’s Crockett Designs Inc. is considering two mutually exclusive projects. Both projects require an initial investment of $12,000 and are typical average-risk projects for the firm. Project A has an expected life of 2 years with after-tax cash inflows of $7,000 and $8,000 at the end of Years 1 and 2, respectively. Project B has an expected life of 4 years with after-tax cash inflows of $8,000 at the end of each of the next 4 years. The firm’s...
. Marian Ltd is considering two mutually exclusive projects with the following details: PROJECT A Initial...
. Marian Ltd is considering two mutually exclusive projects with the following details: PROJECT A Initial Investment $450,000 Scrap value in year 5 $20,000 Year 1 2 3 4 5 $000 $000 $000 $000 $000 Annual Cash Flows 200 150 100 100 100 PROJECT B Initial Investment $100,000 Scrap value in year 5 $10,000 Year 1 2 3 4 5 $000 $000 $000 $000 $000 Annual Cash Flow 50 40 30 20 20 Assume that the initial investments at the...
Marian Ltd is considering two mutually - exclusive projects with the following details: Project A Initial...
Marian Ltd is considering two mutually - exclusive projects with the following details: Project A Initial investment Le 450,000 Scrape value in year 5 Le 20,000 Year 1 2 3 4 5 ( Le000) ( Le000 ) (Le000) (Le000) ( Le000) Annual Cash flows 200 150 100 100 100 Project B: Initial investment Le 100,000 Scrape value in year 5 Le10,000 Year 1 2 3 4 5 ( Le000 ) ( Le000 ) ( Le000) ( Le000) ( Le000 )...
Marian Ltd is considering two mutually - exclusive projects with the following details: Project A Initial...
Marian Ltd is considering two mutually - exclusive projects with the following details: Project A Initial investment Le 450,000 Scrape value in year 5   Le 20,000 Year 1 2 3 4 5 ( Le000) ( Le000 ) (Le000) (Le000) ( Le000) Annual Cash flows 200 150 100 100 100 Project B: Initial investment Le 100,000 Scrape value in year 5 Le10,000 Year 1 2 3 4 5 ( Le000 ) ( Le000 ) ( Le000) ( Le000) ( Le000 )...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT