Font Paragraph USING EXCEL 1. Calculate the total loan amount of each customer a
ID: 2820822 • Letter: F
Question
Font Paragraph USING EXCEL 1. Calculate the total loan amount of each customer and put each result in Total column 2. Count the loan type of customers 3. Sort the interest rate ascending 4. Calculate the total amount for the customer Ali after calculate the interest rate 5. Calculate the Customer ID "CO4" using formula Loans LoanlD Date Amount InterestRate Term Type CustomerID CustomerName 15|M 5|C |C04 |C04 1/15/1999|$475,000.00| 6.90%) | Ali 001 L004 014 031 032 L047 L049 LO52 LO53 L054 1/23/1999 $35,000.00 7.20% sc coa Ali 1/31/1999 $12,000.00 9.50% 1010-04 Ali 2/28/1999 $200,000.00 3/1/1999 $25,000.00 3/11/1999 $200,000.00| 3/21/1999 $150,000.00 3/22/1999 $100,000.00 3/31/1999 $15,000.00 7.00%) 10.00% 7.25% 7.50%) 7.00% 15 MC01 alc co2 15 Adams Mohammed Sara 3 15 MC01 Adams 30 MC01 Ada ms 8.00% 30|co 3 ara | 4/1/1999 $10,000.00| 8.00%) sice2 Mohammed!Explanation / Answer
LoanID Date Amount Interest rate Term type Customer ID Customer Name Total Loan Count loan type Interest reate in ascending order L001 1/15/1999 475000 7% 15 m c04 ali 522,000 3 7% L004 1/23/1999 35000 7% 5 c c04 ali 522,000 3 7% L014 1/31/1999 12000 10% 10 o c04 ali 522,000 3 7% L031 2/28/1999 200000 7% 15 m c01 adams 450,000 3 7% L032 3/1/1999 25000 10% 3 c c02 mohammad 35,000 2 7% L047 3/11/1999 200000 7% 15 m c03 sara 215,000 2 8% L049 3/21/1999 150000 8% 15 m c01 adams 450,000 3 8% L052 3/22/1999 100000 7% 30 m c01 adams 450,000 3 8% L053 3/31/1999 15000 8% 3 o c03 sara 215,000 2 10% L054 4/1/1999 10000 8% 5 c c02 mohammad 35,000 2 10%