What do the net present value, internal rate of return, and payback values from your base scenario and the sales variation scenarios above imply for the proposed investment? Be sure to explain how the time value of money affects your calculations and analysis. How do I calculate this based on my spreadsheet? Thank you.

Alteryx Inc. (NYSE:AYX) YEARS Revenue Net Revenue Cost of Goods Sold (COGS) Depreciation & Amortization FIN FINANCIAL HISTORY 2015 2016 2017 $38,000,000.00 $53,800,000.00 $85,800,000.00 $8,200,000.00 $9,800,000.00 $14,300,000.00 $345,000.00 $759,000.00 $1,700,000.00 $69,800,000.00 Profit Gross Profit $29,455,000.00 $43,241,000.00 Operating Expenses Total Operating Expenses $58,200,000.00 $74,900,000.00 $108,800,000.00 Operating Income Profit Margin -$28,745,000.00 -$31,659,000.00 -$39,000,000.00 77.51% 80.37% 81.35% Key Assumptions The yearly operating results and projections have fluctuated and possibly will fluctuate in the future. Also, due to limited opera performance. Therefore, the past performance may not be a good indicator ofr projected performance. Some Factors that may 1. Alteryx capability to produce noteworthy revenue from new products and services 2. Ability to increase and preserve customer base 3. The expansion and introduction of new products and services 4. Global and domestic economic conditions Conclusions The company has experienced swift growth over a small-time frame. Due to inadequate experience operating at present scale problematic for Alteryx to completely assess future forecasts and risk. The historical and future performance may not be telling ever-changing segment, it is imperative that Alteryx address their risk and uncertainties as it could adversely affect the busines FINANCIAL HISTORY AND PROJECTED PERFORMANCE FINANCIAL PROJECTIONS 2018 2019 2020 $117,374,400.00 $129,111,800.00 $153,643,089.00 $9,348,000.00 $10,780,000.00 $17,017,000.00 $379,500.00 $640,000.00 $1,500,200.00 $107,646,900.00 $117,691,800.00 $135,125,889.00 $129,700,000.00 $156,000,000.00 $153,640,000.00 -$22,053,100.00 -$38,308,200.00 -$18,514,111.00 91.71% 91.15% 87.95% he future. Also, due to limited operating historical data, it makes it difficult to forecast future performance. Some Factors that may influence results are as follows: xperience operating at present scale and possibly at a larger scale, consequently, it may be uture performance may not be telling of future performance. As a new and expanding company in an it could adversely affect the business. Alteryx Inc. (NYSE:AYX) YEARS Revenue FINA FINANCIAL HISTORY 2015 2016 2017 FINANCIAL PROJEC 2018 Net Revenue $38,000,000.00 $53,800,000.00 $85,800,000.00 $78,249,600.00 Cost of Goods Sold (COGS) $8,200,000.00 $9,800,000.00 $14,300,000.00 $9,348,000.00 $345,000.00 $759,000.00 $1,700,000.00 $379,500.00 $68,522,100.00 Depreciation & Amortization Profit Gross Profit $29,455,000.00 $43,241,000.00 $69,800,000.00 Operating Expenses Total Operating Expenses $58,200,000.00 $74,900,000.00 -$28,745,000.00 -$31,659,000.00 ### -$61,177,900.00 77.51% 80.37% 81.35% 87.57% Operating Income Profit Margin ### $129,700,000.00 Key Assumptions The yearly operating results and projections have fluctuated and possibly will fluctuate in the future. Also, due to limited op future performance. Therefore, the past performance may not be a good indicator ofr projected performance. Some Facto 1. Alteryx capability to produce noteworthy revenue from new products and services 2. Ability to increase and preserve customer base 3. The expansion and introduction of new products and services 4. Global and domestic economic conditions Conclusions The company has experienced swift growth over a small-time frame. Due to inadequate experience operating at present sc problematic for Alteryx to completely assess future forecasts and risk. The historical and future performance may not be te company in an ever-changing segment, it is imperative that Alteryx address their risk and uncertainties as it could adversely FINANCIAL HISTORY AND PROJECTED PERFORMANCE FINANCIAL PROJECTIONS 2019 2020 $86,074,600.00 $102,428,727.00 $10,780,000.00 $17,017,000.00 $640,000.00 $1,500,200.00 $74,654,600.00 $83,911,527.00 $156,000,000.00 $153,640,000.00 -$81,345,400.00 -$69,728,473.00 86.73% 81.92% future. Also, due to limited operating historical data, it makes it difficult to forecast ed performance. Some Factors that may influence results are as follows: rience operating at present scale and possibly at a larger scale, consequently, it may be re performance may not be telling of future performance. As a new and expanding ertainties as it could adversely affect the business