Prepare an analysis of The Rondo Company's New Project
The Rondo Company's New Project
Use ONLY these assumptions for your analysis: SOLUTION
1. Project life is 5 years.
2. Initial investment is $6,250,000 for equipment invoice, transportation, and installation.
3. Worker training for operating new equipment is $15,000.
4. First year sales are projected to be $7,500,000 escalated at 3% each year thereafter.
5. Operating overhead (excluding depreciation) is estimated at 27% of annual sales.
6. Administrative overhead is estimated at 35% of annual sales.
7. Depreciation is straight line, 7 years.
8. The tax rate is 40%.
9. The new equipment can be salvaged at the end of the project (end of YR 5) for $1,500,000.
10. Use Rondo's WACC of 10% to discount the project cash flows.
Create an Excel cash flow spreadsheet and calculate the NPV and IRR. Make recommendation on the
DOWNLOAD EXCEL SHEET
project. (Hint: You are only interested in the incremental cash flows.) Create a spreadsheet from the above assumptions since they represent the incremental cash flows. Also, list your assumptions and build the spreadsheet by incorporating the assumption value cells into the spreadsheet. The spreadsheet should automatically flow if an assumption value is changed.