EXCEL VBA 金融建模 - 貸款支付計算器(Eng)

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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

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

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：EXCEL 金融建模 xcel exce eng