You are now the Credit Analyst at Barclays. In column G though I below, we have used the RANK function to rank the companies in descending order based on their various liquidity and solvency ratios: The Rank function is presented in detail in Cash Flow Statement (Workbook 6). Rank Acid Test Current Ratio 1.00 1.42 0.83 Interest Coverage 6,60 6.82 Interest Coverage 3 Current Ratio 3 2 Debt/ Capital 2 Acid Test 0.33 0.30 0.10 0.90 2 Debt / Capital 75% 42% 54% 1173 Nordstrom Macy's Target L Brands 3 2 4 8.99 4 3 4 1 1 4 1.64 3.23 1 In column C through Fcalculate the Average, Median, Minimum and Maximum of the metrics. Calculate the following: Average Median Minimum Maximum Strategie Assessment of Risk Using the Balance Sheet Which Balance Sheet Item(s) would you consider a red flag that this company might have potential problems down the road? 2018 Revenue Growth EPS Growth DSOS Inventory Turns Interest Coverage Debt / Capital 2017 15% 15% 120 10.0 3.0x 10% 12% 10X 180 5.OX 0.5x 20% You are running your own business and generate $100 in sales this month. You are worried about your cash balance. Which increase in Accounts Receivable from this month's sales is best for you? You are trying to reduce your Operating Cycle'. Which do you want to happen