Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2021-2020 statements 2020-2019 statements ratos that need to be fixed for both sets of years fix horizontal analysis year end amounts fix vertical analysis dollar
2021-2020 statements
2020-2019 statements
ratos that need to be fixed for both sets of years
fix horizontal analysis year end amounts
fix vertical analysis dollar amounts
All of the boxes highlighted in yellow should be fixed and the red wording describes what is wrong.
fill out these ratio's and analysis's
just fill in the yellow boxes with the correct information usimg the 2020 and 2021 financial statements as your resource
Assets Current assets Cash and cash equivalents Marketable securities Accounts receivable, net Prepaid expenses and other current assets Total current assets Equity investments Property and equipment, net Operating Intangible assets, net Goodwill Other assets Total assets lease right-of-use assets Liabilities and stockholders' equity Current liabilities Accounts payable Partners payable Operating lease liabilities, current Accrued expenses and other current liabilities Deferred revenue and deposits Total current liabilities Operating lease liabilities, non-current Other liabilities Total liabilities Commitments and contingencies Stockholders' equity common stock and additional paid-in capital Accumulated other comprehensive income (los) Retained earnings Total stockholders equity Total liabilities and stockholders' equity PLATFORMS, INC. CONDENSED CONSOLIDATED BALANCE SHEETS (in millions) (Unaudited) December 31, 2021 5 S 16,601 31397 14.039 4629 66,666 6,775 57.809 12:55 634 19.197 $ 165.987 4,003 Loca 1,327 14312 561 21,135 12745 7,227 41,108 56811 (693) 69,701 124879 MSORY December 31, 2020 S $ 17576 44378 11,335 2381 75,670 6,234 udago 45633 9348 623 19,050 2.75 150316 $0,019 927 1331 1,093 1,033 11,150 302 14081 9031 6414 31,000 Revenue Costs and expenses: Cost of revenue Research and development Marketing and sales General and administrative Total costs and expenses Income from operations Interest and other income, net income before provision for income taxes Provision for income taxes Net income Earnings per share attributable to Class A and Class B common stockholders: Basic Diluted Weighted average shares used to compute earnings per share attributable to Class A and Class B common stockholders: Basic Diluted Share-based compensation expense included in costs and expenses META PLATFORMS, INC. CONDENSED CONSOLIDATED STATEMENTS OF INCOME (in millions, except for per share amounts) (Unaudited) Cost of revenue. Research and development Marketing and sales General and administrative Total share-based compensation expense Three Months Ended December 31, 2021 5 S 5 S 33,671 0,348 7,046 4.387 3305 21086 12585 117 12,702 2,417 10,285 3.72 13.07 2765 3.799 1.49 1882 200 160 2400 2020 $ $ S 28,072 TH $ 5210 5208 3allo 1599 15297 12775 280 3255 1,936 11219 394 380 2.950 Spo Twelve Months Ended December 31, $ 2021 $ 5 117.919 22,649 24.655 14.043 9,829 71,176 46,753 53 47,284 7914 39,370 $ 13.99 5 13-77 2015 2059 577 7,105 837 644 164 S 2020 11TH $ $ S 85.965 16,692 18.447 15.591 6,564 53294 32,671 509 33.180 4034 29,146 10.22 10.09 2,851 2,888 447 4910 691 480 6536 Revenue Costs and expenses: Cost of revenue Research and development Marketing and sales General and administrative a Total costs and expenses Income from operations Interest and other income, net income before provision for income taxes Provision for income taxes Net income Earnings per share attributable to Class A and Class B common stockholders: Basic Diluted Weighted average shares used to compute earnings per share attributable to Class A and Class B common stockholders Basic Diluted Share-based compensation expense included in costs and expenses: Cost of revenue Research and development Marketing and sales General and administrative. Total share-based compensation expense FACEBOOK, INC. CONDENSED CONSOLIDATED STATEMENTS OF INCOME (in millions, except for per share amounts) (Unaudited) S S $ $ Three Months Ended December 31, 2020 28,072 5210 5208 3.280 1699 15.297 13.775 280 13.055 1.030 11,219 394 3.00 2,850 2000 120 1361 175 128 1704 $ $ 2019 21,082 3-492 3.877 3026 1,629 12.22 BBS 31% 8.169 820 7349 2853 190 10% (273 S S Twelve Months Ended December 31, 2020 85,965 16,692 18,447 11,591 6564 53.294 32,671 509 33.80 4.034 29,440 10:22 10.09 2008 447 Hupia DOI 450 0630 $ 2019 70,697 12,770 13,600 9.376 10.465 46,711 23,986 826 24,812 6.327 18.405 648 643 2.854 2,076 377 3460 569 Woz 4036 Assets Current assets Cash and cash equivalents Marketable securities Accounts receivable, net of allowances of $114 and 592 as of December 31, 2020 and 2019, respectively Prepaid expenses and other current assets Total current assets Equity investments Property and equipment, net Operating lease right-of-use assets, net Intangible assets, net Goodwill Other assets Total assets Liabilities and stockholders' equity Current liabilities Accounts payable Partners payable Operating lease liabilities, current Accrued expenses and other current liabilities Deferred revenue and deposits Total current liabilities Operating lease liabilities, non-current Other liabilities Total liabilities Commitments and contingencies Stockholders equity Common stock and additional paid in capital Accumulated other comprehensive income (los) Retained earnings CONDENSED CONSOLIDATED BALANCE SHEETS (in millions) (Unaudited) Total stockholders equity Total liabilities and stockholders' equity. $ 1$ December 31, 2020 17576 44-378 11,335 2,381 75,670 6,234 45.633 9348 023 19,050 2.758 50316 1331 2.03 6.414 2020 50.08 021 77345 08.200 50316 $ December 31, 2019 19,079 35-776 9,518 1,852 66,225 86 35-323 9,460 894 18,715 2,673 133376 1363 886 500 35735 200 15053 9524 7.745 32.322 45.051 (450) 55,692 101,054 $ 133376 Formula (in words): Accounts Receivable Turnover 12/31/2021 12/31/2020 Net Sales divided by average accounts receivable 117,929/14,039-8.40 85,965/11,335 7.58 Your formula in words is correct, but it appears you didn't use average accounts receivable. You will need to look at the 2020 annual report to find the 2019 balance for Accounts Receivable when calculating the 2020 turnover. Formula (in words): 12/31/2021 12/31/2020 Gross Margin Ratio Gross Margin(Net sales-Cost of goods sold) divided by Net Sales (46,753/117,929)*100=40% (32,671/85,965)*100=38% Your formula in words is correct and your Net Sales amount is correct for both years. However, maybe you didn't use the correct Cost of Goods Sold (it is called something slightly different on the financial statements). Also, your final answer needs to be extended to 2 decimal places. Return on Common Stockholders' Equity (Net income) divided by average common equity Formula (in words): 12/31/2021 12/31/2020 (39,370/124,879)*100=31,53% 29,146/128,290)*100=22.72% Your formula in words is correct, but it appears you didn't use average Stockholders' Equity. You will need to look at the 2020 annual report to find the 2019 balance. Current assets Property and equipment, net. Total assets Current abilities Total abilities Total stockholders' equity Horizontal Analysis 12/31/2020 12/31/2021 ASSETS 66,666 4,629 165,987 LIABILITIES: 561 41,108 75,670 124879 2.381 159,316 STOCKHOLDERS' EQUITY 382 31,026 128290 Dollar Change -9,004 2,240 6,671 179 10,082 -3411 Percent Change 0. -11.90 94.41 Your year-end amounts aren't correct which affect the change figures. 4.19 Horizontal and Vertical Analysis - You need to be careful when reporting dollar amounts. Do you think that Facebook only has $57,809 in property and equipment for the entire company? Look at the top of the financial statements. There you will see what the dollar amounts are expressed in. To make it accurate, you need to add zeros to every dollar amount on this sheet or type "all dollar amounts in" for each analysis. 46.86 Your year and amounts aren't correct which affect the change figures. 32.50 -2.658819861 The format of this row seems different than those above. The percentage needs to only report 2 decimal places. Tatal revenue Cost of revenue Research and development Income trom operations terest and other income, net come before income taxes Provision for income taxes i Net income Vertical Analysis 12/31/2021 117,929 71.176 22,649 46.753 531 47,284 7,914 39,370 12/31/2020 85,965 53,294 16,692 18,447 32,671 33,100 4,034 29,246 Common-Size Percentages 12/31/2021 100 60.35 10,21 39,65 0.45 40,10 6.71 33.38 12/31/2020 100 61.99 Dollar amounts are wrong which cause the percentages to also be off. 19.42 21.46 38.01 38.60 4.69 34.02 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started