In: Finance
Refer to the following financial statements for Crosby
Corporation:
CROSBY CORPORATION Income Statement For the Year Ended December 31, 20X2 |
|||
Sales | $ | 3,470,000 | |
Cost of goods sold | 2,230,000 | ||
Gross profit | $ | 1,240,000 | |
Selling and administrative expense | 678,000 | ||
Depreciation expense | 298,000 | ||
Operating income | $ | 264,000 | |
Interest expense | 85,400 | ||
Earnings before taxes | $ | 178,600 | |
Taxes | 148,000 | ||
Earnings after taxes | $ | 30,600 | |
Preferred stock dividends | 10,000 | ||
Earnings available to common stockholders | $ | 20,600 | |
Shares outstanding | 150,000 | ||
Earnings per share | $ | 0.14 | |
Statement of Retained Earnings For the Year Ended December 31, 20X2 |
||
Retained earnings, balance, January 1, 20X2 | $ | 385,800 |
Add: Earnings available to common stockholders, 20X2 | 20,600 | |
Deduct: Cash dividends declared and paid in 20X2 | 175,000 | |
Retained earnings, balance, December 31, 20X2 | $ | 231,400 |
Comparative Balance Sheets |
|||||||
Year-End 20X1 |
Year-End 20X2 |
||||||
Assets | |||||||
Current assets: | |||||||
Cash | $ | 179,000 | $ | 94,600 | |||
Accounts receivable (net) | 505,000 | 543,000 | |||||
Inventory | 702,000 | 707,000 | |||||
Prepaid expenses | 67,600 | 35,000 | |||||
Total current assets | $ | 1,453,600 | $ | 1,379,600 | |||
Investments (long-term securities) | 94,000 | 85,600 | |||||
Gross plant and equipment | $ 2,090,000 | $ 2,630,000 | |||||
Less: Accumulated depreciation | 1,620,000 | 1,918,000 | |||||
Net plant and equipment | 470,000 | 712,000 | |||||
Total assets | $ | 2,017,600 | $ | 2,177,200 | |||
Liabilities and Stockholders’ Equity | |||||||
Current liabilities: | |||||||
Accounts payable | $ | 320,000 | $ | 604,000 | |||
Notes payable | 512,000 | 512,000 | |||||
Accrued expenses | 77,800 | 55,800 | |||||
Total current liabilities | $ | 909,800 | $ | 1,171,800 | |||
Long-term liabilities: | |||||||
Bonds payable, 20X2 | 132,000 | 184,000 | |||||
Total liabilities | $ | 1,041,800 | $ | 1,355,800 | |||
Stockholders’ equity: | |||||||
Preferred stock, $100 par value | $ | 90,000 | $ | 90,000 | |||
Common stock, $1 par value | 150,000 | 150,000 | |||||
Capital paid in excess of par | 350,000 | 350,000 | |||||
Retained earnings | 385,800 | 231,400 | |||||
Total stockholders’ equity | $ | 975,800 | $ | 821,400 | |||
Total liabilities and stockholders’ equity | $ | 2,017,600 | $ | 2,177,200 | |||
a. Prepare a statement of cash flows for the
Crosby Corporation: (Amounts to be deducted should be
indicated with parentheses or a minus sign.)
b. Compute the book value per common share for
both 20X1 and 20X2 for the Crosby Corporation. (Round your
answers to 2 decimals places.)
c. If the market value of a share of common stock
is 2.4 times book value for 20X2, what is the firm’s P/E ratio for
20X2? (Do not round intermediate calculations. Round your
final answer to 2 decimal places.)
CASH FLOW STATEMENT | |||||||
CASH FLOW FROM OPERATING ACTIVITIES | |||||||
a | Earning after taxes | $30,600 | |||||
b | Depreciation for the year | $298,000 | |||||
(Increase)/Decrease in current assets | |||||||
c | Increase in Accounts Receivable | -$38,000 | (543000-505000) | ||||
d | Increase in Inventory | -$5,000 | (707000-702000) | ||||
e | Decrease in Prepaid Expenses | $32,600 | (67600-35000) | ||||
Increase/(Decrease) in current liabilities | |||||||
f | Increase in Accounts Payable | $284,000 | (604000-320000) | ||||
g | Decrease in accrued expenses | -$22,000 | (77800-55800) | ||||
h=a+b+c+d+e+f+g | NET CASH PROVIDED BY OPERATING ACTIVITIES | $580,200 | |||||
CASH FLOW FROM INVESTING ACTIVITIES | |||||||
i | Increase in gross Plant and Equipments | -$540,000 | (2630000-2090000) | ||||
j | Changes in Long Term investment in Equity | $8,400 | (94000-85600) | ||||
k=i+j | NET CASH FLOW PROVIDED BY INVESTING ACTIVITIES | -$531,600 | |||||
CASH FLOW FROM FINANCING ACTIVITIES | |||||||
Increase in Long Term Debt | $52,000 | (184000-132000) | |||||
Less: Total dividends paid | -$185,000 | ||||||
l | NET CASH FLOW PROVIDED BY FINANCING ACTIVITIES | -$133,000 | |||||
m=h+k+l | Total Cash added to reserve | -$84,400 | |||||
Cash in the beginning | $179,000 | ||||||
Cash at the end | $94,600 | ||||||
Retained Earnings in the beginning | $385,800 | ||||||
Add:Net Income | $30,600 | ||||||
Less:Dividend Paid | $185,000 | ||||||
Retaind Earnings at the End | $231,400 | ||||||
b | Book Value Per Share: | ||||||
20X1 | 20X2 | ||||||
Total Stock holders Equity | $975,800 | $821,400 | |||||
Less: Preference Shares | $90,000 | $90,000 | |||||
X | Book Value of Common shares | $885,800 | $731,400 | ||||
Y | Number of common shares | 150000 | 150000 | ||||
X=X/Y | Book Value Per Share: | $5.91 | $4.88 | ||||
c | Net Income | $30,600 | |||||
Preferred Dividend | $10,000 | ||||||
Earnings of common shares | $20,600 | ||||||
Earning per share=20600/150000= | $0.14 | ||||||
X | Market Value per share =2.4*4.88 | $11.70 | |||||
Y | Earning per share | $0.14 | |||||
PE=X/Y | P/E Ratio | 85.21165 | |||||