\begin{tabular}{|c|c|} \hline Table, Excel, or calculator function: & PV of $1 \\ \hline Present Value: & \multirow{2}{*}{ a } \\ \hlinen= & \\ \hlinei= & \multirow{2}{*}{FVofanAnnuityDueFVofanOrdinaryAnnuityPVof$1} \\ \hline Future Value: & \\ \hline Will he be able to pay for the trip? & \multirow{2}{*}{ PV of an Annuity Due } \\ \hline & \\ \hline & PV of an Ordinary Annuity \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Table, Excel, or calculator function: & PV of $1 \\ \hline \multicolumn{2}{|l|}{ Present Value: } \\ \hlinen= & \\ \hlinei= & \multirow{4}{*}{FVof$1FVofanAnnuityDueFVofanOrdinaryAnnuityPVof$1} \\ \hline Future Value: & \\ \hline Will he be able to pay for the trip? & \\ \hline & \\ \hline \end{tabular} Brief Exercise 5-4 (Algo) Future value; single amount [LO5-2] Suppose a husband wants to take his wife on a trip three years from now to Europe to celebrate their 40th anniversary. He has just received a $23,000 inheritance from an uncle and intends to invest it for the trip. The husband estimates the trip will cost $27,500 and he believes he can earn 5% interest, compounded annually, on his investment. Complete the following table to calculate the future value. Will he be able to pay for the trip with the accumulated investment amount? Note: Use tables, Excel, or a financial calculator. Round your final answers to the nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and