Accounting Help

Help in Accounting please, serious inquiries only, and must know your stuff! Textbook is Accounting principles 10th edition

Need by tomorrow (Feb. 7 2013).

CHAPTER 18 ASSIGNMENT

Instructions: Complete the problems below. This assignment can be completed in either: Microsoft Excel, Word, or hand-written and scanned in PDF format. I prefer Microsoft Excel or Word but will not dock points for PDF format.

PART A. (16 points) Use the following data to calculate the ratios below:

CURRENT YEAR PRECEDING YEAR
Current Assets 745,000 820,000
Property, Plant, and Equipment 1,510,000 1,400,000
Total Assets 2,800,000 3,400,000
Current Liabilities (non-interest-bearing) 160,000 140,000
Long-term Liabilities, 12% 400,000 400,000
Preferred Stock, 10% 250,000 250,000
Common Stock, $25 par (current market price is $25/share) 1,200,000 1,200,000
Retained Earnings:
Beginning of Year 240,000 160,000
Net Income for Year 95,000 155,000
Preferred Dividends Declared (25,000) (25,000)
Common Dividends Declared (70,000) (60,000)
Net Sales 3,800,000

1. Profit margin

2. Asset turnover

3. Current ratio

4. Return on assets

5. Return on common stockholders’ equity

6. Earnings per share

7. Price-earnings ratio

8. Debt to total assets ratio

PART B. (16 points) Use the following data to complete the problems below:

ASSETS 2012 2011
Current Assets 440 280
Plant Assets 675 520
Total Assets $ 1,115 $ 800

LIABILITIES AND STOCKHOLDERS’ EQUITY
Current Liabilities 280 120
Long-term Debt 250 160
Common Stock 325 320
Retained Earnings 260 200
Total Liabilities and Stockholders’ Equity $ 1,115 $ 800

9. Using horizontal analysis, show the percentage change for each balance sheet item.

10. Using vertical analysis, prepare a comparative balance sheet.

PART C. (8 points) Use the following data to answer the question:

CURRENT YEAR PRECEDING YEAR
Cash, marketable securities, and receivables 80,000 84,000
Inventories 120,000 66,000
Total Current Assets 200,000 150,000
Current Liabilities 100,000 60,000
Working Capital 100,000 90,000

11. Has the current year’s position improved? Explain. (Hint: use whatever ratios you can to compare the financial position of the preceding year and current year)

PART D. (10 points) Use the following data to answer the question:

Total Assets 2,000,000
Average Total Assets 2,200,000
Net Income 250,000
Net Sales 1,300,000
Average Common Stockholders’ Equity 1,000,000
Net Cash Provided By Operating Activities 275,000
Shares of Common Stock Outstanding 10,000

12. Calculate all profitability ratios that can be computed from the above information.