Using the information in the above financial reports calculate the following rat

Question

Using the information in the above financial reports calculate the following ratios for Bettacort P/l for 2018.

Bettacort P/L Comparative Income Statement For the years ending 31 December 2017 and 2018 2017 1,212,000 1,010,000 10,000 1,200,000 1,000,000 500,000 475,000 525,000 66000 225,000 750,000 200,000 150,000 60,000 340,000 80,00060,000 2018 Sales (all on credit) Sales returns and allowances Net sales Cost of goods sold Gross profit Other Income 12,000 700,000 Selling expenses Administrative expenses Interest expense Net profit before tax Tax expense Net profit after tax 866,000 240,000 180,000 66,000 380,000 28

Explanation / Answer

1.Asser Turnover ratio = Sales / Total Assets = $1,200,000 / $4,770,000 = 25.16%

2.Average Collection period = accounts receivable x 365 days/ credit sales

= $130,000 x ( 365 / $1,200,000) = 39.54 days

3.Current Ratio = current assets/current liabilities = $1,100,000 / $440,000 = 2.5

4.Debt Ratio = Total Debt / Total assets = $1,100,000 / $4,770,000 = 0.23

5.Equity Ratio = Total Equity / Total Assets = $3,230,000 /$4,770,000 = 0.68

6.Inventory Turnover = sales or cost of goods sold/inventory = $1,200,000 / 67,000 = 17.91

7.Profit Margin = Net Income / Net Sales = 300,000 / 1,200,000 = 25%

8.Quick Ratio = current assets - inventory/ current liabilities = ($1,100,000 - $67,000) / $440,000 = 2.35

9.Return on assets = Net Income / Average Total Assets = ((300,000) / (4,770,000 + 4,355,000)/2) = 6.58%

10.Return on equity = Net Income / Average shareholders equity = ((300,000) / (3,230,000 + 2,955,000)/2) = 9.70%

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.