AutoSave OFF Corp CreditAnalysis Hardware Hawaii Question.xltx - Compatibility M Home Insert Draw Page Layout Formulas...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 + 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 +
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
The random sample of n=235 yielded a sample mean of x=26. Assume that we know the population standard deviation is =33. Step 2 of 3 : Calculate a 95% confidence interval for the population mean....
-
Twitter got its start in 2006, first with Jack Dorsey and then Evan Williams as CEO. In 2013, its CEO was Dick Costolo, a former Google executive, who steered the firm through one of the most...
-
Salt Lake Inc. is considering adding a new product to its current line of snowboards. They want to focus on the costs and benefits related to adding, or not adding, the new product. What should Salt...
-
- Conducting a case analysis that deals directly with consumer behavior in a contemporary context. - Choose a company/brand or organization that is of interest to you. All companies and organizations...
-
Turner Video will invest $58,500 in a project. The firms cost of capital is 12 percent. The investment will provide the following inflows. Year Inflow 1 ........$15,000 2 ........ 17,000 3 ...........
-
What do you think the overall Time Complexity for heapsort is? Why do you feel this way?
-
The following balance sheets were drawn up immediately after Pai Ltd had acquired control of Filho Ltd. You are to draw up a consolidated balance sheet. Pai Balance Sheet Investment in Filh Ltd:...
-
Annie Zhao is using attributes sampling in testing controls over sales transactions. She is testing five attributes related to sales invoices using an ARO of 5% (confidence level of 95%), and zero...
-
Return to question After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of Schenkel Enterprises. Unfortunately, you will...
-
Complete the following homework scenario: Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the...
-
Oak Mart, a producer of solid oak tables, reports the following data from its first year of business. Sales price per unit Units produced this year Units sold this year Variable selling and...
-
What is the main issue or strategic challenge that Sandland's is facing at the end of the case? Based on your external and internal analysis what changes would you recommend that Sandland makes to...
-
Pardo Company produces a single product and has capacity to produce 160,000 units per month. Costs to produce its current monthly sales of 128,000 units follow. The normal selling price of the...
-
A 0.8 liter of boiled water at 100C is poured into an adiabatic mug in an air-conditioned hotel room of 25C. An educational Stirling engine is placed onto the mug, whereby it receives the heat from...
-
In a supply chain you have the following. CorpA sells machinery to manufacturers. It produced Machin 1 0 1 that cost $ 1 3 , 0 0 0 excluding GST paid for supplies, and sold this to CorpB for $ 4 1 ,...
-
Discuss in detail why a company is preferred against the following business structures: a) trust b) partnership c) sole trader d) superannuation fund Discuss the benefits by keeping in view the...
-
Is the modified 5-question approach to ethical decision making superior to the modified moral standards or modified Past in approach?
-
Read about the ZZZZ Best Carpet Cleaning fraud. What schemes did the fraudsters use?
-
Search the Internet for the outcome of these courtroom scandals: a. Walter Forbes b. Ken Lay c. Jeffery Skilling d. Mark Swartz e. Sam Waksal
-
Using the Internet, learn what type of fraud was found at McKesson \& Robbins in the 1930s. How large a fraud?
Study smarter with the SolutionInn App