princ_month

Principal to be paid back at time n

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_month 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

Principal to be paid back at time n — princ_month

<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>

princ_month: Principal to be paid back at time n

Description

Usage

Value

Arguments

Examples