Please complete this question using the VBA console in Microsoft Excel.

Please show all code.

3) Write a Valuation function to value the cash flows and value the firm. This will not be a user-function. This will work very similarly to the in-class NPV function and it will return the value of the firm based on cash flows. Use this function to calculate firm value in your spreadsheet. The inputs are: WACC A Variant for all future cash flows Cash balance at 12/31/2018 (make this optional) Liquidity discount. (make this optional) a. b. c. d. 3) Write a Valuation function to value the cash flows and value the firm. This will not be a user-function. This will work very similarly to the in-class NPV function and it will return the value of the firm based on cash flows. Use this function to calculate firm value in your spreadsheet. The inputs are: WACC A Variant for all future cash flows Cash balance at 12/31/2018 (make this optional) Liquidity discount. (make this optional) a. b. c. d