"You are to complete a vertical and horizontal analysis as well as a ratio analysis"

AutoSave OFF Home Insert Draw Page Layout R47 5 Balance Sheet Items 6 7 8 Accounts Receivable 9 Inventory 10 Other Current Assets 11 Cument Assets 12 1 Gerdau Ameristeel Corporation 3 All amounts in US dollars, except common shares issued Cash and cash equivalents 13 Property, Plant and Equipment 14 Other Assets 15 Total Assets 16 17 Current Liabilities 18 Long-Term Debt 19 Other Liabilities 20 Total Liabilities 21 22 Common Shareholders' Equity 23 Weighted Average Number of Common Shares 24 Outstanding 25 Cash Dividends 26 Preferred Dividends 27 28 Statement of Earnings Items 29 Net Sales 30 Cost of Goods Sold 31 Amortization 32 Eamings from operations 33 Interest Expense 34 Income Tax Expense (recovery) 35 Net Eamings (Loss) 36 37 Other Items 38 Cash flows from (used in) Operating Activities 39 Net Capital Expenditures 40 Market Price at December 31, 2006 41 42 Adjustments 43 Cash includes restricted cash 44 45 Other current assets includes defemed tax assets 46 Ready Data 2. C ... Formulas Ratios B + Data $109,734,000 $460,828,000 $820,485,000 $205,996,000 $1,597,043,000 47 Other assets include investments, goodwill 48 defemed financing costs and deferred tax assets 49 Long-tem labilities include convertible debentures 50 Other labilities include accrued benefit obligations and deferred tax labilities 51 52 2006 Vertical 2006 $1,119,458,000 $459.887.000 $3,176,388,000 $525,691,000 $431,441,000 $367,122,000 $1,324,254,000 $1,852,134,000 304,992,828 $91,387,000 N/A $4,464,203,000 $3,610,812,000 $142,984,000 $512,942,000 $43,619,000 $198,929,000 $378,646,000 $508,168,000 $200,253,000 $10.41 Copy of Gerdau_Ameristeel_student.xls Review View Tell me 2005 Vertical 2005 $414,732,000 $344,758,000 $745,165,000 $46,448,000 $1,551,103,000 $955,601,000 $322,747,000 $2,829,451,000 $435,051.000 $529,331,000 $281,050,000 $1,245,432,000 $1,584,019,000 304,276,512 $66,935,000 N/A $3,897,143,000 $3,253,865,000 $103,035,000 $400,505,000 $50,420,000 $144,687,000 $295,497,000 $578,456,000 $129,420.000 Horizontal - Co AutoSave OFF Home Insert Draw Page Layout R47 5 Balance Sheet Items 6 7 8 Accounts Receivable 9 Inventory 10 Other Current Assets 11 Cument Assets 12 1 Gerdau Ameristeel Corporation 3 All amounts in US dollars, except common shares issued Cash and cash equivalents 13 Property, Plant and Equipment 14 Other Assets 15 Total Assets 16 17 Current Liabilities 18 Long-Term Debt 19 Other Liabilities 20 Total Liabilities 21 22 Common Shareholders' Equity 23 Weighted Average Number of Common Shares 24 Outstanding 25 Cash Dividends 26 Preferred Dividends 27 28 Statement of Earnings Items 29 Net Sales 30 Cost of Goods Sold 31 Amortization 32 Eamings from operations 33 Interest Expense 34 Income Tax Expense (recovery) 35 Net Eamings (Loss) 36 37 Other Items 38 Cash flows from (used in) Operating Activities 39 Net Capital Expenditures 40 Market Price at December 31, 2006 41 42 Adjustments 43 Cash includes restricted cash 44 45 Other current assets includes defemed tax assets 46 Ready Data 2. C ... Formulas Ratios B + Data $109,734,000 $460,828,000 $820,485,000 $205,996,000 $1,597,043,000 47 Other assets include investments, goodwill 48 defemed financing costs and deferred tax assets 49 Long-tem labilities include convertible debentures 50 Other labilities include accrued benefit obligations and deferred tax labilities 51 52 2006 Vertical 2006 $1,119,458,000 $459.887.000 $3,176,388,000 $525,691,000 $431,441,000 $367,122,000 $1,324,254,000 $1,852,134,000 304,992,828 $91,387,000 N/A $4,464,203,000 $3,610,812,000 $142,984,000 $512,942,000 $43,619,000 $198,929,000 $378,646,000 $508,168,000 $200,253,000 $10.41 Copy of Gerdau_Ameristeel_student.xls Review View Tell me 2005 Vertical 2005 $414,732,000 $344,758,000 $745,165,000 $46,448,000 $1,551,103,000 $955,601,000 $322,747,000 $2,829,451,000 $435,051.000 $529,331,000 $281,050,000 $1,245,432,000 $1,584,019,000 304,276,512 $66,935,000 N/A $3,897,143,000 $3,253,865,000 $103,035,000 $400,505,000 $50,420,000 $144,687,000 $295,497,000 $578,456,000 $129,420.000 Horizontal - Co