7 Click cell H13 4.000
Insert a PMT function to calculate the payments for students who want to pay for their trips in three installments( months). Use the interest rate and months in the input area above the data. Use appropriate relative, mixed, and / or absolute cell references in the formula. Make sure the result is a positive value.
Copy the function down through cell H22.
8 Click cell I13 4.000
Calculate the agent commission using the base cost of the trip and a VLOOKUP function that returns the commission rate based on the base cost of the trip using the rates lookup table. The function should then calculate the monetary value of the commission.
Copy the function down through cell I22.