Question

In: Accounting

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook....

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook. To complete the analysis, you will need to run the five most applicable liquidity ratios, the two most appropriate solvency measures, and the five most appropriate profitability measures. Include these in an excel document.

I was not given any financial information for facebook.

Expert Solution

Liquidity ratios

1. CURRENT RATIO =current asset / current liabilities

=50480/7017 = 7.19

Current ratio measures a company's ability to pay off its short term liabilities with its short term assets.

2. QUICK RATIO = (Total current assets - prepaid expenses- inventory) / current liabilities

=(50480-1779)/7017 =

= 6.94

Quick ratio measures a company's ability to pay off its short term liabilities with its quick assers. Here FACEBOOK has a high liquidity.

3. WORKING CAPITAL = Current asset - Current liabilities

=50480—7017

≠43,463

Working capital shows the short term current assets remaining after settling all short term liabilities or current obligations.

4. OPERATING CASH FLOW RATIO = operating cash flow / current liabilities

=income from opearting/ current liabilities

=24913/7017

=3.55

It shows how well current liabilities of the company covered by the company's operations

5. CASH RATIO = (cash +marketable securities) /current liabilities

=( 10019+31095)/7017

=41114/7017

=5.86

Solvency measures

1.DEBT/ASSET RATIO= Total liabilities / total asset

=13207/97334

=0.136

It shows percentage of assets funded with borrowings. FACEBOOK has only a low percentage funded with borrowings

2.EQUITY/ASSET RATIO = Total equity/ total assets

=84127\97334

=0.864

It shows how much of total asset are owned outright by the investors

Profitability Measures :

1.RETURN ON ASSET= Net income / average total asset

Average total asset = (total assets at end of the year 2018 +total assets at the end of the year 2018)/2

= (97334+84524)/2 = 90929

Return on asset = 22112/ 90929 = 0.24

It is a profitability ratio which shows how much earnings company can make from its assets

2.RETURN ON EQUITY = Net income / shareholder's equity

= 22112/84127 = 0.26

It measures how efficiently a company is handling the money that shareholders have contributed to it.

3.OPERATING PROFIT MARGIN= Operating earning / Revenue

=24913/55838

= 0.446

Operating profit margin ratio is used to calculate the percentage of profits a company produced from its opeartions.

4.NET PROFIT = (Net profit/ sales) * 100

=(22112/55838)*100. =39.60%

This ratio measures the overall profitability of company considering all direct as well as indirect cost.

5. RETURN ON CAPITAL EMPLOYED =( Net operating profit/ Capital employed) * 100

Capital employed = Total assets - current liabilities

= 97334-7017= 90317

Return on capital employed = (net operating profit / capital employed) * 100

= (24913/90317)*100

= 27.58%

This ratio computes percentage return in the company on the funds invested in the business by its owners. A high ratio represents better the company is.

NOTE:I have downloaded the Annual financial statements of FACEBOOK from their website.

screenshot is attached

ekkarill92 answered 1 year ago

Choose your favorite publicly-traded company other than Facebook that we did in class. Then, do the...

Choose your favorite publicly-traded company other than Facebook that we did in class. Then, do the following: 1) Calculate its beta using three-year historical prices 2) Calculate its re (cost of equity) 3) Calculate its rd (cost of debt) 4) Find out how much debt is has (see balance sheet and the notes that accompany it) 5) Calculate its market capitalization 6) Using the above information, calculate its WACC Please show all of your computations and submit the Excel file.

Select the financial statement of a publicly traded company. Analyze the various financing options the company...

Select the financial statement of a publicly traded company. Analyze the various financing options the company employed. What other options might you recommend? Why would you recommend them?

Complete a thorough financial analysis of Goldman Sachs, a publicly traded corporation. The project deliverables should...

Complete a thorough financial analysis of Goldman Sachs, a publicly traded corporation. The project deliverables should be a structured Word document and accompanying Excel spreadsheets. Requirements must include the following analysis: a. One page description of the Goldman Sachs: it’s products, markets, subsidiaries, risks b. Overall trend assessment of the company’s balance sheet and income statement for the last three to five years. c. Selected ratio trend analysis. The following ratio categories must be included, with three ratios (minimum) from...

Find the financial statements for a publicly traded company, and examine its statement of cash flows....

Find the financial statements for a publicly traded company, and examine its statement of cash flows. Prepare the cash ratios presented in the Module 7 Readings, and prepare an overview (300 words) of what is revealed about the company by its statement of cash flows and cash ratios.

For this week's Discussion, research one (1) publicly traded company in which you are interested using...

For this week's Discussion, research one (1) publicly traded company in which you are interested using the Internet and/or Strayer databases. Locate the company website and financial statements. Also locate information on the types of bonds the company issues. Review the Liabilities section of the company’s Balance Sheet. Be prepared to discuss. 1. Imagine that you just read about another company in the same industry facing criminal charges for misrepresenting their liabilities. Naturally, you’re worried that the company you’re researching...

I would like you do identify a publicly traded manufacturing company. BY publicly traded it means...

I would like you do identify a publicly traded manufacturing company. BY publicly traded it means they have stock traded on an exchange such as the New York Stock Exchange. I would then like you to research a product they manufacture. Based on what you have found would they use process costing or job order costing. Why did you select the method they did. Please be sure to integrate terms and concepts you learned about in week three and four...

Your assignment will be about a publicly traded company in UAE that you admire. Required :...

Your assignment will be about a publicly traded company in UAE that you admire. Required : 1. Write about at least 1 example that shows what you consider to be a good ethical decision this company has made in the past or is in the process of making/considering today. Make sure to tell why they made this decision (What prompted them to make it? What do they hope to achieve by making it? Etc). Also, make sure to tell why...

Using the Securities and Exchange Commissions’ website, select a publicly traded company and review their 10K...

Using the Securities and Exchange Commissions’ website, select a publicly traded company and review their 10K report for controls and procedures (Item 9 and Item 9A). Discuss your findings and share your thoughts on what the company has disclosed. EDGAR Company Filing: U.S. Securities and Exchange Commission. Retrieved from http://www.sec.gov/edgar/searchedgar/companysearch.html

To analyze the financial statements of a publicly traded company COMPANY IS BEST BUY Obtain an...

To analyze the financial statements of a publicly traded company COMPANY IS BEST BUY Obtain an annual report from a publicly traded corporation that is interesting to you. Be sure the company’s financial statements include deferred taxes, postretirement benefits, dilutive securities, and share-based compensation. What kind of share-based compensation does the company have? What was compensation expense for the two most recent years? What are the key elements of this plan discussed in the footnotes? Please identify and describe other...

Select a publicly traded company and a publicly traded, large partnership. Analyze how they are treated...

Select a publicly traded company and a publicly traded, large partnership. Analyze how they are treated for tax purposes. Describe the differences in taxation of their income, formation, dissolution, and liquidation, as well as the responsibilities borne towards creditors and taxing authorities by partners, shareholders, partnerships, and corporations. As a CPA in public practice, which type of business organization would you advise a client to adopt among sole proprietorships, various forms of partnerships, and various forms of corporations? MAKE A...