Cheap Computer Books Best Computer Book

Excel provides two functions specifically for calculating accrued interest and principal payments on a loan: CUMIPMT, which calculates the cumulative interest payments of a bond or note and CUMPRINC, which calculates payments accumulated principal of a bond or note.

Some background on accrued interest and principal payments additional functions

Both functions use the same arguments, including the interest rate, duration) of the loan (number of periods or the grantingBalance (or present value), the start and end dates of the period for which to calculate the accrued interest or principal payments and will change one type of pension, to see if the stream of payments that occur as a pension pension or an annuity due.