How you arrived at your recommendation and show your work.

The Sparklin Automotive Company (SAC) has been in business since 1930. It began business in the United States supplying spark plugs to automotive manufacturers (OEM, the original equipment market) and the automotive aftermarket.
SAC has introduced a new spark plug manufacturing process in the United States that produces a higher quality spark plug guaranteed to last 100,000 miles. The introduction of this spark plug has been very successful in the United States.
In addition to these types of projects, your responsibilities include creating and analyzing the monthly performance of each plant and consolidating the results into a set of financial statements footnoted with explanations.
Assignment:
SAC is considering the purchase of new equipment to manufacture specialty spark plugs. The new equipment would allow the firm to manufacture 100,000 additional spark plugs per year and is expected to have a useful life of 5 years and to have no salvage value at that time. SAC will depreciate the equipment using the straight-line method. Specialty spark plugs are selling for an average price of $20 and are expected to cost $8 to manufacture with the new equipment. Indirect costs are expected to remain the same. The equipment will cost $3,000,000 to purchase and install. SAC’s tax rate is 34%.
The company has Download the following capital structure (see attachment) and intends to keep its capital structure intact in financing this equipment. Use appropriate analytical tools to determine if SAC should purchase the new equipment. Describe how you arrived at your recommendation and show your work.  Excel sprea1dsheet352000 words, excluding title and references