N D E F H Nelly Company borrowed 55,000 a 3-year, 4.00s installment loan, with MONTHLY payments. Note that we need to modify the interest rate for MONTHLY payments. RATE/12. 1. Enter 0; enter 1 below it 5.-15.15 then drag box in lower right corner dovarate/12 G14 2. Loan balance goes here. 6. 314 +[15 INTEREST PRINCIPAL EXPENSE REDUCTION PMT PERIOD o LOAN BAL 2. Enter formula: PMT(rate/12,36, loan-am 2 3 7. After instructions 3, 4, 5, and 6, SELECT CELLS D15, E15, F15, 015- and drag this corner down to G50- hope the loan balance ends at 50.00 + 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 23 34 35 36