Introduction

William Livingston has recently been hired as the CEO of Electrics, Inc. Previously he had been the marketing manager for a large manufacturing company and had established a reputation for identifying new consumer trends. Electrics Inc. is a California-based generator manufacturing company. The company is well known for manufacturing large, heavy-duty generators at a reasonable cost. One of its greatest achievements is that its generators can be easily modified or customized for different applications.

The company is considering an expansion of its current product line to include electric motors conversion kit for cars. Customers can use these kits to convert their cars from gas to electric drive systems. Mr. Livingston felt that due to high energy prices, consumers will be more willing to consider purchasing new conversion kits.

Profile of Electrics

Electrics, Inc. was established by the Smith brothers in 1910 as the Logging Saw Company. The firm started manufacturing large steam saws to serve the logging industry which processed lumber. Their customers were construction companies that provided housing for the population increase in California. The Smith brothers quickly realized that the times were changing. They started looking for the technologies that would keep them at the forefront of their field of business. In 1915, the Smith brothers decided that 2 they needed to make generators as replacements for the saws. They realized that the logging industry was not viable anymore and that generators were starting to serve the same purpose.

The company started making generators in the early 1920s. Electrics then opted to produce large-commercial AC electric motors. It was an easy decision to make since the commercial AC electric motors would use common parts with the companys generators and the customers were local hospitals, schools, and governments. Starting in the 1950s the commercial AC motors business accounted for about 50% of Electrics revenues.

The Car Conversion Kit

Mr. Livingston arranged a meeting with the firms top management and the chief design and the chief manufacturing engineers to propose a new product. Mr. Livingston presented an argument that more individuals in the United State and Canada would be willing to purchase the conversion kit because people are becoming more environmentally conscious. The electric cars are more efficient and environmentally friendlier. Also, the recent increase in fuel costs seems to be long lasting. This is an opportunity to get people hooked on environmentally friendly appliances as he put it.

The proposal under consideration is for the introduction of a new, car conversion kits to convert gas cars into electric ones. To distinguish Electrics from other manufacturers, the proposal included details about the efficiency and quietness of operation of the motors that need to be developed.

Mr. Phillips and Mr. Lopez, the two engineers, enthusiastically and quickly pointed out that the needed technology could be based on the companys commercial AC motors. The framework currently used for building the commercial AC motors can be modified to work for smaller electric motors at a low cost. The marketing vice president, Mr. Chen, pointed out that the marketing analysis could be done quickly and at a reasonable cost. At this point, Mr. Livingston charged the participants in the meeting to produce a financial plan for the development and production of the electric motor.

Customer Cars Most people purchase gas cars and keep them for few years or until they stop working or a nicer new model is introduced. Recently, most states companies started educating people about the efficiency of electric cars and began offering rebates on the most efficient models. These approaches increased public interest. This renewed the publics interest in low fuel-consuming cars.

The Decision

Three weeks later, the vice presidents presented the sales and cost forecasts shown in the exhibits. The information presented contains the cost of production, financing information, and warranty cost estimates. In addition, there were two options for the controller of the electric motor in the conversion kits. The CTX 13 is more expensive to install, but has a lower warranty cost. The MT 78 is cheaper to install, but has a higher warranty cost. Which controller should be used?

The Analysis

Mr. Livingston noticed that there is an abundance of enthusiasm about entering the electric car conversion kit building business, but his cautious nature made him seek a more neutral analyst. This is your responsibility. You have been hired by Electrics to analyze the proposal to build the electric motor and provide recommendations to Mr. Livingston.

Exhibit 1 Sales forecasts:

The forecasts are based on projected levels of demand. The firm could face weak, average, and strong demand. All the numbers are expressed in todays dollars. The forecasted average inflation per year is 3.0%.

Demand level	Weak	Average	Strong
Probability	25%	45%	30%
Price per Electric Motor	$9,100	$9,200	$9,250
Units sold per year	40,000	40,500	40,750
Labor cost per Electric Motor	$4,250
Parts	$2,500
Selling General & Administrative	$9,500,000
Average warranty cost per year per electric motor for the first five years is $75. The present value of this cost will be used as a cost figure for each electric motor. Afterwards, the electric motor owners will become responsible the repairs.
The electric motors can be produced for eight years. Afterwards, the designs become obsolete.

Exhibit 2 Controller costs:

Controller choices:

Controller model number	CTX 13	MT 78
Price per controller and installation	$1280	$1260
Average annual warranty cost per year for five years. Afterwards, the electric motor owner will become responsible the repairs*.	$90	$100
The chosen controller will be installed in every electric motor and will become a cost figure for each unit produced. * The controller manufacturers are not providing Electrics with any warranty. However, Electrics will provide warranty to its customers. After the initial five years, the electric motor owners may purchase extended warranty from any insurance company that offers such packages.

Exhibit 3 Investment needs:

To implement the project, the firm has to invest funds as shown in the following table:

Year 0	Year 1
$17 million	Production and selling of commercial appliances starts

MACRS depreciation will be used.

To facilitate the operation of manufacturing the electric motors, the company will have to allocate funds to net working capital (NWC) equivalent to 10% of annual sales. The investment in NWC will be recovered at the end of the project

Exhibit 4 Financing

The following assumptions are used to determine the cost of capital. Historically, the company tried to maintain a debt to equity ratio equal to 0.50. This ratio was used because lowering the debt implies giving up the debt tax shield and increasing it makes debt service a burden on the firms cash flow. In addition, increasing the debt level may cause a reduced rating of the companys bonds. The marginal tax rate is 35%. All the numbers are expressed in todays dollars. The forecasted average inflation per year is 3.0%.

Cost of debt:

The companys bond rating is roughly at the high end of the A range. Surveying the debt market yielded the following information about the cost of debt for different rating levels:

Bond rating	AA	A	BBB
Interest cost range	4.5% ~ 5.5%	5.25% ~ 6.5%	6.5% ~ 9%

The companys current bonds have a rating of A.

Cost of equity:

The current 10-year Treasury notes have a yield to maturity of 3% and the forecast for the S&P 500 market premium is 6.5%. The companys overall b is 1.35.

b analysis:

The following is information about companies that manufacture generators. The team was not able to find many companies that only manufacture AC motors.

Company	Electrics	Gen, Inc.	General Generators	Universal Power	Generators Inc.	International Motors
Over all b	1.35	1.4	1.5	1.6	1.3	1.45
Debt to equity	0.5	0.3	0.5	0.45	0.35	0.25
Percentage of income from generators	50	45	90	95	85	90

My question is How do I fill this excel sheet out with the information provided in this case? .How do I calculate the warranty cost, depreciation and cost of capital.

1CTX-13 Controller Year 4 Price per Electric Motor 5 Units sold 9,200 40,500 9,200 40,500 9,200 9,200 9,200 9,200 9,200 9,200 40,500 7 Revenue 372,600,000 383,778,000 395,291,340 407,150,080 419,364,583 431,945,520 444,903,886 458,251,002 9 Expenses 10 Labor$4,250/unit 11 Parts $2,500/unit 12 Controller (CTX-13) @ $1,280/unit 13 14 Training 15 Sales/Administration 16 Electric Motor Warranty per unit 17 Controller Motor Warranty (CTX-13) (172,125,000) (177,288,750(182,607,413 (188,085,635) (193,728,204) 199,540,050) (205,526,252) (211,692,039) (101,250,000) 104,287,500 107,416,125) (110,638,609) 113,7(117,376,500 (120,897,795) 124,524,729) (54,997,0S6) (S6,646,968) (58,346,377 (60,096,768 (61,899,671 (63,756,661) (51,840,000) (53,395,200) (100,000,000) 100,000,000) (9,785,000) 9,500,000 (10,078,5S0) 10,380,907) 10,692,334) (11,013,104 (11,343,497) (11,683,802) $0.00 50,000000)(50,000,000 50,000 000)(50,000,000) (50,000,000) (50000,000) (50,000,000) (50,000,000) (9,807,804) (8,602,038)7,360,099) (6,080,902) (4,763,329) (3,406,229) 19 EBIT ($00o) 20 21 Taxes 22 Net Operating Income 23 24 (112,115,000) 110,978,450) 33,634,500 33,293,535 2,942,341 2,580,611 2,208,030 1,824,271 1,428,999 1,021,869 (78,480,500) 77,684,915) (6,865,462) 6,021,426) 5,152,069) (4,256,631) (3,334,330 (2,384,360) INVESTMENT SUMMARY Summary CTX-13 Summary Mt-78 Warranty Costs Cost of Capital 1 CTX-13 Controller Year Year Year Year Year ear Year 26 27 | Plant and Equipment working Capital @ 10% of Revenue 1,000,000,000 (55,890,000) 1,676,700 (1,727,001) (1,778,811) 1,832,175 1,8871411,943,755(2,002,067) 68,737,650 30 Depreciation 31 Gross Salvage Value 32 |-Less. Taxes @ 40% 33 Net Salvage Value ($000) 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 0,000,000 50,000,000 35 Incremental Cash Flow ($000) -> 36 Discounted Cash Flow (1,055,890,000(30,157,200(29,411,916) 41,355,727 42,146,398 42,960,790 43,799,614 44,663,602 116,353,290 349,656,350 Net Present Value ($000) 0 706,233,650 Internal Rate of Return 10.52% Profitability Index 0.33 Payback Years 7.74 COST OF NO. OF PRESENT CAPITALYEARS PMT VALUE Year: 1 2 4 Engine Warranty 0.00% 6 CTX-13 Controller 0.00% 8 MT-78 Controller 0.00% 12 16 17 18 19 Summary CTX-13 Summary Mt-78 Warranty Costs Cost of Capital 2 Current cost (YTM) of company bonds: 4 Tax Rate: 10 Year T-Notes YTM: S&P Market Risk Premium (MRP) 10Company beta: 12 | Debt Ratio: 50% 1: 14 15 Calculations: 16 17R-dat R-dx (1- Tax Rate): 18 19 D/V (D/E)/(1+D/E) 21 R-eq R-rf x (MRP): 24 25 26 27 28 24 WACC-R-dat x D/V + R-eq x E/V : 0.00% Summary CTX-13 Summary Mt-78 Warranty Costs Cost of Capital