MBA 5010: Expansion Recommendation for ZXY Company (9/17/2024)

 

Expansion Recommendation for ZXY Company

 

Executive Summary

ZXY Company is a food product company considering adding two new products to its offerings and an additional production facility. ZXY’s current food products are staples with steady consumer demands. This expansion would 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. ZXY Company will rent the new facility. ZXY requires a 12 percent return on investment to agree to the expansion (Capella University, n.d.). ZXY Company provided a Pro-Forma income statement, a list of its cost of goods sold (COGS) and other expenses, and a cash flow forecast statement. This report aims to perform a financial analysis of the financial documents,  assess potential risks, and provide a recommendation for the proposed expansion.

Risks

ZXY Company's expansion proposal faces many risks that could significantly impact its operations, including financial, regulatory, consumer, market, technical, and supply chain risks. Changes in consumer preferences and economic conditions can affect demand for new products, while increased competition may lead to lost sales (Kotler & Keller, 2016). Economic factors such as inflation or recession can also reduce product demand. Regulatory changes, like food safety standards or environmental regulations, may impose additional compliance costs or operational constraints, potentially leading to penalties or reputational damage if ZXY fails to adapt. Technological risks include the reliability of older technologies, the development of new technologies, and maintenance requirements (Deossa et al., 2017). In food production, these technical risks might involve limitations in processing capacity, storage facilities, or compliance with safety regulations. Operational inefficiencies can increase costs, market risks related to raw material prices, and competition (Marshall et al., 2023). Supply chain disruptions can lead to shortages of raw materials, resulting in production delays, increased costs, and an inability to meet customer demand. This could ultimately harm a company’s reputation and market share (Chui et al., 2022). Additionally, ZXY is subject to demand fluctuations due to seasonal changes and economic conditions (Momani et al., 2016). Uncertainties in the costs and availability of raw materials and utilities are also critical; for example, food manufacturing relies heavily on energy, making fluctuating energy costs a significant concern that can influence operational expenses and strategic planning (Schoenberg, 2017). By addressing these risks proactively, companies can make more informed investment decisions.

Revenue

ZXY’s revenue for both products increases from 2,400,000 for the first year to 9,400,000 by the tenth year (Appendix A). The increase in revenue indicates a growing market demand for a company’s products (Kotler & Keller, 2016). This suggests that the company has maintained a solid customer base and demand that could strengthen the adoption of two new products and support the expansion proposal.

Gross Profit Margin

Margin ratios help determine a company’s profitability. The gross profit margin, or gross margin, evaluates a company's gross profit relative to its revenue. It reflects the difference between sales revenue and the cost of goods sold (Marshall et al., 2023). A high gross margin value means that the company retains more of its profit after it pays the costs of goods sold. This could indicate that the company is managing its production and costs efficiently. A company with a high gross margin may have a competitive advantage and can set market prices. In contrast, a low gross margin may indicate that a company has more competition (Hayes, 2024). ZXY Company’s gross margin increases from 24.%  the first year to 71.7% by the tenth year, with the lowest value in the third year at 11.4%. The significant improvement from Year 1 to Year 10 indicates improved cost control and higher product margins.

Table 1

Gross Margin

(Adapted by the author with data from Appendix A).

Net Profit Margin

The net profit margin, or net margin, gauges a company's ability to generate earnings after deducting all expenses and taxes. It serves as a key indicator of the company's overall financial health. It shows whether the company is effectively generating profit from sales while managing its costs (Hayes, 2023).  It is calculated by dividing net income by total revenue.

Table 2

Net Profit Margin

(Adapted by the author with data from Appendices A & B).

The company will have a negative net profit margin in the first three years: -3.1% in the first year, -11.5 the second year, and -35.5% in the third. The fourth year is the first year the company has positive earnings; however, the steady increase from 14.9% in year four to 46.6% for year 10 indicates a positive growth trend. Because the net profit margin accounts for all expenses, including one-time expenses that increase the profits for only one period, it is necessary to consider other profitability ratios with the net profit margin (Hayes, 2023).

Cash Flows

Cash flows represent the inflow and outflow of cash within a company over a specific period, which is vital in evaluating its overall financial health. Cash flows are categorized into three main types: operating activities, investing activities, and financing activities. Analyzing cash flows is essential for assessing a company's financial viability, as positive cash flow indicates the ability to meet obligations and invest in growth. In contrast, negative cash flow may signal potential financial distress (Marshall et al., 2023). ZXY Company provided a forecast of cash flows that include the cash flow before income taxes, the pre-tax cash flow, and after-tax cash flow (Table 3).

Table 3

Forecast of Cash Flows

(Adapted by the author with data from Appendix C).

In Table 3, the pre-tax cash flow and after-tax cash flow have negative values in the first year but steadily increase to positive values by year three and continue to increase steadily even after taxes are deducted in years six through ten. The cash flow before income taxes starts positive at 112,413 and maintains a positive growth trend to 6,297,791 by year ten. The improving cash flows indicate financial health with continued positive growth.

Capital Budgeting and Net Present Value

Capital budgeting methods assist management in determining which opportunities will create the most value for the company (Marshall et al., 2023). Capital budgeting can help assess the equipment and potential products to determine whether the investment will provide a sufficient return on investment (ROI) (Marshall et al.,2023). There are several methods for capital budgeting; however, the Net Present Value (NPV) method recognizes the time value of money and examines the company’s cash flows, which is necessary to consider for this expansion proposal. NPV can help determine whether the ZXY Company should proceed with the proposed expansion. NPV helps deduce whether the projected cash flows from the new facility will meet or exceed the company's required return on investment (ROI) of 12%. To calculate the NPV, the Present Value is first calculated using the formula PV= cash flow/ (1 + discount rate)^t, where t is the number of periods. Table 4 lists the calculated PV values and the calculated discounted cash flows.

Table 4

Discounted Cash Flow

(Adapted by the author with data from Appendix C).

Next, to calculate the NPV, the initial investment is subtracted from the total discounted cash flow (6,389,922 – 7,000,000 = - 610,078. Since the NPV is -610,078, the company should not continue this expansion. If the financial data used MACRS depreciation, the investment's NPV may increase due to the early tax benefits, making the project more financially appealing (Marshall et al., 2023). However, expansion is not advisable with either depreciation method as the NPV indicates the company will not meet its expected 12% ROI with this investment.

Appendices

 

Appendix A: Pro-Forma Income Statement

 

(ZXY Company’s Proform Income Statement by Capella University Instructions, n.d.).

Appendix B: Expenses Other Than COGS

 

(ZXY Company’s Expenses Other Than COGS by Capella University Instructions, n.d.).

Appendix C: Forecast of Cash Flows

 

(ZXY Compnay’s Forecast of Cash Flows by Capella University Instructions, n.d.).

 

References 

Capella University Instructions. (n.d.). Assessment 4 expansion recommendation [Instructions]. https://courseroom.capella.edu/courses/27380/pages/assessment-4-instructions?module_item_id=1371819

Chiu, Y-J., Hu, Y-C., Yao, C-Y., & Yeh, C-H. (2022). Identifying key risk factors in product development projects. Mathematics, 10(8). https://doi.org/10.3390/math10081295

Deossa, P., De Vos, K., Deconinck, G., & Espinosa, J. (2017). Generation expansion models, including technical constraints and demand uncertainty. Journal of Applied Mathematics. https://doi.org/10.1155/2017/3424129

Hayes, A. (2024, June 25). Profitability ratios: What they are, common types, and how businesses use them. Investopedia. https://www.investopedia.com/terms/p/profitabilityratios.asp

Kotler, P., & Keller, K. L. (2016). Marketing Management (15th ed.). Pearson.

Marshall, D. H., McManus, W. W., & Viele, D. F. (2023). Accounting: What the numbers mean (13th ed.). McGraw-Hill.

Momani, A. M., Al-Hawari, T., & Mousa, R. W. (2016). Using expanded real options analysis to evaluate capacity expansion decisions under uncertainty in the construction material industry. South African Journal of Industrial Engineering, 27(2), 1–14. https://doi.org/10.7166/27-2-1370

Schoenberg, S. (2017, February 14). Energy costs factor into business development, expansion decisions. Mass Live. https://www.masslive.com/politics/2017/02/as_businesses_consider_wmass_m.html