An amortization schedule is one of those things that sounds more intimidating than it actually is. The user who posted this request already knows how to calculate a monthly payment using PMT(), which means they are 80 percent of the way there. What they need now is a clear, repeatable structure that shows exactly where each €94.36 goes every month, and that structure is straightforward to build. The interest portion for any given month is simply the remaining balance multiplied by the monthly interest rate. The principal portion is the total payment minus that interest. Then the remaining balance drops by the principal amount, and the next row repeats the same three calculations. That is the entire logic, sixty times over.
The practical value here is control. A standard amortization schedule built this way lets you see the full trajectory of your loan at a glance. You can watch the interest portion shrink month after month and the principal portion grow, which is exactly the kind of transparency that turns abstract finance into something tangible. The user also wants the ability to make extra payments, and that is where the real power of a custom spreadsheet emerges. Instead of forcing you into a rigid bank calculator, your own schedule lets you add a column for extra principal, subtract it from the balance before the next month's interest calculation, and watch the loan end months or years early. The formula does not change. You just add one number to one cell each month, and the entire schedule recalculates itself.
What makes this approach work is that it does not require any specialized financial functions beyond PMT(). The rest is simple arithmetic and careful cell references. The user is handy with Excel, so they already have the skills to build this. They just needed permission to trust that the math is that simple. It is. The hardest part is getting the first row right, and once that row works, a quick drag-fill handles the other fifty-nine. For anyone reading this who has ever felt stuck between a bank's opaque amortization table and the desire to pay off debt faster, this is the solution. Build the schedule, add the extra payment column, and see for yourself how much time and interest you can save.