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 ...
نظرات