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

由於上載附件過久也未能上傳得到，所以我只給連結了