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,

2. Illustration 9-2/9-3 (using Excel)/9-4 (using Excel) (5 Points)

I/Y = 7.5 N= 20 PMT = 10,000 CPT PV PV=-$101,945 ILLUSTRATION 9-2 The Maximum Amount You Should Borrow PV = -$110,000 PMT = $10,000 N=20 CPT I/Y I/Y = 6.52% ILLUSTRATION 9-3 The Interest Rate to Negotiate