Please look at my west wood project one teacher response we need


Question Description:

35

Please look at my west wood project one teacher response we need ratios’ to compare companies Royal Shell.xls Financial Statement Analysis Package (FSAP) A Comment on Entering Financial Statement Data: Analyst Name: Company Name: Year (Most recent in far right column.) BALANCE SHEET DATA Cash Marketable Securities Accounts Receivable – Trade Inventories Other Current Assets (1) Other Current Assets (2) CURRENT ASSETS Long Term Investments in Securities Property, Plant & Equipment – at cost Accumulated Depreciation Amortizable Intangible Assets (net) Goodwill and Nonamort. Intangibles Other Non-Current Assets (1) Other Non-Current Assets (2) TOTAL ASSETS Accounts Payable – Trade Notes Payable and Short Term Debt Current Maturities of Long Term Debt Other Current Liabilities (1) Other Current Liabilities (2) CURRENT LIABILITIES Long Term Debt Deferred Taxes Other Non-Current Liabilities (1) Other Non-Current Liabilities (2) TOTAL LIABILITIES Minority Interest in Subsidiaries Preferred Stock Common Stock + Paid in Capital Retained Earnings Accum. Other Comprehensive Income Other Equity Adjustments Treasury Stock SHAREHOLDERS’ EQUITY TOTAL LIABILITIES AND EQUITIES INCOME STATEMENT DATA Revenues Cost of Goods Sold Gross Profit Selling, General and Admin. Expense Other Operating Expenses (1) Other Operating Expenses (2) Other Operating Expenses (3) Other Operating Income Non-Recurring Operating Gains Non-Recurring Operating Losses Operating Profit Interest Income Interest Expense Other Income or Gains Unusual Income or Gains Other Expenses or Losses Unusual Expenses or Losses Income before Tax Income Tax Expense Minority Interest in Earnings Income from Discontinued Ops. Extraordinary Gains (Losses) Changes in Acctg. Principles NET INCOME (computed) Net Income (enter reported amount as a check) Other Comprehensive Income Items COMPREHENSIVE INCOME STATEMENT OF CASH FLOWS DATA NET INCOME Add back Depreciation and Amortization Exps. Other Addbacks to Net Income Other Subtractions from Net Income (Incr.) Decrease in Accts. Receivable – Trade (Incr.) Decrease in Inventories (Incr.) Decr. in Other Curr. Assets (1) (Incr.) Decr. in Other Curr. Assets (2) Incr. (Decr.) in Acct. Payable – Trade Incr. (Decr.) in Other Current Liabilities (1) Incr. (Decr.) in Other Current Liabilities (2) Incr. (Decr.) in Other Non-Current Liabs. (1) Incr. (Decr.) in Other Non-Current Liabs. (2) Other Operating Cash Flows NET CF FROM OPERATIONS Property, Plant, and Equipment Sold Property, Plant, and Equipment Acquired (Increase) Decrease in Marketable Securities Investments Sold Investments Acquired Other Investment Transactions (1) Other Investment Transactions (2) NET CF FROM INVESTING ACTIVITIES Increase in ST Borrowing Decrease in ST Borrowing Increase in LT Borrowing Decrease in LT Borrowing Issue of Capital Stock Share repurchases – Treasury Stock Dividend Payments Other Financing Transactions (1) Other Financing Transactions (2) NET CF FROM FINANCING ACTIVITIES Effects of exchange rate changes on cash NET CHANGE IN CASH SUPPLEMENTAL DATA Statutory Tax Rate Average Tax Rate After-tax Effects of Nonrecurring and Unusual Items on Net Income Preferred Stock Dividends (total, if any) Common Shares Outstanding Earnings per Share (basic) Common Dividends per Share Market Price per Share FINANCIAL DATA CHECKS Assets – Liabilities – Equities Net Income (computed) – Net Income (reported) Cash Changes Rich Westwood Royal Shell 2009 2010 2011 2012 2013 2014 9,719 13,444 11,292 18,550 9,696 21,607 59,328 27,410 0 0 96,457 31,175 131,619 70,102 29,348 79,509 28,976 65,403 30,781 63,638 30,009 58,470 19,701 112,894 33,414 142,705 119,777 37,990 152,081 114,734 38,350 172,293 103,343 99,778 191,897 192,472 5,356 5,039 4,521 4,470 3,874 23,700 292,181 67,161 7,978 0 9,189 461 84,789 30,862 13,838 10,509 14,048 154,046 1,704 0 527 127,633 3,809 24,699 322,560 76,550 17,569 5,492 25,396 345,257 81,846 14,741 4,867 25,611 360,32

Answer

35