C&I and Rooftop PPA Project Model
A project model for commercial rooftop, carport and ground-mount systems sold under a PPA or lease: solve for the rate that hits your return, test host terms, and value a buyout.
What it answers
Built around the decisions C&I developers, EPCs and project finance analysts actually make.
- PPA rate. The rate that hits your target return, solved directly.
- Host terms. Whether a host's term, escalator and credit justify the price.
- PPA or lease. Side-by-side economics of the two structures.
- Buyout value. What an early buyout is worth to you in any year.
- Structure cost. The return impact of carport or roof-work capex.
What's inside
- Inputs
- System size and type, capex, PPA or lease terms, escalator, host credit, opex, insurance, roof lease.
- Revenue
- PPA or lease revenue by year with escalation and degradation.
- Tax credits
- Base ITC plus adders and transferability.
- Debt
- Term debt sized to DSCR, closed-form.
- Cash flow
- Annual waterfall to equity.
- Buyout schedule
- Buyout value by year at your discount rate.
- Outputs
- Rate solve, project and equity IRR, NPV, LCOE, DSCR, payback.
- Checks
- Balance and tie-out flags.
Built for
- C&I developers quoting PPAs and leases
- EPCs offering financing to hosts
- Analysts reviewing third-party proposals
Not built for
- Residential leases
- Virtual or utility-scale PPAs
Build it, hire it, or buy it
| Build from scratch | Hire a consultant | Hillcrest model | |
|---|---|---|---|
| Cost | Your time | $5,000 to $15,000 | $499, or tailored from $2,500 |
| Time to first answer | 1 to 3 weeks | 2 to 6 weeks | Same day |
| Documentation | Rarely | Varies | Full user guide and sample case |
| You can audit every formula | Yes | Sometimes | Yes, 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.
C&I and Rooftop PPA Project Model
Price a commercial PPA or lease and see the return behind every cent per kWh.