Earned Grant Amount Calculation Tools for Fixed Amount Grants
The Earned Fixed Amount Grant Calculators (“the tools”) are guides and associated spreadsheet templates used to determine the earned fixed amount grant funds that a program has earned. For full-time and Professional Corps programs, the earned amount is based on enrolled AmeriCorps members’ service hours. For EAP type fixed amount grants, the earned grant amount is based on the number of enrolled members. For all three fixed amount grant types, the calculation of earned grant funds involves consideration of other factors described in the Fixed Amount Grant Financial and Administrative Guide.
The full time and Professional Corps tools offered below establish the earned grant amount as of the date a program’s member roster was extracted from the Trust portal. These tools can be used to identify the earned full-time fixed amount grant for national direct programs without sub-grants, individual sub-grants awarded by national direct programs, and individual formula and competitive sub-grants awarded by State Commissions. Users are cautioned that the tools are being upgraded to automatically calculate what today are manual work-around calculations; the Guide presents work-around advice.
- Fixed Amount Full Time & Professional Corps Calculator User Guide Edition 3.0
- Earned Full Time & Professional Corps Grant Calculator for programs with 500 Members v3.0
- Earned Full Time & Professional Corps Grant Calculator for programs with 1000 Members v3.0
- Earned Full Time & Professional Corps Grant Calculator for programs with 3000 Members v3.0
- Earned Full Time & Professional Corps Grant Calculator for programs with 5000 Members v3.0
- Earned Full Time & Professional Corps Grant Calculator for programs with 7500 Members v3.0
The EAP tools presented below can be used to establish the earned grant amount as-of the date of a program’s member roster extracted from the Trust portal. The earned grant amount can be determined for any point in the active grant cycle, and at closeout, with the closeout calculation being the final and fully accurate amount. Calculations during the active grant cycle are estimates only, in that they cannot accurately project whether or not Members in "Active" status will in fact enroll and serve. The EAP tools were updated in October 2019 to automate the exclusion of exited individuals listed on a roster but with no (0) hours of national service; these individuals were never enrolled into service and do not count towards the earned grant amount. The October 2019 upgrades also improved overall accuracy by expanding MSY conversion factors to eight decimal points, and now presents a more intuitive data entry template at tab 1. The user guide is being updated to complement these upgrades.
- Fixed Amount EAP Calculator User Guide Edition 3.0
- Fixed Amount EAP Calculator for Programs with 500 or fewer Members (October 2019)
- Fixed Amount EAP Calculator for Programs with 1,000 or fewer Members (October 2019)
- Fixed Amount EAP Calculator for Programs with 5,000 or fewer Members (October 2019)
- Fixed Amount EAP Calculator for Programs with 20,000 or fewer Members (October 2019)