Question

In: Accounting

The Company Lenz-Simon Corporation specializes in the production of precision metal castings for use in the...

The Company

Lenz-Simon Corporation specializes in the production of precision metal castings for use in the automotive industry. Because its precision castings are used in transmissions, steering-assembly parts, and crankshafts, LSC customers require extremely high quality products from the firm. For its part, LSC has met the challenge and has become a preferred supplier to many of the top automotive firms in North America and Europe. Benefits of being a preferred supplier include longterm supply contracts and preferential bidding on new contracts. LSC is a closely-held firm with the founding Simon families owning 51% of the common shares outstanding. LSC common stock trades on Nasdaq. LSC has traditionally employed a hurdle rate of 15% on invested capital, but this rate has not been reviewed since 1985. Cydney believes the firm’s existing capital structure of 30% debt-70% equity is optimal for LSC. The debt consists entirely of loans from Fifth Dimension Bank and bears an interest rate of 8.5%. LSC’s federal-plus-state marginal tax rate is about 40%. Going back to the early 1980s, the firm has sought to earn a rate of return on its equity investment of about 18%. A financial analyst has supplied Cydney with some financial information: the yield on 20-year US Treasury bonds is currently at 5.0% and the market risk premium is about 6.5%. The beta coefficient for LSC is 1.3, which is consistent with other firms in the industry that have similar capital structures.

The Aspen Automated Mold-Maker Machine

LSC currently uses six semi-automated machines to produce its precision molds. The process requires some heavy lifting from workers, and medical claims for back injuries in the molding shop have doubled over the past decade. The existing machines were purchased five years ago at a total installed cost of $443,500 and are being depreciated using 5-year MACRS depreciation. LSC has received an offer of $100,000 for the six machines. LSC management believes that the semiautomated machines will need to be replaced after about six years. The LSC foundry currently operates two eight-hour shifts per day. The firm’s foundry is closed for holidays and most weekends; therefore production occurs 240 days per year. The current semi-automated machines require 12 workers per shift (24 in total) at $11.50 per worker per hour, plus the equivalent of 1.5 maintenance workers per shift, each of whom is paid $9.25 an hour, plus maintenance supplies of $5,600 a year. Cydney assumed that the semi-automated machines, if kept, would continue to consume electrical power at the rate of $17,750 a year.

The cost of the new Aspen automated molding machine would be $1,075,000, which includes shipping from the manufacturer in Boulder, Colorado. Over the past year, LSC has been setting aside funds into an account for future capital expenditures for these types of projects; to date, $165,500 has been designated from this fund to effectively lower the up-front equipment cost to $909,500. LSC engineers estimate that installation and modifications to the plant will cost $245,000 and LSC would capitalize and depreciate these costs for tax purposes. The Aspen would be depreciated using 5-year MACRS depreciation.

A senior plant engineer estimates that the Aspen Mold-Maker would need to be replaced after the sixth year and would have an estimated salvage value of $190,000 at that time. The new machine would require two skilled operators (one per eighthour shift), each receiving $16.25 per hour (including benefits). LSC would also enter into an annual maintenance contract for the Aspen mold-maker at an annual cost of $65,700. Power costs are estimated to be $38,600 yearly. In addition, the automatic machine is expected to generate annual savings of $7,500 through improved labor efficiency in other areas of the foundry. All savings and costs, excluding depreciation, are expected to increase at the expected inflation rate of 3% per year.

Cydney finds certain aspects of the decision to purchase the Aspen molding equipment difficult to quantify. In order to smooth the production workflow with the existing semi-automated machines, about 30% of foundry’s floor space is devoted to wide galleries that are needed to stage raw materials next to each machine. The automated machine would free up about half of the gallery space for other purposes. At the present time, however, there is no need for new space. She believes that the Aspen automated machine would result in even higher levels of product quality and lower scrap rates than the company was now achieving. With intensifying global competition, this outcome may prove to have significant competitive importance. The Aspen has a maximum capacity that is 33% higher than that of the six semi-automated machines; but those machines were operating at only 90% of capacity, and Cydney was unsure when additional capacity would be needed. The latest economic news suggested that the economies of North America Europe would continue with sluggish growth.

Finally, Cydney is unsure whether the tough collective-bargaining agreement her company had with the employees’ union would allow her to lay off the 24 operators of the semi-automated machines. Reassigning the workers to other jobs might be easier, but the only positions needing to be filled were those of janitors, who were paid $8.75 an hour. The extent of any labor savings would depend on negotiations with the union. Assignment Please answer the following questions.

Provide detailed calculations in EXCEL that support your answer for each question. Include any assumptions that you make. I strongly suggest that you do your calculations in a spreadsheet.

1. Compute the estimated net initial investment for the proposed capital investment.

2. Compute the net operating cash flows after tax for the proposed capital investment over the proposed life of the project. At this point, assume Aspen is able to eliminate all 24 current operators.

3. What are the terminal cash flows in the final year?

4. What is the appropriate cost of capital for the proposed project?

5. What is the NPV for the proposed project? Would you accept or reject the project based solely on the NPV that you estimate?

6. Let’s return to Cydney’s concern about the ability to lay off all 24 operators for the existing equipment. Analyze and discuss how uncertainty regarding the labor situation can affect the NPV of the project. Provide supporting calculations from your worksheet.

7. Perform a sensitivity analysis on two uncertain input variables that you believe are important input variables for the project.

8. Based on your results and analysis in answering questions 5-7, would you recommend that the project be accepted or rejected? Discuss.

Solutions

Expert Solution

1. Net initial investment

Equipment cost- 909500

Installation and modification-245000

Cost of each skilled opeartor @16.25 per hour for 8 hours - 260*240=$62400

Less : Present value of Salvage value of old machine at the end of Year 6 at 13.45 % discount rate-190000*.4688=$89072

Net initial investment ----1127828---

2.

Particulars yr1 2 3 4 5 6
Revenues 7500 7725 7956.75 8195.453 8441.316 8694.556
AMC 65700 67671 69701.13 71792.16 73945.93 76164.31
Power cost 38600 39758 40950.74 42179.26 43444.64 44747.98
Depreciation 230900 230900 230900 230900 230900 230900
Tax sheild on depreciation 92360 92360 92360 92360 92360 92360
Tax savings on AMC 26280 27068.4 27880.45 28716.87 29578.37 30465.72
Tax savings on power cost 15440 15903.2 16380.3 16871.7 17377.86 17899.19
Revenue net of tax 4500 4635 4774.05 4917.272 5064.79 5216.733
Cash flows after tax 138580 139966.6 141394.8 142865.8 144381 145941.6

3. Terminal cash flows :

Salvage value- $190000

Annual savings $7500

Terminal cash inflows - $197500

4. Cost of capital = Risk free rate + Beta times of risk premium= 5%+1.3*6.5%=13.45%


Related Solutions

LENZ-SIMON CASTINGS CORPORATION CASE ANALYSIS Cydney Lenz, CFO of Lenz-Simon Corporation (LSC) is considering the purchase...
LENZ-SIMON CASTINGS CORPORATION CASE ANALYSIS Cydney Lenz, CFO of Lenz-Simon Corporation (LSC) is considering the purchase of an Aspen automated mold-maker machine to replace six existing semi-automated molding machines. The Aspen mold-maker machine is expected to improve the quality of LSC precision metal castings and to provide additional capacity for future expansion. Cydney plans to carefully estimate the project’s benefits and costs in order to make a recommendation to the LSC Board of Directors on whether to proceed with the...
LENZ-SIMON CASTINGS CORPORATION CASE ANALYSIS Cydney Lenz, CFO of Lenz-Simon Corporation (LSC) is considering the purchase...
LENZ-SIMON CASTINGS CORPORATION CASE ANALYSIS Cydney Lenz, CFO of Lenz-Simon Corporation (LSC) is considering the purchase of an Aspen automated mold-maker machine to replace six existing semi-automated molding machines. The Aspen mold-maker machine is expected to improve the quality of LSC precision metal castings and to provide additional capacity for future expansion. Cydney plans to carefully estimate the project’s benefits and costs in order to make a recommendation to the LSC Board of Directors on whether to proceed with the...
Q5. High Precision Metal Company has to buy a laser cutting machine. They consider three alternatives...
Q5. High Precision Metal Company has to buy a laser cutting machine. They consider three alternatives as follows: Alternative 1. Down payment $50,000, yearly nominal installment is 20,000 USD in a period of 8 years, and the yearly process and maintenance cost is $3000. The salvage value is $30,000 after 10 years. Alternative 2. $80,000 USD investment and yearly nominal installment is $12,000 in a period of 10 years. The salvage value is $40,000. The yearly process and maintenance cost...
Simon Corporation is considering the acquisition of Ingram Company. Ingram has a capital structure consisting of...
Simon Corporation is considering the acquisition of Ingram Company. Ingram has a capital structure consisting of $7.5 million (market value) of 11% bonds and $15 million (market value) of common stock. Ingram's pre-merger beta is 1.36. Simon's beta is 1.02, and both it and Ingram face a 40% tax rate. Simon's capital structure is 40% debt and 60% equity. The free cash flows from Ingram are estimated to be $4.5 million for each of the next 4 years and a...
You are the production manager for Delta Paint, a regional manufacturing company that specializes in customized paints.
  You are the production manager for Delta Paint, a regional manufacturing company that specializes in customized paints. Your company sells paint by the gallon, and you have the task of forecasting the best production blends to maximize profit and most effectively utilize resources. Instructions:For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open the download file exploring_e06_grader_Capstone.xlsx. 0.000 2 Create appropriate range names for Total Production Cost (cell B18) and...
St. Louis Machining Company is engaged in the production of machine parts. One division specializes in...
St. Louis Machining Company is engaged in the production of machine parts. One division specializes in the production of two machine parts: Part #123 and Part #456. Historically, the profitability of the division has been tied to Part #123. However, in the past two years, the division has been facing intense competition and the sales of this part have declined. The following conversation between Betty DeRose, division manager, and Sandy Beach, marketing manager, reflects the concerns of the division's top...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal end on December 31 and June 30. In 2004 the company decides to expand their operations and finances it by issuing 4,000 bonds at a 14% coupon rate (annual). The bonds pay interest on October 31 and April 30, and are due on April 30, 2019. a. (3 points) Assuming the bonds are issued on April 30, 2004 at 104, record the journal entry(ies)...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal end on December 31 and June 30. In 2004 the company decides to expand their operations and finances it by issuing 4,000 bonds at a 14% coupon rate (annual). The bonds pay interest on October 31 and April 30, and are due on April 30, 2019. a. (3 points) Assuming the bonds are issued on April 30, 2004 at 104, record the journal entry(ies)...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal...
Glen Avon Inc. specializes in the production of telecommunication satellites. The company has a 6-month fiscal end on December 31 and June 30. In 2004 the company decides to expand their operations and finances it by issuing 4,000 bonds at a 14% coupon rate (annual). The bonds pay interest on October 31 and April 30, and are due on April 30, 2019. a. (3 points) Assuming the bonds are issued on April 30, 2004 at 104, record the journal entry(ies)...
Ethical Delima The Precision Parts Corporation manufactures automobile parts. The company has reported a profit every...
Ethical Delima The Precision Parts Corporation manufactures automobile parts. The company has reported a profit every year since the company’s inception in 1980. Management prides itself on this accomplishment and believes one important contributing factor is the company’s incentive plan that rewards top management a bonus equal to a percentage of operating income if the operating income goal for the year is achieved. However, 2018 has been a tough year, and prospects for attaining the income goal for the year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT