Microsoft Excel - CUMIPMT Function
=CUMIPMT(rate, # of periods, present value, start period, end period, type)
This handy Excel function allows you to calculate the amount of interest you would pay on a loan during a certain time period. The time period would be indicated by payment number rather than a specific date range. For example if you had borrowed $10,000 @ 4.5% for 10 years and you wanted to know the total amount of interest you had paid in year 4 and 5 this can be done using the CUMIPMT() function.
=CUMIPMT(4%, 10, 10000, 4, 5, 0)
نظرات