MGT410

TB1 - Textbook Problems

Please complete the following textbook problems and upload your answers and work documenting how you arrived at your answers. You can use an Excel spreadsheet or Word document.

1. Chapter 2, Problem 18, Page 36

2. Chapter 1, Scientific Equipment Manufacturing (A problem created by Dr. Bober)

Please consider the following financial data from the past year for Scientific Equipment Manufacturing:

Gross Income........................ $32,280,000

Total Sales............................. $30,126,000

Total Credit Sales................... $22,560,000

Net Income.............................   $5,400,000

Cost of Goods Sold................  $18,000,000

Total Assets............................  $16,200,000

Average Inventory...................    $4,525,000

Average Receivables..............    $6,275,000

QUESTIONS:

a) Compute the receivables turnover ratio

solution

Receivables Turnover Ratio = Net credit sales/Average receivable

= $22,560,000/$6,275,000

=3.59521912

≈ 3.60 (2d.p)

Note: Net credit sales= Sales on credit -sales returns-sales allowances =$22,560,000-$0-$0= $22,560,000

b) Compute the inventory turnover ratio

solution

Inventory Turnover Ratio= cost of goods sold/average inventory

= $18,000,000/$4,525,000

= 3.97790055

≈ 3.98 (2d.p)

c) Compute the asset turnover ratio

solution

Asset turnover ratio = Net Sales/Average Total Assets

= $30,126,000/$16,200,000

= 1.85962963

≈ 1.86 (2d.p)