how can i calculate uk apr with excel
 

Hi there, does anyone know of a spreadsheet to calculate apr from total
amount repaid, repayment numbers...?
Many thanks

I am not sure if you will find what you are looking for but try the Financial
functions by clicking on Insert, then Function and click on Financial. You'll
find a good few predefined functions. Hope that helps....
--
Regards,

Martin


"Paul Connolly" wrote:

Hi there, does anyone know of a spreadsheet to calculate apr from total
amount repaid, repayment numbers...?
Many thanks

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