Talk:Documentation/Calc Functions/CUMPRINC

SF Comments

(1) Summary. Replace with the following “Calculates the total capital repaid in specified payment periods for a loan with a constant interest rate.”.

(2) Returns. Replace with the following “Returns a negative real number (in currency units) which is the total capital repaid on the loan for the given arguments. Here the negative sign indicates the amount is a payment.”. We ought to state that the value returned is in the same currency units as the present value (PV). Also, worth saying that CUMPRINC formats the result as a currency if the cell has default formatting.

(3) Arguments, general. Please apply comments on CUMIPMT arguments to this section of the CUMPRINC page.

(4) Additional details. The following text from the Open Office page is useful and can be included – “With a fixed rate loan, where you make a constant payment each period to pay off the loan over the term, some of each period payment is interest on the outstanding capital, and some is a repayment of capital. Over time (as you pay off capital), the interest becomes less and the capital repayment becomes more. IPMT returns the interest in the payment of a specified period. PPMT returns the capital repaid in the payment of that period. Together they add up to the actual payment, given by PMT. CUMPRINC returns the total capital repaid in payments during the periods start to end inclusive - that is, the sum of PPMT over that time.”.

(5) Examples, 1st example. Unexpected character in Returns entry, after minus sign.

(6) Examples, 1st and 2nd examples. Change “payoff amounts” and “payoff amount” to “capital repaid”. Change “18th period” to “18th periods”.

--Stevefanning (talk) 2020-11-14T19:29:02 (UTC)