How to fill this out?
ali all ile Format Painter Merge & Center Formatting - Table Clipboard Tant Alignment Number doubtful accounts. Effective management of receivables is critical for most companies. Generally, the change in receivables should be consistent you will need to go with the change in sales. Provide the following detailed information regarding sales, accounts receivable and allowance for to EDGAR and use Interactive Data to Must link to Horizontal Vertical Analysis every cell possible; otherwise find data in Notes to Rs on EDGAR complete some portions of this SLA Sthcrease increase Current Year Prior Year (Desteese) (Decremte) 1 2 3 Sales revenues 4 Accounts Receivable and Qur eatiar cutenes 5 Less: Allowance for doubtful accounts NDIV/! Erd 6 Accounts Receivable, net Allowance for doubtful accounts as a % of Sales ar 8 Allowance for doubtful accounts as a Gross AR 9 What is percentage change in Gross Ak? What is percentage change in Revenue? Are these changes similar, do they align; or different and what does that mean for the company Narrate your response using proper ratio analysis and accounting 10 language of business Did company increase or decrease Allowance for Doubtful Accounts and was the change in AR in the same direction was the Allowance for doubtfaccounts as of Sales AND GROSS AR the same for both years, Increase or decrease? What 12 do these comparisons tell you about company's view of collectibility of amounts due from customers! Calculate AR Turnover and Average Days to Collect Receivables in table below for current and prior years. Has ratio improved 14 or deteriorated year over year, what does that mean? 16 Ratio Formula 17 net credit sales/avg. net AR 15 365 / AR turnover Current Year Prior Year 0.00 VENO worker Sales & AR Cash Flows H Ne CF Company Selection Reuters kry Ratios Ethib Nike, Inc. Balance Sheets: Vertical Analysis May 31, Fallon) Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories 3 Other Current Assets Total Current Assets Property, Piant and Equipment, net 1 Total Intangibles and Other Assets 2 Total Assets 3 14 Current Liabilities 35 Accounts Payable 86 Accrued Liabilities 37 Other Current Liabilities 38 Total Current Liabilities 89 Long-Term Debt 90 Other Noncurrent Liabilities 91 Total Liabilities 92 Stockholders' Equity 93 Common Stock 94 Additional Paid in Capital 95 Retained Earnings 96 Accumulated Other Comprehensive Income IL 97 Less Treasury Stock at cost 98 Total Stockholders' Equity 99 Total Liabilities and Stockholders' Equity 100 101 102 103 104 105 106 107 108 Nof 2013 tal Assets $4,466 18.839 4,272 18.01% 5,622 23.70% 2,165 9.13% 16,525 69.68% 4,744 20.00N 2,448 10.329 $23,717 100.00% Nof 2013 otal Assets $2,612 11.0196 5,010 21.12% 244 1.03% 7,866 33.17% 3,464 14.61% 3,347 14.115 14,677 61 88% of 2018 al Assets $4,249 18 859 3,498 15.52% 5,261 23.34% 2,126 9.43% 15,134 67.15% 4,454 19.76 2,948 13.08% $22,536 100.00 Nof 2018 tal Assets 52,279 10.119 3,269 14 519 492 2.18% 6,040 26,80N 3,468 15.39% 3,216 14.27% 12,724 56.46N Nof 2017 al Assets $3,808 16.37% 3,677 15.81% 5,055 21.73% 3,521 15.14% 16,061 69.05% 3,989 17.15N 3,209 13.80W $23,259 100.00% Nof 2017 al Assets 52,048 8.81 3,011 12.95 415 1.78% 5,474 23.53N 3,471 14.92% 1,907 8.20% 10,852 46.66% 3 7,163 1,643 231 0 9,040 523,717 0.01% 30,20% 5.93 0.97% 0.00N 38.15 100.0% 6,384 3,517 (92) 0 9,812 $22,536 0.01% 28.33 15.61% -0.419 0.00N 43.54N 100.00 3 5,710 6,907 213) 0 12,407 $23,259 0.01% 24.559 29.70% -0.929 0.00N 53.34% 100.00N Common-site Balance Sheet presented as a Percentage of Total Assets Item Amount Total Assets column trou
