I need to use Excel to perform a financial ratio analysis for two companies' (AMD and Intel) Income Statements, Balance Sheets, and Cash Flow Statements for the previous three years.

How do I Calculate the following ratios using the Income Statement and Balance Sheet: Return on Equity (Net Income/Total Shareholder Equity), Profit Margin (Net Income/Revenues), Total Asset Turnover (Revenues/Total Assets), and the Equity Multiplier (Total Assets/Shareholder Equity). Notice that Return on Equity is the same as the multiplication of the next three ratios.

Attached you will find an excel worksheet that includes AMD and Intels financial statements for the past 3 years.

Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares Income Statement (AMD) 12/31/2016 4,272,000 3,274,000 998,000 1,008,000 372,000 -10,000 -372,000 80,000 -292,000 156,000 -448,000 39,000 -497,000 -497,000 -497,000 D) 12/26/2015 3,991,000 2,911,000 1,080,000 12/27/2014 5,506,000 3,667,000 1,839,000 947,000 482,000 129,000 3,000 1,561,000 -481,000 1,072,000 604,000 304,000 14,000 1,994,000 -155,000 -5,000 -486,000 160,000 -646,000 14,000 -66,000 -221,000 177,000 -398,000 5,000 - -660,000 - -403,000 - -660,000 - -403,000 - -660,000 -403,000 Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charg Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets Balance Sheet (AMD) 12/31/2016 12/26/2015 1,264,000 12/27/2014 785,000 805,000 235,000 818,000 685,000 193,000 2,736,000 311,000 751,000 204,000 2,530,000 59,000 164,000 289,000 279,000 3,321,000 533,000 678,000 324,000 2,320,000 3,084,000 3,767,000 1,214,000 996,000 230,000 177,000 1,403,000 2,007,000 86,000 1,151,000 177,000 112,000 1,440,000 2,035,000 105,000 132,000 1,346,000 1,435,000 124,000 188,000 278,000 298,000 3,496,000 9,000 -7,803,000 -119,000 8,334,000 -5,000 416,000 127,000 344,000 - 2,905,000 302,000 320,000 65,000 3,580,000 - 8,000 -7,306,000 -123,000 7,017,000 -8,000 -412,000 -690,000 8,000 -6,646,000 -119,000 6,949,000 -5,000 187,000 -198,000 Cash Flow (AMD) Period Ending Net Income Operating Activities, Cash Flows Provided By or Used In Depreciation Adjustments To Net Income Changes In Accounts Receivables Changes In Liabilities Changes In Inventories Changes In Other Operating Activities Total Cash Flow From Operating Activities Investing Activities, Cash Flows Provided By or Used In Capital Expenditures Investments Other Cash flows from Investing Activities Total Cash Flows From Investing Activities Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Net Borrowings Other Cash Flows from Financing Activities Total Cash Flows From Financing Activities Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents 12/31/2016 -497,000 133,000 274,000 222,000 196,000 -73,000 -165,000 90,000 -77,000 342,000 2,000 267,000 687,000 -561,000 -4,000 122,000 479,000 12/26/2015 -660,000 12/27/2014 -403,000 167,000 154,000 280,000 -129,000 -11,000 -27,000 -226,000 203,000 393,000 7,000 -377,000 199,000 -120,000 -98,000 -96,000 235,000 8,000 147,000 -95,000 83,000 8,000 -12,000 - 5,000 56,000 -2,000 59,000 - 4,000 40,000 2,000 46,000 - -20,000 -64,000 Income Statement (Intel) 12/31/2016 59,387,000 23,196,000 36,191,000 Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 12,740,000 8,397,000 1,886,000 294,000 23,317,000 12,874,000 12/26/2015 55,355,000 20,676,000 34,679,000 12/27/2014 55,870,000 20,261,000 35,609,000 12,128,000 7,930,000 354,000 265,000 20,677,000 14,002,000 11,537,000 8,136,000 295,000 294,000 20,262,000 15,347,000 12,936,000 14,212,000 12,936,000 2,620,000 14,212,000 2,792,000 10,822,000 15,801,000 4,097,000 - 11,735,000 - 10,316,000 12,115,000 - 11,420,000 - 10,316,000 15,801,000 11,704,000 - 11,420,000 11,704,000 Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets Balance Sheet 12/31/2016 12/26/2015 5,560,000 11,539,000 4,690,000 5,553,000 8,166,000 35,508,000 10,896,000 36,171,000 14,099,000 9,494,000 15,308,000 10,005,000 4,787,000 5,167,000 3,053,000 38,320,000 7,851,000 31,858,000 11,332,000 3,933,000 - 7,159,000 - 8,165,000 - 113,327,000 101,459,000 12,030,000 4,634,000 3,638,000 20,302,000 20,649,000 3,538,000 1,730,000 10,768,000 2,634,000 2,244,000 15,646,000 20,036,000 2,841,000 954,000 - 46,219,000 39,477,000 882,000 - 897,000 - 25,373,000 40,747,000 - 23,411,000 37,614,000 - 106,000 66,226,000 42,633,000 60,000 61,085,000 45,820,000 12/27/2014 2,561,000 11,493,000 6,385,000 4,273,000 3,018,000 27,730,000 9,120,000 33,238,000 10,861,000 4,446,000 6,505,000 91,900,000 12,210,000 1,596,000 2,205,000 16,011,000 12,059,000 3,278,000 3,775,000 35,123,000 912,000 21,781,000 33,418,000 666,000 55,865,000 40,558,000 Cash Flow Period Ending Net Income Operating Activities, Cash Flows Provided By or Used In Depreciation Adjustments To Net Income Changes In Accounts Receivables Changes In Liabilities Changes In Inventories Changes In Other Operating Activities Total Cash Flow From Operating Activities Investing Activities, Cash Flows Provided By or Used In Capital Expenditures Investments Other Cash flows from Investing Activities Total Cash Flows From Investing Activities Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Net Borrowings Other Cash Flows from Financing Activities Total Cash Flows From Financing Activities Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents 12/31/2016 10,316,000 12/26/2015 11,420,000 7,790,000 3,034,000 65,000 -31,000 119,000 515,000 21,808,000 8,711,000 -33,000 -355,000 -637,000 -764,000 675,000 19,017,000 -9,625,000 -38,000 -16,154,000 -25,817,000 -7,326,000 -2,446,000 1,589,000 -8,183,000 -4,925,000 -1,479,000 1,219,000 -675,000 -5,739,000 -4,556,000 -1,810,000 9,002,000 -558,000 1,912,000 1,000 12,747,000 -9,748,000 12/27/2014 11,704,000 8,549,000 264,000 -861,000 -531,000 -98,000 1,391,000 20,418,000 -10,105,000 1,754,000 -1,554,000 -9,905,000 -4,409,000 -9,457,000 235,000 -427,000 -13,611,000 -15,000 -3,113,000