Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed
image text in transcribed
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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Society Research On Audit Practice And Regulations

Authors: Wally Smieliauskas, Minlei Ye, Ping Zhang

1st Edition

1138314129, 978-1138314122

More Books

Students also viewed these Accounting questions

Question

Briefly describe the difference between DAC and RBAC.

Answered: 1 week ago

Question

How to distinguish tangible asset and intangible asset?

Answered: 1 week ago

Question

LO 273 What factors aff ect a child during the mothers pregnancy?

Answered: 1 week ago