Finance Excel ASS: Ratios

1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for historical analysis. In all, your Excel file must include the following: o Three worksheets of annual balance sheet data o Three worksheets of annual income statement data o Three worksheets of annual statement of cash flow data Important Note: Be sure to label each worksheet in Excel with the appropriate year, as you did in the Module Three assignment.

2. Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data:

o Current ratio

o Debt/equity ratio

o Free cash flow

o Earnings per share

o Price/earnings ratio

o Return on equity

o Net profit margin

3. Written Responses Using the Write Submission area of Blackboard for this part of the assignment, respond to the following:

o Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why?

o Describe how three of the ratios you calculated for your company compare to the general industry. Find general industry data by entering your specific company?s ticker symbol here. If you are not familiar with the Write Submission feature, see the screen shot below.

4. Professionalism, References, and Mechanics Format the data on all worksheets so that the file has a neat and professional appearance. Include links and properly formatted citations referencing the location of the data used. Your written responses should be free of errors in organization, grammar, and style.

Guidelines for Submission: Submit an Excel file that meets the criteria described in the prompt. The written responses should be done in the Write Submission area of Blackboard. Citations should be formatted according to APA style.

-----

_{Facebook Inc. is my company for this HW.}

_{Please use Yahoo! Finance (required link) to get financial information needed. This is Part II of my assignment in Finance. I will attached here my Part I also.}

Facebook, Inc. Balance Sheet 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 4,907,000.00 13,527,000.00 2,559,000.00 659,000.00 21,652,000.00 5,687,000.00 18,026,000.00 3,246,000.00 796,000.00 - Total Assets 49,407,000.00 Liabilities 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 1,645,000.00 224,000.00 56,000.00 1,925,000.00 107,000.00 3,157,000.00 - Total Liabilities Stockholders' Equity Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock 5,189,000.00 - Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity 9,787,000.00 - 34,886,000.00 455,000.00 Total Stockholder Equity 44,218,000.00 Net Tangible Assets 22,946,000.00 Facebook, Inc. Income Statement Total Revenue Cost of Revenue 17,928,000.00 2,867,000.00 Gross Profit 15,061,000.00 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses 4,816,000.00 4,020,000.00 - 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 6,225,000.00 6,194,000.00 - - Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Sha 6,194,000.00 2,506,000.00 19,000.00 3,669,000.00 3,669,000.00 3,669,000.00 nc. ent Facebook, Inc. Cash Flow Net Income December 2014 to Sep 2015 2,925,000 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 1,243,000 1,536,000 -610,000 687,000 -339,000 5,457,000 -1,831,000 1,243,000 -5,325,000 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 -5,913,000 18,000 -243,000 -73,000 Total Cash Flows From Financing Activities Effect Of Exchange Rate Changes 1,571,000 Change In Cash and Cash Equivalents 992,000 -123,000 Inc. p 2015 1,491,000 32,000 1,011,000 1,035,000 649,000 1,409,000 -378,000 -170,000 841,000 213,000 134,000 - 4,222,000 1,612,000 1,504,000 8,000 939,000 -463,000 -1,362,000 -882,000 -380,000 -1,235,000 -4,874,000 -915,000 -2,624,000 -7,024,000 6,777,000 -1,891,000 1,335,000 -889,000 -2,862,000 -667,000 6,283,000 1,000 872,000 Stock Prices Date Adj Close Stock Price 29-Apr-16 28-Apr-16 27-Apr-16 26-Apr-16 22-Apr-16 21-Apr-16 20-Apr-16 117.58 116.73 108.89 108.76 110.1 110.56 113.44 Stock price's rate of return 9.790493653