ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Effective Rate of Return (https://www.excelbanter.com/excel-discussion-misc-queries/137250-effective-rate-return.html)

Sr Accountant[_2_]

Effective Rate of Return
 
I am trying to find the effective rate of return on a loan as follows:

PV $100,000
Life = 10 yrs
First 3 yrs = No Payments
Next 7 yrs = $1,460.86

If I calculate over just 7 years I get 6%, but how do I find the effective
rate of return over the life of the loan?

Thanks!


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com