Login
Screenshot of the Ultimate Financial Calculator interface

Ultimate Financial Calculator Promotional Section

Pick your colors:

How to Calculate a Loan with Scheduled Skipped Payments

To set your preferred currency and date format, click the “$ : MM/DD/YYYY” link in the lower right corner of any calculator.

advertisement

A Step-by-Step Tutorial
Tutorial 12

“Skipped payment loans” are loans that have an irregular payment schedule. These payment skips are part of the loan agreement and are not considered missed payments. The Ultimate Financial Calculator can handle this type of loan structure.

Background: Some businesses borrow money at different times of the year to stabilize cash flow. Certain individuals may work seasonally and earn income only during specific months. For example, outdoor construction workers might not work in January or February. In such situations, borrowers may take out a loan that allows them to skip payments during months when income is lower or unavailable. This tutorial explains how to enter that type of loan setup.


Before using this tutorial, all users should review the more detailed first tutorial. It explains the basic concepts and settings of the UFC.


To create an amortization table that allows for skipped payments, follow these steps:

  1. Set Schedule Type to Loan.
    • Alternatively, click to clear any previous entries.
  2. Click , then select Rounding Options. Set “Rounding” to Adjust last amount to reach “0” balance.
  3. In the header section, make the following settings:
    1. For Calculation Method, select Normal.
    2. Set Initial Compounding to Daily.
    3. Enter 8.75 for Initial Interest Rate.
  1. In row 1 of the cash‑flow input area, create a “Loan” series.
    1. Set the “Date” to February 15, 2024.
    2. Set the “Amount” to 75,000.00.
    3. Set “# Periods” to 1.
      • Note: Since the number of periods is 1, you will not be able to set a frequency. If a frequency is set, it will be cleared when you leave the row.
  1. Move to the second row of the cash‑flow input area. Select “Payment” for the “Series”. Initially, the regular payment amount is unknown.
    1. Set the “Date” to March 15, 2024.
    2. Set the “Amount” to “Unknown”.
    3. Set “# Periods” to 48.
      • This value defines the loan term as 48 months, including the skipped months.
      • The actual number of payments will be fewer than 48.
      • Because some months will have no payment, the calculated payment amount will be higher than if the loan were paid over 48 months with no skipped months.
  • Before the calculation, your screen will look like this (Fig. 1):
Skipped payment loan setup
Fig. 1—Initial preparation of a loan with scheduled skipped payments.
  1. Display “Options for Selected Cash Flow Series” by clicking the second row’s right‑most cell in the “Series Options” column.
    1. Select the “Monthly Skip” tab at the top of the window.
    2. Make sure “Activate Monthly Skip series for the currently highlighted series” is selected.
    3. Set “Regular monthly amount” to “Unknown”.
    4. Set “Amount on skipped months” to $0.00.
      • Skipped months are not required to have a zero payment, but this example uses $0.00.
    5. Check “July” and “August” as the skipped months. Fig. 2.
    6. Click .
Selecting months to skip
Fig. 2—Selecting months to skip.
  1. Click . The result is $2,232.10. Fig. 3.
    • This is the required level payment amount when no payments are made in July or August.
Calculated level payment
Fig. 3—Calculated level payment amount considering the skipped months.
  1. To view a detailed amortization schedule showing how the monthly payment is allocated between principal and interest, click . Fig. 4.
    • Note: No payments are made in July or August, but interest still accrues during those months.
Amortization schedule with skipped payments
Fig. 4—Amortization schedule showing skipped payments.
  • Note: In addition to the “Monthly Skip” option, there is a “Series Skip” option.
    • Series Skip is used with payment frequencies other than monthly. Fig. 5.
    • The user specifies how many payments to make, followed by how many to skip.
Series Skip option
Fig. 5—Series Skip option.

Skipped payments can be a predefined feature agreed upon by both the borrower and the lender. Calculating the unknown payment amount for such a loan is complex. A financial calculator must handle the irregular cash flow and the interest that accrues during skipped periods. A correct result should require only a minimal rounding adjustment in the final payment. The Ultimate Financial Calculator is designed to perform this type of calculation accurately.

Back to the Ultimate Financial Calculator.

advertisement