do question 7

of item in their report? Explain. 7. Calculate the IRR of the project. Based on your calculations what would you recommend? Why? How sensitive is the net present value of the project to the Having been involved with more than a few of these kinds of proposals before, the head of the design team, Matt Robichek, knew that he had better take every possible factor into consideration and be prepared for a tough and demanding question and answer session at the next committee meeting. Luckily for Matt, his assistant, Chris Robinson, who had recently carned his chartered financial analyst (CFA) designation, was an experi- enced and dependable employee. Prior to being hired by CPC three years ago, Chris had worked for another large engineering company for over 10 years. "Chris, we have to dot all the 'i's' and cross all the it's on this one" said Matt. "Or else the big guys are going to tear us apart, because we're talking major dollars here. Their main question is going to be, is it really worth it?" So Matt and Chris began collecting the necessary information. They knew that to have a comprehensive feasibility study they would have to include the following: 1. Pro forma statements showing expected annual revenues, variable costs, fixed costs, and not cash flows over the economic life of the project with appropriate supporting documentation. 2. Break-even analysis. 3. Sensitivity of the cash flows to alternative scenarios of sales growth and profit margins. Based on the data provided by the marketing department, they prepared Table 1. showing the expected unit sales of the Lawn Robot over its 10-year economic life and the expected selling price per unit. Note that the price of $1,000 per unit was estimated to gradually drop to $900 per unit over the 10-year period reflecting competitive pressures. Depreciation for this project was based on the seven-year MACRS rates as shown in Table 2. The cost of equipment, including shipping, handling, and instal- lation, was estimated at $20 million. It was estimated that after 10 years, the equipment and tools could be sold for $4 million. The manufacturing would be done in an unused plant of the firm. Similar plant locations could be leased for $10,000 per month. Fixed costs were estimated to be $1,500,000 per year while variable production costs per unit were expected to be $400. To get the project underway, additional inventory of $500,000 would be required. The company would increase its accounts payable by $600,000 and its accounts receivable by $1,000,000. Matt and Chris estimated that each year thereafter, the net working capital of the firm would amount to 5% of sales. The weighted average cost of capital was calculated to be 14%. Interest expenses on debt raised to fund the project were estimated to be $400,000 per year. The company's tax rate was expected to remain constant at 34%. Table 1 Year Unit Price 2 3 Projected Unit Sales and Price for Lawn Robot Unit Sales 30.000 34,000 30,000 39,000 36.000 36,000 35,500 35,000 34,500 34.000 5 $1000 1000 1000 950 950 950 950 900 900 900 7 8 9 10 Table 2 Modified ACRS Depreciation Allowances Year 3-Year 5-Year 7-Year 1 33.33% 44.44 2 3 4 5 14.82 7.41 20.00% 32.00 19.20 11.52 11.52 5.76 14.29% 24.49 17.49 12.49 8.93 8.93 6 7 8 8.93 4.45 of item in their report? Explain. 7. Calculate the IRR of the project. Based on your calculations what would you recommend? Why? How sensitive is the net present value of the project to the Having been involved with more than a few of these kinds of proposals before, the head of the design team, Matt Robichek, knew that he had better take every possible factor into consideration and be prepared for a tough and demanding question and answer session at the next committee meeting. Luckily for Matt, his assistant, Chris Robinson, who had recently carned his chartered financial analyst (CFA) designation, was an experi- enced and dependable employee. Prior to being hired by CPC three years ago, Chris had worked for another large engineering company for over 10 years. "Chris, we have to dot all the 'i's' and cross all the it's on this one" said Matt. "Or else the big guys are going to tear us apart, because we're talking major dollars here. Their main question is going to be, is it really worth it?" So Matt and Chris began collecting the necessary information. They knew that to have a comprehensive feasibility study they would have to include the following: 1. Pro forma statements showing expected annual revenues, variable costs, fixed costs, and not cash flows over the economic life of the project with appropriate supporting documentation. 2. Break-even analysis. 3. Sensitivity of the cash flows to alternative scenarios of sales growth and profit margins. Based on the data provided by the marketing department, they prepared Table 1. showing the expected unit sales of the Lawn Robot over its 10-year economic life and the expected selling price per unit. Note that the price of $1,000 per unit was estimated to gradually drop to $900 per unit over the 10-year period reflecting competitive pressures. Depreciation for this project was based on the seven-year MACRS rates as shown in Table 2. The cost of equipment, including shipping, handling, and instal- lation, was estimated at $20 million. It was estimated that after 10 years, the equipment and tools could be sold for $4 million. The manufacturing would be done in an unused plant of the firm. Similar plant locations could be leased for $10,000 per month. Fixed costs were estimated to be $1,500,000 per year while variable production costs per unit were expected to be $400. To get the project underway, additional inventory of $500,000 would be required. The company would increase its accounts payable by $600,000 and its accounts receivable by $1,000,000. Matt and Chris estimated that each year thereafter, the net working capital of the firm would amount to 5% of sales. The weighted average cost of capital was calculated to be 14%. Interest expenses on debt raised to fund the project were estimated to be $400,000 per year. The company's tax rate was expected to remain constant at 34%. Table 1 Year Unit Price 2 3 Projected Unit Sales and Price for Lawn Robot Unit Sales 30.000 34,000 30,000 39,000 36.000 36,000 35,500 35,000 34,500 34.000 5 $1000 1000 1000 950 950 950 950 900 900 900 7 8 9 10 Table 2 Modified ACRS Depreciation Allowances Year 3-Year 5-Year 7-Year 1 33.33% 44.44 2 3 4 5 14.82 7.41 20.00% 32.00 19.20 11.52 11.52 5.76 14.29% 24.49 17.49 12.49 8.93 8.93 6 7 8 8.93 4.45