FSA 7120 Module 4 Written Assignment: A Credit Analysis of a Mid-Sized Manufacturer Example

Can Harlow Carry Its Debt? Coverage, Cash Flow and a Downside Case for a Refinancing

Student Name

Master of Business Administration, Thomas Edison State University

FSA-7120: Financial Statement Analysis

Mentor Name

Month Day, Year

Can Harlow Carry Its Debt? Coverage, Cash Flow and a Downside Case for a Refinancing

Introduction

Credit analysis asks a narrower question than equity analysis. A lender's upside is capped at interest and principal, so the lender cares less about how much a borrower might earn and more about whether it will earn enough in a poor year. Fridson and Alvarez (2011) therefore emphasize cash flow, coverage and the quality of the earnings behind them. This paper evaluates Harlow Fixtures, the composite lighting manufacturer from earlier modules, as it seeks to refinance a $120 million term loan maturing in 2026.

Core Credit Ratios

The recast column uses Module 2's adjustments, which lowered operating income by $8.0 million. The longer useful lives changed only depreciation, which EBITDA leaves out, so recast EBITDA falls by the expensed software and the larger inventory reserve, $5.4 million in all. Funds from operations equal net income plus depreciation and amortization, and on either basis they cover more than a third of debt each year.

Placing the Ratios Against Rating Ranges

Rating agencies publish guidance that maps ratios like these to rating categories for industrial companies. On debt to EBITDA of about 2.0 times and funds from operations above 30 percent of debt, Harlow's financial profile is consistent with the middle of the investment grade range, roughly BBB. Its business profile is weaker than its numbers: sales of under $500 million, two distributors that account for a third of sales and exposure to construction spending usually pull a small manufacturer down one or two notches. A fair overall view is low BBB to high BB. Kaplan and Urwitz (1979) showed that a handful of accounting ratios, size and debt subordination explain much of the variation in bond ratings, which supports building the view from these measures.

The Downside Case

Lighting fixtures follow commercial construction. A 15 percent fall in sales, the kind of drop a moderate construction recession would bring, is a reasonable stress case.

Gross margin falls in the downside case because factory costs do not shrink with volume, and operating expenses are trimmed by only about $2.4 million. EBITDA roughly halves, interest is still covered three and a half times, but debt rises to 3.6 times EBITDA, which would breach the current 3.0 times covenant. A breach does not mean default, but it hands control of the relationship to the lender at a bad moment.

Liquidity and Cash Flow

Harlow held $18.0 million of cash at year-end 2024, and the Module 3 forecast projects $30.4 million by the end of 2025. Operating cash flow of about $46 million covers planned capital spending of $25 million with room for dividends. In the downside case, working capital would release cash as receivables and inventory shrink, a cushion that partly offsets lower profit. A $25 million undrawn revolving facility would give enough liquidity to cover a full year of interest and the most likely capital spending even if EBITDA halved.

Recommendation

The bank should refinance the $120 million at a BBB-minus or BB-plus pricing level with three conditions. First, set the maximum debt to EBITDA covenant at 3.75 times rather than 3.0 times, which survives the downside case, paired with a minimum interest coverage of 3.0 times. Second, define EBITDA in the agreement to exclude capitalized development costs and recurring restructuring charges, closing the gaps found in Module 2. Third, require quarterly reporting of gross margin, since the Module 3 sensitivity analysis showed margin to be the driver of earnings. Altman (1968) found that measures of profitability relative to assets were among the most useful early signals of failure, so the lender should also track operating income to total assets over time.

Conclusion

Harlow can carry its debt in a normal year with comfortable coverage, and its cash flow would survive a construction downturn. Its covenants, not its solvency, are the weak point. A refinancing with realistic covenant headroom and a tighter definition of EBITDA protects the lender without forcing an unnecessary breach.

References

Altman, E. I. (1968). Financial ratios, discriminant analysis and the prediction of corporate bankruptcy. The Journal of Finance, 23(4), 589-609. https://doi.org/10.1111/j.1540-6261.1968.tb00843.x

Fridson, M., & Alvarez, F. (2011). Financial statement analysis: A practitioner's guide (4th ed.). John Wiley & Sons.

Kaplan, R. S., & Urwitz, G. (1979). Statistical models of bond ratings: A methodological inquiry. The Journal of Business, 52(2), 231-261. https://doi.org/10.1086/296045