Accounts: Deal - Deferred Revenue
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.
Layout / How to
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 Calculate button to update the results.)
Step 1: Calculating the RVI Premium
RVI default information is stored on the Company Information screen, RVI / Deferred Revenue page. If you use the Set Fields from Default Values button, this values will be pulled from the company defaults, as well as from this lease (or loan) itself.
The RVI Calculation is:
A = Vehicle Cost * Insured Residual Percentage
B = End Value - A
If B < 0 then B is set to 0
RVI Premium = B * Premium Percentage * (1 + Surplus Percentage)
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: Acquisition Fee - Gap Fee - RVI Premium
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: Deferred Revenue Amount / Term
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 Last Month Amt. field.
Based on the Start Date entered, an amortization schedule is presented. Each deferred revenue payment is due by the end of each month. If a deal terminates early, the balance immediately becomes due.