Function Problems

Calculate Loan Payments After a 90-Day Same-as-Cash Period in Excel

Steve KSteve K Nov 3, 2026 870 views

Question details

The user needs an Excel formula to calculate the monthly payments for a loan featuring a 90-day same-as-cash deferral where interest accrues and is added to the principal.

How to Calculate Loan Payments After a 90-Day Same-as-Cash Period in Excel
Product
Excel
Device & OS
not provided
Scenario
Building a financial worksheet to bypass a proprietary lender application for a simple-interest loan with deferred payments.
Observed behavior
The lender's application provides exact payment amounts. Replicating this requires adding the 90-day accrued interest to the principal and carefully adjusting the PMT function arguments for payment timing and exact day counts.
Before you start

Gather your exact loan terms, including the original principal, annual interest rate, exact deferral period (90 days vs. 3 full months), and whether payments are due at the beginning or end of each period.

Solution 1Recommended

Use the PMT Function with Accrued Principal

Calculate the new financed balance by adding the 90-day simple interest to the original loan amount, then use the PMT function to find the monthly payment.

When a loan has a 'same-as-cash' period but isn't paid off during that window, interest generally accrues from day one. To find your actual monthly payment for the repayment term, you must first calculate the accrued interest and add it to your starting principal.

Differences of a few cents between your formula and a lender's application usually come down to how they count the deferral period (exactly 90 days vs. 3 whole months) and payment timing (beginning vs. end of the month).

1
Calculate the Accrued Interest

Determine the interest for the 90-day period. For a $2,000 loan at 18%, calculate the daily interest and multiply by 90 using the formula: ROUND(2000*90*18%/365, 2).

2
Set up the PMT formula structure

Select an empty cell and type =PMT(. The PMT function requires the rate, number of periods (nper), and present value (pv).

3
Enter the Rate and Number of Periods

For the rate argument, enter 18%/12 to get the monthly interest. For the periods, enter your payment term (e.g., 12, 24, or 36). If the 90 days eat into a 36-month term, use 3*12-3. If the term starts after the 90 days, use the full term length.

4
Combine into a single formula

Enter =PMT(18%/12, 36, -2000-ROUND(2000*90*18%/365, 2)) to get the final monthly payment. Note the negative sign before the principal, which ensures the payment outputs as a positive number.

Use the PMT Function with Accrued Principal
Adjusting for Payment Timing: If your payments are calculated as if they occur at the beginning of each month, add ,0,1 to the end of your PMT formula (e.g., =PMT(18%/12, 36, -2000-..., 0, 1)).

Calculate Complex Loan Amortizations Effortlessly with WPS Spreadsheet

WPS Office Spreadsheet provides full support for advanced financial functions like PMT, PPMT, and IPMT. You can easily build amortization tables, calculate deferred interest, and format your financial data exactly like Microsoft Excel.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or open your existing loan tracker.
  2. 2. Insert the PMT Function: Click on the 'Formulas' tab, select 'Financial', and choose 'PMT' from the drop-down menu.
  3. 3. Fill in the Arguments: Use the pop-up dialogue box to input your monthly rate, number of periods, and your adjusted present value (principal + 90-day interest).
  4. 4. Save as Excel Format: Go to Menu > Save As, and choose the .xlsx format to ensure your financial models remain fully compatible.
100% compatible with Microsoft Excel financial formulas (.xlsx).Built-in function wizard helps you easily enter rate, nper, and pv values without memorizing syntax.Completely free and lightweight, perfect for personal finance tracking.Cross-platform support allows you to check loan schedules on Windows, Mac, iOS, and Android.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my calculated loan payment differ slightly from the lender's document?

Lenders may use different rounding rules, base their year on 360 days instead of 365, or calculate the deferral period as 3 exact months rather than 90 days. Payment timing (beginning vs. end of the month) also shifts the final penny amounts.

How do I calculate interest for exactly 3 months instead of 90 days?

Instead of multiplying the principal by 90/365, you can calculate the interest based on monthly compounding or simple interest per month. For example, simply add 3 months of interest by taking the monthly rate (18%/12) multiplied by 3, then multiplying by the principal.

What does the 'type' argument in the PMT function do?

The 'type' argument indicates when payments are due. Omit it or enter '0' if payments are due at the end of the payment period. Enter '1' if payments are due at the beginning of the period.

Can I build an amortization schedule for a loan with a same-as-cash period?

Yes. Start your amortization table with the principal balance equal to the original loan plus the accrued interest from the same-as-cash period. Then, use the PMT, IPMT (Interest Payment), and PPMT (Principal Payment) functions to map out each subsequent month's payment.