Given the spreadsheet, how do I solve for (1) free cash flows (2)cumulative free cash flows (3) discounted free cash flows (4) cumulative discounted free cash flows and (5) NPV.

Thank you!

What is the formula for free cash flow and the formula for NPV?

Instructions: Please read the PDF file attached with the case study and extract whatever information you may need from there. Most of that information is already populated. You are required to fill in the highlighted cells. You do not need to write a separate report in this case. Everything needs to be done in this sheet. Cumulative Discounted Free Cash Flows These cells are not required, but if you can NPV Note: Your NPV and Payback calculations should be based on the Free Cash Flows and WACC. You cancluated these values above. Payback Analysis (when do cash flows sum positive?) Discounted Payback Analysis Recommendations: Based on your calculations of the NPV and Payback Periods analysis above, do you recommend Jane accepts this project? Please justify your answers. Note: NPV plays a key role in such decisions. Instructions: Please read the PDF file attached with the case study and extract whatever information you may need from there. Most of that information is already populated. You are required to fill in the highlighted cells. You do not need to write a separate report in this case. Everything needs to be done in this sheet. Cumulative Discounted Free Cash Flows These cells are not required, but if you can NPV Note: Your NPV and Payback calculations should be based on the Free Cash Flows and WACC. You cancluated these values above. Payback Analysis (when do cash flows sum positive?) Discounted Payback Analysis Recommendations: Based on your calculations of the NPV and Payback Periods analysis above, do you recommend Jane accepts this project? Please justify your answers. Note: NPV plays a key role in such decisions