Question

In: Accounting

Problem 12-1A U3 Company is considering three long-term capital investment proposals. Each investment has a useful...

Problem 12-1A U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $171,200 $187,250 $206,000 Annual net income: Year 1 14,980 19,260 28,890 2 14,980 18,190 24,610 3 14,980 17,120 22,470 4 14,980 12,840 13,910 5 14,980 9,630 12,840 Total $74,900 $77,040 $102,720 Depreciation is computed by the straight-line method with no salvage value. The company’s cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.) Compute the cash payback period for each project. (Round answers to 2 decimal places, e.g. 10.50.) Project Bono years Project Edge years Project Clayton years Compute the net present value for each project. (Round answers to 0 decimal places, e.g. 125. If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses eg (45). For calculation purposes, use 5 decimal places as displayed in the factor table provided.) Project Bono Project Edge Project Clayton Net present value $ $ $ Compute the annual rate of return for each project. (Hint: Use average annual net income in your computation.) (Round answers to 2 decimal places, e.g. 10.50.) Project Bono Project Edge Project Clayton Annual rate of return % % % Rank the projects on each of the foregoing bases. Which project do you recommend? Project Cash Payback Net Present Value Annual Rate of Return Bono Edge Clayton The best project is .

Solutions

Expert Solution

Ans-Payback period- Project Bono

Depreciation per year 171,200/5 =$34,240

Cash payback period= 171,200/ (14,980+34,240)

= 3.48 years

Project Edge:- Depreciation per year= 187,250/ 5 = $37,450 per year

Year Annual Net Income Depreciation Value Cumulative Cash Flow
1 19,260 37,450 56,710
2 18,190 37,450 112,350
3 17,120 37,450 166,920
4 12,840 37,450 217,210
5 9,630 37,450 264,290
77,040

187,250-166,920= 20,330

20,330/(37,450+12,480)=0.41

Payback period = 3.41 years

Project Clayton:- Depreciation per year= 202,000/5- 40,400 per year

Year Annual Net Income Depreciation Value Cumulative Cash Flow
1 28,890 40,400 69,290
2 24,610 40,400 134,300
3 22,470 40,400 197,170
4 13,910 40,400 251,480
5 12,840 40,400 304,720
102,720

202,000-197,170= 4,830

4,830/ (40,400+13,910)=0.09

Payback period= 3.09 years

Ans-b- Calculation of NPV:-

Project Bono Project Edge Project Clayton
Year Discount Factor Cash Inflow PV Cash Inflow PV Cash Inflow PV
1 0.86957 49,220 42,800.24 56,710 49,313.32 69,290 60,252.51
2 0.75614 49,220 37,217.21 55,640 42,071.63 65,010 49,156.66
3 0.65752 49,220 32,363.13 54,570 35,880.87 62,870 41,338.28
4 0.57175 49,220 28,141.54 50,290 28,753.31 54,310 31,051.74
5 0.49718 49,220 24,471.20 47,080 23,407.23 53,240 26,469.86
Total 246,100 164,993.32 264,290 179,426.35 304,720 208,269.06
Investment 171,200 187,250 202,000
NPV -6,206.68 -7,823.65 6,269.04

Ans-c- Annual rate of return:-

Project BONO:-

=14,980/ (171,200+0)/2= 17.50%

Project EDGE:-

=(77,040/5)/ (187,250+0)/2 = 16.46%

Project Clayton:-

=(102,720/5)/ (202,000+0)/2 = 20.34%

Ans-d-Ranking

Project Cash Payback NPV ARR
BONO 3 2 2
EDGE 2 3 3
CLAYTON 1 1 1

Related Solutions

Problem 12-1A (Video) U3 Company is considering three long-term capital investment proposals. Each investment has a...
Problem 12-1A (Video) U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $168,000 $183,750 $202,000 Annual net income: Year  1 14,700 18,900 28,350         2 14,700 17,850 24,150         3 14,700 16,800 22,050         4 14,700 12,600 13,650         5 14,700 9,450 12,600 Total $73,500 $75,600 $100,800 Depreciation is computed by the straight-line method with no salvage value. The company’s...
Problem 25-01A U3 Company is considering three long-term capital investment proposals. Each investment has a useful...
Problem 25-01A U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $171,200 $187,250 $208,000 Annual net income: Year  1 14,980 19,260 28,890         2 14,980 18,190 24,610         3 14,980 17,120 22,470         4 14,980 12,840 13,910         5 14,980 9,630 12,840 Total $74,900 $77,040 $102,720 Depreciation is computed by the straight-line method with no salvage value. The company’s cost...
Problem 25-01A U3 Company is considering three long-term capital investment proposals. Each investment has a useful...
Problem 25-01A U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $171,200 $187,250 $208,000 Annual net income: Year  1 14,980 19,260 28,890         2 14,980 18,190 24,610         3 14,980 17,120 22,470         4 14,980 12,840 13,910         5 14,980 9,630 12,840 Total $74,900 $77,040 $102,720 Depreciation is computed by the straight-line method with no salvage value. The company’s cost...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $ 164,800 $ 180,250 $ 204,000 Annual net income: Year  1 14,420 18,540 27,810         2 14,420 17,510 23,690         3 14,420 16,480 21,630         4 14,420 12,360 13,390         5 14,420 9,270 12,360 Total $ 72,100 $ 74,160 $ 98,880 Depreciation is computed by the straight-line method with no salvage...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. I got all the answers by my computation for average rate of return Is wrong Project Bono Project Edge Project Clayton Capital investment $164,800 $180,250 $206,000 Annual net income: Year  1 14,420 18,540 27,810         2 14,420 17,510 23,690         3 14,420 16,480 21,630         4 14,420 12,360 13,390         5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $161,600 $176,750 $204,000 Annual net income: Year  1 14,140 18,180 27,270         2 14,140 17,170 23,230         3 14,140 16,160 21,210         4 14,140 12,120 13,130         5 14,140 9,090 12,120 Total $70,700 $72,720 $96,960 Depreciation is computed by the straight-line method with no salvage value. The company’s cost of capital...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $174,400 $190,750 $218,000 Annual net income: Year 1 15,260 19,620 29,430 2 15,260 18,530 25,070 3 15,260 17,440 22,890 4 15,260 13,080 14,170 5 15,260 9,810 13,080 Total $76,300 $78,480 $104,640 Depreciation is computed by the straight-line method with no salvage value. The company’s cost of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $ 171,200 $ 187,250 $ 202,000 Annual net income: Year  1 14,980 19,260 28,890         2 14,980 18,190 24,610         3 14,980 17,120 22,470         4 14,980 12,840 13,910         5 14,980 9,630 12,840 Total $ 74,900 $ 77,040 $ 102,720 Depreciation is computed by the straight-line method with no salvage...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,800 $180,250 $202,000 Annual net income: Year  1 14,420 18,540 27,810         2 14,420 17,510 23,690         3 14,420 16,480 21,630         4 14,420 12,360 13,390         5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company’s cost of capital...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of...
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $163,200 $178,500 $204,000 Annual net income: Year  1 14,280 18,360 27,540         2 14,280 17,340 23,460         3 14,280 16,320 21,420         4 14,280 12,240 13,260         5 14,280 9,180 12,240 Total $71,400 $73,440 $97,920 Depreciation is computed by the straight-line method with no salvage value. The company’s cost of capital...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT