For row 408-413, the answers are either yes or no.

Row 416- The answers are $100/$50/$0 account receivable.

Row 419- account receivable rise/ Account payable rise.

Debt / 4 4 397 379 Credit Analysis Homework 380 You are now the Credit Analyst at Barclays. 381 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: 382 The Rank function is presented in detail in 6. 383 384 Rank 385 Current Acid Interest Debt / Current Acid Interest 386 Ratio Test Coverage Capital Ratio Test Coverage Capital 387 Nordstrom 1.00 0.33 6.60 75% 3 2 3 2 388 Macy's 1.42 0.30 6.82 42% 2 3 2 4 389 Target 0.83 0.10 8.99 54% 1 3 390 L Brands 1.64 0.90 3.23 117% 1 1 4 1 391 392 In column C through F calculate the Average, Median, Minimum and Maximum of the metrics. 393 Calculate the following: 394 395 Current Acid Interest Debt / 396 Ratio Test Coverage Capital Average 398 Median 399 Minimum 400 Maximum 401 402 403 Strategic Assessment of Risk Using the Balance Sheet 404 Please compare the trend in financial performance between 2019 and 2020. 405 Which Balance Sheet item(s) would you consider a red flag that this company might have potential problems down the road? 406 407 2019 2020 408 Revenue Growth 15% 12% 409 EPS Growth 15% 10% 410 DSOS 120 180 411 Inventory Turns 10.0x 5.Ox 412 Interest Coverage 3.Ox 0.5x 413 Debt / Capital 10% 20% 414 415 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? 416 417 418 You are trying to reduce your Operating Cycle'. Which do you want to happen? 419 420