princ_remn

Principal

excel

amortization

Loan

amortized

cumprinc

Provides similar functionality to 'Microsoft Excel' 'CUMPRINC' function <https://support.microsoft.com/en-us/office/cumprinc-function-94a4516d-bd65-41a1-bc16-053a6af4c04d>.
Returns principal remaining at a given month, principal paid in a month, and accumulated principal paid at a given month based on original loan amount,
monthly interest rate, and term of loan.

Jason Richardson

Functions Centered Around Microsoft Excel Cumprinc Function

princ_remn function

<dl><dt>s</dt>
<dd>original loan amount</dd>
<dt>r</dt>
<dd>interest rate. Divide by 100 if in a percent and again by 12 if yearly</dd>
<dt>t</dt>
<dd>loan term in months</dd>
<dt>n</dt>
<dd>month to return value for</dd></dl>

Arguments

Remaining principal at time n — princ_remn

<dl>

<dt>s</dt>
<dd>original loan amount</dd>


<dt>r</dt>
<dd>interest rate. Divide by 100 if in a percent and again by 12 if yearly</dd>


<dt>t</dt>
<dd>loan term in months</dd>


<dt>n</dt>
<dd>month to return value for</dd>

</dl>

Remaining principal at time n

princ_remn: Remaining principal at time n

Description

Usage

Value

Arguments

Examples