当前位置：文江博客话题详情

excel cumipmt 公式到 Coldfusion

发布于 2024-11-30 15:00:08 字数 135 浏览 0 评论 0原文

我正在尝试在coldfusion中复制excel的cumipmt公式（开始期和结束期之间贷款支付的累积利息）。

Excel 的版本采用利率、nper [付款期总数]、现值、开始、结束和类型 [等于 0]。

有人有方程式吗？

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

错々过的事 2024-12-07 15:00:08

我不认为这只是一个可以找到两个时期之间支付的累积利息的方程式或公式。这是你必须做的

a) Find the monthly payment keeping in view whether the payment is made at the end or at the beginning of period [PMT]
b) Find the total interest paid by the end period
1. Find the outstanding principal by the end period [OP_E]
2. Find the total principal paid by the end period [TP_E] = PV - [OP_E]
3. Find the total amount paid by the end period [TA_E] = PMT x end
4. Find the total interest paid by the end period [TI_E] = [TA_E] - [TP_E]
c) Find the total interest paid by the start period minus 1
1. Find the outstanding principal by the start period [OP_S-1]
2. Find the total principal paid by the start period [TP_S-1] = PV - [OP_S-1]
3. Find the total amount paid by the start period [TA_S-1] = PMT x start - 1
4. Find the total interest paid by the start period [TI_S-1] = [TA_S-1] - [TP_S-1]
d) Now find the CUMIPMT = [TI_E] - [TI_S-1]

这个CUMIPMT计算器使用上述或类似的计算累积的算法贷款利息

I don't think it is just a single equation or formula with which you can find cumulative interest paid between two periods. This is what you have to do

a) Find the monthly payment keeping in view whether the payment is made at the end or at the beginning of period [PMT]
b) Find the total interest paid by the end period
1. Find the outstanding principal by the end period [OP_E]
2. Find the total principal paid by the end period [TP_E] = PV - [OP_E]
3. Find the total amount paid by the end period [TA_E] = PMT x end
4. Find the total interest paid by the end period [TI_E] = [TA_E] - [TP_E]
c) Find the total interest paid by the start period minus 1
1. Find the outstanding principal by the start period [OP_S-1]
2. Find the total principal paid by the start period [TP_S-1] = PV - [OP_S-1]
3. Find the total amount paid by the start period [TA_S-1] = PMT x start - 1
4. Find the total interest paid by the start period [TI_S-1] = [TA_S-1] - [TP_S-1]
d) Now find the CUMIPMT = [TI_E] - [TI_S-1]

This CUMIPMT Calculator uses the above or similar algorithm to calculate the cumulative interest paid on a loan

回复收藏 0 原文

~没有更多了~