ZXY Company is a food product company. ZXY is considering expanding to two new products and a second production facility. The food products are staples with steady demands. The proposed expansion will require an investment of $$7,000,000$ for equipment with an assumed ten$-$year life, after which all equipment and other assets can be sold for an estimated $$1,000,000.$ They will be renting the facility. ZXY requires a $12$ percent return on investments. You have been asked to recommend whether or not to make the investment.

You are an accounting manager. Your boss has asked you to review and provide a recommendation on the expansion based on information that has been provided.

In preparing and supporting your recommendation to either make the investment or not, include the following items as part of your analysis:

Analysis of financial information.

Identification of risks associated with the investment. Consider:

How risky the project appears.

How far off your estimates of revenues and expenses can be before your decision would change.

The difference if the company were to use a straight line versus a MACRS depreciation.

Recommendation for a course of action.

Explanation of criteria supporting your recommendation.

Financial Information

As part of your analysis you might find that additional information from marketing, accounting, or finance would be useful in making an informed and well$-$supported recommendation. In a real workplace setting you would have the ability to ask for that information. However, for the purposes of this assessment, you can make assumptions about the values of that data or ratios in support of your recommendation.

Accounting worked with the marketing group to create the ZXY Company Financial Statements spreadsheet for the new products business and the new facility.

Notes about the financial information:

The expense line labeled SQF FDA Mandates refers to the costs of complying with Food and Drug Administration requirements.

Depreciation expense is calculated using $7-$year life modified accelerated cost recovery system $($MACRS$).$

ZXY $-$ Forecast

Ten Years

Pro$-$Forma Income Statement Year $1$ Year $2$ Year $3$ Year $4$ Year $5$ Year $6$ Year $7$ Year $8$ Year $9$ Year $10$ Total

Brand new Acme System $-$ full system

Income

Revenue

Product A $2,400,0002,800,0002,800,0003,240,0003,900,0003,900,0003,900,0003,900,0003,900,0003,900,00034,640,000$

Product B $900,0001,350,0002,500,0003,000,0004,000,0004,950,0005,500,00022,200,000$

Total $$ Revenue $2,400,0002,800,0002,800,0004,140,0005,250,0006,400,0006,900,0007,900,0008,850,0009,400,00056,840,000$

Cost of Goods Sold

Pest Control $50,00066,55073,20573,20573,20573,20573,20573,20573,20573,205702,190$

SQF FDA mandates $90,00090,00090,00090,00090,00030,00030,00030,00030,00030,000600,000$

Rent $-$ Plant $400,000408,000416,160424,483432,973441,632450,465459,474468,664478,0374,379,888$

Plant Equip. $-$ Fklf $-$ Scrb$/$Lease $40,00064,00064,00064,00064,00064,00064,00064,00064,00064,000616,000$

Plant Equip. $-$ Ongoing maintenance $50,00070,00075,00075,00075,00075,00075,00075,00075,00075,000720,000$

Plant Equip. $-$ Parts $40,00050,00050,00050,00050,00050,00050,00050,00050,00050,000490,000$

Miscellaneous $-$ Equipment $15,00015,00015,00015,00015,00015,00015,00015,00015,00015,000150,000$

Building repairs $25,00025,00025,00025,00025,00025,00025,00025,00025,00025,000250,000$

Plant supplies $100,000120,000144,000109,808120,789132,868146,154160,770176,847194,5321,405,767$

Plant Utilities $120,000210,000240,000240,000240,000240,000240,000240,000240,000240,0002,250,000$

Garbage removal$/$Janitorial $30,00045,62652,47052,47052,47052,47052,47052,47052,47052,470495,388$

Plant telephone