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 company$$s 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 CNBC Links to an external site.. Remember, the ticker symbol for this Zoom is ZM$.$

Word Document

Using Word, make your own assumptions about how much Net Income and Net Investment will grow over the next five years and what they will grow in perpetuity. That is a total of $12$ assumptions $($one for each year and one for perpetuity for two items$).$ In your write up $$ explain the reasoning behind those choices, using your own ideas of how companies $($and universities, for that matter$)$ will use Zoom in the future.

Why do you think it's different? What does that say about your estimates compared to what the market is estimating will happen with Zoom.

Submission Instructions

Submit your well$-$formatted Excel worksheet, showing your discounted cash flow analysis.

Submit your Word Document justifying your assumptions and comparing your estimated value to the current market price.