Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss, Balance Sheet and Cash Flow Statement. This is to be
Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss, Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied from a financial advisor on the internet. It is not acceptable to simply state one number is bigger than the other and therefore it is better. You need to explain the importance of the number and why it is better/worse.
profit and loss
Balance sheet
Cash flow statement
Company Name Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Item Operating Revenue Other Revenue Total Revenue Excluding Interest Operating Expenses EBITDA Depreciation Amortisation Depreciation and Amortisation EBIT Interest Revenue Interest Expense Net Interest Expense PreTax Profit Tax Expense Net Profit after Tax Before Abnormals Abnormals Abnormals Tax Net Abnormals Reported NPAT After Abnormals Outside Equity Interests Shares Outstanding at Period End Weighted Average Number of Shares EPS Adjusted (cents/share) EPS After Abnormals (cents/share) 06/19 06/18 27,818,000,000.00 66,594,000,000.00 315,000,000.00 558,000,000.00 28,133,000,000.00 67,152,000,000.00 -24,648,000,000.00 -61,486,000,000.00 3,485,000,000.00 5,666,000,000.00 -424,000,000.00 -913,000,000.00 -113,000,000.00 -285,000,000.00 -537,000,000.00 -1,198,000,000.00 2,948,000,000.00 4,468,000,000.00 26,000,000.00 14,000,000.00 -175,000,000.00 -211,000,000.00 -149,000,000.00 - 197,000,000.00 2,799,000,000.00 4,271,000,000.00 -859,000,000.00 -1,246,000,000.00 1,940,000,000.00 3,025,000,000.00 0.00 -421,000,000.00 0.00 0.00 0.00 -421,000,000.00 5,510,000,000.00 1,197,000,000.00 0.00 0.00 1,133,840,000.00 1,133,840,242.00 1,131,000,000.00 1,131,000,000.00 171.38 266.99 486.75 105.65 $Movement %Movement -38,776,000,000 -58.23% -243,000,000 -43.55% -39,019,000,000 -58.11% 36,838,000,000 -59.91% -2,181,000,000 -38.49% 489,000,000 -53.56% 172,000,000 -60.35% 661,000,000 -55.18% -1,520,000,000 -34.02% 12,000,000 85.71% 36,000,000 -17.06% 48,000,000 -24.37% -1,472,000,000 -34.46% 387,000,000 -31.06% - 1,085,000,000 -35.87% 421,000,000 -100.00% O #DIV/0! 421,000,000 -100.00% 4,313,000,000 360.32% 0 #DIV/0! -242 0.00% 0 0.00% -96 -35.81% 381 360.72% 0.00 Company Name Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Wesfarmers Limited Nesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Wesfarmers Limited Wesfarmers Limited Nesfarmers Limited Wesfarmers Limited Nesfarmers Limited Nesfarmers Limited Nesfarmers Limited Wesfarmers Limited Item CA-Cash CA - Receivables CA - Prepaid Expenses CA - Inventories CA - Investments CA-NCA Held Sale CA - Other Total Current Assets NCA-Receivables NCA - Inventories NCA - Investments NCA - PP&E NCA - Intangibles(ExGW) NCA - Goodwill NCA - Future Tax Benefit NCA-Other Total NCA Total Assets CL - Account Payable CL-Short-Term Debt CL-Provisions CL - NCL Held Sale CL-Other Total Curr. Liabilities NCL-Account Payable NCL-Long-Term Debt NCL - Provisions NCL - Other Total NCL Total Liabilities Share Capital Reserves Retained Earnings Other Equity Convertible Equity SE Held Sale Outside Equity Total Equity 06/19 06/18 $Movement Movement 795,000,000.00 683,000,000.00 112000000 16.40% 1,027,000,000.00 1,657,000,000.00 -630000000 -38.02% 0.00 0.00 0 #DIV/0! 4,246,000,000.00 6,011,000,000.00 -1765000000 -29.36% 101,000,000.00 126,000,000.00 -25000000 -19.84% 0.00 0.00 0 #DIV/0! 181,000,000.00 229,000,000.00 -48000000 -20.96% 6,350,000,000.00 8,706,000,000.00 -2356000000 -27.06% 0.00 0.00 0 #DIV/0! 0.00 0 #DIV/0! 3,786,000,000.00 1,139,000,000.00 2647000000 232.40% 3,878,000,000.00 8,408,000,000.00 -4530000000 -53.88% 986,000,000.00 4,369,000,000.00 -3383000000 -77.43% 3,090,000,000.00 13,491,000,000.00 -10401000000 -77.10% 194,000,000.00 692,000,000.00 -498000000 -71.97% 49,000,000.00 128,000,000.00 -79000000 -61.72% 11,983,000,000.00 28,227,000,000.00 -16244000000 -57.55% 18,333,000,000.00 36,933,000,000.00 -18600000000 -50.36% 3,620,000,000.00 6,541,000,000.00 -2921000000 -44.66% 356,000,000.00 1,159,000,000.00 -803000000 -69.28% 1,080,000,000.00 2,041,000,000.00 -961000000 -47.08% 0.00 0.00 0 #DIV/0! 160,000,000.00 284,000,000.00 -124000000 -43.66% 5,216,000,000.00 10,025,000,000.00 -4809000000 -47.97% 0.00 0.00 0 #DIV/0! 2,673,000,000.00 2,965,000,000.00 -292000000 -9.85% 382,000,000.00 1,033,000,000.00 -651000000 -63.02% 91,000,000.00 156,000,000.00 -65000000 -41.67% 3,146,000,000.00 4,154,000,000.00 -1008000000 -24.27% 8,362,000,000.00 14,179,000,000.00 -5817000000 -41.03% 15,728,000,000.00 22,234,000,000.00 -6506000000 -29.26% -5,549,000,000.00 344,000,000.00 -5893000000 -1713.08% -208,000,000.00 176,000,000.00 -384000000 -218.18% 0.00 0.00 0 #DIV/0! 0.00 0.00 0 #DIV/0! 0.00 0.00 0 #DIV/0! #VALUE! #VALUE! 9,971,000,000.00 22,754,000,000.00 -12783000000 -56.18% B Company Name farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited farmers Limited Item Receipts from Customers Payments to Suppliers and Employees Dividends Received Interest Received Interest Paid Tax Paid Other Operating Cashflows Net Operating Cashflows Payment for Purchase of PPE Proceeds From Sale of PPE Investments Purchased Proceeds From Sale of Investments Payments for Purchase of Subsidiaries Proceeds from Sale of Subsidiaries Loans Granted Loans Repaid Other Investing Cashflows Net Investing Cashflows Proceeds from Issues Proceeds from Borrowings Repayment of Borrowings Dividends Paid Other Financing Cashflows Net Financing Cashflows Net Increase in Cash Cash at Beginning of Period Exchange Rate Adj Other Cash Adjustments Cash at End of Period D E F G 06/19 06/18 $Movement %Movement 48,770,000,000.00 75,354,000,000.00 -26584000000 -35.28% -44,892,000,000.00 -69,836,000,000.00 24944000000 -35.72% 65,000,000.00 50,000,000.00 15000000 30.00% 27,000,000.00 15,000,000.00 12000000 80.00% -170,000,000.00 - 195,000,000.00 25000000 -12.82% -1,082,000,000.00 -1,308,000,000.00 226000000 -17.28% 0.00 0.00 0 #DIV/0! 2,718,000,000.00 4,080,000,000.00 -1362000000 -33.38% -1,356,000,000.00 1,815,000,000.00 459000000 -25.29% 529,000,000.00 606,000,000.00 -77000000 -12.71% 0.00 0.00 O #DIV/0! 231,000,000.00 17,000,000.00 214000000 1258.82% - 17,000,000.00 0.00 -17000000 #DIV/0! 858,000,000.00 534,000,000.00 324000000 60.67% 0.00 0.00 o #DIV/0! 0.00 0.00 O #DIV/0! 0.00 0.00 0 #DIV/0! 245,000,000.00 -658,000,000.00 903000000 - 137.23% 0.00 0.00 0 #DIV/0! 2,000,000,000.00 688,000,000.00 1312000000 190.70% -1,164,000,000.00 1,905,000,000.00 741000000 -38.90% -3,628,000,000.00 -2,528,000,000.00 -1100000000 43.51% -59,000,000.00 -7,000,000.00 -52000000 742.86% -2,851,000,000.00 -3,752,000,000.00 901000000 -24.01% 112,000,000.00 -330,000,000.00 442000000 -133.94% 683,000,000.00 1,013,000,000.00 -330000000 -32.58% 0.00 0.00 0 #DIV/0! 0.00 0.00 0 #DIV/0! 795,000,000.00 683,000,000.00 112000000 16.40%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started