ODDFPMTSCHED
Updated 2023-10-06 21:42:47.807000
Syntax
SELECT * FROM [wct].[ODDFPMTSCHED](
<@Rate, float,>
,<@Nper, int,>
,<@PV, float,>
,<@FV, float,>
,<@FirstPeriod, float,>)
Description
Use the table-valued function ODDFPMTSCHED to generate an amortization schedule for an annuity where the first period is either longer or shorter than all the other periods.
Arguments
@FirstPeriod
the length of the first period. @FirstPeriod is an expression of type float or of a type that can be implicitly converted to float.
@Rate
the periodic interest rate. @Rate is an expression of type float or of a type that can be implicitly converted to float.
@FV
the future value as at the end of the annuity. @FV is an expression of type float or of a type that can be implicitly converted to float.
@Nper
the number of annuity payments. @Nper is an expression of type int or of a type that can be implicitly converted to int.
@PV
the present value of the annuity. @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": "ae105014-8fc0-4f0c-aa9d-566405d4ad78", "colName": "num_pmt", "colDatatype": "int", "colDesc": "Payment number"}, {"id": "1f789149-b16f-4054-a6b8-dd4d3073d275", "colName": "amt_prin_init", "colDatatype": "float", "colDesc": "\t Initial principal amount; amt_prin_end from the previous row"}, {"id": "90043a23-2e68-4545-85a4-6ed659ef1c07", "colName": "amt_int_pay", "colDatatype": "float", "colDesc": "\t Interest portion of the periodic payment"}, {"id": "e96fc891-74bc-4c98-be35-976793f844be", "colName": "amt_prin_pay", "colDatatype": "float", "colDesc": "\t Principal portion of the periodic payment"}, {"id": "0f7a556c-4d62-465b-80e8-bd5d2dcccf9f", "colName": "amt_prin_end", "colDatatype": "float", "colDesc": "Ending principal amount; amt_prin_init \u2013 amt_prin_pay"}]}
Remarks
If @Rate <= -1 then no rows are returned.
If @Nper < 1 then no rows are returned.
If @FirstPeriod <= 0 then no rows are returned.
If @Nper is NULL then @Nper = 1.
If @Rate is NULL then @Rate = 0.
If @PV is NULL then @PV = 0.
If @FV is NULL then @FV = 0.
If @FirstPeriod is NULL then @FirstPeriod = 1.
amt_prin_pay for the final period includes @FV so that the amt_prin_end for the final period is zero.
ODDFPMTSCHED uses the same conventions for the sign of the inputs and the results as Excel and Google spreadsheets; generally @PV and @FV should have opposite signs and the periodic interest and principal payments will have the opposite sign of @PV.
Examples
Generate a payment schedule for an annuity assuming a periodic rate of 0.5%, with 36 periodic payments. The price of the annuity is 11,500 and there is no cash value at the end of the annuity. The first period is 1 and 5/6th longer than the other periods.
SELECT *
FROM wct.ODDFPMTSCHED( .005, --@Rate
36, --@Nper
-11500, --@PV
0, --@FV
1 + 5 / 6e+00 --@FirstPeriod
);
This produces the following result.
{"columns":[{"field":"num_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_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_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","amt_prin_init":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_prin_end":"11500"},{"num_pmt":"1","amt_prin_init":"11500","amt_int_pay":"105.416666666668","amt_prin_pay":"245.886079534899","amt_prin_end":"11254.1139204651"},{"num_pmt":"2","amt_prin_init":"11254.1139204651","amt_int_pay":"56.2705696023263","amt_prin_pay":"295.032176599241","amt_prin_end":"10959.0817438659"},{"num_pmt":"3","amt_prin_init":"10959.0817438659","amt_int_pay":"54.795408719338","amt_prin_pay":"296.50733748223","amt_prin_end":"10662.5744063836"},{"num_pmt":"4","amt_prin_init":"10662.5744063836","amt_int_pay":"53.3128720319278","amt_prin_pay":"297.98987416964","amt_prin_end":"10364.584532214"},{"num_pmt":"5","amt_prin_init":"10364.584532214","amt_int_pay":"51.8229226610788","amt_prin_pay":"299.479823540489","amt_prin_end":"10065.1047086735"},{"num_pmt":"6","amt_prin_init":"10065.1047086735","amt_int_pay":"50.3255235433721","amt_prin_pay":"300.977222658195","amt_prin_end":"9764.12748601531"},{"num_pmt":"7","amt_prin_init":"9764.12748601531","amt_int_pay":"48.8206374300848","amt_prin_pay":"302.482108771483","amt_prin_end":"9461.64537724382"},{"num_pmt":"8","amt_prin_init":"9461.64537724382","amt_int_pay":"47.3082268862167","amt_prin_pay":"303.994519315351","amt_prin_end":"9157.65085792847"},{"num_pmt":"9","amt_prin_init":"9157.65085792847","amt_int_pay":"45.7882542896573","amt_prin_pay":"305.51449191191","amt_prin_end":"8852.13636601656"},{"num_pmt":"10","amt_prin_init":"8852.13636601656","amt_int_pay":"44.2606818300924","amt_prin_pay":"307.042064371475","amt_prin_end":"8545.09430164509"},{"num_pmt":"11","amt_prin_init":"8545.09430164509","amt_int_pay":"42.7254715082222","amt_prin_pay":"308.577274693345","amt_prin_end":"8236.51702695174"},{"num_pmt":"12","amt_prin_init":"8236.51702695174","amt_int_pay":"41.1825851347699","amt_prin_pay":"310.120161066798","amt_prin_end":"7926.39686588494"},{"num_pmt":"13","amt_prin_init":"7926.39686588494","amt_int_pay":"39.6319843294318","amt_prin_pay":"311.670761872136","amt_prin_end":"7614.72610401281"},{"num_pmt":"14","amt_prin_init":"7614.72610401281","amt_int_pay":"38.0736305200658","amt_prin_pay":"313.229115681502","amt_prin_end":"7301.49698833131"},{"num_pmt":"15","amt_prin_init":"7301.49698833131","amt_int_pay":"36.5074849416674","amt_prin_pay":"314.7952612599","amt_prin_end":"6986.70172707141"},{"num_pmt":"16","amt_prin_init":"6986.70172707141","amt_int_pay":"34.9335086353599","amt_prin_pay":"316.369237566208","amt_prin_end":"6670.3324895052"},{"num_pmt":"17","amt_prin_init":"6670.3324895052","amt_int_pay":"33.3516624475337","amt_prin_pay":"317.951083754034","amt_prin_end":"6352.38140575117"},{"num_pmt":"18","amt_prin_init":"6352.38140575117","amt_int_pay":"31.7619070287606","amt_prin_pay":"319.540839172807","amt_prin_end":"6032.84056657836"},{"num_pmt":"19","amt_prin_init":"6032.84056657836","amt_int_pay":"30.164202832902","amt_prin_pay":"321.138543368666","amt_prin_end":"5711.70202320969"},{"num_pmt":"20","amt_prin_init":"5711.70202320969","amt_int_pay":"28.5585101160618","amt_prin_pay":"322.744236085506","amt_prin_end":"5388.95778712419"},{"num_pmt":"21","amt_prin_init":"5388.95778712419","amt_int_pay":"26.9447889356293","amt_prin_pay":"324.357957265938","amt_prin_end":"5064.59982985825"},{"num_pmt":"22","amt_prin_init":"5064.59982985825","amt_int_pay":"25.3229991492922","amt_prin_pay":"325.979747052275","amt_prin_end":"4738.62008280597"},{"num_pmt":"23","amt_prin_init":"4738.62008280597","amt_int_pay":"23.6931004140429","amt_prin_pay":"327.609645787525","amt_prin_end":"4411.01043701845"},{"num_pmt":"24","amt_prin_init":"4411.01043701845","amt_int_pay":"22.0550521850978","amt_prin_pay":"329.24769401647","amt_prin_end":"4081.76274300198"},{"num_pmt":"25","amt_prin_init":"4081.76274300198","amt_int_pay":"20.4088137150197","amt_prin_pay":"330.893932486548","amt_prin_end":"3750.86881051543"},{"num_pmt":"26","amt_prin_init":"3750.86881051543","amt_int_pay":"18.7543440525824","amt_prin_pay":"332.548402148985","amt_prin_end":"3418.32040836645"},{"num_pmt":"27","amt_prin_init":"3418.32040836645","amt_int_pay":"17.0916020418299","amt_prin_pay":"334.211144159738","amt_prin_end":"3084.10926420671"},{"num_pmt":"28","amt_prin_init":"3084.10926420671","amt_int_pay":"15.4205463210515","amt_prin_pay":"335.882199880516","amt_prin_end":"2748.22706432619"},{"num_pmt":"29","amt_prin_init":"2748.22706432619","amt_int_pay":"13.7411353216371","amt_prin_pay":"337.56161087993","amt_prin_end":"2410.66545344626"},{"num_pmt":"30","amt_prin_init":"2410.66545344626","amt_int_pay":"12.0533272672383","amt_prin_pay":"339.249418934329","amt_prin_end":"2071.41603451193"},{"num_pmt":"31","amt_prin_init":"2071.41603451193","amt_int_pay":"10.3570801725564","amt_prin_pay":"340.945666029011","amt_prin_end":"1730.47036848292"},{"num_pmt":"32","amt_prin_init":"1730.47036848292","amt_int_pay":"8.65235184242761","amt_prin_pay":"342.65039435914","amt_prin_end":"1387.81997412378"},{"num_pmt":"33","amt_prin_init":"1387.81997412378","amt_int_pay":"6.93909987062329","amt_prin_pay":"344.363646330944","amt_prin_end":"1043.45632779284"},{"num_pmt":"34","amt_prin_init":"1043.45632779284","amt_int_pay":"5.21728163897058","amt_prin_pay":"346.085464562597","amt_prin_end":"697.370863230241"},{"num_pmt":"35","amt_prin_init":"697.370863230241","amt_int_pay":"3.48685431616252","amt_prin_pay":"347.815891885405","amt_prin_end":"349.554971344836"},{"num_pmt":"36","amt_prin_init":"349.554971344836","amt_int_pay":"1.74777485673167","amt_prin_pay":"349.554971344836","amt_prin_end":"0"}]}
In this example we generate a payment schedule for an annuity assuming a periodic rate of 0.5%, with 180 periodic payments. The price of the annuity is 250,000 and there is a 50,000 cash value at the end of the annuity. The first period is one-half as long as the other periods. We will return the last 24 rows.
SELECT *
FROM
(
SELECT TOP 24
*
FROM wct.ODDFPMTSCHED( .005, --@Rate
180, --@Nper
-250000, --@PV
50000, --@FV
0.5 --@FirstPeriod
)
ORDER BY num_pmt DESC
) n
ORDER BY 1 ASC;
This produces the following result.
{"columns":[{"field":"num_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_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_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"157","amt_prin_init":"87961.2505481276","amt_int_pay":"439.806252740677","amt_prin_pay":"1492.65953751018","amt_prin_end":"86468.5910106174"},{"num_pmt":"158","amt_prin_init":"86468.5910106174","amt_int_pay":"432.34295505309","amt_prin_pay":"1500.12283519776","amt_prin_end":"84968.4681754197"},{"num_pmt":"159","amt_prin_init":"84968.4681754197","amt_int_pay":"424.842340877153","amt_prin_pay":"1507.6234493737","amt_prin_end":"83460.844726046"},{"num_pmt":"160","amt_prin_init":"83460.844726046","amt_int_pay":"417.304223630247","amt_prin_pay":"1515.16156662061","amt_prin_end":"81945.6831594254"},{"num_pmt":"161","amt_prin_init":"81945.6831594254","amt_int_pay":"409.728415797149","amt_prin_pay":"1522.7373744537","amt_prin_end":"80422.9457849717"},{"num_pmt":"162","amt_prin_init":"80422.9457849717","amt_int_pay":"402.114728924895","amt_prin_pay":"1530.35106132596","amt_prin_end":"78892.5947236457"},{"num_pmt":"163","amt_prin_init":"78892.5947236457","amt_int_pay":"394.462973618259","amt_prin_pay":"1538.00281663259","amt_prin_end":"77354.5919070131"},{"num_pmt":"164","amt_prin_init":"77354.5919070131","amt_int_pay":"386.772959535145","amt_prin_pay":"1545.69283071571","amt_prin_end":"75808.8990762974"},{"num_pmt":"165","amt_prin_init":"75808.8990762974","amt_int_pay":"379.044495381521","amt_prin_pay":"1553.42129486933","amt_prin_end":"74255.4777814281"},{"num_pmt":"166","amt_prin_init":"74255.4777814281","amt_int_pay":"371.277388907144","amt_prin_pay":"1561.18840134371","amt_prin_end":"72694.2893800844"},{"num_pmt":"167","amt_prin_init":"72694.2893800844","amt_int_pay":"363.471446900487","amt_prin_pay":"1568.99434335036","amt_prin_end":"71125.295036734"},{"num_pmt":"168","amt_prin_init":"71125.295036734","amt_int_pay":"355.626475183705","amt_prin_pay":"1576.83931506715","amt_prin_end":"69548.4557216669"},{"num_pmt":"169","amt_prin_init":"69548.4557216669","amt_int_pay":"347.742278608367","amt_prin_pay":"1584.72351164249","amt_prin_end":"67963.7322100244"},{"num_pmt":"170","amt_prin_init":"67963.7322100244","amt_int_pay":"339.818661050162","amt_prin_pay":"1592.64712920069","amt_prin_end":"66371.0850808237"},{"num_pmt":"171","amt_prin_init":"66371.0850808237","amt_int_pay":"331.855425404098","amt_prin_pay":"1600.61036484675","amt_prin_end":"64770.4747159769"},{"num_pmt":"172","amt_prin_init":"64770.4747159769","amt_int_pay":"323.852373579972","amt_prin_pay":"1608.61341667088","amt_prin_end":"63161.8612993061"},{"num_pmt":"173","amt_prin_init":"63161.8612993061","amt_int_pay":"315.809306496562","amt_prin_pay":"1616.65648375429","amt_prin_end":"61545.2048155518"},{"num_pmt":"174","amt_prin_init":"61545.2048155518","amt_int_pay":"307.726024077795","amt_prin_pay":"1624.73976617306","amt_prin_end":"59920.4650493787"},{"num_pmt":"175","amt_prin_init":"59920.4650493787","amt_int_pay":"299.602325246877","amt_prin_pay":"1632.86346500397","amt_prin_end":"58287.6015843747"},{"num_pmt":"176","amt_prin_init":"58287.6015843747","amt_int_pay":"291.438007921931","amt_prin_pay":"1641.02778232892","amt_prin_end":"56646.5738020458"},{"num_pmt":"177","amt_prin_init":"56646.5738020458","amt_int_pay":"283.232869010248","amt_prin_pay":"1649.2329212406","amt_prin_end":"54997.3408808052"},{"num_pmt":"178","amt_prin_init":"54997.3408808052","amt_int_pay":"274.986704404055","amt_prin_pay":"1657.4790858468","amt_prin_end":"53339.8617949584"},{"num_pmt":"179","amt_prin_init":"53339.8617949584","amt_int_pay":"266.699308974847","amt_prin_pay":"1665.766481276","amt_prin_end":"51674.0953136824"},{"num_pmt":"180","amt_prin_init":"51674.0953136824","amt_int_pay":"258.370476568449","amt_prin_pay":"51674.0953136824","amt_prin_end":"0"}]}
In this example we c alculate the weekly payment for an automobile lease with a term of 3 years and an annual interest rate of 25%. The amount to be financed is 11,000 and the residual value at the end of the lease is 3,500. The first payment is due 2014-11-25 and we will return the first 52 payments.
SELECT TOP 53
*
FROM wct.ODDFPMTSCHED( .25 * 7 / 365e+00,
--@Rate
156,
--@Nper
-11000, --@PV
3500, --@FV
DATEDIFF(d, '2014-11-13', '2014-11-25') / 7e+00
--@FirstPeriod
)
ORDER BY num_pmt ASC;
This produces the following result.
{"columns":[{"field":"num_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_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_prin_end","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"num_pmt":"0","amt_prin_init":"0","amt_int_pay":"0","amt_prin_pay":"0","amt_prin_end":"11000"},{"num_pmt":"1","amt_prin_init":"11000","amt_int_pay":"90.4109589041082","amt_prin_pay":"-4.90130154744293","amt_prin_end":"11004.9013015474"},{"num_pmt":"2","amt_prin_init":"11004.9013015474","amt_int_pay":"52.76322541838","amt_prin_pay":"32.7464319382852","amt_prin_end":"10972.1548696092"},{"num_pmt":"3","amt_prin_init":"10972.1548696092","amt_int_pay":"52.6062219775786","amt_prin_pay":"32.9034353790867","amt_prin_end":"10939.2514342301"},{"num_pmt":"4","amt_prin_init":"10939.2514342301","amt_int_pay":"52.4484657805561","amt_prin_pay":"33.0611915761092","amt_prin_end":"10906.190242654"},{"num_pmt":"5","amt_prin_init":"10906.190242654","amt_int_pay":"52.2899532182028","amt_prin_pay":"33.2197041384625","amt_prin_end":"10872.9705385155"},{"num_pmt":"6","amt_prin_init":"10872.9705385155","amt_int_pay":"52.1306806641178","amt_prin_pay":"33.3789766925474","amt_prin_end":"10839.591561823"},{"num_pmt":"7","amt_prin_init":"10839.591561823","amt_int_pay":"51.9706444744925","amt_prin_pay":"33.5390128821728","amt_prin_end":"10806.0525489408"},{"num_pmt":"8","amt_prin_init":"10806.0525489408","amt_int_pay":"51.8098409880741","amt_prin_pay":"33.6998163685912","amt_prin_end":"10772.3527325722"},{"num_pmt":"9","amt_prin_init":"10772.3527325722","amt_int_pay":"51.6482665260292","amt_prin_pay":"33.8613908306361","amt_prin_end":"10738.4913417416"},{"num_pmt":"10","amt_prin_init":"10738.4913417416","amt_int_pay":"51.4859173919131","amt_prin_pay":"34.0237399647522","amt_prin_end":"10704.4676017768"},{"num_pmt":"11","amt_prin_init":"10704.4676017768","amt_int_pay":"51.3227898715332","amt_prin_pay":"34.1868674851321","amt_prin_end":"10670.2807342917"},{"num_pmt":"12","amt_prin_init":"10670.2807342917","amt_int_pay":"51.1588802329052","amt_prin_pay":"34.3507771237601","amt_prin_end":"10635.9299571679"},{"num_pmt":"13","amt_prin_init":"10635.9299571679","amt_int_pay":"50.994184726148","amt_prin_pay":"34.5154726305173","amt_prin_end":"10601.4144845374"},{"num_pmt":"14","amt_prin_init":"10601.4144845374","amt_int_pay":"50.8286995833997","amt_prin_pay":"34.6809577732656","amt_prin_end":"10566.7335267641"},{"num_pmt":"15","amt_prin_init":"10566.7335267641","amt_int_pay":"50.662421018732","amt_prin_pay":"34.8472363379333","amt_prin_end":"10531.8862904262"},{"num_pmt":"16","amt_prin_init":"10531.8862904262","amt_int_pay":"50.4953452280707","amt_prin_pay":"35.0143121285946","amt_prin_end":"10496.8719782976"},{"num_pmt":"17","amt_prin_init":"10496.8719782976","amt_int_pay":"50.3274683890968","amt_prin_pay":"35.1821889675684","amt_prin_end":"10461.68978933"},{"num_pmt":"18","amt_prin_init":"10461.68978933","amt_int_pay":"50.1587866611726","amt_prin_pay":"35.3508706954926","amt_prin_end":"10426.3389186345"},{"num_pmt":"19","amt_prin_init":"10426.3389186345","amt_int_pay":"49.9892961852357","amt_prin_pay":"35.5203611714296","amt_prin_end":"10390.8185574631"},{"num_pmt":"20","amt_prin_init":"10390.8185574631","amt_int_pay":"49.8189930837262","amt_prin_pay":"35.6906642729391","amt_prin_end":"10355.1278931902"},{"num_pmt":"21","amt_prin_init":"10355.1278931902","amt_int_pay":"49.6478734604998","amt_prin_pay":"35.8617838961654","amt_prin_end":"10319.266109294"},{"num_pmt":"22","amt_prin_init":"10319.266109294","amt_int_pay":"49.4759334007259","amt_prin_pay":"36.0337239559394","amt_prin_end":"10283.2323853381"},{"num_pmt":"23","amt_prin_init":"10283.2323853381","amt_int_pay":"49.3031689708032","amt_prin_pay":"36.206488385862","amt_prin_end":"10247.0258969522"},{"num_pmt":"24","amt_prin_init":"10247.0258969522","amt_int_pay":"49.1295762182609","amt_prin_pay":"36.3800811384044","amt_prin_end":"10210.6458158138"},{"num_pmt":"25","amt_prin_init":"10210.6458158138","amt_int_pay":"48.9551511717118","amt_prin_pay":"36.5545061849534","amt_prin_end":"10174.0913096288"},{"num_pmt":"26","amt_prin_init":"10174.0913096288","amt_int_pay":"48.7798898406846","amt_prin_pay":"36.7297675159807","amt_prin_end":"10137.3615421129"},{"num_pmt":"27","amt_prin_init":"10137.3615421129","amt_int_pay":"48.6037882156098","amt_prin_pay":"36.9058691410555","amt_prin_end":"10100.4556729718"},{"num_pmt":"28","amt_prin_init":"10100.4556729718","amt_int_pay":"48.4268422676751","amt_prin_pay":"37.0828150889902","amt_prin_end":"10063.3728578828"},{"num_pmt":"29","amt_prin_init":"10063.3728578828","amt_int_pay":"48.2490479487524","amt_prin_pay":"37.2606094079129","amt_prin_end":"10026.1122484749"},{"num_pmt":"30","amt_prin_init":"10026.1122484749","amt_int_pay":"48.0704011913195","amt_prin_pay":"37.4392561653458","amt_prin_end":"9988.67299230956"},{"num_pmt":"31","amt_prin_init":"9988.67299230956","amt_int_pay":"47.8908979083345","amt_prin_pay":"37.6187594483308","amt_prin_end":"9951.05423286123"},{"num_pmt":"32","amt_prin_init":"9951.05423286123","amt_int_pay":"47.7105339931705","amt_prin_pay":"37.7991233634948","amt_prin_end":"9913.25510949773"},{"num_pmt":"33","amt_prin_init":"9913.25510949773","amt_int_pay":"47.5293053195101","amt_prin_pay":"37.9803520371552","amt_prin_end":"9875.27475746058"},{"num_pmt":"34","amt_prin_init":"9875.27475746058","amt_int_pay":"47.3472077412489","amt_prin_pay":"38.1624496154163","amt_prin_end":"9837.11230784516"},{"num_pmt":"35","amt_prin_init":"9837.11230784516","amt_int_pay":"47.1642370924101","amt_prin_pay":"38.3454202642552","amt_prin_end":"9798.7668875809"},{"num_pmt":"36","amt_prin_init":"9798.7668875809","amt_int_pay":"46.9803891870315","amt_prin_pay":"38.5292681696337","amt_prin_end":"9760.23761941127"},{"num_pmt":"37","amt_prin_init":"9760.23761941127","amt_int_pay":"46.7956598190931","amt_prin_pay":"38.7139975375721","amt_prin_end":"9721.5236218737"},{"num_pmt":"38","amt_prin_init":"9721.5236218737","amt_int_pay":"46.6100447624095","amt_prin_pay":"38.8996125942558","amt_prin_end":"9682.62400927944"},{"num_pmt":"39","amt_prin_init":"9682.62400927944","amt_int_pay":"46.4235397705188","amt_prin_pay":"39.0861175861464","amt_prin_end":"9643.5378916933"},{"num_pmt":"40","amt_prin_init":"9643.5378916933","amt_int_pay":"46.2361405766106","amt_prin_pay":"39.2735167800547","amt_prin_end":"9604.26437491324"},{"num_pmt":"41","amt_prin_init":"9604.26437491324","amt_int_pay":"46.0478428934212","amt_prin_pay":"39.4618144632441","amt_prin_end":"9564.80256045"},{"num_pmt":"42","amt_prin_init":"9564.80256045","amt_int_pay":"45.8586424131181","amt_prin_pay":"39.6510149435471","amt_prin_end":"9525.15154550645"},{"num_pmt":"43","amt_prin_init":"9525.15154550645","amt_int_pay":"45.6685348072233","amt_prin_pay":"39.8411225494419","amt_prin_end":"9485.31042295701"},{"num_pmt":"44","amt_prin_init":"9485.31042295701","amt_int_pay":"45.4775157265058","amt_prin_pay":"40.0321416301595","amt_prin_end":"9445.27828132685"},{"num_pmt":"45","amt_prin_init":"9445.27828132685","amt_int_pay":"45.2855808008836","amt_prin_pay":"40.2240765557817","amt_prin_end":"9405.05420477107"},{"num_pmt":"46","amt_prin_init":"9405.05420477107","amt_int_pay":"45.0927256393125","amt_prin_pay":"40.4169317173528","amt_prin_end":"9364.63727305372"},{"num_pmt":"47","amt_prin_init":"9364.63727305372","amt_int_pay":"44.8989458297101","amt_prin_pay":"40.6107115269551","amt_prin_end":"9324.02656152676"},{"num_pmt":"48","amt_prin_init":"9324.02656152676","amt_int_pay":"44.7042369388264","amt_prin_pay":"40.8054204178388","amt_prin_end":"9283.22114110892"},{"num_pmt":"49","amt_prin_init":"9283.22114110892","amt_int_pay":"44.5085945121673","amt_prin_pay":"41.0010628444979","amt_prin_end":"9242.22007826442"},{"num_pmt":"50","amt_prin_init":"9242.22007826442","amt_int_pay":"44.3120140738711","amt_prin_pay":"41.1976432827942","amt_prin_end":"9201.02243498163"},{"num_pmt":"51","amt_prin_init":"9201.02243498163","amt_int_pay":"44.1144911266247","amt_prin_pay":"41.3951662300406","amt_prin_end":"9159.62726875159"},{"num_pmt":"52","amt_prin_init":"9159.62726875159","amt_int_pay":"43.916021151551","amt_prin_pay":"41.5936362051143","amt_prin_end":"9118.03363254647"}]}
See Also
ODDFIPMT - Interest portion of a periodic payment for an annuity with an odd first period
ODDFPPMT - Principal portion of a periodic payment for an annuity with an odd first period
ODDFPV - Present Value of an annuity with an odd first period
PMTSCHED - Calculate an amortization schedule for a loan with no odd periods.