<div>
Thank you Barry. &nbsp;That is exactly what I did. &nbsp;I used the fuction and had the same APR calculated. &nbsp;I justed wanted verification. &nbsp;<br />
<br />
Thanks for your time
</div>


Thank you Barry.  That is exactly what I did.  I used the fuction and had the same APR calculated.  I justed wanted verification.  

Thanks for your time

<div>
<div class="content wysiwyg-content">
I need to figure out the APR. &nbsp;Can someone please assist me with a formula?<br />
<br />
Currently I am selling a product for $810. &nbsp;I also give the option to purchase it over 36 months for $25.00/month. &nbsp;if they choose this option they will pay $900. &nbsp;I have to make sure due to usury laws that the imputed interest on this transaction is less than 8% APR. &nbsp;Can someone help me with a formula or function that will help me figure out the affective APR? &nbsp;<br />
<br />
the difference between the cash price ($810) and the financed price ($900) is $90. &nbsp;This would be the imputed interst I assume.
</div>
</div>


I need to figure out the APR.  Can someone please assist me with a formula?

Currently I am selling a product for $810.  I also give the option to purchase it over 36 months for $25.00/month.  if they choose this option they will pay $900.  I have to make sure due to usury laws that the imputed interest on this transaction is less than 8% APR.  Can someone help me with a formula or function that will help me figure out the affective APR?  

the difference between the cash price ($810) and the financed price ($900) is $90.  This would be the imputed interst I assume.

Calculate APR

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.