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:
excel.xlsx