In: Accounting
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has been above 20% each of the last three years. Casey is considering a capital budgeting project that would require a $3,500,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company's discount rate is 16%. The project would provide net operating income each year for the five years as follows:
Sales...... ..................$3,400,000
Variable Expenses...1,600,000
Contribution Margin...1,800,000
Fixed Expenses:
Advertising, salaries, & other fixed out of pocket costs.... $700,000
Depreciation.......................................................................700,000
Total FIxed Expenses...................................................................................1,400,000
Net Operating income...................................................................................$400,000
Problem 11-13A
1. The net present value is computed as follows:
| 
 Now  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
|
| 
 Purchase of equipment...............  | 
||||||
| 
 Sales........................  | 
||||||
| 
 Variable expenses.....  | 
||||||
| 
 Out-of-pocket costs.  | 
 __________  | 
|||||
| 
 Total cash flows (a)..  | 
||||||
| 
 Discount factor (b)...  | 
||||||
| 
 Present value (a)×(b)................................  | 
||||||
| 
 Net present value.....  | 
2. The simple rate of return is computed as follows:
3. The company would want Casey to
| Req 1 | ||||||||
| NET PRESENT VALUE | ||||||||
| NOW | YEAR1 | YEAR2 | YEAR3 | YEAR4 | YEAR5 | |||
| Purchase of equipment | -3,500,000 | |||||||
| sales | 3,400,000 | 3,400,000 | 3,400,000 | 3,400,000 | 3,400,000 | |||
| Vvariable expense | 1600000 | 1600000 | 1600000 | 1600000 | 1600000 | |||
| Out of pocket cost | 700000 | 700000 | 700000 | 700000 | 700000 | |||
| Total cash flows | -3,500,000 | 1100000 | 1,100,000 | 1,100,000 | 1,100,000 | 1,100,000 | ||
| Discount factor | 1 | 0.862069 | 0.743163 | 0.640658 | 0.552291 | 0.476113 | ||
| Present value | -3500000 | 948275.9 | 817479.2 | 704723.4 | 607520.2 | 523724.3 | ||
| Net present value | 101,723 | |||||||
| Req 2: | ||||||||
| Annual operating profits: | ||||||||
| Sales | 3,400,000 | |||||||
| Less: Variable cost | 1,600,000 | |||||||
| Less: Total fixed cost | 1,400,000 | |||||||
| Net operating income | 400,000 | |||||||
| Average Investment: | 1,750,000 | (i.e. 3500,000/2) | ||||||
| Rate of return: Average annual income / average investment *100 | ||||||||
| ($ 400,000 /1750,000 *100 ) = 22.86% | ||||||||
| Req 3: | ||||||||
| The Company would want casey to Invest in project. | ||||||||