[OC] House price you can afford by paying 1000/month for 30 years vs. interest rateSubmitted by hmiamid t3_xy7qym in dataisbeautiful
hmiamid OP t1_irgj20r wrote
Reply to comment by rainpizza in [OC] House price you can afford by paying 1000/month for 30 years vs. interest rate by hmiamid
Sure. Formula is (1-q^-N )/(q^(1/12)-1) where q is 1+r, r is the interest rate and N is the mortgage term in years. Make sure to put r without a percentage. So f.ex. for 5%, r = 0.05 and therefore q = 1.05. The 1/12 is because we pay every month.
Viewing a single comment thread. View all comments