Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I calculate the area under the curve using Excel? | Excel Worksheet Functions | |||
How to calculate in Excel sheet eg. add or divide any thing and i. | New Users to Excel | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |