Answer:
I recommend Bank A to Robin as its interest rate on loan is the lowest at 3.95%
Explanation:
In calculating the interest in excel spreadsheet, I used the rate formula which is given as =RATE (nper, pmt, pv, [fv], [type], [guess]) where nper is the duration loan,pmt is the yearly loan repayment,present value of the loan is $25000 in all cases while fv,type and guess are not applicable and as a result are shown as zeros.
Find attached for detailed analysis.