I need help on number one. I struggle with the excell formulas. Thank you :)

Replicate the following loan analysis scenarios from Chapter 9 in our text book on an Excel Spreadsheet using financial formulas where applicable, and submit your work by the due date, Sunday 12/1: (15 Points Total) 1. Illustration 9-1 (5 Points) 2. Illustration 9-2/9-3 (using Excel)/9-4 (using Excel) (5 Points) 3. Illustration 9-10 Loan Amortization Schedule (5 Points) ASSIGNMENT SUBMISSION Replicate the following loan analysis scenarios from Chapter 9 in our text book on an Excel Spreadsheet using financial formulas where applicable, and submit your work by the due date, Sunday 12/1: (15 Points Total) 1. Illustration 9-1 (5 Points) 2. Illustration 9-2/9-3 (using Excel)/9-4 (using Excel) (5 Points) 3. Illustration 9-10 Loan Amortization Schedule (5 Points) ASSIGNMENT SUBMISSION