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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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
|
|