Excel: =MOD() to Calculate Quarterly Interest Payments

  • Peter Lynch

One of the challenges you will encounter building monthly debt schedules is the need to calculate and show interest expense in each month, and then reflect the payment of interest at the end of the quarter. This video provides a helpful approach.

Click on the icon in the lower right-hand corner of the video player to expand to full screen.

The template used in the video is available for download: Monthly Debt Schedule

What you will learn in this video:
1. How to use =MOD() in an =IF() statement to calculate quarterly interest payments.
2. Multiple uses of the =OR() function.

Related: Interest Expense in a Monthly Financial Model (Interest Expense vs Interest Paid)