How much is it worth You are applying for a job as an equity analyst The company has given you an Excel spreadsheet Download Excel spreadsheet with some financial information about Zoom Knowing that demand for the companys only product exploded with the pandemic, the company wants to know what you think the stock price should be The company does not pay a dividend, so you are forced to use a Discounted Cash Flow Analysis to determine the value of the company Project Hints You can find all three items (net income, depreciation, and capital expenditures) on the cash flow statement Due to its business, appropriate capital expenditures include Purchase of property and equipment, Cash paid for acquisition, Purchases of strategic investments, and Purchases of intangible assets Note in finance, defining Capex, is often subjective Project Instructions In this Assignment, you will use the information given in the Excel document above to determine the company's value and create a write up explaining your thoughts Excel File Download the Excel file above Isolate Net Income, Depreciation, and Capital Expenditures (do not worry about changes in working capital) and calculate Cash Flow from these items ( hint Capital Expenditures Deprecation is net investment) Use a cost of capital of 10 to calculate the discounted cash flows Determine your estimated price per share value Compare your estimated price to the current price of the stock You can look it up at any financial website such as CNBCLinks to an external site Remember, the ticker symbol for this Zoom is ZM Zoom Video Communications Consolidated Statements of Operations Zoom Video Communications Consolidated Balance Sheets (in thousands, except share and per share data) 1 31 20221 31 2021 Assets Current assets Cash and cash equivalents 51,062,82052,240,303 Marketable securities $4,356,446$2,004,410 Accounts receivable 5419,673 $ 294,703 Deferred contract acqusition costs, current 5199,266 S 136,630 Prepaid expenses and other current assets Total current assets begin tabular rrrr 5 145,602 5 116,819 hline 6,183,807 54,792,865 end tabular Deferred contract acqusition costs, noncurrent $164,714$157,262 Property and equipment, net $222,354 S 149,924 Operating lease right of use begin tabular lrrrr asset $ 95,965 5 97,649 Strategic Investments $ 367,814 5 15,658 Goodwill S 27,607 S 24,340 Deferred tax assets S 382,296 S 1,519 Other assets, noncurrent $ 106,761 5 55,766 cline 2 6 Total Assets S 7,551,318 55,297,993 hline hline end tabular Liabilities Current liabilities Accounts payable 57,841$8,664 Accured expenses and other current liabilities $430,415$393,018 begin tabular lllll Deferred revenue, current $ 1,141,435 $ 858,284 cline 2 4 Total current liabilities $ 1,579,691 $1,259,966 end tabular Deferred revenue, noncurrent $38,481 S 25,211 Operating lease liabilities, noncurrent 585,018$50,415 Other liabilities, noncurrent $68,110561,634 Total liabilities 1,771,300$1,437,226 Shareholder's Equity Common Stock $299$292 Additional paid in capital $3,749,514$3,187,168 Accumulated other comprehensive income $ 17,902)5839 begin tabular lrrrr Retained earnings 5 2,048,107 5 672,468 cline 2 5 Total Stockholder's Equity 5,780,018 53,860,767 end tabular Total Liabilities and Stockholder's Equity 57,551,31855,297,993 Zoom video communications Consolidated statement of Cash Flows (in thousands, except share and per share data) 1 31 20221 31 20211 31 2020 Cash flows from operating activities cash provided by operating activities Stock based compensation expense 5477,287$275,818573,109 income tax benefit from release of valuation allowanceAmortizationofdefferedcontractacquaitioncostsGainsonstrategicinwestments,netDepreciationandamortization5555(327,957)$177,283(43,761)48,188$5104,306(2,538)28,657557,1015516,449 Cash flows from investing activities Purchases of marketable securities 5(4,434,749 $ 2,056,470)(800,228) Maturities of marketable securities 51,733,043$580,795$343,554 Sales of marketable securities 5296,867$36,6975 Purchases of property and equipment 5(132,590 $(79,972)(38,084) Purchases of strategic investments 5(305,149)$ 13,000)5(3,000) Cash Flows from financing activities Proceeds from issurance of common stock for employee stock purchase plan 559,331$38,433515,482 Proceeds from exercise of stock options, net of repurchases 514,404$28,55059,169 Proceeds from employee transactions to be remitted to employees and tax authorities $4(40,004)$4,063548,547 Proceeds from follow on public offering, net of underwriting discounts $$1,979,206$ Proceeds fromlPO, net of underwriting offering 5$542,492 Other Net cash provided by financing activities Net increase in cash Cash, beginning of year Cash, end of year begin tabular rrrrrr 5 337 $ 5 hline 5 34,068 $2,050,277 $ 615,690 hline 5 (1,219,763) $1,959,034 5 268,114 5 2,293,116 $ 334,062 5 65,968 hline 5 1,073,353 $2,293,116 5 334,082 hline end tabular begin tabular l hline 22 23 24 25 26 27 28 29 30 31 32 33 hline end tabular 3 (in thousands, encept share and pet share datal) 1 3112022 sesest Assets Current assets Eash and cash Deferred oontract 10) acquation oorts, current $1 199,2661136,630 Prepaid eipenses and II other ourrent assets 12 Total curent assets Deteried contract acquition costr 13 noncurtent $164,714$157,262 Propeity and equipenent, 14 net i $222,354$149,924 i4 Operating lease right of 21 Liabilities 23 Current liabities 24 Acoounts payable $1 7,841 48 664 Acoured expenses and 25 other ourentliablibes $430,4151393,018 Detertedrevense Deferred revemue, 28 noncurtent $38 481 25211 Operating lease 29 liabidkies, noncument 885 018 $ 90 415 Dther liabilies, 30) nonourter 168,110 61,634 31 Total liabilities 1771300 winsuse 32 Shareholder's Equity 34 CommonStock 3 s 299 ine 292 35 Additionalpaid in i, 3,749,514 stintwit Acournulsted othes 36) comprehensive income (17,902) s 839 (1) Petainedearning 36 Equity Total Liabilities and 69 Stookholder's Equity $7 751 3$8 ttntt Incomestatement Balance Shere Cash Flows Zoom Video Communications Consolidated Statement of Cash Flows (in thousands, except share and per share data) Cash flows from investing activities 39 Cash flows from financing activities Proceeds trom issurance of common 40 letock for emnlovee stock nurchase S 593315 38 4335482 Income Statement Balance Sheet Cash Flows 4 Ready EAccessibility Good to go Purchases of intangible assets Other Net Cash used in investing activities begin tabular r r r r rr hline 5 (13,018) 5 (5,843) 5 (141) hline 5 $ 1,659 5 (1,569) hline$ (2,859,097) 5 (1,562,420) 5 (499,468) hline end tabular 38 39 Cash Flows from financing activities Proceeds from issurance of common Proceeds from exercise of stock 41 options, net of repurchases Proceeds from employee transactions to be remitted to employees and tax 42 authorities (40,004)$4,088$$8,547 Proceeds from follow on public 43 offering, net of underwriting discounts $1,979,206$ Proceeds fromIPO, net of underwriting 44 offering 45 Other 46 Net cash provided by financing 47 Net increase in cash 48 Cash, beginning of year 49 Cash, end of year begin tabular rr r r rr hline$ $ $ 542,492 hline$ 337 $ $ hline$ 34,068 $ 2,050,277 5 615,690 hline$ (1,219,763) $ 1,959,034 5 268,114 hline$ 2,293,116 $ 334,082 5 65,968 hline$ 1,073,353 $ 2,293,116 $ 334,082 hline hline end tabular Zoom Video Communications Consolidated Statements of Operations Zoom Video Communications Consolidated Balance Sheets (in thousands, except share and per share data) 1 31 20221 31 2021 Assets Current assets Cash and cash equivalents 51,062,82052,240,303 Marketable securities $4,356,446$2,004,410 Accounts receivable 5419,673 $ 294,703 Deferred contract acqusition costs, current 5199,266 S 136,630 Prepaid expenses and other current assets Total current assets begin tabular rrrr 5 145,602 5 116,819 hline 6,183,807 54,792,865 end tabular Deferred contract acqusition costs, noncurrent $164,714$157,262 Property and equipment, net $222,354 S 149,924 Operating lease right of use begin tabular lrrrr asset $ 95,965 5 97,649 Strategic Investments $ 367,814 5 15,658 Goodwill S 27,607 S 24,340 Deferred tax assets S 382,296 S 1,519 Other assets, noncurrent $ 106,761 5 55,766 cline 2 6 Total Assets S 7,551,318 55,297,993 hline hline end tabular Liabilities Current liabilities Accounts payable 57,841$8,664 Accured expenses and other current liabilities $430,415$393,018 begin tabular lllll Deferred revenue, current $ 1,141,435 $ 858,284 cline 2 4 Total current liabilities $ 1,579,691 $1,259,966 end tabular Deferred revenue, noncurrent $38,481 S 25,211 Operating lease liabilities, noncurrent 585,018$50,415 Other liabilities, noncurrent $68,110561,634 Total liabilities 1,771,300$1,437,226 Shareholder's Equity Common Stock $299$292 Additional paid in capital $3,749,514$3,187,168 Accumulated other comprehensive income $ 17,902)5839 begin tabular lrrrr Retained earnings 5 2,048,107 5 672,468 cline 2 5 Total Stockholder's Equity 5,780,018 53,860,767 end tabular Total Liabilities and Stockholder's Equity 57,551,31855,297,993 Zoom video communications Consolidated statement of Cash Flows (in thousands, except share and per share data) 1 31 20221 31 20211 31 2020 Cash flows from operating activities cash provided by operating activities Stock based compensation expense 5477,287$275,818573,109 income tax benefit from release of valuation allowanceAmortizationofdefferedcontractacquaitioncostsGainsonstrategicinwestments,netDepreciationandamortization5555(327,957)$177,283(43,761)48,188$5104,306(2,538)28,657557,1015516,449 Cash flows from investing activities Purchases of marketable securities 5(4,434,749 $ 2,056,470)(800,228) Maturities of marketable securities 51,733,043$580,795$343,554 Sales of marketable securities 5296,867$36,6975 Purchases of property and equipment 5(132,590 $(79,972)(38,084) Purchases of strategic investments 5(305,149)$ 13,000)5(3,000) Cash Flows from financing activities Proceeds from issurance of common stock for employee stock purchase plan 559,331$38,433515,482 Proceeds from exercise of stock options, net of repurchases 514,404$28,55059,169 Proceeds from employee transactions to be remitted to employees and tax authorities $4(40,004)$4,063548,547 Proceeds from follow on public offering, net of underwriting discounts $$1,979,206$ Proceeds fromlPO, net of underwriting offering 5$542,492 Other Net cash provided by financing activities Net increase in cash Cash, beginning of year Cash, end of year begin tabular rrrrrr 5 337 $ 5 hline 5 34,068 $2,050,277 $ 615,690 hline 5 (1,219,763) $1,959,034 5 268,114 5 2,293,116 $ 334,062 5 65,968 hline 5 1,073,353 $2,293,116 5 334,082 hline end tabular begin tabular l hline 22 23 24 25 26 27 28 29 30 31 32 33 hline end tabular 3 (in thousands, encept share and pet share datal) 1 3112022 sesest Assets Current assets Eash and cash Deferred oontract 10) acquation oorts, current $1 199,2661136,630 Prepaid eipenses and II other ourrent assets 12 Total curent assets Deteried contract acquition costr 13 noncurtent $164,714$157,262 Propeity and equipenent, 14 net i $222,354$149,924 i4 Operating lease right of 21 Liabilities 23 Current liabities 24 Acoounts payable $1 7,841 48 664 Acoured expenses and 25 other ourentliablibes $430,4151393,018 Detertedrevense Deferred revemue, 28 noncurtent $38 481 25211 Operating lease 29 liabidkies, noncument 885 018 $ 90 415 Dther liabilies, 30) nonourter 168,110 61,634 31 Total liabilities 1771300 winsuse 32 Shareholder's Equity 34 CommonStock 3 s 299 ine 292 35 Additionalpaid in i, 3,749,514 stintwit Acournulsted othes 36) comprehensive income (17,902) s 839 (1) Petainedearning 36 Equity Total Liabilities and 69 Stookholder's Equity $7 751 3$8 ttntt Incomestatement Balance Shere Cash Flows Zoom Video Communications Consolidated Statement of Cash Flows (in thousands, except share and per share data) Cash flows from investing activities 39 Cash flows from financing activities Proceeds trom issurance of common 40 letock for emnlovee stock nurchase S 593315 38 4335482 Income Statement Balance Sheet Cash Flows 4 Ready EAccessibility Good to go Purchases of intangible assets Other Net Cash used in investing activities begin tabular r r r r rr hline 5 (13,018) 5 (5,843) 5 (141) hline 5 $ 1,659 5 (1,569) hline$ (2,859,097) 5 (1,562,420) 5 (499,468) hline end tabular 38 39 Cash Flows from financing activities Proceeds from issurance of common Proceeds from exercise of stock 41 options, net of repurchases Proceeds from employee transactions to be remitted to employees and tax 42 authorities (40,004)$4,088$$8,547 Proceeds from follow on public 43 offering, net of underwriting discounts $1,979,206$ Proceeds fromIPO, net of underwriting 44 offering 45 Other 46 Net cash provided by financing 47 Net increase in cash 48 Cash, beginning of year 49 Cash, end of year begin tabular rr r r rr hline$ $ $ 542,492 hline$ 337 $ $ hline$ 34,068 $ 2,050,277 5 615,690 hline$ (1,219,763) $ 1,959,034 5 268,114 hline$ 2,293,116 $ 334,082 5 65,968 hline$ 1,073,353 $ 2,293,116 $ 334,082 hline hline end tabular

Question

How much is it worth  You are applying for a job as an equity analyst  The company has given you an Excel spreadsheet Download Excel spreadsheet with some financial information about Zoom  Knowing that demand for the companys only product exploded with the pandemic, the company wants to know what you think the stock price should be  The company does not pay a dividend, so you are forced to use a Discounted Cash Flow Analysis to determine the value of the company  Project Hints You can find all three items (net income, depreciation, and capital expenditures) on the cash flow statement  Due to its business, appropriate capital expenditures include Purchase of property and equipment, Cash paid for acquisition, Purchases of strategic investments, and Purchases of intangible assets   Note  in finance, defining Capex, is often subjective  Project Instructions In this Assignment, you will use the information given in the Excel document above to determine the company's value and create a write up explaining your thoughts  Excel File Download the Excel file above  Isolate Net Income, Depreciation, and Capital Expenditures (do not worry about changes in working capital) and calculate Cash Flow from these items ( hint  Capital Expenditures Deprecation is net investment)  Use a cost of capital of 10  to calculate the discounted cash flows  Determine your estimated price per share value  Compare your estimated price to the current price of the stock  You can look it up at any financial website such as CNBCLinks to an external site  Remember, the ticker symbol for this Zoom is ZM  Zoom Video Communications Consolidated Statements of Operations Zoom Video Communications Consolidated Balance Sheets (in thousands, except share and per share data) 1 31 20221 31 2021 Assets Current assets Cash and cash equivalents 51,062,82052,240,303 Marketable securities $4,356,446$2,004,410 Accounts receivable 5419,673  $ 294,703 Deferred contract acqusition costs, current 5199,266 S 136,630 Prepaid expenses and other current assets Total current assets  begin tabular  rrrr  5   145,602   5   116,819     hline 6,183,807   54,792,865  end tabular  Deferred contract acqusition costs, noncurrent $164,714$157,262 Property and equipment, net $222,354 S 149,924 Operating lease right of use   begin tabular  lrrrr  asset   $   95,965   5   97,649    Strategic Investments   $   367,814   5   15,658    Goodwill   S   27,607   S   24,340    Deferred tax assets   S   382,296   S   1,519    Other assets, noncurrent   $   106,761   5   55,766     cline   2   6   Total Assets   S   7,551,318   55,297,993     hline  hline  end tabular  Liabilities Current liabilities Accounts payable 57,841$8,664 Accured expenses and other current liabilities $430,415$393,018  begin tabular  lllll  Deferred revenue, current   $   1,141,435   $   858,284     cline   2   4   Total current liabilities   $   1,579,691   $1,259,966  end tabular  Deferred revenue, noncurrent $38,481 S 25,211 Operating lease liabilities, noncurrent 585,018$50,415 Other liabilities, noncurrent $68,110561,634 Total liabilities    1,771,300$1,437,226 Shareholder's Equity Common Stock $299$292 Additional paid in capital $3,749,514$3,187,168 Accumulated other comprehensive income $ 17,902)5839  begin tabular  lrrrr  Retained earnings   5   2,048,107   5   672,468     cline   2   5   Total Stockholder's Equity   5,780,018   53,860,767  end tabular  Total Liabilities and Stockholder's Equity 57,551,31855,297,993 Zoom video communications Consolidated statement of Cash Flows (in thousands, except share and per share data) 1 31 20221 31 20211 31 2020 Cash flows from operating activities cash provided by operating activities Stock based compensation expense 5477,287$275,818573,109 income tax benefit from release of valuation  allowanceAmortizationofdefferedcontractacquaitioncostsGainsonstrategicinwestments,netDepreciationandamortization5555(327,957)$177,283(43,761)48,188$5104,306(2,538)28,657557,1015516,449 Cash flows from investing activities Purchases of marketable securities 5(4,434,749 $ 2,056,470)(800,228) Maturities of marketable securities 51,733,043$580,795$343,554 Sales of marketable securities 5296,867$36,6975 Purchases of property and equipment 5(132,590 $(79,972)(38,084) Purchases of strategic investments 5(305,149)$ 13,000)5(3,000) Cash Flows from financing activities Proceeds from issurance of common stock for employee stock purchase plan 559,331$38,433515,482 Proceeds from exercise of stock options, net of repurchases 514,404$28,55059,169 Proceeds from employee transactions to be remitted to employees and tax authorities $4(40,004)$4,063548,547 Proceeds from follow on public offering, net of underwriting discounts $$1,979,206$ Proceeds fromlPO, net of underwriting offering 5$542,492 Other Net cash provided by financing activities Net increase in cash Cash, beginning of year Cash, end of year  begin tabular  rrrrrr  5   337   $   5       hline 5   34,068   $2,050,277   $   615,690     hline 5   (1,219,763)   $1,959,034   5   268,114    5   2,293,116   $   334,062   5   65,968     hline 5   1,073,353   $2,293,116   5   334,082     hline  end tabular   begin tabular   l    hline 22    23    24    25    26    27    28    29    30    31    32    33     hline  end tabular  3  (in thousands, encept share and pet share datal) 1 3112022 sesest Assets Current assets Eash and cash Deferred oontract 10) acquation oorts, current  $1 199,2661136,630 Prepaid eipenses and II other ourrent assets 12 Total curent assets Deteried contract acquition costr  13 noncurtent $164,714$157,262 Propeity and equipenent, 14 net i $222,354$149,924 i4 Operating lease right of  21  Liabilities  23  Current liabities 24  Acoounts payable $1 7,841 48 664 Acoured expenses and 25 other ourentliablibes $430,4151393,018 Detertedrevense  Deferred revemue, 28 noncurtent $38 481    25211 Operating lease 29  liabidkies, noncument  885 018  $ 90 415 Dther liabilies, 30) nonourter 168,110 61,634 31 Total liabilities 1771300 winsuse 32 Shareholder's Equity 34 CommonStock 3 s 299 ine 292 35  Additionalpaid in i, 3,749,514 stintwit Acournulsted othes 36) comprehensive income    (17,902) s 839 (1) Petainedearning 36  Equity Total Liabilities and 69 Stookholder's Equity $7 751 3$8   ttntt  Incomestatement Balance Shere Cash Flows Zoom Video Communications Consolidated Statement of Cash Flows (in thousands, except share and per share data) Cash flows from investing activities 39 Cash flows from financing activities Proceeds trom issurance of common 40 letock for emnlovee stock nurchase S 593315 38 4335482 Income Statement Balance Sheet Cash Flows 4 Ready EAccessibility  Good to go Purchases of intangible assets Other Net Cash used in investing activities  begin tabular   r r r r rr    hline 5   (13,018)   5   (5,843)   5   (141)     hline 5     $   1,659   5   (1,569)     hline$   (2,859,097)   5   (1,562,420)   5   (499,468)     hline  end tabular  38 39 Cash Flows from financing activities Proceeds from issurance of common Proceeds from exercise of stock 41 options, net of repurchases Proceeds from employee transactions to be remitted to employees and tax 42 authorities (40,004)$4,088$$8,547 Proceeds from follow on public 43 offering, net of underwriting discounts $1,979,206$ Proceeds fromIPO, net of underwriting 44 offering 45 Other 46 Net cash provided by financing 47 Net increase in cash 48 Cash, beginning of year 49 Cash, end of year  begin tabular   rr r r rr    hline$     $     $   542,492     hline$   337   $     $       hline$   34,068   $   2,050,277   5   615,690     hline$   (1,219,763)   $   1,959,034   5   268,114     hline$   2,293,116   $   334,082   5   65,968     hline$   1,073,353   $   2,293,116   $   334,082     hline  hline  end tabular  Zoom Video Communications Consolidated Statements of Operations Zoom Video Communications Consolidated Balance Sheets (in thousands, except share and per share data) 1 31 20221 31 2021 Assets Current assets Cash and cash equivalents 51,062,82052,240,303 Marketable securities $4,356,446$2,004,410 Accounts receivable 5419,673  $ 294,703 Deferred contract acqusition costs, current 5199,266 S 136,630 Prepaid expenses and other current assets Total current assets  begin tabular  rrrr  5   145,602   5   116,819     hline 6,183,807   54,792,865  end tabular  Deferred contract acqusition costs, noncurrent $164,714$157,262 Property and equipment, net $222,354 S 149,924 Operating lease right of use   begin tabular  lrrrr  asset   $   95,965   5   97,649    Strategic Investments   $   367,814   5   15,658    Goodwill   S   27,607   S   24,340    Deferred tax assets   S   382,296   S   1,519    Other assets, noncurrent   $   106,761   5   55,766     cline   2   6   Total Assets   S   7,551,318   55,297,993     hline  hline  end tabular  Liabilities Current liabilities Accounts payable 57,841$8,664 Accured expenses and other current liabilities $430,415$393,018  begin tabular  lllll  Deferred revenue, current   $   1,141,435   $   858,284     cline   2   4   Total current liabilities   $   1,579,691   $1,259,966  end tabular  Deferred revenue, noncurrent $38,481 S 25,211 Operating lease liabilities, noncurrent 585,018$50,415 Other liabilities, noncurrent $68,110561,634 Total liabilities    1,771,300$1,437,226 Shareholder's Equity Common Stock $299$292 Additional paid in capital $3,749,514$3,187,168 Accumulated other comprehensive income $ 17,902)5839  begin tabular  lrrrr  Retained earnings   5   2,048,107   5   672,468     cline   2   5   Total Stockholder's Equity   5,780,018   53,860,767  end tabular  Total Liabilities and Stockholder's Equity 57,551,31855,297,993 Zoom video communications Consolidated statement of Cash Flows (in thousands, except share and per share data) 1 31 20221 31 20211 31 2020 Cash flows from operating activities cash provided by operating activities Stock based compensation expense 5477,287$275,818573,109 income tax benefit from release of valuation  allowanceAmortizationofdefferedcontractacquaitioncostsGainsonstrategicinwestments,netDepreciationandamortization5555(327,957)$177,283(43,761)48,188$5104,306(2,538)28,657557,1015516,449 Cash flows from investing activities Purchases of marketable securities 5(4,434,749 $ 2,056,470)(800,228) Maturities of marketable securities 51,733,043$580,795$343,554 Sales of marketable securities 5296,867$36,6975 Purchases of property and equipment 5(132,590 $(79,972)(38,084) Purchases of strategic investments 5(305,149)$ 13,000)5(3,000) Cash Flows from financing activities Proceeds from issurance of common stock for employee stock purchase plan 559,331$38,433515,482 Proceeds from exercise of stock options, net of repurchases 514,404$28,55059,169 Proceeds from employee transactions to be remitted to employees and tax authorities $4(40,004)$4,063548,547 Proceeds from follow on public offering, net of underwriting discounts $$1,979,206$ Proceeds fromlPO, net of underwriting offering 5$542,492 Other Net cash provided by financing activities Net increase in cash Cash, beginning of year Cash, end of year  begin tabular  rrrrrr  5   337   $   5       hline 5   34,068   $2,050,277   $   615,690     hline 5   (1,219,763)   $1,959,034   5   268,114    5   2,293,116   $   334,062   5   65,968     hline 5   1,073,353   $2,293,116   5   334,082     hline  end tabular   begin tabular   l    hline 22    23    24    25    26    27    28    29    30    31    32    33     hline  end tabular  3  (in thousands, encept share and pet share datal) 1 3112022 sesest Assets Current assets Eash and cash Deferred oontract 10) acquation oorts, current  $1 199,2661136,630 Prepaid eipenses and II other ourrent assets 12 Total curent assets Deteried contract acquition costr  13 noncurtent $164,714$157,262 Propeity and equipenent, 14 net i $222,354$149,924 i4 Operating lease right of  21  Liabilities  23  Current liabities 24  Acoounts payable $1 7,841 48 664 Acoured expenses and 25 other ourentliablibes $430,4151393,018 Detertedrevense  Deferred revemue, 28 noncurtent $38 481    25211 Operating lease 29  liabidkies, noncument  885 018  $ 90 415 Dther liabilies, 30) nonourter 168,110 61,634 31 Total liabilities 1771300 winsuse 32 Shareholder's Equity 34 CommonStock 3 s 299 ine 292 35  Additionalpaid in i, 3,749,514 stintwit Acournulsted othes 36) comprehensive income    (17,902) s 839 (1) Petainedearning 36  Equity Total Liabilities and 69 Stookholder's Equity $7 751 3$8   ttntt  Incomestatement Balance Shere Cash Flows Zoom Video Communications Consolidated Statement of Cash Flows (in thousands, except share and per share data) Cash flows from investing activities 39 Cash flows from financing activities Proceeds trom issurance of common 40 letock for emnlovee stock nurchase S 593315 38 4335482 Income Statement Balance Sheet Cash Flows 4 Ready EAccessibility  Good to go Purchases of intangible assets Other Net Cash used in investing activities  begin tabular   r r r r rr    hline 5   (13,018)   5   (5,843)   5   (141)     hline 5     $   1,659   5   (1,569)     hline$   (2,859,097)   5   (1,562,420)   5   (499,468)     hline  end tabular  38 39 Cash Flows from financing activities Proceeds from issurance of common Proceeds from exercise of stock 41 options, net of repurchases Proceeds from employee transactions to be remitted to employees and tax 42 authorities (40,004)$4,088$$8,547 Proceeds from follow on public 43 offering, net of underwriting discounts $1,979,206$ Proceeds fromIPO, net of underwriting 44 offering 45 Other 46 Net cash provided by financing 47 Net increase in cash 48 Cash, beginning of year 49 Cash, end of year  begin tabular   rr r r rr    hline$     $     $   542,492     hline$   337   $     $       hline$   34,068   $   2,050,277   5   615,690     hline$   (1,219,763)   $   1,959,034   5   268,114     hline$   2,293,116   $   334,082   5   65,968     hline$   1,073,353   $   2,293,116   $   334,082     hline  hline  end tabular

Accepted Answer

The Answer is in the image, click to view ...

Question

How much is it worth? You are applying for a job as an equity analyst. The company has given you an Excel spreadsheet Download Excel

Step by Step Solution

Step: 1

Get Instant Access with AI-Powered Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question