Tools & Templates
Cost Share Calculator
Plan salary cap distributions across fiscal years and review adjustment scenarios in one place.
Excel Template Available
Prefer to work in Excel?
Download the blank cost share template and complete it offline in the spreadsheet format.
How to Use This Tool
Enter the project dates first, then complete the key inputs. The calculator will generate fiscal-year rows automatically and apply the salary cap logic by year.
This tool uses month-based fiscal year proration so results are aligned to fiscal-year month segments rather than daily allocation.
If projected salary is at or below the cap, grant LOE equals total LOE. If projected salary exceeds the cap, grant LOE is reduced and the remainder moves to cost share.
Use the adjustment table to test a known grant salary or known grant LOE for a selected fiscal year and review the reverse-calculated split for a defined adjustment period.
Project Details
Enter the project dates to generate the fiscal year breakdown automatically.
This tool uses month-based fiscal year proration and treats the entered end date as inclusive. Enter the last day of the project period as reflected on the NOA and follow institutional salary allocation policies. This calculator is intended for planning purposes—final decisions should align with the award and sponsor terms.
Key Inputs
These values drive the salary cap and cost share calculations for each generated fiscal year.
Fiscal Year Breakdown
The online version is dynamic and can generate as many fiscal years as needed based on the project dates.
| Fiscal Year | Start | End | Months | Proration |
|---|
Main Cost Share Calculation
Grant LOE is capped when salary exceeds the cap. Cost share LOE is the remaining effort.
| FY | Months | Proration | Projected Salary | Salary Cap | Total LOE % | Grant LOE % | C/S LOE % | Grant Salary | Grant Fringe | C/S Salary | C/S Fringe | Total Grant Cost | Total C/S Cost |
|---|
Summary
High-level totals across all generated fiscal years.
Adjustment / Reverse Calculation
Select a fiscal year and test a known grant salary or known grant LOE for that year.
Adjustment calculations apply within a single selected fiscal year. Enter the number of months to prorate for the adjustment period. If salary changed during that fiscal year, use the salary override field or confirm the correct salary basis before relying on the result.
| Selected FY | Salary Used | Months | Proration | Total LOE % | Reverse Grant LOE % | Reverse C/S LOE % | Reverse Grant Salary | Reverse Grant Fringe | Reverse C/S Salary | Reverse C/S Fringe |
|---|
Need a clean record of the calculator output? Use the print dialog and choose Save as PDF.