Please provide both answers and how to solve it in EXCEL FILE ONLY!

5. Suppose that you are comparing the following two payment plans. Since you are paying (not receiving) these amounts, the smaller, the better. In present value terms, which plan is better for you? Use 5% as a discount rate and use 1 year as discounting frequency. (That is, 5% is both an APR and an EAR.) \begin{tabular}{cccc} time of payment & payment amounts in: & present value of: \\ \cline { 2 - 4 } (in years, from & plan 2 & \\ \hline 0 & plan 1 & 0 \\ 1 & 1000000 & 800000 \\ 2 & 500000 & 800000 \\ 3 & 500000 & 800000 \end{tabular} in total Alternatively, you can use the "Goal Seek" function in Excel. It is in: [Data]-[What-If Analysis]-[Goal Seek]. n that Goal Seek, you can try to set the total present value of plan 2 equal to that of plan 1 (type in that number) by changing the number in "equal amount