You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A: You are contacted by the business named Speedo Cycle seeking another accounting consultation. They would like to gain a better idea of which areas of the business are performing well and what the company can do to continue to grow. They would like a report on the aspect of liquidity, profitability and activity levels in the business as well as your professional recommendations on some pathways to improve their long-term success. They have provided you the following data from their accounting system for the year ended 30 June 2021. Income Statement for year ended 30 June 2021 Sales (all credit) Less Cost of Goods Sold Inventory 1/7/20 Purchases Cost of Goods Available for Sale Less: Inventory 30/6/21 Total Cost of Goods Sold GROSS PROFIT Other Income Total Income Less: Operating expenses NET PROFIT $ $ $ $ 53,250 345,700 398,950 65,800 $ $ $ $ $ $ $ 485,000 333,150 151,850 4,000 155,850 108,800 47,050 Current Assets Accounts Receivable Less Allowance for doubtful debts Inventory Prepaid expenses Accrued revenue Non-Current Assets Land Buildings Plant and equipment Motor Vehicles Office Furniture Total Assets Current Liabilities Bank Overdraft Accounts Payable GST Payable Accrued Expenses Balance Sheet for year ended 30 June 2021 Non-Current Liabilities Mortgage Loan Total Liabilities NET ASSETS Owners' Equity Capital Smith Add: Net Profit Less Drawings TOTAL OWNER'S EQUITY $ $ 81,000 4,000 $ 232,400 $ 47,050 $ $ $ SA $ $ $ $ LA $ $ 77,000 65,800 800 900 80,000 75,000 65,000 25,000 7,750 $ 20,000 $ 55,500 $ 3,000 $ 2,300 $ $ $ 75,000 279,450 38,000 $ $ $ $ $ 6669 $ $ 144,500 252,750 397,250 80,800 75,000 155,800 241,450 $ 241,450 Task 5 Based on the financial information provided, you are required to calculate the following ratios for the year ended 30 June 2021. Show all your workings in the table. Make sure you check the consistency and accuracy of your answers. Ratios Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2021 (show your calculations) After you have calculated the 30/06/2021 ratios above, other additional information was given as well: Other Information Industry Averages Gross profit rate Net profit rate Current ratio Quick ratio Inventory turnover rate Average collection periods 30/06/2020 39% 12% 1.5: 1 1.3: 1 5.3 Times 51 days 41% 16% 1.6: 1 1.5: 1 5.1 times 42 days Task 6 For each of the rates that you have calculated in 30/06/2021 (see Task 5) compare them with both the 30/06/2020 data and the industry averages contained in the table above. Make sure you check consistency and accuracy of your work and the external data provided, then comment as to whether the rates have increased, decreased, or remained the same. Also advise Speedo Cycle of the possible causes of the rate changes and suggest what actions management may take to improve those rates Hint: please refer to textbook Chapter 4 on your understanding of application of ratio analysis to financial statements to answer this question Answer: (approx. 50 words each) Gross Profit rate A: Net Profit rate A: Quick ratio A: Inventory turnover (times per year) A: Accounts Receivable collection period (in days) A: Satisfactory Not Satisfactory Task 7 Satisfactory Not Satisfactory Explain the advantages and disadvantages of ratios and comparison techniques (approx. 150 words) Hint: please refer to module Management Reports & Analysis note in canvas A:
Expert Answer:
Related Book For
Marketing Research An Applied Orientation
ISBN: 978-0136085430
6th edition
Authors: Naresh K Malhotra
Posted Date:
Students also viewed these accounting questions
-
In the Household Expenditure Statistics: Year Ended 30 June 2016 (Statistics New Zealand, , licensed by Statistics New Zealand for re-use under the Creative Commons Attribution 3.0 New Zealand...
-
In preparing the financial statements for the year ended 30 June 2018 the accountant of Windsor Ltd, a tobacco manufacturer and wholesaler, has come to you with the following information and request...
-
For the year ended 30 June 2018, Green Pty Ltd (Turnover > $50 million) reported profit before tax of $750,000. The following information is available: Goodwill written off $30,000 Depreciation...
-
Is Madisons response regarding the factors that affect short-term and long-term rate volatility correct? A. Yes B. No, she is incorrect regarding factors linked to long-term rate volatility C. No,...
-
The following accounts and their balances appear in the ledger of Cline Properties Inc. on April 30 of the current year: Common Stock , $90 par...................$2,700,000 Paid-In Capital in Excess...
-
The manufacturer of a cable company sells cable for $30 per foot. The cost, C, of producing x feet of cable is C = 12.5x + 210. The company makes a profit when the amount of money received from...
-
What account is debited when a partner withdraws supplies for personal use?
-
Swan Creek Company has 40,000 shares of cumulative preferred 2% stock, $60 par and 50,000 shares of $50 par common stock . The following amounts were distributed as dividends: Year 1...... $ 30,000...
-
A new business buys $35,000 worth of computer equipment. If the useful life of the equipment is 8 years with a salvage value of $2,500, what is the Excel formula to determine the depreciation during...
-
A local gas station owner, Michael, is looking to invest in LED lighting displays around his fuel pumps to distinguish his station from the one just down the street. He has received several bids from...
-
Based on the given information, please calculate the followings: 1. Payback period 2. Discounted payback period 3. Profitability index 4. Net Present Value (NPV) 5. Internal Rate of Return Project A...
-
What is the relationship between the value of an MBS and the assumed volatility?
-
What dimension of a floaters price sensitivity do index duration and spread duration measure?
-
How does a collateralized mortgage obligation alter the cash flow from mortgages so as to shift prepayment risk across various classes of bondholders?
-
What is the difference between a hard and soft call in a convertible bond issue?
-
a. How is contribution to portfolio duration computed? b. How is the result interpreted?
-
The maximum ionic density in ionosphere is found to be 1 0 ^ 6 electrons per cubic centimeter, the maximum frequency at which the wave reflected back to the earth is 3 0 MHz . How much should be the...
-
Solve each equation. x 3 - 6x 2 = -8x
-
What is the main difference between a full-service and a limited-service supplier?
-
What sampling plan should be adopted for the survey of question 9?
-
What are the issues involved in designing multiple-choice questions?
-
What is the case for efficiency and productivity?
-
Do earnings differences reflect discrimination or differences in productivity?
-
How many people live in poverty?
Study smarter with the SolutionInn App