Refer to the data sheet DCF from. Complete the calculations in the yellow shaded areas

Student instructions:Use the forecasting variables on the previous tab to complete the discounted free cash flow forecast and valuation shown below.Enter formulas in the blanks where indicated to complete the calculations needed.These initial incremental cash flows would require an initial $5,000,000 equipment investment and increase of $500,000 in Net Operating Working Capital.Salvage Value in the end would be $1,000,000 (don't forget to add this in the end and make tax adjustments).Discount rate is WACC in previous worksheet, but reinvestment rate is 10%.Find NPV, IRR, MIRR, and Discounted Payback.