Solved by verified expert :Chapter 2 Mini Case: “Financial Statement and Cash Flow Analysis”
Jaedan
Industries
Income
Statement
For
the year ending December 31, 2010
Sales
$42,000,000
COGS
$26,460,000
Gross Profit
$15,540,000
Operating Expenses
Selling, General
& Administrative
$1,621,000
Depreciation
$800,000
Earnings Before
Interest & Tax
$13,119,000
Interest Expense
$375,000
Earnings before Taxes
$12,744,000
Taxes
$4,332,960
Net Income
$8,411,040
Dividends Paid
$2,102,760
Additions to Retained
Earnings
$6,308,280
Jaedan
Industries
Statement
of Retained Earnings
For
the year ending December 31, 2010
Balance from
beginning of the year
$1,628,819
Addition: Net Income
of 2010
$8,411,040
Less: Cash dividends
paid during 2010
Preferred Stock
$8,000
Common Stock
$2,102,760
Total dividends paid
$2,110,760
Retained Earnings
Balance as on Dec 31, 2010
$7,929,099
Jaedan
Industries
Balance
Sheet
December
31, 2010
Assets
Cash
$3,689,000
Marketable securities
$1,836,000
Accounts Receivable
$5,423,000
Inventory
$4,118,000
Total Current
Assets
$15,066,000
Fixed Assets
$14,811,000
Less: Accumulated
Depreciation
$5,960,000
Net Fixed Assets
$8,851,000
Total Assets
$23,917,000
Liabilities & Equity
Accounts Payable
$3,136,000
Notes Payable
$706,000
Accruals
$500,000
Total Current
Liabilities
$4,342,000
Long term bonds
$3,046,000
Preferred stock
$100,000
Common Stock (at par)
$4,000,000
Paid-in capital in
excess of par
$4,500,000
Retained Earnings
$7,929,099
Total Liabilities
& Equity
$23,917,099
Jaedan
Industries
Statement
of Cash Flows
For
the year ended December 31, 2010
Cash flow from
operating activities
Net Income
$8,411,040
Depreciation
$800,000
Increase in Accounts
Receivable
($2,556,000)
Increase in Inventory
($908,000)
Increase in accounts
payable
$190,000
Increase in Accruals
$150,000
Cash provided by
operating activities
$6,087,040
Cash flow from
investment activities
Increase in gross
fixed assets
($2,932,000)
Cash provided by
investment activities
($2,932,000)
Cash flow from
financing activities
Increase in notes
payable
$22,000
Dividends paid:
Preferred
($8,000)
Common
($2,102,760)
Cash provided by
financing activities
($2,088,760)
Net increase in
cash and marketable securities
$1,066,280
Free Cash Flow:
OCF =
[13119000*(1-0.34)] + 800000 =
$9,458,540
Change in Fixed
Assets =
$2,932,000
Change in Current
Assets =
$4,530,181
Change in Accounts
Payable =
$190,000
Change Accruals =
$150,000
FCF = $9,458,540 – $2,932,000 – ($4,530,181
– $190,000 -$150,000)
=
$2,336,359
Ratios
for 2010 for Jaedan vs. Industry
Jaedan
Industry
Liquidity Ratios
Current Ratio
3.47
3.26
Quick Ratio
2.52
2.19
Current ratio for Jaedan = Total Current
Assets/Total Current Liabilities
=
$15,066,000/$4,342,000
=
3.469
Quick ratio for Jaedan = (Total Current
Assets – Inventory)/Total Current Liabilities
=
($15,066,000 – $4,118,000)/$4,342,000
=
2.52
Debt Ratios
Jaedan
Industry
Debt Ratio
30.89%
39.36%
Assets-to-equity
ratio
145.58%
163.13%
Debt-to-equity ratio
18.43%
30.23%
Times interest earned
34.98
16.81%
Debt ratio for Jaedan = (Total Current Liabilities + Long Term
Bonds)/Total Assets
=
($4,342,000 + $3,046,000)/$23,917,000
=
30.89
Asset-to-equity-ratio for Jaedan = Total Assets/ (Total Liabilities
& Equity – Long term bonds – Total Current Liabilities-Preferred Stock)
= $23,917,000/
($23,917,000 – $3,046,000 – $4,342,000 – $100,000)
=
145.58
Debt-to-equity-ratio for Jaedan = Long Term Bonds/ (Total
Liabilities & Equity – Long term bonds – Total Current Liabilities)
=
$3,046,000/ ($23,917,000 – $3,046,000 – $4,342,000)
=
18.43
Time Interest earned = EBIT/ Interest Expense
=
$13,119,000/ $375,000
=
34.98
Profitability
Ratios
Jaedan
Industry
Gross profit margin
37.00%
23.74%
Operating profit
margin
31.24%
20.89%
Net profit margin
20.03%
17.97%
Earnings per share
8.40
4.58
Return on Total
Assets
35.13%
41.87%
Return on Common
Equity
51.15%
68.30%
Gross profit margin = Gross Profit/ Sales =
$15,540,000/ $42,000,000
=
37.00%
Operating profit margin = EBIT/ Sales =
$13,119,000/ $42,000,000
=
31.235%
Net profit margin = Net Income/Sales = $8,
411, 040/ $42,000,000
=
20.026%
Earnings per Share = Earnings avail for
common stockholders/ number of common stock shares outstanding.
= $8, 403,040/ $1,000,000
=
$8.40
Return on Total Assets = Earnings avail for
common stockholders/Total Assets
= $8, 403,040/ $23,917,000
=
35.134%
Return on Common Equity = Earnings avail
for common stockholders/Common Stock Equity
= $8, 403,040/ $16,429,000
= 51.147%
Market ratios
Jaedan
Industry
P/E Ratio
6.76%
5.97%
Market/Book Ratio
3.46%
4.32%
P/E Ratio = Market Price per share of
common stock/ EPS
=
$56.82/$8.40 = 6.76%
Market/Book Ratio = Market Price per share
of common stock/ Book Value per share of common stock.
Book value per share of common stock =
common stock equity/ shares outstanding
=
16,429,000/1,000,000
=
$16.43
Market/Book Ratio = $56.82/$16.43 = 3.46%