CAFRMAN'S REVIEW GUIDE | |||
ESC - Economic Summary of Combined Governments |
Introduction | Back to Main Menu | ||
The Retirement/Pension Surplus Adjustment | |||
Data Entries on the Form |
If reviews are conducted of more than one government, then the economic impact results of these governments can be added together to provide a total economic impact.
The Retirement/Pension Surplus Adjustment
There is an adjustment that may be necessary in the reporting of retirement/pension (retirement) surpluses on this form. If retirement surpluses have been reported at the State-level and included in the per capita amounts, AND if there are retirement surpluses being reported at the school district, city and/or county-level reviews for the SAME retirement system/plan, then an adjustment is necessary in one of the two per capita potential surpluses reporting.
If the school district, city and/or county-level government's CAFR stipulates the amount of retirement surpluses, then we recommend that the State-level per capita amounts be adjusted to delete the retirement surpluses portion. This is how we would handle this.
Prepare a second Econ2A and enter it as FilePage Number 2. Deduct the retirement surpluses for the particular retirement plan(s) from the Total Potential Surpluses for the State, Rev1 or Rev2 form. Enter the reduced Total Potential Surpluses in the appropriate cell on Econ2A and use the the data on this form for inclusion on the ESC form described here.
DE = Data Entry. The cells with this designation are cells that a user should enter the appropriate data.
An "-A" at the end of a cell designation means that in the computer program this cell is completed by the computer program and user data entry is not necessary. For example, C9-A means that in Column "C" and Row "9" the entry in that cell (C9) is automatically entered by the program.
Here is what the ESC Form looks like:
For all users, the following table lists the entries/formulas in the appropriate cells on the form corresponding to the picture of the form above.
Economic Summary of Combined Governments (ESC) | |||
DE-1 | Name of State | ||
DE-2 | Name of County | ||
DE-3 | Name of City | ||
DE-4 | Name of School District/System | ||
B7 | State - [Form Econ2A, F1-A] | ||
B8 | County - [Econ2B, F1-A] | ||
B9-A | [B7 + B8] | ||
B11 | [Econ2A,F6-A] | ||
B12 | Econ2B,F7-A] | ||
B13-A | [B11 + B12] | ||
B15 | [Form Econ2A, E8-A] | ||
B16 | [Form Econ2B, E9-A | ||
B21 | [B7] | ||
B22 | [B8] | ||
B23 | [Econ2D, F1-A] | ||
B24-A | [Sum of B21-B23] | ||
B26 | [B11] | ||
B27 | [B12] | ||
B28 | [Econ2D, F7-A] | ||
B29-A | [Sum of B26-B28] | ||
B31 | [B15] | ||
B32 | [B16] | ||
B33 | [Form Econ2D, E9-A | ||
B34 | [Sum B31 - B33] | ||
C7-A | [B7 x 4] | ||
C8-A | [B8 x 4] | ||
C9-A | [C7+C8] | ||
C11-A | [B11 x 4] | ||
C12-A | [B12 x 4] | ||
C13-A | [C11+C12] | ||
C21 | [C7] | ||
C22 | [C8] | ||
C23 | [Econ2D, G1-A] | ||
C24-A | [Sum of C21-C23] | ||
C26 | [C11-A] | ||
C27 | [C12-A] | ||
C28 | [B28 x 4] | ||
C29 | [Sum of C26 - C28] | ||
F7 | State - [Form Econ2A, F1-A] | ||
F8 | City - [Form Econ2C, F1-A] | ||
F9-A | [F7+F8] | ||
F11 | [Econ2A,F6-A] | ||
F12 | Econ2B,F7-A] | ||
F13-A | [F11 + F12] | ||
F15 | [Form Econ2A, E8-A] | ||
F16 | [Form Econ2C, E9-A] | ||
F17-A | [F15 + F16] | ||
F21 | [F7-A] | ||
F22 | [F8-A] | ||
F23 | [Econ2D,F1-A] | ||
F24-A | [F22 + F23] | ||
F26 | [F11-A] | ||
F27 | [F12-A] | ||
F28 | [Econ2D, F7-A] | ||
F29-A | [F26 + F27 + F28] | ||
F31 | [F15-A] | ||
F32 | [F16-A] | ||
F33 | [Econ2D, E9-A] | ||
F34-A | [F31 + F32 + F33] | ||
G7-A | [F7-A x 4] | ||
G8-A | [F8 x 4] | ||
G9-A | [G7 + G8] | ||
G11-A | [F11 x 4] | ||
G12-A | [F12 x 4] | ||
G13-A | [G12-A + G13-A] | ||
G21 | [G7-A] or [G21 x 4] | ||
G22 | [G8-A] or [G22 x 4] | ||
G24-A | [G21 + G22] | ||
G26 | [G11-A] or [G26 x 4] | ||
G27 | [G12-A] or [G27 x 4] | ||
G28 | [F28 x 4] | ||
G29-A | [G26 + G27 + G28] |