Please solve using excel and show the excel functions used.

\begin{tabular}{|l|l} \hline 41 & \\ \hline 42 & Year \end{tabular} 43 Free cash flow calculation 44 Profit after tax 45 Add back depreciation 46 Subtract increase in current assets 47 Add back increase in current liabilities 48 Subtract increase in fixed assets at cost 49 Add back after-tax interest on debt 50 Subtract after-tax interest on cash \& mkt. securities 51 Free cash flow 52 53 54 Valuing the firm 55 Weighted average cost of capital 56 Long-term FCF growth (g) 57 58 Year 59 FCF 60 Terminal value 61 Total 62 63 NPV of row 61 64 Add in initial (year 0) cash and mkt. securities 65 Enterprise value 66 Subtract out value of firm's debt today 67 Equity value 68 69 Cash and marketable securities as negative debt 70 NPV of row 61 = enterprise value 71 Net year 0 debt 72 Equity value 73 74 75 Valuing the firm--using half-year discounting 76 Year 77 FCF 78 Terminal value 79 Total 80 81 NPV of row 81 82 Add in initial (year 0) cash and mkt. securities 83 Enterprise value 84 Subtract out value of firm's debt today 85 Equity value 86 87 88 89 Growth \begin{tabular}{|l|l} \hline 41 & \\ \hline 42 & Year \end{tabular} 43 Free cash flow calculation 44 Profit after tax 45 Add back depreciation 46 Subtract increase in current assets 47 Add back increase in current liabilities 48 Subtract increase in fixed assets at cost 49 Add back after-tax interest on debt 50 Subtract after-tax interest on cash \& mkt. securities 51 Free cash flow 52 53 54 Valuing the firm 55 Weighted average cost of capital 56 Long-term FCF growth (g) 57 58 Year 59 FCF 60 Terminal value 61 Total 62 63 NPV of row 61 64 Add in initial (year 0) cash and mkt. securities 65 Enterprise value 66 Subtract out value of firm's debt today 67 Equity value 68 69 Cash and marketable securities as negative debt 70 NPV of row 61 = enterprise value 71 Net year 0 debt 72 Equity value 73 74 75 Valuing the firm--using half-year discounting 76 Year 77 FCF 78 Terminal value 79 Total 80 81 NPV of row 81 82 Add in initial (year 0) cash and mkt. securities 83 Enterprise value 84 Subtract out value of firm's debt today 85 Equity value 86 87 88 89 Growth