I am having a hard time figuring this out and need help. I am attaching all the info. I cant seem to figure it out.
Cross-sectional ratio analysis:
Use the financial statements on Fox
Manufacturing Company for the year ended December 31, 2009, along with the
industry average ratios to:
a. Prepare and interpret a complete ratio analysis of the firm's 2009 operations.
b. Summarize your findings and make recommendations.
The solution helps in estimating ratios and also summarizing your findings and make recommendations.
11.12 Whittaker, Inc: Income statement and ratio analysis
See attached case study for Whittaker, IncProblem Description:
Presented below are partially completed financial statements for Whittaker, Inc.:
For the Year Ended December 31, 2011
Sales $ ?
Cost of goods sold ?
Gross profit $ ?
Operating expenses ?
Income from operations $ ?
Interest expense ?
Income before taxes $ ?
Income taxes (20%) ?
Net income $ ?
December 31, 2011
Cash $ ?
Accounts receivable ?
Merchandise inventory ?
Total current assets $171,000
Property, plant and equipment, net ?
Total assets $ ?
Current liabilities $ ?
Bonds payable, 15% 70,000
Total liabilities $ ?
Common stock, $2 par value 10,000
Additional paid-in-capital 15,000
Retained earnings ?
Total owners' equity ?
Total liabilities and owners' equity $ ?
Financial ratios computed from these financial statements include the following:
Current ratio 1.9 to 1
Acid-test ratio 1.3 to 1
Debt/equity ratio 2.0 to 1
Inventory turnover 4.0 times
Accounts receivable turnover 6.8 times
Times interest earned 4.45 times
Gross profit ratio 40%
Return on investment 12%
Earnings per share $5.52
All sales during the year were made on account. Cash collections during the year exceeded sales
by $14,000, and no uncollectible accounts were written off.
The balance of the accounts receivable account was $57,000 on January 1, 2011.
No common stock was issued during the year.
Dividends declared and paid during the year were $7,600.
The balance of the inventory account was $48,000 on January 1, 2011.
Interest expense on the income statement relates to the 15% bonds payable; $10,000 of these bonds
were issued on May 1, 2011; the remaining amount of bonds payable were outstanding throughout
the year. All bonds were issued at face value.
Please proceed to the "Analysis" worksheet and complete the basic problem requirements. Complete the problem
requirements by entering appropriate amounts or formulas in shaded worksheet cells:
a. Complete the income statement and balance sheet for Whittaker, Inc. Show how each amount was determined.
b. After completing part a, use your answers to recompute each of the financial ratios provided as additional
After completing the "Analysis" worksheet, please proceed to the "What the Numbers Mean" worksheet and respond
to the additional requirements presented.