80.2K

Verified Solution

Link Copied!

Analyse your companys leverage ratio in 2021 compared to 2020 and 2019. Use two leverage ratios to support your answer which are total debt ratio and long-term debt ratio. 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.

QUESTION 2:

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 15,761,500 16,477,600 2022 (Forecasted) 2021 60,868.400 44 344800 16.523.600 Sales Cost of Goods Sold Gross Profit Seling. General and Administrative Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Net 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 1.84 Dividend Per Share Tax Rate 1.94 30" 1.99 30 30% 30% Woolworths Balance Sheet 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 4872,200 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 Ner Fixed Assets 9,246,100 9,600,700 10,062.100 Total Assets 15,053,400 15.845.900 17.04.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 4.423.100 4X30,100 Total Shareholder's Equity 8,003,300 9,054,300 9,739,100 Total Liabilities and Owner's Equity 15,033,400 15.845.900 17.040.200 Ordinary Shares Outstanding 1,231,900 1.250.200 1.259,00 1.259.00 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 15,761,500 16,477,600 2022 (Forecasted) 2021 60,868.400 44 344800 16.523.600 Sales Cost of Goods Sold Gross Profit Seling. General and Administrative Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Net 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 1.84 Dividend Per Share Tax Rate 1.94 30" 1.99 30 30% 30% Woolworths Balance Sheet 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 4872,200 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 Ner Fixed Assets 9,246,100 9,600,700 10,062.100 Total Assets 15,053,400 15.845.900 17.04.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 4.423.100 4X30,100 Total Shareholder's Equity 8,003,300 9,054,300 9,739,100 Total Liabilities and Owner's Equity 15,033,400 15.845.900 17.040.200 Ordinary Shares Outstanding 1,231,900 1.250.200 1.259,00 1.259.00

Answer & Explanation Solved by verified expert

See Answer