想不通, 請指教
點樣可以計第一年的 ending balance
rate: 3.75%
years 20
annual payment $161,195
beginning balance $2,240,000
用平時的 formula 唔 work.
i.e. =if( first year <= rate, pv(nper...),0)
excel if + pv + ending balance
2009-06-19 8:17 am
回答 (2)
2009-06-19 9:00 pm
✔ 最佳答案
計本利和, 可用 pmt( ) 函數計本金, 可用 ppmt( ) 函數
計利息, 可用 ipmt( ) 函數
2009-06-19 3:59 pm
annual payment: $161,195
first year interest: = $2,240,000 x 3.75%
= $84,000
Net payment: $161,195 - $84,000
therefore, ending balance of first year
= $2,240,000 - ($161,195 - $84,000)
= $2,162,805
first year interest: = $2,240,000 x 3.75%
= $84,000
Net payment: $161,195 - $84,000
therefore, ending balance of first year
= $2,240,000 - ($161,195 - $84,000)
= $2,162,805
收錄日期: 2021-04-27 13:12:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090619000051KK00029