This might help:

http://www.bygsoftware.com/Excel/functions/PV_RATE.htm


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

"Paul Connolly" <Paul wrote in message
...
Hi there, does anyone know of a spreadsheet to calculate apr from total
amount repaid, repayment numbers...?
Many thanks