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. )