Question

In: Finance

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.

Solutions

Expert Solution

Payback Period for the PROJECT-A

Year

Cash Flows ($)

Cumulative net Cash flow ($)

0

-7,50,000

-7,50,000

1

2,50,000

-5,00,000

2

3,50,000

-1,50,000

3

2,50,000

1,00,000

4

2,00,000

3,00,000

Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 2.00 Year + ($150,000 / $250,000)

= 2.00 Year + 0.60 Years

= 2.60 Years

Payback Period for the PROJECT-B

Year

Cash Flows ($)

Cumulative net Cash flow ($)

0

-7,50,000

-7,50,000

1

2,00,000

-5,50,000

2

4,00,000

-1,50,000

3

1,00,000

-50,000

4

1,75,000

1,25,000

Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 3.00 Year + ($50,000 / $175,000)

= 3.00 Year + 0.29 Years

= 3.29 Years

DECISION

The Project-A Should be accepted, since it has the lower payback period of 2.60 Years.


Related Solutions

There are two mutually exclusive investment opportunities. The initial investment for both projects are $100,000. The...
There are two mutually exclusive investment opportunities. The initial investment for both projects are $100,000. The first investment will generate $20,000 per year in perpetuity. The second project is expected to generate $15,000 for the first year and the amount will grow at 2% per year after that. The first cash flow for both investments start at the end of the first year. a. Calculate the internal rate of return for both investments. b. Assume the cost of capital is...
A company is considering two mutually exclusive projects. Initial investment for Project A (IRR=32%) is 15,000...
A company is considering two mutually exclusive projects. Initial investment for Project A (IRR=32%) is 15,000 and for B (IRR=28%) 18,000. For both projects, life time of the projects is 5 years, required rate of return for both the projects is 10%. The net cash flows before the tax and depreciation are as given in the table below. For both projects tax of 40% on cash inflows is to be charged. Year 1 2 3 4 5 Project A 7000...
1. There are two mutually exclusive projects. Project A requires a $600,000 initial investment and is...
1. There are two mutually exclusive projects. Project A requires a $600,000 initial investment and is expected to provide $120,000 annual net cash inflows for 6 years. Project B requires a $740,000 initial investment and is expected to provide $200,000 annual net cash inflows for 4 years. Which project should you accept according to IRR method when your cost of capital is 10%? A. Project A B. Project B C. Both D. Neither of these 2. Leveraged IRR: A. estimates...
Suppose that a company has six non-mutually exclusive projects to consider for capital investment in table...
Suppose that a company has six non-mutually exclusive projects to consider for capital investment in table below. The company has only MM$300 available for investment. Which investment should be selected considering discount rate of 10%? Use NPV, GRR, and PI analysis. Discuss the results. Project 0 1 2 3 4 A - MM$100 + MM$20 + MM$40 + MM$60 + MM$80 B - MM$150 - MM$50 + MM$100 + MM$100 + MM$140 C - MM$60 + MM$20 + MM$40 +...
A company is considering two mutually exclusive projects. Both require an initial investment of $10,000 at t = 0
Using Excel (if applicable),A company 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 $8,000 and $7,000 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 cost or cash flows. Project Y has an expected life of 4 years with...
Projects A and B are mutually exclusive projects. Project A requires an initial investment today of...
Projects A and B are mutually exclusive projects. Project A requires an initial investment today of $300 and generates expected cash flows of $100 at the end of each of the next 5 years. Project B requires an initial investment today of $130 and generates expected cash flows of $55 at the end of each of the next 5 years. a. If you plotted the NPV profiles, what would be the "crossover rate" in the graph? (Note you are not...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT