EXCEL VBA 金融建模 - 貸款支付計算器(Eng)
It calculates your car loan payments and generates a payment schedule.You can also investigate how changing your loan conditions (such as the paymentfrequency or the term) affects the payment.
The spreadsheet is easy to use and navigate; required parameters arehighlighted, and drop-down menus let you change the payment frequency andcompounding period.
Just enter the loan amount, interest rate, loan term, first paymentdate, payment frequency and loan compounding period
AAfter you click a button, the spreadsheet calculates your
- interest rate per payment
- payment amount
- the date of the final payment
- and the total interest and principal paid at the end of the loan
連結
http://investexcel.net/wp-content/uploads/2015/04/Auto-Loan-Payment-Calculator2.zip
由於上載附件過久也未能上傳得到,所以我只給連結了