• 05/02/2017
    Excel: =MOD() to Calculate Quarterly Interest Payments

    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: Download Template

    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.