Example of Budget Calculation for Nonrent Bill Codes

This example shows how the system uses the recurring bill code rule to calculate the forecasted budget for the nonrent revenue accounts specified.

This table lists the recurring bill code setup:

Bill Code	Growth Pattern	Account	Recurring Billing Amount
TXIN	Fixed	5320	1,700
UTIL	Percent	5330	2,300

This table lists the growth pattern setup:

Growth Pattern Name	Year	Amount or Percent
Fixed	01	1,000
Fixed	02	2,000
Fixed	03	3,000
Percent	01	1.00
Percent	02	2.00
Percent	03	3.00

Term of Lease: 36 months (3 years)

• Calculation for TXIN:

  1,700 × 12 = 20,400 (annual amount)

  20,400 + 1,000 = 21,400 ÷ 12 = 1,783.33 (forecasted amount for each period in year 1)

  21,400 + 2,000 = 23,400 ÷ 12 = 1,950 (forecasted amount for each period in year 2)

  23,400 + 3,000 = 26,400 ÷ 12 = 2,200 (forecasted amount for each period in year 3)

  The system updates account 5320 in the AREF Budget Results table (F15L109) with the forecasted amount for each period of each year for which the budget is forecast while the lease is effective.

• Calculation for UTIL:

  2,300 × 12 = 27,600 (annual amount)

  27,600 × 1.01 = 27,876 ÷/ 12 = 2,323 (forecasted amount for each period in year 1)

  27,876 × 1.02 = 28,433.52 ÷ 12 = 2,369.46 (forecasted amount for each period in year 2)

  28,433.52 × 1.03 = 29,286.53 ÷ 12 = 2,440.54 (forecasted amount for each period in year 3)

  The system updates account 5330 in the F15L109 table with the forecasted amount for each period of each year for which the budget is forecast while the lease is effective.

See "Setting Up Bill Codes and Adjustment Reason Codes" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide