Hi,
i'm trying to make som calculations in excel, and im in need of help.

PV= -150.000
PMT= 6000 (paid 12 times a year)
I= 8% (p.a. but calculatet 4 times a year, so there are 2% each quarter)

Im interestet in a formula, that calculates how much interest i have to pay, and how long it would take me to pay the loan off.

Hope someone can help me

/shvid