Hi guys,
I have been busting my head for this problem but to no avail, please help me out here. Basically we are inquiring for loan offers from lenders and I have the following proposal: we take 1.7 million euro as loan, payable in 60 months (5 years), and we pay a total of 413.000 EUR as a total interest; so in total, what we pay in the end is 2.113.000 EUR principal + interest. The annuities are equal across the lifespan of this payment schedule, so this should be, as it is normal, a regressive interest amount and progressive principal. After I extract the interest rate I should be able reverse the payment schedule with the usual formulas: PPMT + IPMT = Annuity, for each of those 60 months (that is, in the end CUMIPMT = 413.000 EUR). Now, I have been trying to use that RATE formula, and finally I figured it out; my problem is that it gives me an accrued interest rate. I do not want to use an accrued interest rate, this has to be the interest rate used by that lender, the interest rate from the payment schedule which we use to compute the interest in each month. Also, INTRATE is not helping he either. Any solution would be greatly appreciated. Thanks a lot, Silviu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
