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.
PV
Mastering 5 Key Financial Functions: PMT, PV, FV, NPER, RATE Whether we’re planning to buy a car, save for retirement, or pay off a loan, numbers play a central role in our financial journey. Excel gives us powerful tools to analyze and plan financial scenarios. In this post, we’ll walk through five key Excel financial…
Read More
When it comes to evaluating investments in Excel, most people immediately jump to the familiar NPV and IRR functions. While these are incredibly powerful, they can lead to incorrect conclusions if we don’t fully understand how they work, especially when cash flows vary or are irregular. In this post, we’ll walk through six powerful finance…
Read More
When assessing whether an investment is financially worthwhile, smart investors don’t guess … they measure. Excel has multiple functions that can measure an investment’s net present value. Excel’s classic net present value function, NPV, assumes cash flows occur at regular intervals. But what do we do when the cash flow timing is irregular? That’s where…
Read More
Welcome! In today’s post, we’ll walk through the concept of Net Present Value (NPV) and how to calculate it accurately in Excel. If you’ve ever wondered how to measure whether an investment is worth it, NPV is one of the most practical tools you can use. But, as with many financial functions, there’s a catch.…
Read More
Understanding the concept of present value can be one element in our financial decision making process. From evaluating loans and subscriptions to complex financial instruments like reverse mortgages, Excel’s PV function provides an accessible, effective tool for comparing future payments in today’s dollars. In this post, we’ll explore how to use the Excel PV function…
Read More