Question

In: Finance

A company is considering three capital budgeting projects. Data relative to each is given below. Each...

A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the Net Present Value (NPV) method to evaluate capital budgeting projects and its discount rate is 9%.

Project A         Project B         Project C

Initial cash outlay (cost)                     -$5,000,000     -$6,000,000     -$2,500,000

Cash inflows per year                           $1,500,000    $1,800,000     $600,000

Residual value                                       $ 500,000              0                $100,000

  1. If the projects are mutually exclusive, which, if any, should the company accept?  Why?

  1. If the projects are independent, which, if any, should the company accept?  Why?
  1. One of the company’s managers states “To me, no matter what else we do, Project C needs to be our first choice because it has the lowest initial cost of $2,500,000.”  Comment on this manager’s proposal, considering the concepts of NPV and Payback Method.

Solutions

Expert Solution

CALCULATION OF NPV: Project A Project B Project C
Initial cost $ -50,00,000 $ -60,00,000 $ -25,00,000
Cash inflows per year $   15,00,000 $   18,00,000 $     6,00,000
Residual value $      5,00,000 $                  -   $     1,00,000
PVIFA[9,5] 3.88965 3.88965 3.88965
PVIF[9,5] 0.64993 0.64993 0.64993
PV of cash inflows $   58,34,475 $   70,01,370 $   23,33,790
PV of residual value $      3,24,965 $                  -   $         64,993
Sum of PVs $   61,59,440 $   70,01,370 $   23,98,783
Less: Initial cost $ -50,00,000 $ -60,00,000 $ -25,00,000
NPV $   11,59,440 $   10,01,370 $   -1,01,217
PAYBACK PERIOD: [in years]
Initial cost/Annual cash flow 3.33 3.33 4.17
ANSWERS:
1] If the projects are mutually exclusive, Project A should be accepted as it has the
highest NPV.
2] It the projects are independent, the firm should accept Project A and Project B as
they have positive NPV.
3] Lowest initial cost is not the criterion. Project C has the highest payback period
and a negative NPV. Hence, it is to be rejected. Even if it has a lower payback
period, it should be rejected as it has a negative NPV.

Related Solutions

Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows....
Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows. Project Investment Annual Income Life of Project 22A $240,600 $17,220 6 years 23A 271,400 21,000 9 years 24A 284,100 15,700 7 years Annual income is constant over the life of the project. Each project is expected to have zero salvage value at the end of the project. Iggy Company uses the straight-line method of depreciation. Click here to view the factor table. (a) Determine...
Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows....
Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows. Project Investment Annual Income Life of Project 22A $240,600 $17,220 6 years 23A 271,400 21,000 9 years 24A 284,100 15,700 7 years Annual income is constant over the life of the project. Each project is expected to have zero salvage value at the end of the project. Iggy Company uses the straight-line method of depreciation. Click here to view the factor table. (a) Determine...
Marigold Company is considering three capital expenditure projects. Relevant data for the projects are as follows....
Marigold Company is considering three capital expenditure projects. Relevant data for the projects are as follows. Project Investment Annual Income Life of Project 22A $243,300 $16,860 6 years 23A 274,200 20,730 9 years 24A 280,500 15,700 7 years Annual income is constant over the life of the project. Each project is expected to have zero salvage value at the end of the project. Marigold Company uses the straight-line method of depreciation. Click here to view PV table. (a) Determine the...
Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows....
Iggy Company is considering three capital expenditure projects. Relevant data for the projects are as follows. Project Investment Annual Income Life of Project 22A $243,000 $16,720 6 years 23A 270,900 20,620 9 years 24A 283,300 15,700 7 years Annual income is constant over the life of the project. Each project is expected to have zero salvage value at the end of the project. Iggy Company uses the straight-line method of depreciation. Click here to view PV table. (a) Determine the...
The Capital Budgeting Projects She must choose one of the four capital budgeting projects listed below:  ...
The Capital Budgeting Projects She must choose one of the four capital budgeting projects listed below:   Table 1 t A B C D 0         (19,500,000)         (21,000,000)         (16,500,000)         (18,000,000) 1            7,500,000            6,500,000            5,200,000            7,500,000 2            7,500,000            7,200,000            5,200,000            5,800,000 3            5,000,000            8,000,000            6,300,000            4,400,000 4            3,500,000            3,000,000            5,900,000            4,500,000 Risk Average Average High Low Table 1 shows the expected after-tax operating...
Company A is considering the following two mutually exclusive projects. Company A bases their capital budgeting...
Company A is considering the following two mutually exclusive projects. Company A bases their capital budgeting decisions solely on the NPV criteria. (Do not round intermediate calculations. Round your final answer to two decimal places.) Year Project 1 Project 2 0 -$75,000 -$75,000 1 $50,000 $20,000 2 $30,000 $21,000 3 $15,000 $59,000 1. At what required rate of return (%) is Company A indifferent between the two projects? 2. If the required rate of return is less than the crossover...
Please use Excel functions like PV A company is considering two capital budgeting projects. Each project...
Please use Excel functions like PV A company is considering two capital budgeting projects. Each project requires an initial outlay of $4,000,000. Cash inflows for each project are given in the table below. Each project has a life of 3 years. The company uses the NPV method to evaluate capital budgeting projects and its required rate of return is 9%. Here are the cash inflows from the projects. Project A         Project B         Year 1                                                 $1,900,000            0                Year 2                                                 $1,900,000           ...
Petram company is considering two alternative capital budgeting projects. Project A is an investment of $300,000...
Petram company is considering two alternative capital budgeting projects. Project A is an investment of $300,000 to renovate office facilities. Project B is an investment of $600,000 to expand diagnostic capabilities. Relevant cash flow data for the two projects over their expected two-year lives are as follows: Year 1 Year 2    Pr.     Cash Flow    Pr.        Cash Flow Project A 0.18 $     0 0.08 $    0 0.64 100,000 0.84 100,000 0.18 200,000 0.08 200,000 Project...
Monty Inc. is comparing several alternative capital budgeting projects as shown below:                      Projects    &nbsp
Monty Inc. is comparing several alternative capital budgeting projects as shown below:                      Projects                            A             B             C       Initial investment $82000    $122000    $162000    Present value of net cash flows 92000    112000    202000   Using the profitability index, the projects rank as C, A, B. A, C, B. C, B, A. A, B, C.
Monty Inc. is comparing several alternative capital budgeting projects as shown below:                      Projects    &nbsp
Monty Inc. is comparing several alternative capital budgeting projects as shown below:                      Projects                            A             B             C       Initial investment $82000    $122000    $162000    Present value of net cash flows 92000    112000    202000   Using the profitability index, the projects rank as C, A, B. A, C, B. C, B, A. A, B, C.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT