Using Budget Templates

Sponsored Progams has created budget templates which will help you calculate items in your proposal budget accurately and appropriately (especially time and effortfringe benefits, and F&A), even though sponsors will often require you to submit a budget in a format of their own choosing as well.

General Tips for Using Budget Templates

  • You need to save the template to your desktop first because the formulas in the cells are locked.
  • List all faculty/ staff personnel at Appalachian and their current 9-month base salary (for faculty) or annual salary (for 12-month EPA Administrative and SPA personnel). The template includes formulas which automatically increase salaries by 3% each year, and the cells containing those formulas are locked.
  • The F&A rate is set to default to Appalachian's current negotiated rate. If the sponsor does not allow F&A, you may change this amount to 0. If the sponsor requires a reduced amount, enter that rate in place of Appalachian's current rate.