Five customers would each like to get a car loan from Third Landmark National Bank. Based on the information given, analyze which customer will spend the most money (after all costs and interest). Using financial formulas, fill in any information missing.

1. Compute a formula to calculate the APR in Cell B8 for Justin Timbers.

2. Compute a formula to calculate the total amount each customer will pay over the lifetime of the loan in Cell F4. Copy this formula through Cell F8.

3. Compute a formula to calculate the total amount of interest each customer will pay over the lifetime of the loan in Cell G4. Copy this formula through Cell G8

4. Please also solve for Cells E18, G18 and H18.

Please show the excel formulas used. Thank you!!