Here are the calculations for the required ratios:
a) Rate of stock turnover
Step 1: Calculate the average stock.
AverageStock=2OpeningStock+ClosingStock
AverageStock=2$63,000+$50,300=2$113,300=$56,650
Step 2: Calculate the rate of stock turnover.
RateofStockTurnover=AverageStockCostofGoodsSold
RateofStockTurnover=$56,650$227,700≈4.02times
The rate of stock turnover is 4.02times.
b) Gross profit margin
Step 1: Use the formula for gross profit margin.
GrossProfitMargin=SalesGrossProfit×100%
GrossProfitMargin=$418,350$190,650×100%≈45.57%
The gross profit margin is 45.57%.
c) Current ratio
Step 1: Calculate total current assets.
CurrentAssets=Stock+Debtors+Cash
CurrentAssets=$50,300+$32,500+$18,350=$101,150
Step 2: Use the formula for the current ratio.
CurrentRatio=CurrentLiabilitiesCurrentAssets
CurrentRatio=$41,750$101,150≈2.42:1
The current ratio is 2.42:1.
d) Acid test ratio
Step 1: Calculate quick assets (current assets excluding stock).
QuickAssets=CurrentAssets−Stock
QuickAssets=$101,150−$50,300=$50,850
Step 2: Use the formula for the acid test ratio.
AcidTestRatio=CurrentLiabilitiesQuickAssets
AcidTestRatio=$41,750$50,850≈1.22:1
The acid test ratio is 1.22:1.
e) Return on capital employed
Step 1: Calculate capital employed.
CapitalEmployed=Capital+NetProfit−Drawings
CapitalEmployed=$110,500+$40,000−$21,400=$129,100
Step 2: Use the formula for return on capital employed.
ReturnonCapitalEmployed=CapitalEmployedNetProfit×100%
ReturnonCapitalEmployed=$129,100$40,000×100%≈30.98%
The return on capital employed is 30.98%.
Send me the next one 📸