Question

In: Accounting

ABC Company has 2 mutually exclusive investment options. Information on the two options is reported below:...

ABC Company has 2 mutually exclusive investment options. Information on the two options is reported below:

Option A Option B

Initial Investment $150,000 $350,000

Year 1 return $45,000 $100,000

Year 2 return $55,000 $110,000

Year 3 return $60,000 $125,000

Year 4 return $70,000 $110,000

Year 5 return $55,000 $75,000

Year 6 return $60,000

Year 7 return $45,000

Calculate the IRR, NPV (assume a 5% discount rate for NPV calculation), Profitability Index and Payback period for both investments and then determine which one you would choose and explain why.

Solutions

Expert Solution

Solution:

Computation of IRR
Period Project A Project B
Cash inflows IRR Cash inflows IRR
0 -$150,000.00 30.94% -$350,000.00 15.31%
1 $45,000.00 $100,000.00
2 $55,000.00 $110,000.00
3 $60,000.00 $125,000.00
4 $70,000.00 $110,000.00
5 $55,000.00 $75,000.00
6 $60,000.00
7 $45,000.00

Computation of NPV and Profitability index
Particulars Period PV Factor Project A Project B
Amount Present Value Amount Present Value
Cash outflows:
Initial investment 0 1 $150,000 $150,000 $350,000 $350,000
Present Value of Cash outflows (A) $150,000 $350,000
Cash Inflows
Year 1 1 0.95238 $45,000.00 $42,857 $100,000.00 $95,238
Year 2 2 0.90703 $55,000.00 $49,887 $110,000.00 $99,773
Year 3 3 0.86384 $60,000.00 $51,830 $125,000.00 $107,980
Year 4 4 0.82270 $70,000.00 $57,589 $110,000.00 $90,497
Year 5 5 0.78353 $55,000.00 $43,094 $75,000.00 $58,764
Year 6 6 0.74622 $60,000.00 $44,773
Year 7 7 0.71068 $45,000.00 $31,981
Present Value of Cash Inflows (B) $322,011 $452,253
Net Present Value (NPV) (B-A) $172,011 $102,253
Profitability index (B/A) 2.15 1.29
Computation of Cumulative Cash flows
Period Project A Project B
Cash inflows Cumulative Cash Inflows Cash inflows Cumulative Cash Inflows
1 $45,000.00 $45,000.00 $100,000.00 $100,000.00
2 $55,000.00 $100,000.00 $110,000.00 $210,000.00
3 $60,000.00 $160,000.00 $125,000.00 $335,000.00
4 $70,000.00 $230,000.00 $110,000.00 $445,000.00
5 $55,000.00 $285,000.00 $75,000.00 $520,000.00
6 $60,000.00 $345,000.00
7 $45,000.00 $390,000.00

Payback period Project A = 2 years + ($150,000 - $100,000) / $60,000 = 2.83 years

Payback period - Project B = 3 years + ($350,000 - $335,000) / $110,000 = 3.14 years

On the basis of above analysis i will choose project A as its IRR is higher than IRR of project B. IRR is the best measure for decision making. Further NPV and profitability index of project A is higher than Project B. Therefore Project A is best to choose.


Related Solutions

ABC Company has 2 mutually exclusive investment options. Information on the two options is reported below:...
ABC Company has 2 mutually exclusive investment options. Information on the two options is reported below: Option A Option B Initial Investment $150,000 $350,000 Year 1 return $45,000 $100,000 Year 2 return $55,000 $110,000 Year 3 return $60,000 $125,000 Year 4 return $70,000 $110,000 Year 5 return $55,000 $75,000 Year 6 return $60,000 Year 7 return $45,000 Calculate the IRR, NPV (assume a 5% discount rate for NPV calculation), Profitability Index and Payback period for both investments and then determine...
I. VDSL Company has two mutually exclusive projects. Below is a table representing the initial investment...
I. VDSL Company has two mutually exclusive projects. Below is a table representing the initial investment and cash flows for these projects over four (4) years. Project A Project B Year Cash Flow Cash Flow $ $ 0 -750,000 -750,000 1 250,000 200,000 2 350,000 400,000 3 250,000 100,000 4 200,000 175,000 If the company wishes to recover the investment in 2.5 years, calculate the payback period of each project and determine which project is the best investment.
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year...
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year Project A Project B 0 -$1,000 -$1,000 1 600 300 2 600 600 3 600 900 If the cost of capital is 10%, which investment(s) should the company select? Both Project A and Project B Project B with a NPV of $444.78 Project B with a NPV of $276.31 Project A with a NPV of $493.11 Project A with a NPV of $253.64
ABC Company is considering investing in two mutually exclusive projects, L and S. The two projects’...
ABC Company is considering investing in two mutually exclusive projects, L and S. The two projects’ forecasted cash flows are shown as below. WACC is 10%. Year 0 1 2 3 4 Project L CF ($) -1,000    700 500 200 0 Project S CF ($) -1,200 100 300 800 1,000 a. Calculate the NPVs for both projects. b. Calculate the IRRs for both projects. c. Calculate the Discounted Paybacks for both projects. [Draw a timeline] d. Based on your...
The Box Company was confronted with the two mutually exclusive investment projects, A and B, which...
The Box Company was confronted with the two mutually exclusive investment projects, A and B, which have the following after-tax cash flows: Cash Flows, per Year ($) Project                                0                1                         2                   3                          4 A                                   (12,000)        5,000               5,000              5,000                5,000 B                                   (12,000)            Nil                     Nil                    Nil            25,000 Based on these cash flows: (a) Calculate each project’s NPV and IRR. (Assume that the firm’s cost of capital after taxes is 10 percent.) (b) Suggest to the management as to which project to...
The manager of a canned-food processing plant has two mutually exclusive labeling machine options. On the...
The manager of a canned-food processing plant has two mutually exclusive labeling machine options. On the basis of a rate of return analysis with a MARR of 9% per year, determine which model is economically better Model X Y First cost, $ -50,000 -90,000 AOC, $ per year -6,000 -4,000 Salvage value, $ 10,000 15,000 Life, years 5 10
There are two mutually exclusive projects, where the basic information is provided below. Assume a DN...
There are two mutually exclusive projects, where the basic information is provided below. Assume a DN alternative does not exist. MARR is 10% per year. Which project do you choose and why? Long term Short Term (Lease) Initial Cost $45,000 $15,000 Major overhaul costs (every ten years) $12,000 Not existent Minor overhaul costs (every 5 years) $6000 Not existent Annual Operating cost $2000 $1500 Useful Life Infinity 10 Salvage value $1,500 $2,500 (deposit return)
An entrepreneur has a choice of two mutually exclusive investment projects, Project A and Project B....
An entrepreneur has a choice of two mutually exclusive investment projects, Project A and Project B. Each lasts for one time period and the firm has no other projects. Project A will result in a cash flow of £27 million in the good state and £10 million in the bad state. Each outcome is equally likely. Project B will result in a cash flow of £34 million in the good state and zero in the bad state. Each outcome is...
A firm has two mutually exclusive investment opportunities, Alpha and Beta. Returns on the projects are...
A firm has two mutually exclusive investment opportunities, Alpha and Beta. Returns on the projects are as follows: Project Alpha: returns $300 million after one year with probability 40% and $50 million after one year with probability 60%. Project Beta returns $180 million after one year for certain. Assume that all investors are risk-neutral so that present values can be calculated by discounting expected future cash flows at the risk-free interest rate of 5% per year. Also, assume that all...
A company is considering three mutually exclusive projects with the below provided information. Which project the...
A company is considering three mutually exclusive projects with the below provided information. Which project the company should accept if its cost of capital is 10%?                                                                                                                                                 Preject Project’s Life in years Initial Investment PV of Net Cash Flows at 10% X 7 -17,000 23,000 Y 6 -16,000 21,000 Z 7 -16,000 21,000 Select one: a. Project Z b. Project X c. Project Y d. Projects X and Y
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT