Model library

Development Budget and Milestone Tracker

A pipeline budget and cash tool for developers: spend by phase for every project, milestone payments under sale agreements, and the runway your company actually has.

What it answers

Built around the decisions development teams and founders of early-stage solar companies actually make.

  • Cash to NTP. How much each project needs to reach notice to proceed.
  • Milestone timing. When milestone payments under a sale agreement land, and what happens if one slips.
  • Runway. Months of runway across the pipeline at current burn.
  • Pipeline triage. Which projects to accelerate, pause or drop.

What's inside

Pipeline
Up to 40 projects with stage, utility, size and target dates.
Budget by phase
Site control, interconnection, permitting, engineering and legal spend per project.
Milestones
Payment milestones, amounts and expected dates for projects under sale agreements.
Cash forecast
Monthly cash in and out across the company for 36 months.
Dashboard
Spend to date, cash to NTP, runway and milestone calendar.
Checks
Tie-out flags.
Formulas only, inputs in blue, no macros, no circular references.

Built for

  • Developers running multi-project pipelines
  • Founders managing burn against milestone income

Not built for

  • Construction budgeting and EPC cost control

Build it, hire it, or buy it

Build from scratchHire a consultantHillcrest model
CostYour time$5,000 to $15,000$299, or tailored from $2,500
Time to first answer1 to 3 weeks2 to 6 weeksSame day
DocumentationRarelyVariesFull user guide and sample case
You can audit every formulaYesSometimesYes, fully unlocked

Questions

Which versions of Excel does it work in?

Microsoft 365 and Excel 2019 or later, on Windows or Mac. There are no macros. It is built for Excel; Google Sheets is not supported.

What tax credit assumptions does it use?

Credit rates, adders and transferability pricing are inputs, so you set them to current law and your deal. The user guide explains each one and where to confirm it.

Can I use it for more than one project?

Yes: unlimited projects within one company, for up to three named users. Larger teams are covered by a Professional engagement, which includes an organization-wide license.

Do I get updates?

Yes, free for 12 months. We email a new version when inputs or structure change.

What if something is wrong?

Email us. If there is an error we cannot fix within 14 days of purchase, we refund you in full. See the terms.

Can you tailor it to my deal?

Yes. Professional engagements set the model up on your first deal and train your team, from $2,500. Institutional builds tailored to your structure start at $7,500. See team and institutional options.

Development Budget and Milestone Tracker

Track development spend and cash runway across a pipeline, project by project.