In: Accounting
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 value. The company’s cost of capital is 15%. (Assume that
cash flows occur evenly throughout the year.)
Click here to view PV table.
Compute the cash payback period for each project. (Round answers to 2 decimal places, e.g. 10.50.)
| Project Bono | enter the cash payback period in years rounded to 2 decimal places | years | |
|---|---|---|---|
| Project Edge | enter the cash payback period in years rounded to 2 decimal places | years | |
| Project Clayton | enter the cash payback period in years rounded to 2 decimal places | 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 | $ enter a dollar amount rounded to 0 decimal places | $ enter a dollar amount rounded to 0 decimal places | $ enter a dollar amount rounded to 0 decimal places | 
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 | enter percentages rounded to 2 decimal places % | enter percentages rounded to 2 decimal places % | enter percentages rounded to 2 decimal places % | 
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 | select a ranking numberselect a ranking number 1 3 2 | select a ranking numberselect a ranking number 2 3 1 | select a ranking numberselect a ranking number 3 2 1 | ||||
| Edge | select a ranking numberselect a ranking number 1 3 2 | select a ranking numberselect a ranking number 1 2 3 | select a ranking numberselect a ranking number 1 2 3 | ||||
| Clayton | select a ranking numberselect a ranking number 1 3 2 | select a ranking numberselect a ranking number 1 2 3 | select a ranking numberselect a ranking number 1 2 3 | 
| The best project is select a projectselect a project Bono/Edge/Clayton. | 
| Calculation of cash payback period: | |||||||
| Cash Payback period = Cost of investment/Cash Inflows | |||||||
| Bono | Edge | Clayton | |||||
| Cost of investment | 171200 | 187250 | 202000 | ||||
| Cash inflows | 74900 | 77040 | 102720 | ||||
| Csh payback period | 2.28 | 2.43 | 1.97 | ||||
| Ranking | 2 | 3 | 1 | ||||
| The project having low cash payback period will be ranked high | |||||||
| Calculation of net present value: | |||||||
| Net present value = Present value of Cash Inflows - Present value of Cash Outflows | |||||||
| Bono | Edge | Clayton | |||||
| Particulars | Discounting Factor @15% | Amt. | Present value | Amt | Present Valu | Amt. | Present Value | 
| Cash Outflow at T =0 | 1 | 171200 | -171200 | 187250 | -187250 | 202000 | -202000 | 
| Cash inflows at t=1 | 0.86956 | 14980 | 13026 | 19260 | 16747.72 | 28890 | 25121.59 | 
| 0.75614 | 14980 | 11326.98 | 18190 | 13754.19 | 24610 | 18608.6 | |
| 0.65752 | 14980 | 9849.65 | 17120 | 11256.74 | 22470 | 14774.47 | |
| 0.57175 | 14980 | 8564.82 | 12840 | 7341.27 | 13910 | 7953.04 | |
| 0.49718 | 14980 | 7447.76 | 9630 | 4787.84 | 12840 | 6383.79 | |
| Net Present Value | -120984.79 | -133362.24 | -129158.51 | ||||
| or (120985) | or (133362) | -129158 | |||||
| Ranking | 1 | 3 | 2 | ||||
| The project having more net present value will be highly ranked. | |||||||
| Calculation of rate of return: | |||||||
| Brun | Edge | Clayton | |||||
| Total Income | 74900 | 77040 | 102720 | ||||
| Average income (Toatl income/5) | 14980 | 15408 | 20544 | ||||
| Cost of investment | 171200 | 187250 | 202000 | ||||
| Rate of return (Average return/Cost of investment)*100 | 8.75% | 8.23% | 10.17% | ||||
| Ranking | 2 | 3 | 1 | ||||
| The project having high rate of return will be ranked high. | |||||||
| As the project Clayton is having high rate of return and low cash payback period. So it is the best project | |||||||