2. Five customers would each like to get a car loan from 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. on the G23 A D E 1 2 First Landmark National Bank Customer APR Years 3 Monthly Payment Car Value Total Payback Total Interest (all years) Paid (all years) 4 Stewart Fuller 6.50% 4 $ (426.87) 5 Jim Johnson 7.25% 5 $ 7,500 6 Haley Trucker 7.00% 5 $ 19,709 7 Melody Rice 6.50% $ (280.45) $ 18,530 5 S (785.65) $ 39,500 HINT: Assume each customer will make one (1) monthly payment throughout each year of their loan's term. 3. Compute the missing information in Columns B through E (highlighted in light yellow). 4. Write 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. 5. Write 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. 6. Format the values of the highlighted cells in Columns B through G such that their number formatting matches other values in its respective column. 7. Format all dollar amounts as Accounting style. 8. Format APR in row 8 as percent with 2 decimal places. 9. Format ALL NEGATIVE values in RED with parenthesis. 10. Write a conclusion summarizing which customer will end up paying the most (in terms of amount of interest) above and beyond the cost of their car. 11. Bonus - Optional (5 points) - Solve for Cells E18 (2 pts), G18 (2 pts) and H18 (1 pt.). Partial credit for each part will be considered./ 8 Tom Battlefield 9 10 11 Conclusion: 12 13 14 15 16 Bonus Periods APR Years Monthly Payment Down Payment Car Value 17 18 12 4.99% 5 $ (525.00) $ 30,000.00 19 20 21 22 23 24 25 26 H Total Payback Total Interest (all years) Paid (all years)