wk 3 495503
Target
Download most recent Annual Report from their Website. ( Post with assignment)
Prepare an Excel Workbook.
Tab 1 – Horizontal Analysis of the Balance Sheet
Tab 2 – Vertical Analysis of the Income Statement
Tab 3 – Financial Ratios – Select 2 profitability and 2 liquidity ratios (Use formate covered in class, I want to see details of the calculations.)
Review analysis work and select 4 of the more critical observations made in the analysis.
Write a paper of no more that 1250 words in which you conduct a comparative and ratio analysis to measure profitability and liquidity.
, Page of , 12/31/2012 12/31/2011 106000 90000 400000 350000 99000 65000 122000 90000 130000 115000 155000 170000 12/31/2005 2012 2011 , , Page of Page(s), 2012 2011 800000 600000 520000 408000 120000 72000 60000 48000 30000 24000 70000 48000 2012 2011 , , Page of Page(s), 12/31/2005 2012 2011 2010 30000 20000 18000 50000 45000 48000 90000 95000 64000 55000 70000 45000 500000 370000 358000 725000 600000 533000 85000 80000 70000 145000 85000 50000 320000 310000 300000 175000 125000 113000 725000 600000 533000 2012 2011 740000 600000 40000 30000 700000 570000 425000 350000 275000 220000 180000 150000 95000 70000 1 7 7.5 8.5 2 2012 2011 2012 2011 2012 2011 2012 2011 2012 2011 2012 2011 2012 2011 , , Page of Page(s), Retained earnings Instructions: Amount Formula Name: Course: Date: Total stockholders’ equity Current assets Plant assets (net) Current liabilities Long-term liabilities Common stock, $1 par Condensed Balance Sheet Increase or (Decrease) Percentage Assets Total assets Liabilities Total liabilities Stockholders’ Equity Total liabilities and stockholders’ equity Instructor: E13-3, Prepare horizontal analysis. Here is financial information for Pauletti Inc. Prepare a schedule showing a horizontal analysis for 2012 using 2011 as the base year. PAULETTI INC. E13-4, Prepare vertical analysis. Operating data for Gladow Corporation are presented below. Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income Prepare a schedule showing a vertical analysis for 2012 and 2011. GLADOW CORPORATION Condensed Income Statement For the Years Ended December 31 Percent Gross profit Account title Title P13-3A, Perform ratio analysis, and discuss change in financial position and operating results. Condensed balance sheet and income statement data for Glassgow Corporation are presented here. GLASSGOW…
Attachments:
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.