I need a loan calculator that you can plug in the payment amount

  • Thread starter payment amount loan calculator
  • Start date
P

payment amount loan calculator

I can't find a template that you can plug the payment amount as a fixed
amount and then ihave it calculate the number of payments or the interest
rate...Have you seen one of those?
Ann
 
A

Andy Wiggins

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/Loan_Calculator.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook includes two worksheets that can help you calculate the likely
repayments you will have to make on mortgages and personal loans (including
HP and conditional sale agreements).


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"payment amount loan calculator" <payment amount loan
[email protected]> wrote in message
 
P

payment amount loan calculator

Thank you Andy, but that one and all other loan calculators that I can find
require Principal, Rate and Time to calculate the payment amount. I want one
that requires the Principal, Rate and Payment amount to calculate the number
of payments...any ideas?
 
Top