Provided by D Smith, Scriptco

Functions explained Here

Amt. Borrowed - 100,000.
Annual Compounded Rate - 5%; Loan Term - 30 Years
Note : the formula bar would show : =PMT(B3/12,B4*12,B2)
193,255. would be what you paid in 30 yrs.
If the loan was simple interest, you paid 150,000.
( i=prt ) So, 100,000. x .05 x 30
NOTE : The Rate is divided by 12 ( for mo'ly. interest )
NOTE : The Nper is multiplied by 12 ( 12 mos./yr. )