Financial Data for Springfield Power Co. as of December 31, 2004: Inventory $200

Question

Financial Data for Springfield Power Co. as of December 31, 2004:

Inventory                                                                            $200,000

Long-term debt                                                                   $300,000

Interest expense                                                                $15,000

Accumulated depreciated                                                  $440,000

cash                                                                                 $260,000

Net Sales (all credit)                                                       $1,500,000

Common Stock                                                               $800,000

Accounts receiveables                                                     $225,000

Operating expenses (incl. depr. Exp. and taxes)            $525,000

Notes payables-current                                                   $180,000

Cost of goods sold                                                           $940,000

Plant and Equipment                                                     $1,300,000

Accounts Payable                                                          $160,000

Marketable securities                                                     $90,000

Accured wages                                                               $65,000

Retained earnings                                                          $130,000

From the information above, calculate the follwoing ratios for the Springfield Power Co.

1. Current ratio

2. Acid test ratio

3. Average collection period

4. inventory turnover

5. Gross profit margin

6. operating profit margin

7. net profit margin

8. total asset turnover

9. times-interest-earned

Explanation / Answer

Assets

Liabilities and Equity

1. Current ratio = Current assets/ Current liabilities

= $775000/ $405000 = 1.91 times

2. Acid test ratio = (Current assets - Inventory)/ Current liabilities

= ($775000 - $200000) / $405000

= 1.42 times

3. Average collection period = 365 days x Accounts receivable / Sales

= 365 x $225000/ $1500000

= 54.75 days

4. Inventory turnover = Cost of goods sold/ Inventory

= $940000/ $200000

= 4.7 times

5. Gross profit margin = (Sales - Cost of goods sold)/ Sales

= ($1500000 - $940000)/ $1500000

= 37.33%

6. Operating profit margin = (Sales - Cost of goods sold - Operating expenses)/ Sales

= ($1500000 - $940000 - $525000) / $1500000

= 2.33%

7. Net profit margin = (Sales - Cost of goods sold - Operating expenses - Interest expense)/ Sales

= ($1500000 - $940000 - $525000 - $15000) / $1500000

= 1.33%

8. Total asset turnover = Sales/ Total assets

= $1500000/ $1635000

= 0.92 times

9. Times-interest-earned = Operating profit/ Interest expense

= (Sales - Cost of goods sold - Operating expenses)/ Interest expense

= ($1500000 - $940000 - $525000)/ $15000

= 2.33 times

Inventory $200000 Cash 260000 Accounts receivables 225000 Marketable securities 90000 Total current assets $775000 Plant and equipment, net (1300000-440000) 860000 Total assets $1635000

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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