Spreadsheet: 07a49de1-f3e0-41dd-bb40-728dcc2b737a
Sheet: Complex Inputs

 | [NAME] for Deriving Total Project Capital Cost, if applicable
 | Sample inputs provided on this tab are illustrative only, all inputs must be provided and validated by the user.
 |  | $ | % Eligible for ITC | Depreciation Classification
 | Solar Panels | 3500000 | 1 | 5-year MACRS
 | Transportation/Delivery | 500000 | 1 | 5-year MACRS
 | [NAME] | 800000 | 1 | 5-year MACRS
 | Installation Labor | 200000 | 1 | 15-year SL
 | Inverters | 1000000 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | Total Generation Equipment Cost
 | Click Here to Return to Inputs Worksheet
 |  | $ | % Eligible for ITC | Depreciation Classification
 | Site Survey & Preparation | 175000 | 1 | 20-year SL
 | Balance of Facility / Electrical Collection System | 2150000 | 1 | 5-year MACRS
 | [NAME] | 0 | 0 | 20-year SL
 | Access Roads | 100000 | 1 | 20-year SL
 | Spare Parts | 25000 | 1 | 5-year MACRS
 | Commissioning | 50000 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | Total Balance of Plant Cost
 | Click Here to Return to Inputs Worksheet
 |  | $ | % Eligible for ITC | Depreciation Classification
 | Substation | 200000 | 0.5 | 20-year SL
 | Transformer | 50000 | 0.5 | 20-year SL
 | Metering | 25000 | 0.5 | 20-year SL
 | Utility System Improvements | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | placeholder | 0 | 0.5 | 20-year SL
 | Total Interconnection Cost
 | Click Here to Return to Inputs Worksheet
 |  | $ | % Eligible for ITC | Depreciation Classification
 | Site Selection & Evaluation | 100000 | 1 | 15-year SL
 | Site Acquisition Cost | 10000 | 1 | 20-year SL
 | Permitting | 350000 | 1 | 5-year MACRS
 | Engineering/Design | 500000 | 1 | 5-year MACRS
 | Resource Analysis | 20000 | 1 | 20-year SL
 | Other Development Costs | 300000 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | placeholder | 0 | 1 | 5-year MACRS
 | Total Development Costs & Fees
 | Click Here to Return to Inputs Worksheet
 |  | $ | % Eligible for ITC | Depreciation Classification
 | Lender Fee |  | 0 | Non-Depreciable
 | Interest During Construction |  | 0 | 20-year SL
 | Other Equity & Debt Closing Costs |  | 0 | 20-year SL
 | Initial Funding of Debt Service & Working Capital/O&M Reserves |  | 0 | Non-Depreciable
 | Total Installed Cost
 | Click Here to Return to Inputs Worksheet
 | Total Project Costs |  |  | Depreciation Allocation
 | Cost Category | $ | $ [NAME] for ITC | Cost Category | 5-year MACRS | 7-year MACRS | 15-year MACRS | 20-year MACRS | 5-year SL | 15-year SL | 20-year SL | 39-year SL | Non-Depreciable
 | Generation Equipment |  |  | Generation Equipment
 | Balance of Plant |  |  | Balance of Plant
 | Interconnection |  |  | Interconnection
 | Development Costs & Fee |  |  | Development Costs & Fee
 | Reserves & Financing Costs |  |  | Reserves & Financing Costs
 | Total Installed Cost
 | Taxable Entity? (turns on/off ITC and depreciation input cells)
 | Year-by-Year Inputs for Market Value of Production, if applicable
 |  | Project Year | Bundled* Market Value of Production (¢/kWh)
 |  |  | 5
 |  |  | 5.1
 |  |  | 5.202
 |  |  | 5.30604
 |  |  | 5.412160800000001
 |  |  | 5.520404016000001
 |  |  | 5.630812096320001
 |  |  | 5.7434283382464
 |  |  | 5.858296905011328
 |  |  | 5.975462843111555
 |  |  | 6.094972099973786
 |  |  | 6.216871541973262
 |  |  | 6.341208972812728
 |  |  | 6.468033152268982
 |  |  | 6.597393815314362
 |  |  | 6.729341691620649
 |  |  | 6.863928525453064
 |  |  | 7.001207095962125
 |  |  | 7.141231237881368
 |  |  | 7.284055862638995
 |  |  | 7.429736979891776
 |  |  | 7.578331719489611
 |  |  | 7.729898353879403
 |  |  | 7.884496320956991
 |  |  | 8.042186247376131
 |  |  | 8.203029972323653
 |  |  | 8.367090571770127
 |  |  | 8.53443238320553
 |  |  | 8.70512103086964
 |  |  | 8.879223451487032
 |  | * Includes energy, capacity & RECs