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.
1. How to use =MOD() in an =IF() statement to calculate quarterly interest payments.2. Multiple uses of the =OR() function.
should be simple.*