=A2/POWER(1+B2;C2)

Where in cells you can put numbers you like:

A2 is final amount (1 000 000)
B2 is rate (0,08)
C2 is number of months (120)

result is 97,5325 dolars per month.