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%. All sales are collected in cash, all variable expenses are paid in cash during the year they are incurred, and all out-of-pocket fixed expenses are paid in cash during the year they are incurred. The project would provide net operating income each year for five years as follows: |
| Sales | $ | 3,400,000 | |
| Variable expenses | 1,600,000 | ||
| Contribution margin | 1,800,000 | ||
| Fixed expenses: | |||
| Advertising, salaries, and other
fixed out-of-pocket costs |
$700,000 | ||
| Depreciation | 700,000 | ||
| Total fixed expenses | 1,400,000 | ||
| Net operating income | $ | 400,000 | |
| Required: | |
| 1. | What are the annual net cash inflows for this project? |
| 1100000 |
| 2. | What are the total cash inflows from this project after 5 years are complete? |
| 5500000 |
| 3. | What is the present value of the cash inflows? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) |
| 4. | What is the project’s net present value? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) |
| 5. | What is the project’s internal rate of return? (Use Microsoft Excel to calculate present values. Round your percentage to two decimal places.) |
| 5-a. | Would the company want Casey to pursue this investment opportunity? | ||||
|