nt) Need a helping to solve this problem (excel assignme

First Animated National Bank Customer Brown, Cleveland Cartman, Eric Griffin, Brian Simpson, Homer Smith, Stan Conclusion: APR 6.50% 7.25% 7.00% 6.50% Monthly Payment Years 4 $ 5 5 $ $ 5 $ Down Payment Car Value (426.87) $ 1,000.00 $ - $ (350.65) $ (280.45) $ 1,850.00 $ (785.65) $ 2,500.00 $ 7,500 19,709 18,530 44,900 Total Payback (all years) Total Interest Paid (all years) 1. Fill out the missing information in Column B to Column F 2. 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 Call G7. 3. Write a formula to calculate the total amount each customer will pay over the lifetime of the loan in Cell H3. Copy this formula through Cell G7 4.Format the values of highlighted cells in Columns B through F such that their number formatting matches other values in its repective column. 5. Format ALL NEGATIVE values in RED with parenthesis 6. Write a conclusion summarizing which customer will end up paying the most (in terms of amount of interest) above and beyonf the cost of their car. olumn F h customer will pay mula through Call h customer will pay mula through Cell B through F such in its repective hesis will end up paying d beyonf the cost of