finance code

[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

 

[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.

 

[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.

 

[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.

 

[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.