excelRe: online calculator for Mortgage# Living
b*e
1 楼
go tp Excel, under "insert->function" choose "finance" on the left, then "PMT"
as payment on the right, you could also calculate FV as future value, those
are the basic concept if you take a finance 101 class...
the detailed concept behind the payment calcualtion is:
your present value @ month 0: 300K
interest for the 1st month: 300K * 5%/12
balance @ the end of month 1: 300K + 300K * 5%/12
your payment: PMT
your balance after you pay off the 1st payment due: (300K + 300K * 5%/12)-PMT
your prese
as payment on the right, you could also calculate FV as future value, those
are the basic concept if you take a finance 101 class...
the detailed concept behind the payment calcualtion is:
your present value @ month 0: 300K
interest for the 1st month: 300K * 5%/12
balance @ the end of month 1: 300K + 300K * 5%/12
your payment: PMT
your balance after you pay off the 1st payment due: (300K + 300K * 5%/12)-PMT
your prese
