# The Renewable Energy Development Handbook: companion files

Julian R. Sterling

## What is here

- **Renewable_Energy_Development_Model.xlsx**: the workbook that rebuilds every case figure in the book with live formulas (Appendix A). Sheets: Cover, Inputs, Capex, Energy, Market, Opex, Credits, Cases, Breakeven, Sensitivities, Screening, Interconnection, Stages, Sale, Debt, Tax equity, FEOC, Wind, Hybrid, EPC, Checks.
- **Renewable_Energy_Diligence_Checklists.docx**: the diligence checklists of Appendix B in editable form.

## Which sheet answers which chapter

- Chapters 1, 5, 10 and 14: Stages (value by milestone, delay, Calder's return) and Sale (earlier sales, milestone payments, platform)
- Chapter 2: Screening (three sites and the wind alternative)
- Chapter 3: Opex (land rent, decommissioning) and Sensitivities (rent)
- Chapter 4: Energy (losses, P50, P90, P99)
- Chapter 6: Interconnection (deposits, upgrade shocks)
- Chapter 7: Market, Cases and Breakeven (utility PPA, virtual PPA, merchant)
- Chapters 8 and 9: Capex, Sensitivities (modules, trackers) and EPC
- Chapter 10: Cases (development value and its bridge) and Sensitivities (tornado)
- Chapter 11: Credits (PTC, ITC, bonuses, transfer) and FEOC (foreign entity test)
- Chapter 12: Debt and Tax equity
- Chapter 13: Hybrid (battery option)
- Chapter 15: EPC (delay damages, retention, performance)

## Two inputs to change first

1. The network upgrades override (bottom of Inputs): enter 30,000,000 and watch case U fall from $33.4 million to $21.6 million on Cases; Interconnection shows why each extra $1 million costs more than $1 million discounted one year.
2. The credit switch: set it to None and case U falls to minus $39.6 million; set it to ITC and it reads $6.6 million. Reset it, then set the energy level to P90 to see $10.9 million.

Blue type is an input, black type a formula. Every input carries a range name (cf_p50, u_price, premium ...). No macro, no circular reference, no external link, no hidden sheet. The Checks sheet should read ALL OK on the default inputs: 431 printed figures and 10 identities. Reset each switch after a test.

Cedar Hollow Solar, Hartwell Ridge Wind, Calder Plains Renewables, Ashgrove Clean Power Fund, Norland Electric Cooperative, Quillon Data Systems, Ironbridge Constructors, Larkspur Solar Manufacturing and Marlow County are fictional; all case figures are illustrative teaching assumptions. Provided as is, without warranty. Not investment, legal, tax, accounting or engineering advice.