Question

1 Approved Answer

Posted on Jul 30, 2024

a) Briefly explain the industry the company operates within and any key regulations to which they must adhere (100 words) b) Using the downloaded data,

image text in transcribed

a) Briefly explain the industry the company operates within and any key regulations to which they must adhere (100 words) b) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet, Cash Flow and Ratios for 2017 and 2018, Set the $ movement to "no decimal places" and the % movement to "2 decimal places" for the statements. When analysing the ratios please use2 decimal places for both the $ and % movements Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss c) 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. Marks will be significantly deducted if it is not in your own words and work. 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 (200 words) better/worse d) Select a minimum of ten ratios, ensuring you include a range of liquidity, profitability and solvency ratios and analyse the company. Where possible use the ratios we have covered in class. As in part c above 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 (350 words) Please note only refer to those ratios that are provided on the "ratios" tab, do not attempt to calculate them yourself. e) Draw an overall conclusion as to whether you would invest in the company and why? (150 words) f) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within your report. Where you include them is up to you based on your report presentation (could be in an appendix) Remember: You need to upload 1 document with all the assignment answers structured in a Business Report format. Please follow the presentation guide and save your completed assignment as a .pdf document to ensure your layout is retained. financialdownload.xls.xlsx- ,, PDFelement Power Pivot 8 y) ASX Code ASK Code Company Name Wesfarmers Limited Revenue 68,015.000,000.00 66,594.000,000.00 2 WES 3 WES Westarmers Limited Other Revenue 633.000,000.00 553.000,000.00 Wesfarmers Limited Total Revenue Excluding Interest 68,648,000,000.00 67.152.000,000.00 Wesfarmiers Lirmited 5 WES Operating Expenses -63,130,000,000.00 -61,486,000,000.000 Wesfarmers Limited EBITDA 5,518,000,000.00 5,666,000,000.00 6 WES Wesfarmers Limited Dopreciation 960.000,000.00 913.000,000.00 8 WES Westarmers Limited Amortisation 158.000,000.00 285.000,000.00 Wesfarmers Limited 9 WES Deprec ation and Amortisation 1.118,000,000.00 1,198,000,000.00 Wesfarmers Limited 10 WES 1.400,000,000.00 .468,000,000.00O EBIT 11 WES Wesfarmers Limited Interest Revenue 94,000,000.00 14,000,000.00 12 WES Westarmers Limited 264.000,000.00 211.000,000.00 Westarmers Limited Net Interest Expense 180,000,000,00 197.000,000.00 13 WES Wesfarmers Limited PreTax Profit 14 VFS 4.220,000,000.00 271,000,000.00 Wesfarmers Limited 15 WES 1,265,000,000.00 -1,246,000,000.00 Wesfarmers Limited Net Profit after Tax Before Abnormals 2,955,000,000.00 3,025,000,000.00 16 WES Westarmers Limited Abnormals 2.000,000.00 421.000,000.00 17 WES 18 WES 19 WES Wesfarmers Limited Wesfarmers Limited -82,000,00000-421,000,00000 Wesfarmers Limited Reported NPAT After Abnormals Outside Equity Interests Shares Outstanding at Period End Weighted Average Number of Shares EPS Adjusted (cents/share) 20 WES 2,873,000,000.00 1,197,000,000.00 Wesfarmers Limited 21 WES Westarmers Limited 1,131.752,000.00 1,133.040,242.00 22 WES 23 WES Wesfarmers Limited 1,128,000,000.00 1,131.000,000,00 24 WES 25 WES Wesfarmers Limited 261.46 266.99 Wesfarmers Limited EPS After Abnormals (cents/share) 105.65 254.20 Profit Loss Balance Sheet Cash Flow Ratio Analysis --+-+ 100% financialdownload.xlsxlsx- yj PDFelement Power Pivot 8 ASX Code 1843 1 It 2 WES 2 1,013,000,000.00 683,000,000.00 CA Receivables 1,633.000,000.00 1,657.000,000.00 Wesfarmers Limited Wesfarmers Limited CA - Inventories 6,530,000,000.00 6,011,000,000.00 Westarmers Limitec 247,000.000.00 126,000,000.00 Wesfarmers Limited CA -NCA Held Sale 229,000,000.00 CA - Other 244,000,000.00 Total Crrent Assets 9 WES 9,667,000,000.00 8,706.000,000.00 Wesfarmers Limited NCA Inventories Wesfarmers Limited 949,000.000.00 1,139,000,000.00 Westarmers Limitec NCA PP&E 9,440,000.000.00 8,408,000,000.00 Westarmers Limited NCA Intangibles(ExGW) 4,576,000.000.00 4,369,000,000.00 Wesfarmers Limited 14,360,000,000,00 13,491.000,000.00 Wesfarmers Limited NCA Future Tax Beneft 16 WES 971,000,000.00692.000,000.00 Wesfarmers Limited NCA - Other 152,000,00000 128,000,000.00 Wesfarmers Limited Total NCA 30,448,000,000.00 28,227,000,000.00 Wesfarmers Limited 40,115,000.000.00 36,933,000,000.00 Westarmers Limitec 6,615,000.000.00 6,541,000,000.00 Westarmers Limited CL Short-Term Debt 1,347,000.000.00 1,159.000,000.00 sfarmers Limited 2,189,000,000.00 2,041000,000.00 Wesfarmers Limited CL NCL Held Sale Wesfarmers Limited 266,000,000.00284.000,000.00 Wesfarmers Limited Total Curr. Liabilities 10,417,000,000.00 10,025,000,000.00 Wesfarmers Limited NCL - Account Payable NCL Long Westarmers Limitec 4,066,000.000.00 2,965,000,000.00 Wesfarmers Limited NCL Provisions 1,535,000.000,00 1,033,000,000.00 NCL Other farmers Limited 156,000,000.00 156,000,000.00 Wesfarimers Limited Total NCI 5,757,000,000.00 ,154.000,000.00 Wesfarmers Limited Total Liabi ities 16,174,000,000.00 14,179,000,000.00 Wesfarmers Limited Share Capital 22,242,000,000.00 22,234,000,000.00 Wesfarmers Limited 190,000.000.00 344.000,000.00 Rctained Earnings Other Equity Westarmers Limited 1,509,000.000.00 176,000,000.00 Wesfarmers Limited Convertible Equity 7 WES Wesfariers Limited SE Held Sale Wesfarmers Limited Outside Equity Wesfarmers Limited 941,000.000.00 754,000,000.00 Profit Loss | Balance Sheet Cash Flow Ratio Analysis | financialdownload.xls.xlsx- 1 PDFelement Power Pivot 9 ASX Code 1 ASX Code Company Name Wesfarmers Limited Receipts from Customers 74,042,000,000.00 75354,000,000.00 WesfarTers Limited 68,713,000,000.00 -69.836,000,000.00 Wesfarmers Limited Dividends Received 46,000,000.00 50,000,000.00 Wesfarmers Limited Interest Receivecd 83,000.000.00 15,000,000.00 Wesfanmers Limited Interest Paid 234,000.000.00 195,000,000.00 Westanmers Limited 951,000.000.00 -1,308,000,000.00 Wesfarmers Limited Other Operating Cashflows Net Operating Cashflows Payrment for Purchase of PPE 47,000.000.00 Wesfarmers Lirited 9 WES 4,226,000,000.00 4.080,000,000.00 Wesfarmers Limited -1,681,000,000.00 1,815,000,000.00 Wesfarmers Limited Proceeds From Sale of PPE 653,000,000.00 606,000,000.00 Wesfarmers Limited Investments Purchased 2,000,000.00 Westanmers Limited Procceds From Sale of Investments 54,000.000.00 17,000,000.00 Westamers Limited Payments for Purchase of Subsidiaries Proceeds from Sale of Subsidiaries 24,000.000.00 Wesfarmers Limited 947,000.000.00 534,000,000.00 Wesfarmers Lirited 16 WES Laans Granted Wesfarmers Limited Wesfarmers Limited Other Investing Cashflows Net Investing Cashflows Wesfamers Limited 53,000.000.00 659,000,000.00 Westanmers Limited Procceds from Issucs 1,000,000.00 Westarmers Limited Proceeds from Borrowings 220,000.000,00 688,000,000.00 Wesfarmers Limited 1,994,000,000.00 1.905,000,000.00 Wesfarmers Limited 23 WES -1,998.000,000.002,528,000,000.00 Wesfarmers Limited Other Financing Cashflows ,000,000.00 Wesfarmers Limited Net Financing Cashflows 3,771,000,000.00 -3.752,000,000.00 Wesfamers Limited Net Increase in Cash 402,000.000.00 330,000,000.00 Westanmers Limited Cash at Boginning of Period 611,000.000.00 1,013,000,000.00 Westarmers Limited Wesfarmers Limited Other Cash Adjustments WesfarTers Liited Cash at End of Period 30 WES 1,013,000,000.00 683,000,000.00 Profit Loss Balance Sheet Cash Flow Ratio Anal + 100% financialdownload.xls.xlsx- 467838 29 5 5 1 1 2 ~ 5 1 1 9 1 1 5200004 20 PDFelement Power Pivot 9 1 9 g 97 50 2 2 7 3 Lee 3 83 ASX Code 6 2 4 7 2 2 3 4 6 5 8 6 8 4 3 3 2 1 ASX Code 4. 6 6 8 2 7 4 4 5 0. 1 2 7 5 1 0 3 1 2 8 4001141019967 256 Item nt Net Profit Margin (%) 234| 5| 6 7 8 9 10 1 2 3 4 1 6 1 1 1 2 2 2 2 2 2 2 2 2 NOPAT Margin (%) Gross Gearing (DE)(%) Inventary/Trading Rev. ) Funds from Ops/EBITDA (%) Rev Profit Loss Balance Sheet |Cash Flow Ratio Analysis LII +--+ 100% 42.99 40 WES Wesfarmers Limited Sales per Share (S) 41.98 49.36 Wesfarmers Limited Year End Share Price 40.12 41 WES Westanmers Limited Market Cap 45,405,090,240.0055,966,354,345.00 2 WES 43 WES Wesfarmers Limited Net Debt 4,400.000,000.003441,000,000.00 Wesfarmers Limited Enterprise Value 44 WES 49,805.890,240.0059,407,354,345.00 Wesfarmers Limited 45 WES EV/EBITDA 9.03 10.48 Wesfarmiers Limited 46 WES EVWERIT 11.32 1330 46.76 47 WES Wesfarmers Limited 15.80 Market Cap/Rep NPAT Market Cap. Trading Rev Wesfarmers Limited 48 WES 0.67 0.84 Wesfarmers Limited Price/Book Value 1.90 2.46 49 WES 50 WES Wesfarnmers Limited Price/Gross Cash Flow 10.02 12.94 51 WES Westarnmers Limited PER 15.34 18.49 52 53 54 56 57 58 59 60 Balance Sheet Cash Flow Ratio Analysis6 a) Briefly explain the industry the company operates within and any key regulations to which they must adhere (100 words) b) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet, Cash Flow and Ratios for 2017 and 2018, Set the $ movement to "no decimal places" and the % movement to "2 decimal places" for the statements. When analysing the ratios please use2 decimal places for both the $ and % movements Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss c) 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. Marks will be significantly deducted if it is not in your own words and work. 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 (200 words) better/worse d) Select a minimum of ten ratios, ensuring you include a range of liquidity, profitability and solvency ratios and analyse the company. Where possible use the ratios we have covered in class. As in part c above 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 (350 words) Please note only refer to those ratios that are provided on the "ratios" tab, do not attempt to calculate them yourself. e) Draw an overall conclusion as to whether you would invest in the company and why? (150 words) f) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within your report. Where you include them is up to you based on your report presentation (could be in an appendix) Remember: You need to upload 1 document with all the assignment answers structured in a Business Report format. Please follow the presentation guide and save your completed assignment as a .pdf document to ensure your layout is retained. financialdownload.xls.xlsx- ,, PDFelement Power Pivot 8 y) ASX Code ASK Code Company Name Wesfarmers Limited Revenue 68,015.000,000.00 66,594.000,000.00 2 WES 3 WES Westarmers Limited Other Revenue 633.000,000.00 553.000,000.00 Wesfarmers Limited Total Revenue Excluding Interest 68,648,000,000.00 67.152.000,000.00 Wesfarmiers Lirmited 5 WES Operating Expenses -63,130,000,000.00 -61,486,000,000.000 Wesfarmers Limited EBITDA 5,518,000,000.00 5,666,000,000.00 6 WES Wesfarmers Limited Dopreciation 960.000,000.00 913.000,000.00 8 WES Westarmers Limited Amortisation 158.000,000.00 285.000,000.00 Wesfarmers Limited 9 WES Deprec ation and Amortisation 1.118,000,000.00 1,198,000,000.00 Wesfarmers Limited 10 WES 1.400,000,000.00 .468,000,000.00O EBIT 11 WES Wesfarmers Limited Interest Revenue 94,000,000.00 14,000,000.00 12 WES Westarmers Limited 264.000,000.00 211.000,000.00 Westarmers Limited Net Interest Expense 180,000,000,00 197.000,000.00 13 WES Wesfarmers Limited PreTax Profit 14 VFS 4.220,000,000.00 271,000,000.00 Wesfarmers Limited 15 WES 1,265,000,000.00 -1,246,000,000.00 Wesfarmers Limited Net Profit after Tax Before Abnormals 2,955,000,000.00 3,025,000,000.00 16 WES Westarmers Limited Abnormals 2.000,000.00 421.000,000.00 17 WES 18 WES 19 WES Wesfarmers Limited Wesfarmers Limited -82,000,00000-421,000,00000 Wesfarmers Limited Reported NPAT After Abnormals Outside Equity Interests Shares Outstanding at Period End Weighted Average Number of Shares EPS Adjusted (cents/share) 20 WES 2,873,000,000.00 1,197,000,000.00 Wesfarmers Limited 21 WES Westarmers Limited 1,131.752,000.00 1,133.040,242.00 22 WES 23 WES Wesfarmers Limited 1,128,000,000.00 1,131.000,000,00 24 WES 25 WES Wesfarmers Limited 261.46 266.99 Wesfarmers Limited EPS After Abnormals (cents/share) 105.65 254.20 Profit Loss Balance Sheet Cash Flow Ratio Analysis --+-+ 100% financialdownload.xlsxlsx- yj PDFelement Power Pivot 8 ASX Code 1843 1 It 2 WES 2 1,013,000,000.00 683,000,000.00 CA Receivables 1,633.000,000.00 1,657.000,000.00 Wesfarmers Limited Wesfarmers Limited CA - Inventories 6,530,000,000.00 6,011,000,000.00 Westarmers Limitec 247,000.000.00 126,000,000.00 Wesfarmers Limited CA -NCA Held Sale 229,000,000.00 CA - Other 244,000,000.00 Total Crrent Assets 9 WES 9,667,000,000.00 8,706.000,000.00 Wesfarmers Limited NCA Inventories Wesfarmers Limited 949,000.000.00 1,139,000,000.00 Westarmers Limitec NCA PP&E 9,440,000.000.00 8,408,000,000.00 Westarmers Limited NCA Intangibles(ExGW) 4,576,000.000.00 4,369,000,000.00 Wesfarmers Limited 14,360,000,000,00 13,491.000,000.00 Wesfarmers Limited NCA Future Tax Beneft 16 WES 971,000,000.00692.000,000.00 Wesfarmers Limited NCA - Other 152,000,00000 128,000,000.00 Wesfarmers Limited Total NCA 30,448,000,000.00 28,227,000,000.00 Wesfarmers Limited 40,115,000.000.00 36,933,000,000.00 Westarmers Limitec 6,615,000.000.00 6,541,000,000.00 Westarmers Limited CL Short-Term Debt 1,347,000.000.00 1,159.000,000.00 sfarmers Limited 2,189,000,000.00 2,041000,000.00 Wesfarmers Limited CL NCL Held Sale Wesfarmers Limited 266,000,000.00284.000,000.00 Wesfarmers Limited Total Curr. Liabilities 10,417,000,000.00 10,025,000,000.00 Wesfarmers Limited NCL - Account Payable NCL Long Westarmers Limitec 4,066,000.000.00 2,965,000,000.00 Wesfarmers Limited NCL Provisions 1,535,000.000,00 1,033,000,000.00 NCL Other farmers Limited 156,000,000.00 156,000,000.00 Wesfarimers Limited Total NCI 5,757,000,000.00 ,154.000,000.00 Wesfarmers Limited Total Liabi ities 16,174,000,000.00 14,179,000,000.00 Wesfarmers Limited Share Capital 22,242,000,000.00 22,234,000,000.00 Wesfarmers Limited 190,000.000.00 344.000,000.00 Rctained Earnings Other Equity Westarmers Limited 1,509,000.000.00 176,000,000.00 Wesfarmers Limited Convertible Equity 7 WES Wesfariers Limited SE Held Sale Wesfarmers Limited Outside Equity Wesfarmers Limited 941,000.000.00 754,000,000.00 Profit Loss | Balance Sheet Cash Flow Ratio Analysis | financialdownload.xls.xlsx- 1 PDFelement Power Pivot 9 ASX Code 1 ASX Code Company Name Wesfarmers Limited Receipts from Customers 74,042,000,000.00 75354,000,000.00 WesfarTers Limited 68,713,000,000.00 -69.836,000,000.00 Wesfarmers Limited Dividends Received 46,000,000.00 50,000,000.00 Wesfarmers Limited Interest Receivecd 83,000.000.00 15,000,000.00 Wesfanmers Limited Interest Paid 234,000.000.00 195,000,000.00 Westanmers Limited 951,000.000.00 -1,308,000,000.00 Wesfarmers Limited Other Operating Cashflows Net Operating Cashflows Payrment for Purchase of PPE 47,000.000.00 Wesfarmers Lirited 9 WES 4,226,000,000.00 4.080,000,000.00 Wesfarmers Limited -1,681,000,000.00 1,815,000,000.00 Wesfarmers Limited Proceeds From Sale of PPE 653,000,000.00 606,000,000.00 Wesfarmers Limited Investments Purchased 2,000,000.00 Westanmers Limited Procceds From Sale of Investments 54,000.000.00 17,000,000.00 Westamers Limited Payments for Purchase of Subsidiaries Proceeds from Sale of Subsidiaries 24,000.000.00 Wesfarmers Limited 947,000.000.00 534,000,000.00 Wesfarmers Lirited 16 WES Laans Granted Wesfarmers Limited Wesfarmers Limited Other Investing Cashflows Net Investing Cashflows Wesfamers Limited 53,000.000.00 659,000,000.00 Westanmers Limited Procceds from Issucs 1,000,000.00 Westarmers Limited Proceeds from Borrowings 220,000.000,00 688,000,000.00 Wesfarmers Limited 1,994,000,000.00 1.905,000,000.00 Wesfarmers Limited 23 WES -1,998.000,000.002,528,000,000.00 Wesfarmers Limited Other Financing Cashflows ,000,000.00 Wesfarmers Limited Net Financing Cashflows 3,771,000,000.00 -3.752,000,000.00 Wesfamers Limited Net Increase in Cash 402,000.000.00 330,000,000.00 Westanmers Limited Cash at Boginning of Period 611,000.000.00 1,013,000,000.00 Westarmers Limited Wesfarmers Limited Other Cash Adjustments WesfarTers Liited Cash at End of Period 30 WES 1,013,000,000.00 683,000,000.00 Profit Loss Balance Sheet Cash Flow Ratio Anal + 100% financialdownload.xls.xlsx- 467838 29 5 5 1 1 2 ~ 5 1 1 9 1 1 5200004 20 PDFelement Power Pivot 9 1 9 g 97 50 2 2 7 3 Lee 3 83 ASX Code 6 2 4 7 2 2 3 4 6 5 8 6 8 4 3 3 2 1 ASX Code 4. 6 6 8 2 7 4 4 5 0. 1 2 7 5 1 0 3 1 2 8 4001141019967 256 Item nt Net Profit Margin (%) 234| 5| 6 7 8 9 10 1 2 3 4 1 6 1 1 1 2 2 2 2 2 2 2 2 2 NOPAT Margin (%) Gross Gearing (DE)(%) Inventary/Trading Rev. ) Funds from Ops/EBITDA (%) Rev Profit Loss Balance Sheet |Cash Flow Ratio Analysis LII +--+ 100% 42.99 40 WES Wesfarmers Limited Sales per Share (S) 41.98 49.36 Wesfarmers Limited Year End Share Price 40.12 41 WES Westanmers Limited Market Cap 45,405,090,240.0055,966,354,345.00 2 WES 43 WES Wesfarmers Limited Net Debt 4,400.000,000.003441,000,000.00 Wesfarmers Limited Enterprise Value 44 WES 49,805.890,240.0059,407,354,345.00 Wesfarmers Limited 45 WES EV/EBITDA 9.03 10.48 Wesfarmiers Limited 46 WES EVWERIT 11.32 1330 46.76 47 WES Wesfarmers Limited 15.80 Market Cap/Rep NPAT Market Cap. Trading Rev Wesfarmers Limited 48 WES 0.67 0.84 Wesfarmers Limited Price/Book Value 1.90 2.46 49 WES 50 WES Wesfarnmers Limited Price/Gross Cash Flow 10.02 12.94 51 WES Westarnmers Limited PER 15.34 18.49 52 53 54 56 57 58 59 60 Balance Sheet Cash Flow Ratio Analysis6