1. Get one company. 2. Find the Financial Statements from Yahoo Finance. (https://finance.yahoo.com/). 3. Copy and Paste Balance Sheet and Income Statement and Cash Flow in Excel sheet. 4. Calculate...

1 answer below »

1. Get one company.


2. Find the Financial Statements from Yahoo Finance. (https://finance.yahoo.com/).


3. Copy and Paste Balance Sheet and Income Statement and Cash Flow in Excel sheet.


4. Calculate Vertical and Horizontal Analysis. ( https://youtu.be/qYg0FjG5xng )( Income Statement and Balance Sheet)


5. Calculate the Liquidity Ratios



Answered Same DayApr 10, 2022

Answer To: 1. Get one company. 2. Find the Financial Statements from Yahoo Finance....

Nitish Lath answered on Apr 11 2022
93 Votes
Untitled Spreadsheet
Financial statements
    Facebook Inc (NMS: FB)
    General Company Information
    Principal Office    Website
    1601 Willow Road Menlo Park, CA 94025 USA    www.facebook.com
    Phone    Primary NAICS
    650 543-4800    541511 : Custom Computer Programming Services
    Auditor    Closing Stock Price
    Ernst & Young LLP    372.63 (as of 08/27/2021)
    Number of
Employees    Incorporated
    58,604 (Year End Average Staff as of 12/31/2020)    July 2004 , DE, United States
    Country    Mergent Dividend Achiever
    United States    No
    Exchange and Ticker    Number of Shareholders
    NMS : FB    3,471 (class A common record), 32 (class B common record) (as of 12/31/2020)
    Primary SIC
    7371 : Computer programming services
    Business Summary
    Facebook is building products that enable people to connect and share with friends and family through mobile devices, personal computers, virtual reality headsets, and in-home devices. Co.'s products include: Facebook, Instagram, Messenger, WhatsApp, and
    Facebook Reality Labs. Co. sells advertising placements to marketers. Co.'s ads enable marketers to reach people based on a variety of factors including age, gender, location, interests, and behaviors. Marketers purchase ads that can appear in several
    places including on Facebook, Instagram, Messenger, and third-party applications and websites.
    Company Financials
    Income Statement
    Exchange rate used is that of the Year End reported date
                        Vertical analysis                        Horizontal analysis
    As Reported Annual Income Statement
    Report Date    12/31/2020    12/31/2019    12/31/2018        12/31/2020        12/31/2019        12/31/2018        12/31/2020    12/31/2019
    Currency    USD    USD    USD        USD        USD        USD        USD    USD
    Audit Status    Not Qualified    Not Available    Not Qualified        Not Qualified        Not Available        Not Qualified        Not Qualified    Not Available
    Consolidated    Yes    Yes    Yes        Yes        Yes        Yes        Yes    Yes
    Scale    Thousands    Thousands    Thousands        Thousands        Thousands        Thousands        Thousands    Thousands
    Revenue    $ 85,965,000    $ 70,697,000    $ 55,838,000        100.00%        100.00%        100.00%        22%    27%
    Cost of revenue    $ 16,692,000    $ 12,770,000    $ 9,355,000        19.42%        18.06%        16.75%        31%    37%
    Payments & other fees    -    -    $ 825,000        NM        NM        1.48%
    Advertising    -    -    $ 55,013,000        NM        NM        98.52%
    Research & development    $ 18,447,000    $ 13,600,000    $ 10,273,000        21.46%        19.24%        18.40%        36%    32%
    Marketing & sales    $ 11,591,000    $ 9,876,000    $ 7,846,000        13.48%        13.97%        14.05%        17%    26%
    General & administrative    $ 6,564,000    $ 10,465,000    $ 3,451,000        7.64%        14.80%        6.18%        -37%    203%
    Total cost & expenses    $ 53,294,000    $ 46,711,000    $ 30,925,000        61.99%        66.07%        55.38%        14%    51%
    Income from operations    $ 32,671,000    $ 23,986,000    $ 24,913,000        38.01%        33.93%        44.62%        36%    -4%
    Interest income, net    $ 672,000    $ 924,000    $ 661,000        0.78%        1.31%        1.18%        -27%    40%
    Interest expense    -    $ 20,000    $ 9,000        NM        0.03%        0.02%            122%
    Foreign currency exchange gains (losses), net    $ -129,000    $ -105,000    $ -213,000        -0.15%        -0.15%        -0.38%        23%    -51%
    Other income (expense)    $ -34,000    $ 27,000    $ 9,000        -0.04%        0.04%        0.02%        -226%    200%
    Interest & other income (expense), net    $ 509,000    $ 826,000    $ 448,000        0.59%        1.17%        0.80%        -38%    84%
    Income (loss) before provision for income taxes - domestic    $ 24,233,000    $ 5,317,000    $ 8,800,000        28.19%        7.52%        15.76%        356%    -40%
    Income (loss) before provision for income taxes - foreign    $ 8,947,000    $ 19,495,000    $ 16,561,000        10.41%        27.58%        29.66%        -54%    18%
    Income before provision for income taxes    $ 33,180,000    $ 24,812,000    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here