FIN 320 Final Project Financial Analysis Report

Financial Analysis

Data and Calculation Approach

The company analysis uses Walmart’s Form 10-Q for the quarter ended April 30, 2026, filed May 29, 2026, and compares it with the April 30, 2025 quarter. To remain consistent with the required worksheet methodology, quarter-end balances are used for total asset turnover, financial leverage, return on assets, and return on equity rather than average balances or annualized measures. The resulting ratios should therefore be interpreted as nonannualized worksheet measures rather than direct substitutes for conventional trailing-twelve-month market ratios. Dollar amounts in the financial calculation table are in millions unless noted otherwise (Walmart Inc., 2026b).

Note. Total liabilities exclude redeemable noncontrolling interest. The worksheet P/E uses quarter-end market price divided by quarterly EPS and is therefore nonannualized. Total asset turnover, financial leverage, ROA, and ROE likewise use quarter-end balance-sheet values under the required methodology rather than average balances. The historical closing prices used are $131.93 on April 30, 2026, and $97.25 on April 30, 2025 (Nasdaq, 2026).

Interpretation of Financial Health

The most notable year-over-year change is the improvement in profitability. Total revenue increased 7.3%, operating income increased 5.0%, and net income attributable to Walmart increased 18.8% (Walmart Inc., 2026b). The worksheet net profit margin improved from 2.71% to 3.00%. Although a 3% margin is modest in absolute terms, Walmart’s sales volume means that relatively small changes in margin can produce meaningful changes in earnings. The higher ROA and ROE support the same conclusion, although both measures use quarter-end balances under the required methodology. Ratio analysis is most informative when profitability, efficiency, liquidity, and leverage are considered together rather than as isolated indicators (Brealey et al., 2023).

Asset efficiency weakened slightly. Total asset turnover declined from 0.631 to 0.614 because total assets grew faster than quarterly revenue. Part of the change is consistent with Walmart’s current investment program: capital expenditures were $6.684 billion in the first quarter, compared with $4.986 billion a year earlier, with spending directed toward supply-chain capacity, technology, stores, and customer-facing initiatives (Walmart Inc., 2026b). One quarter of lower turnover is not sufficient to establish a negative trend; the more relevant test is whether the additional asset base subsequently contributes to productivity, revenue growth, or stronger operating margins.

Leverage remained relatively stable. The debt ratio declined from 65.45% to 65.13%, while financial leverage declined from 2.904 to 2.876. Walmart also reported $15.0 billion of committed U.S. credit facilities that were undrawn at April 30, 2026, providing a substantial liquidity backstop (Walmart Inc., 2026b). Short-term borrowing deserves closer attention because it increased to $10.673 billion from $5.595 billion a year earlier. The company has borrowing capacity, but additional short-term obligations should remain tied to identifiable operating needs and repayment sources.

Working Capital Management

Why Working Capital Matters

Working capital management concerns the balance among cash, inventory, receivables, and current obligations needed to support ongoing operations without tying up unnecessary funds. It affects a firm’s ability to pay suppliers, maintain product availability, and convert operating activity into cash. Kumar et al. (2026) report that more efficient working capital management is associated with stronger profitability, operating effectiveness, asset use, and operating cash flow. Because their evidence is drawn from Indian firms rather than U.S. large-format retailing, the findings are best treated as general evidence about working-capital discipline rather than direct evidence about Walmart specifically.

The underlying trade-offs arise throughout the operating cycle. Additional inventory can reduce stockouts but also absorbs cash and increases storage, markdown, and obsolescence costs. More generous customer credit can support sales while delaying cash collection, and supplier-payment timing can either preserve short-term liquidity or strain commercial relationships. Effective working capital management therefore requires coordination across the cash-conversion cycle rather than maximization of any single current-asset or current-liability account (Berk & DeMarzo, 2024).

Application to Walmart

Walmart illustrates why a current ratio below 1.0 requires business-model context. Its working capital deficit increased from $22.7 billion in April 2025 to $26.2 billion in April 2026. Management states that Walmart normally operates with a working capital deficit because it collects much of its cash at the point of sale, uses supplier financing through payables, and maintains access to capital markets (Walmart Inc., 2026b). This operating structure is consistent with the broader working-capital principle that liquidity should be evaluated in relation to cash generation and the operating cycle rather than by one ratio in isolation (Kumar et al., 2026).

The wider deficit nevertheless warrants attention. First-quarter operating cash flow fell from $5.411 billion to $4.738 billion, while higher capital spending pushed free cash flow to negative $1.946 billion. Walmart linked much of the cash-flow change to the timing of inventory receipts and increased investment in its omnichannel strategy (Walmart Inc., 2026b). Inventory growth, supplier terms, short-term borrowing, and capital expenditures should therefore be reviewed together because deterioration across several of these measures could create liquidity pressure even when no single indicator signals distress.

Financing Options for Operations and Expansion

Businesses can finance operations and expansion through internal cash generation, bank credit, short-term market debt, long-term bonds, equity, leases, and supplier credit. The appropriate source depends on the maturity, risk, flexibility, and cash-flow profile of the underlying need (Berk & DeMarzo, 2024; Brealey et al., 2023). Capital structure does not have a universal optimum that applies to every firm; Graham et al. (2015) document substantial variation in corporate leverage across firms and over time. Financing decisions therefore require a balance among cost, refinancing risk, taxes, flexibility, and effects on shareholders.

Internal cash flow and retained earnings avoid new interest obligations and ownership dilution, but using internal funds carries an opportunity cost because the same cash could support dividends, repurchases, debt reduction, or another investment. Bank loans and revolving credit provide flexibility when the amount or timing of a funding need is uncertain, although interest-rate exposure, lender covenants, and collateral requirements may constrain that flexibility (Berk & DeMarzo, 2024).

Commercial paper and other short-term notes can be efficient for large, creditworthy firms with temporary financing needs, whereas long-term bonds and notes are more consistent with long-lived assets because repayment is spread over a longer horizon. The maturity of financing should be aligned with the period over which the financed asset is expected to generate cash flows; otherwise, refinancing risk can become unnecessarily large (Berk & DeMarzo, 2024; Brealey et al., 2023).

Equity financing supplies permanent capital without scheduled repayment, but it dilutes existing shareholders’ claims on future earnings and control. Leasing can reduce the initial cash requirement and spread payments over the asset’s use, yet it still creates an economic financing obligation. Morales-Díaz and Zamora-Ramírez (2018) demonstrate that lease capitalization can materially affect reported assets, liabilities, and leverage, reinforcing the need to evaluate leasing as financing rather than as an off-balance-sheet substitute for debt.

Walmart already uses several of these financing channels. Its April 2026 Form 10-Q reports short-term borrowings, long-term debt, operating and finance lease obligations, and $15.0 billion of undrawn committed U.S. credit facilities. Management expects operating cash flow, existing cash, short-term borrowing, and capital-market access to cover anticipated requirements (Walmart Inc., 2026b). Diversifying financing sources is appropriate because seasonal inventory requirements and long-lived capital investments do not have the same maturity or risk profile (Berk & DeMarzo, 2024).

Short-Term Financing

Short-term financing is most appropriate when the underlying cash need is temporary. Trade credit, revolving lines, short-term bank loans, commercial paper, and receivables or inventory financing can bridge seasonal inventory requirements or timing differences between payments and cash receipts. Maturity matching reduces the risk of financing long-lived assets with obligations that must be repeatedly renewed (Berk & DeMarzo, 2024; Brealey et al., 2023).

The principal risk is refinancing. A firm that depends heavily on short-term debt may have to renew obligations when market rates are higher, lenders are less willing to extend credit, or operating cash flow has weakened. Short-term borrowing also exposes the borrower to faster repricing of interest costs. Accordingly, temporary financing should be linked to a specific operating requirement and a realistic repayment source rather than used to conceal a persistent cash-flow shortfall (Berk & DeMarzo, 2024).

For Walmart, commercial paper and revolving credit are realistic tools because the company has substantial committed credit capacity. However, short-term borrowings increased by more than $5 billion year over year (Walmart Inc., 2026b). Additional short-term financing would be most defensible for seasonal inventory or another temporary cash requirement, not for the permanent cost of a building or another long-lived asset.

Risk and Benefit Analysis of the Three Investment Types

Corporate Bond Investment

A corporate bond can provide regular coupon income, a contractual maturity value, and diversification from an investor’s operating assets. The principal risks include default, interest-rate movements, inflation, reinvestment or call risk when applicable, and market liquidity. Bond value is determined by discounting promised cash flows at a required return that reflects these risks (Berk & DeMarzo, 2024; Brealey et al., 2023). Corporate social performance can also affect debt pricing: Oikonomou et al. (2014) found that stronger social performance was associated with lower corporate bond yield spreads, while social transgressions were associated with higher spreads and weaker credit assessments.

Ethical concerns should be evaluated both as financial risks and as stakeholder obligations. Amiraslani et al. (2023) found that stronger environmental and social performance can provide bond-market benefits when trust becomes especially important, but the ethical significance of child labor does not depend on whether markets immediately price the concern. The International Labour Organization (2025) reported that child labor still affected approximately 138 million children globally in 2024. When a bond issuer has an unresolved supply-chain labor concern, independent evidence of remediation is necessary before the issue can reasonably be treated as closed.

Capital Equipment and Real Property

Capital equipment and real property can improve capacity, productivity, safety, and operating cost over many years, but they also require a large commitment before all future benefits are known. The main financial risks are forecasting error, maintenance expense, technological obsolescence, and a lower-than-expected resale value. NPV is useful because it converts the project’s expected future cash flows into today’s dollars using the required return; payback by itself ignores both the time value of money and cash flows after the payback date (Brealey et al., 2023).

The site history in the building scenario adds an environmental risk that should be priced into the decision. The EPA describes former gasoline-station properties as petroleum brownfields and stresses the importance of due diligence before purchase (U.S. Environmental Protection Agency, 2025). From an ethical standpoint, cleanup and safety costs should be included honestly in the project rather than excluded from the model to preserve a positive NPV.

Capital Lease

A finance lease can preserve cash at the beginning of a project and spread payments over the period in which the equipment is expected to earn benefits. This can be attractive when technology changes quickly or when ownership is not the main objective. The drawbacks are fixed payments, contract restrictions, termination penalties, and an effective financing cost that may be higher than purchasing the asset. Morales-Díaz and Zamora-Ramírez (2018) show why lease obligations also matter for ratio analysis: capitalizing leases changes reported assets, liabilities, and leverage.

A lease should therefore be evaluated as a substantive financing commitment rather than as a mechanism for minimizing reported debt. Walmart reported $6.033 billion of finance-lease right-of-use assets and $6.673 billion of current and long-term finance-lease obligations at April 30, 2026 (Walmart Inc., 2026b). Any additional lease would increase future fixed payments. A complete evaluation should also consider energy use, worker safety, waste, maintenance, and disposal requirements because those factors affect the asset’s full economic cost over its useful life.

Financial Evaluation of the Specified Assumptions

The investment evaluation uses the specified scenario figures and assumes that stated annual cash flows occur at the end of each year. NPV is the primary decision rule, with IRR and simple payback used as supporting measures. Corporate-finance theory generally gives NPV priority because it measures value created after accounting for the required return, whereas IRR and payback can produce misleading rankings in some settings (Berk & DeMarzo, 2024; Brealey et al., 2023). Where the scenarios provide accounting profit or an aggregate lease commitment rather than a complete cash-flow schedule, the simplifying assumptions used to convert those inputs into project cash flows are stated explicitly below.

Bond Investment Evaluation

The bond has a $30 million face value, an 8% annual coupon, a 10-year maturity, and a price of 95. The purchase price is therefore $28.50 million, and the annual coupon is $2.40 million. Discounting the coupons and the $30 million maturity payment at the required 9% return produces a present value of approximately $28.07 million. NPV is therefore approximately negative $0.43 million. The yield that equates the promised cash flows to the purchase price is approximately 8.77%, below the 9% required return. This follows the standard bond-valuation approach of discounting promised cash flows at the investor’s required return (Berk & DeMarzo, 2024).

The bond should be rejected at the stated price. The financial case fails because the estimated yield is below the required return and the NPV is negative. The unresolved labor concern further weakens the investment case. The scenario indicates that the issuer’s assembler has a history of child labor and that the claimed correction has not been independently verified. Evidence that social performance affects corporate debt pricing (Amiraslani et al., 2023; Oikonomou et al., 2014), together with the continuing global prevalence of child labor (International Labour Organization, 2025), supports requiring credible third-party verification before reconsidering the issuer even if the bond were repriced.

Building and Capital Equipment Evaluation

The building requires a $10 million cash outlay, is expected to produce $1.25 million in annual after-tax net profit for 20 years, has a $1.5 million salvage value, and is evaluated at a 10% discount rate. Because the scenario does not provide separate depreciation, tax, or working-capital cash-flow adjustments, the analysis assumes that the stated annual after-tax net profit approximates annual after-tax project cash flow. Under that simplifying assumption, the present value of the 20 annual amounts is approximately $10.64 million and the present value of the salvage value is approximately $0.22 million. Total present value is therefore approximately $10.86 million, producing an NPV of approximately positive $0.86 million, an estimated IRR of 11.21%, and a simple payback period of 8.0 years. The project clears the stated financial hurdle, but the conclusion is sensitive to the cash-flow proxy assumption.

The principal concern is the limited margin of safety. A positive NPV of approximately $865,000 could be eliminated by tank removal, soil or groundwater remediation, additional permitting, or project delays at the former gas-station site. EPA guidance on petroleum brownfields makes this risk directly relevant (U.S. Environmental Protection Agency, 2025). LEED certification addresses building performance but does not resolve potential site contamination. Conditional approval is therefore appropriate only after a Phase I environmental site assessment, any necessary follow-up testing, confirmation of underground tank status, and a quantified estimate of remediation responsibility and cost.

Walmart has the scale to pay $10 million in cash; it reported $10.729 billion of cash and cash equivalents at April 30, 2026 (Walmart Inc., 2026b). Even so, corporate size should not replace project discipline. The cash purchase would make working capital about $10 million more negative if nothing else changed, so the board should still ask whether the expected return justifies the cash use after environmental costs are included.

Capital Lease and Equipment Evaluation

The equipment alternative is presented as a $25 million lease-related economic commitment that generates $4 million in annual cash flow for 15 years, has no salvage value, and uses a 12% required return. Because the scenario does not provide an actual lease-payment schedule, the analysis treats the $25 million commitment as a time-zero economic outlay for valuation purposes. Under that simplified assumption, the present value of the annual cash flows is approximately $27.24 million. NPV is therefore positive $2.24 million, the estimated IRR is 13.65%, and the simple payback period is 6.25 years. Of the three alternatives, this project creates the largest estimated dollar value under the stated assumptions.

The newer equipment is also expected to use less electricity and create less plastic waste. Those benefits should be supported by documented operating evidence rather than accepted solely as qualitative claims. Before execution, management should quantify expected energy consumption, waste reduction, maintenance cost, disposal obligations, and worker-safety effects. The lease contract should also be reviewed for payment timing, purchase or renewal options, residual-value provisions, maintenance responsibilities, and termination penalties. If the present value of unavoidable lease payments differs materially from the assumed $25 million commitment, the NPV should be recalculated.

The equipment lease ranks first among the three alternatives. It has the highest NPV and IRR and aligns with the type of automation and supply-chain investment Walmart is already undertaking. It also avoids the specific site-contamination risk associated with the building. The lease nevertheless creates another fixed obligation and should be monitored alongside Walmart’s existing lease liabilities and short-term liquidity position (Walmart Inc., 2026b).

Combined Recommendation

The three projects are not necessarily mutually exclusive, but they should still compete for capital. The recommended ranking is the equipment lease first, the building second subject to environmental conditions, and the bond last. The lease produces the largest estimated NPV and has a direct operating use. The building produces a positive NPV under the stated cash-flow proxy, but its margin of safety is small relative to potential environmental costs. The bond fails the required-return test before the unresolved labor concern is considered.

Future Financial Considerations

The future outlook excludes the specified investment scenarios and focuses on Walmart’s current operating performance. The first quarter of fiscal 2027 was encouraging: total revenue grew 7.3%, net sales grew 7.1%, operating income grew 5.0%, and reported diluted EPS increased 19.6% to $0.67. Walmart also reported 26% growth in global eCommerce net sales and continued growth in membership and advertising-related income (Walmart Inc., 2026c). These businesses may support earnings growth without relying exclusively on the traditional low-margin merchandise model.

As of May 21, 2026, management expected fiscal 2027 constant-currency net sales growth of 3.5% to 4.5%, adjusted operating income growth of 6% to 8%, adjusted EPS of $2.75 to $2.85, and capital expenditures of approximately 3.5% of net sales (Walmart Inc., 2026c). Operating income growing faster than sales would support further margin improvement, but guidance remains a forecast rather than a realized result. Performance should therefore be evaluated against subsequent operating income, cash flow, and returns generated by the current investment program.

Cash flow is the principal near-term caution. First-quarter operating cash flow fell to $4.738 billion while property-and-equipment payments rose to $6.684 billion, producing negative free cash flow of $1.946 billion. Short-term borrowings also increased, although Walmart still had $15.0 billion of undrawn committed U.S. credit at quarter end (Walmart Inc., 2026b). The company’s financial position remains supported by its scale and access to liquidity, but free cash flow should recover as inventory timing normalizes and recent capital spending begins to generate returns.

The fiscal 2026 Form 10-K also gives reasons not to treat the outlook as certain. Walmart identifies a changing tariff environment, consumer-demand forecasting, supplier performance, technology and eCommerce execution, cybersecurity, legal and regulatory changes, and the cost of strategic investments as material risks (Walmart Inc., 2026a). These risks are especially relevant for a high-volume retailer because relatively small changes in merchandise cost or operating expense rates can have a noticeable effect on profit.

Overall, the evidence supports a moderate-to-strong outlook, with greater near-term risk in cash conversion than in solvency. Revenue growth, improving profitability, and expanding digital businesses support the positive case. The wider working capital deficit, higher inventory, negative first-quarter free cash flow, and continued capital spending are the weaker elements. Over the next several quarters, the central issue is whether Walmart can convert its current investment program into stronger margins and free cash flow without materially increasing leverage.

Conclusion

Walmart appears financially strong enough to consider new investment, but the analysis does not support accepting every available project. Profitability and EPS improved, leverage moved slightly lower, and the company retains significant financing capacity. At the same time, working capital is more negative and short-term borrowing has increased. That mix favors projects with clear economic returns and financing terms that do not create unnecessary liquidity pressure.

Under the specified assumptions, the equipment lease should be approved after verification of the actual lease terms, the building should receive conditional approval after environmental due diligence, and the corporate bond should be rejected at its current price. The lease creates the greatest estimated value. The building remains economically positive only if the assumed cash flows are realized and environmental costs do not eliminate its limited NPV margin. The bond’s estimated 8.77% yield does not meet the 9% required return, and the labor issue remains unresolved. These recommendations prioritize value creation, transparent recognition of risk, and financing choices that preserve long-term shareholder value.

References

Amiraslani, H., Lins, K. V., Servaes, H., & Tamayo, A. (2023). Trust, social capital, and the bond market benefits of ESG performance. Review of Accounting Studies, 28(2), 421–462. https://doi.org/10.1007/s11142-021-09646-0

Berk, J., & DeMarzo, P. (2024). Corporate finance (6th global ed.). Pearson.

Brealey, R. A., Myers, S. C., Allen, F., & Edmans, A. (2023). Principles of corporate finance (14th ed.). McGraw Hill.

Graham, J. R., Leary, M. T., & Roberts, M. R. (2015). A century of capital structure: The leveraging of corporate America. Journal of Financial Economics, 118(3), 658–683. https://doi.org/10.1016/j.jfineco.2014.08.005

International Labour Organization. (2025, June 11). Despite progress, child labour still affects 138 million children globally. https://www.ilo.org/resource/news/despite-progress-child-labour-still-affects-138-million-children-globally

Kumar, K., Sivasankaran, N., Chakrabarti, P., Kanagaraj, A., & Ramachandran, G. (2026). How does efficient working capital management impact a firm’s fundamentals? Evidence from India. Global Business Review, 27(3), 443–461. https://doi.org/10.1177/09721509221105795

Morales-Díaz, J., & Zamora-Ramírez, C. (2018). The impact of IFRS 16 on key financial ratios: A new methodological approach. Accounting in Europe, 15(1), 105–133. https://doi.org/10.1080/17449480.2018.1433307

Nasdaq. (2026). Walmart Inc. Common Stock (WMT) historical data. https://www.nasdaq.com/market-activity/stocks/wmt/historical

Oikonomou, I., Brooks, C., & Pavelin, S. (2014). The effects of corporate social performance on the cost of corporate debt and credit ratings. The Financial Review, 49(1), 49–75. https://doi.org/10.1111/fire.12025

U.S. Environmental Protection Agency. (2025). Petroleum brownfields. https://www.epa.gov/ust/petroleum-brownfields

Walmart Inc. (2026a). Annual report on Form 10-K for the fiscal year ended January 31, 2026. https://stock.walmart.com/sec-filings/all-sec-filings/content/0000104169-26-000055/wmt-20260131.htm

Walmart Inc. (2026b). Quarterly report on Form 10-Q for the quarter ended April 30, 2026. https://www.sec.gov/Archives/edgar/data/104169/000010416926000102/wmt-20260430.htm

Walmart Inc. (2026c). Q1 FY27 earnings presentation. https://stock.walmart.com/sec-filings/all-sec-filings/content/0000104169-26-000095/earningspresentationfy27.htm