I need VB/VBA code or a third party MS Access add-in that will
calculate Annual Percentage Rates according the the requirements of
the UK Consumer Credit Act/Office Of Fair Trading.

---

Clarification of Question by bluesunbeam-ga on 30 Jul 2003 04:19 PDT

Answer must contain VB/VBA code examples

---

Request for Question Clarification by answerguru-ga on 30 Jul 2003 09:54 PDT

Hello there,

I would be happy to provide you with the VBA code for calculating APR,
however could I clarify just what you mean by "the requirements of the
UK Consumer Credit Act/Office Of Fair Trading"? APR seems to be a
fairly standard international calculation - the only comments these
regulatory bodies seem to have regarding APR is how it can be
advertised to consumers (so as not to be misleading). It would be
helpful if you could let me know if you have a set of rules or
requirements that apply to the actual calculation of APR.

Thanks,

answerguru-ga