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.
IPMT
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
If you’re managing loans or curious about how much interest you’re paying each month, Excel’s IPMT function is here to help. In this post, we’ll not only explore how the function works, but we’ll also take it further by building a fully dynamic loan amortization schedule—one that updates automatically when you change any loan inputs.…
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