Days In Year

General

The typical loan payment calculation doesn’t take into account non-uniform payment periods.  In reality, all months don’t actually last 30 days and there are 52 weeks and one day in a year (two days for a leap year).  This means that more interest will accrue in the month of January than in the month of February if interest is accruing daily.

Actual

Like you’d expect, this option calculates the interest that accrues daily and then multiplies it by the number of days in a payment period in order to get the total period interest accrual.  This means interest accrues based on a 365-day year.

Frequency

This option will calculate payments and accrue interest based on uniform payment periods for your payment frequency.  That means that if you have a monthly frequency a payment period is 30 days.  With 12 payment periods per year, the days in the year equal 30 (days in period) x 12 (payments per year) = 360.  Semi-monthly payment periods also use a 360-day year because 15 x 24 = 360.  Weekly and bi-weekly frequencies will use a 364 day year because 7 x 52 = 364 and 14 x 26 = 364.

The first question most people have when they first learn this is: where did the extra interest go?  Since the interest rate for a payment period is different (annual interest rate/360 vs. annual interest rate/365), the actual calculated interest and payment amounts are extremely close.

Example

In this example, we will be looking at a 24-month loan for $11,152 at a 25% interest rate.  If the Days in Year option is set to Frequency, the payment schedule is calculated to be 24 monthly payments of $595.20.

If you change the setting to Actual, the payment schedule is calculated as 23 payments of $595.20 and 1 payment of $592.33.

You might be thinking, “I thought the Actual meant 4 extra days of interest, why does the borrower pay slightly less?”  The explanation for this is in how the period interest rate is calculated.  Here is how the first payment breaks down between interest and principal in a Frequency scenario:

As you can see, the interest portion of the first payment is $232.33.  This is calculated as the monthly interest rate multiplied by the average daily balance for the payment period.  To get the period interest rate, take the yearly rate of 25% and divide it by the number of payment periods in a year (12).  This gives a monthly interest rate of 2.0833%.  If we multiply that by the average daily balance for the first payment period of $11,152 we get 11,152 x .020833 (the percentage as a decimal) = 232.33, so $232.33 will be the interest portion of the first payment.

In an Actual scenario, the first payment breaks down as follows:

You can see that the interest portion for the first payment is $229.15.  Since the payment periods in a monthly loan are actually of different lengths, we will calculate monthly interest as:

monthly interest = daily interest rate x average daily balance x number of days in the period

The daily interest rate is calculated as:

25% (yearly interest rate) / 365

When we plug in the numbers we get:

25% / 365 = 0.0684%

So 0.0684% is the daily interest rate.  Since the average daily balance for the payment period is $10,000 and there are 30 days in the first payment period, interest for the period is calculated as:

.000684 (daily interest rate converted to a decimal) x 11,152 x 30 = 229.15

So, $229.15 worth of interest will accrue in this period.

You’ll notice if you multiply 0.0684% by 30 (days in the period) you get 2.0548% monthly interest.  As we calculated above, the monthly interest rate for our Frequency scenario was 2.0833%.  We could have calculated that rate in the same way as we calculated the rate in our Actual scenario as:

25% (yearly rate) / 360 (days in year) x 30 (days in period) = 2.0833%

Since our interest rate is slightly higher in the Frequency scenario, it compensates for the 4 days of “missing” interest.  In most cases, the calculated payment schedules with either Days in Year selection will be quite close.

Note: In many cases, the payment schedule for a contract is calculated using a frequency-specific number of days in the year (360 or 364), but interest is accrued based on the actual number of days in a year.  This may cause inconsistency when trying to match contracts obtained from different sources.


How did we do?


Powered by HelpDocs (opens in a new tab)