1) Update Column F with the payment per month for each of these situations. (hint: use the PMT function to calculate the payments)

2) Update Column G with the total amount paid over the duration of the loan for each of these situations

3) Update Column H with the total interest paid over the duration of the loan for each of these situations What would be the exact function to use to figure these out?

What would be the exact function used to solve these?

\begin{tabular}{|l|l|l|r|r|r|r|} & \multicolumn{1}{|c|}{A} & \multicolumn{1}{c|}{B} & C & \multicolumn{1}{c|}{E} & G & F \\ \hline & Vacation Locatiol Vacation Duratiol Price & Interest Rate Loan Payment Time (in years) Payment Per Month & Total Amount Paid & Total Interest Paid \\ \hline 2 & Eastern Europe & 2 weeks & $2,000 & 5.5% & 1 \\ \hline 3 & Western Europe & 2 weeks & $3,000 & 6.0% & 1 \\ \hline 4 & Eastern Europe & 3 weeks & $3,500 & 5.5% & 2 \\ \hline 5 & Eastern Europe & 4 weeks & $4,000 & 6.0% & 2 \\ \hline 6 & Western Europe & 4 weeks & $5,000 & 6.5% & 2 \\ \hline \end{tabular}