XYZ Company had a Gross Profit Margin of 48% last year, XYZ Company had sales of

Question

XYZ Company had a Gross Profit Margin of 48% last year, XYZ Company had sales of $13,500,000 last year, of which 71% were on credit and the remainder in cash? XYZ has current assets of $1,400,000 and current liabilities of $450,000, and $100,000 in cash. (a), If account receivable is $662,000, what's the Average Collection Period, (b), if they reduce Average Collection Period to 14 days, what's the new account receivable, (c), XYZ has an inventory turnover ratio of 7.5, what's their level of inventory? 6 The bond is currently trading for 93, (a). what is the companies MSFT has a coupon of 6 9% yield?, (b), if the bond rises to 104, does the yield increase or decrease?, (c, why does MSFT pay 7

Explanation / Answer

a) Average collection period = 365 / accounts receivable turnover ratio

= 365 / 14.48

= 25 days (approx)

Accounts receivable turnover ratio = Net credit sales / Average accounts receivable

= 9585000 / 662000

= 14.48

b) if they reduce average collection period to 14days,then new accounts receivable =

Average collection period = 365 * Accounts receivable / Net Credit sales

14 = 365 * Accounts receivable / 9585000

Accounts receivable = 367643.83

c) Inventory turnover ratio = 7.5

Inventory turnover ratio = cost of good sold / Average inventory

7.5 = 7,020,000 / Inventory

Inventory = 936000

Gross profit margin = 48%

Cost of goods sold = 1 - 0.48 = 52%

Cost of goods sold = 13500000 * 0.52 = 7,020,000

Related Questions

Navigate

• Browse (All)
• Browse X
• Subjects

---

---

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