You are here: Deals Version 2 > Creating a Worksheet_V2

Creating a Worksheet_V2

In Deals, you can create a worksheet to calculate payments for a new deal. The worksheet is the deal structure page, where you work with the customer to structure the deal according to parameters from the bank or requests from the customer, such as monthly payment and down payment. You can save the worksheet and come back to it later to edit it and recalculate as needed.

  1. From the Deal page, click the Worksheets tab.

A list of worksheets appears if there are existing ones for this deal.

  1. Click Create a New Worksheet.

The Create New Worksheet pop-up window opens.

  1. Click Select Vehicle to locate the vehicle you are creating the worksheet for.

Search fields appear.

If you do not add a vehicle here, you can add one on the worksheet.

  1. Enter or select search criteria, and click Search.

A list of vehicles matching your search criteria appears.

  1. Locate the vehicle you want to add a worksheet for, and select it.
  2. Choose the worksheet type, such as cash, in house financing, or outside financing.
You must select a local lender from the drop-down list before that button enables. See Add RouteOne Lenders for information on adding new lenders to your drop-down list from the RouteOne website.

The Def Downs sub-tab opens by default. The header cards and right side of the page remain no matter what sub-tab you are on. When you enter or change any field information, the Apply button appears, and you must click Apply to save the changes.

  1. Complete the Detail fields with appropriate information, such as date, sales price, down payment, and loan rate.
Click More Details to view more fields. The Worksheet Summary and RegZ Contract Disclosure and sections show calculations. These automatically update when you click Apply and are view-only.
  1. Complete the Payment Schedule section by entering the number of payments, how much the customer wants the payment to be and how often, as well as the first payment date.
Click Add Another Schedule if you want to add more payment schedules. The system tells you when you have reached the maximum number of payment schedules. The number of payment schedules available is shown in the Contract Settings section in the Max Number of Payment Schedules field. IDMS allows 12 payment schedules, but the contract determines the number of payments schedules allowed.
  1. If applicable, click the Lender Fees & Decision accordion to view decisioning information.

  1. If applicable, click the Washout accordion to access view-only information that analyzes how the numbers are worked out.

Click the View icon to see or hide the net profit.

  1. If applicable, click the Amortization accordion to access the view-only amortization scheduled based on the numbers you have entered.

To View a Deals Worksheet Summary

See also:

Add Deferred Downs

Add a Trade-In

Add After Market Information

Add Taxes and Fees

Add Commissions

Add Lender Fees and Decisioning

Change Worksheet Settings