Skip to content Skip to main navigation
Teachers College, Columbia University
Printer-friendly Version
Teachers College, Columbia University Logo

Office of Sponsored Programs

Budgeting Guidelines

‌We have recently updated the TC‌ ‌ OSP Budget Template 9.2017v2 (Excel) to reflect the latest fringe benefit rates as well as anticipated tuition increases.  The latest version is dated95.1.2017.  All rates embedded in the template are up to date.  Effective immediately, please use only this version.  Also the instructions and the material in the notes have changed considerably so please review them carefully.  

The budget template was designed to accommodate all types of grant budgets. It assumes no prior knowledge of grant budgeting, or of TC salary formulas, indirect cost and fringe benefit rates, or even Excel formulas. 

The biggest change in the latest version is that we have changed the default settings for faculty salary calculations using the nine month academic year salary as the basis for all calculations. This is in recognition of the fact that NIH recently changed its budget forms to reflect academic year and summer effort expressed in months rather than percentages.  Overage and course release have always been calculated on the nine month base, so the change ought to simplify budgeting with less formula editing. 

Below is some guidance for estimating costs of other frequently requested budget items:


Each item below corresponds to a common line item in most grant budgets

1. Faculty Salaries

The 9 month contract leaves the three summer months available for faculty to devote 100% of their effort on grant related work. Therefore, faculty will most frequently request Summer Salary from a grant. The three months of the summer are equal to 1/3 of the academic year, so summer salary is capped at 33% of IBS. Each month of summer salary is equal to 11% of the 9 month salary.

Faculty may also do grant related work during the year. A faculty member may elect to "buy out" of teaching (more formally known as "course release") to work on a sponsored project, at a rate equal to 15% of IBS for each course released. If a faculty member performs work on a sponsored project in addition to his or her normal duties at the college during the academic year, he or she may draw overage compensation. TC policy caps overage at 20% of 9 month salary.

The maximum annual compensation a faculty member may draw from TC and external sources combined is thus 153% of the 9 month base salary.  Any grant funds budgeted for a faculty members salary in excess of the 53% summer salary and overage must be budgeted for course release or rebudgeted for other purposes..  

NOTE: The National Institutes of Health (NIH) sets an annual salary cap. Effective January 8, 2017, total compensation for individuals receiving funds from NIH and institutional sources may not exceed $187,000. If a faculty member's annualized base salary exceeds this amount, the lower amount must be used.

Grant budgets for the National Science Foundation (NSF) require that salary requests be expressed as months. No more than 2 months salary may be requested for any one individual on one grant.

2. Other Professional Salaries

Other professional staff at TC work on 12 month contracts and are not (in general) entitled to overage payments, so their salaries are far simpler to calculate. For professional staff currently on the TC Payroll, request salary for such individuals as a flat percentage of their current Institutional Base salary.

It's frequently the case that staff positions named in a grant proposal budget will only be created if the grant is funded, in which case we have to estimate what each position's Institutional Base Salary will be. Below is a list of position categories frequently included in grant budgets with a salary range for each.

Senior Research Scientist/PostDoc: $60,000-90,000

Project Director/Business Manager: $55,000-80,000

Project Coordinator/Data Collection Coordinator/Statistical coordinator (doctoral level): $30,000-55,000

Project Tech Support, Network Engineer, Web/Multimedia Designer: $60,000-680,000

Secretary/Clerical Staff : $30,000-50,000

3. Graduate Research Assistants

As of 1/1/08, the college has codified specific types of support for graduate students:

  • Doctoral Research Fellowships: Includes a stipend of between $20-30K per year, with 12 credits tuition charged to the grant, matched by the college
  • Graduate Research Assistant: Works no more than 20 hours a week and earns no less than $4000 per semester (up to 19 weeks) per academic year.. Eligible for 6 points tuition waiver. 
    • Please note that effective December 31, 2017 minimum wage rises to $13.00 per hour in NYC, with a rise to $15.00 per hour effective December 31, 2018. Investigators budgeting multi year grants should be aware that the $4000 minimum GRA salary will purchase less graduate assistance each year of the project until 2019.  In order to support the same level of graduate assistance throughout the project, PIs should budget $4750 per semester during calendar year 2018 and $5500 per semester thereafter.

Part time hourly and part time professional lines may also be used to support graduate students.

4. Fringe Benefits

Teachers College's fringe benefit rate for FY17 is 35.1% on ALL personnel. 

OTPS Expenses

5. Subcontracts 

Subcontracts are budgeted when a project requires collaboration with another institution to fulfill its objectives. Usually, one institution takes the lead on the project, and issues one or more subcontracts to collaborating institutions. Each collaborating institution prepares a budget according to its own salary formulas, fringe benefit and indirect cost rates and submits it to the lead institution with a letter from an institutional official committing to do the work on the project should the grant be funded. Different sponsors have different requirements as to how much detail of each subcontract budget they need, so consult the program guidelines.

TC investigators who plan on submitting a proposal as a subcontractor to another institution must still submit their proposal budget for internal routing.

6. Consultants

Consultants are individuals outside of TC with skills or expertise necessary to the conduct of a project, but whose involvement is more limited in time or scope than a subcontractor. Consultants are often engaged on a project to perform statistical analysis, to evaluate research design or program outcomes, or to serve in an advisory capacity to a project. Most of the time, we don't know exactly who will be engaged as a consultant on a project. 

PLEASE NOTE:  The IRS sets rules as to who may be paid as a consultant.  The determination as to whether a particular individual can be paid as a consultant or must be paid as an employee is made just prior to the start of work.  There are no sponsor rules requiring that a given individual working on a project must be paid as a consultant; if an individual is determined to be an employee prior to hiring, that individual must be paid as an employee, with associated fringe benefit and indirect cost rate charges, regardless of how funds are budgeted in the grant.

Noncompliance in this area can lead to severe IRS penalties, so the Offices of the General Counsel, Purchasing and Payroll are extremely diligent in ensuring compliance with all applicable regulations.

 7. Travel

 Most research grants budget funds for travel, for the Principal Investigator and other project staff to present and attend conferences. Travel requests of this type should be kept relatively low, no more than $1000-$2000 per year.

 Sometimes extensive travel is an integral part of the project, for example, when data collection takes place outside the NYC area or when collaborators work at a distance from one another. To budget in such cases, take the number of individuals who will be travelling, estimate the total number of trips per year each will have to make, and use the Web to get a sense of current airfares and room rates at the locations in question. Local travel should be budgeted on the travel line as well.

 8. Supplies and Equipment

 Federal guidelines define equipment as costing more than $5000. This means that most computing, software, low end a/v equipment, etc., should go on the supply line with items like toner cartridges, office supplies, etc, rather than on the equipment line. At TC, where we aren't doing research in the physical and health sciences that require major specialized equipment, servers and high end video equipment are the items most frequently found on the equipment line.

 We generally budget desktop computers at $1500 per unit (unless we know for certain a higher-end model will be needed). Generally, we request at least one desktop computer for the graduate assistants working on the project to share, as well as one unit for each full time professional (exclusive of faculty) who work on the project. Requesting a laptop for a project can strike a sponsor as frivolous (unless it's clearly justified), but there is nothing to prohibit you from purchasing a laptop once funds are awarded.

Once again, the Web can help you obtain reasonable estimates for supplies and equipment.

 9. Participant Support Costs

Items on this line include payments to students in a training program for their time, room and board, travel or study fees. They also include compensation for time and travel of research subjects. The actual dollar amounts of these expenses will vary widely depending on the nature and duration of participants' involvement. Keep in mind, however, that according to federal guidelines on human subjects research, fees paid to subjects may not be set so high that the fees become an enticement to participate.

10. Tuition

Most grant applications do not include a specific line for tuition for your graduate assistants; we usually place it on a line marked "other." Tuition for the 2017-2018 academic year is at $1572 per credit; budget for 4% annual tuition increases.

 11. Telephone/Office Supplies/Postage/Overnight Express Service

 Most grant budgets routinely request $300-$500 per year for each of these items. If you can anticipate the need for software upgrades or other routine maintenance expenses, they should go here as well. Your telephone budget should increase if you anticipate needing more lines than you currently have available, if you will be conducting telephone surveys or will be making significant long distance calls. Postage should be increased if you are conducting a mail survey or plan on doing mass mailings as part of the project.

Indirect Costs

12. IDC

Teachers College has a federally negotiated indirect cost rate of 68.8% on salaries only.

Not all federal programs will accept our negotiated rate. If a program sets a different rate, please print the guidelines for the reference of the Grants and Contracts Accounting Office. You may budget according to the rate set by the sponsor. Federal Training programs cap indirect costs at 8% of total direct costs, as do most programs from NYSED. 

Indirect Costs: Private Sponsors and Contracts

Most private sponsors publish policies on indirect costs.  TC policy is to request the maximum amount of indirect costs allowable under the sponsor guidelines.  If a sponsor-'s indirect cost policy caps the rate at less than 15%, TC requires documentation of that policy at the time of internal routing. 

TC's standard IDC rate for US-based, private, grant making foundations is 15% of total direct costs when the sponsor has no published IDC guidelines.


TC's standard IDC rate for proposals to all non-US based funding sources (foreign foundations, governments, and NGOs) and for performance-based, work-for-hire type contracts is 39.6% of total direct costs.  Proposals requesting IDC in amounts less than 39.6% of total direct costs require approval from the Provost and Vice President for Finance and Administration.

Other Budgeting Issues

Most sponsors set limits on the amount of funds you may request in a given proposal. These budget ceilings must be met by adjusting the direct costs of the proposal budget. Indirect costs may never be waived simply to meet a budget ceiling. There may be certain, limited circumstances when indirect costs may be waived. Formal requests for a Waiver of indirect costs should be submitted to the Associate Dean no later than two weeks prior to the deadline date.

A related issue is cost sharing. Applicants should be aware that, according to federal regulations, cost sharing may only be a consideration in the evaluation of a grant application if the program guidelines require it. Including cost sharing in a grant proposal that doesn't expressly request cost sharing will not help your proposal.

The current budget climate at the College means that we will be looking at proposals that do require cost sharing with particular scrutiny. All applicants are responsible for obtaining commitments to meet the cost share prior to submission of the application.

Budgeting needs to be a collaborative activity between the PI/project staff and OSP. Project staff should decide what its needs are for a given proposal; OSP can perform released time/overage, summer salary, fringe benefits and indirect cost calculations if you make your request at least one week prior to the sponsor deadline.

An issue that arises frequently during the budgeting process concerns the appropriateness of particular budget items. The National Science Foundation usually funds up to two month's salary per faculty investigator on each award, which faculty may take as released time, overage or summer salary. This is a reasonable rule of thumb for applications to other agencies as well, though the scope of a particular project can often make a request for more time entirely appropriate, especially from NIH, which routinely makes multiyear awards in the millions of dollars. Beyond that, there really are not many hard and fast rules about budget requests. Agency program officers can provide important guidance in this area. Keep in mind that program officers are extremely reluctant to discuss budget issues independently of programmatic issues and therefore will always want to discuss the budget with you as the investigator rather than the Director or some other administrator. Most often, what you need is guidance in demonstrating that an unusual budget request is warranted by the objectives of the project. Program officers are happy to provide this guidance and will usually be fairly direct in letting you know if a particular budget request is a deal breaker or not.

How the budget affects the chances of a proposal's ultimate success or failure is the source of much anxiety on the part of applicants. Reviewers are typically asked to evaluate if the applicant has identified sufficient resources to conduct the project as described, and at this point, coming in too low can hurt your chances just as much as coming in too high. Our indirect cost and fringe benefit rates, etc., will not factor in at this stage of the process. These issues do begin to matter when the peer review process has concluded and program officers have to choose among proposals given equal priority ratings by the review panel. Even so, it is not automatically true that funds will go to the proposal that comes in at the lowest cost. Many other factors come into play at this point, including granting funds to investigators whom the sponsor has supported before, supporting minority investigators and/or institutions (if that is stated as a priority in the RFP) and spreading benefits out over a wide geographical area. Remember that Federal agencies and private foundations are not profit-driven enterprises. If they have a budget of $15 m to give out during a particular funding cycle, they will give out $15 m, or otherwise lose it. No sponsoring agency operates under the assumption that the way to get the most "bang for the buck" is to distribute some funding to as many investigators as possible. If your budget is reasonable in relation to your objectives and contains no obvious padding or unnecessary expenditures, your chances of rejection for budgetary reasons are probably minimal. However, if your proposal received a high priority rating but was rejected for budgetary reasons, the program officer will tell you so if you inquire. In such instances, you will almost always be given advice about where to cut spending and be encouraged to apply during the next cycle.