Sunday, May 4, 2008

Excel Simple Loan Calculator

Below is a simple (yet complete) Excel loan calculator. I developed this spreadsheet for auto loans, and focus was placed on the payment calculation. I added a VB6 macro which will put you in control of Excel's Goal Seek function, to find target values for the various variables involved.

-Loan_Pmt.xls-

0 Comments:

Post a Comment

<< Home