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-
-Loan_Pmt.xls-
0 Comments:
Post a Comment
<< Home