The following financial statements are for Sioux Appliances,a sole trader,for the years ending 31 March 20X3,20X4 and 20X5.
continues over page
Other information:
20X2 Accounts receivable were 52,000
20X2 Inventory were 19,000
20X2 Total assets were 360,000
20X2 Sales were 490,000
The bank overdraft limit is $20,000.
The mortgage is due for repayment in 20X7.
a Give a brief explanation of what each of the following ratios measure or mean: (You are not required to interpret the results from the financial statements at this point. )
i Net profit %,Return on equity %
ii Inventory turnover (days),Accounts receivable turnover (days)
iii Liquidity ratio (= Quick ratio),Debt ratio %.
b Calculate the following ratios for the 20X5 year.Show your calculations.
i Gross profit %,Net profit %,Return on equity %
ii Inventory turnover,in times per year and in days
iii Accounts receivable turnover,in times per year and in days
iv Current ratio,Liquidity ratio,Debt ratio %.
c Comment on the ratios calculated above,and the financial statement results for Sioux Appliances during the years 20X3-20X5 inclusive,in the following areas:
• profitability
• managerial performance
• financial stability.
d Recommend to Sioux what you consider to be the 6 most important things to do to correct her financial position and performance.

Question

The following financial statements are for Sioux Appliances,a sole trader,for the years ending 31 March 20X3,20X4 and 20X5.
  continues over page
  Other information:
20X2 Accounts receivable were 52,000
20X2 Inventory were 19,000
20X2 Total assets were 360,000
20X2 Sales were 490,000
The bank overdraft limit is $20,000.
The mortgage is due for repayment in 20X7.
a Give a brief explanation of what each of the following ratios measure or mean: (You are not required to interpret the results from the financial statements at this point. )
i Net profit %,Return on equity %
ii Inventory turnover (days),Accounts receivable turnover (days)
iii Liquidity ratio (= Quick ratio),Debt ratio %.
b Calculate the following ratios for the 20X5 year.Show your calculations.
i Gross profit %,Net profit %,Return on equity %
ii Inventory turnover,in times per year and in days
iii Accounts receivable turnover,in times per year and in days
iv Current ratio,Liquidity ratio,Debt ratio %.
c Comment on the ratios calculated above,and the financial statement results for Sioux Appliances during the years 20X3-20X5 inclusive,in the following areas:
• profitability
• managerial performance
• financial stability.
d Recommend to Sioux what you consider to be the 6 most important things to do to correct her financial position and performance.

Quizplus · Accepted Answer

The Answer is a i Net profit % measures the efficiency of net profit generation.
Return on equity % measures the rate of return on the owner's investment in the business.
ii Inventory turnover in days measures how many days on average it takes to sell stock.
Accounts receivable turnover measures how long on average it takes to collect money from customers.
iii Liquidity ratio measures the ability of a firm to pay its debts due within 1-2 months.
Debt ratio measures the % of the firm's total $ assets that are financed by borrowing.
b Ratios:

a i Net profit % measures the efficiency of net profit generation. Return on equity % measures the rate of return on the owner's investment in the business. ii Inventory turnover in days measures how many days on average it takes to sell stock. Accounts receivable turnover measures how long on average it takes to collect money from customers. iii Liquidity ratio measures the ability of a firm to pay its debts due within 1-2 months. Debt ratio measures the % of the firm's total $ assets that are financed by borrowing. b Ratios: c Profitability • Gross profit % has been constant each year,but the net profit % has decreased considerably.This means that net-profit-making efficiency has decreased considerably. • Return on equity has dropped below bank interest rates from 20X3-20X5,actual gross profit has almost halved,and actual net profit has almost disappeared. • A decrease in advertising has led to a decrease in sales and profitability. • Bad debts have risen slightly,suggesting bad credit control. • Interest expense is very high and has increased each year. Managerial performance • Inventory turnover has slowed down considerably.It is taking about one and a half times longer to sell inventory in 20X5 compared with 20X3. • Although sales dropped greatly from 20X3-20X5,the inventory balance only dropped slightly.This suggests inefficiency in inventory management. • Accounts receivable turnover has improved dramatically each year from 20X3-20X5.Accounts receivable was very good at 37 days in 20X3;now it is even better at 21 days,which is well below the expected norm of 35-40 days. Financial stability • The current ratio was very close to the approximate ideal of 2 : 1 in 20X3.At 1.8 : 1 in 20X5 it is still reasonably close to 2 : 1. • The liquidity ratio was very high in 20X3.It is still above 1 : 1 in 20X5,meaning the business is solvent (able to pay its short-term debts). • The level of debt has risen to almost 79%.At this level,the business is quite risky,as banks are unlikely to lend more money to the firm. • The total interest expense is also very high,which adds to the risk. • Despite the decreasing sales,Accounts payable have risen,suggesting the firm has problems paying its debts. • Drawings have been rising and were very high in the last year. • The business cannot afford this level of drawings to continue. d Recommendations • Increase advertising back up to the 20X3 level to boost sales. • Provide discount for cash to encourage cash sales (which are currently zero). • Have a sale with low prices on old stock to reduce inventory level. • Check and delete any slow-moving inventory items. • Investigate if there are any errors in accounting records. • If possible,sell or lease part of the land and buildings to enable more debt to be repaid. • Reduce drawings back to the 20X3 level or lower to enable more debt to be repaid. • Investigate ways to reduce the level of debt and therefore to reduce interest payments.

c Profitability
• Gross profit % has been constant each year,but the net profit % has decreased considerably.This means that net-profit-making efficiency has decreased considerably.
• Return on equity has dropped below bank interest rates from 20X3-20X5,actual gross profit has almost halved,and actual net profit has almost disappeared.
• A decrease in advertising has led to a decrease in sales and profitability.
• Bad debts have risen slightly,suggesting bad credit control.
• Interest expense is very high and has increased each year.
Managerial performance
• Inventory turnover has slowed down considerably.It is taking about one and a half times longer to sell inventory in 20X5 compared with 20X3.
• Although sales dropped greatly from 20X3-20X5,the inventory balance only dropped slightly.This suggests inefficiency in inventory management.
• Accounts receivable turnover has improved dramatically each year from 20X3-20X5.Accounts receivable was very good at 37 days in 20X3;now it is even better at 21 days,which is well below the expected norm of 35-40 days.
Financial stability
• The current ratio was very close to the approximate ideal of 2 : 1 in 20X3.At 1.8 : 1 in 20X5 it is still reasonably close to 2 : 1.
• The liquidity ratio was very high in 20X3.It is still above 1 : 1 in 20X5,meaning the business is solvent (able to pay its short-term debts).
• The level of debt has risen to almost 79%.At this level,the business is quite risky,as banks are unlikely to lend more money to the firm.
• The total interest expense is also very high,which adds to the risk.
• Despite the decreasing sales,Accounts payable have risen,suggesting the firm has problems paying its debts.
• Drawings have been rising and were very high in the last year.
• The business cannot afford this level of drawings to continue.
d Recommendations
• Increase advertising back up to the 20X3 level to boost sales.
• Provide discount for cash to encourage cash sales (which are currently zero).
• Have a sale with low prices on old stock to reduce inventory level.
• Check and delete any slow-moving inventory items.
• Investigate if there are any errors in accounting records.
• If possible,sell or lease part of the land and buildings to enable more debt to be repaid.
• Reduce drawings back to the 20X3 level or lower to enable more debt to be repaid.
• Investigate ways to reduce the level of debt and therefore to reduce interest payments.

The Following Financial Statements Are for Sioux Appliances,a Sole Trader,for