Conch Republic Electronics is a midsized electronics manufacturer located in Key

Question

Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, the company still maintain its main service business of repairing household electronics, which accounts for about 50 percent of its total revenue. The company also expanded into the business of manufacturing electronic items. You and your team, the Carson College of Business graduates, are hired by the company's finance department to evaluate a new project for the company. One of the major revenue-producing items of Conch Republic's manufacture division is a smart phone. Conch Republic currently has one smart phone model on the market, and sales have been excellent. Conch Republic's main competitor on the smart phone market is Apple Inc. (AAPL). Conch Republic's smart phone is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current smart phone has limited features in comparison with newer models. Conch Republic spent $750,000 to develop a prototype for a new smart phone that has all the features of the existing smart phone but adds new features such as WiFi tethering. The company has spent a further $200,000 for a marketing study to determine the expected sales figures for the new smart phone. Conch Republic can manufacture the new smart phones for $215 each in variable costs. Fixed costs for the operation are estimated to run $6.1 million per year. The estimated sales volume is 155,000, 165,000, 125,000, 95,000, and 75,000 per year for the next five years, respectively. The unit price of the new smart phone will be $520. The necessary equipment can be purchased for $40.5 million and will be depreciated on a seven-year MACRS schedule. It is believed the value of the equipment in five years will be $6.1 million. As previously stated, Conch Republic currently manufactures a smart phone. Production of the existing model is expected to be terminated in two years. If Conch Republic does not introduce the new smart phone, sales will be 95,000 units and 65,000 units for the next two years, 2 respectively. The price of the existing smart phone is $380 per unit, with variable costs of $145 each and fixed costs of $4.3 million per year. If Conch Republic does introduce the new smart phone, sales of the existing smart phone will fall by 30,000 units per year, and the price of the existing units will have to be lowered to $210 each. Net working capital for the smart phones will be 20 percent of sales and will occur with the timing of the cash flows for the year; for example, there is no initial outlay for NWC, but changes in NWC will first occur in Year 1 with the first year's sales. Conch Republic has a 35 percent corporate tax rate. The company has a target debt to equity ratio of 1 and is currently AA rated. The overall cost of capital of the company is 12 percent. The finance department of the company has asked your team to prepare a report to Shelly, the company’s president, and the report should answer the following questions. QUESTIONS: Can you and your team prepare the income statement table, the operating cash flow (OCF) table, and the total cash flow from assets (CFFA) table?

Explanation / Answer

CONCH REPUBLIC: 0 1 2 3 4 5 New smart phone sales in units 155000 165000 125000 95000 75000 Sales revenue (at $520) 80600000 85800000 65000000 49400000 39000000 Variable cost (at $215) 33325000 35475000 26875000 20425000 16125000 Fixed cost 6100000 6100000 6100000 6100000 6100000 Depreciation (MACRS) 5787450 9918450 7083450 5058450 3616650 31464450 Net operating income 35387550 34306550 24941550 17816550 13158350 Tax at 35% 12385643 12007293 8729543 6235793 4605423 NOPAT 23001908 22299258 16212008 11580758 8552928 Add: Depreciation 5787450 9918450 7083450 5058450 3616650 OCF (New smart phone) 28789358 32217708 23295458 16639208 12169578 Loss: of contribution margin on existing smart phone: Existing sales in units 95000 65000 Total contribution margin (at 380-145 = 235) 22610000 15470000 Sales in units if new phone is introduced 65000 35000 Total contribution margin (210-145=65) 4225000 2275000 Loss of contribution margin on existing phone 18385000 13195000 Incremental OCF 10404358 19022708 23295458 16639208 12169578 NWC required (for new phone) 16120000 17160000 13000000 9880000 7800000 Investment in NWC 16120000 1040000 -4160000 -3120000 -9880000 Capital expenditure 40500000 -7127443 (See note below) CFFA -40500000 -5715643 17982708 27455458 19759208 29177021 PVIF at 12% 1 0.8928571 0.7971939 0.7117802 0.6355181 0.5674269 PV at 12% -40500000 -5103252 14335704 19542252 12557334 16555825 NPV 17387863 WORKINGS: Loss on sale of equipment at t5: Book value of the equipment = 40500000-31464450 = 9035550 Amount realized 6100000 Loss on sale 2935550 Tax shield on loss at 35% 1027443 Net cash flow after tax = 6100000+1027443 = 7127443

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.