Please use the Excel file provided to show the formulas needed to solve this problem.

EXCEL FILE (copy and paste into another tab/window):https://1drv.ms/x/s!AnWxTJTVVD_IfhCk5J4hUpMpBQg

Five customers would each like to get a car loan from First Animated National Bank. Based on the information given, analyze which customer will spend the most money (after all costs and interest). Using financial formulas learned in class, fill in any information missing. HINT: Assume each customer will make one (1) monthly payment throughout each year of their loan's term. Compute the missing information in Columns B through F Write a formula to calculate the total amount each customer will pay over the lifetime of the loan in Cell G3. Copy this formula through Cell G7. Write a formula to calculate the total amount of interest each customer will pay over the lifetime of the loan in Cell H3. Copy this formula through Cell G7. Five customers would each like to get a car loan from First Animated National Bank. Based on the information given, analyze which customer will spend the most money (after all costs and interest). Using financial formulas learned in class, fill in any information missing. HINT: Assume each customer will make one (1) monthly payment throughout each year of their loan's term. Compute the missing information in Columns B through F Write a formula to calculate the total amount each customer will pay over the lifetime of the loan in Cell G3. Copy this formula through Cell G7. Write a formula to calculate the total amount of interest each customer will pay over the lifetime of the loan in Cell H3. Copy this formula through Cell G7