Analyse the efficiency position of your company in 2021 compared to 2020 and 2019. Use two efficiency ratios, the inventory turnover and average collection period. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis’ titles.

 

Statement 2019 Sales 58,674,100 Woolworths Income 2021 2022 (Forecasted) 2020 60,952,200 60,868,400 Cost of Goods Sold 42,912,600 44,474,600 44,344,800 Gross Profit 15,761,500 16,477,600 16,523,600 Selling, General and Administrative 9,616,300 Fixed Expenses 2,000,000 10,062,900 2,000,000 2,000,000 7,198,800 Depreciation Expense 798,200 798,200 798,200 EBIT 3,347,000 3,616,500 6,526,600 Interest Expense 387,900 26,800 254,800 Earnings Before Taxes 2,959,100 3,589,700 6,271,800 Taxes 887,730 1,076,910 1,881,540 Net Income 2,071,370 2,512,790 4,390,260 Dividend Per Share 1.84 1.94 1.99 Tax Rate 30% 30% 30% 30% Woolworths Balance Sheet Assets 2019 2020 2021 Cash and Equivalents 903,400 935,300 1,521,900 Accounts Receivable 698,500 616,700 584,000 Inventory 4,205,400 4,693,200 4,872,2001 Total Current Assets 5,807,300 6.245,200 6,978,100 Plant & Equipment 17,783,300 19,016,000 20,316,000 Accumulated Depreciation 8,537,200 9,415,300 10,253,900 Net Fixed Assets 9,246,100 9,600,700 10,062,100 Total Assets 15,053,400 15,845,900 17,040,200 Liabilities and Owner's Equity Accounts Payable 2,280,000 3,006,300 3,181,200 Short-term Notes Payable 168,100 217,900 1,643,700 Other Current Liabilities 1,113,100 1,173,500 1,241,100 Total Current Liabilities. 3,561,200 4,397,700 6,066,000 Long-term Debt 3,488,900 2,393,900 1,235,100 Total Liabilities 7,050,100 6,791,600 7,301,100 Common Stock 4,342,200 4,631,200 4,909,000 Retained Earnings 3,661,100 4423,100 4,830,100 Total Shareholder's Equity 8,003,300 9,054,300 9,739,100 Total Liabilities and Owner's Equity 15,053,400 15,845,900 17,040,200 Ordinary Shares Outstanding 1,231,900 1,250,200 1,259,800 1,259,800 i