finance code

B

becker

I am writing a installment finance program for financing home products.

Does anyone know where I can get the formula or code for the "APR" (Annual
Percentage Rate) that must be listed on the finance contract.

I am have a lot of problem with this.

Thanks
 
A

Arvin Meyer [MVP]

Open any code window, and on the menu, chose Help, then type in "Rate". The
rate function is what you are looking for.
 
O

Olduke

Do a Google on the subject.
There are no shortage of websites that will do this function on line.
Whether or not you can download the function...I don't know.
 
B

becker

Olduke....

Thanks for replying.

Yes, several programs on line do the actual computations for you. But there
is no underlying code or function available.

Thanks again.
 
O

Olduke

i believe there is a template on the Excel page on microsoft.com that does
this.
If nothing else, you can download it and get the maths from that.
 
Top