Use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company: Please show formulas. Calculate the value of the firm and the value of the equity in the firm using DFC analysis. Pretty lost as I have never done these calculations. If any detailed answer could be provided it be greatly appreciated. Thank you!

1. Use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company