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. | ||||||||