60.1K

Verified Solution

Link Copied!

Analyse the liquidity position of your company in 2020 compared to 2019 and 2018. Calculate the values for two liquidity ratios. Ensure that you analyse in this question, not just describe the ratio values. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis titles.

Woolworths Income Statement 2019 2020 58,674,100 60,952.200 42,912,600 44,474,600 13,761,500 16,477.600 2022 (Forecasted) 2021 60,363.400 44.344.00 16,323,600 Sales Cost of Goods Sold Gross Profit Selling. General and Administrative Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Ner Income 9,616,300 2,000,000 798,200 3,347,000 387.900 2,959.100 887,730 2,071,370 10,062.900 2,000,000 798,200 3,616,500 26,800 3,589,700 1,076,910 2.512,790 7.198.800 2.000.000 798.200 6 526,600 254.800 6,271,800 1.881.540 4.390,260 Dividend Per Share Tax Rate 1.84 30% 1.94 30% 1.99 30% 2021 1. $21.900 584.000 4872.200 6,978,100 20.316,000 10.253.900 10,062,100 17.040,200 Woolworths Balance Sheet Assets 2019 2020 Cash and Equivalents 903,400 935.300 Accounts Receivable 698,500 616,700 Inventory 4,205,400 4,693,200 Total Current Assets 5,807,300 6,245,200 Plant & Equipment 17.783.300 19,016,000 Accumulated Depreciation 8.537.200 9,415,300 Net Fixed Assets 9,246,100 9,600,700 Total Assets 15.053.400 15.845.900 Liabilities and Owner's Equity Accounts Payable 2,280,000 3,006,300 Short-term Notes Payable 168,100 217.900 Other Current Liabilities 1,113.100 1.173.500 Total Current Liabilities 3.561,200 4,397,700 Long-term Debt 3.488.900 2,393.900 Toral Liabilities 7,050,100 6,791,600 Common Stock 4,342,200 4,631,200 Retained Earnings 3,661,100 4,423,100 Total Shareholder's Equity 8,003,300) 9,054,300 Total Liabilities and Owner's Equity 15,053,000 15,845,900 3,181,200 1.643,700 1,241,100 6,066,000 1.235.100 7,301,100 4.909,000 4,830,100 9,739,100 17,040,200 Ordinary Shares Outstanding 1,231,900 1.250.200 1.259,800 1.259,800 Woolworths Income Statement 2019 2020 58,674,100 60,952.200 42,912,600 44,474,600 13,761,500 16,477.600 2022 (Forecasted) 2021 60,363.400 44.344.00 16,323,600 Sales Cost of Goods Sold Gross Profit Selling. General and Administrative Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Ner Income 9,616,300 2,000,000 798,200 3,347,000 387.900 2,959.100 887,730 2,071,370 10,062.900 2,000,000 798,200 3,616,500 26,800 3,589,700 1,076,910 2.512,790 7.198.800 2.000.000 798.200 6 526,600 254.800 6,271,800 1.881.540 4.390,260 Dividend Per Share Tax Rate 1.84 30% 1.94 30% 1.99 30% 2021 1. $21.900 584.000 4872.200 6,978,100 20.316,000 10.253.900 10,062,100 17.040,200 Woolworths Balance Sheet Assets 2019 2020 Cash and Equivalents 903,400 935.300 Accounts Receivable 698,500 616,700 Inventory 4,205,400 4,693,200 Total Current Assets 5,807,300 6,245,200 Plant & Equipment 17.783.300 19,016,000 Accumulated Depreciation 8.537.200 9,415,300 Net Fixed Assets 9,246,100 9,600,700 Total Assets 15.053.400 15.845.900 Liabilities and Owner's Equity Accounts Payable 2,280,000 3,006,300 Short-term Notes Payable 168,100 217.900 Other Current Liabilities 1,113.100 1.173.500 Total Current Liabilities 3.561,200 4,397,700 Long-term Debt 3.488.900 2,393.900 Toral Liabilities 7,050,100 6,791,600 Common Stock 4,342,200 4,631,200 Retained Earnings 3,661,100 4,423,100 Total Shareholder's Equity 8,003,300) 9,054,300 Total Liabilities and Owner's Equity 15,053,000 15,845,900 3,181,200 1.643,700 1,241,100 6,066,000 1.235.100 7,301,100 4.909,000 4,830,100 9,739,100 17,040,200 Ordinary Shares Outstanding 1,231,900 1.250.200 1.259,800 1.259,800

Answer & Explanation Solved by verified expert

See Answer