AMORTSCHED
Updated 2023-10-10 14:24:37.143000
Syntax
SELECT * FROM [westclintech].[wct].[AMORTSCHED] (
<@PV, float,>
,<@LoanDate, datetime,>
,<@Rate, float,>
,<@FirstPayDate, datetime,>
,<@NumPmts, int,>
,<@Pmtpyr, int,>
,<@DaysInYr, int,>
,<@FV, float,>
,<@IntRule, nvarchar(4000),>)
Description
Use the table-valued function AMORTSCHED to generate an amortization schedule for a loan. The amortization schedule includes the payment number, the payment date, and the principal amount at the beginning of the period, the interest amount for the period, the principal payment for the period, any deferred interest for the period, and the ending principal amount.
AMORTSCHED supports loans with odd first periods, does US Rule or actuarial interest calculations, and allows you to specify a terminal (or future) value for the loan.
Arguments
@Pmtpyr
the number of loan payments made in a year. @Pmtpyr is an expression of type int or of a type that can be implicitly converted to int.
@FirstPayDate
the date that the first payment is due. @FirstPayDate is an expression of type datetime or of a type that can be implicitly converted to datetime.
@LoanDate
the date that the loan starts accruing interest. @LoanStartDate is an expression of type datetime or of a type that can be implicitly converted to datetime.
@Rate
the annual interest rate. @Rate is an expression of type float or of a type that can be implicitly converted to float.
@IntRule
Identifies the loan as conforming to the US Rule (“U”) or the actuarial rule (“A”) regarding the compounding of interest in the odd first period.
@NumPmts
the total number of payments to be recorded over the life of the loan. @NumPmts is an expression of type int or of a type that can be implicitly converted to int.
@FV
the future value at the end of the loan. @FV is an expression of type float or of a type that can be implicitly converted to float.
@DaysInYr
the denominator number of days to be used in the calculation of the interest amount in the odd first period. @DaysInYr is an expression of type int or of a type that can be implicitly converted to int.
@PV
the principal amount of the loan or lease. @PV is an expression of type float or of a type that can be implicitly converted to float.
Return Type
table
{"columns": [{"field": "colName", "headerName": "Name", "header": "name"}, {"field": "colDatatype", "headerName": "Type", "header": "type"}, {"field": "colDesc", "headerName": "Description", "header": "description", "minWidth": 1000}], "rows": [{"id": "59a485bd-bbea-4625-a74e-7f5ece28dcd6", "colName": "num_pmt", "colDatatype": "int", "colDesc": "The payment number."}, {"id": "fa660088-dbb9-4510-948f-0443428c2801", "colName": "date_pmt", "colDatatype": "datetime", "colDesc": "The date of the payment."}, {"id": "5cce1bdb-093b-46c0-98c7-0552d83e2d07", "colName": "amt_prin_init", "colDatatype": "float", "colDesc": "The principal amount at the beginning of the period. For the first period, the principal amount is the amount of the loan, otherwise the principal amount is the ending principal amount from the prior period."}, {"id": "1fd87b18-0ca3-4120-b3e6-5e569dda1db7", "colName": "amt_pmt", "colDatatype": "float", "colDesc": "The payment amount."}, {"id": "dc3085b5-219e-499d-a806-df5a98fb15f0", "colName": "amt_int_pay", "colDatatype": "float", "colDesc": "The interest payable amount for the period. The interest amount is the period interest rate (@Rate/@Pmtpyr) multiplied by the principal amount at the beginning of the period (amt_prin_init)."}, {"id": "16bb1165-3d59-44b2-ae55-466e9a7f5909", "colName": "amt_prin_pay", "colDatatype": "float", "colDesc": "The principal payment amount for the period. For actuarial accrual loans, the principal payment amount is the payment amount (amt_pmt) minus the interest payment amount (amt_int_pay). If the interest payment amount is greater than the payment amount, then the principal payment amount is negative. For US rule loans, the principal payment amount will always be greater than or equal to zero."}, {"id": "ba5953b0-93f8-447f-b641-a65a9b05862a", "colName": "amt_int_def", "colDatatype": "float", "colDesc": "The interest deferral (or escrow) amount. For US Rule loans only. If the interest payment amount (amt_int_pay) is greater than the payment amount (amt_pmt) then the difference is put into this column. When the interest payments (amt_int_pay) become less than the periodic payment (amt_pmt), the interest deferral amount (amt_int_def) from prior periods are reduced to zero, before applying any amounts to principal payments (amt_prin_pay)."}, {"id": "34101ecd-4937-4731-b200-378e4388e9eb", "colName": "amt_prin_end", "colDatatype": "float", "colDesc": "The ending principal amount. Calculated as the beginning principal amount (amt_prin_init) less the principal payment amount for the period (amt_prin_pay)."}]}
Remarks
If @DaysInYr is NULL, then @DaysInYr = 360.
If @FV is NULL, then @FV = 0.
If @IntRule is NULL, then @IntRule = “A”.
@FirstPayDate must be greater than @LoanDate.
@Pmtpyr must be 1, 2, 3, 4, 6, 12, 13, 24, 26, 52 or 365.
@NumPmts must be greater than 1.
@Rate must be greater than zero.
@DaysInYr must be 360, 364, 365, 365360 or 365365.
@PV must be greater than zero.
Examples
Generate the amortization schedule for a 50,000, 5-year loan starting on 1 November with payments due on the first of every month. The rate on the loan is 6 per cent.
SELECT *
FROM wct.AMORTSCHED( 50000, --Loan Amount
'11/01/2010', --Loan Start Date
.06, --Annual Interest Rate
'12/01/2010', --First Payment Date
60, --Number of payments (5*12)
12, --Number of payments per year
NULL, --Days in year (defaults to 360)
NULL, --FV (defaults to 0)
NULL --IntRule (defaults to 'A' meaning actuarial)
);
This produces the following results.
{"columns":[{"field":"num_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"date_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_init","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_def","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","date_pmt":"2010-11-01 00:00:00.000","amt_prin_init":"0","amt_pmt":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_int_def":"0","amt_prin_end":"50000"},{"num_pmt":"1","date_pmt":"2010-12-01 00:00:00.000","amt_prin_init":"50000","amt_pmt":"966.640076471413","amt_int_pay":"250","amt_prin_pay":"716.64007647142","amt_int_def":"0","amt_prin_end":"49283.3599235286"},{"num_pmt":"2","date_pmt":"2011-01-01 00:00:00.000","amt_prin_init":"49283.3599235286","amt_pmt":"966.640076471413","amt_int_pay":"246.416799617643","amt_prin_pay":"720.223276853729","amt_int_def":"0","amt_prin_end":"48563.1366466749"},{"num_pmt":"3","date_pmt":"2011-02-01 00:00:00.000","amt_prin_init":"48563.1366466749","amt_pmt":"966.640076471413","amt_int_pay":"242.815683233374","amt_prin_pay":"723.824393238043","amt_int_def":"0","amt_prin_end":"47839.3122534368"},{"num_pmt":"4","date_pmt":"2011-03-01 00:00:00.000","amt_prin_init":"47839.3122534368","amt_pmt":"966.640076471413","amt_int_pay":"239.196561267184","amt_prin_pay":"727.443515204221","amt_int_def":"0","amt_prin_end":"47111.8687382326"},{"num_pmt":"5","date_pmt":"2011-04-01 00:00:00.000","amt_prin_init":"47111.8687382326","amt_pmt":"966.640076471413","amt_int_pay":"235.559343691163","amt_prin_pay":"731.080732780232","amt_int_def":"0","amt_prin_end":"46380.7880054524"},{"num_pmt":"6","date_pmt":"2011-05-01 00:00:00.000","amt_prin_init":"46380.7880054524","amt_pmt":"966.640076471413","amt_int_pay":"231.903940027262","amt_prin_pay":"734.736136444139","amt_int_def":"0","amt_prin_end":"45646.0518690082"},{"num_pmt":"7","date_pmt":"2011-06-01 00:00:00.000","amt_prin_init":"45646.0518690082","amt_pmt":"966.640076471413","amt_int_pay":"228.230259345041","amt_prin_pay":"738.409817126332","amt_int_def":"0","amt_prin_end":"44907.6420518819"},{"num_pmt":"8","date_pmt":"2011-07-01 00:00:00.000","amt_prin_init":"44907.6420518819","amt_pmt":"966.640076471413","amt_int_pay":"224.538210259409","amt_prin_pay":"742.101866212011","amt_int_def":"0","amt_prin_end":"44165.5401856699"},{"num_pmt":"9","date_pmt":"2011-08-01 00:00:00.000","amt_prin_init":"44165.5401856699","amt_pmt":"966.640076471413","amt_int_pay":"220.827700928349","amt_prin_pay":"745.812375543035","amt_int_def":"0","amt_prin_end":"43419.7278101268"},{"num_pmt":"10","date_pmt":"2011-09-01 00:00:00.000","amt_prin_init":"43419.7278101268","amt_pmt":"966.640076471413","amt_int_pay":"217.098639050634","amt_prin_pay":"749.541437420761","amt_int_def":"0","amt_prin_end":"42670.1863727061"},{"num_pmt":"11","date_pmt":"2011-10-01 00:00:00.000","amt_prin_init":"42670.1863727061","amt_pmt":"966.640076471413","amt_int_pay":"213.35093186353","amt_prin_pay":"753.289144607879","amt_int_def":"0","amt_prin_end":"41916.8972280982"},{"num_pmt":"12","date_pmt":"2011-11-01 00:00:00.000","amt_prin_init":"41916.8972280982","amt_pmt":"966.640076471413","amt_int_pay":"209.584486140491","amt_prin_pay":"757.055590330892","amt_int_def":"0","amt_prin_end":"41159.8416377673"},{"num_pmt":"13","date_pmt":"2011-12-01 00:00:00.000","amt_prin_init":"41159.8416377673","amt_pmt":"966.640076471413","amt_int_pay":"205.799208188837","amt_prin_pay":"760.840868282568","amt_int_def":"0","amt_prin_end":"40399.0007694847"},{"num_pmt":"14","date_pmt":"2012-01-01 00:00:00.000","amt_prin_init":"40399.0007694847","amt_pmt":"966.640076471413","amt_int_pay":"201.995003847424","amt_prin_pay":"764.645072623964","amt_int_def":"0","amt_prin_end":"39634.3556968608"},{"num_pmt":"15","date_pmt":"2012-02-01 00:00:00.000","amt_prin_init":"39634.3556968608","amt_pmt":"966.640076471413","amt_int_pay":"198.171778484304","amt_prin_pay":"768.468297987092","amt_int_def":"0","amt_prin_end":"38865.8873988737"},{"num_pmt":"16","date_pmt":"2012-03-01 00:00:00.000","amt_prin_init":"38865.8873988737","amt_pmt":"966.640076471413","amt_int_pay":"194.329436994368","amt_prin_pay":"772.310639477037","amt_int_def":"0","amt_prin_end":"38093.5767593966"},{"num_pmt":"17","date_pmt":"2012-04-01 00:00:00.000","amt_prin_init":"38093.5767593966","amt_pmt":"966.640076471413","amt_int_pay":"190.467883796983","amt_prin_pay":"776.172192674429","amt_int_def":"0","amt_prin_end":"37317.4045667222"},{"num_pmt":"18","date_pmt":"2012-05-01 00:00:00.000","amt_prin_init":"37317.4045667222","amt_pmt":"966.640076471413","amt_int_pay":"186.587022833611","amt_prin_pay":"780.053053637763","amt_int_def":"0","amt_prin_end":"36537.3515130845"},{"num_pmt":"19","date_pmt":"2012-06-01 00:00:00.000","amt_prin_init":"36537.3515130845","amt_pmt":"966.640076471413","amt_int_pay":"182.686757565422","amt_prin_pay":"783.95331890598","amt_int_def":"0","amt_prin_end":"35753.3981941785"},{"num_pmt":"20","date_pmt":"2012-07-01 00:00:00.000","amt_prin_init":"35753.3981941785","amt_pmt":"966.640076471413","amt_int_pay":"178.766990970892","amt_prin_pay":"787.873085500498","amt_int_def":"0","amt_prin_end":"34965.525108678"},{"num_pmt":"21","date_pmt":"2012-08-01 00:00:00.000","amt_prin_init":"34965.525108678","amt_pmt":"966.640076471413","amt_int_pay":"174.82762554339","amt_prin_pay":"791.812450928017","amt_int_def":"0","amt_prin_end":"34173.71265775"},{"num_pmt":"22","date_pmt":"2012-09-01 00:00:00.000","amt_prin_init":"34173.71265775","amt_pmt":"966.640076471413","amt_int_pay":"170.86856328875","amt_prin_pay":"795.771513182634","amt_int_def":"0","amt_prin_end":"33377.9411445673"},{"num_pmt":"23","date_pmt":"2012-10-01 00:00:00.000","amt_prin_init":"33377.9411445673","amt_pmt":"966.640076471413","amt_int_pay":"166.889705722837","amt_prin_pay":"799.75037074857","amt_int_def":"0","amt_prin_end":"32578.1907738188"},{"num_pmt":"24","date_pmt":"2012-11-01 00:00:00.000","amt_prin_init":"32578.1907738188","amt_pmt":"966.640076471413","amt_int_pay":"162.890953869094","amt_prin_pay":"803.749122602308","amt_int_def":"0","amt_prin_end":"31774.4416512164"},{"num_pmt":"25","date_pmt":"2012-12-01 00:00:00.000","amt_prin_init":"31774.4416512164","amt_pmt":"966.640076471413","amt_int_pay":"158.872208256082","amt_prin_pay":"807.767868215313","amt_int_def":"0","amt_prin_end":"30966.6737830011"},{"num_pmt":"26","date_pmt":"2013-01-01 00:00:00.000","amt_prin_init":"30966.6737830011","amt_pmt":"966.640076471413","amt_int_pay":"154.833368915006","amt_prin_pay":"811.806707556399","amt_int_def":"0","amt_prin_end":"30154.8670754447"},{"num_pmt":"27","date_pmt":"2013-02-01 00:00:00.000","amt_prin_init":"30154.8670754447","amt_pmt":"966.640076471413","amt_int_pay":"150.774335377224","amt_prin_pay":"815.865741094167","amt_int_def":"0","amt_prin_end":"29339.0013343506"},{"num_pmt":"28","date_pmt":"2013-03-01 00:00:00.000","amt_prin_init":"29339.0013343506","amt_pmt":"966.640076471413","amt_int_pay":"146.695006671753","amt_prin_pay":"819.945069799629","amt_int_def":"0","amt_prin_end":"28519.0562645509"},{"num_pmt":"29","date_pmt":"2013-04-01 00:00:00.000","amt_prin_init":"28519.0562645509","amt_pmt":"966.640076471413","amt_int_pay":"142.595281322755","amt_prin_pay":"824.044795148642","amt_int_def":"0","amt_prin_end":"27695.0114694023"},{"num_pmt":"30","date_pmt":"2013-05-01 00:00:00.000","amt_prin_init":"27695.0114694023","amt_pmt":"966.640076471413","amt_int_pay":"138.475057347011","amt_prin_pay":"828.165019124386","amt_int_def":"0","amt_prin_end":"26866.8464502779"},{"num_pmt":"31","date_pmt":"2013-06-01 00:00:00.000","amt_prin_init":"26866.8464502779","amt_pmt":"966.640076471413","amt_int_pay":"134.33423225139","amt_prin_pay":"832.305844220002","amt_int_def":"0","amt_prin_end":"26034.5406060579"},{"num_pmt":"32","date_pmt":"2013-07-01 00:00:00.000","amt_prin_init":"26034.5406060579","amt_pmt":"966.640076471413","amt_int_pay":"130.17270303029","amt_prin_pay":"836.467373441126","amt_int_def":"0","amt_prin_end":"25198.0732326168"},{"num_pmt":"33","date_pmt":"2013-08-01 00:00:00.000","amt_prin_init":"25198.0732326168","amt_pmt":"966.640076471413","amt_int_pay":"125.990366163084","amt_prin_pay":"840.649710308295","amt_int_def":"0","amt_prin_end":"24357.4235223085"},{"num_pmt":"34","date_pmt":"2013-09-01 00:00:00.000","amt_prin_init":"24357.4235223085","amt_pmt":"966.640076471413","amt_int_pay":"121.787117611542","amt_prin_pay":"844.852958859843","amt_int_def":"0","amt_prin_end":"23512.5705634486"},{"num_pmt":"35","date_pmt":"2013-10-01 00:00:00.000","amt_prin_init":"23512.5705634486","amt_pmt":"966.640076471413","amt_int_pay":"117.562852817243","amt_prin_pay":"849.077223654182","amt_int_def":"0","amt_prin_end":"22663.4933397945"},{"num_pmt":"36","date_pmt":"2013-11-01 00:00:00.000","amt_prin_init":"22663.4933397945","amt_pmt":"966.640076471413","amt_int_pay":"113.317466698972","amt_prin_pay":"853.322609772407","amt_int_def":"0","amt_prin_end":"21810.1707300221"},{"num_pmt":"37","date_pmt":"2013-12-01 00:00:00.000","amt_prin_init":"21810.1707300221","amt_pmt":"966.640076471413","amt_int_pay":"109.05085365011","amt_prin_pay":"857.589222821283","amt_int_def":"0","amt_prin_end":"20952.5815072008"},{"num_pmt":"38","date_pmt":"2014-01-01 00:00:00.000","amt_prin_init":"20952.5815072008","amt_pmt":"966.640076471413","amt_int_pay":"104.762907536004","amt_prin_pay":"861.877168935407","amt_int_def":"0","amt_prin_end":"20090.7043382654"},{"num_pmt":"39","date_pmt":"2014-02-01 00:00:00.000","amt_prin_init":"20090.7043382654","amt_pmt":"966.640076471413","amt_int_pay":"100.453521691327","amt_prin_pay":"866.186554780055","amt_int_def":"0","amt_prin_end":"19224.5177834853"},{"num_pmt":"40","date_pmt":"2014-03-01 00:00:00.000","amt_prin_init":"19224.5177834853","amt_pmt":"966.640076471413","amt_int_pay":"96.1225889174266","amt_prin_pay":"870.517487553978","amt_int_def":"0","amt_prin_end":"18354.0002959313"},{"num_pmt":"41","date_pmt":"2014-04-01 00:00:00.000","amt_prin_init":"18354.0002959313","amt_pmt":"966.640076471413","amt_int_pay":"91.7700014796567","amt_prin_pay":"874.870074991737","amt_int_def":"0","amt_prin_end":"17479.1302209396"},{"num_pmt":"42","date_pmt":"2014-05-01 00:00:00.000","amt_prin_init":"17479.1302209396","amt_pmt":"966.640076471413","amt_int_pay":"87.395651104698","amt_prin_pay":"879.244425366698","amt_int_def":"0","amt_prin_end":"16599.8857955729"},{"num_pmt":"43","date_pmt":"2014-06-01 00:00:00.000","amt_prin_init":"16599.8857955729","amt_pmt":"966.640076471413","amt_int_pay":"82.9994289778645","amt_prin_pay":"883.640647493527","amt_int_def":"0","amt_prin_end":"15716.2451480794"},{"num_pmt":"44","date_pmt":"2014-07-01 00:00:00.000","amt_prin_init":"15716.2451480794","amt_pmt":"966.640076471413","amt_int_pay":"78.5812257403968","amt_prin_pay":"888.058850730977","amt_int_def":"0","amt_prin_end":"14828.1862973484"},{"num_pmt":"45","date_pmt":"2014-08-01 00:00:00.000","amt_prin_init":"14828.1862973484","amt_pmt":"966.640076471413","amt_int_pay":"74.140931486742","amt_prin_pay":"892.499144984649","amt_int_def":"0","amt_prin_end":"13935.6871523637"},{"num_pmt":"46","date_pmt":"2014-09-01 00:00:00.000","amt_prin_init":"13935.6871523637","amt_pmt":"966.640076471413","amt_int_pay":"69.6784357618187","amt_prin_pay":"896.961640709591","amt_int_def":"0","amt_prin_end":"13038.7255116542"},{"num_pmt":"47","date_pmt":"2014-10-01 00:00:00.000","amt_prin_init":"13038.7255116542","amt_pmt":"966.640076471413","amt_int_pay":"65.1936275582708","amt_prin_pay":"901.44644891311","amt_int_def":"0","amt_prin_end":"12137.279062741"},{"num_pmt":"48","date_pmt":"2014-11-01 00:00:00.000","amt_prin_init":"12137.279062741","amt_pmt":"966.640076471413","amt_int_pay":"60.6863953137052","amt_prin_pay":"905.953681157693","amt_int_def":"0","amt_prin_end":"11231.3253815834"},{"num_pmt":"49","date_pmt":"2014-12-01 00:00:00.000","amt_prin_init":"11231.3253815834","amt_pmt":"966.640076471413","amt_int_pay":"56.1566269079168","amt_prin_pay":"910.48344956347","amt_int_def":"0","amt_prin_end":"10320.8419320199"},{"num_pmt":"50","date_pmt":"2015-01-01 00:00:00.000","amt_prin_init":"10320.8419320199","amt_pmt":"966.640076471413","amt_int_pay":"51.6042096600994","amt_prin_pay":"915.0358668113","amt_int_def":"0","amt_prin_end":"9405.80606520858"},{"num_pmt":"51","date_pmt":"2015-02-01 00:00:00.000","amt_prin_init":"9405.80606520858","amt_pmt":"966.640076471413","amt_int_pay":"47.0290303260429","amt_prin_pay":"919.611046145375","amt_int_def":"0","amt_prin_end":"8486.19501906321"},{"num_pmt":"52","date_pmt":"2015-03-01 00:00:00.000","amt_prin_init":"8486.19501906321","amt_pmt":"966.640076471413","amt_int_pay":"42.430975095316","amt_prin_pay":"924.209101376049","amt_int_def":"0","amt_prin_end":"7561.98591768716"},{"num_pmt":"53","date_pmt":"2015-04-01 00:00:00.000","amt_prin_init":"7561.98591768716","amt_pmt":"966.640076471413","amt_int_pay":"37.8099295884358","amt_prin_pay":"928.83014688296","amt_int_def":"0","amt_prin_end":"6633.1557708042"},{"num_pmt":"54","date_pmt":"2015-05-01 00:00:00.000","amt_prin_init":"6633.1557708042","amt_pmt":"966.640076471413","amt_int_pay":"33.165778854021","amt_prin_pay":"933.474297617372","amt_int_def":"0","amt_prin_end":"5699.68147318682"},{"num_pmt":"55","date_pmt":"2015-06-01 00:00:00.000","amt_prin_init":"5699.68147318682","amt_pmt":"966.640076471413","amt_int_pay":"28.4984073659341","amt_prin_pay":"938.141669105489","amt_int_def":"0","amt_prin_end":"4761.53980408133"},{"num_pmt":"56","date_pmt":"2015-07-01 00:00:00.000","amt_prin_init":"4761.53980408133","amt_pmt":"966.640076471413","amt_int_pay":"23.8076990204067","amt_prin_pay":"942.832377450971","amt_int_def":"0","amt_prin_end":"3818.70742663036"},{"num_pmt":"57","date_pmt":"2015-08-01 00:00:00.000","amt_prin_init":"3818.70742663036","amt_pmt":"966.640076471413","amt_int_pay":"19.0935371331518","amt_prin_pay":"947.54653933825","amt_int_def":"0","amt_prin_end":"2871.16088729211"},{"num_pmt":"58","date_pmt":"2015-09-01 00:00:00.000","amt_prin_init":"2871.16088729211","amt_pmt":"966.640076471413","amt_int_pay":"14.3558044364606","amt_prin_pay":"952.284272034935","amt_int_def":"0","amt_prin_end":"1918.87661525718"},{"num_pmt":"59","date_pmt":"2015-10-01 00:00:00.000","amt_prin_init":"1918.87661525718","amt_pmt":"966.640076471413","amt_int_pay":"9.59438307628589","amt_prin_pay":"957.045693395096","amt_int_def":"0","amt_prin_end":"961.830921862083"},{"num_pmt":"60","date_pmt":"2015-11-01 00:00:00.000","amt_prin_init":"961.830921862083","amt_pmt":"966.640076471413","amt_int_pay":"4.80915460931041","amt_prin_pay":"961.830921862083","amt_int_def":"0","amt_prin_end":"0"}]}
This is an example of a loan that negatively amortizes principal using the actuarial rule.
SELECT *
FROM wct.AMORTSCHED( 50000, --Loan Amount
'11/01/2010', --Loan Start Date
.12, --Annual Interest Rate
'04/15/2011', --First Payment Date
60, --Number of payments (5*12)
12, --Number of payments per year
NULL, --Days in year (defaults to 360)
NULL, --FV (defaults to 0)
NULL --IntRule (defaults to 'A' meaning actuarial)
);
This produces the following result.
{"columns":[{"field":"num_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"date_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_init","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_def","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","date_pmt":"2010-11-01 00:00:00.000","amt_prin_init":"0","amt_pmt":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_int_def":"0","amt_prin_end":"50000"},{"num_pmt":"1","date_pmt":"2011-04-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1161.40977681566","amt_int_pay":"2733.33333333333","amt_prin_pay":"-1571.92355651766","amt_int_def":"0","amt_prin_end":"51571.9235565177"},{"num_pmt":"2","date_pmt":"2011-05-15 00:00:00.000","amt_prin_init":"51571.9235565177","amt_pmt":"1161.40977681566","amt_int_pay":"515.719235565177","amt_prin_pay":"645.690541250478","amt_int_def":"0","amt_prin_end":"50926.2330152672"},{"num_pmt":"3","date_pmt":"2011-06-15 00:00:00.000","amt_prin_init":"50926.2330152672","amt_pmt":"1161.40977681566","amt_int_pay":"509.262330152672","amt_prin_pay":"652.14744666301","amt_int_def":"0","amt_prin_end":"50274.0855686042"},{"num_pmt":"4","date_pmt":"2011-07-15 00:00:00.000","amt_prin_init":"50274.0855686042","amt_pmt":"1161.40977681566","amt_int_pay":"502.740855686042","amt_prin_pay":"658.668921129611","amt_int_def":"0","amt_prin_end":"49615.4166474746"},{"num_pmt":"5","date_pmt":"2011-08-15 00:00:00.000","amt_prin_init":"49615.4166474746","amt_pmt":"1161.40977681566","amt_int_pay":"496.154166474746","amt_prin_pay":"665.255610340915","amt_int_def":"0","amt_prin_end":"48950.1610371337"},{"num_pmt":"6","date_pmt":"2011-09-15 00:00:00.000","amt_prin_init":"48950.1610371337","amt_pmt":"1161.40977681566","amt_int_pay":"489.501610371336","amt_prin_pay":"671.908166444322","amt_int_def":"0","amt_prin_end":"48278.2528706893"},{"num_pmt":"7","date_pmt":"2011-10-15 00:00:00.000","amt_prin_init":"48278.2528706893","amt_pmt":"1161.40977681566","amt_int_pay":"482.782528706893","amt_prin_pay":"678.62724810878","amt_int_def":"0","amt_prin_end":"47599.6256225805"},{"num_pmt":"8","date_pmt":"2011-11-15 00:00:00.000","amt_prin_init":"47599.6256225805","amt_pmt":"1161.40977681566","amt_int_pay":"475.996256225806","amt_prin_pay":"685.413520589864","amt_int_def":"0","amt_prin_end":"46914.2121019907"},{"num_pmt":"9","date_pmt":"2011-12-15 00:00:00.000","amt_prin_init":"46914.2121019907","amt_pmt":"1161.40977681566","amt_int_pay":"469.142121019907","amt_prin_pay":"692.267655795738","amt_int_def":"0","amt_prin_end":"46221.9444461949"},{"num_pmt":"10","date_pmt":"2012-01-15 00:00:00.000","amt_prin_init":"46221.9444461949","amt_pmt":"1161.40977681566","amt_int_pay":"462.219444461949","amt_prin_pay":"699.190332353712","amt_int_def":"0","amt_prin_end":"45522.7541138412"},{"num_pmt":"11","date_pmt":"2012-02-15 00:00:00.000","amt_prin_init":"45522.7541138412","amt_pmt":"1161.40977681566","amt_int_pay":"455.227541138412","amt_prin_pay":"706.182235677268","amt_int_def":"0","amt_prin_end":"44816.571878164"},{"num_pmt":"12","date_pmt":"2012-03-15 00:00:00.000","amt_prin_init":"44816.571878164","amt_pmt":"1161.40977681566","amt_int_pay":"448.16571878164","amt_prin_pay":"713.244058034019","amt_int_def":"0","amt_prin_end":"44103.3278201299"},{"num_pmt":"13","date_pmt":"2012-04-15 00:00:00.000","amt_prin_init":"44103.3278201299","amt_pmt":"1161.40977681566","amt_int_pay":"441.033278201299","amt_prin_pay":"720.376498614358","amt_int_def":"0","amt_prin_end":"43382.9513215156"},{"num_pmt":"14","date_pmt":"2012-05-15 00:00:00.000","amt_prin_init":"43382.9513215156","amt_pmt":"1161.40977681566","amt_int_pay":"433.829513215156","amt_prin_pay":"727.580263600517","amt_int_def":"0","amt_prin_end":"42655.3710579151"},{"num_pmt":"15","date_pmt":"2012-06-15 00:00:00.000","amt_prin_init":"42655.3710579151","amt_pmt":"1161.40977681566","amt_int_pay":"426.553710579151","amt_prin_pay":"734.856066236513","amt_int_def":"0","amt_prin_end":"41920.5149916786"},{"num_pmt":"16","date_pmt":"2012-07-15 00:00:00.000","amt_prin_init":"41920.5149916786","amt_pmt":"1161.40977681566","amt_int_pay":"419.205149916786","amt_prin_pay":"742.204626898871","amt_int_def":"0","amt_prin_end":"41178.3103647797"},{"num_pmt":"17","date_pmt":"2012-08-15 00:00:00.000","amt_prin_init":"41178.3103647797","amt_pmt":"1161.40977681566","amt_int_pay":"411.783103647797","amt_prin_pay":"749.62667316787","amt_int_def":"0","amt_prin_end":"40428.6836916118"},{"num_pmt":"18","date_pmt":"2012-09-15 00:00:00.000","amt_prin_init":"40428.6836916118","amt_pmt":"1161.40977681566","amt_int_pay":"404.286836916118","amt_prin_pay":"757.122939899542","amt_int_def":"0","amt_prin_end":"39671.5607517123"},{"num_pmt":"19","date_pmt":"2012-10-15 00:00:00.000","amt_prin_init":"39671.5607517123","amt_pmt":"1161.40977681566","amt_int_pay":"396.715607517123","amt_prin_pay":"764.694169298549","amt_int_def":"0","amt_prin_end":"38906.8665824137"},{"num_pmt":"20","date_pmt":"2012-11-15 00:00:00.000","amt_prin_init":"38906.8665824137","amt_pmt":"1161.40977681566","amt_int_pay":"389.068665824137","amt_prin_pay":"772.341110991525","amt_int_def":"0","amt_prin_end":"38134.5254714222"},{"num_pmt":"21","date_pmt":"2012-12-15 00:00:00.000","amt_prin_init":"38134.5254714222","amt_pmt":"1161.40977681566","amt_int_pay":"381.345254714222","amt_prin_pay":"780.064522101435","amt_int_def":"0","amt_prin_end":"37354.4609493208"},{"num_pmt":"22","date_pmt":"2013-01-15 00:00:00.000","amt_prin_init":"37354.4609493208","amt_pmt":"1161.40977681566","amt_int_pay":"373.544609493208","amt_prin_pay":"787.865167322467","amt_int_def":"0","amt_prin_end":"36566.5957819983"},{"num_pmt":"23","date_pmt":"2013-02-15 00:00:00.000","amt_prin_init":"36566.5957819983","amt_pmt":"1161.40977681566","amt_int_pay":"365.665957819983","amt_prin_pay":"795.743818995667","amt_int_def":"0","amt_prin_end":"35770.8519630026"},{"num_pmt":"24","date_pmt":"2013-03-15 00:00:00.000","amt_prin_init":"35770.8519630026","amt_pmt":"1161.40977681566","amt_int_pay":"357.708519630026","amt_prin_pay":"803.701257185639","amt_int_def":"0","amt_prin_end":"34967.150705817"},{"num_pmt":"25","date_pmt":"2013-04-15 00:00:00.000","amt_prin_init":"34967.150705817","amt_pmt":"1161.40977681566","amt_int_pay":"349.67150705817","amt_prin_pay":"811.738269757501","amt_int_def":"0","amt_prin_end":"34155.4124360595"},{"num_pmt":"26","date_pmt":"2013-05-15 00:00:00.000","amt_prin_init":"34155.4124360595","amt_pmt":"1161.40977681566","amt_int_pay":"341.554124360595","amt_prin_pay":"819.855652455066","amt_int_def":"0","amt_prin_end":"33335.5567836044"},{"num_pmt":"27","date_pmt":"2013-06-15 00:00:00.000","amt_prin_init":"33335.5567836044","amt_pmt":"1161.40977681566","amt_int_pay":"333.355567836044","amt_prin_pay":"828.054208979622","amt_int_def":"0","amt_prin_end":"32507.5025746248"},{"num_pmt":"28","date_pmt":"2013-07-15 00:00:00.000","amt_prin_init":"32507.5025746248","amt_pmt":"1161.40977681566","amt_int_pay":"325.075025746248","amt_prin_pay":"836.334751069418","amt_int_def":"0","amt_prin_end":"31671.1678235554"},{"num_pmt":"29","date_pmt":"2013-08-15 00:00:00.000","amt_prin_init":"31671.1678235554","amt_pmt":"1161.40977681566","amt_int_pay":"316.711678235554","amt_prin_pay":"844.698098580098","amt_int_def":"0","amt_prin_end":"30826.4697249753"},{"num_pmt":"30","date_pmt":"2013-09-15 00:00:00.000","amt_prin_init":"30826.4697249753","amt_pmt":"1161.40977681566","amt_int_pay":"308.264697249753","amt_prin_pay":"853.145079565918","amt_int_def":"0","amt_prin_end":"29973.3246454094"},{"num_pmt":"31","date_pmt":"2013-10-15 00:00:00.000","amt_prin_init":"29973.3246454094","amt_pmt":"1161.40977681566","amt_int_pay":"299.733246454094","amt_prin_pay":"861.676530361568","amt_int_def":"0","amt_prin_end":"29111.6481150478"},{"num_pmt":"32","date_pmt":"2013-11-15 00:00:00.000","amt_prin_init":"29111.6481150478","amt_pmt":"1161.40977681566","amt_int_pay":"291.116481150478","amt_prin_pay":"870.293295665189","amt_int_def":"0","amt_prin_end":"28241.3548193826"},{"num_pmt":"33","date_pmt":"2013-12-15 00:00:00.000","amt_prin_init":"28241.3548193826","amt_pmt":"1161.40977681566","amt_int_pay":"282.413548193826","amt_prin_pay":"878.996228621829","amt_int_def":"0","amt_prin_end":"27362.3585907608"},{"num_pmt":"34","date_pmt":"2014-01-15 00:00:00.000","amt_prin_init":"27362.3585907608","amt_pmt":"1161.40977681566","amt_int_pay":"273.623585907608","amt_prin_pay":"887.78619090806","amt_int_def":"0","amt_prin_end":"26474.5723998527"},{"num_pmt":"35","date_pmt":"2014-02-15 00:00:00.000","amt_prin_init":"26474.5723998527","amt_pmt":"1161.40977681566","amt_int_pay":"264.745723998527","amt_prin_pay":"896.664052817145","amt_int_def":"0","amt_prin_end":"25577.9083470356"},{"num_pmt":"36","date_pmt":"2014-03-15 00:00:00.000","amt_prin_init":"25577.9083470356","amt_pmt":"1161.40977681566","amt_int_pay":"255.779083470356","amt_prin_pay":"905.630693345298","amt_int_def":"0","amt_prin_end":"24672.2776536903"},{"num_pmt":"37","date_pmt":"2014-04-15 00:00:00.000","amt_prin_init":"24672.2776536903","amt_pmt":"1161.40977681566","amt_int_pay":"246.722776536903","amt_prin_pay":"914.687000278769","amt_int_def":"0","amt_prin_end":"23757.5906534115"},{"num_pmt":"38","date_pmt":"2014-05-15 00:00:00.000","amt_prin_init":"23757.5906534115","amt_pmt":"1161.40977681566","amt_int_pay":"237.575906534115","amt_prin_pay":"923.833870281549","amt_int_def":"0","amt_prin_end":"22833.75678313"},{"num_pmt":"39","date_pmt":"2014-06-15 00:00:00.000","amt_prin_init":"22833.75678313","amt_pmt":"1161.40977681566","amt_int_pay":"228.3375678313","amt_prin_pay":"933.072208984355","amt_int_def":"0","amt_prin_end":"21900.6845741456"},{"num_pmt":"40","date_pmt":"2014-07-15 00:00:00.000","amt_prin_init":"21900.6845741456","amt_pmt":"1161.40977681566","amt_int_pay":"219.006845741456","amt_prin_pay":"942.402931074212","amt_int_def":"0","amt_prin_end":"20958.2816430714"},{"num_pmt":"41","date_pmt":"2014-08-15 00:00:00.000","amt_prin_init":"20958.2816430714","amt_pmt":"1161.40977681566","amt_int_pay":"209.582816430714","amt_prin_pay":"951.826960384962","amt_int_def":"0","amt_prin_end":"20006.4546826864"},{"num_pmt":"42","date_pmt":"2014-09-15 00:00:00.000","amt_prin_init":"20006.4546826864","amt_pmt":"1161.40977681566","amt_int_pay":"200.064546826864","amt_prin_pay":"961.34522998879","amt_int_def":"0","amt_prin_end":"19045.1094526976"},{"num_pmt":"43","date_pmt":"2014-10-15 00:00:00.000","amt_prin_init":"19045.1094526976","amt_pmt":"1161.40977681566","amt_int_pay":"190.451094526976","amt_prin_pay":"970.958682288689","amt_int_def":"0","amt_prin_end":"18074.150770409"},{"num_pmt":"44","date_pmt":"2014-11-15 00:00:00.000","amt_prin_init":"18074.150770409","amt_pmt":"1161.40977681566","amt_int_pay":"180.74150770409","amt_prin_pay":"980.66826911156","amt_int_def":"0","amt_prin_end":"17093.4825012974"},{"num_pmt":"45","date_pmt":"2014-12-15 00:00:00.000","amt_prin_init":"17093.4825012974","amt_pmt":"1161.40977681566","amt_int_pay":"170.934825012974","amt_prin_pay":"990.474951802702","amt_int_def":"0","amt_prin_end":"16103.0075494947"},{"num_pmt":"46","date_pmt":"2015-01-15 00:00:00.000","amt_prin_init":"16103.0075494947","amt_pmt":"1161.40977681566","amt_int_pay":"161.030075494947","amt_prin_pay":"1000.37970132071","amt_int_def":"0","amt_prin_end":"15102.627848174"},{"num_pmt":"47","date_pmt":"2015-02-15 00:00:00.000","amt_prin_init":"15102.627848174","amt_pmt":"1161.40977681566","amt_int_pay":"151.02627848174","amt_prin_pay":"1010.38349833394","amt_int_def":"0","amt_prin_end":"14092.24434984"},{"num_pmt":"48","date_pmt":"2015-03-15 00:00:00.000","amt_prin_init":"14092.24434984","amt_pmt":"1161.40977681566","amt_int_pay":"140.9224434984","amt_prin_pay":"1020.48733331727","amt_int_def":"0","amt_prin_end":"13071.7570165228"},{"num_pmt":"49","date_pmt":"2015-04-15 00:00:00.000","amt_prin_init":"13071.7570165228","amt_pmt":"1161.40977681566","amt_int_pay":"130.717570165228","amt_prin_pay":"1030.69220665044","amt_int_def":"0","amt_prin_end":"12041.0648098723"},{"num_pmt":"50","date_pmt":"2015-05-15 00:00:00.000","amt_prin_init":"12041.0648098723","amt_pmt":"1161.40977681566","amt_int_pay":"120.410648098723","amt_prin_pay":"1040.99912871694","amt_int_def":"0","amt_prin_end":"11000.0656811554"},{"num_pmt":"51","date_pmt":"2015-06-15 00:00:00.000","amt_prin_init":"11000.0656811554","amt_pmt":"1161.40977681566","amt_int_pay":"110.000656811554","amt_prin_pay":"1051.40912000411","amt_int_def":"0","amt_prin_end":"9948.6565611513"},{"num_pmt":"52","date_pmt":"2015-07-15 00:00:00.000","amt_prin_init":"9948.6565611513","amt_pmt":"1161.40977681566","amt_int_pay":"99.486565611513","amt_prin_pay":"1061.92321120414","amt_int_def":"0","amt_prin_end":"8886.73334994716"},{"num_pmt":"53","date_pmt":"2015-08-15 00:00:00.000","amt_prin_init":"8886.73334994716","amt_pmt":"1161.40977681566","amt_int_pay":"88.8673334994716","amt_prin_pay":"1072.5424433162","amt_int_def":"0","amt_prin_end":"7814.19090663096"},{"num_pmt":"54","date_pmt":"2015-09-15 00:00:00.000","amt_prin_init":"7814.19090663096","amt_pmt":"1161.40977681566","amt_int_pay":"78.1419090663096","amt_prin_pay":"1083.26786774934","amt_int_def":"0","amt_prin_end":"6730.92303888162"},{"num_pmt":"55","date_pmt":"2015-10-15 00:00:00.000","amt_prin_init":"6730.92303888162","amt_pmt":"1161.40977681566","amt_int_pay":"67.3092303888162","amt_prin_pay":"1094.10054642684","amt_int_def":"0","amt_prin_end":"5636.82249245477"},{"num_pmt":"56","date_pmt":"2015-11-15 00:00:00.000","amt_prin_init":"5636.82249245477","amt_pmt":"1161.40977681566","amt_int_pay":"56.3682249245477","amt_prin_pay":"1105.04155189113","amt_int_def":"0","amt_prin_end":"4531.78094056364"},{"num_pmt":"57","date_pmt":"2015-12-15 00:00:00.000","amt_prin_init":"4531.78094056364","amt_pmt":"1161.40977681566","amt_int_pay":"45.3178094056364","amt_prin_pay":"1116.09196741001","amt_int_def":"0","amt_prin_end":"3415.68897315363"},{"num_pmt":"58","date_pmt":"2016-01-15 00:00:00.000","amt_prin_init":"3415.68897315363","amt_pmt":"1161.40977681566","amt_int_pay":"34.1568897315363","amt_prin_pay":"1127.25288708414","amt_int_def":"0","amt_prin_end":"2288.43608606949"},{"num_pmt":"59","date_pmt":"2016-02-15 00:00:00.000","amt_prin_init":"2288.43608606949","amt_pmt":"1161.40977681566","amt_int_pay":"22.8843608606949","amt_prin_pay":"1138.52541595497","amt_int_def":"0","amt_prin_end":"1149.91067011452"},{"num_pmt":"60","date_pmt":"2016-03-15 00:00:00.000","amt_prin_init":"1149.91067011452","amt_pmt":"1161.40977681566","amt_int_pay":"11.4991067011452","amt_prin_pay":"1149.91067011452","amt_int_def":"0","amt_prin_end":"0"}]}
The same loan, except that the US Rule is applied, so there is no negative amortization.
SELECT *
FROM wct.AMORTSCHED( 50000, --Loan Amount
'11/01/2010', --Loan Start Date
.12, --Annual Interest Rate
'04/15/2011', --First Payment Date
60, --Number of payments (5*12)
12, --Number of payments per year
NULL, --Days in year (defaults to 360)
NULL, --FV (defaults to 0)
'U' --IntRule (defaults to 'A' meaning actuarial)
);
This produces the following result.
{"columns":[{"field":"num_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"date_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_init","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_def","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","date_pmt":"2010-11-01 00:00:00.000","amt_prin_init":"0","amt_pmt":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_int_def":"0","amt_prin_end":"50000"},{"num_pmt":"1","date_pmt":"2011-04-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1160.81640297125","amt_int_pay":"1160.81640297125","amt_prin_pay":"0","amt_int_def":"1572.51693036209","amt_prin_end":"50000"},{"num_pmt":"2","date_pmt":"2011-05-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1160.81640297125","amt_int_pay":"1160.81640297125","amt_prin_pay":"0","amt_int_def":"911.70052739084","amt_prin_end":"50000"},{"num_pmt":"3","date_pmt":"2011-06-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1160.81640297125","amt_int_pay":"1160.81640297125","amt_prin_pay":"0","amt_int_def":"250.884124419594","amt_prin_end":"50000"},{"num_pmt":"4","date_pmt":"2011-07-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1160.81640297125","amt_int_pay":"750.884124419594","amt_prin_pay":"409.932278551652","amt_int_def":"0","amt_prin_end":"49590.0677214483"},{"num_pmt":"5","date_pmt":"2011-08-15 00:00:00.000","amt_prin_init":"49590.0677214483","amt_pmt":"1160.81640297125","amt_int_pay":"495.900677214483","amt_prin_pay":"664.915725756763","amt_int_def":"0","amt_prin_end":"48925.1519956916"},{"num_pmt":"6","date_pmt":"2011-09-15 00:00:00.000","amt_prin_init":"48925.1519956916","amt_pmt":"1160.81640297125","amt_int_pay":"489.251519956916","amt_prin_pay":"671.564883014331","amt_int_def":"0","amt_prin_end":"48253.5871126772"},{"num_pmt":"7","date_pmt":"2011-10-15 00:00:00.000","amt_prin_init":"48253.5871126772","amt_pmt":"1160.81640297125","amt_int_pay":"482.535871126772","amt_prin_pay":"678.280531844474","amt_int_def":"0","amt_prin_end":"47575.3065808328"},{"num_pmt":"8","date_pmt":"2011-11-15 00:00:00.000","amt_prin_init":"47575.3065808328","amt_pmt":"1160.81640297125","amt_int_pay":"475.753065808328","amt_prin_pay":"685.063337162919","amt_int_def":"0","amt_prin_end":"46890.2432436699"},{"num_pmt":"9","date_pmt":"2011-12-15 00:00:00.000","amt_prin_init":"46890.2432436699","amt_pmt":"1160.81640297125","amt_int_pay":"468.902432436699","amt_prin_pay":"691.913970534548","amt_int_def":"0","amt_prin_end":"46198.3292731353"},{"num_pmt":"10","date_pmt":"2012-01-15 00:00:00.000","amt_prin_init":"46198.3292731353","amt_pmt":"1160.81640297125","amt_int_pay":"461.983292731353","amt_prin_pay":"698.833110239893","amt_int_def":"0","amt_prin_end":"45499.4961628954"},{"num_pmt":"11","date_pmt":"2012-02-15 00:00:00.000","amt_prin_init":"45499.4961628954","amt_pmt":"1160.81640297125","amt_int_pay":"454.994961628954","amt_prin_pay":"705.821441342292","amt_int_def":"0","amt_prin_end":"44793.6747215531"},{"num_pmt":"12","date_pmt":"2012-03-15 00:00:00.000","amt_prin_init":"44793.6747215531","amt_pmt":"1160.81640297125","amt_int_pay":"447.936747215531","amt_prin_pay":"712.879655755715","amt_int_def":"0","amt_prin_end":"44080.7950657974"},{"num_pmt":"13","date_pmt":"2012-04-15 00:00:00.000","amt_prin_init":"44080.7950657974","amt_pmt":"1160.81640297125","amt_int_pay":"440.807950657974","amt_prin_pay":"720.008452313272","amt_int_def":"0","amt_prin_end":"43360.7866134841"},{"num_pmt":"14","date_pmt":"2012-05-15 00:00:00.000","amt_prin_init":"43360.7866134841","amt_pmt":"1160.81640297125","amt_int_pay":"433.607866134841","amt_prin_pay":"727.208536836405","amt_int_def":"0","amt_prin_end":"42633.5780766477"},{"num_pmt":"15","date_pmt":"2012-06-15 00:00:00.000","amt_prin_init":"42633.5780766477","amt_pmt":"1160.81640297125","amt_int_pay":"426.335780766477","amt_prin_pay":"734.480622204769","amt_int_def":"0","amt_prin_end":"41899.097454443"},{"num_pmt":"16","date_pmt":"2012-07-15 00:00:00.000","amt_prin_init":"41899.097454443","amt_pmt":"1160.81640297125","amt_int_pay":"418.99097454443","amt_prin_pay":"741.825428426817","amt_int_def":"0","amt_prin_end":"41157.2720260161"},{"num_pmt":"17","date_pmt":"2012-08-15 00:00:00.000","amt_prin_init":"41157.2720260161","amt_pmt":"1160.81640297125","amt_int_pay":"411.572720260161","amt_prin_pay":"749.243682711085","amt_int_def":"0","amt_prin_end":"40408.0283433051"},{"num_pmt":"18","date_pmt":"2012-09-15 00:00:00.000","amt_prin_init":"40408.0283433051","amt_pmt":"1160.81640297125","amt_int_pay":"404.080283433051","amt_prin_pay":"756.736119538196","amt_int_def":"0","amt_prin_end":"39651.2922237669"},{"num_pmt":"19","date_pmt":"2012-10-15 00:00:00.000","amt_prin_init":"39651.2922237669","amt_pmt":"1160.81640297125","amt_int_pay":"396.512922237669","amt_prin_pay":"764.303480733578","amt_int_def":"0","amt_prin_end":"38886.9887430333"},{"num_pmt":"20","date_pmt":"2012-11-15 00:00:00.000","amt_prin_init":"38886.9887430333","amt_pmt":"1160.81640297125","amt_int_pay":"388.869887430333","amt_prin_pay":"771.946515540914","amt_int_def":"0","amt_prin_end":"38115.0422274924"},{"num_pmt":"21","date_pmt":"2012-12-15 00:00:00.000","amt_prin_init":"38115.0422274924","amt_pmt":"1160.81640297125","amt_int_pay":"381.150422274924","amt_prin_pay":"779.665980696323","amt_int_def":"0","amt_prin_end":"37335.376246796"},{"num_pmt":"22","date_pmt":"2013-01-15 00:00:00.000","amt_prin_init":"37335.376246796","amt_pmt":"1160.81640297125","amt_int_pay":"373.353762467961","amt_prin_pay":"787.462640503286","amt_int_def":"0","amt_prin_end":"36547.9136062928"},{"num_pmt":"23","date_pmt":"2013-02-15 00:00:00.000","amt_prin_init":"36547.9136062928","amt_pmt":"1160.81640297125","amt_int_pay":"365.479136062928","amt_prin_pay":"795.337266908319","amt_int_def":"0","amt_prin_end":"35752.5763393844"},{"num_pmt":"24","date_pmt":"2013-03-15 00:00:00.000","amt_prin_init":"35752.5763393844","amt_pmt":"1160.81640297125","amt_int_pay":"357.525763393844","amt_prin_pay":"803.290639577402","amt_int_def":"0","amt_prin_end":"34949.285699807"},{"num_pmt":"25","date_pmt":"2013-04-15 00:00:00.000","amt_prin_init":"34949.285699807","amt_pmt":"1160.81640297125","amt_int_pay":"349.49285699807","amt_prin_pay":"811.323545973176","amt_int_def":"0","amt_prin_end":"34137.9621538339"},{"num_pmt":"26","date_pmt":"2013-05-15 00:00:00.000","amt_prin_init":"34137.9621538339","amt_pmt":"1160.81640297125","amt_int_pay":"341.379621538339","amt_prin_pay":"819.436781432908","amt_int_def":"0","amt_prin_end":"33318.525372401"},{"num_pmt":"27","date_pmt":"2013-06-15 00:00:00.000","amt_prin_init":"33318.525372401","amt_pmt":"1160.81640297125","amt_int_pay":"333.18525372401","amt_prin_pay":"827.631149247237","amt_int_def":"0","amt_prin_end":"32490.8942231537"},{"num_pmt":"28","date_pmt":"2013-07-15 00:00:00.000","amt_prin_init":"32490.8942231537","amt_pmt":"1160.81640297125","amt_int_pay":"324.908942231537","amt_prin_pay":"835.907460739709","amt_int_def":"0","amt_prin_end":"31654.986762414"},{"num_pmt":"29","date_pmt":"2013-08-15 00:00:00.000","amt_prin_init":"31654.986762414","amt_pmt":"1160.81640297125","amt_int_pay":"316.54986762414","amt_prin_pay":"844.266535347106","amt_int_def":"0","amt_prin_end":"30810.7202270669"},{"num_pmt":"30","date_pmt":"2013-09-15 00:00:00.000","amt_prin_init":"30810.7202270669","amt_pmt":"1160.81640297125","amt_int_pay":"308.107202270669","amt_prin_pay":"852.709200700577","amt_int_def":"0","amt_prin_end":"29958.0110263663"},{"num_pmt":"31","date_pmt":"2013-10-15 00:00:00.000","amt_prin_init":"29958.0110263663","amt_pmt":"1160.81640297125","amt_int_pay":"299.580110263663","amt_prin_pay":"861.236292707583","amt_int_def":"0","amt_prin_end":"29096.7747336587"},{"num_pmt":"32","date_pmt":"2013-11-15 00:00:00.000","amt_prin_init":"29096.7747336587","amt_pmt":"1160.81640297125","amt_int_pay":"290.967747336587","amt_prin_pay":"869.848655634659","amt_int_def":"0","amt_prin_end":"28226.9260780241"},{"num_pmt":"33","date_pmt":"2013-12-15 00:00:00.000","amt_prin_init":"28226.9260780241","amt_pmt":"1160.81640297125","amt_int_pay":"282.269260780241","amt_prin_pay":"878.547142191005","amt_int_def":"0","amt_prin_end":"27348.3789358331"},{"num_pmt":"34","date_pmt":"2014-01-15 00:00:00.000","amt_prin_init":"27348.3789358331","amt_pmt":"1160.81640297125","amt_int_pay":"273.483789358331","amt_prin_pay":"887.332613612916","amt_int_def":"0","amt_prin_end":"26461.0463222202"},{"num_pmt":"35","date_pmt":"2014-02-15 00:00:00.000","amt_prin_init":"26461.0463222202","amt_pmt":"1160.81640297125","amt_int_pay":"264.610463222202","amt_prin_pay":"896.205939749045","amt_int_def":"0","amt_prin_end":"25564.8403824711"},{"num_pmt":"36","date_pmt":"2014-03-15 00:00:00.000","amt_prin_init":"25564.8403824711","amt_pmt":"1160.81640297125","amt_int_pay":"255.648403824711","amt_prin_pay":"905.167999146535","amt_int_def":"0","amt_prin_end":"24659.6723833246"},{"num_pmt":"37","date_pmt":"2014-04-15 00:00:00.000","amt_prin_init":"24659.6723833246","amt_pmt":"1160.81640297125","amt_int_pay":"246.596723833246","amt_prin_pay":"914.219679138","amt_int_def":"0","amt_prin_end":"23745.4527041866"},{"num_pmt":"38","date_pmt":"2014-05-15 00:00:00.000","amt_prin_init":"23745.4527041866","amt_pmt":"1160.81640297125","amt_int_pay":"237.454527041866","amt_prin_pay":"923.361875929381","amt_int_def":"0","amt_prin_end":"22822.0908282572"},{"num_pmt":"39","date_pmt":"2014-06-15 00:00:00.000","amt_prin_init":"22822.0908282572","amt_pmt":"1160.81640297125","amt_int_pay":"228.220908282572","amt_prin_pay":"932.595494688674","amt_int_def":"0","amt_prin_end":"21889.4953335685"},{"num_pmt":"40","date_pmt":"2014-07-15 00:00:00.000","amt_prin_init":"21889.4953335685","amt_pmt":"1160.81640297125","amt_int_pay":"218.894953335685","amt_prin_pay":"941.921449635561","amt_int_def":"0","amt_prin_end":"20947.573883933"},{"num_pmt":"41","date_pmt":"2014-08-15 00:00:00.000","amt_prin_init":"20947.573883933","amt_pmt":"1160.81640297125","amt_int_pay":"209.47573883933","amt_prin_pay":"951.340664131917","amt_int_def":"0","amt_prin_end":"19996.2332198011"},{"num_pmt":"42","date_pmt":"2014-09-15 00:00:00.000","amt_prin_init":"19996.2332198011","amt_pmt":"1160.81640297125","amt_int_pay":"199.962332198011","amt_prin_pay":"960.854070773236","amt_int_def":"0","amt_prin_end":"19035.3791490278"},{"num_pmt":"43","date_pmt":"2014-10-15 00:00:00.000","amt_prin_init":"19035.3791490278","amt_pmt":"1160.81640297125","amt_int_pay":"190.353791490278","amt_prin_pay":"970.462611480968","amt_int_def":"0","amt_prin_end":"18064.9165375469"},{"num_pmt":"44","date_pmt":"2014-11-15 00:00:00.000","amt_prin_init":"18064.9165375469","amt_pmt":"1160.81640297125","amt_int_pay":"180.649165375469","amt_prin_pay":"980.167237595778","amt_int_def":"0","amt_prin_end":"17084.7492999511"},{"num_pmt":"45","date_pmt":"2014-12-15 00:00:00.000","amt_prin_init":"17084.7492999511","amt_pmt":"1160.81640297125","amt_int_pay":"170.847492999511","amt_prin_pay":"989.968909971736","amt_int_def":"0","amt_prin_end":"16094.7803899793"},{"num_pmt":"46","date_pmt":"2015-01-15 00:00:00.000","amt_prin_init":"16094.7803899793","amt_pmt":"1160.81640297125","amt_int_pay":"160.947803899793","amt_prin_pay":"999.868599071453","amt_int_def":"0","amt_prin_end":"15094.9117909079"},{"num_pmt":"47","date_pmt":"2015-02-15 00:00:00.000","amt_prin_init":"15094.9117909079","amt_pmt":"1160.81640297125","amt_int_pay":"150.949117909079","amt_prin_pay":"1009.86728506217","amt_int_def":"0","amt_prin_end":"14085.0445058457"},{"num_pmt":"48","date_pmt":"2015-03-15 00:00:00.000","amt_prin_init":"14085.0445058457","amt_pmt":"1160.81640297125","amt_int_pay":"140.850445058457","amt_prin_pay":"1019.96595791279","amt_int_def":"0","amt_prin_end":"13065.0785479329"},{"num_pmt":"49","date_pmt":"2015-04-15 00:00:00.000","amt_prin_init":"13065.0785479329","amt_pmt":"1160.81640297125","amt_int_pay":"130.650785479329","amt_prin_pay":"1030.16561749192","amt_int_def":"0","amt_prin_end":"12034.912930441"},{"num_pmt":"50","date_pmt":"2015-05-15 00:00:00.000","amt_prin_init":"12034.912930441","amt_pmt":"1160.81640297125","amt_int_pay":"120.34912930441","amt_prin_pay":"1040.46727366684","amt_int_def":"0","amt_prin_end":"10994.4456567742"},{"num_pmt":"51","date_pmt":"2015-06-15 00:00:00.000","amt_prin_init":"10994.4456567742","amt_pmt":"1160.81640297125","amt_int_pay":"109.944456567742","amt_prin_pay":"1050.8719464035","amt_int_def":"0","amt_prin_end":"9943.57371037067"},{"num_pmt":"52","date_pmt":"2015-07-15 00:00:00.000","amt_prin_init":"9943.57371037067","amt_pmt":"1160.81640297125","amt_int_pay":"99.4357371037067","amt_prin_pay":"1061.38066586754","amt_int_def":"0","amt_prin_end":"8882.19304450313"},{"num_pmt":"53","date_pmt":"2015-08-15 00:00:00.000","amt_prin_init":"8882.19304450313","amt_pmt":"1160.81640297125","amt_int_pay":"88.8219304450313","amt_prin_pay":"1071.99447252622","amt_int_def":"0","amt_prin_end":"7810.19857197691"},{"num_pmt":"54","date_pmt":"2015-09-15 00:00:00.000","amt_prin_init":"7810.19857197691","amt_pmt":"1160.81640297125","amt_int_pay":"78.1019857197691","amt_prin_pay":"1082.71441725148","amt_int_def":"0","amt_prin_end":"6727.48415472544"},{"num_pmt":"55","date_pmt":"2015-10-15 00:00:00.000","amt_prin_init":"6727.48415472544","amt_pmt":"1160.81640297125","amt_int_pay":"67.2748415472544","amt_prin_pay":"1093.54156142399","amt_int_def":"0","amt_prin_end":"5633.94259330144"},{"num_pmt":"56","date_pmt":"2015-11-15 00:00:00.000","amt_prin_init":"5633.94259330144","amt_pmt":"1160.81640297125","amt_int_pay":"56.3394259330144","amt_prin_pay":"1104.47697703823","amt_int_def":"0","amt_prin_end":"4529.46561626321"},{"num_pmt":"57","date_pmt":"2015-12-15 00:00:00.000","amt_prin_init":"4529.46561626321","amt_pmt":"1160.81640297125","amt_int_pay":"45.2946561626321","amt_prin_pay":"1115.52174680861","amt_int_def":"0","amt_prin_end":"3413.9438694546"},{"num_pmt":"58","date_pmt":"2016-01-15 00:00:00.000","amt_prin_init":"3413.9438694546","amt_pmt":"1160.81640297125","amt_int_pay":"34.139438694546","amt_prin_pay":"1126.6769642767","amt_int_def":"0","amt_prin_end":"2287.2669051779"},{"num_pmt":"59","date_pmt":"2016-02-15 00:00:00.000","amt_prin_init":"2287.2669051779","amt_pmt":"1160.81640297125","amt_int_pay":"22.872669051779","amt_prin_pay":"1137.94373391947","amt_int_def":"0","amt_prin_end":"1149.32317125843"},{"num_pmt":"60","date_pmt":"2016-03-15 00:00:00.000","amt_prin_init":"1149.32317125843","amt_pmt":"1160.81640297125","amt_int_pay":"11.4932317125843","amt_prin_pay":"1149.32317125866","amt_int_def":"0","amt_prin_end":"-2.31011654250324E-10"}]}
In this example, we have a loan with weekly payments, but we want to summarize the payment information into by month and year.
SELECT MONTH(date_pmt) as [MONTH],
YEAR(date_pmt) as [YEAR],
ROUND(SUM(amt_pmt), 2) as [Monthly Payments],
ROUND(SUM(amt_int_pay), 2) as [Monthly Interest],
ROUND(SUM(amt_prin_pay), 2) as [Monthly Principal]
FROM wct.AMORTSCHED( 50000, --Loan Amount
'10/28/2010', --Loan Start Date
.12, --Annual Interest Rate
'11/05/2010', --First Payment Date
156, --Number of payments
52, --Number of payments per year
NULL, --Days in year (defaults to 360)
NULL, --FV (defaults to 0)
NULL --IntRule (defaults to 'A' meaning actuarial)
)
GROUP BY MONTH(date_pmt),
YEAR(date_pmt)
ORDER BY 2,
1;
This produces the following result.
{"columns":[{"field":"MONTH","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"YEAR","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"Monthly Payments","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"Monthly Interest","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"Monthly Principal","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"MONTH":"10","YEAR":"2010","Monthly Payments":"0","Monthly Interest":"0","Monthly Principal":"0"},{"MONTH":"11","YEAR":"2010","Monthly Payments":"1527.44","Monthly Interest":"458.19","Monthly Principal":"1069.24"},{"MONTH":"12","YEAR":"2010","Monthly Payments":"1909.3","Monthly Interest":"556.83","Monthly Principal":"1352.47"},{"MONTH":"1","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"434.21","Monthly Principal":"1093.22"},{"MONTH":"2","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"424.12","Monthly Principal":"1103.32"},{"MONTH":"3","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"413.92","Monthly Principal":"1113.51"},{"MONTH":"4","YEAR":"2011","Monthly Payments":"1909.3","Monthly Interest":"502.93","Monthly Principal":"1406.37"},{"MONTH":"5","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"390.65","Monthly Principal":"1136.79"},{"MONTH":"6","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"380.15","Monthly Principal":"1147.29"},{"MONTH":"7","YEAR":"2011","Monthly Payments":"1909.3","Monthly Interest":"460.27","Monthly Principal":"1449.03"},{"MONTH":"8","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"356.16","Monthly Principal":"1171.27"},{"MONTH":"9","YEAR":"2011","Monthly Payments":"1909.3","Monthly Interest":"429.98","Monthly Principal":"1479.32"},{"MONTH":"10","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"331.68","Monthly Principal":"1195.76"},{"MONTH":"11","YEAR":"2011","Monthly Payments":"1527.44","Monthly Interest":"320.63","Monthly Principal":"1206.8"},{"MONTH":"12","YEAR":"2011","Monthly Payments":"1909.3","Monthly Interest":"385.1","Monthly Principal":"1524.19"},{"MONTH":"1","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"295.41","Monthly Principal":"1232.03"},{"MONTH":"2","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"284.03","Monthly Principal":"1243.41"},{"MONTH":"3","YEAR":"2012","Monthly Payments":"1909.3","Monthly Interest":"338.87","Monthly Principal":"1570.43"},{"MONTH":"4","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"258.03","Monthly Principal":"1269.4"},{"MONTH":"5","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"246.31","Monthly Principal":"1281.13"},{"MONTH":"6","YEAR":"2012","Monthly Payments":"1909.3","Monthly Interest":"291.23","Monthly Principal":"1618.07"},{"MONTH":"7","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"219.53","Monthly Principal":"1307.91"},{"MONTH":"8","YEAR":"2012","Monthly Payments":"1909.3","Monthly Interest":"257.41","Monthly Principal":"1651.89"},{"MONTH":"9","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"192.19","Monthly Principal":"1335.25"},{"MONTH":"10","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"179.85","Monthly Principal":"1347.58"},{"MONTH":"11","YEAR":"2012","Monthly Payments":"1909.3","Monthly Interest":"207.3","Monthly Principal":"1702"},{"MONTH":"12","YEAR":"2012","Monthly Payments":"1527.44","Monthly Interest":"151.68","Monthly Principal":"1375.75"},{"MONTH":"1","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"138.97","Monthly Principal":"1388.46"},{"MONTH":"2","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"126.15","Monthly Principal":"1401.29"},{"MONTH":"3","YEAR":"2013","Monthly Payments":"1909.3","Monthly Interest":"139.47","Monthly Principal":"1769.83"},{"MONTH":"4","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"96.86","Monthly Principal":"1430.58"},{"MONTH":"5","YEAR":"2013","Monthly Payments":"1909.3","Monthly Interest":"102.47","Monthly Principal":"1806.82"},{"MONTH":"6","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"66.95","Monthly Principal":"1460.49"},{"MONTH":"7","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"53.46","Monthly Principal":"1473.98"},{"MONTH":"8","YEAR":"2013","Monthly Payments":"1909.3","Monthly Interest":"47.66","Monthly Principal":"1861.63"},{"MONTH":"9","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"22.65","Monthly Principal":"1504.79"},{"MONTH":"10","YEAR":"2013","Monthly Payments":"1527.44","Monthly Interest":"8.75","Monthly Principal":"1518.69"}]}
This is an example of a loan with an odd first period with the same payment for every period where the interest is calculated using the actual number of days in the period divided by 360.
SELECT *
FROM wct.AMORTSCHED( 50000, --Loan Amount
'11/01/2010', --Loan Start Date
.12, --Annual Interest Rate
'04/15/2011', --First Payment Date
60, --Number of payments (5*12)
12, --Number of payments per year
365360, --Days in year (defaults to 360)
NULL, --FV (defaults to 0)
'A' --IntRule (defaults to 'A' meaning actuarial)
);
This produces the following result.
{"columns":[{"field":"num_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"date_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_init","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_pmt","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_pay","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_int_def","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"amt_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","date_pmt":"2010-11-01 00:00:00.000","amt_prin_init":"0","amt_pmt":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_int_def":"0","amt_prin_end":"50000"},{"num_pmt":"1","date_pmt":"2011-04-15 00:00:00.000","amt_prin_init":"50000","amt_pmt":"1166.49141780498","amt_int_pay":"2750","amt_prin_pay":"-1583.50858219502","amt_int_def":"0","amt_prin_end":"51583.508582195"},{"num_pmt":"2","date_pmt":"2011-05-15 00:00:00.000","amt_prin_init":"51583.508582195","amt_pmt":"1166.49141780498","amt_int_pay":"515.83508582195","amt_prin_pay":"650.656331983033","amt_int_def":"0","amt_prin_end":"50932.852250212"},{"num_pmt":"3","date_pmt":"2011-06-15 00:00:00.000","amt_prin_init":"50932.852250212","amt_pmt":"1166.49141780498","amt_int_pay":"526.306139918857","amt_prin_pay":"640.185277886126","amt_int_def":"0","amt_prin_end":"50292.6669723259"},{"num_pmt":"4","date_pmt":"2011-07-15 00:00:00.000","amt_prin_init":"50292.6669723259","amt_pmt":"1166.49141780498","amt_int_pay":"502.926669723259","amt_prin_pay":"663.564748081725","amt_int_def":"0","amt_prin_end":"49629.1022242441"},{"num_pmt":"5","date_pmt":"2011-08-15 00:00:00.000","amt_prin_init":"49629.1022242441","amt_pmt":"1166.49141780498","amt_int_pay":"512.834056317189","amt_prin_pay":"653.657361487794","amt_int_def":"0","amt_prin_end":"48975.4448627563"},{"num_pmt":"6","date_pmt":"2011-09-15 00:00:00.000","amt_prin_init":"48975.4448627563","amt_pmt":"1166.49141780498","amt_int_pay":"506.079596915149","amt_prin_pay":"660.411820889834","amt_int_def":"0","amt_prin_end":"48315.0330418665"},{"num_pmt":"7","date_pmt":"2011-10-15 00:00:00.000","amt_prin_init":"48315.0330418665","amt_pmt":"1166.49141780498","amt_int_pay":"483.150330418665","amt_prin_pay":"683.341087386318","amt_int_def":"0","amt_prin_end":"47631.6919544802"},{"num_pmt":"8","date_pmt":"2011-11-15 00:00:00.000","amt_prin_init":"47631.6919544802","amt_pmt":"1166.49141780498","amt_int_pay":"492.194150196295","amt_prin_pay":"674.297267608688","amt_int_def":"0","amt_prin_end":"46957.3946868715"},{"num_pmt":"9","date_pmt":"2011-12-15 00:00:00.000","amt_prin_init":"46957.3946868715","amt_pmt":"1166.49141780498","amt_int_pay":"469.573946868715","amt_prin_pay":"696.917470936268","amt_int_def":"0","amt_prin_end":"46260.4772159352"},{"num_pmt":"10","date_pmt":"2012-01-15 00:00:00.000","amt_prin_init":"46260.4772159352","amt_pmt":"1166.49141780498","amt_int_pay":"478.024931231331","amt_prin_pay":"688.466486573653","amt_int_def":"0","amt_prin_end":"45572.0107293616"},{"num_pmt":"11","date_pmt":"2012-02-15 00:00:00.000","amt_prin_init":"45572.0107293616","amt_pmt":"1166.49141780498","amt_int_pay":"470.910777536736","amt_prin_pay":"695.580640268247","amt_int_def":"0","amt_prin_end":"44876.4300890933"},{"num_pmt":"12","date_pmt":"2012-03-15 00:00:00.000","amt_prin_init":"44876.4300890933","amt_pmt":"1166.49141780498","amt_int_pay":"433.805490861235","amt_prin_pay":"732.685926943748","amt_int_def":"0","amt_prin_end":"44143.7441621496"},{"num_pmt":"13","date_pmt":"2012-04-15 00:00:00.000","amt_prin_init":"44143.7441621496","amt_pmt":"1166.49141780498","amt_int_pay":"456.152023008879","amt_prin_pay":"710.339394796104","amt_int_def":"0","amt_prin_end":"43433.4047673535"},{"num_pmt":"14","date_pmt":"2012-05-15 00:00:00.000","amt_prin_init":"43433.4047673535","amt_pmt":"1166.49141780498","amt_int_pay":"434.334047673535","amt_prin_pay":"732.157370131449","amt_int_def":"0","amt_prin_end":"42701.247397222"},{"num_pmt":"15","date_pmt":"2012-06-15 00:00:00.000","amt_prin_init":"42701.247397222","amt_pmt":"1166.49141780498","amt_int_pay":"441.246223104628","amt_prin_pay":"725.245194700356","amt_int_def":"0","amt_prin_end":"41976.0022025217"},{"num_pmt":"16","date_pmt":"2012-07-15 00:00:00.000","amt_prin_init":"41976.0022025217","amt_pmt":"1166.49141780498","amt_int_pay":"419.760022025217","amt_prin_pay":"746.731395779767","amt_int_def":"0","amt_prin_end":"41229.2708067419"},{"num_pmt":"17","date_pmt":"2012-08-15 00:00:00.000","amt_prin_init":"41229.2708067419","amt_pmt":"1166.49141780498","amt_int_pay":"426.035798336333","amt_prin_pay":"740.45561946865","amt_int_def":"0","amt_prin_end":"40488.8151872732"},{"num_pmt":"18","date_pmt":"2012-09-15 00:00:00.000","amt_prin_init":"40488.8151872732","amt_pmt":"1166.49141780498","amt_int_pay":"418.384423601824","amt_prin_pay":"748.10699420316","amt_int_def":"0","amt_prin_end":"39740.7081930701"},{"num_pmt":"19","date_pmt":"2012-10-15 00:00:00.000","amt_prin_init":"39740.7081930701","amt_pmt":"1166.49141780498","amt_int_pay":"397.407081930701","amt_prin_pay":"769.084335874282","amt_int_def":"0","amt_prin_end":"38971.6238571958"},{"num_pmt":"20","date_pmt":"2012-11-15 00:00:00.000","amt_prin_init":"38971.6238571958","amt_pmt":"1166.49141780498","amt_int_pay":"402.70677985769","amt_prin_pay":"763.784637947293","amt_int_def":"0","amt_prin_end":"38207.8392192485"},{"num_pmt":"21","date_pmt":"2012-12-15 00:00:00.000","amt_prin_init":"38207.8392192485","amt_pmt":"1166.49141780498","amt_int_pay":"382.078392192485","amt_prin_pay":"784.413025612498","amt_int_def":"0","amt_prin_end":"37423.426193636"},{"num_pmt":"22","date_pmt":"2013-01-15 00:00:00.000","amt_prin_init":"37423.426193636","amt_pmt":"1166.49141780498","amt_int_pay":"386.708737334239","amt_prin_pay":"779.782680470744","amt_int_def":"0","amt_prin_end":"36643.6435131653"},{"num_pmt":"23","date_pmt":"2013-02-15 00:00:00.000","amt_prin_init":"36643.6435131653","amt_pmt":"1166.49141780498","amt_int_pay":"378.650982969374","amt_prin_pay":"787.840434835609","amt_int_def":"0","amt_prin_end":"35855.8030783297"},{"num_pmt":"24","date_pmt":"2013-03-15 00:00:00.000","amt_prin_init":"35855.8030783297","amt_pmt":"1166.49141780498","amt_int_pay":"334.65416206441","amt_prin_pay":"831.837255740573","amt_int_def":"0","amt_prin_end":"35023.9658225891"},{"num_pmt":"25","date_pmt":"2013-04-15 00:00:00.000","amt_prin_init":"35023.9658225891","amt_pmt":"1166.49141780498","amt_int_pay":"361.914313500087","amt_prin_pay":"804.577104304896","amt_int_def":"0","amt_prin_end":"34219.3887182842"},{"num_pmt":"26","date_pmt":"2013-05-15 00:00:00.000","amt_prin_init":"34219.3887182842","amt_pmt":"1166.49141780498","amt_int_pay":"342.193887182842","amt_prin_pay":"824.297530622141","amt_int_def":"0","amt_prin_end":"33395.0911876621"},{"num_pmt":"27","date_pmt":"2013-06-15 00:00:00.000","amt_prin_init":"33395.0911876621","amt_pmt":"1166.49141780498","amt_int_pay":"345.082608939175","amt_prin_pay":"821.408808865809","amt_int_def":"0","amt_prin_end":"32573.6823787962"},{"num_pmt":"28","date_pmt":"2013-07-15 00:00:00.000","amt_prin_init":"32573.6823787962","amt_pmt":"1166.49141780498","amt_int_pay":"325.736823787962","amt_prin_pay":"840.754594017021","amt_int_def":"0","amt_prin_end":"31732.9277847792"},{"num_pmt":"29","date_pmt":"2013-08-15 00:00:00.000","amt_prin_init":"31732.9277847792","amt_pmt":"1166.49141780498","amt_int_pay":"327.906920442719","amt_prin_pay":"838.584497362265","amt_int_def":"0","amt_prin_end":"30894.343287417"},{"num_pmt":"30","date_pmt":"2013-09-15 00:00:00.000","amt_prin_init":"30894.343287417","amt_pmt":"1166.49141780498","amt_int_pay":"319.241547303309","amt_prin_pay":"847.249870501675","amt_int_def":"0","amt_prin_end":"30047.0934169153"},{"num_pmt":"31","date_pmt":"2013-10-15 00:00:00.000","amt_prin_init":"30047.0934169153","amt_pmt":"1166.49141780498","amt_int_pay":"300.470934169153","amt_prin_pay":"866.02048363583","amt_int_def":"0","amt_prin_end":"29181.0729332795"},{"num_pmt":"32","date_pmt":"2013-11-15 00:00:00.000","amt_prin_init":"29181.0729332795","amt_pmt":"1166.49141780498","amt_int_pay":"301.537753643888","amt_prin_pay":"864.953664161096","amt_int_def":"0","amt_prin_end":"28316.1192691184"},{"num_pmt":"33","date_pmt":"2013-12-15 00:00:00.000","amt_prin_init":"28316.1192691184","amt_pmt":"1166.49141780498","amt_int_pay":"283.161192691184","amt_prin_pay":"883.3302251138","amt_int_def":"0","amt_prin_end":"27432.7890440046"},{"num_pmt":"34","date_pmt":"2014-01-15 00:00:00.000","amt_prin_init":"27432.7890440046","amt_pmt":"1166.49141780498","amt_int_pay":"283.472153454714","amt_prin_pay":"883.01926435027","amt_int_def":"0","amt_prin_end":"26549.7697796543"},{"num_pmt":"35","date_pmt":"2014-02-15 00:00:00.000","amt_prin_init":"26549.7697796543","amt_pmt":"1166.49141780498","amt_int_pay":"274.347621056428","amt_prin_pay":"892.143796748556","amt_int_def":"0","amt_prin_end":"25657.6259829057"},{"num_pmt":"36","date_pmt":"2014-03-15 00:00:00.000","amt_prin_init":"25657.6259829057","amt_pmt":"1166.49141780498","amt_int_pay":"239.471175840453","amt_prin_pay":"927.02024196453","amt_int_def":"0","amt_prin_end":"24730.6057409412"},{"num_pmt":"37","date_pmt":"2014-04-15 00:00:00.000","amt_prin_init":"24730.6057409412","amt_pmt":"1166.49141780498","amt_int_pay":"255.549592656392","amt_prin_pay":"910.941825148591","amt_int_def":"0","amt_prin_end":"23819.6639157926"},{"num_pmt":"38","date_pmt":"2014-05-15 00:00:00.000","amt_prin_init":"23819.6639157926","amt_pmt":"1166.49141780498","amt_int_pay":"238.196639157926","amt_prin_pay":"928.294778647057","amt_int_def":"0","amt_prin_end":"22891.3691371456"},{"num_pmt":"39","date_pmt":"2014-06-15 00:00:00.000","amt_prin_init":"22891.3691371456","amt_pmt":"1166.49141780498","amt_int_pay":"236.544147750504","amt_prin_pay":"929.947270054479","amt_int_def":"0","amt_prin_end":"21961.4218670911"},{"num_pmt":"40","date_pmt":"2014-07-15 00:00:00.000","amt_prin_init":"21961.4218670911","amt_pmt":"1166.49141780498","amt_int_pay":"219.614218670911","amt_prin_pay":"946.877199134073","amt_int_def":"0","amt_prin_end":"21014.544667957"},{"num_pmt":"41","date_pmt":"2014-08-15 00:00:00.000","amt_prin_init":"21014.544667957","amt_pmt":"1166.49141780498","amt_int_pay":"217.150294902222","amt_prin_pay":"949.341122902761","amt_int_def":"0","amt_prin_end":"20065.2035450542"},{"num_pmt":"42","date_pmt":"2014-09-15 00:00:00.000","amt_prin_init":"20065.2035450542","amt_pmt":"1166.49141780498","amt_int_pay":"207.340436632227","amt_prin_pay":"959.150981172756","amt_int_def":"0","amt_prin_end":"19106.0525638815"},{"num_pmt":"43","date_pmt":"2014-10-15 00:00:00.000","amt_prin_init":"19106.0525638815","amt_pmt":"1166.49141780498","amt_int_pay":"191.060525638815","amt_prin_pay":"975.430892166168","amt_int_def":"0","amt_prin_end":"18130.6216717153"},{"num_pmt":"44","date_pmt":"2014-11-15 00:00:00.000","amt_prin_init":"18130.6216717153","amt_pmt":"1166.49141780498","amt_int_pay":"187.349757274392","amt_prin_pay":"979.141660530592","amt_int_def":"0","amt_prin_end":"17151.4800111847"},{"num_pmt":"45","date_pmt":"2014-12-15 00:00:00.000","amt_prin_init":"17151.4800111847","amt_pmt":"1166.49141780498","amt_int_pay":"171.514800111847","amt_prin_pay":"994.976617693136","amt_int_def":"0","amt_prin_end":"16156.5033934916"},{"num_pmt":"46","date_pmt":"2015-01-15 00:00:00.000","amt_prin_init":"16156.5033934916","amt_pmt":"1166.49141780498","amt_int_pay":"166.95053506608","amt_prin_pay":"999.540882738904","amt_int_def":"0","amt_prin_end":"15156.9625107527"},{"num_pmt":"47","date_pmt":"2015-02-15 00:00:00.000","amt_prin_init":"15156.9625107527","amt_pmt":"1166.49141780498","amt_int_pay":"156.621945944444","amt_prin_pay":"1009.86947186054","amt_int_def":"0","amt_prin_end":"14147.0930388921"},{"num_pmt":"48","date_pmt":"2015-03-15 00:00:00.000","amt_prin_init":"14147.0930388921","amt_pmt":"1166.49141780498","amt_int_pay":"132.03953502966","amt_prin_pay":"1034.45188277532","amt_int_def":"0","amt_prin_end":"13112.6411561168"},{"num_pmt":"49","date_pmt":"2015-04-15 00:00:00.000","amt_prin_init":"13112.6411561168","amt_pmt":"1166.49141780498","amt_int_pay":"135.49729194654","amt_prin_pay":"1030.99412585844","amt_int_def":"0","amt_prin_end":"12081.6470302584"},{"num_pmt":"50","date_pmt":"2015-05-15 00:00:00.000","amt_prin_init":"12081.6470302584","amt_pmt":"1166.49141780498","amt_int_pay":"120.816470302584","amt_prin_pay":"1045.6749475024","amt_int_def":"0","amt_prin_end":"11035.972082756"},{"num_pmt":"51","date_pmt":"2015-06-15 00:00:00.000","amt_prin_init":"11035.972082756","amt_pmt":"1166.49141780498","amt_int_pay":"114.038378188478","amt_prin_pay":"1052.4530396165","amt_int_def":"0","amt_prin_end":"9983.51904313947"},{"num_pmt":"52","date_pmt":"2015-07-15 00:00:00.000","amt_prin_init":"9983.51904313947","amt_pmt":"1166.49141780498","amt_int_pay":"99.8351904313947","amt_prin_pay":"1066.65622737359","amt_int_def":"0","amt_prin_end":"8916.86281576589"},{"num_pmt":"53","date_pmt":"2015-08-15 00:00:00.000","amt_prin_init":"8916.86281576589","amt_pmt":"1166.49141780498","amt_int_pay":"92.1409157629141","amt_prin_pay":"1074.35050204207","amt_int_def":"0","amt_prin_end":"7842.51231372382"},{"num_pmt":"54","date_pmt":"2015-09-15 00:00:00.000","amt_prin_init":"7842.51231372382","amt_pmt":"1166.49141780498","amt_int_pay":"81.0392939084794","amt_prin_pay":"1085.4521238965","amt_int_def":"0","amt_prin_end":"6757.06018982731"},{"num_pmt":"55","date_pmt":"2015-10-15 00:00:00.000","amt_prin_init":"6757.06018982731","amt_pmt":"1166.49141780498","amt_int_pay":"67.5706018982731","amt_prin_pay":"1098.92081590671","amt_int_def":"0","amt_prin_end":"5658.1393739206"},{"num_pmt":"56","date_pmt":"2015-11-15 00:00:00.000","amt_prin_init":"5658.1393739206","amt_pmt":"1166.49141780498","amt_int_pay":"58.4674401971796","amt_prin_pay":"1108.0239776078","amt_int_def":"0","amt_prin_end":"4550.1153963128"},{"num_pmt":"57","date_pmt":"2015-12-15 00:00:00.000","amt_prin_init":"4550.1153963128","amt_pmt":"1166.49141780498","amt_int_pay":"45.501153963128","amt_prin_pay":"1120.99026384186","amt_int_def":"0","amt_prin_end":"3429.12513247094"},{"num_pmt":"58","date_pmt":"2016-01-15 00:00:00.000","amt_prin_init":"3429.12513247094","amt_pmt":"1166.49141780498","amt_int_pay":"35.4342930355331","amt_prin_pay":"1131.05712476945","amt_int_def":"0","amt_prin_end":"2298.06800770149"},{"num_pmt":"59","date_pmt":"2016-02-15 00:00:00.000","amt_prin_init":"2298.06800770149","amt_pmt":"1166.49141780498","amt_int_pay":"23.7467027462488","amt_prin_pay":"1142.74471505873","amt_int_def":"0","amt_prin_end":"1155.32329264276"},{"num_pmt":"60","date_pmt":"2016-03-15 00:00:00.000","amt_prin_init":"1155.32329264276","amt_pmt":"1166.49141780498","amt_int_pay":"11.1681251622133","amt_prin_pay":"1155.32329264277","amt_int_def":"0","amt_prin_end":"-1.00044417195022E-11"}]}