b*******e
发帖数: 67 | 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 | s**********i
发帖数: 711 | 2 so complicated. why not just write
=pmt(0.05/12, 360, 300000)
in one cell...
【在 b*******e 的大作中提到】
: 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
|
|
