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

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 Connolly@discussions.microsoft.com> wrote in message
news:66DE5159-477D-40DB-806F-C4086EBACB45@microsoft.com...
> 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 Connolly@discussions.microsoft.com> wrote in message
news:66DE5159-477D-40DB-806F-C4086EBACB45@microsoft.com...
> Hi there, does anyone know of a spreadsheet to calculate apr from total
> amount repaid, repayment numbers...?
> Many thanks