Using "% Val" Percentage Calculations

 

The % Val field is used to make projections based on percentages of actual figures. Actual figures will be multiplied by the figure in this field and the result of the calculation will appear in this column on the report.

  1. First, set up the columns to be printed on the report, using Method 1 or Method 2. Be sure to enter either Type codes or Begin and End periods for the columns that will be used for calculations, too.

  2. On one of the columns already set up, enter a figure in the % Val field to be multiplied by the actual figures.

Sample

For example, say you wish to make projections, showing a 2% increase and a 5% increase over current figures. The sample below is set up to display current figures in column 1, a 2% increase in column 2, and a 5% increase in column 3.

images\method5intopicg_shg.gif

 

The final report would look similar to this:

                                                             CURRENT             CURRENT             CURRENT

                                                              PERIOD              PERIOD              PERIOD

                                                       -----------------   -----(102%)------   -----(105%)------

              INCOME

     111-00    INT INCOME / SIGNATURE LOANS PART SECU          82,886.60-          84,544.33-          87,030.93-

     111-01    INT INCOME - BUSINESS REAL ESTATE PART              66.66               67.99               69.99

     111-02    N/A                                                   .00                 .00                 .00

     111-03    INT INCOME - SHARE PLEDGE LOANS                  2,161.11-           2,204.33-           2,269.16-

     111-04    INT INCOME - SIGNATURE LOANS                    78,210.28-          79,774.48-          82,120.79-

     111-05    INT INCOME - STOCK LOANS                              .00                 .00                 .00

     111-06    INT INCOME - PAYMENT SHAVER LOANS                     .00                 .00                 .00

     111-07    INT INCOME - PAYMENT SHAVER USED                      .00                 .00                 .00

     111-08    INT INCOME - BUS ADJ RATE MORTGAGE               5,515.75-           5,626.06-           5,791.53-

     111-09    VIP LOAN INTEREST REBATES                       15,078.00           15,379.56           15,831.90

     111-10    PAYMENT SHAVER PREMIUM                                .00                 .00                 .00

 

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#using_pct_val_percentage_calculations.htm