tag:blogger.com,1999:blog-10933503.post111061365594390290..comments2011-02-28T09:04:04.211+10:00Comments on Technical Musings: Loan repayment calculations and high school algebraNeil Ennishttp://www.blogger.com/profile/01765014622796279160noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-10933503.post-48587199995749125252008-06-19T08:40:00.000+10:002008-06-19T08:40:00.000+10:00Good news :)You CAN calculate NPER algebraically.T...Good news :)<BR/><BR/>You CAN calculate NPER algebraically.<BR/><BR/>The formula is:<BR/>NPER = LOG ([PMT*(1+RATE*TYPE) - RATE * FV] / (PMT*(1+RATE*TYPE) + RATE*PV)) / LOG(1+RATE)Neil Ennishttps://www.blogger.com/profile/01765014622796279160noreply@blogger.com