Budget Worksheet

spar logo

 

To utilize SPAR's  Excel Template files, just click on the link below that applies to the length of your current proposal. 


Please note: the templates automatically calculate university average fringe rates and the federally-negotiated indirect/F&A rates. Please refer to the proposal guidelines for specific budgetary instructions.

1 Year Excel Template

2 Year Excel Template  

3 Year Excel Template

4 Year Excel Template 

5 Year Excel Template

6 Year Excel Template  

Sample Budget Justification (pdf)

How do you calculate person months?

Conversion of percentage of effort to person months is straight-forward. To calculate person months, multiply the percentage of your effort associated with the project times the number of months of your appointment. For example:

25% of a 9 month academic year appointment equals 2.25 (AY) person months (9 x .25= 2.25)

10% of a 12 month calendar appointment equals 1.2 (CY) person months (12 x .10 = 1.2)

35% of a 3 month summer term appointment equals 1.05 (SM) person months (3 x .35= 1.05)