我想問下點解我用EXCEL計Monthly payment時,個答案會孌左係紅色?
同埋點解我計total interest cost時個答案係(13,408,612.49)但我看書個答案係
(408,612.49)?
total interest cost =(total repayment -loan payment)
資料如下:
Monthly repayment :$191,905.90
Interest rate 4.00%
Years:3
Loan amount:$6500000
excel!!!!!!!!!!!!!!!!!!!!!!
2010-12-14 7:36 am
回答 (1)
2010-12-14 8:06 pm
✔ 最佳答案
red means negative value, you are required to repay the debt so it is red.13,408,612.49 is the total payment amount so you need to deduct the loan amount.
收錄日期: 2021-04-13 17:42:01
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20101213000051KK01610