| Title: | Functions Centered Around Microsoft Excel Cumprinc Function |
|---|---|
| Description: | 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. |
| Authors: | Jason Richardson [aut, cre]
|
| Maintainer: | Jason Richardson <[email protected]> |
| License: | GPL (>= 2) |
| Version: | 0.1 |
| Built: | 2026-05-20 08:38:16 UTC |
| Source: | https://github.com/cran/cumprinc |
Accumulated principal paid back at time n
princ_accum(s, r, t, n)princ_accum(s, r, t, n)
s |
original loan amount |
r |
interest rate. Divide by 100 if in a percent and again by 12 if yearly |
t |
loan term in months |
n |
month to return value for |
numeric value of accumulated paid principal
s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_accum( s, r, t, n)s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_accum( s, r, t, n)
Principal to be paid back at time n
princ_month(s, r, t, n)princ_month(s, r, t, n)
s |
original loan amount |
r |
interest rate. Divide by 100 if in a percent and again by 12 if yearly |
t |
loan term in months |
n |
month to return value for |
numeric value of principal paid in given month
s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_month( s, r, t, n)s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_month( s, r, t, n)
Remaining principal at time n
princ_remn(s, r, t, n)princ_remn(s, r, t, n)
s |
original loan amount |
r |
interest rate. Divide by 100 if in a percent and again by 12 if yearly |
t |
loan term in months |
n |
month to return value for |
numeric value of remaining principal
s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_remn( s, r, t, n)s <- 10000 r <- 5 / 100 / 12 t <- 60 n <- 5 princ_remn( s, r, t, n)