1. Calculate the total loan amount of each customer and put each result in Total

Question

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 Amount InterestRate Term Type Customerlp CustomerName LoanlD Date 1/15/1999|$475,000.00| 1/23/1999 $35,000.00 1/31/1999 $12,000.00| 2/28/1999 $200,000.00| 6.90%) 7.20%| 9.50%) 7.00%) C04 5|clco4 |C04 lcol 15M Ali- L001 L004 014 | 100 15|M Adams 031 032 047 049 LO52 LO53 LO54 3/1/1999 $25,000.00 10.00% 3 C CO2 Mohammed 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.25% 7.50%) 7.00%) 8.00%| 8.00%) lco3 CO1 lcol |C03 SCCO2 Sara 15M 15 M 30,M 3|0 Adams Adams ara 4/1/1999 $10,000.00| Mohammed

Explanation / Answer

1. Total Loan Amount of each customer

2. Counting of loan type of customers

3 loan type of customers (M, C, O)

3. Intetest rate ascend

4. Total amount of Ali after calculating Interest RateA

5. Calculation of customer ID "C04"

Customer ID "C04" is Ali's ID and its count is 3.

Customer Name Total Loan Amount Ali ($ 475,000+$ 35,000+$ 12,000) $ 522,000 Adams ($ 200,000+$ 150,000+$ 100,000) $ 450,000 Mohammed ($ 25,000+$ 10,000) $ 35,000 Sara ($ 200,000+$ 15,000) $ 215,000

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.