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 | $ 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 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 for the project rounded to 2 decimal places | years | |
|---|---|---|---|
| Project Edge | enter the cash payback period in years for the project rounded to 2 decimal places | years | |
| Project Clayton | enter the cash payback period in years for the project 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 | 
eTextbook and Media
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 a percentage number rounded to 2 decimal places % | enter a percentage number rounded to 2 decimal places % | enter a percentage number rounded to 2 decimal places % | 
Depreciation:
(In $)
| Bono | Edge | Clayton | |
| Capital investment | 168,000 | 183,750 | 202,000 | 
| Useful life (Years) | 5 | 5 | 5 | 
| Salvage value | 0 | 0 | 0 | 
| Depreciation (investment/lifel | 33,600 | 36,750 | 40,400 | 
Cashflow = Annual net income + Depreciation
Cash flows are
(In $)
| Years | Bono | Edge | Clayton | 
| 1 | 
 =14,700+33,600 =48,300  | 
 =18,900+36,750 =55,650  | 
 =28,350+40,400 =68,750  | 
| 2 | 
 =14,700+33,600 =48,300  | 
 =17,850+36,750 =54,600  | 
 =24,150+40,400 =64,550  | 
| 3 | 
 =14,700+33,600 =48,300  | 
 =16,800+36,750 =53,550  | 
 =22,050+40,400 =62,450  | 
| 4 | 
 =14,700+33,600 =48,300  | 
 =12,600+36,750 =49,350  | 
 =13,650+40,400 =54,050  | 
| 5 | 
 =14,700+33,600 =48,300  | 
 =9,450+36,750 =46,200  | 
 =12,600+40,400 =53,000  | 
Cost of capital is 15%
PV factor is (1/1.15)n
Where "n" is no of years
Discounted cashflows = PV factor * cashflows
Discounted cash flows are
(In $)
| Year | PV factor | Bono | Edge | Clayton | 
| 1 | 0.870 | 42,021 | 48,415.50 | 59,812.50 | 
| 2 | 0.756 | 36,514.80 | 41,277.60 | 48,799.80 | 
| 3 | 0.658 | 31,781.40 | 35,235.90 | 41,092.10 | 
| 4 | 0.572 | 27,627.60 | 28,228.20 | 30,916.60 | 
| 5 | 0.497 | 24,005.10 | 22,961.40 | 26,341 | 
| 161,949.9 | 176,118.60 | 206,962 | ||
| Present value | 161,950 | 176,119 | 206,962 | 
| Present value | 161,950 | 176,119 | 206,962 | 
| Less: Capital investment | 168,000 | 183,750 | 202,000 | 
| Net present value | (6,050) | (7,631) | 4,962 | 
Cash pay back period:
For project bono
= Initial investment / Annual Cashflow
= 168,000/48,300
= 3.48 years
For project Edge/ Clayton
(In $)
| Years | 
 cash flow of Project Edge  | 
 Cumulative cash flow of project Edge  | 
 Cash flow of Project Clayton  | 
 Cumulative cash flow of project Clayton  | 
| 1 | 55,650 | 55,650 | 68,750 | 68,750 | 
| 2 | 54,600 | 115,815 | 64,550 | 133,300 | 
| 3 | 53,550 | 169,365 | 62,450 | 195,750 | 
| 4 | 49,350 | 218,715 | 54,050 | 249,800 | 
| 5 | 46,200 | 264,915 | 53,000 | 302,800 | 
Edge = 2+(168,000-115,815)/53,550 = 2.97 years
Clayton = 3+(202,000-195,750)/54,060 = 3.12 years
Annual rate of return:
= Average income/Average Investment
= (Total income /5)/Investment
For bono
= (73,500/5)/168,000 = 8.75%
For edge
= (75,600/5)/183,750 = 8.23%
For Clayton
= (100,800/5)/202,000 = 9.98%