=pmt(8%/12,10*12,0,-1000000)

Assuming interest is paid monthly