Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
PPMT
Understanding how loan payments are structured can feel overwhelming but Excel gives us powerful tools to make these calculations quick and simple. Whether we’re evaluating monthly payments, interest breakdowns, or savings from early payoff, Excel’s financial functions (PMT, IPMT, PPMT, CUMPRINC, CUMIPMT) help us every step of the way. This post is brought to you…
Read More
Managing loans and tracking monthly payments just got a whole lot easier. In this tutorial, we’ll explore the PPMT function in Excel—a lesser-known but incredibly powerful function that calculates the principal portion of a loan payment for a specific period. Even better, we’ll show how to transform this function into a fully dynamic loan amortization…
Read More
In this tutorial, we’ll create a fully dynamic amortization schedule based on the number of months entered. For example, if you enter 12 months, the amortization schedule will span 12 rows. If you enter 360 months, the amortization schedule will span 360 rows. The technique demonstrated in this tutorial uses the following functions: SCAN, SEQUENCE,…
Read More