In: Finance
Project C: The project is outside of the normal products sold of the firm. The project is a reconsideration of a project proposed two years ago by a former manager. At that time a marketing study costing $200,000 was done; however, the project was not undertaken. Now the firm needs to consider if this project is worth the firm’s capital investment dollars. This project would require investment in equipment of $20,000,000 with an additional cost of $5,000,000 in installation fees. The project will be considered under a 6 year project cycle, but would be depreciated under the 5 year MACRS schedule. At the end of the project, management estimates that the equipment could be sold at a market value of $5,000,000. This project also creates a need to increase raw goods inventory by $6,000,000. During the operational cycle of this project, the product would have a sales price of $90.00 per unit. Costs associated with this project would be $65.00 in variable cost per unit and a fixed cost per year of $5,000,000. Management estimates that the sales volume would be 500,000 units in year 1, 600,000 units in year 2, 700,000 units in year 3, 800,000 units in year 4, 800,000 units in year 5, and 600,000 units in year 6. Because management is uneasy with undertaking a project so far outside of its normal product portfolio, it is imposing a 3 percentage point premium above the WACC as the required rate of return on the project.
Create a valuation spreadsheet for each of the projects mentioned above. Evaluate each project according to the following valuation methods: a. Net Present Value of Discounted Cash Flow b. Internal Rate of Return c. Payback Period d. Profitability Index
Modified Accelerated Cost Recovery System (MACRS)
Ownership Year 5-Year Investment Class Depreciation Schedule
1 20%
2 32%
3 19%
4 12%
5 11%
6 6%
Total = 100%
WACC = 12.064%
tax rate = 4%