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.
-
First, set up the columns to be printed on the report, using Method 1 or Method 2. Be sure to enter either Typecodes or Begin and End periods for the columns that will be used for calculations, too.
-
On one of the columns already set up, enter a figure in the % Val field to be multiplied by the actual figures.
-
-
For example, to show a 3% increase, enter “103” in the field. For a 10% decrease, enter “90” in the field.
-
Use Enter to proceed to the next screen.
-
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.
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