Question

In: Accounting

Vista Company is considering two new projects, each requiring an equipment investment of $97,000. Each project...

Vista Company is considering two new projects, each requiring an equipment investment of $97,000. Each project will last for three years and produce the following cash inflows:

         Year                                Cool                       Hot   

            1                               $ 38,000               $ 42,000

            2                                   43,000                   42,000

            3                                   48,000                   42,000

                                             $129,000               $126,000

The equipment will have no salvage value at the end of its three-year life. Vista Company uses straight-line depreciation and requires a minimum rate of return of 12%.

Present value data are as follows:

                  Present Value of 1                               Present Value of an Annuity of 1

         Period                           12%                         Period                              12%  

            1                                  .893                             1                                       .893

            2                                  .797                             2                                     1.690

            3                                  .712                             3                                     2.402

Instructions

(a)   Compute the net present value of each project.

(b)   Compute the profitability index of each project.

(c) Which project should be selected? Why?

Additional requirement:

Calculate the Cash Payback period of each project

Solutions

Expert Solution

Answer a
Calculation of the net present value of each project
Year Discount Factor @ 12% Cool Hot
Cash flow present Value Cash flow present Value
0 1 -$97,000.00 -$97,000.00 -$97,000.00 -$97,000.00
1 0.893 $38,000.00 $33,928.57 $42,000.00 $37,500.00
2 0.797 $43,000.00 $34,279.34 $42,000.00 $33,482.14
3 0.712 $48,000.00 $34,165.45 $42,000.00 $29,894.77
Net Present Value $5,373.36 $3,876.91
NPV of Project Cool = $5,373.36
NPV of Project Hot = $3,876.91
Answer b
Profitability Index of a project = Present value of future cash inflows / Initial Investment in project
Profitability Index of a Project Cool = $102,373.36 / $97,000 = 1.06
Profitability Index of a Project Hot = $100,876.91 / $97,000 = 1.04
Answer c
Project Cool should be selected as it has higher NPV and PI compared to Project Hot.
Answer d
Calculation of Cash payback period
Year Cool Hot
Cash flow Cumulative Cash Flow Cash flow Cumulative Cash Flow
0 -$97,000.00 -$97,000.00 -$97,000.00 -$97,000.00
1 $38,000.00 -$59,000.00 $42,000.00 -$55,000.00
2 $43,000.00 -$16,000.00 $42,000.00 -$13,000.00
3 $48,000.00 $32,000.00 $42,000.00 $29,000.00
Cash payback period of Project Cool = 2 Years + [$16000 / $48000] = 2.33 years
Cash payback period of Project Hot = 2 Years + [$13000 / $42000] = 2.31 years

Related Solutions

A Manufacturing Company is considering two new projects, each requiring an equipment investment of $22,000. Each...
A Manufacturing Company is considering two new projects, each requiring an equipment investment of $22,000. Each project will last for 3 years and produce the following annual net cash inflows. Year BB CC 1 $ 10,000 $14,000 2 10,000 10,000 3 10,000 6,000 Total $30,000 $30,000 The equipment's salvage value is zero for each machine. Cepeda uses straight-line depreciation. Cepeda's minimum required rate of return is 12%. Instructions (a) Compute each project's payback period. (Round to two decimals.) (b) Compute...
Ducan Company is considering three new projects, each requiring an equipment investment of $25,740. Each project...
Ducan Company is considering three new projects, each requiring an equipment investment of $25,740. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $8,190 $11,700 $15,210 2 10,530 11,700 14,040 3 14,040 11,700 12,870 Total $32,760 $35,100 $42,120 The equipment’s salvage value is zero, and Sheffield uses straight-line depreciation. Sheffield will not accept any project with a cash payback period over 2 years. Sheffield’s required rate of return is...
VI. ABC Manufacturing Company is considering two new projects, each requiring an equipment investment of $22,000....
VI. ABC Manufacturing Company is considering two new projects, each requiring an equipment investment of $22,000. Each project will last for 3 years and produce the following annual net cash inflows. Year BB    CC 1 $ 10,000 $14,000 2 10,000 10,000       3     10,000     6,000 Total $30,000 $30,000 The equipment's salvage value is zero for each machine. Cepeda uses straight-line depreciation. Cepeda's minimum required rate of return is 12%. Instructions (a) Compute each project's payback period. (Round to...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $ 24,640. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $ 7,840 $ 11,200 $ 14,560 2 10,080 11,200 13,440 3 13,440 11,200 12,320 Total $ 31,360 $ 33,600 $ 40,320 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,320....
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,320. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,420 $10,600 $13,780 2 9,540 10,600 12,720 3 12,720 10,600 11,660 Total $29,680 $31,800 $38,160 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of...
Crane’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $25,080....
Crane’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $25,080. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,980 $11,400 $14,820 2 10,260 11,400 13,680 3 13,680 11,400 12,540 Total $31,920 $34,200 $41,040 The equipment’s salvage value is zero, and Crane uses straight-line depreciation. Crane will not accept any project with a cash payback period over 2 years. Crane’s required rate of...
Coronado’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,540....
Coronado’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,540. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,490 $10,700 $13,910 2 9,630 10,700 12,840 3 12,840 10,700 11,770 Total $29,960 $32,100 $38,520 The equipment’s salvage value is zero, and Coronado uses straight-line depreciation. Coronado will not accept any project with a cash payback period over 2 years. Coronado’s required rate of...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,760....
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,760. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,560 $10,800 $14,040 2 9,720 10,800 12,960 3 12,960 10,800 11,880 Total $30,240 $32,400 $38,880 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $27,500....
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $27,500. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $8,750 $12,500 $16,250 2 11,250 12,500 15,000 3 15,000 12,500 13,750 Total $35,000 $37,500 $45,000 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $27,280....
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $27,280. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $8,680 $12,400 $16,120 2 11,160 12,400 14,880 3 14,880 12,400 13,640 Total $34,720 $37,200 $44,640 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT