Case Question 12-22 (c1) Assess Pippin’s liquidity. Case Question 12-22 Pippin P

Question

Case Question 12-22

(c1) Assess Pippin’s liquidity.

Case Question 12-22

Pippin Piping Co. manufactures decorative fabric trims. The company’s financial statements follow.
Pippin Piping Co.
Comparative Income Statements
For the Years Ended December 31 2016 2015 2014 Sales revenue $576,600 $523,000 $484,200 Cost of goods sold 291,000 259,200 234,300 Gross margin 285,600 263,800 249,900 Operating expenses 106,200 104,600 104,100 Operating income 179,400 159,200 145,800 Other revenue 22,500 15,900 23,900 Interest expense 11,200 10,500 11,900 Income before income tax 190,700 164,600 157,800 Income tax expense (40%) 76,280 65,840 63,120 Net income $114,420 $98,760 $94,680 Pippin Piping Co.
Comparative Balance Sheets
As of December 31 Assets 2016 2015 2014     Cash $32,000 $25,800 $20,500     Accounts receivable (net) 126,860 127,000 94,300     Inventory 60,000 80,700 56,000     Prepaid expenses 11,000 10,000 4,600             Total current assets 229,860 243,500 175,400     Property & equipment (net) 668,900 576,000 540,300 Total Assets $898,760 $819,500 $715,700 Liabilities and Stockholders’ Equity     Accounts payable $53,120 $81,200 $79,100     Accrued expenses 11,000 12,240 41,700             Total current liabilities 64,120 93,440 120,800     Long-term debt 170,000 160,000 150,000             Total liabilities 234,120 253,440 270,800 Stockholders’ Equity     Common stock, $0.50 par value 6,000 6,000 5,000     Additional paid-in capital 99,000 99,000 62,000     Retained earnings 559,640 461,060 377,900             Total stockholders’ equity 664,640 566,060 444,900 Total Liabilities and Stockholders’ Equity $898,760 $819,500 $715,700
Additional information
2016 2015 2014 Closing stock price $38 $35 $30 Shares outstanding 12,000 12,000 10,000 Dividends paid per share $1.32 $1.30 $1.25

(c1) Assess Pippin’s liquidity.

Working capital 2014 $ 2015 $ 2016 $ Current ratio (Round answers to 2 decimal places, e.g. 52.75 2014 2015 2016 Acid test ratio (Round answers to 2 decimal places, e.g. 52.75. 2014 2015 2016

Explanation / Answer

Solution

(243500-10000-80700)/93440=1.64

523000/110650*=4.7

*(94300+127000)/2=53500

576600/126930*=4.5

*(127000+126860)/2=

259200/68350*=3.8

*(56000+80700)/2=68350

291000/70350*=4.1

*(80700+60000)/2=70350

S.No. Ratio Formula 2014 2015 2016 1 Working Capital = Current Asset-Current Liablities 175400-120800=54600 243500-93440=150060 229860-64120=165740 2 Current ratio = Current Asset/Current Liablities 175400/120800=1.45 243500/93440=2.61 229860/64120=3.58 3 Quick ratio = Total Current Asset-Inventroy-Prepaid Expense/Current Liabalities (175400-4600-56000)/120800=0.95

(243500-10000-80700)/93440=1.64

(229860-11000-60000)/64120=2.48 4 Account Receivable Turnover Ratio=Net Credit Sales/Average Accounts Receivable

523000/110650*=4.7

*(94300+127000)/2=53500

576600/126930*=4.5

*(127000+126860)/2=

5 Average Account Receivable=365/Account Receivable Turnover Ratio 365/4.7=77.2 365/4.5=80.3 6 Inventory turnover= Cost of Goods Sold/Average Inventory

259200/68350*=3.8

*(56000+80700)/2=68350

291000/70350*=4.1

*(80700+60000)/2=70350

7 Average days to sell inventory=Ending Inventory/Cost of Goods Sold*365 (80700/259200)*365=113.6 (60000/291000)*365=75.3

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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