How is it that when I capitalize this amortization table, the present value doesn't equal the sum of PV or the XNPV formula of all the future payments?
It's not about this amortization specifically, but any amortization table for long periods.
I tried it on some other amortization tables and it never equal the present value of the loan. If I capitalize the future payments with the same rate as the loan rate, it must always be equal to the present value of the loan. It's must be so mathematically. So I don't see what's wrong. I thought it was because there are some years with 366 days, but even if I use it in the calculations for the relevant years, it does come close- but not enough.
Link for the amortization table: https://drive.google.com/file/d/1tocPRNMOqQM52wpEC_hjV9AGak-M8cHy/view?usp=sharing
Does anyone have an answer for it? Thanks