A1:t:Loan Amt:Loan Amt
A2:t:intest RT:intest RT
A3:t:Num Years:Num Years
A5:t:Payment:Payment
B1:n:100000:100000
B2:n:6.5:6.5
B3:n:30:30
B5:f:632.067497:B1*(C2*(1+C2)^C3)/((1+C2)^C3-1)
C2:f:0.00541666:B2/12/100
C3:f:360:b3*12
