How To Use The Ppmt Function In Excel
The way these payments are split isn’t the same from month to month, however. The more payments you make, the smaller your interest payments become. As a consequence, the amount that goes towards reducing your loan (the payment on principal) increases every month. If you want to know the proportion of your loan payment that’s going towards paying off your outstanding balance, you can use the PPMT function in Microsoft Excel to help you....