AutoSave OFF Corp CreditAnalysis Hardware Hawaii Question.xltx - Compatibility M Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 ' ' ab Wrap Text General Paste B I U Merge & Center $ % 9 0 00 0 Conditional Formatting D23 A B 1 2 C fx D E F G H | J K L M N Hawaii Mill Hardware (in US$ Millions) Corporate Credit Analysis 3 2019 2020 Ratios for 2020 4 ST Debt 60 60 Debt/(Debt + Equity) 56% Approximate Rating BB 5 LT Debt 50 30 6 FCF/Debt 7 Common Stock 20 25 8 Retained Earnings 55 45 FFO/Debt 9 10 Interest Expense 6 11 Tax Expense 3 12 Net Income 10 13 Depreciation Exp 15 14 CF from WC changes -10 15 CF from Capex -10 16 Cash on B/S 20 17 18 Total Debt 110 19 Total Equity 75 20 Total Capital 185 160 21 Average Capital 172.5 5115252 2263 EBIT/Average Capital -1 -1 EBIT/Interest Expense 20 -5 90 70 Debt/EBITDA Notes 1) Company has been in business over 100 years 2) 2020 is only the 4th time the company lost money. 3) Company has been a very good customer of the bank for 50 years. You are their main bank 4) Your bank currently has $15 million of credit risk exposure to Hawaii Mill. Questions 22 23 FFO 24 CF Ops 25 FCF 26 EBIT 27 EBITDA 28 29 30 31 32 1) What is your LT debt rating for Hawaii Mill? 2) In addition to the above ratios, what other factors (pros and cons) would you incorporate into your analysis of Hawaii Mill's credit strength? (factors can be financial, market, econ, etc) 3) Assume you are under the current Coronavirus situation, Hawaii Mill is asking for a 5 year loan for $10 million to shore up its finances. Would you make the loan and why? If so, what interest rate would you charge? What conditions (covenants) would you add to the loan agreement? What additional information would you like to see? 33 34 35 26 Hardware S&P Ratios +