70.2K

Verified Solution

Link Copied!

Old MathJax webview

SM1 BALANCE SHEET 2019 2020

Austal profit and loss income statement 2019 2020

Austal Balance sheet

JUST ANSWER QUESTION 3 AND 5 PLEASE

You are part of a team of financial analysts who have been hired by Eden Waldorf, Chief Loans Officer (CLO) at Bastion Banking Corporation. The bank has received loan applications from the abovementioned companies. Accordingly, the CLO of the bank requires your team to analyse the financial position and performance of the above assigned companies for the two stated financial years (2019 and 2020), to determine whether the companies are eligible for a loan from the bank. Your task involves answering the following 5 questions in your own words I QUESTION 1: Calculate the Cash Conversion Cycle (CCC) for each of the two companies in 2019 and 2020. Using your answer, analyse the efficiency of each of the two companies in managing their working capital in 2020 as compared to 2019. Note: ensure that you analyse in this question, not just describe the CCC values. (3 marks) QUESTION 2: Analyse the sources of finance for each of the two companies in 2020 as compared to 2019. Use two capital structure ratios to support your answer and provide an explanation regarding the changes in the composition of the sources of finance for each enterprise. Note: ensure that you analyse in this question, not just describe the ratio values. (2 marks) QUESTION 3: Analyse the ability of management to manage their fixed assets and total assets for each of the two companies in 2020 as compared to 2019. Use two Asset Management efficiency ratios to support your answer and explain any change in each companies' ability to use their assets to generate sales. Note: ensure that you analyse in this question, not just describe the ratio values. (2 marks) QUESTION 4: Analyse the profitability of invested capital (assets) for each of the two companies in 2020 as compared to 2019. Based on your calculations, explain the main reason(s) for the change in the profitability for each company over the two years. Note: ensure that you analyse in this question, not just describe the ratio values. (3 marks) QUESTION 5: Given your answers and analysis in Questions 1 to 4, what is your final recommendation to the CLO of Bastion Banking Corporation: an approval or denial of the loan to each and/or both firms? Discuss the basis for your recommendation. Ensure you base your recommendation only on the change in the ratios for the two stated financial years (i.e., 2019 and 2020). (4 marks) In questions 1-4, an analysis is required and not just a description of the ratio. That means you need to explain how the ratio chanded over time and what are the main I In questions 1-4, an analysis is required and not just a description of the ratio. That means you need to explain how the ratio changed over time and what are the main reason(s) for that change, and how that will impact the company's financial position. The aim of the assignment is to examine and analyse the change in the firm's financial position and performance based only on your calculated ratios. Each company must be compared to itself over the 2019 and 2020 period. Do not compare the companies to each other or to the industry in which they operate SM1 PROFIT AND LOSS STATEMENT 07/19 07/20 (smillions) Operating Revenue Other Revenue Total Revenue Excluding Interest Operating Expenses EBITDA Depreciation Amortisation Depreciation and Amortisation EBIT Interest Revenue Interest Expense 980.29 1,209.84 0.86 0.38 981.15 1,210.21 -837.30 -1,051.07 143.85 159.14 -24.59 -41.72 -1.86 -2.93 -26.45 -44.66 117.39 114.48 1.18 0.12 -8.44 -18.38 Net Interest Expense -7.26 -18.25 Pre Tax Profit Tax Expense Net Profit after Tax Before Abnormals 110.13 -31.43 78.71 0.00 0.00 0.00 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) 96.23 -24.80 71.43 -1.54 0.00 -1.54 69.88 0.00 179.31 179.28 39.75 38.89 78.71 0.00 179.22 179.21 43.92 43.92 SM1 BALANCE SHEET 07/19 07/20 (Smillions Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets 15.32 59.27 9.14 157.77 2.26 0.00 26.68 270.43 5.47 58.59 11.53 250.31 20.93 0.00 12.20 359.03 Non-Current Assets Receivables Inventories Investments PP&E Intangibles(EXGW) Goodwill Future Tax Benefit Other Total NCA 0.00 0.00 0.00 0.00 0.15 13.22 808.88 913.96 15.72 39.49 3.49 60.90 0.00 0.00 0.00 0.00 828.24 1,027.57 Total Assets 1,098.67 1,386.61 206.74 95.35 54.72 0.00 0.00 356.81 221.86 99.66 35.97 0.00 0.00 357.50 Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities Non-Current Liabilitie's Account Payable Long-Term Debt Provisions Other Total NCL 0.00 238.76 31.90 0.00 270.67 0.00 410.33 55.24 0.00 465.57 627.47 823.06 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings Other Equity Convertible Equity SE Held Sale 256.55 -23.44 238.08 0.00 0.00 0.00 249.53 12.97 301.04 0.00 0.00 0.00 07/19 07/20 Paragraph (Smillions 15.32 59.27 9.14 157.77 2.26 5.47 58.59 11.53 250.31 20.93 0.00 12.20 359.03 0.00 26.68 270.43 Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets Non-Current Assets Receivables Inventories Investments PPBE Intangibles(EXGW) Goodwill Future Tax Benefit Other Total NCA 0.00 0.00 0.00 0.00 0.15 13.22 808.88 913.96 15.72 39.49 60.90 0.00 0.00 0.00 0.00 828.24 1,027.57 3.49 1,098.67 1,386.61 206.74 95.35 54.72 0.00 0.00 356.81 221.86 99.66 35.97 0.00 Total Assets Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities Non-Current Liabilities Account Payable Long-Term Debt Provisions Other Total NCL 0.00 357.50 0.00 238.76 31.90 0.00 270.67 0.00 410.33 55.24 0.00 465.57 627.47 823.06 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings Other Equity Convertible Equity SE Held Sale Outside Equity Total Equity 256.55 -23.44 238.08 0.00 0.00 0.00 249.53 12.97 301.04 0.00 0.00 0.00 471.20 563.54 AUSTAL LIMITED ASB PROFIT AND LOSS 2019-2020 Smillions 06/19 06/20 Operating Revenue Other Revenue Total Revenue Excluding Interest Operating Expenses EBITDA Depreciation 1,851.02 2,086.00 17.64 15.17 1,868.66 2,101.17 -1,732.46 -1,925.03 136.20 176.14 -39.90 -42.91 -2.83 -45.74 Amortisation Depreciation and Amortisation EBIT Interest Revenue Interest Expense Net Interest Expensel -2.30 -42.21 94.00 1.05 -8.28 130.40 1.38 -8.27 -7.23 -6.88 123.51 -34.54 88.98 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) 86.76 -24.18 62.58 -1.20 0.00 -1.20 61.38 0.00 352.68 349.60 0.00 0.00 0.00 88.98 0.00 356,05 356.24 AUSTAL LIMITED BALANCE SHEET ($millions) 06/19 06/20 Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets 275.66 225.27 9.48 167.04 1.93 0.00 1.70 681.09 396.67 144.22 11.44 143.80 1.22 0.00 0.00 697.34 0.55 0.00 Non-Current Assets Receivables Inventories Investments PP&E Intangibles(ExGW) Goodwill Future Tax Benefit Other Total NCA 1.99 588.38 7.95 12.80 0.25 0.00 2.92 619.94 9.29 12.90 8.40 26.15 646.21 4.76 20.72 670.76 Total Assets 1,327.30 1,368.11 Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities 202.31 51.21 94.30 0.00 126.85 474.66 156.91 11.35 83.74 0.00 97.73 349.73 Non-Current Liabilities Account Payable Long-Term Debt Provisions Other Total NCL 0.00 122.54 43.10 56.21 221.86 0.00 163.91 51.68 54.05 269.63 696.52 619.36 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings 130.57 189.52 310.69 135.34 235.12 378.28 Account Payable Long-Term Debt Provisions Other Total NCL 0.00 122.54 43.10 56.21 221.86 0.00 163.91 51.68 54.05 269.63 696.52 619.36 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings 130.57 189.52 310.69 135.34 235.12 378.28 0.00 0.00 0.00 0.00 0.00 0.00 Other Equity Convertible Equity SE Held Sale Outside Equity Total Equity 630.78 748.74 You are part of a team of financial analysts who have been hired by Eden Waldorf, Chief Loans Officer (CLO) at Bastion Banking Corporation. The bank has received loan applications from the abovementioned companies. Accordingly, the CLO of the bank requires your team to analyse the financial position and performance of the above assigned companies for the two stated financial years (2019 and 2020), to determine whether the companies are eligible for a loan from the bank. Your task involves answering the following 5 questions in your own words I QUESTION 1: Calculate the Cash Conversion Cycle (CCC) for each of the two companies in 2019 and 2020. Using your answer, analyse the efficiency of each of the two companies in managing their working capital in 2020 as compared to 2019. Note: ensure that you analyse in this question, not just describe the CCC values. (3 marks) QUESTION 2: Analyse the sources of finance for each of the two companies in 2020 as compared to 2019. Use two capital structure ratios to support your answer and provide an explanation regarding the changes in the composition of the sources of finance for each enterprise. Note: ensure that you analyse in this question, not just describe the ratio values. (2 marks) QUESTION 3: Analyse the ability of management to manage their fixed assets and total assets for each of the two companies in 2020 as compared to 2019. Use two Asset Management efficiency ratios to support your answer and explain any change in each companies' ability to use their assets to generate sales. Note: ensure that you analyse in this question, not just describe the ratio values. (2 marks) QUESTION 4: Analyse the profitability of invested capital (assets) for each of the two companies in 2020 as compared to 2019. Based on your calculations, explain the main reason(s) for the change in the profitability for each company over the two years. Note: ensure that you analyse in this question, not just describe the ratio values. (3 marks) QUESTION 5: Given your answers and analysis in Questions 1 to 4, what is your final recommendation to the CLO of Bastion Banking Corporation: an approval or denial of the loan to each and/or both firms? Discuss the basis for your recommendation. Ensure you base your recommendation only on the change in the ratios for the two stated financial years (i.e., 2019 and 2020). (4 marks) In questions 1-4, an analysis is required and not just a description of the ratio. That means you need to explain how the ratio chanded over time and what are the main I In questions 1-4, an analysis is required and not just a description of the ratio. That means you need to explain how the ratio changed over time and what are the main reason(s) for that change, and how that will impact the company's financial position. The aim of the assignment is to examine and analyse the change in the firm's financial position and performance based only on your calculated ratios. Each company must be compared to itself over the 2019 and 2020 period. Do not compare the companies to each other or to the industry in which they operate SM1 PROFIT AND LOSS STATEMENT 07/19 07/20 (smillions) Operating Revenue Other Revenue Total Revenue Excluding Interest Operating Expenses EBITDA Depreciation Amortisation Depreciation and Amortisation EBIT Interest Revenue Interest Expense 980.29 1,209.84 0.86 0.38 981.15 1,210.21 -837.30 -1,051.07 143.85 159.14 -24.59 -41.72 -1.86 -2.93 -26.45 -44.66 117.39 114.48 1.18 0.12 -8.44 -18.38 Net Interest Expense -7.26 -18.25 Pre Tax Profit Tax Expense Net Profit after Tax Before Abnormals 110.13 -31.43 78.71 0.00 0.00 0.00 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) 96.23 -24.80 71.43 -1.54 0.00 -1.54 69.88 0.00 179.31 179.28 39.75 38.89 78.71 0.00 179.22 179.21 43.92 43.92 SM1 BALANCE SHEET 07/19 07/20 (Smillions Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets 15.32 59.27 9.14 157.77 2.26 0.00 26.68 270.43 5.47 58.59 11.53 250.31 20.93 0.00 12.20 359.03 Non-Current Assets Receivables Inventories Investments PP&E Intangibles(EXGW) Goodwill Future Tax Benefit Other Total NCA 0.00 0.00 0.00 0.00 0.15 13.22 808.88 913.96 15.72 39.49 3.49 60.90 0.00 0.00 0.00 0.00 828.24 1,027.57 Total Assets 1,098.67 1,386.61 206.74 95.35 54.72 0.00 0.00 356.81 221.86 99.66 35.97 0.00 0.00 357.50 Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities Non-Current Liabilitie's Account Payable Long-Term Debt Provisions Other Total NCL 0.00 238.76 31.90 0.00 270.67 0.00 410.33 55.24 0.00 465.57 627.47 823.06 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings Other Equity Convertible Equity SE Held Sale 256.55 -23.44 238.08 0.00 0.00 0.00 249.53 12.97 301.04 0.00 0.00 0.00 07/19 07/20 Paragraph (Smillions 15.32 59.27 9.14 157.77 2.26 5.47 58.59 11.53 250.31 20.93 0.00 12.20 359.03 0.00 26.68 270.43 Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets Non-Current Assets Receivables Inventories Investments PPBE Intangibles(EXGW) Goodwill Future Tax Benefit Other Total NCA 0.00 0.00 0.00 0.00 0.15 13.22 808.88 913.96 15.72 39.49 60.90 0.00 0.00 0.00 0.00 828.24 1,027.57 3.49 1,098.67 1,386.61 206.74 95.35 54.72 0.00 0.00 356.81 221.86 99.66 35.97 0.00 Total Assets Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities Non-Current Liabilities Account Payable Long-Term Debt Provisions Other Total NCL 0.00 357.50 0.00 238.76 31.90 0.00 270.67 0.00 410.33 55.24 0.00 465.57 627.47 823.06 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings Other Equity Convertible Equity SE Held Sale Outside Equity Total Equity 256.55 -23.44 238.08 0.00 0.00 0.00 249.53 12.97 301.04 0.00 0.00 0.00 471.20 563.54 AUSTAL LIMITED ASB PROFIT AND LOSS 2019-2020 Smillions 06/19 06/20 Operating Revenue Other Revenue Total Revenue Excluding Interest Operating Expenses EBITDA Depreciation 1,851.02 2,086.00 17.64 15.17 1,868.66 2,101.17 -1,732.46 -1,925.03 136.20 176.14 -39.90 -42.91 -2.83 -45.74 Amortisation Depreciation and Amortisation EBIT Interest Revenue Interest Expense Net Interest Expensel -2.30 -42.21 94.00 1.05 -8.28 130.40 1.38 -8.27 -7.23 -6.88 123.51 -34.54 88.98 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) 86.76 -24.18 62.58 -1.20 0.00 -1.20 61.38 0.00 352.68 349.60 0.00 0.00 0.00 88.98 0.00 356,05 356.24 AUSTAL LIMITED BALANCE SHEET ($millions) 06/19 06/20 Current Assets Cash Receivables Prepaid Expenses Inventories Investments NCA Held Sale Other Total Current Assets 275.66 225.27 9.48 167.04 1.93 0.00 1.70 681.09 396.67 144.22 11.44 143.80 1.22 0.00 0.00 697.34 0.55 0.00 Non-Current Assets Receivables Inventories Investments PP&E Intangibles(ExGW) Goodwill Future Tax Benefit Other Total NCA 1.99 588.38 7.95 12.80 0.25 0.00 2.92 619.94 9.29 12.90 8.40 26.15 646.21 4.76 20.72 670.76 Total Assets 1,327.30 1,368.11 Current Liabilities Account Payable Short-Term Debt Provisions NCL Held Sale Other Total Curr. Liabilities 202.31 51.21 94.30 0.00 126.85 474.66 156.91 11.35 83.74 0.00 97.73 349.73 Non-Current Liabilities Account Payable Long-Term Debt Provisions Other Total NCL 0.00 122.54 43.10 56.21 221.86 0.00 163.91 51.68 54.05 269.63 696.52 619.36 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings 130.57 189.52 310.69 135.34 235.12 378.28 Account Payable Long-Term Debt Provisions Other Total NCL 0.00 122.54 43.10 56.21 221.86 0.00 163.91 51.68 54.05 269.63 696.52 619.36 Total Liabilities Shareholders Equity Share Capital Reserves Retained Earnings 130.57 189.52 310.69 135.34 235.12 378.28 0.00 0.00 0.00 0.00 0.00 0.00 Other Equity Convertible Equity SE Held Sale Outside Equity Total Equity 630.78 748.74

Answer & Explanation Solved by verified expert

See Answer