excel有個pmt的公式可以知道貸款後每期的還款金額
假設貸款3000萬
設定30年
利率7.8%
excel 的公式為
=pmt(7.8%/12,360,3000萬)
=215,961
因為要將這個公式寫在程式內，估狗後看不太懂
想請教數學神人這個數學式是如何計算呢?
Example:
=PMT(0,3;13;2000;0;1)
Result:
=-477,29
公式:
===============================================================
PMT(number Rate; number Nper; number Pv; number [Fv]; number [Type])
Rate: Interest rate per period.
Nper: Total number of periods.
Pv: Cash value of future payments.
Fv: Final value after the last payment.
The default value is 0.
Type: Maturity of the payments.
The default value is 0.
nper und rate have to be defined in the same time unit.
======================================================================
資料來源: http://doc.optadata.com/en/dokumentation/application/expression/functions/financial.html
內文搜尋
從 APP 打開
X