Calculate and interpret the net present value (NPV) of the companies annual free cash flow (FCF) for a 5 year period (NPER) taking into account a constant growth rate (which will need to be calculated), and a discount rate that is equal to your companies weighted average cost of capital (WACC), which is 7%.

Please explain how this would be done and made on Excel I know excel has a NPER function but I am confused on what exactly we use inside the NPER function.

Here is the data I'm trying to use from a company to get the NPV for with a 5 year NPER

for the columns, left to right, its 2021-2017

$924.7 $2,884.9 $1,067.1 $4,518 $1,305.9 $-813.2 $492.7 ...! $141.2 $4,200.3 $1,524.1 $771.9 $2,296 $-43 $-49.8 $189.9 $-884.4 $3,594.6 $1,449.3 $-1,690.9 $-241.6 $-197.7 $-173 $31.9 $1,208.3 $-96.8 $131 $-41.2 $1,503.2 $1,821.8 $3,325 $-2.7 $-10.9 $-210.8 $-1,237.4 $-2,676.4 $1,597.8 $-1,483.6 $14 $391.6 $46.4 $750.4 $218 $-501.2 EEEE $6,286.3 $6,913.7 $11,937.8 $-1,976.4 $1,648.7 $5,047 $-1,806.6 $5,989.1 $89.7 $4,251.8 $-1,519.4 $-1,470 ... $1,175 $684.3 $-703.1 $85.4 Net Income/Loss Total Depreciation And Amortization - Cash Flow Other Non-Cash Items Total Non-Cash Items Change In Accounts Receivable Change In Inventories Change In Accounts Payable Change In Assets/Liabilities Total Change In Assets/Liabilities Cash Flow From Operating Activities Net Change In Property, Plant, And Equipment Net Change In Intangible Assets Net Acquisitions/Divestitures Net Change In Short-term Investments Net Change In Long-Term Investments Net Change In Investments - Total Investing Activities - Other Cash Flow From Investing Activities Net Long-Term Debt Net Current Debt Debt Issuance/Retirement Net - Total Net Common Equity Issued/Repurchased Net Total Equity Issued/Repurchased Total Common And Preferred Stock Dividends Paid Financial Activities - Other Cash Flow From Financial Activities Net Cash Flow Stock-Based Compensation Common Stock Dividends Paid $-183.5 $167.7 $312.4 E E $56.7 $56.7 $-183.5 $312.4 $167.7 $-56.2 $-81.2 $5.6 $529.7 $529.7 $54.3 $-850 $350.2 $-319.5 $-1,010.8 $1,646 $-2,361.5 $5,584.1 [alil $-1,250 $-431.2 $-1,681.2 $246.2 $350.2 EEEEEEEEEE $-44.4 $-1,711.5 $4,727.6 $438.9 $5,166.5 $-1,400.1 $-1,400.1 $-1,923.5 $-129.6 $1,713.3 $1,664.3 $246.2 $-2,119 $-97 $-3,651 $2,104.8 $319.1 . $1,646 $-9,812.5 $-9,812.5 $-1,761.3 $-129.1 $-10,056.9 $-6,069.7 $308 $5,584.1 $-6,979.6 $-6,979.6 $-1,743.4 $-103.9 $-3,242.8 $6,294 $250.3 $-1,891.7 $-1,891.7 $-1,450.4 $-87.2 $-3,079.1 $333.5 $248.6 $176 $-2,119 $-1,923.5 $-1,761.3 $-1,743.4 $-1,450.4