This is used to calculate deferred revenue using acquisition fees, RVI, & Gap values. It was specifically written for one ALMSys customer, but you may find that it could work in different situations.

The whole idea of deferred revenue is to put off profits on a new lease (or loan) and string them out over the life of the deal. This screen calculates deferred revenue in 3 steps. (Note: If you make any changes to the values on this screen, you must click the

Step 1: Calculating the RVI Premium

RVI default information is stored on the Company Information screen, RVI / Deferred Revenue page. If you use the

The RVI Calculation is:

Example: Vehicle cost id $49,150.00, End value is $26,190.00, insured residual percentage is 25%, premium percentage is 0.6%, and surplus percentage is 3%. The calulation would be:

A = 49150 * 0.25 = 12287.50

B = 26190 - 12287.50 = 13902.50

RVI Premium = 13902.50 * 0.006 * (1.03) = 85.91745. So, $85.91 is the RVI premium.

Step 2: Deferred Revenue Amount

The deferred revenue total amount calculation is:

Example: Acquition fee is $590.00, gap fee is $95.00, RVI premium is $85.91. The calculation would be:

590 - 95 - 85.91 = 409.09. So, $409.09 is the total deferred revenue amount.

Step 3: Monthly Revenue

The monthly revenue calculation is:

Example: Deferred revenue amount is $409.09, term is 39 months. The calculation would be:

409.09 / 39 = 10.48948718. So, $10.49 is the monthly deferred revenue amount. In order to make the total number of payments exactly equal to the total deferred revenue amount, ALMSys calculates the (monthly amt * (term - 1)), subtracts that from the total deferred revenue, and places it into the

Amortization Schedule

Based on the