Third year principal reductionPMT - [P - A - A(1+r)]r=(PMT-P r)+Ar + A(1+r)r=A+Ar+Ar+Ar^2=A*(1+r)^2
You make it A + Ar + Ar^2. Hence wrong answer.
When cakculating the interest payment, the principal reduction in all previous years accumulate.
Too complicated for you and there is fixed answer in mathematics.
Switch to continue to argue in the topic without fixed answer.
My equation of PMT is correct
You can refer to following article.You can find out my equation is the same with the one in this article. And the result got from my equation is the same with the result got from bank home loan calculator.
http://www.masterhsiao.com.tw/ExcelFinance/PMT/PMT.htm
http://www.masterhsiao.com.tw/ExcelFinance/PMT/PMT.htm