MrExcel Publishing
Your One Stop for Excel Tips & Solutions

APR Calculation


Posted by David on June 29, 2001 10:14 AM

Is anyone familiar with how to use excel to calculate an APR (annual percentage rate)on a series of uneven cash flows. The RATE and IRR functions use even cash flows. I am trying to calculate the APR on an adjustable rate real estate loan.

Thanks, David


Posted by faster on June 29, 2001 10:41 AM

Try IRR()

Posted by David on June 29, 2001 11:08 AM

Thank you!