Contract Funding and Burn Rate Tracker
3 free downloads per account. Just your email and a 6-digit code.
About this template
A contract burn rate tracker shows, for each government contract, how fast costs are being incurred against the money the government has actually obligated. Cost-type contracts that are incrementally funded carry the Limitation of Funds clause at FAR 52.232-22, and fully funded ones carry the Limitation of Cost clause at FAR 52.232-20. Both require written notice to the contracting officer before costs reach a set share of the funds or estimated cost.
The workbook takes monthly incurred costs per contract and calculates incurred to date, average monthly burn, projected spend over the look-ahead window, the projected percentage of funds, a notice flag, months of funding left and the run-out date. The default window and threshold are the 60 days and 75 percent named in both clauses, which a contract may vary.
Who it is for
The contracts manager or project controller who must warn the contracting officer before an incrementally funded contract runs out of money, and was asked for the status of every contract.
What is inside
- Contracts sheet with 8 worked contracts and 24 blank rows, 13 formula columns per row
- Costs incurred and average monthly burn pulled from the Monthly costs sheet with SUMIFS, never typed in
- Projected spend over the look-ahead window and the percentage of funds it reaches
- Notice flag against a threshold per contract, defaulting to the 75 percent and 60 day terms in FAR 52.232-22 and 52.232-20
- Months of funding left, the estimated run-out date and a red, amber or green status
- Monthly costs sheet with 40 worked rows, unbilled cost and cumulative cost formulas
- Settings sheet with the as-of date, window and threshold as marked input cells
- Summary sheet with portfolio totals, notice and status counts and the earliest run-out date
How to use it
Enter the as-of date on the Settings sheet, then add your contracts and their monthly costs; every other column calculates.
Files
- XLSXcontract-funding-and-burn-rate-tracker.xlsx20 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
When must a contractor notify under the Limitation of Funds clause?
FAR 52.232-22(c) requires written notice when the contractor has reason to believe that costs expected in the next 60 days, added to costs already incurred, will exceed 75 percent of the total amount allotted. The clause notes that a contract may vary the period from 30 to 90 days and the percentage from 75 to 85 percent.
What is the difference between funded value and contract value?
The contract value, or ceiling, is the total the contract may reach if fully funded. The funded or allotted amount is what the government has obligated so far. Work beyond the funded amount is at the contractor's risk, which is why the tracker measures burn against funding and shows unfunded value separately.
How is the run-out date calculated?
The tracker divides the funds remaining by the average monthly cost of the last few months, set on the Settings sheet, and adds that number of months to the as-of date. It is a straight-line estimate, so a planned ramp-up or a large subcontract invoice should be checked by hand.




