Actuarial Interest between Dates

The Actuarial Interest between Dates calculation lets you calculate interest between two dates based upon a fixed interest rate.

This method calculates compound interest for full periods and simple interest for fractional (stub) periods. Full periods are determined by counting backwards from the end date, fractional periods are calculated based upon the number of days in the remaining stub period and the assumed number of days in a year.

Input

• interest rate

• compounding frequency

• start date

• end date

• start value

• year length

Results

• end value

• total interest

• number of full periods

• number of stub days

Example

•

On January 1, 2002 someone borrows $10,000 at 6 % actuarial interest. Intervals are monthly and the year length is 360 days. How much does he have to pay when he settles his debt on May 23, 2002? Input Fixed interest rate: 6 %   Interest is compounded: monthly   Start date [mm/dd/yyyy]: 01/01/2002   End date [mm/dd/yyyy]: 05/23/2002   Start value: 10,000   Year length : 360 days   Rounding: nearest       Result End value: 11,540.89 Answer: $11,540.89.

 

Related topics

Simple interest

Compound interest

Variable interest tables

Day count conventions

Year Fraction

Date Series

Time between Dates