Share
Explore BrainMass

Rosson Company: Analyzing financial statements, horizontal analysis, ratios

Analyzing Financial Statements

Information below comes from the financial statements of Rosson Company.

2004 2003
Revenues:
Net Sales $299,000 $246,000
Other Revenues 8,000 9,000
Total Revenues 307,000 255,000
Expenses:
Cost of Goods Sold 172,000 138,000
S,G&A Expenses 44,000 40,000
Interest Expense 4,000 4,500
Income Tax Expense 31,000 25,400
Total Expenses 251,000 207,900
Income Before Extraordinary Items 56,000 47,100
Extraordinary Gain (net of tax) 9,000 0
Net Income $ 65,000 $ 47,100

Assets
Current Assets:
Cash $ 7,500 $ 12,500
Marketable Securities 1,000 1,500
Accounts Receivable 50,000 47,500
Inventories 150,000 145,000
Prepaid Expenses 5,000 2,500
Total Current Assets 213,500 209,000
Plant and Equipment (net) 147,000 157,000
Intangibles 30,500 0
Total Assets $391,000 $366,000

Equities
Liabilities:
Current Liabilities:
Accounts Payable $ 58,000 $ 79,500
Other Accrued Liabilities 25,000 22,500
Total Current Liabilities 83,000 102,000
Bonds Payable 90,000 100,000
Total Liabilities 173,000 202,000

Stockholders? Equity:
Common Stock ($5 par) 130,000 130,000
Paid-In Capital in Excess of Par of Par 20,000 20,000
Retained Earnings 68,000 14,000
Total Stockholders? Equity 218,000 164,000
Total Equities $391,000 $366,000

Market price at year-end $14.00 $8.55
Dividend payments amounted to $11,000 in 2004 and $5,000 in 2003.

Required
Perform the following analyses. If you have insufficient data to use averages in ratio computations, use year-end balances in the calculations.

a. Perform horizontal analysis of the income statement and balance sheet data. Use 2003 as the base year.
b. Perform vertical analysis of the income statement and balance sheet data for 2003 and 2004. Use sales revenue as the base figure for the income statement. Use total assets as the base figure for the balance sheet.
c. Calculate the following liquidity ratios for 2004 and 2003: (1) working capital, (2) current ratio, (3) quick (acid-test) ratio, (4) accounts receivable turnover, (5) average collection period, (6) inventory turnover, (7) number of days required to sell inventory.
d. Calculate the following solvency ratios for 2004 and 2003: (1) liabilities to total equity, (2) stockholders? equity ratio, (3) debt/equity ratio, (4) number of times interest earned, (5) plant assets to long-term liabilities.
e. Calculate the following profitability ratios for 2004 and 2003: (1) net margin, (2) turnover of assets, (3) return on investment, (4) return on equity.
f. Calculate the following stock market ratios for 2004 and 2003: (1) earnings per share, (2) book value per share, (3) price-earnings ratio, (4) dividend yield.

Solution Preview

(a) Horizontal Analysis
In horizontal analysis you have to compare financial data of two or more years. For example, sales revenue from 2003 to 2004 has increased by $52000 or 20.39% (52000*100/255000). Similarly you can calculate the rise in net income: $17900 or 38%. These are very good signs for any company.
You can also put other income statement or balance sheet figures and calculate the growth or otherwise.

(b) Vertical Analysis
Income Stat: You may calculate Gross Profit Margin = Gross Profit/Sales or Net Profit Margin/Sales. These are very popular profitability ratios.

Balance Sheet: Calculate Return on Assets=Net Income/Assets, Debt to Assets = Total Liabilities/Assets, Debt to Equity = Total Liabilities/Shareholders' Equity. These are leverage and liquidity ratios.
...

Solution Summary

The solution presents the computations for all the ratio analysis together with narrative for better understanding.

$2.19