AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home Share A ll OFF D Insert Cut Copy Format O 5 = Draw Page Layout Calibri (Body) , 11 B I U D Formulas ; An A A AutoSum" AO Data Review = = = 2 = = = View T U Paste E> Wrap Text Merge & Center General $ . % F A D Conditional Format cell 9. =* insert Delete . Format Sort & Filter Formatting as Table Styles Clear Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x fx A B C D E F G H I J 1 Ratios K L M N O P Q R S T U V W X Y Bigwig's Income Statement as at 31.3.17 and 31.3.18 2018 Em Sales Revenue 567,584 Cost of Sales 373,486 Gross Profit 194,098 Expenses 143,258 Operating Profit 50,840 Finance Costs 5,000 Profit before Tax 45,840 Tax at 20% 9,168 Profit after tax 36,672 2017 Em 510,619 323,512 187,107 176,139 10,968 10,968 2,194 8,774 Bigwig's Statement of Financial position at at 31.3.17 and 31.3.18 2018 2018 Em 2017 Em 2017 Em Em 274,400 229,430 ASSETS Non-current Assets Current Assets Inventories Trade Receivables Cash at Bank Total Assets 85,450 85,300 92,007 52,345 65,490 43,222 262,757 537,157 161,057 390,487 250,000 62,157 235,000 25,487 312,157 260,487 CAPITAL AND LIABILITIES Equity Ordinary Share Capital (E1 shares) Retained Earnings Long-term Liabilities Long-term Borrowings Current Liabilities Trade Payables Total Capital and Liabilities 80,000 145,000 537,157 130,000 390,487 Additional information: Assume that all sales are credit sales. No dividend is proposed. You are required to: Calculate the key ratios. ENTERANSWERS Instructions +. Ready - - - + 100% AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home Share A ll OFF D Insert Cut Copy Format O 5 = Draw Page Layout Calibri (Body) , 11 B I U D Formulas ; An A A AutoSum" AO Data Review = = = 2 = = = View T U Paste E> Wrap Text Merge & Center General $ . % F A D Conditional Format cell 9. =* insert Delete . Format Sort & Filter Formatting as Table Styles Clear Check for Updates K L M N O P Q R S T U V W X Y Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x fx A B C D E F G H I J Em - Em Em Em ASSETS Non-current Assets 274,400 229,430 Current Assets Inventories 85,450 52,345 Trade Receivables 85,300 65,490 Cash at Bank 92,007 262,757 43,222 161,057 Total Assets 537,157 390,487 250,000 62,157 235,000 25,487 312,157 260,487 CAPITAL AND LIABILITIES Equity Ordinary Share Capital (E1 shares) Retained Earnings Long-term Liabilities Long-term Borrowings Current Liabilities Trade Payables Total Capital and Liabilities 80,000 130,000 145,000 537,157 390,487 Additional information: Assume that all sales are credit sales. No dividend is proposed. You are required to: Calculate the key ratios. 2018 2017 Performance Ratios Gross Profit Ratio Net Profit Ratio Return on Shareholder's Funds Liquidity Ratios Current Ratio Quick Ratio Efficiency Ratios Non-current Assets Turnover Inventory Turnover Trade Receivables Turnover Investment Ratios Gearing (Debt/Equity) Earnings Per Share times times times times times times ENTERANSWERS Instructions + Ready - - - + 100% AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home OFF D Insert Cut Copy Share A ll O Draw Calibri B i U 5 = Page Layout 11 S AutoSum" AO Formulas As A A Data Review View = = = 0 THE Wrap Text 3 3 33 E Merge & Center - General $ . % F A D Conditional Format 9. =* Insert Delete Paste 3 o Cell Format Clear Sort & Filter Formatting as Table Styles Check for Updates > Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x V fx Learning outcomes: F G 1 Learning outcomes: 1. To introduce the concept of analysis of accounts using ratios. 2. To introduce different categories of ratios. 3. To introduce the concept of trends over years. 4. To understand the different ways of expressing ratios (e.g., percentage, times a year, simple ratio). 3 Steps to Perform: Points Possible Step O Instructions 1 Start Excel. 2 In cell E45, by using cell references, calculate the gross profit ratio. Copy the formula from cell E45 and paste onto cell G45. 3 In cell E46, by using cell references, calculate the net profit ratio. Copy the formula from cell E46 and paste onto cell G46. In cell E47, by using cell references, calculate the return on shareholders' funds. Copy the formula from cell E47 and paste onto cell G47. Note: Use the profit before tax and total equity in your calculation. 5 In cell E49, by using cell references, calculate the current ratio. Copy the formula from cell E49 and paste onto cell G49. 6 In cell E50, by using cell references, calculate the quick ratio. Copy the formula from cell E50 and paste onto cell G50. In cell E52, by using cell references, calculate the non-current assets turnover. Copy the formula from cell E52 and paste onto cell G52. Note: Use end-of-year, not average, values in your calculation. In cell E53, by using cell references, calculate the inventory turnover. Copy the formula from cell E53 and paste onto cell G53. Note: Use the cost of sales and end-of-year, not average, values in your calculation. In cell E54, by using cell references, calculate the trade receivables turnover. Copy the formula from cell E54 and paste onto cell G54. Note: Use the cost of sales and end-of-year, not average, values in your calculation. 10 In cell E56, by using cell references, calculate the long-term debt to equity ratio. Copy the formula from cell E56 and paste onto cell G56. In cell E57, by using cell references, calculate the earnings per share. Copy the formula from cell E57 and paste onto cell 657. 11 Note: Use end-of-year, not average, values in your calculation. 12 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. ENTERANSWERS Instructions + 16 Ready @ - - + 125% AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home Share A ll OFF D Insert Cut Copy Format O 5 = Draw Page Layout Calibri (Body) , 11 B I U D Formulas ; An A A AutoSum" AO Data Review = = = 2 = = = View T U Paste E> Wrap Text Merge & Center General $ . % F A D Conditional Format cell 9. =* insert Delete . Format Sort & Filter Formatting as Table Styles Clear Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x fx A B C D E F G H I J 1 Ratios K L M N O P Q R S T U V W X Y Bigwig's Income Statement as at 31.3.17 and 31.3.18 2018 Em Sales Revenue 567,584 Cost of Sales 373,486 Gross Profit 194,098 Expenses 143,258 Operating Profit 50,840 Finance Costs 5,000 Profit before Tax 45,840 Tax at 20% 9,168 Profit after tax 36,672 2017 Em 510,619 323,512 187,107 176,139 10,968 10,968 2,194 8,774 Bigwig's Statement of Financial position at at 31.3.17 and 31.3.18 2018 2018 Em 2017 Em 2017 Em Em 274,400 229,430 ASSETS Non-current Assets Current Assets Inventories Trade Receivables Cash at Bank Total Assets 85,450 85,300 92,007 52,345 65,490 43,222 262,757 537,157 161,057 390,487 250,000 62,157 235,000 25,487 312,157 260,487 CAPITAL AND LIABILITIES Equity Ordinary Share Capital (E1 shares) Retained Earnings Long-term Liabilities Long-term Borrowings Current Liabilities Trade Payables Total Capital and Liabilities 80,000 145,000 537,157 130,000 390,487 Additional information: Assume that all sales are credit sales. No dividend is proposed. You are required to: Calculate the key ratios. ENTERANSWERS Instructions +. Ready - - - + 100% AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home Share A ll OFF D Insert Cut Copy Format O 5 = Draw Page Layout Calibri (Body) , 11 B I U D Formulas ; An A A AutoSum" AO Data Review = = = 2 = = = View T U Paste E> Wrap Text Merge & Center General $ . % F A D Conditional Format cell 9. =* insert Delete . Format Sort & Filter Formatting as Table Styles Clear Check for Updates K L M N O P Q R S T U V W X Y Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x fx A B C D E F G H I J Em - Em Em Em ASSETS Non-current Assets 274,400 229,430 Current Assets Inventories 85,450 52,345 Trade Receivables 85,300 65,490 Cash at Bank 92,007 262,757 43,222 161,057 Total Assets 537,157 390,487 250,000 62,157 235,000 25,487 312,157 260,487 CAPITAL AND LIABILITIES Equity Ordinary Share Capital (E1 shares) Retained Earnings Long-term Liabilities Long-term Borrowings Current Liabilities Trade Payables Total Capital and Liabilities 80,000 130,000 145,000 537,157 390,487 Additional information: Assume that all sales are credit sales. No dividend is proposed. You are required to: Calculate the key ratios. 2018 2017 Performance Ratios Gross Profit Ratio Net Profit Ratio Return on Shareholder's Funds Liquidity Ratios Current Ratio Quick Ratio Efficiency Ratios Non-current Assets Turnover Inventory Turnover Trade Receivables Turnover Investment Ratios Gearing (Debt/Equity) Earnings Per Share times times times times times times ENTERANSWERS Instructions + Ready - - - + 100% AutoSave Zaribaf_EXP.10_Ratios_Start Q Search Sheet Home OFF D Insert Cut Copy Share A ll O Draw Calibri B i U 5 = Page Layout 11 S AutoSum" AO Formulas As A A Data Review View = = = 0 THE Wrap Text 3 3 33 E Merge & Center - General $ . % F A D Conditional Format 9. =* Insert Delete Paste 3 o Cell Format Clear Sort & Filter Formatting as Table Styles Check for Updates > Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x V fx Learning outcomes: F G 1 Learning outcomes: 1. To introduce the concept of analysis of accounts using ratios. 2. To introduce different categories of ratios. 3. To introduce the concept of trends over years. 4. To understand the different ways of expressing ratios (e.g., percentage, times a year, simple ratio). 3 Steps to Perform: Points Possible Step O Instructions 1 Start Excel. 2 In cell E45, by using cell references, calculate the gross profit ratio. Copy the formula from cell E45 and paste onto cell G45. 3 In cell E46, by using cell references, calculate the net profit ratio. Copy the formula from cell E46 and paste onto cell G46. In cell E47, by using cell references, calculate the return on shareholders' funds. Copy the formula from cell E47 and paste onto cell G47. Note: Use the profit before tax and total equity in your calculation. 5 In cell E49, by using cell references, calculate the current ratio. Copy the formula from cell E49 and paste onto cell G49. 6 In cell E50, by using cell references, calculate the quick ratio. Copy the formula from cell E50 and paste onto cell G50. In cell E52, by using cell references, calculate the non-current assets turnover. Copy the formula from cell E52 and paste onto cell G52. Note: Use end-of-year, not average, values in your calculation. In cell E53, by using cell references, calculate the inventory turnover. Copy the formula from cell E53 and paste onto cell G53. Note: Use the cost of sales and end-of-year, not average, values in your calculation. In cell E54, by using cell references, calculate the trade receivables turnover. Copy the formula from cell E54 and paste onto cell G54. Note: Use the cost of sales and end-of-year, not average, values in your calculation. 10 In cell E56, by using cell references, calculate the long-term debt to equity ratio. Copy the formula from cell E56 and paste onto cell G56. In cell E57, by using cell references, calculate the earnings per share. Copy the formula from cell E57 and paste onto cell 657. 11 Note: Use end-of-year, not average, values in your calculation. 12 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. ENTERANSWERS Instructions + 16 Ready @ - - + 125%