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  

Introduction

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.

Data Entries on the Form

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:

ESC

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]  

Back To Top