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. 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.