Question

In: Finance

Exercise 24-2 Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment...

Exercise 24-2

Doug’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 Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of return is 12%. Click here to view PV table.

(a)

Compute each project’s payback period. (Round answers to 2 decimal places, e.g. 15.25.)

AA
years
BB
years
CC
years



Which is the most desirable project?

The most desirable project based on payback period is

Project AA
Project BB
Project CC



Which is the least desirable project?

The least desirable project based on payback period is

Project BB
Project AA
Project CC


(b)

Compute the net present value of each project. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45). Round final answers to the nearest whole dollar, e.g. 5,275. For calculation purposes, use 5 decimal places as displayed in the factor table provided.)

AA
BB
CC


Which is the most desirable project based on net present value?

The most desirable project based on net present value is

Project AA
Project BB
Project CC
.


Which is the least desirable project based on net present value?

The least desirable project based on net present value is

Project CC
Project BB
Project AA
.

Click if you would like to Show Work for this question:
Open Show Work

Solutions

Expert Solution

a)

AA:

Cumulative cash flow for year 0 = -25,080

Cumulative cash flow for year 1 = -25,080 + 7,980 = -17,100

Cumulative cash flow for year 2 = -17,100 + 10,260 = -6,840

Cumulative cash flow for year 3 = -6,840 + 13,680 = 6,840

6840 / 13,680 = 0.5

Payback period = 2 + 0.5 = 2.5 years

BB:

Cumulative cash flow for year 0 = -25,080

Cumulative cash flow for year 1 = -25,080 + 11,400 = -13,680

Cumulative cash flow for year 2 = -13,680 + 11,400 = -2,280

Cumulative cash flow for year 3 =  -2,280 + 11,400 = 9,120

2280 / 11400 = 0.2

Payback period for BB = 2.2 years

CC:

Cumulative cash flow for year 0 = -25,080

Cumulative cash flow for year 1 = -25,080 + 14,820= -10,260

Cumulative cash flow for year 2 = -10,260 + 13,680 = 3,420

10,260 / 13,680 = 0.75

Payback period for CC = 1.75

Project CC is most desirable as it has the lowest payback period.

Project AA is least desirable as it has the highest payback period.

b)

AA:

NPV = Present value of cash inflows - present value of cash outflows

Present value of cash inflows = 7,980 / ( 1 + 0.12) + 10,260 / ( 1 + 0.12)2 + 13,680 / ( 1 + 0.12)3

Present value of cash inflows = 7,125 + 8,179.21 + 9,737.15

Present value of cash inflows = 25,041.36

NPV = 25,041.36 - 25,080 = -39

BB:

Present value of cash inflows = 11,400 / ( 1 + 0.12) + 11,400 / ( 1 + 0.12)2 + 11,400 / ( 1 + 0.12)3

Present value of cash inflows = 10,178.57 + 9,088.01 + 8,114.29

Present value of cash inflows = 27,380.87

NPV = 27,380.87 - 25,080 = $2,301

CC:

Present value of cash inflows = 14,820 / ( 1 + 0.12) + 13,680 / ( 1 + 0.12)2 + 12,540 / ( 1 + 0.12)3

Present value of cash inflows = 13,232.14 + 10,905.61 + 8,925.72

Present value of cash inflows = 33,063.47

NPV = 33,063.47 - 25,080 = $7,984

Project CC is the most desirable as it has the highest NPV

Project AA is least desirable as it has a negative NPV


Related Solutions

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...
Exercise 25-02 Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment...
Exercise 25-02 Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $24,200. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,700 $11,000 $14,300 2 9,900 11,000 13,200 3 13,200 11,000 12,100 Total $30,800 $33,000 $39,600 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...
Exercise 25-02 Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment...
Exercise 25-02 Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $24,420. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $7,770 $11,100 $14,430 2 9,990 11,100 13,320 3 13,320 11,100 12,210 Total $31,080 $33,300 $39,960 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...
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...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT