Calculator – Eat My Mortgage

Your borrowing
Untitled
Amount Borrowed*
Monthly income and expenses
Net Monthly Income*
Monthly Expenses*
Your current repayment
Mortgage Payments*
Payment frequency
Interest rate
Calculations
Interest rate per period
(({Interest rate:7}/100)/{Payment frequency:15})
X
=NPER(B6/12,B7,-B5,0) pmt * (1 + rate * type) + (-1 / rate) * fv (-{Mortgage Payments:9}*(1+{Interest rate per period:13})+(-1/{Interest rate per period:13}))
Y
pv * rate + pmt * (1 + rate * type) ({Amount Borrowed:1}*{Interest rate per period:13}) - ({Mortgage Payments:9} *(1+{Interest rate per period:13}))
Loan Term
in years
Repayment period / years
(100* Z / sqrt(1 + rate))) / payment frequency {Z:18} / {Payment frequency:15}

Your borrowing