Definition. This function calculates the sum of interest that accrues for a certain part of the year with a given annual interest rate and simple yield in arrears. Other time periods are possible, but not common.
For reasons of compatibility, this function was included in Lotus 1-2-3.
Rate (required) The annual interest rate in arrears that is to be distributed equally among all the periods in the year
Per (required) Specifies the number of the period (starting with zero) from the end of which the interest is to be calculated until the end of the year
Nper (required) The total amount of periods with the year; determines the factor for the annual interest rate
Pv (required) The present value (cash value) ...