Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
UNIQUE() Function - Excel 365 Function for Removing Duplicates
Tutorial: Excel 365 Formulas Course The new UNIQUE() function for Excel 365 allows you to quickly, ...
SEQUENCE() Function - Excel 365 New Function for List Making
Tutorial: The new SEQUENCE() function for Excel 365 allows you to quickly, easily, and simply make ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Finance Trick #18: CUMIPMT function for Interest


See how to use the CUMIPMT function to calculate the cumulative Interest on a loan for a 1 year period. See the Tax benefit of Interest and the Net cash flow out for an Interest Payment.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Excel Formula





Got a Question? Ask it Here in the Forum.