Showing posts with label Produces an amortization table. Show all posts
Showing posts with label Produces an amortization table. Show all posts

Friday, September 13, 2019

Produces an amortization table

 WE CAN PLOT THE PERCENTAGE OF EACH PAYENT TOWARDS INTEREST VS PERIOD

amortization,amortization table,amortization schedule,what is amortization,loan amortization,mortgage amortization,amortization meaning,amortization explained,amortization definition,loan amortization schedule,amortisation,mortgage,amortization entries,amortization expense,amortization payments,amortization schedules,amortization for dummies,amortization accounting

#amort.table(Loan=NA,n=NA,pmt=NA,i,ic=1,pf=1,plot=FALSE)
#Loan=
> loan amount
> n= the number of payments/periods
"n=      the number"
> pmt=  value of level payments
"pmt=    Value of"
> i=  nominal interest rate convertible ic times per year
"i=      nominal interest"
> ic=  interest conversion frequency per year
"> pf=  the payment frequency- number of payments per year
> amort.table(Loan=1000,n=2,i=0.05,ic=1,pf=1)
$Schedule
  Payment Interest Paid Principal Paid Balance
1   537.8         50.00          487.8   512.2
2   537.8         25.61          512.2     0.0

$Other
               Details
Loan           1000.00
Total Paid     1075.61
Total Interest   75.61
Eff Rate          0.05

> amort.table(Loan=100,pmt=40,i=.04,ic=2,pf=2,plot=FALSE)
$Schedule
     Year Payment Interest Paid Principal Paid Balance
1     0.5   40.00          2.00          38.00   62.00
2     1.0   40.00          1.24          38.76   23.24
2.59  1.3   23.51          0.27          23.24    0.00

$Other
                   Details
Loan             100.00000
Total Paid       103.51000
Total Interest     3.51000
Balloon PMT       63.24000
Drop PMT          23.70480
Last Regular PMT  23.51322
Eff Rate           0.04040
i^(2)              0.04000

> amort.table(Loan=NA,pmt=102.77,n=10,i=.08,plot=TRUE)
$Schedule
   Payment Interest Paid Principal Paid Balance
1   102.77         55.17          47.60  641.99
2   102.77         51.36          51.41  590.58
3   102.77         47.25          55.52  535.06
4   102.77         42.80          59.97  475.09
5   102.77         38.01          64.76  410.33
6   102.77         32.83          69.94  340.39
7   102.77         27.23          75.54  264.85
8   102.77         21.19          81.58  183.27
9   102.77         14.66          88.11   95.16
10  102.77          7.61          95.16    0.00

$Other
                 Details
Loan            689.5951
Total Paid     1027.7000
Total Interest  338.1000
Eff Rate          0.0800
amortization,amortization table,amortization schedule,what is amortization,loan amortization,mortgage amortization,amortization meaning,amortization explained,amortization definition,loan amortization schedule,amortisation,mortgage,amortization entries,amortization expense,amortization payments,amortization schedules,amortization for dummies,amortization accounting

Black-Scholes formula-R

 Black-Scholes formula-R > BlackScholes <- function(TypeFlag = c("c", "p"), S, X, Time, r, b, sigma) { TypeFla...