{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions and Assumptions","Project Info","Building Info","Multiple Buildings","Summary and S1 Review","Advanced Inputs","HPD Approval Form","Roof Layout","Results","Data Validation","Assumptions Calcs & Lookups","HPD Underwriting","25 Year Cash Flow","Change Log"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":205,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions and Assumptions","index":0,"n_rows":271,"n_cols":6,"rows_kept":271,"cut":false,"hidden":false,"merged":[[12,0,12,6],[189,0,189,6],[179,2,179,3],[47,1,47,2],[182,2,182,3],[180,2,180,3],[47,3,47,4],[48,3,48,4],[67,2,67,4],[68,2,68,4],[114,0,114,6],[51,3,51,4],[52,3,52,4],[49,5,49,6],[64,2,64,4],[95,0,95,6],[53,1,53,2],[53,3,53,4],[54,3,54,4],[55,3,55,4],[54,1,54,2],[55,1,55,2],[56,1,56,2],[56,3,56,4],[249,3,249,4],[250,3,250,4],[248,5,248,6],[249,5,249,6],[250,5,250,6],[245,0,246,6],[86,0,89,6],[96,0,98,6],[234,1,243,6],[99,0,99,6],[116,0,116,1],[117,0,117,1],[118,0,118,1],[221,1,221,6],[115,2,115,6],[116,2,116,6],[115,0,115,1],[153,0,153,3],[154,0,154,6],[190,0,190,6],[101,0,106,6],[109,0,112,6],[100,0,100,6],[92,0,92,6],[270,0,274,6],[229,1,233,6],[58,0,59,6],[224,1,226,6],[209,1,213,6],[216,1,220,6],[173,0,176,6],[185,0,187,6],[194,0,195,6],[197,1,201,6],[147,0,151,6],[157,0,162,6],[163,0,163,6],[253,1,258,6],[261,1,264,6],[247,1,247,2],[247,3,247,4],[247,5,247,6],[248,1,248,2],[249,1,249,2],[250,1,250,2],[113,0,113,6],[90,0,90,6],[91,0,91,6],[43,1,43,6],[19,0,19,6],[23,0,23,6],[30,0,30,6],[37,0,39,6],[31,0,34,6],[48,1,48,2],[49,1,49,2],[21,0,21,6],[44,3,44,4],[45,1,45,2],[44,5,44,6],[44,1,44,2],[45,3,45,4],[46,3,46,4],[2,2,2,5],[3,2,3,5],[27,2,27,5],[28,2,28,5],[63,2,63,5],[55,5,55,6],[56,5,56,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[46,1,46,2],[5,0,5,6],[6,0,11,6],[13,0,13,6],[15,0,15,6],[17,0,17,6],[49,3,49,4],[50,3,50,4],[50,1,50,2],[51,1,51,2],[52,1,52,2],[107,0,107,6],[108,0,108,6],[73,2,73,4],[74,2,74,4],[69,2,69,4],[70,2,70,4],[71,2,71,4],[72,2,72,4],[75,2,75,4],[85,0,85,6],[66,2,66,4],[65,2,65,4],[83,0,83,6],[252,1,252,6],[260,1,260,6],[269,0,269,6],[228,1,228,6],[223,1,223,6],[208,1,208,6],[181,2,181,3],[117,2,117,6],[118,2,118,6],[119,2,119,6],[166,1,171,6],[135,0,145,6],[123,0,124,6],[126,0,128,6],[130,0,133,6],[178,2,178,4],[120,2,120,6],[266,1,266,6],[119,0,119,1],[120,0,120,1],[202,1,202,6],[204,1,204,6],[206,1,206,6],[248,3,248,4]]}
[]
[]
[null,null,"SOLAR FEASIBILITY ANALYSIS"]
[null,null,"        Version 2025 1.1, Updated May 2025"]
[]
["Instructions"]
["The Solar Feasibility Analysis tool can be used to complete a preliminary assessment of solar financial viability for New York City affordable housing properties. This tool was developed by the New York City Department of Housing Preservation and Development (HPD), with support from non-profit Solar One, as part of the agency's efforts to increase the deployment of solar energy systems on affordable housing properties participating in HPD programs. Completing this Solar Feasibility Analysis is an HPD requirement for Substantial Rehabilitation & Preservation projects, and optional for New Construction projects. Solar One can provide free and comprehensive solar technical assistance to all HPD projects. Contact affordable@solar1.org with any inquiries."]
[]
[]
[]
[]
[]
["Note for New Construction: As of July 1, 2024, HPD's \"Solar Where Feasible\" requirement is no longer in effect. While it is no longer mandatory for New Construction projects to submit an analysis and receive an HPD Approval Form, we encourage Development teams to continue utilizing the solar feasibility analysis to assist with Local Law 92/94 compliance. This tool is a preliminary resource for assessing solar viability, maximizing available incentives, and optimizing solar design for your projects. "]
["1. User Inputs: populate all blue fields on the Project Info and Building Info tabs. Please confirm that all fields are populated accurately, as these inputs impact the solar financial model. If you do not understand what value to enter into a required field, hover over the field to view a pop-up with explanatory text and links."]
[]
["2. Advanced Inputs (Optional):  if you have verified information regarding the project, such as a detailed solar design with a specific price, you can enter this information in the Advanced Inputs tab. All fields on the Advanced Inputs tab are optional, and values provided in the Advanced Inputs tab will override the calculator's default assumptions.         "]
[]
["3. Roof Layout: Provide image/s of roof plan(s) with solar layout or the Sustainable Roofing Zone. Please include any existing or planned equipment (e.g. HVAC systems, electrification equipment, cell towers, antennas, roof decks, LL11 rigging equipment, etc.). Please note in the comments section if green roof is being incorporated to satisfy DEP requirements. Identify key features on the image or within the Roof Layout comments section."]
[]
["4. Results: review this tab, which is read-only, for a summary of financial benefits of solar at the site, calculated based on user inputs. Results include key financial metrics such as the Upfront Cost Estimate, Year One Electricity Savings, and Payback Period."]
[]
["5. 25 Year Cashflow: to view a 25 year cash flow analysis of the solar energy system, click \"VIEW 25 YEAR CASH FLOW\" on the Results tab. This will display another page which includes a breakdown of costs and benefits by year over a 25 year analysis period."]
[]
["6. Submission: once you have completed the HPD Solar Feasibility Analysis for your project, submit it along with the Roof Plan and any additional documentation by clicking \"SUBMIT SOLAR FEASIBILITY ANALYSIS\" on the Results tab. "]
[]
[]
[]
[null,null,"SOLAR FEASIBILITY ANALYSIS"]
[null,null,{"$f":"C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["Assumptions"]
["The following pages outline assumptions included in the Solar Feasibility Analysis. Disclaimer: Solar One is providing this preliminary analysis tool on an as-is basis and makes no claims regarding the accuracy of calculations, assumptions and figures provided herein. Solar technical feasibility, installation costs, incentives, energy generation, and electricity bill savings may vary."]
[]
[]
[]
[]
["Solar Energy System Costs"]
["Unless a user provides the total cost of the solar energy system via Advanced Inputs, the cost is estimated based on user inputs. Key cost drivers that are accounted for in the tool include system size (in kilowatts-DC), mounting method, building height, and the complexity of permitting and metering. "]
[]
[]
[]
["First, a base price is estimated based on system size:"]
[]
[null,{"$f":"'Assumptions Calcs & Lookups'!A3","v":"System Price Estimate ($/Watt-DC)"}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A4","v":"Min (kW-DC)"},null,{"$f":"'Assumptions Calcs & Lookups'!B4","v":"Max (kW-DC)"},null,{"$f":"'Assumptions Calcs & Lookups'!C4","v":"Price ($/Watt-DC)"}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A5","v":4},null,{"$f":"'Assumptions Calcs & Lookups'!B5","v":9.99},null,{"$f":"'Assumptions Calcs & Lookups'!C5","v":5.7}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A6","v":10},null,{"$f":"'Assumptions Calcs & Lookups'!B6","v":19.989999999999998},null,{"$f":"'Assumptions Calcs & Lookups'!C6","v":4.88}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A7","v":20},null,{"$f":"'Assumptions Calcs & Lookups'!B7","v":29.99},null,{"$f":"'Assumptions Calcs & Lookups'!C7","v":4.16}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A8","v":30},null,{"$f":"'Assumptions Calcs & Lookups'!B8","v":44.99},null,{"$f":"'Assumptions Calcs & Lookups'!C8","v":3.83}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A9","v":45},null,{"$f":"'Assumptions Calcs & Lookups'!B9","v":64.989999999999995},null,{"$f":"'Assumptions Calcs & Lookups'!C9","v":3.61}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A10","v":65},null,{"$f":"'Assumptions Calcs & Lookups'!B10","v":79.989999999999995},null,{"$f":"'Assumptions Calcs & Lookups'!C10","v":3.45}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A11","v":80},null,{"$f":"'Assumptions Calcs & Lookups'!B11","v":99.99},null,{"$f":"'Assumptions Calcs & Lookups'!C11","v":3.34}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A12","v":100},null,{"$f":"'Assumptions Calcs & Lookups'!B12","v":149.99},null,{"$f":"'Assumptions Calcs & Lookups'!C12","v":3.17}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A13","v":150},null,{"$f":"'Assumptions Calcs & Lookups'!B13","v":249.99},null,{"$f":"'Assumptions Calcs & Lookups'!C13","v":2.95}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A14","v":250},null,{"$f":"'Assumptions Calcs & Lookups'!B14","v":499.99},null,{"$f":"'Assumptions Calcs & Lookups'!C14","v":2.73}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A15","v":500},null,{"$f":"'Assumptions Calcs & Lookups'!B15","v":749.99},null,{"$f":"'Assumptions Calcs & Lookups'!C15","v":2.62}]
[null,{"$f":"'Assumptions Calcs & Lookups'!A16","v":750},null,{"$f":"'Assumptions Calcs & Lookups'!B16","v":0},null,{"$f":"'Assumptions Calcs & Lookups'!C16","v":2.5099999999999998}]
[]
["The default base prices in this tool are informed by the publicly available NYSERDA solar project dataset which includes system size and pricing for all solar projects that received incentives from NYSERDA."]
[]
[]
["Next, pricing adders are applied based on the project's complexity:"]
[]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A19","v":"Pricing Adders"}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A20","v":"Mechanically Attached Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B20","v":0.25}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A21","v":"Canopy Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B21","v":1.2}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A22","v":"Tall Building First Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B22","v":0.2}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A23","v":"Tall Building First Adder Threshold (>70ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B23","v":70}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A24","v":"Tall Building Second Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B24","v":0.2}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A25","v":"Tall Building Second Adder Threshold (>150ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B25","v":150}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A26","v":"Tall Building Third Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B26","v":0.2}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A27","v":"Tall Building Third Adder Threshold (>200ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B27","v":200}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A28","v":"Landmarks Adder ($/Project)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B28","v":1250}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A29","v":"New Meter Adder ($/Project)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B29","v":1500}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A30","v":"Prevailing Wage Adder (%)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B30","v":0.2}]
[]
["The Mechanically Attached Adder is applied for system < 15 kW-DC or more than 100 feet tall."]
["The Canopy Adder is applied if \"Solar Canopy Design\" = \"Yes\"."]
["The Tall Building Adders are applied on top of any other pricing adders based on the building height."]
["The Landmarks Adder is applied if \"Landmarks or Historic District\" = \"Yes\"."]
["The New Meter Adder is applied if the system will be installed as a Community Solar (or CDG) type system. "]
["A Prevailing Wage Adder of 20% is applied to all projects where Prevailing Wages are required."]
[]
["Note: The solar EPC price may be overridden using the Total Solar Energy System Price ($/Watt-DC) located in Advanced Inputs.  The base price and/or the Turnkey Cost may be further adjusted using the Total Price Adjustment % input located in Advanced Inputs. The Total Price Adjustment (%) is used to estimate a percentage increase or decrease due to inflation, high-end materials, or other factors. A positive decimal will increase the price by that percentage (i.e. 0.5 is +50%) and a negative decimal will decrease the price by that percentage (i.e. -0.5 is -50%). Alternatively, a specific dollar amount can be added to the price with the Total Price Adjustment ($). Note: only one Price Adjustment can be used at a time.  "]
[]
["Solar Energy System Size"]
["Unless a user specifies the solar energy system size using Advanced Inputs, the system size is estimated based on user inputs. Key inputs that impact estimated system size include: Est. Usable Roof Area for Solar (sq ft), Solar Canopy Design (which impacts the assumed power density), and Est. Annual Owner-Paid Electricity Costs. "]
[]
[]
[]
[]
["First, the maximum possible system size is estimated based on Est. Usable Roof Area for Solar (sq ft) and assumed power density (Watts-DC/square foot). "]
[]
[null,"Standard Power Density: 12 Watts-DC/sq ft"]
[null,"Canopy Power Density: 14 Watts-DC/sq ft"]
[]
["Next, the system size is used to estimate annual solar energy generation and utility bill savings. If the system is oversized relative to the Owner-Paid Electricity Cost, the system size is reduced to offset no more than 100% of the owner-paid electricity bills."]
[]
[]
[]
["Solar Energy Production"]
["Unless a user specifies Year One Production (kWh) using Advanced Inputs, the estimated year one solar production is estimated by multiplying the system size (kW-DC) by a production factor of 1,150 kWh/kW-DC. This is a reasonable production factor for a solar PV system in NYC. Please note that actual solar production varies based on several factors, including solar panel tilt, orientation, shade, inverter efficiency, and normal weather variability. This tool assumes that solar energy production degrades by 0.5% each year to account for normal/expected solar panel performance degradation."]
[]
[]
[]
[]
[]
[]
["Electricity Bill Savings"]
["Unless a user enters override values for the Value of Solar ($/kWh) fields using Advanced Inputs, electric bill savings are estimated based on the Owner-Paid Electricity Information fields on the User Inputs tab as well as the Year One Production (kWh) estimate. The logic used to estimate electricity bill savings based on Owner-Paid Electricity Information is fairly sophisticated:"]
[]
[]
[]
[]
["Electric Tariff: assuming the utility is Con Edison and the user does not specify the electric tariff with Advanced Inputs, user inputs are evaluated to estimate the owner-paid electric tariff/rate class:"]
["Con Edison Tariff",null,"Description"]
["EL9",null,"Large Commercial (typical electricity tariff for elevator building common areas with individually metered apartments)"]
["EL2",null,"Small Commercial (typical electricity tariff for walk up building common areas with individually metered apartments)"]
["EL8",null,"Master Metered Residential Rate"]
["EL1",null,"Residential and Religious Rate (most common for individual apartments or houses of worship)"]
["EL12",null,"Master Metered Residential Rate w/Electric Resistance Heating"]
[]
[]
["Annual Usage (kWh): unless the user enters Annual Electricity Usage (kWh) using Advanced Inputs, this value is estimated based on the Owner-Paid Electricity Cost ($) and the Electric Tariff:"]
[]
[]
[{"$f":"\"If the electric tariff is EL8, EL9 or EL12, the total owner paid electricity bill is divided by a simple blended electricity rate of \"&TEXT(EL8_,\"$0.00\")&\"/kWh to estimate annual usage. If the electric tariff is EL1 or EL2, the total owner paid electricity bill is divided by a simple blended electricity rate of \"&TEXT(EL1_,\"$0.00\")&\"/kWh to estimate annual usage.\"","v":"If the electric tariff is EL8, EL9 or EL12, the total owner paid electricity bill is divided by a simple blended electricity rate of $0.16/kWh to estimate annual usage. If the electric tariff is EL1 or EL2, the total owner paid electricity bill is divided by a simple blended electricity rate of $0.33/kWh to estimate annual usage."}]
[]
[]
[]
["Peak Demand (kW): unless a user enters Peak Demand (kW) using Advanced Inputs, this value is estimated based on Annual Usage and assuming a load ratio of 50%. While solar does not typically reduce demand charges, Peak Demand is an important input to estimate the Year One Value of Solar ($/kWh) for multifamily EL9 electricity customers."]
[]
[]
[]
[]
["Year One Value of Solar ($/kWh): estimating the value of solar in New York State is complex. There are currently two distinct regimes for valuing solar energy; net energy metering, where solar energy directly offsets the volumetric portion of an owner-paid electricity bill or alternatively the Value of Distributed Energy Resources (VDER) tariff, a monetary crediting methodology that accounts for the location-specific benefits of distributed energy resources. VDER was adopted by New York State for large commercial customers and optionally for all customers over the last few years, and in some cases it can allow for greater utility bill savings than net metering. Unless the user enters a Year One Value of Solar using the Advanced Inputs, this value is estimated based on the Electric Tariff, Peak Demand, and corresponding metering recommendation to maximize the value of solar energy. Please note: for the small subset of NYC buildings in PSEG-LI territory, we recommend entering the Year One Value of Solar ($/kWh) using Advanced Inputs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Net Energy Metering"]
[{"$f":"\"For \"&CHAR(147)&\"behind-the-meter\"&CHAR(148)&\" solar projects, this tool assumes that the year one value of solar is \"&TEXT(EL8_,\"$0.00\")&\"/kWh for demand-metered electric tariffs (EL8, EL9, EL12) and \"&TEXT(EL1_,\"$0.00\")&\"/kWh for non-demand-metered tariffs (EL1 and EL2). \"&\"Net metering is generally recommended for EL1 and EL2 accounts as well as very large EL9 accounts, \"&\"although there are exceptions and we recommend that building owners consult with a solar expert regarding their solar credit distribution strategy to maximize savings. \"","v":"For “behind-the-meter” solar projects, this tool assumes that the year one value of solar is $0.16/kWh for demand-metered electric tariffs (EL8, EL9, EL12) and $0.33/kWh for non-demand-metered tariffs (EL1 and EL2). Net metering is generally recommended for EL1 and EL2 accounts as well as very large EL9 accounts, although there are exceptions and we recommend that building owners consult with a solar expert regarding their solar credit distribution strategy to maximize savings. "}]
[]
[]
[]
[]
[]
["Customer Benefit Contribution"]
[{"$f":"\"Solar projects that are not compensated under Community Distributed Generation (CDG) will be subject to monthly utility fees. \"&\"For a non-demand metered electric customer (EL2) whose solar project is compensated under Net Energy Metering, the fee is estimated to be \"&TEXT(CBC_NEM_EL2,\"$0.00\")&\"/kW-DC/month. \"","v":"Solar projects that are not compensated under Community Distributed Generation (CDG) will be subject to monthly utility fees. For a non-demand metered electric customer (EL2) whose solar project is compensated under Net Energy Metering, the fee is estimated to be $2.15/kW-DC/month. "}]
[]
["Value of Distributed Energy Resources (VDER)"]
["For electricity that is exported to the Con Edison grid and compensated under VDER, either through a new or existing meter, the solar energy is valued based on a number of user inputs and assumptions. The New York State Energy Research and Development Authority (NYSERDA) publishes and maintains a VDER Calculator, a spreadsheet-based tool that is used to accurately estimate the value of solar energy. This tool was referenced during the creation of the HPD Solar Feasibility Analysis, and it can be accessed here:"]
[]
[]
[]
[]
[]
["https://www.nyserda.ny.gov/All-Programs/NY-Sun/Contractors/Value-of-Distributed-Energy-Resources/Value-Stack-Calculator"]
[]
[null,"Commercial System Relief Program (CSRP) Zone"]
[null,"Con Edison's Commercial System Relief Program (CSRP) zones impact the value a building will receive for solar energy under VDER, with a higher value given to solar projects in day-peaking load zones, where the solar energy offsets demand for electricity during peak times. Unless a user specifies their CSRP Load Zone using Advanced Inputs, this tool makes the conservative assumption that all proposed solar projects are located in a 4:00 PM-8:00 PM CSRP zone, which will result in a lower estimated value of solar energy."]
[]
[]
[]
[]
[]
[]
["The table below summarizes the estimated Year One Value of Solar for projects compensated under VDER. Values were calculated using the NYSERDA VDER calculator. This tool assumes that all projects are located in the most common CSRP Zone unless otherwise indicated using the Advanced Inputs."]
[]
[]
[]
[]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A63","v":"VDER: Value of Solar by CSRP Load Zone ($/kWh)"}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A64","v":"11:00 AM-3:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B64","v":0.19309999999999999}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A65","v":"2:00 PM-6:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B65","v":0.16289999999999999}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A66","v":"4:00 PM-8:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B66","v":0.13700000000000001}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A67","v":"7:00 PM-11:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B67","v":0.11269999999999999}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!C64","v":"Source: NYSERDA VDER Calculator Version 3.2, published February 2025. Last updated March 2025."}]
[]
["Value of Solar Annual Escalation (%): unless a user specifies this value using Advanced Inputs, the assumed annual increase in the value of solar is 1.0% for projects receiving compensation under VDER and 2.5% for projects receiving compensation under net energy metering."]
[]
[]
[]
["New Meter Fees"]
[{"$f":"\"Solar projects compensated under the Community Distributed Generation program require new Con Edison meters. The monthly meter fee is estimated to be \"&TEXT(CDGMonthlyMeterFee,\"$0.00\")&\"/month.\"","v":"Solar projects compensated under the Community Distributed Generation program require new Con Edison meters. The monthly meter fee is estimated to be $27.00/month."}]
[]
[]
["Solar Incentives"]
["Solar energy systems are eligible for a number of federal, state and local incentives that improve the return on investment for solar energy systems. This tool incorporates the following incentives:"]
[]
[]
[null,"Federal Tax Credit: solar projects installed in the United States are eligible for a federal income tax credit. The tax credit is currently available for commercial businesses (as the Investment Tax Credit or ITC), for tax-exempt organiztions (through Elective/Direct pay), or for owner-occupied homes, including co-ops and condos (as the RETC: Residential Energy Tax Credit - option to be taken through Transferability). This tool assumes that the basis for the tax credit is the gross system cost. Users can override the default assumptions using Advanced Inputs. Learn more about the RETC here: "]
[]
[]
[]
[]
[null,"https://www.irs.gov/credits-deductions/residential-clean-energy-credit"]
[null,"and the ITC here: "]
[null,"https://www.energy.gov/sites/default/files/2024-02/508%20Federal%20Solar%20Tax%20Credits%20for%20Businesses_Feb24.pdf   "]
[null,"and Elective/Direct Pay and Transferability here: "]
[null,"https://www.irs.gov/credits-deductions/elective-pay-and-transferability"]
[]
[null,"New York State Residential Tax Credit"]
[null,{"$f":"\"Residents of owner-occupied multifamily buildings are eligible to receive a state income tax credit of up to \"&TEXT('Assumptions Calcs & Lookups'!B88,\"00%\")&\" of the cost of a solar energy system after deducting the NY-Sun incentive. This tax credit goes directly to residents and is non-refundable, so owner-residents must have a tax liability to take this incentive. \"&\"The NYS Residential Tax Credit is currently capped at $5,000 per household and is capped at 50 kilowatts-DC on a per project basis. The incentive is included in the financial analysis only if indicated in the Advanced Inputs.\"","v":"Residents of owner-occupied multifamily buildings are eligible to receive a state income tax credit of up to 25% of the cost of a solar energy system after deducting the NY-Sun incentive. This tax credit goes directly to residents and is non-refundable, so owner-residents must have a tax liability to take this incentive. The NYS Residential Tax Credit is currently capped at $5,000 per household and is capped at 50 kilowatts-DC on a per project basis. The incentive is included in the financial analysis only if indicated in the Advanced Inputs."}]
[]
[]
[]
[]
[]
[null,"New York State Historic Rehabilitation Tax Credit"]
[null,{"$f":"\"Residents of owner-occupied multifamily buildings that are listed on the National Register and in income qualifying census tracts are eligible for a state income tax credit worth \"&TEXT('Assumptions Calcs & Lookups'!B91,\"00%\")&\" of the cost of a solar energy system. This incentive is included in the financial analysis if indicated in the Advanced Inputs. Learn more about this incentive program here:\"","v":"Residents of owner-occupied multifamily buildings that are listed on the National Register and in income qualifying census tracts are eligible for a state income tax credit worth 20% of the cost of a solar energy system. This incentive is included in the financial analysis if indicated in the Advanced Inputs. Learn more about this incentive program here:"}]
[]
[]
[]
[]
[null,"https://parks.ny.gov/shpo/tax-credit-programs/"]
[]
[null,"Interaction Between NY State Incentives and Federal Income Taxes"]
[null,{"$f":"\"This model assumes that offsetting a state income tax bill results in a corresponding increase to federal taxable income. The model assumes that the incremental taxable federal income is taxed at \"&TEXT('Assumptions Calcs & Lookups'!B88,\"00%\")&\". The model also assumes that NY-Sun Incentives are taxable for for-profit businesses but not for home owners. \"","v":"This model assumes that offsetting a state income tax bill results in a corresponding increase to federal taxable income. The model assumes that the incremental taxable federal income is taxed at 25%. The model also assumes that NY-Sun Incentives are taxable for for-profit businesses but not for home owners. "}]
[]
[]
[]
[null,"NYC Solar Property Tax Abatement"]
[null,{"$f":"\"Solar projects in NYC may be eligible for a solar property tax abatement equal to \"&TEXT('Assumptions Calcs & Lookups'!B89,\"00%\")&\" of the cost of the system after deducting the NY-Sun incentive, applied in equal increments of \"&TEXT('Assumptions Calcs & Lookups'!B89/4,\"0.0%\")&\" over the course of four years. If a building already has full tax exemption or certain abatements, this incentive cannot be monetized. If a building has a partial exemption, this incentive may be monetized on the remaining taxes. \"&\"A user can specify eligibility for the NYC Property Tax Abatement on the Building Info tab and elaborate on eligibility in the Comments section.\"","v":"Solar projects in NYC may be eligible for a solar property tax abatement equal to 30% of the cost of the system after deducting the NY-Sun incentive, applied in equal increments of 7.5% over the course of four years. If a building already has full tax exemption or certain abatements, this incentive cannot be monetized. If a building has a partial exemption, this incentive may be monetized on the remaining taxes. A user can specify eligibility for the NYC Property Tax Abatement on the Building Info tab and elaborate on eligibility in the Comments section."}]
[]
[]
[]
[]
[null,"Low Income Housing Tax Credits: solar energy systems can be included in the basis for LIHTCs. When a project includes LIHTCs, it can significantly improve the economics of the solar project because LIHTCs can be combined with solar incentives. There are two ways for a user to indicate that a solar project is eligible for LIHTCs; on the Building Info tab, a user can enter one of the following values into the field Low Income Housing Tax Credits: \"No\", \"4%\", or \"9%\". As of December 2020, pursuant to the Covid-Related Tax Relief Bill of 2020, Congress created a 4.00% permanent floor for the value of this incentive (i.e. the 4% LIHTC is no longer floating at a rate between 3-4%). The other way that a user can indicate the Low Income Housing Tax Credit value is through the Advanced Inputs tab, where a user can specify the exact LIHTC rate. The eligible LIHTC basis is the total cost of the solar energy system."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NY-Sun Incentives"]
["NYSERDA offers a capacity-based incentive for solar projects in New York, as a base incentive plus a multifamily affordable housing adder of $0.60/Watt-DC for projects up to 200 kW-DC. The base incentive steps down above 200 kW-DC, and the affordable housing adder is only applied to the first 200 kW-DC of the system. The table below summarizes the estimated level of the base NY-Sun Incentive by system size:"]
[]
[null,"Con Edison NY_SUN Incentive",null,"Project Size (kW-DC)",null,"Incentive Rate ($/W)"]
[null,"Small",null,"0-200 kW",null,{"$f":"'Assumptions Calcs & Lookups'!M5","v":0.6}]
[null,"Medium",null,"200-1,000 kW",null,{"$f":"'Assumptions Calcs & Lookups'!L5","v":0.6}]
[null,"Large",null,">1,000 kW",null,{"$f":"'Assumptions Calcs & Lookups'!K5","v":0.5}]
[]
[null,"NY-Sun Multifamily Affordable Incentive: "]
[null,{"$f":"\"For affordable housing solar projects, the NY-Sun incentive is \"&TEXT('Assumptions Calcs & Lookups'!M5+'Assumptions Calcs & Lookups'!N5,\"$0.00\")&\"/Watt-DC for the first 200 kW-DC. This tool assumes that all NY projects are eligible to receive the NY-Sun Incentive including the affordable adder unless otherwise indicated in the Advanced Inputs. \"&\"This incentive cannot be stacked with other NY-Sun adders (e.g. the Inclusive Community Solar Adder, or the Rooftop Adder).  \"&\"Please note: for the small subset of NYC buildings in PSEG-LI territory, the NY-Sun Multifamily Affordable incentive is $1.00/Watt-DC. We recommend entering the NYSERDA NY-Sun Incentive using Advanced Inputs.\"","v":"For affordable housing solar projects, the NY-Sun incentive is $1.60/Watt-DC for the first 200 kW-DC. This tool assumes that all NY projects are eligible to receive the NY-Sun Incentive including the affordable adder unless otherwise indicated in the Advanced Inputs. This incentive cannot be stacked with other NY-Sun adders (e.g. the Inclusive Community Solar Adder, or the Rooftop Adder).  Please note: for the small subset of NYC buildings in PSEG-LI territory, the NY-Sun Multifamily Affordable incentive is $1.00/Watt-DC. We recommend entering the NYSERDA NY-Sun Incentive using Advanced Inputs."}]
[]
[]
[]
[]
[]
[]
[null,"NY-Sun Affordable CDG Incentive"]
[null,{"$f":"\"In addition to the affordable housing adder, NY-Sun provides a Multifamily Affordable CDG adder of an additional \"&TEXT('Assumptions Calcs & Lookups'!O5,\"$0.00\")&\"/Watt-DC (up to 200 kW-DC), for any multifamily affordable housing project that uses Community Distributed Generation in Con Edison territory. With the affordable adder, this brings the total NY-Sun incentive to \"&TEXT('Assumptions Calcs & Lookups'!O5+'Assumptions Calcs & Lookups'!N5+'Assumptions Calcs & Lookups'!M5,\"$0.00\")&\"/Watt-DC.\"","v":"In addition to the affordable housing adder, NY-Sun provides a Multifamily Affordable CDG adder of an additional $0.40/Watt-DC (up to 200 kW-DC), for any multifamily affordable housing project that uses Community Distributed Generation in Con Edison territory. With the affordable adder, this brings the total NY-Sun incentive to $2.00/Watt-DC."}]
[]
[]
[]
[]
[null,"Note: For tax liable owners, the NY-Sun Incentive may be considered taxable income. This tool calculates the amount of taxes owed based on the estimated corporate income tax rate. The amount is shown on the Results tab as \"Federal Taxes Due to State Incentives"]
[]
["Other Assumptions"]
["Solar Operations & Maintenance: "]
[{"$f":"\"This tool assumes there are limited O&M expenses for the solar energy systems. Solar energy systems typically include 25 year manufacturer warranties on solar panels, 10+ year warranties on inverters, and 5-10 year workmanship warranties. \"&\"The only O&M cost included in this tool is an inverter replacement during year 15 of the 25 year analysis period. The assumed inverter replacement cost is \"&TEXT('Assumptions Calcs & Lookups'!B97,\"$0.00\")&\"/Watt-DC including parts & labor.\"","v":"This tool assumes there are limited O&M expenses for the solar energy systems. Solar energy systems typically include 25 year manufacturer warranties on solar panels, 10+ year warranties on inverters, and 5-10 year workmanship warranties. The only O&M cost included in this tool is an inverter replacement during year 15 of the 25 year analysis period. The assumed inverter replacement cost is $0.20/Watt-DC including parts & labor."}]

{"sheet":"Project Info","index":1,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,1],[32,0,40,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[30,0,30,1],[27,0,27,1],[22,0,22,1],[15,0,15,1],[6,0,6,1],[4,0,4,1],[5,0,5,1]]}
["USER INPUTS"]
[{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
[]
["PROJECT INFORMATION"]
["Please fill in the following tabs: Project Info, Building Info, and Roof Layout. For portfolio projects, skip Building Info and proceed to the \"Multiple Buildings\" tab. Optionally, enter only verified information in the Advanced Inputs tab. S1 will provide feedback on all submissions.\nFor Sub Rehab/Preservation projects, S1 will send a  recommendation to HPD, and HPD will generate the signed Solar Approval Form. If you are part of an HPD Development project, do not submit an analysis until after the pre-scoping meeting. \nFor portfolio submissions, press the orange button below to fill in the Multiple Buildings tab. Please note that for portfolio projects, you do not need to fill out the \"Building Info\" tab, and  the Results tab will not be populated until S1 completes a portfolio analysis.\n*Effective 11/15/24, the DOB no longer accepts HPD exemption letters for financial infeasibility. Projects with new roofs/new roof assemblies subject to LL92/94 will need to comply with the DOB requirement. Contact affordable@solar1.org for further instructions or questions."]
["Project Details"]
["Project Name (per HPD)"]
["Site Address/es"]
["Construction Type"]
["Is project receiving HPD subsidy?"]
["Project Design Phase"]
["# of Buildings in Project"]
["# of Buildings Proposing Solar"]
["Is project subject to DEP Stormwater rules and will need to use a green roof to comply?"]
["Applicant Information"]
["Submission Date"]
["Applicant Name"]
["Applicant Company"]
["Applicant Email"]
["Owner/Developer Name"]
["Owner/Developer Email"]
["HPD Information"]
["HPD Project ID (5 digits)"]
["HPD Project Manager"]
["HPD Project Manager Email"]
["HPD Program"]
["Agency Approvals"]
["Is project planning to incorporate solar?"]
["Is project subject to DOB LL92/94?"]
["Applicant Comments"]
["Please write any comments explaining why Applicant believes project should include solar or be exempt from including solar."]

{"sheet":"Building Info","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,1],[36,0,36,1],[18,0,18,1],[5,0,5,1],[0,0,0,1],[1,0,1,1],[3,0,3,1],[26,0,26,1],[4,0,4,1]]}
["USER INPUTS"]
[{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["BUILDING INFORMATION"]
["Use this tool to complete a preliminary assessment of solar financial viability for a New York City affordable housing property. If you have questions, review the Instructions and Assumptions tab or email affordable@solar1.org for assistance or a free solar consultation.\n\nNote: For portfolio projects, skip this tab and proceed to the \"Multiple Buildings\" tab."]
["Project Details"]
["Project Name (per HPD)",{"$f":"ProjectName","v":0}]
["Site Address/es",{"$f":"SiteAddress","v":0}]
["Construction Type",{"$f":"ConstructionType","v":0}]
["Ownership Type"]
["Estimated Project Completion Year"]
["Prevailing Wages Required"]
["Number of Dwelling Units in Project"]
["Building Height (ft)"]
["Estimated Usable Roof Area for Solar (sq ft)"]
["Solar Canopy Design Proposed"]
["Roof Condition"]
["Does project propose electrification/energy efficiency work that may affect solar/roof design?"]
["Incentives Eligibility"]
["Is project eligible for the Federal Solar Tax Credit?"]
["Is this a Low Income Housing Tax Credit (LIHTC) Project?"]
["      If yes, can solar be included in the LIHTC Basis?"]
["Is project eligible for NYC Solar Property Tax Abatement?"]
["Is project in a Landmark or Historic District?"]
["Is project in a Qualified Census Tract?"]
["Does project receive funding from a federal housing program?"]
["Owner-Paid Electricity Information"]
["Electric Utility"]
["Est. Annual Owner-Paid Electricity Costs"]
["Master-Metered Building"]
["Elevator Building"]
[]
[]
[]
[]
["The advanced inputs are completely optional.  Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate cells with confirmed information."]
["Disclaimer: Solar One is providing this preliminary analysis tool on an as-is basis and makes no claims regarding the accuracy of calculations and figures provided herein. Solar technical feasibility, installation costs, incentives, energy generation, and electricity bill savings may vary."]

{"sheet":"Multiple Buildings","index":3,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":true,"merged":[[73,0,73,1],[74,0,74,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[66,0,66,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[54,0,54,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[42,0,42,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[30,0,30,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[8,0,8,1],[8,2,8,3],[18,0,18,1],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3],[13,0,13,11],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3],[7,0,7,1],[7,2,7,3],[0,1,0,9],[1,1,1,9],[3,0,3,3],[4,0,4,1],[4,2,4,3]]}
[null,"USER INPUTS FOR MULTIPLE BUILDINGS"]
[null,{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["PROJECT INFORMATION"]
["Ownership Type"]
["Estimated Project Completion Year"]
["Prevailing Wages Required"]
["Is project eligible for the Federal Solar Tax Credit?"]
["Is this a Low Income Housing Tax Credit (LIHTC) Project?"]
["      If yes, can solar be included in the LIHTC Basis?"]
["Is project eligible for NYC Solar Property Tax Abatement?"]
["Does project receive funding from a federal housing program?"]
[]
["BUILDING INFORMATION"]
["Address",null,"Is building in a Landmark or Historic District?","Is building in a Qualified Census Tract?","# of Dwelling Units","Building Height (ft)","Estimated Usable Roof Area for Solar (sq ft)","Roof Condition","Project Proposing Electrification/energy efficiency work?","Est. Annual Owner-Paid Electricity Costs ($)","Master-Metered Building","Elevator Building"]

{"sheet":"Summary and S1 Review","index":4,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[[36,2,36,8],[35,9,35,10],[34,2,34,8],[30,9,30,10],[31,9,31,10],[32,9,32,10],[34,9,34,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[35,2,35,3],[32,2,32,3],[33,2,33,8],[35,4,35,5],[30,5,30,8],[29,2,29,3],[27,2,27,3],[28,2,28,3],[30,2,30,3],[27,6,27,8],[28,6,28,8],[29,6,29,8],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[24,9,24,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[15,9,15,10],[23,9,23,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[16,9,16,10],[13,9,13,10],[0,9,0,10],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[35,0,35,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[19,0,19,1],[18,0,18,1],[20,0,20,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[11,9,11,10],[12,9,12,10],[14,9,14,10],[0,2,0,8],[1,2,1,8],[35,7,35,8],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[31,2,31,8],[32,4,32,8],[11,5,11,8],[12,2,12,8],[11,2,11,4],[14,2,14,3],[13,5,13,6],[8,5,8,8],[15,0,15,1],[16,0,16,1],[20,2,20,3],[17,2,17,4],[16,5,16,8],[25,5,25,8],[26,6,26,8],[22,2,22,3],[23,2,23,3],[24,2,24,3],[21,2,21,3],[18,5,18,6],[23,5,23,6],[26,2,26,3],[18,2,18,3],[19,2,19,3],[24,5,24,8],[22,5,22,6],[25,2,25,4],[19,5,19,6],[20,5,20,6],[21,5,21,6],[3,2,3,8],[6,2,6,3],[4,4,4,8],[5,4,5,8],[14,5,14,6],[15,5,15,6],[17,5,17,6],[4,2,4,3],[5,2,5,3],[9,2,9,3],[10,2,10,3],[7,2,7,3],[9,5,9,6],[8,2,8,3],[16,2,16,3],[7,7,7,8],[9,7,9,8],[10,7,10,8],[13,2,13,3],[6,5,6,6],[6,7,6,8],[15,2,15,3],[7,5,7,6],[10,5,10,6]]}
[null,null,{"$f":"E5&\" Solar Summary\"","v":" Solar Summary"}]
[null,null,{"$f":"RIGHT(Results!A2,35)","v":" Version 2025 1.1, Updated May 2025"}]
[null,null,null,null,null,null," "]
[null,null,"Project Details"]
[null,null,"Project Name",null,{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""}]
[null,null,"Site Address/es",null,{"$f":"IF(SiteAddress=\"\",\"\",SiteAddress)","v":""}]
[null,null,"Project Design Phase",null,{"$f":"ProjectStatus","v":0},"Submission Date",null,{"$f":"IF(Date=0,\"0\",Date)","v":"0"}]
[null,null,"Construction Type",null,{"$f":"IF(ConstructionType=\"\",\"\",ConstructionType)","v":""},"Eligible for Federal Solar Tax Credit",null,{"$f":"IF(TaxIncentiveEligible=\"\",\"\",TaxIncentiveEligible)","v":""}]
[null,null,"# Buildings in Project",null,{"$f":"IF(NumberBuildings=\"\",\"\",NumberBuildings)","v":""},{"$f":"IF(TaxIncentiveEligible=\"Yes (owner is a 501c3 - can get tax credit via Elective/Direct Pay)\",\"IRS pre-filing registration and filing required for Elective/Direct Pay\",\"\")","v":""}]
[null,null,"# Buildings Proposing Solar",null,{"$f":"IF(NumberBuildingsSolar=\"\",\"\",NumberBuildingsSolar)","v":""},"LIHTC Project",null,{"$f":"IF(LIHTCEligible=\"\",\"\",LIHTCEligible)","v":""}]
[null,null,"# Dwelling Units",null,{"$f":"IF(DwellingUnits=\"\",\"\",DwellingUnits)","v":""},"Includes Solar in LIHTC Eligible Basis",null,{"$f":"IF(IncludeLIHTC=\"\",\"N/A\",IncludeLIHTC)","v":"N/A"}]
[null,null,"Projected System Details",null,null,"Estimated Costs"]
[null,null,"With multiple buildings, the below numbers are totals and weighted averages for buildings viable for solar. See Roof Layout for details"]
[null,null,"System Design Type",null,{"$f":"IF(Canopy=\"Yes\", \"Canopy\",\n    IF(SystemType<>\"\",SystemType,\n      IF(BldgHeight<100, \"Ballasted\", \"Planar\")\n      )\n    )","v":"Ballasted"},"Est. Total System Cost",null,null,{"$f":"IFERROR(ABS(TotalEPCPrice),0)","v":0},"This amount reflects the estimated solar installer contract total only. Excludes GC markup or contingency. "]
[null,null,"System Size (kW)",null,{"$f":"IFERROR(ROUND(PVSystemSize,2)&\" kW-DC\",0)","v":"0 kW-DC"},"NY-Sun Incentive (All projects eligible)",null," - ",{"$f":"IFERROR(ABS(NYSunIncentive),)","v":0},"Available to all projects and paid directly to the installer at the end of construction."]
[null,null,"Est. Cost ($/Watt-DC)",null,{"$f":"IFERROR(AdjustedEPCPricePerWattDC,0)","v":0},"Est. Upfront Cost After NY-Sun Incentive (excludes tax credits)",null," =",{"$f":"IFERROR(ABS(UpfrontCost),0)","v":0},"This is the net solar cost after the solar installer receives the NY-Sun incentive. "]
[null,null,"Est. Y1 Production (kWh)",null,{"$f":"IFERROR(Y1SolarProduction,0)","v":0},"Estimated Available Tax Incentives"]
[null,null,"Estimated Savings",null,null,"Federal Solar Tax Credit",null,null,{"$f":"IFERROR(ABS(ITC),)","v":0},"Federal Tax Credit should be recognized as a source in HPD budget to the extent possible."]
[null,null,"Est. Y1 GHG Reduction",null,{"$f":"IFERROR(ROUND(mTCo2_Avoided,1)&\" mtCO2e\",0)","v":0},"BONUS Federal Solar Tax Credit*",null,null,{"$f":"IFERROR(ABS(SUM('Assumptions Calcs & Lookups'!B123:B125)),0)","v":0},"HPD will not generally underwrite bonus credit unless requested by the developer."]
[null,null,"Est. Annual Owner-Paid Electricity Costs",null,{"$f":"AnnualElectricBill","v":0},"Additional LIHTC from Solar, if available",null,null,{"$f":"IFERROR(ABS(TenYearLIHTCValue),0)","v":0},"Always confirm this number."]
["Should not exceed Annual Owner-Paid Electric Costs. ",null,"Est. Y1 Electricity Savings ($)",null,{"$f":"IFERROR(Results!B12,0)","v":0},"NYC Property Tax Abatement*",null,null,{"$f":"IFERROR(ABS(NYCPTA),)","v":0},"Always confirm this number. Cannot be monetized if building already has full tax exemption or certain abatements. Not typically recognized in HPD budget.\t"]
[null,null,"Est. Lifetime Net Savings",null,{"$f":"IFERROR('25 Year Cash Flow'!$O$29,0)","v":0},"State Residential Income Tax Credit*",null,null,{"$f":"IFERROR(ABS(NYSResidentialTaxCredit),)","v":0}]
["Typically 50% for Preservation and 80% for New Construction.",null,"% of Savings Underwritten",null,{"$f":"IF(ConstructionType=\"new Construction\", 0.8, 0.5)","v":0.5},"Historic Tax Credit*",null,null,{"$f":"IFERROR(ABS(NYSHistoricTaxCredit),)","v":0},"HPD will not generally underwrite the historic tax credit"]
[null,null,"Annual Underwritten Savings**",null,{"$f":"E21*E23","v":0},"Total Available Tax Incentives",null,null,{"$f":"IFERROR(Results!B31,0)","v":0},"Reminder that not all tax incentives are recognized in HPD budget, see notes above."]
[null,null,"Est. Payback Period***",null,{"$f":"Results!G11","v":"0 years"},"* Tax Incentive not typically recognized as a source in the HPD budget\n** PM to undewrite the applicable % of savings in the underwriting shell \n*** Payback period includes system cost, annual utility savings, inverter replacement cost, NY-Sun Incentive and any other incentives noted above"]
[null,null,"Applicant Information",null,null,"HPD Information"]
[null,null,"Applicant Company",null,{"$f":"IF(Company=\"\",\"\",Company)","v":""},"HPD ID",{"$f":"IF(HPDID=\"\",\"\",HPDID)","v":""}]
[null,null,"Applicant Name",null,{"$f":"IF(Name=\"\",\"\",Name)","v":""},"HPD PM",{"$f":"IF(HPDPM=\"\",\"\",HPDPM)","v":""}]
[null,null,"Applicant Email",null,{"$f":"IF(Email=\"\",\"\",Email)","v":""},"HPD Email",{"$f":"IF(HPDPMEmail=\"\",\"\",HPDPMEmail)","v":""}]
[null,null,"Owner/Developer Name",null,{"$f":"IF(DeveloperName=\"\",\"\",DeveloperName)","v":""},"HPD Program",{"$f":"IF(HPDProgram=\"\",\"\",HPDProgram)","v":""}]
[null,null,"Owner/Developer Email",null,{"$f":"IF(DeveloperEmail=\"\",\"\",DeveloperEmail)","v":""}]
[null,null,"Solar One Review"]
[null,null,"S1 Recommendation for HPD"]
[null,null,"Solar One Comments: "]
[null,null,null,null,null,null,null,null,null,"S1:Please be sure to comment on:\n-Cost\n-Is design optimized\n-Co-benefits  (deck, architectural features)\n-Extenuating circumstances"]
[null,null,"Solar One Signature",null,null,null,"Date",{"$f":"NOW()","v":"2025-05-14T11:39:39.230"}]
[null,null," Note that as of November 15 2024, DOB will no longer accept HPD Exemption letters and projects subject to LL92/94 will be required to comply with the DOB's requirements."]

{"sheet":"Advanced Inputs","index":5,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":true,"merged":[[37,0,37,1],[42,0,42,1],[38,0,38,1],[0,0,0,1],[1,0,1,1],[4,0,4,1],[22,0,22,1],[13,0,13,1],[5,0,5,1],[3,0,3,1]]}
["USER INPUTS"]
[{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["ADVANCED INPUTS (OPTIONAL)"]
["All fields on this page are optional. Values entered into this form will override any default assumptions or calculated values. Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate a cell if you have confirmed information for it. "]
["Projected System Details and Cost"]
["Solar Energy System Size (kW-DC)"]
["Total Solar Energy System Price ($/Watt-DC)"]
["Year One Production (kWh)"]
["Annual Solar Performance Degradation"]
["System Type"]
["Total Price Adjustment % (e.g. GC markup)"]
["Total Price Adjustment $"]
["Value of Solar ($/kWh)"]
["Solar Metering Configuration"]
["Con Edison Electricity Tariff (Owner-Paid)"]
["Peak Demand (Prev. 12 Months or Estimated (kW))"]
["Annual Electricity Usage (Actual or Estimated kWh)"]
["CSRP Load Zone"]
["Year One Value of Solar ($/kWh)"]
["Annual Escalation to Value of Solar"]
["Annual Meter Fees (CDG Only)"]
["Incentives"]
["NY-Sun Incentive ($/Watt-DC)"]
["Total Federal Solar Tax Credit Override (%)"]
["Bonus Federal Solar Tax Credit"]
["Bonus Federal Solar Tax Credit (%)"]
["Eligible for Energy Community Tax Credit?"]
["Eligible for Domestic Content Tax Credit?"]
["Low Income Housing Tax Credit (%)"]
["Property Tax Abatement Amount ($)"]
["Eligible for Historic Tax Credit?"]
["Eligible for State Residential Income Tax Credit?"]
["State Residential Income Tax Credit Amount ($)"]
["Owner Federal Income Tax Rate (%)"]
["Owner State Income Tax Rate (%)"]
["Regulated Affordable Housing?"]
["Use this space to highlight any additional information related to solar."]
[]
[]
[]
[]
["Disclaimer: Solar One is providing this preliminary analysis tool on an as-is basis and makes no claims regarding the accuracy of calculations and figures provided herein. Solar technical feasibility, installation costs, incentives, energy generation, and electricity bill savings may vary."]

{"sheet":"HPD Approval Form","index":6,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[[21,0,21,1],[23,3,23,4],[22,3,22,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[32,0,32,6],[35,0,35,6],[30,0,30,1],[30,3,30,6],[0,0,0,6],[19,0,19,1],[22,0,22,1],[23,0,23,1],[6,0,6,1],[5,2,5,6],[4,2,4,6],[15,0,15,1],[3,0,3,6],[20,0,20,1],[18,0,18,1],[7,0,7,1],[29,5,29,6],[26,3,26,4],[27,3,27,4],[28,3,28,4],[31,0,31,6],[29,0,29,1],[29,3,29,4],[26,0,26,1],[28,0,28,1],[24,3,24,6],[27,0,27,1],[26,5,26,6],[27,5,27,6],[28,5,28,6],[36,0,36,1],[33,0,33,2],[33,3,33,6],[36,5,36,6],[36,2,36,3],[34,0,34,6],[10,3,10,4],[11,0,11,2],[12,0,12,6],[16,0,16,1],[15,3,15,4],[10,5,10,6],[16,3,16,6],[4,0,4,1],[5,0,5,1],[25,0,25,2],[25,3,25,6],[17,3,17,4],[17,0,17,2],[11,3,11,6],[13,3,13,4],[14,3,14,4],[14,0,14,1],[13,0,13,1],[24,0,24,1],[8,0,8,1],[9,0,9,1],[6,3,6,4],[10,0,10,1],[9,5,9,6],[9,3,9,4],[8,3,8,6],[6,5,6,6],[7,5,7,6],[7,3,7,4]]}
["HPD SOLAR APPROVAL FORM"]
[]
[]
["Project Details1"]
["Project Name",null,{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""}]
["Site Address/es",null,{"$f":"IF(SiteAddress=\"\",\"\",SiteAddress)","v":""}]
["Project Design Phase",null,{"$f":"ProjectStatus","v":0},"Submission Date",null,{"$f":"IF(Date=0,\"0\",Date)","v":"0"}]
["Construction Type",null,{"$f":"IF(ConstructionType=\"\",\"\",ConstructionType)","v":""},"Eligible for Federal Solar Tax Credit",null,{"$f":"IF(TaxIncentiveEligible=\"\",\"\",TaxIncentiveEligible)","v":""}]
["# Buildings in Project",null,{"$f":"IF(NumberBuildings=\"\",\"\",NumberBuildings)","v":""},{"$f":"IF(TaxIncentiveEligible=\"Yes (owner is a 501c3 - can get tax credit via Elective/Direct Pay)\",\"IRS pre-filing registration and filing required for Elective/Direct Pay\",\"\")","v":""}]
["# Buildings Proposing Solar",null,{"$f":"IF(NumberBuildingsSolar=\"\",\"\",NumberBuildingsSolar)","v":""},"LIHTC Project",null,{"$f":"IF(LIHTCEligible=\"\",\"\",LIHTCEligible)","v":""}]
["# Dwelling Units",null,{"$f":"IF(DwellingUnits=\"\",\"\",DwellingUnits)","v":""},"Includes Solar in LIHTC Eligible Basis",null,{"$f":"IF(IncludeLIHTC=\"\",\"N/A\",IncludeLIHTC)","v":"N/A"}]
["Projected System Details",null,null,"Estimated Costs2"]
["With multiple buildings, the below numbers are totals and weighted averages for buildings viable for solar. See Roof Layout for details."]
["System Design Type",null,{"$f":"IF(Canopy=\"Yes\", \"Canopy\",\n    IF(SystemType<>\"\",SystemType,\n      IF(BldgHeight<100, \"Ballasted\", \"Planar\")\n      )\n    )","v":"Ballasted"},"Est. Total System Cost",null,null,{"$f":"IFERROR(ABS(TotalEPCPrice),0)","v":0}]
["System Size (kW)",null,{"$f":"IFERROR(ROUND(PVSystemSize,2)&\" kW-DC\",0)","v":"0 kW-DC"},"NY-Sun Incentive",null," - ",{"$f":"IFERROR(ABS(NYSunIncentive),)","v":0}]
["Est. Cost ($/Watt-DC)",null,{"$f":"IFERROR(AdjustedEPCPricePerWattDC,0)","v":0},"Est. Upfront Cost After NY-Sun Incentive",null," =",{"$f":"IFERROR(ABS(UpfrontCost),0)","v":0}]
["Est. Y1 Production (kWh)",null,{"$f":"IFERROR(Y1SolarProduction,0)","v":0},"Estimated Available Tax Incentives"]
["Estimated Savings",null,null,"Federal Solar Tax Credit",null,null,{"$f":"IFERROR(ABS(ITC),)","v":0}]
["Est. Y1 GHG Reduction",null,{"$f":"IFERROR(ROUND(mTCo2_Avoided,1)&\" mtCO2e\",0)","v":0},"BONUS Federal Solar Tax Credit*",null,null,{"$f":"IFERROR(ABS(SUM('Assumptions Calcs & Lookups'!B123:B125)),0)","v":0}]
["Est. Annual Owner-Paid Electricity Costs",null,{"$f":"AnnualElectricBill","v":0},"Additional LIHTC from Solar",null,null,{"$f":"IFERROR(ABS(TenYearLIHTCValue),0)","v":0}]
["Est. Y1 Electricity Savings ($)",null,{"$f":"IFERROR(Results!B12,0)","v":0},"NYC Property Tax Abatement*",null,null,{"$f":"IFERROR(ABS(NYCPTA),)","v":0}]
["Est. Lifetime Net Savings",null,{"$f":"IFERROR('25 Year Cash Flow'!$O$29,0)","v":0},"State Residential Income Tax Credit*",null,null,{"$f":"IFERROR(ABS(NYSResidentialTaxCredit),)","v":0}]
["% of Savings Underwritten",null,{"$f":"IF(ConstructionType=\"New Construction\", 0.8, 0.5)","v":0.5},"Historic Tax Credit*",null,null,{"$f":"IFERROR(ABS(NYSHistoricTaxCredit),0)","v":0}]
["Annual Underwritten Savings",null,{"$f":"C21*C23","v":0},"Total Tax Incentives",null,null,{"$f":"IFERROR(Results!B31,0)","v":0}]
["Est. Payback Period",null,{"$f":"Results!G11","v":"0 years"},"*Tax Incentive not typically recognized as a source in the HPD budget."]
["Applicant Information",null,null,"HPD Information"]
["Applicant Company",null,{"$f":"IF(Company=\"\",\"\",Company)","v":""},"HPD ID",null,{"$f":"IF(HPDID=\"\",\"\",HPDID)","v":""}]
["Applicant Name",null,{"$f":"IF(Name=\"\",\"\",Name)","v":""},"HPD PM",null,{"$f":"IF(HPDPM=\"\",\"\",HPDPM)","v":""}]
["Applicant Email",null,{"$f":"IF(Email=\"\",\"\",Email)","v":""},"HPD Email",null,{"$f":"IF(HPDPMEmail=\"\",\"\",HPDPMEmail)","v":""}]
["Owner/Developer Name",null,{"$f":"IF(DeveloperName=\"\",\"\",DeveloperName)","v":""},"HPD Program",null,{"$f":"IF(HPDProgram=\"\",\"\",HPDProgram)","v":""}]
["Owner/Developer Email",null,{"$f":"IF(DeveloperEmail=\"\",\"\",DeveloperEmail)","v":""}]
["HPD Approval"]
["1All projects must be signed by HPD.\n2Costs are based only on the inputs and assumptions in this tool, including any Advanced Inputs. Estimated total cost of system does not include GC markup. Final costs (and payback) may be different than shown in this analysis. This analysis can be re-run if there are changes to the design or if bid costs are signficantly higher than estimated and it is necessary to re-calculate the payback (e.g., project is over budget and needs to be value engineered).\nAny waivers or DOB Exemptions noted here are for HPD’s Solar Where Feasible requirement only and do not override DEP's stormwater requirements. As of 11/15/24, DOB will no longer accept HPD Exemption letters and projects subject to LL92/94 will be required to comply with the DOB's requirements."]
["HPD Determination"]
["HPD Comments:\n"]
[]
["HPD Approval Signature",null,null,null,"Date",{"$f":"NOW()","v":"2025-05-14T11:39:39.230"}]

{"sheet":"Roof Layout","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,6],[14,0,18,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[5,0,6,6],[12,0,12,6],[9,0,9,3],[10,0,10,6]]}
[]
["ROOF LAYOUT"]
[{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["SOLAR PV SYSTEM LAYOUT OR USABLE ROOF AREA"]
["Provide image/s of roof plan(s) with solar layout or Sustainable Roofing Zone. Please include any existing or planned equipment (e.g. HVAC systems, electrification equipment, cell towers, antennas, roof decks, LL11 rigging equipment, etc.). Please note in the comments section if green roof is being incorporated to satisfy DEP requirments. Identify key features on image or in comments section below.  Images should include any of the following to clarify design features or obstacles:"]
[]
[null,"> Sketch",null,null,"> Building Plans","> Drawings"]
[null,"> Screenshot",null,null,"> Rendering","> Diagrams"]
["Roof Condition:",null,null,null,{"$f":"IF(RoofCondition=0, \"Not Populated\", RoofCondition)","v":"Not Populated"}]
[]
[]
["Comments on System Layout or Roof Area \n"]
["Note unique design features, such as canopies, green roofs, architectural details or other aspects to demonstrate why solar is or is not included in design. Please also note if additional drawings are separately attached."]

{"sheet":"Results","index":8,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,4,36,6],[11,4,11,5],[42,0,42,6],[1,0,1,6],[0,0,0,6],[32,4,32,6],[4,0,7,6],[3,0,3,6],[32,0,32,2],[8,0,8,2],[15,0,15,2],[20,0,20,2],[37,0,38,2],[8,4,8,6],[9,4,9,5],[10,4,10,5],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
["SOLAR FEASIBILITY ANALYSIS RESULTS"]
[{"$f":"'Instructions and Assumptions'!C4","v":"        Version 2025 1.1, Updated May 2025"}]
[]
[{"$f":"\"PRELIMINARY SOLAR FINANCIAL ANALYSIS: \"&ProjectName","v":"PRELIMINARY SOLAR FINANCIAL ANALYSIS: "}]
["Solar energy systems provide electricity bill savings, however they are also eligible for a number of federal, state and local incentives that can significantly improve return on investment. The summary below includes estimated costs, incentives, electricity bill savings, and payback period for a solar energy system on this property. Payback Period is estimated using the costs, savings and incentives shown in this analysis, but may not reflect the actual payback of the system as underwritten by HPD."]
[]
[]
[]
["PROJECTED SYSTEM PERFORMANCE",null,null,null,"TAKEAWAYS"]
["Solar Energy System Size (kW-DC)",{"$f":"IFERROR(IF(RecommendedPVSystemSize<4,\"System Too Small\",RecommendedPVSystemSize),0)","v":0},null,null,"Internal Rate of Return",null,{"$f":"IFERROR(IRR('25 Year Cash Flow'!Q4:Q29,0.1),0)","v":0}]
["Est. Year One Solar Production (kWh)",{"$f":"IFERROR(Y1SolarProduction,0)","v":0},null,null,"Payback Period",null,{"$f":"IF(COUNTIF('25 Year Cash Flow'!O4:O29,\"<0\")&\" years\"=\"26 years\", \"N/A\",COUNTIF('25 Year Cash Flow'!O4:O29,\"<0\")&\" years\")","v":"0 years"}]
["Year One Electricity Savings",{"$f":"IFERROR('25 Year Cash Flow'!F5,0)","v":0},null,null,"Lifetime Net Savings",null,{"$f":"IFERROR('25 Year Cash Flow'!O29,0)","v":0}]
["NY-Sun $/Watt",{"$f":"IFERROR(NYSUNDollarPerWattDC,0)","v":0}]
["Total Cost ($/Watt-DC)",{"$f":"IFERROR(AdjustedEPCPricePerWattDC,0)","v":0}]
[]
["ESTIMATED UPFRONT COSTS"]
["Est. Total System Cost ",null,{"$f":"ABS(IFERROR('Assumptions Calcs & Lookups'!$B$119,0))","v":0}]
["NY-Sun Incentive","-",{"$f":"ABS(IFERROR(NYSunIncentive,0))","v":0}]
["Upfront Cost Estimate"," =",{"$f":"ABS(IFERROR(C17-C18,\"\"))","v":0}]
[]
["AVAILABLE TAX INCENTIVES"]
["Federal Tax Credit %",{"$f":"IF(ORFedTaxCreditPercent>0.3,0.3,FedTaxCreditPercent)","v":0}]
["Federal Tax Credit",{"$f":"IFERROR(ITC,0)","v":0}]
["Bonus Federal Tax Credits %",{"$f":"IF(ORFedTaxCreditPercent>0.3,ORFedTaxCreditPercent-0.3,\nIFERROR(SUM(BonusFedTaxCreditPercent,EnergyCommunityTaxCreditPercent,DomesticContentTaxCreditPercent),\"\")\n)","v":0}]
["Bonus Federal Tax Credits ",{"$f":"IFERROR(ABS(SUM('Assumptions Calcs & Lookups'!B123:B125)),0)","v":0}]
["Federal Taxes Due to State Incentives",{"$f":"IFERROR('Assumptions Calcs & Lookups'!B131,0)","v":0}]
["Additional LIHTC From Solar",{"$f":"IFERROR(TenYearLIHTCValue,0)","v":0}]
["NYC Property Tax Abatement",{"$f":"IFERROR(NYCPTA,\"\")","v":0}]
["State Residential Income Tax Credit",{"$f":"IFERROR(NYSResidentialTaxCredit,0)","v":0}]
["Historic Tax Credit",{"$f":"IFERROR(ABS(NYSHistoricTaxCredit),0)","v":0}]
["Total Tax Incentives",{"$f":"SUM(B23,B25:C30)","v":0}]
[]
["FEASIBILITY REPORT SUBMITTED BY",null,null,null,"NEXT STEPS"]
["Name",{"$f":"Name","v":0},null,null,{"$f":"IF(ConstructionType=\"New Construction\",NextSteps_NewConstruction,\nIF(ProjectStatus=\"Preliminary Screening/IPNA\",NextSteps_IPNA,NextSteps_Other))","v":"1. Submit to HPD using the button below.\n2. Await results from Solar 1 and HPD’s Sustainability Office.\n3. Save HPD Approval Form in project records."}]
["Company",{"$f":"Company","v":0}]
["Email",{"$f":"Email","v":0}]
["HPD ID",{"$f":"HPDID","v":0}]
[{"$f":"IF(FormComplete=1,\"\",\"WARNING: incomplete form. Please enter values for all blue fields on the Project Info, Building Info, and Solar Layout tabs.\")","v":"WARNING: incomplete form. Please enter values for all blue fields on the Project Info, Building Info, and Solar Layout tabs."}]
[]
[]
[]
[]
["Disclaimer: Solar One is providing this preliminary analysis tool on an as-is basis and makes no claims regarding the accuracy of calculations and figures provided herein. Solar technical feasibility, installation costs, incentives, energy generation, and electricity bill savings may vary."]

{"sheet":"Data Validation","index":9,"n_rows":18,"n_cols":45,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Owner Type",null,"Yes/No",null,"Yes/No",null,"Project Eligible for Federal Solar Tax Credit?",null,"LIHTC Eligible",null,"Is Project Proposing Solar?",null,"Subject to DOB LL92/94",null,"Solar Mandate Approval",null,"HPD Program - Dropdown Options",null,"Construction Type",null,"Project Completion Year",null,"HPD Subsidy",null,"Roof Condition",null,"Electrification",null,"Bonus Federal Solar Tax Credit (%)",null,"Bonus Federal Solar Tax Credit Description",null,"Project Status",null,"Utility Provider",null,"System Type",null,"Solar Metering Configuration",null,"Con Edison Electricity Tariff (Owner-Paid)",null,"CSRP Load Zones",null,"Next Steps"]
["For-Profit Rental",null,"Yes",null,"Yes",null,"Yes (owner is a taxable entity)",null,"Yes 4%",null,"Yes - project proposing solar",null,"Yes (roof assembly is being replaced)",null,"Solar Required - payback period ≤ 10 years",null,"421a",null,"New Construction",null,2025,null,"Yes, project is receiving HPD subsidy",null,"Roof was resurfaced or replaced in the last 5 years",null,"No",null,0.1,null,"Low-Income Community",null,"Preliminary Screening/IPNA",null,"Con Edison",null,"Ballasted",null,"Behind-the-Meter",null,"EL1",null,"11:00 AM-3:00 PM",null,"1. submit to HPD using the button below\n2. await feedback on IPNA screening from Solar 1\n3. include screening in IPNA submissions to HPD\n4. submit full analysis after pre-scoping meeting"]
["Non-Profit Rental",null,"No",null,"No",null,"Yes (owner is a 501c3 - can get tax credit via Elective/Direct Pay)",null,"Yes 9%",null,"Yes - proposing solar for some buildings but not all",null,"No (roof assembly not being replaced)",null,"Solar Required on some but not all buildings - see comments",null,"ANCP",null,"Sub Rehab",null,2026,null,"No, project is only receiving a Tax Exemption",null,"Roof is getting resurfaced or replaced as part of scope",null,"Yes (explain in comments and include in roof plan)",null,0.2,null,"Qualified Low-Income Economic Benefit Project",null,"Scoping (note: submit after pre-scoping meeting)",null,"PSEG-LI",null,"Mechanically Attached",null,"CDG (Solar Export Meter)",null,"EL2",null,"2:00 PM-6:00 PM",null,"1. Submit to HPD using the button below\n2. Await feedback from Solar 1\n3. Utilize Results to inform compliance with LL92/94"]
["Co-op/Condo",null,null,null,"Some, but not all",null,"Yes (owner will sell credit via transferability)",null,"No",null,"No - project includes green roof over 90% of roof area",null,"Unknown (roof work to be determined)",null,"Solar Strongly Recommended - see comments",null,"ELLA",null,"Mod Rehab",null,2027,null,"No, project is a Maintenance-Only scope",null,"Other (explain in the Roof Layout comments section)",null,null,null,null,null,"Qualified Low-Income Residential Building Project",null,"Design Revisions",null,null,null,"Canopy",null,null,null,"EL8",null,"4:00 PM-8:00 PM",null,"1. Submit to HPD using the button below.\n2. Await results from Solar 1 and HPD’s Sustainability Office.\n3. Save HPD Approval Form in project records."]
["Limited Partnership",null,null,null,null,null,"No (owner is a co-op/condo with no tax liability)",null,null,null,"No - project cannot support > 4kW",null,null,null,"Solar Recommended - see comments",null,"GHPP",null,"Gut Rehab",null,2028,null,"No, project is in the Delegated Loan program",null,null,null,null,null,null,null,"Other (please explain in notes section)",null,"Post-Bid",null,null,null,null,null,null,null,"EL9",null,"7:00 PM-11:00 PM"]
[null,null,null,null,null,null,"No (explain in Applicant Comments)",null,null,null,"No - solar is not cost effective",null,null,null,"Solar Not Required - green roof over 90% of sustainable roofing zone",null,"HRP",null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,"Post- Closing",null,null,null,null,null,null,null,"EL12"]
[null,null,null,null,null,null,null,null,null,null,"No - see comments",null,null,null,"Solar Not Required - cannot support >4kW",null,"HUD Multi Family",null,null,null,2030]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Not Required - payback period > 10 years",null,"LIHTC YR 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Not Required - other reason, see comments",null,"M2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project should be redesigned and submitted",null,"Mix & Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NCP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Door"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reso A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHLP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HPO"]

{"sheet":"Assumptions Calcs & Lookups","index":10,"n_rows":137,"n_cols":15,"rows_kept":137,"cut":false,"hidden":true,"merged":[[1,7,1,9],[2,0,2,2],[16,0,16,1],[18,0,18,1],[14,8,14,10],[15,8,15,10],[16,8,16,10],[17,8,17,10],[13,8,13,10],[18,8,18,10],[2,7,2,9],[2,10,3,10],[20,8,20,10],[32,0,32,1],[116,0,116,1],[54,0,54,1],[62,0,62,1],[35,0,35,1],[76,0,76,1],[92,0,92,1],[98,0,98,2],[110,0,110,1],[47,0,47,1],[33,0,33,1],[71,8,71,9],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[19,8,19,10]]}
["Assumptions, Calculations and Lookup Tables"]
[null,null,null,null,null,null,null,"Project Completion Year:",null,null,{"$f":"IF(ProjectCompletionYearIN=\"\",'Assumptions Calcs & Lookups'!H5,ProjectCompletionYearIN)","v":2024}]
["System Price Estimate ($/Watt-DC)",null,null,"<- Update every 12 months",null,null,null,"Incentives",null,null,"NY-Sun >1 MW","NY-Sun >200kW","NY-Sun <200kW","NY-Sun Affordable Adder","NY-Sun Affordable CDG"]
["Min (kW-DC)","Max (kW-DC)","Price ($/Watt-DC)",null,null,null,null,"Year","ITC","RETC"]
[4,9.99,5.7,null,null,null,null,2024,0.3,0.3,0.5,0.6,0.6,{"$f":"1.6-M5","v":1},{"$f":"2-M5-N5","v":0.39999999999999991}]
[10,19.989999999999998,4.88,null,null,null,null,2025,0.3,0.3]
[20,29.99,4.16,null,null,null,null,2026,0.3,0.3]
[30,44.99,3.83,null,null,null,null,2027,0.3,0.3]
[45,64.989999999999995,3.61,null,null,null,null,2028,0.3,0.3]
[65,79.989999999999995,3.45,null,null,null,null,2029,0.3,0.3]
[80,99.99,3.34,null,null,null,null,2030,0.3,0.3]
[100,149.99,3.17]
[150,249.99,2.95,null,null,null,null,"EPC Price Decrease by Project Completion Year"]
[250,499.99,2.73,null,null,null,null,"Year","Base Price Percentage"]
[500,749.99,2.62,null,null,null,null,2024,1]
[750,null,2.5099999999999998,null,null,null,null,2025,{"$f":"I15","v":1}]
["Base EPC Price for Simulation ($/Watt-DC)",null,{"$f":"LOOKUP(PVSystemSize,Min__kW_DC,Price____Watt_DC)","v":{"$error":"#N/A"}},null,null,null,null,2026,1]
[null,null,null,null,null,null,null,2027,1]
["Pricing Adders",null,"Applies?",null,null,null,null,2028,1]
["Mechanically Attached Adder ($/Watt-DC)",0.25,{"$f":"IF(SystemType=\"Ballasted\",\"No\",\nIF(RecommendedPVSystemSize<15,\"Yes\",\nIF(BldgHeight>100,\"Yes\",\nIF(SystemType=\"Mechanically Attached\",\"Yes\",\"No\")\n)))","v":{"$error":"#N/A"}},"<- Systems that are under 15 kW-DC or above 100 ft will be subject to the mechanically attached adder.",null,null,null,2029,1]
["Canopy Adder ($/Watt-DC)",1.2,{"$f":"IF(OR(Canopy=\"Yes\",SystemType=\"Canopy\"),\"Yes\",\"No\")","v":"No"},"<-  Only applicable if user indicates that a system is a canopy but does not specify the system price.",null,null,null,2030,1]
["Tall Building First Adder ($/Watt-DC)",0.2,{"$f":"IF(BldgHeight>='Assumptions Calcs & Lookups'!B23,\"Yes\",\"No\")","v":"No"}]
["Tall Building First Adder Threshold (>70ft)",70]
["Tall Building Second Adder ($/Watt-DC)",0.2,{"$f":"IF(BldgHeight>='Assumptions Calcs & Lookups'!B25,\"Yes\",\"No\")","v":"No"},"<- Additional to the Tall Building Adder"]
["Tall Building Second Adder Threshold (>150ft)",150]
["Tall Building Third Adder ($/Watt-DC)",{"$f":"IF(C26=\"Yes\",\n      _xlfn.FLOOR.MATH(\n             ((BldgHeight-B25)/50)*0.2,0.2),0.2)","v":0.2},{"$f":"IF(BldgHeight>='Assumptions Calcs & Lookups'!B27,\"Yes\",\"No\")","v":"No"}]
["Tall Building Third Adder Threshold (>200ft)",200]
["Landmarks Adder ($/Project)",1250,{"$f":"IF(Landmark=\"Yes\",\"Yes\",\"No\")","v":"No"}]
["New Meter Adder ($/Project)",1500,{"$f":"IF(AND(MeteringConfiguration=\"CDG (Solar Export Meter)\", RecommendedPVSystemSize>0),\"Yes\",\"No\")","v":{"$error":"#N/A"}},"<- Applied when system is interconnected as CDG (Community Distributed Generation)"]
["Prevailing Wage Adder (%)",0.2,{"$f":"IF(PrevailingWage=\"Yes\",\"Yes\",\"No\")","v":"No"}]
["Price Adjustment (%)",{"$f":"Price_Adjustment_Percentage","v":0},{"$f":"IF(Price_Adjustment_Percentage<>0,\"Yes\",\"No\")","v":"No"}]
["Price Adjustment ($)",{"$f":"IFERROR(Price_Adjustment_Dollar/(PVSystemSize*1000),0)","v":0},{"$f":"IF(Price_Adjustment_Dollar<>0,\"Yes\",\"No\")","v":"No"}]
["Total EPC Price for Model ($/Watt-DC)","Total Price for Simulation ($/Watt-DC)",{"$f":"IF(OREPCPricePerWattDC<>\"\",OREPCPricePerWattDC,\n  (\n     (\n        ((C17+SUMIF(C20:C24,\"Yes\",B20:B24))*RecommendedPVSystemSize*1000)\n      +SUMIF('Assumptions Calcs & Lookups'!C28:C29,\"Yes\",'Assumptions Calcs & Lookups'!B28:B29))\n  /(RecommendedPVSystemSize*1000)*VLOOKUP(ProjectCompletionYear,$H$15:$K$21,2,FALSE))\n  *(IF(PrevailingWage=\"Yes\",1+B30,1))\n)","v":{"$error":"#N/A"}},"<- Adjusted based on project year"]
["Adjusted EPC Price for Model ($/Watt-DC)","Total Price for Simulation ($/Watt-DC)",{"$f":"IF(PriceAdjustmentPercentageApplies=\"Yes\",EPCPricePerWattDC*(1+B31),IF(PriceAdjustmentDollarApplies=\"Yes\",(EPCPricePerWattDC+B32),EPCPricePerWattDC))","v":{"$error":"#N/A"}}]
[]
["Solar Energy System and Production"]
["Year One Shade-Free Production Factor (kWh/kW-DC)",{"$f":"1150/0.95","v":1210.5263157894738},"<- Max output without using Advanced Inputs to override defaults (conservative)."]
["Solar Access (%)",0.95,"<- Default value, Production Factor can be defined by user with Advanced Inputs."]
["Effective Capacity Factor",{"$f":"(Year_One_Shade_Free_Production_Factor__kWh_kW_DC*SolarAccess)/8760","v":0.13127853881278539}]
["Watts-DC Per Square Foot Usable Roof Area",12,"<- Conservative assumption re: power density."]
["Watts-DC Per Square Foot Usable Roof Area (Canopy)",14]
["Max Possible System Size (kW-DC)",{"$f":"IF(Canopy=\"Yes\",UsableRoofArea*B41/1000,UsableRoofArea*B40/1000)","v":0},"<- Max system size based on available roof area (not considering electric bill)."]
["Recommended System Size (kW-DC)",{"$f":"IF(ORPVSystemSize<>\"\",ORPVSystemSize,\n    IF(OR(ElectricTariff=\"EL2\",ElectricTariff=\"EL1\"),\n      IF(MaxPVSystemSize*Year_One_Shade_Free_Production_Factor__kWh_kW_DC*SolarAccess<AnnualUsagekWh,MaxPVSystemSize,MaxPVSystemSize*(AnnualUsagekWh/(MaxPVSystemSize*Year_One_Shade_Free_Production_Factor__kWh_kW_DC*SolarAccess))),\n         IF(MaxPVSystemSize*B37*SolarAccess*Y1VoS<AnnualElectricBill,MaxPVSystemSize,MaxPVSystemSize*(AnnualElectricBill/(MaxPVSystemSize*Year_One_Shade_Free_Production_Factor__kWh_kW_DC*SolarAccess*Y1VoS)))\n       )\n     )","v":{"$error":"#N/A"}},"<- Recommended system never offsets more than 100% of annual usage under net metering, and never offsets more than 100% of owner-paid electric bill under VDER."]
["Year One Solar Production (kWh)",{"$f":"IF(ORY1SolarProduction<>\"\",ORY1SolarProduction,RecommendedPVSystemSize*B37*SolarAccess)","v":{"$error":"#N/A"}}]
["Annual PV Performance Degradation",{"$f":"IF(ORAnnualPVDegradation<>\"\",ORAnnualPVDegradation,0.5%)","v":5.0000000000000001E-3}]
["Metric Tons of Carbon Avoided/Year",{"$f":"Y1SolarProduction*0.00028896","v":{"$error":"#N/A"}}]
[]
["Value of Solar Assumptions/Estimates"]
["Metering Configuration",{"$f":"IF(ORMeteringConfiguration<>\"\",ORMeteringConfiguration,\"Behind-the-Meter\")","v":"Behind-the-Meter"}]
["Electric Tariff",{"$f":"IF(ORElectricTariff<>\"\",ORElectricTariff,IF(MasterMetered=\"Yes\",\"EL8\",IF(ElevatorBuilding=\"Yes\",\"EL9\",IF(AND(MasterMetered=\"No\",ElevatorBuilding=\"No\"),\"EL2\",))))","v":0},"<- Estimated based on User Inputs. Advanced Inputs allow for override."]
["Peak Demand (Prev. 12 Months or Estimated (kW))",{"$f":"IF(ORPeakDemandkW<>\"\",ORPeakDemandkW,(AnnualUsagekWh/8760)*2)","v":0},"<- Estimated based on User Inputs. Assumes 50% Load Factor. Advanced Inputs allow for override."]
["Annual Usage (kWh)",{"$f":"IF(ORAnnualUsagekWh<>\"\",ORAnnualUsagekWh,IF(OR(ElectricTariff=\"EL9\",ElectricTariff=\"EL8\",ElectricTariff=\"EL12\"),AnnualElectricBill/EL8_,IF(OR(ElectricTariff=\"EL2\",ElectricTariff=\"EL1\"),AnnualElectricBill/EL1_,)))","v":0},"<- Estimated based on User Inputs. Advanced Inputs allow for override."]
["CSRP Load Zone",{"$f":"IF(ORCSRPLoadZone<>\"\",ORCSRPLoadZone,\"4:00 PM-8:00 PM\")","v":"4:00 PM-8:00 PM"},"<-Default is most common peak time (4:00-8:00 PM). Advanced Inputs allow for override."]
[]
["NEM Value of Solar ($/kWh)",null,"<- Update every 12 months"]
["Utility Tariff","NEM VoS"]
["EL1",0.33]
["EL2",0.33]
["EL8",0.16]
["EL9",0.16]
["EL12",0.16]
[]
["VDER: Value of Solar by CSRP Load Zone ($/kWh)",null,"<- Update every 12 months. "]
["11:00 AM-3:00 PM",0.19309999999999999,"Source: NYSERDA VDER Calculator Version 3.2, published February 2025. Last updated March 2025."]
["2:00 PM-6:00 PM",0.16289999999999999]
["4:00 PM-8:00 PM",0.13700000000000001]
["7:00 PM-11:00 PM",0.11269999999999999]
[]
["VoS Today",{"$f":"IF(ORY1VoS<>\"\",ORY1VoS,IF(MeteringConfiguration=\"Behind-the-Meter\",VLOOKUP(ElectricTariff,NEMVoSLookup,2,FALSE),IF(MeteringConfiguration=\"CDG (Solar Export Meter)\",VLOOKUP(CSRPLoadZone,CSRPVoSLookup,2,FALSE),)))","v":{"$error":"#N/A"}}]
["VoS for Model",{"$f":"IF(ORY1VoS<>\"\",ORY1VoS,VOSToday*(1+VoSEscalator)^(ProjectCompletionYear-YEAR(NOW())))","v":{"$error":"#N/A"}},"<- Unless the user override the Y1 VoS, the Y1 VoS increases from the VoS Today based on the VoS Annual Escalator and the time between now and Project Completion Year."]
["VoS Annual Escalator",{"$f":"IF(ORVoSEscalator<>\"\",ORVoSEscalator,IF(MeteringConfiguration=\"Behind-the-Meter\",0.025,0.01))","v":2.5000000000000001E-2},"<- Assuming 2.5% annual increase to value of solar under net metering, 1% under VDER."]
[null,null,null,null,null,null,null,null,"Customer Benefit Contribution"]
[null,null,null,null,null,null,null,null,"Behind-The-Meter","CDG (Solar Export Meter)"]
["Annual NEM Customer Benefit Contribution ",{"$f":"IF(Utility=\"PSEG-LI\",0,\nIF(OR(ElectricTariff=H74,ElectricTariff=H75),INDEX(I74:J75, MATCH(ElectricTariff,H74:H75,0), MATCH(MeteringConfiguration,I73:J73,0)),))","v":0},null,null,null,null,null,"EL1",1.84,0.92,"<- month/kW-DC for non-demand metered customers Behind-the-Meter projects."]
["CDG Annual Meter Fees",{"$f":"IF(MeteringConfiguration=\"Behind-the-Meter\",0,IF(ORCDGAnnualMeterFee<>\"\",ORCDGAnnualMeterFee,-C75*12))","v":0},27,"per month","<- Only applied for projects where solar export meter is recommended.",null,null,"EL2",2.15,1.51]
[]
["Solar Incentives",null,"<- Update every 12 months"]
["NY-Sun Incentive <200 kW ($/Watt-DC)",{"$f":"IF(RecommendedPVSystemSize<200,$M$5,0)","v":{"$error":"#N/A"}},"<- References ProjectCompletionYear"]
["NY-Sun Incentive 200-1000 kW ($/Watt-DC)",{"$f":"IF(AND(RecommendedPVSystemSize>=200,RecommendedPVSystemSize<1000),$L$5,0)","v":{"$error":"#N/A"}}]
["NY-Sun Incentive >1,000 kW ($/Watt-DC)",{"$f":"IF(RecommendedPVSystemSize>=1000,$K$5,0)","v":{"$error":"#N/A"}}]
["NY-Sun Affordable Housing Adder ($/Watt-DC)",{"$f":"IF(AffordHousing<>\"No\",$N$5,0)","v":1},"<- Only applicable for the first 200 kW-DC of any solar project."]
["NY-Sun Affordable Housing CDG Adder ($/Watt-DC)",{"$f":"IF(AffordHousing<>\"No\",IF(MeteringConfiguration=\"CDG (Solar Export Meter)\",$O$5,0),0)","v":0},"<- Only applicable for the first 200 kW-DC of any solar project."]
["NY-Sun Rebate ($/Watt-DC)",{"$f":"IF(ORNYSUNDollarPerWattDC<>\"\",ORNYSUNDollarPerWattDC,IF(RecommendedPVSystemSize<=200,SUM($B$78:$B$82),IF(RecommendedPVSystemSize>200,IF(AffordHousing<>\"No\",(((200*SUM($B$78:$B$82))+((RecommendedPVSystemSize-200)*SUM($B$78:$B$80)))/RecommendedPVSystemSize),SUM($B$78:$B$80)),\"\")))","v":{"$error":"#N/A"}},"<- For systems over 200 kW, affordable adders applied to first 200 kW, and base incentive applied to remainder"]
["Federal Tax Credit",{"$f":"IF(ORFedTaxCreditPercent>0,ORFedTaxCreditPercent,\nIF((COUNTIF(TaxIncentiveEligible,\"*Yes*\"))=1,\nIF(OwnerType<>\"Co-op/Condo\",VLOOKUP(ProjectCompletionYear,$H$4:$J$11,2,FALSE),\nIF(OwnerType=\"Co-op/Condo\",VLOOKUP(ProjectCompletionYear,$H$4:$J$11,3,FALSE),)\n),0))","v":0},"<- References OwnerType and ProjectCompletionYear"]
["Bonus Federal Solar Tax Credit",{"$f":"IF(ORFedTaxCreditPercent>0,0,ORBonusFedTaxCreditPercent)","v":0}]
["Energy Community Tax Credit",{"$f":"IF(ORFedTaxCreditPercent>0,0,IF(OREnergyCommunityTaxCredit=\"\",0,0.1))","v":0}]
["Domestic Content Tax Credit",{"$f":"IF(ORFedTaxCreditPercent>0,0,IF(ORDomesticeContentTaxCredit=\"\",0,0.1))","v":0}]
["NY State Residential Tax Credit",{"$f":"IF(TaxIncentiveEligible<>\"No (explain in Applicant Comments)\",25%,0)","v":0.25},"<- Co-ops/condos only, taken by the residents, capped at 50 kW-DC."]
["NYC Property Tax Abatement",0.3,"<- Likely not available to HPD-financed projects."]
["NYC Property Tax Abatement Cap ($)",250000]
["NY State Historic Tax Credit",0.2,"<- Only applicable for rehab projects for co-ops/condos that are either landmark buildings or in an historic district AND income qualifying census tracts. https://www.tax.ny.gov/pit/credits/historic_rehab_credit.htm"]
[]
["Other Assumptions"]
["Residential Federal Income Tax Rate",{"$f":"IF(ORFedTaxRate<>\"\",ORFedTaxRate,25%)","v":0.25},"<- Used to calculate federal income taxes on state tax credit."]
["Corporate Federal Income Tax Rate",{"$f":"IF(ORFedTaxRate<>\"\",ORFedTaxRate,21%)","v":0.21},"<- Used to calculate depreciation value."]
["State Income Tax Rate",{"$f":"IF(ORStateTaxRate<>\"\",ORStateTaxRate,7.1%)","v":7.0999999999999994E-2},"<- Used to calculate depreciation value."]
["Inverter Replacement Cost ($/Watt-DC)",0.2,"<- Inverter is replaced in year 15."]
[]
["Depreciation Schedules",null,null,{"$f":"IF(ProjectCompletionYearIN=2024,0.6,\nIF(ProjectCompletionYearIN=2025,0.4,\nIF(OR(ProjectCompletionYearIN=2026, ProjectCompletionYearIN=2027,ProjectCompletionYearIN=2028,ProjectCompletionYearIN=2029,ProjectCompletionYearIN=2030),0.2,0)))","v":0},"Year 1 Bonus Depreciation"]
["Year","Federal Accelerated Depreciation (MACRS)","State Depreciation","Depreciation"]
[1,{"$f":"$D$99+((1-$D$99)*C101)","v":0.2},0.2]
[2,{"$f":"(1-$D$99)*$C102","v":0.32},0.32]
[3,{"$f":"(1-$D$99)*$C103","v":0.192},0.192]
[4,{"$f":"(1-$D$99)*$C104","v":0.115},0.115]
[5,{"$f":"(1-$D$99)*$C105","v":0.115},0.115]
[6,{"$f":"(1-$D$99)*$C106","v":5.8000000000000003E-2},5.8000000000000003E-2]
[]
["Federal Depreciation Basis",null,"<- Total System Cost minus 50% of the value of the Federal Investment Tax Credit * Tax Incentive Multiplier"]
["State Depreciation Basis",null,"<- Total System Cost minus NY SUN incentive * Tax Incentive Multiplier"]
[]
["Low Income Housing Tax Credits"]
["LIHTC Basis",{"$f":"-TotalEPCPrice*TaxIncentiveMultiplier","v":{"$error":"#N/A"}},"<- Total System Cost * Tax Incentive Multiplier"]
["9% LIHTC Rate",0.09,"<- Source: October 2019 IRS bulletin: https://www.irs.gov/pub/irs-drop/rr-19-23.pdf"]
["4% LIHTC Rate",0.04,"<- Source: COVID-Related Tax Relief Act of 2020."]
["Applicable LIHTC Rate",{"$f":"IF(IncludeLIHTC=\"No\",0,IF(ORLIHTCRate<>\"\",ORLIHTCRate,IF(LIHTCEligible=\"No\",0,IF(LIHTCEligible=\"Yes 9%\",B113,IF(LIHTCEligible=\"Yes 4%\",B114,)))))","v":0}]
[]
["Cost and Incentive Calculations"]
["Tax Incentive Multiplier",1]
["System Cost",{"$f":"-RecommendedPVSystemSize*AdjustedEPCPricePerWattDC*1000","v":{"$error":"#N/A"}}]
["NY SUN Incentive",{"$f":"NYSUNDollarPerWattDC*(RecommendedPVSystemSize*1000)","v":{"$error":"#N/A"}}]
["Upfront Cost",{"$f":"TotalEPCPrice+NYSunIncentive","v":{"$error":"#N/A"}}]
["Federal Investment Tax Credit",{"$f":"-TotalEPCPrice*FedTaxCreditPercent*TaxIncentiveMultiplier","v":{"$error":"#N/A"}},"<- Federal Tax Credit calculated from total EPC price."]
["Bonus Federal Solar Tax Credit",{"$f":"_xlfn.IFNA(-TotalEPCPrice*BonusFedTaxCreditPercent*TaxIncentiveMultiplier,\"\")","v":""}]
["Energy Community Tax Credit",{"$f":"_xlfn.IFNA(-TotalEPCPrice*EnergyCommunityTaxCreditPercent*TaxIncentiveMultiplier,\"\")","v":""}]
["Domestic Content Tax Credit",{"$f":"_xlfn.IFNA(-TotalEPCPrice*DomesticContentTaxCreditPercent*TaxIncentiveMultiplier,\"\")","v":""}]
["LIHTC Value (Undiscounted)",{"$f":"LIHTC_Basis*LIHTCRate*10*TaxIncentiveMultiplier","v":{"$error":"#N/A"}},"<- Total ten year value of LIHTC without net present value calculation."]
["Depreciation Value (Federal and State)"]
["NY State Residential Tax Credit",{"$f":"IF(ORNYSResidentialTaxCredit<>\"\",ORNYSResidentialTaxCredit,\n        IF(StateSolarTaxElig<>\"Yes\",0,\n                  IF(AND(OwnerType=\"Co-op/Condo\",RecommendedPVSystemSize<=50),-UpfrontCost*NY_State_Residential_Tax_Credit,\n                        IF(AND(OwnerType=\"Co-op/Condo\",RecommendedPVSystemSize>50),50*(AdjustedEPCPricePerWattDC-NYSUNDollarPerWattDC)*1000*NY_State_Residential_Tax_Credit,0)\n                       )\n               )\n          )","v":0}]
["NY Historic Tax Credit",{"$f":"IF(AND(ORHistoricTaxCredit =\"yes\", OwnerType=\"Co-op/Condo\",Landmark=\"Yes\",QualifyingCensusTract=\"Yes\",OR(ConstructionType<>\"New Construction\",ConstructionType=\"Sub Rehab\")),-UpfrontCost*NY_State_Historic_Tax_Credit,0)","v":0},"<- Only available for existing owner-occupied properties that are Landmark or Historic and in Income Qualifying Census Tracts."]
["NYC Property Tax Abatement",{"$f":"IF(ORNYCPTA<>\"\",ORNYCPTA,IF(PTAEligible=\"\",0,IF(PTAEligible=\"No\",0,IF(UpfrontCost*NYC_Property_Tax_Abatement>NYC_Property_Tax_Abatement_Cap,NYC_Property_Tax_Abatement_Cap,-UpfrontCost*NYC_Property_Tax_Abatement))))","v":0}]
["Increased Federal Taxes Due to State Incentives",{"$f":"IF(AND(OwnerType=\"For-Profit Rental\", FedTaxCreditPercent>0),(-SUM(B128:B129)*ResiFedTaxRate)-(NYSunIncentive*CorpFedTaxRate),0)","v":0},"<- Assuming that NY-Sun incentive and NY State income tax credits result in corresponding increase to federal income, and therefore tax liability. https://www.bu.edu/law/files/2016/06/Feld-Final-5-30.pdf."]
["Net Cost After Incentives and Taxes",{"$f":"SUM(B121:B131)","v":{"$error":"#N/A"}}]
[]
["Form Completion Check",{"$f":"IF(SUM(ISBLANK(ProjectName),ISBLANK(HPDID),ISBLANK(SiteAddress),ISBLANK(OwnerType),ISBLANK(ProjectCompletionYear),ISBLANK(TaxIncentiveEligible),IF(OwnerType<>\"Co-op/Condo\",SUM(ISBLANK(EligibleDepreciation),ISBLANK(LIHTCEligible)),0),ISBLANK(PTAEligible),ISBLANK(Landmark),ISBLANK(QualifyingCensusTract),ISBLANK(BldgHeight),ISBLANK(UsableRoofArea),ISBLANK(Canopy),ISBLANK(Utility),ISBLANK(AnnualElectricBill),ISBLANK(MasterMetered), ISBLANK(ElevatorBuilding), ISBLANK(Name),ISBLANK(Company),ISBLANK(Email),ISBLANK(DeveloperName),ISBLANK(SolarLayoutNotes))>0,0,1)","v":0}]
[]
["This tool was developed by non-profit Solar One. It is provided on an as-is basis and Solar One makes no claims regarding the accuracy of its contents."]
["If you have questions or feedback regarding this tool, please email affordable@solar1.org."]

{"sheet":"HPD Underwriting","index":11,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":true,"merged":[[11,0,11,2],[4,0,4,3],[5,0,6,3],[7,0,7,3],[8,0,8,2],[10,0,10,2],[9,0,9,2],[22,0,22,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[16,0,16,3],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[36,0,36,2],[23,0,23,2],[25,0,25,3],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[35,0,35,3],[43,0,43,2],[44,0,44,2],[45,0,45,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2]]}
[]
[null,null,"   Solar Underwriting Tool"]
[null,null,{"$f":"RIGHT(Results!A2,48)","v":"        Version 2025 1.1, Updated May 2025"}]
[]
["User Inputs"]
["User to fill in all Highlighted Cells (blue). All other cells will be automatically populated/calculated. This tool can be used to assess preliminary solar financial viability for an NYC affordable housing property from an HPD underwriting perspective."]
[]
["Inputs from Solar Screening Tool or Solar Designer"]
["Site Address",null,null,{"$f":"SiteAddress","v":0}]
["Number of Dwelling Units",null,null,{"$f":"DwellingUnits","v":0}]
["Solar Systen Size (kW-DC) ",null,null,{"$f":"PVSystemSize","v":0}]
["Estimated Owner Electric Cost (Annual)",null,null,{"$f":"AnnualElectricBill","v":0}]
["Year One Utility Bill Savings (should be lower than Owner's Electric Cost)",null,null,{"$f":"Results!B12","v":0}]
["Upfront Cost Estimate (after NY-Sun) ",null,null,{"$f":"Results!C19","v":0}]
["Estimated Payback (in years)",null,null,{"$f":"Results!G11","v":"0 years"}]
[]
["Financing & Permanent Loan Assumptions (HPD PM to Populate)"]
["Estimated Project Cost (TDC)",null,null,{"$f":"D10*E18","v":0},{"$f":"IF(PrevailingWage=\"yes\",\"450000\",\"400000\")","v":"400000"}]
["Loan Term (years)",null,null,30]
["Perm. Loan Rate (%)",null,null,4.7500000000000001E-2]
["Cap Rate (%)",null,null,0.05]
["Permanent Lender Maximum LTV",null,null,0.8]
["Permanent Lender Minimum DSCR (typically 1.15 or 1.25)",null,null,1.1499999999999999]
["% of Energy Savings that will be Underwritten ",null,null,0.8]
[]
["Tax Credit Assumptions (HPD PM to Populate)"]
["LIHTC Annual Credit if applicable (9%, 4%, 0%)",null,null,{"$f":"LIHTCRate","v":0}]
["Eligible Basis with Boost (for QCT or DDA)",null,null,1.3]
["Raise per Credit (LIHTC)",null,null,1]
["LIHTC Credit equity",null,null,{"$f":"TenYearLIHTCValue*D28*D29","v":{"$error":"#N/A"}}]
["LIHTC Credit equity per Dwelling Unit",null,null,{"$f":"IFERROR(D30/D10,)","v":0}]
["Federal Solar Tax Credit ",null,null,{"$f":"FedTaxCreditPercent","v":0}]
["Raise per Solar Tax Credit (ITC)",null,null,1]
["Federal Solar Tax Credit equity",null,null,{"$f":"ITC*'HPD Underwriting'!D33","v":{"$error":"#N/A"}}]
[]
["Subsidy & Loan Impacts (Results Automatically Calculated)"]
["Total Cost after ITC & LIHTC Credit Applied",null,null,{"$f":"D14-D30-D34","v":{"$error":"#N/A"}}]
["Underwritten Annual Energy Savings (Year One Savings * % Underwritten)",null,null,{"$f":"D24*D13","v":0}]
["LTV Test for Additional First Mortgage ",null,null,{"$f":"IF(COUNT(D21:D22)<2,\"TBD\",D38/D21*D22)","v":0}]
["DSCR Test for Additional First Mortgage ",null,null,{"$f":"IFERROR(-PV(D20/12,D19*12,D38/D23/12,0),\"TBD\")","v":0}]
["Additional First Mortgage - (Lower of LTV & DSCR Test)",null,null,{"$f":"IF(OR(D39=\"TBD\",D40=\"TBD\"),\"TBD\",MIN(D39:D40))","v":0}]
["Subsidy Required (Incremental Cost of Solar)",null,null,{"$f":"IF(COUNT(D18:D24)<7,\"TBD\",D37-D41)","v":{"$error":"#N/A"}}]
["Subsidy per Dwelling Unit",null,null,{"$f":"IFERROR(D42/D10,\"TBD\")","v":"TBD"}]
["Subsidy as Percent of TDC",null,null,{"$f":"IFERROR(D42/D18,\"TBD\")","v":"TBD"}]
["Metric Tons of Carbon Avoided/Year (LL 97 Coefficients for 2024-2030)",null,null,{"$f":"Results!B11*0.00028896","v":0}]
["Annual \"Value\" of Avoided Carbon (Assuming $268/metric ton per LL97)",null,null,{"$f":"D45*268","v":0}]

{"sheet":"25 Year Cash Flow","index":12,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["25 Year Cashflow"]
[]
["Year","Solar Energy Production (kWh)","Value of Solar ($/kWh)","Customer Benefit Contribution (Behind-the-Meter)","New Meter Fees (CDG Only)","Net Electricity Bill Savings","Upfront System Cost","Inverter Replacement","Federal Tax Credit","LIHTC","Property Tax Abatement","NYS Tax Credit","NYS Historic Tax Credit","Increased Federal Taxes Due to State Tax Credits","Balance","Balance (No Tax Incentives)","Cash Inflows and Outflows"]
[0,null,null,null,null,null,{"$f":"UpfrontCost","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"SUM(F4:N4)","v":{"$error":"#N/A"}},{"$f":"O4","v":{"$error":"#N/A"}},{"$f":"SUM(F4:N4)","v":{"$error":"#N/A"}}]
[1,{"$f":"Y1SolarProduction","v":{"$error":"#N/A"}},{"$f":"Y1VoS","v":{"$error":"#N/A"}},{"$f":"NEMAnnualCBC","v":0},{"$f":"CDGAnnualMeterFee","v":0},{"$f":"(B5*C5)+SUM(D5:E5)","v":{"$error":"#N/A"}},null,null,{"$f":"ITC+SUM('Assumptions Calcs & Lookups'!B123:B125)","v":{"$error":"#N/A"}},{"$f":"TenYearLIHTCValue/10","v":{"$error":"#N/A"}},{"$f":"NYCPTA/4","v":0},{"$f":"NYSResidentialTaxCredit","v":0},{"$f":"NYSHistoricTaxCredit","v":0},{"$f":"IncreasedFedTaxesDue_to_State_Incentives","v":0},{"$f":"O4+SUM(F5:N5)","v":{"$error":"#N/A"}},{"$f":"P4+F5+H5","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[2,{"$f":"B5*(1-AnnualPVDegradation)","v":{"$error":"#N/A"}},{"$f":"C5*(1+VoSEscalator)","v":{"$error":"#N/A"}},0,{"$f":"CDGAnnualMeterFee","v":0},{"$f":"(B6*C6)+SUM(D6:E6)","v":{"$error":"#N/A"}},null,null,null,{"$f":"TenYearLIHTCValue/10","v":{"$error":"#N/A"}},{"$f":"NYCPTA/4","v":0},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$f":"NYCPTA/4","v":0},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$f":"NYCPTA/4","v":0},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,{"$f":"-RecommendedPVSystemSize*'Assumptions Calcs & Lookups'!B97*1000","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[21,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[22,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[23,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[24,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[25,{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Change Log","index":13,"n_rows":300,"n_cols":3,"rows_kept":300,"cut":false,"hidden":true,"merged":[[295,0,295,1],[289,0,289,1],[130,0,130,1]]}
["CHANGE LOG"]
["Last updated by Alex Federico on 5/13/25"]
["2025-05-01"]
["Item","Description"]
["NY-Sun <200kW and >200kW","Updated rates to $0.60"]
["NY-Sun Affordable & Affordable CDG","Changed from hardcorded rates to formulas. $1.60 minus the NY-Sun <200kW rate & $2.00 minus the NY-Sun <200kW rate"]
["2025-03-01"]
["Item","Description"]
["Results: Bonus Federal Tax Credit %","Adjusted the formula to check for the ORFedTaxCredit first, if it is over 30% then the Bonus will be calculated as ORFedTaxCredit minus 30%.  If the ORFedTaxCredit is NOT over 30% then the Bonus will be calculated by adding together the BonusFedTaxCredit, EnergyCommunityTaxCredit, and the DomesticContect TaxCredit. "]
["Results: Federal Tax Credit %","Adjusted the formula to check for the ORFedTaxCredit first, if it is over 30% then the Fed Tax Credit will be listed as 30%, if it is not over 30% then it will be value entered in Advanced Inputs"]
["Data Validation: Construction Type","Removed \"Tax Exemption Only, Maintenance Only, or Delegated Loan\" as an option"]
["Project Info","Added a row for \"Is project receiving HPD subsidy?\""]
["Data Validation: HPD Subsidy","Added list for new HPD Subsidy dropdown"]
["Assumptions Calcs & Lookups: VDER","Updated VDER rates using the 2025 NYSERDA Calculator"]
["Assumptions Calcs & Lookups: CBC Rates","Updated Customer Benefit Constribution rates using the 2025 NYSERDA Customer Benefit Constribution Rates"]
["Assumptions Calcs & Lookups: NYSUN Rates","Updated the <200kW from$1.00 to $0.80 & >200kW from $0.80 to $0.60"]
["Assumptions Calcs & Lookups: NEM Value of Solar","Increased EL1 and EL2 from $0.30 to $0.33 based on S1 & NYCA's average rates"]
["Assumptions Calcs & Lookups: System Price Est","Updated the Est EPC Pricing based on NYSERDA pricing data 2021-2024"]
["Instructions and Assumptions","replaced\nhttps://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics \nwith \nhttps://www.irs.gov/credits-deductions/residential-clean-energy-credit"]
["Instructions and Assumptions","replaced\nhttps://www.energy.gov/eere/solar/federal-solar-tax-credits-businesses \nwith \nhttps://www.energy.gov/sites/default/files/2024-02/508%20Federal%20Solar%20Tax%20Credits%20for%20Businesses_Feb24.pdf              "]
["Building Info: Is project eligible for the Federal Solar Tax Credit?","replaced\nhttps://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics \nwith \nhttps://www.irs.gov/credits-deductions/residential-clean-energy-credit"]
["Multiple Buildings: Is project eligible for the Federal Solar Tax Credit?","replaced\nhttps://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics \nwith \nhttps://www.irs.gov/credits-deductions/residential-clean-energy-credit"]
["Instructions and Assumptions","Updated version to \"2025 1.0\""]
["2024-08-24"]
["Item","Description"]
["Advanced Input: Total Price Adjustment","Added Data Validation to prevent both fields from being used. "]
["Assumptions Calcs & Lookups: NYSUN First 200k","Lowered the rate from $1.00 to $0.80"]
["Summary and S1 Review\nHPD Approval Form","Removed DOB LL92/94 Exemption Letter inputs"]
["Project Info","Removed the button for Multiple Buildings. Removed the following inputs: Roof Condition; Project is proposing electrification/energy efficieny work?"]
["Building Info","Added the button for Multiple Buildings.  Added the following inputs: Roof Condition; Project is proposing electrification/energy efficieny work?"]
["Multiple Buildings","Added a column for Project is porposing electrification/energy work?"]
["2024-07-24"]
["Item","Description"]
["HPD Approval Form: System Type","change formula from = SystemType \nto\n =IF(Canopy=\"Yes\", \"Canopy\",\n    IF(SystemType<>\"\",SystemType,\n      IF(BldgHeight<100, \"Ballasted\", \"Planar\")\n      )\n    )"]
["Data Validation: Next Steps","Added next steps for New Construction and changed next steps for IPNA Status"]
["Results: Next Steps","Updated the formula to prioritize check the construction type before the project status"]
["HPD Approval Form: % of Savings Underwritten","Change from an input to a formula. If New Construction 80%, otherwise 50%"]
["Summary & S1 Review: % of Savings Underwritten","Change from an input to a formula. If New Construction 80%, otherwise 50%"]
["HPD Approval Form: System Type","Changed formula to default to Ballasted for buildings <100ft and Planar for building >=100ft if no System Type is selected in Advanced Inputs"]
["Summary & S1 Review:System Type","Changed formula to default to Ballasted for buildings <100ft and Planar for building >=100ft if no System Type is selected in Advanced Inputs"]
["HPD Approvval Form & Summary and S1 Review","Fixed Recommendation and DOB dropdown lists"]
["Data Validation: Project Status","Change Scoping to Scoping )note: submit after pre-scoping meeting)"]
["Project Info: Does project propose electrification/energy efficiency work that may affect solar/roof design?","Updated hover comment"]
["Visual Basic: ThisWorkbook","Added VBA Private Sub Workbook_BeforeClose that checks if any internal only sheets are visible before closing. If any of them are visible a message box will pop up. "]
["Advance Inputs","Removed conditional formatting from Bonus Tax Credits. They will no longer grey out when the Federal Tax Credit OR is used. "]
["Project Info: Is project subject to DOB LL92/94","Changed language from Seeking DOB LL92/94 Exemption Letter?\" To \"Is project subject to DOB LL92/94?\"\nRemoved Hyperlink\nUpdated dropdown options"]
["Roof Layout","Added hover instructions for adding pictures.\n\nTo insert 1 image:\nGo to Insert  > Pictures > Place In Cell and then select the location of your image\n\nTo insert more than 1 image:  \nGo to Insert  > Pictures > Place Over Cells and then select the location of your image. Once the images have been placed onto the sheet, please move and resize the images so that they fit within space provided."]
["2024-05-01"]
["Item","Description"]
["Data Validation","Created a new sheet called Data Validation. "]
["Assumptions & Calcs","Moved dropdown list options from Assumptions & Calcs to Data Validation"]
["Project Info","Condensed merged cells to being from across 7 Columns to across 2"]
["HPD Approval Form & Solar Summary","Changed Lifetime Net Savings foruma to reference Cashflow O29 (lifetime net savings)"]
[]
["2024-05-01"]
["Item","Description"]
["Macros","Regrouped condensed the macros into less modules. Renamed the modules to describe the macros located in the module. "]
["Print Areas and page layouts","Change the margins for all worksheets to Normal. Adjusted print areas."]
["Project Info","Added a macro button to show Multiple Buildings worksheet"]
["Multiple Buildings","Added a macro button to clear inputs and close the worksheet"]
["2024-02-01"]
["Item","Description"]
["see full list of February 2024 edits at link >>>","https://docs.google.com/spreadsheets/d/1MEhAUnbrp4GxzV_G78OSxPqnwGfGFpelIGbL2g1a6EA/edit#gid=0"]
[]
["2024-01-24"]
["Item","Description"]
["Assumptions Calcs & Lookups","Added lists for \"Bonus Federal Solar Tax Credit (%)\" & \"Bonus Federal Solar Tax Credit Description\""]
["Advanced Inputs","Changed \"Federal Solar Tax Credit (%)\" to \"Bonus Federal Solar Tax Credit (%)\"\nAdded \"Bonus Federal Solar Tax Credit Type\" \nAdded \"Eligible for Energy Community Tax Credit?\"\nAdded \"Eligible for Domestic Content Tax Credit?\""]
["Assumptions Calcs & Lookups","Changed \"Federal Tax Credit\" calculation \n =IF((COUNTIF(TaxIncentiveEligible,\"*Yes*\"))=1, IF(ORFedTaxCreditPercent<>\"\",ORFedTaxCreditPercent, IF(OwnerType<>\"Co-op/Condo\",VLOOKUP(ProjectCompletionYear,$H$4:$J$11,2,FALSE), IF(OwnerType=\"Co-op/Condo\",VLOOKUP(ProjectCompletionYear,$H$4:$J$11,3,FALSE),))),0)\n"]
["Assumptions Calcs & Lookups","Added Bonus Federal Tax Credit, Energy Community Tax Credit, and Domestic Content Tax Credit to Solar incentives "]
["Assumptions Calcs & Lookups","Updated NY State Residential Tax Credit calculation so that it is only calculated with a YES"]
["Assumptions Calcs & Lookups","Added calculations for \"Bonus Federal Solar Tax Credit (%)\",  \"Bonus Federal Solar Tax Credit Type\", Added \"Eligible for Energy Community Tax Credit?\", and \"Eligible for Domestic Content Tax Credit?\"\n=-TotalEPCPrice*______*TaxIncentivesMultiplier"]
["HPD Approval Form","Separated Solar Tax Credit into solar Federal Tax Credit BASE and Solar Federal Tax Credit BONUS"]
["Summary & S1 Review","Replaced with the new HPD Approval Form"]
["Assumptions Calcs & Lookups","Added a matrix with Updated CBC charges for 2024"]
[]
[]
[]
[]
[]
["2023-12-14"]
["Item","Description"]
["Assumptions Calcs & Lookups","Added \"<- Assuming that NY-SUN incentive and NY State income tax credits result in corresponding increase to federal income, and therefore tax liability. https://www.bu.edu/law/files/2016/06/Feld-Final-5-30.pdf.\""]
["Assumptions Calcs & Lookups","changed\"<- Applied when owner-paid electricity is metered under EL8, EL9, or EL12 rate in order to increase value of solar under VDER tariff.\" to \"<- Applied when system is interconnected as CDG (Community Distributed Generation)\""]
["Instructions & Assumptions","removed 2023 numbers from Depreciation instructions."]
[" ","changed CSRP note to say: \"<-Default is most common peak time (4:00-8:00 PM). Advanced Inputs allow for override.\""]
["Assumptions Calcs & Lookups","Removed the note \"<- Assuming net energy metering for EL2, EL1, EL9 with >25 kW peak demand, and PSEG-LI. VDER for all other electricity tariffs.\" from Assumptions & Calculations C67"]
["Assumptions Calcs & Lookups","Changed Version to \"Version 2.3, Updated December 2023\""]
["Instructions & Assumptions: Federal Tax Credit","Added the following language\n\"…The tax credit is currently available for commercial businesses (as the Investment Tax Credit or ITC), for tax-exempt organizations (through Elective/Direct pay), or for owner-occupied homes, including co-ops and condos (as the Residential Energy Tax Credit or RETC - option to be taken through Transferability)...\""]
["Instructions & Assumptions","Removed the NY-SUN Incentives from the Solar Incentives section and moved it to a new section titled \"NY-SUN Incentives\" right after the Solar Incentives.  This includes the Incentive rates, NY_SUN Multifamily Affordable Incentive and the NY-SUN Affordable CDG Incentive."]
["Instructions & Assumptions: NYS Residential Tax Credit","Added the following language:\n\"...educting the NY-SUN incentive. This tax credit goes directly to residents and is non-refundable, so owner-residents must have a tax liability to take this incentive. The NYS…\""]
["Instructions & Assumptions: NYC Solar Property Tax Abatement","Updated the rate from 20% to 30%\nAdded the following language: \n\"...incentive cannot be monetized. If a building has a partial exemption, this incentive may be monetized on the remaining taxes. A user can\"\n\"...Building Info tab and elaborate on eligibility in the Comments section.”"]
["Insturctions & Assmptions: Note Regarding Tax Incentives","Removed the following language \"...and can be done using the HPD Underwriting tab or outside of this tool.”\""]
["Building Info: Applicant Comments description","Changed to \"Please write any comments on project explaining why Applicant believes project should include solar or be exempt from including solar.\""]
["Building Info: Project Completion Year","Removed 2022 & 2023 from Data Validation. Added 2027-2030"]
["Assumptions Calcs & Lookups: Roof Condition","Changed \"Roof was replaced…\" to \"Roof was resurfaced…\""]
["Project Info","Changed \"Electrification\" to \"Project includes electrificiation/ efficiency work\""]
["Building Info","Changed \"Building Type\" to \"Owner Type\""]
["Building Info","Changed \"Number of Dwelling Units\" to \"Number of Dwelling Units in Project\""]
["Building Info: Federally Funded Affordable Housing","Added comment \"Federal Housing Programs qualify projects for the IRA’s Category 3 bonus tax credit.\""]
["Building Info: Eligible for NYC Solar Property Tax Abatement ","Change the comment from \"As of 2021, building that install solar in NYC are eligible to receive a solar property tax abatement, which has a value of 20% of the total upfront investment, capped at $250,000 per tax lot.\" to \"As of 2024, NYC solar projects may be eligible for a 30% property tax abatement\""]
["Building Info: Income Qualifying Census Tract","Changed from \"Income Qualifying Census Tract\" ot \"Is project in a Qualified Census Tract?\"\nChange link to https://www.huduser.gov/portal/sadda/sadda_qct.html"]
["Advanved Inputs: Total Price Adjustment %","Change \"Total Price Adjustment %\" to \"Total Price Adjustment % (e.g. GC Markup)\""]
["Assumptions Calcs & Lookups: S1 Review and HPD Approval - Solar Mandate Approval - Dropdown Options","Uncapitalized first word after the dash (-)\nAdded: \nSolar Not Required - payback period >10 years\nSolar Not Required - other reason, see comments\nRemoved:\nSolar Note Required - not cost -effective"]
["HPD Approval Form: Projected System Details","Changed \"See Building List for details\" to \"See Site Address/es for details\""]
["HPD Approval Form","Change \"DOB LL92/94 Exemption Letter Required?\" to \"Is HPD-issued letter for DOB LL92/94 Exemption Required?\""]
["Building Info: LIHTC","Changed dropdown options to Yes 9%, Yes 4%, and No"]
["Assumptions & Calcs: Applicable LIHTC Rate","Updated formual to reflect new dropdown options"]
["Instructions and Assumptions: Federal Tax credit","Removed project completion table"]
["Summary and S1 Review","Added a section \"Solar One Comments (HPD Internal Use):\""]
["Instructions & Assumptions: NY-SUN Incentives","Added \"Note: For tax liable owners the NY-SUN Incentive may be considered taxable income. This tool calculates the amount of taxes owed based on the estimated corporte income tax rate.\""]
["Instructions & Assumptions: HPD Underwriting ","Removed entire section"]
["Building Info: Is project eligible for Federal Solar Tax Credit?","Expanded yes/no options to  \nYes (owner is a taxable entity)\nYes (owner is a non-profit)\nYes (owner is eligible for transferability)\nNo (explain in Applicant Comments)"]
["Results","Removed \"*If building owner is not able to benefit from tax incentives directly, third-party ownership may allow the owner to benefit from tax incentives indirectly.\" and associated asterisks "]
["Results","Removed \"For HPD PMs: the payback period captures the incentives listed, but do not necessarily impact HPD's budget or underwriting. Please see the PM tab for underwriting details.\""]
["Assumptions & Calcs: NY-SUN Incentives Rate","<200kW changed from 1.20 to 1.00\nAffordable Adder changed from .40 to .60\nAffordable CDG adders changed from .40 to 1.00"]
["Assumptions & Calcs: Total EPC Price","Udpated Project Completion Year reference to include the full table"]
["2023-11-23"]
["Item","Description"]
["Assumptions Calcs & Lookups: Roof Condition","Changed \"Excellent and replaced in the last 5 years\" to \"Roof was replaced in the last 5 years\""]
["Project Info: Project Details","Added a line for Electrification"]
["Assumptions Calcs & Lookups: Dropdown Lists","Added dropdown list for Electrification"]
["Building Info","Added section header \"Incentives Eligibility\" & moved \"Federally Funded affordable Housing?\" to the new section"]
["Advanced Inputs","changed the instructions from \"Values entered into this form will override any default assumptions or calculated values. All fields on this page are optional. The advanced inputs are completely optional.  Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate cells with confirmed information.\"\nto\n\"All fields on this page are optional. Values entered into this form will override any default assumptions or calculated values. Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate a cell if you have confirmed information for it. \""]
["Advanced Inputs","Change sections headers\n\"Solar Energy System Characteristics\" to \"Projected System Details and Cost\"\n\"Incentives and Taxes\" to \"Incentives\""]
["Results","Change section headers\n\"System\" to \"Projected System Performance\"\n\"Costs\" to \"Estimated Costs\"\n\"Tax Incentives\" to \"Available Tax Incentives\""]
["Summary and S1 Review","Change \"System Details\" to \"Project System Details\""]
["Assumptions Calcs & Lookups: Dropdown Lists","Add 421a and Reso A to the HPD Programs dropdown list"]
["Summary and S1 Review","Removed \"Est. Cost After Incentives (& Taxes)\""]
["HPD Approval Form","Changed section headers\n\"System Details\" to \"Projected System Details\"\n\"Solar Savings\" to \"Estimated Savings\"\n\"Solar Costs and Incentives\" to \"Estimated Costs and Incentives\""]
["2023-10-23"]
["Item","Description"]
["Building Info","Added comment to Accelerated Depreciation\n\nSolar energy systems owned by commercial businesses are eligible for federal and state accelerated depreciation, including a year one bonus depreciation at the federal level and 5-year MACRS at the state level. Please note that the ability to take advantage of depreciation depends on a business' taxable passive income and tax rate."]
["Assumptions Calcs & Lookups","Added Gut Rehab & Maintenance Only to the Construction Type list"]
["Project Info & Assumptions Calcs & Lookups","Sheet: Project Info\nAdded a label and drop down for Roof Condition\n\nSheet: Assumptions calcs & lookups\nListed the roof condition options for the drop down data validation"]
["Assumptions Calcs & Lookups","Added a list for Roof Condition dropdown\n        - Excellent and replaced in the last 5 years \n        - Roof is getting repaired or replaced as part of scope\n        - Other (explain in the Roof Layout comments section) "," "]
["Roof Layout","Added a row for Roof Condition that pulls the input from the Project Info sheet using the formula =IF(RoofCondition=0, \"Not Populated\", RoofCondition) and added conditional formatting that will make \"Not Populate\" italicized and grey"]
["Roof Layout","Added language to the instructions - \"Please include any existing or planned equipment (e.g. HVAC systems, cell towners/antennas, roof decks, etc.).\" "]
["Assumptions Calcs & Lookups: New Meter Adder ($/Project)","OLD: =IF(MeteringConfiguration=\"CDG (Solar Export Meter)\",\"Yes\",\"No\")\nNEW: =IF(AND(MeteringConfiguration=\"CDG (Solar Export Meter)\", RecommendedPVSystemSize>0),\"Yes\",\"No\")"]
["Building Info: Income Qualifying Census Tract","Updated link from https://cris.parks.ny.gov/Login.aspx?ReturnUrl=%2f to https://cimsprodprep.cdfifund.gov/CIMS4/apps/pn-nmtc/index.aspx#?center=-98.212,38.724&level=4"]
["Building Info","Added the following underneath the Advanced Inputs button\n“The advanced inputs are completely optional.  Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate cells with confirmed information.”"]
["Advaced Inputs ","Added the following to the instructions\n“The advanced inputs are completely optional.  Answering these additional inputs will increase the accuracy of your feasibility analysis. Please only populate cells with confirmed information.”"]
["Building Info: Solar Canopy Design Proposed","Moved Solar Canopy Design Proposed up to be underneath Estimated Usable Roof Area for Solar (sq ft)"]
["Summary and S1 Review","Combined Construction Type and Includes Solar in LIHTC Eligible Basis to one row.\nConbined Is Project EGC or LEED? And LIHTC Project to one row. \nMoved Est Annual Owner-Paid Electricity Costs under Site Address\nChanged Solar Project Details to System Details"]
["Results","Reorganized the results sheet into \"buckets\" - Systen, Tax Incentives, Costs, and Takeaways"]
["Results: System Cost","To ensure that all numbers are positive the System Cost formula was changed from =IFERROR('Assumptions Calcs & Lookups'!$B$111,0) to -IFERROR('Assumptions Calcs & Lookups'!$B$111,0)"]
["Building Info","Links Added to: \nEligible for Solar Tax Credit - https://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics \nLandmark or Historic Distric - https://parks.ny.gov/shpo/tax-credit-programs/\nProject Can Benefit From Accelerated Depreciation - https://www.seia.org/initiatives/depreciation-solar-energy-property-macrs\nFederally Funded Affordable Housing - https://www.federalregister.gov/documents/2023/08/15/2023-17078/additional-guidance-on-low-income-communities-bonus-credit-program#p-26"]
["HPD Approval Form","Comments and Signature cells were added to the editable ranges when the sheet is protected"]
["Results","Added conditional formatting. If Eligible for Solar Tax Credits\" is \"No\" then the cell will be greyed out"]
["Results","Added the following underneath Takeaways:\n\"If building owner is not able to benefit from tax incentives directly, third-party ownership may allow the owner to benefit from tax incentives indirectly.\""]
["Results","Added the following at the end of the page:\n\"For HPD PMs: the payback period captures the incentives listed, but do not necessarily impact HPD's budget or underwriting. Please see the PM tab for underwriting details.\""]
["Assumptions Calcs & Lookups","Added additional building height adders to account for buildings over 150ft & adjusted the formulas to account for building that are greater than AND EQUAL TO the threshold"]
["Assumptions Calcs & Lookups","Changed the Federal Tax Credit % and NY State Residential Tax Credit to ensure that it is influenced by the Eligible For Solar Tax Credit. The following If statement was added to the beginning of both.\n=IF(TaxIncentiveEligible=\"Yes\","]
["Assumptions Calcs & Lookups","Updated the CBC rate in the Annual NEM CBC formula"]
["Assumptions Calcs & Lookups","Added ANCP to the HPD Programs list"]
["Assumptions Calcs & Lookups: NEM VoS Rates","Updated NEM Value of Solar Values from $0.24 to $0.30 and $0.12 to $0.16"]
["Assumptions Calcs & Lookups: Meter Configuration","Changed from\n=IF(ORMeteringConfiguration<>\"\",ORMeteringConfiguration,IF(Utility=\"PSEG-LI\",\"Behind-the-Meter\",IF(OR(ElectricTariff=\"EL2\",ElectricTariff=\"EL1\"),\"Behind-the-Meter\",IF(AND(ElectricTariff=\"EL9\",PeakDemandkW>25),\"Behind-the-Meter\",\"CDG (Solar Export Meter)\"))))\nto\n=IF(ORMeteringConfiguration<>\"\",ORMeteringConfiguration,\"Behind-the-Meter\")"]
["Assumptions Calcs & Lookups: VDER VoS CSRP Load Zones","Updated rates from the Here Comes Solar VDER Rate Cheat Sheet"]
["2023-03-23"]
["Item","Description"]
["Fixed State Tax Credit sign error","State tax credit was calculated as a negative number. Fixed to make the tax credit a positive number."]
["2023-01-01"]
["Item","Description"]
["Removed IncludeLIHTC from form completion check","To account for greyed out cells, removed \"IncludeLIHTC\" from the form completion check formula and added logic to disregard LIHTC and accelerated depreciation for if co-op/condos."]
["Price Adjustment","Made price adjustment allow for negative as well as positive adjustments"]
["25 Year Cash Flow","Changed the Federal Tax Credit formula back to simply =ITC.  "]
["Instructions and Assumptions: Solar Energy System Costs","Replaced: Note: Historically, the turnkey cost of solar energy systems has declined by 4% per year. To keep estimates conservative, this tool does not assume prices decline over time. Please note that Advanced Inputs override cost assumptions.\nWith information regarding the Turnkey Solar Energy Systems Price and Total Price Adjustment inputs. "]
["Advanced Inputs: CSRP Load Zone","Updated link for 2023 and made the default CSRP zone 4-8 PM"]
["Building Info: Federally Funded Affordable Housing?","Added a note listing the types of housing that are eligible"]
["Instructions and Assumptions: Accelerated Depreciation","Removed \"100%\" from \"...including 100% year one bonus depreciation…\""]
["November/December 2022"]
["Item","Description"]
["Raised base EPC price ($/Watt) by 10%","Inflation adjustment"]
["Updated version number and date in header"]
["Added 2026 to the Project Completion Year dropdown and lookup table"]
["Increased ITC and RETC to 30%","IRA improvement"]
["LIHTC basis modification to eliminate 50% ITC haircut","IRA improvement"]
["Instructions and Assumptions","Replaced all the screenshot images of charts with referenced cells"]
["Assumptions Calcs & Lookups B91:B96 Federal Accelerated Depreciation & D91:D96 State Depreciation","Updated depreciation schedule and calculator. Changed Federal Depreciation to be based off of the ProjectCompletionYearIN. Added the Year 1 Bonus Depreciation and depreciation over 6 years. "]
["Assumptions Calcs & Lookups","Named any unnamed cells using the label to the left of the data"]
["Advanced Inputs: Federal Solar Tax Credits","Increased the data validation limit from 30% to 70%"]
["Assumptions Calcs & Lookups: Federal Investment Tax Credit","Changed from =IF(TaxIncentiveEligible=\"Yes\",-UpfrontCost*FedTaxCreditPercent*TaxIncentiveMultiplier,) to =IF(TaxIncentiveEligible=\"Yes\",-TotalEPCPrice*FedTaxCreditPercent*TaxIncentiveMultiplier,)"]
["Assumptions Calc & Lookups: NY State Residential Tax Credit","Removed IF(TaxIncentiveEligible=\"\"… by changing IF(TaxIncentiveEligible=\"No\"… to IF(OR(….\nChanged Co-op-Condos with a System Size <=50 from UpfrontCost to TotalEPC Print (similar to changes made in Federal Investment Tax Credit)"]
["Building Info","Shifted rows down to add \"Federally Funded Affordable Housing?\" "]
["Assumptions Calcs & Lookups","Added HRP as a HPD Program - Dropdown Option"]
["Advanced Inputs","Shifted rows down to add \"Eligible for State Solar Tax Credit?\" "]
["Assumptions Calcs & Lookups: NY State Residential Tax Credit","Shifted rows down to add \"Eligible for State Solar Tax Credit?\" "]
["Advanced Inputs","Shifted rows down to add \"Price Adjustment\""]
["Assumptions Calcs & Lookups","Added Pricing Adjustment (%) and Adjusted EPC Price for Model ($.Watt-DC) to the Pricing Adders. Changed all formulas referencing EPCPricePerWattDC to AdjustedEPCPricePerWattDC"]
["Advanced Inputs","Shifted rows down to add \"Include NYSERDA in Federal Tax Credit?\" to Incentives and Taxes"]
["Results","Added NY-SUN $/Watt"]
["25 Year Cash Flow","Updated the Federal Tax Credit formula to an If statement dependant on \"Include NYSERDA in Federal Tax Credit?\""]
["2022-05-22"]
["Item","Description"]
["Removed TSRF calculation","Removed the back-end calculation for TSRF as it couldn't be adjusted from building inputs and wasn't providing benefit. "]
["New Meter adder based on MeteringConfiguration","Changed the new meter adder (in the pricing section) to be dependent on  MeteringConfiguration\"\", rather than the electrical tariff. "]
["Comments cleanup for elimination of Community Credit","Changed comments to remove references to \"incresed value of solar\""]
["Cost by year of completion","Updated cost reduction to 0%/year due to recent inflation and cost increases. No longer safe to assume costs will decline."]
["Updated NYSERDA MW block Incentives","Increased base incentive to $1.20/W and affordable incentive to $1.60/W. Multifamily CDG remains at $2/W. Changed formulas to reference new NYSERDA incentive segments of <200 kW, >200 kW and >1 MW."]
["2022-01-01"]
["Item","Description"]
["Affordable Housing Yes/No","Added option for selecting non-affordable housing "]
["Multifamily CDG Adder","Added Multifamily CDG adder and changed NYSERDA incentive calculation to SUM all available incentives"]
["Update NEM values","changed from $.11 and $.22 to $.12 and $.24 for EL-9 and EL-2 respectively. "]
["Increased blended utility rate","For estimating kWh usage from total annual bill. Changed from $0.20 for EL9 and $.24 for EL2, to $.22 and $.26 respectively"]
["Updated instructions & Assumption","to update years and add in Affordable CDG adder."]
["Updated VDER rates","Removed Community Credit"]
["Updated Project Completion Year","Done"]
["2021-09-01"]
["Item","Description"]
["Added \"Format and Print\" to HPD Approval Form tab - NG","Done"]
["Updated Customer Benefit Contribution calc - NG","Updated calculation to reflect the NY PSC's August 16th order which clarified that demand-metered customers that participate in net-metering do not need to pay this fee"]
["Updated header of Results tab to include Project Name - NG","Changed the header formula to include ProjectName instead of Site Address to account for multibuilding sites"]
["Deleted NewConstruction named range - NG","Deleted a named range that was not referenced in any meaningful formulas"]
["Added N/A option for roof area ","Changed Data Validation to Warning with message \"Only input N/A if system size is already included in Advanced Inputs Tab\""]
["Added N/A option for building height","Changed Data Validation to Warning with message \"Only input N/A if system price ($/W)  is already included in Advanced Inputs Tab\""]
["Removed sample language on solar summary page","Done"]
["Added buttons to hide 25 Year Cashflow and HPD Underwriting Tool","Orange Buttons at base of page will hide tools and bring user back to Results Page"]
["Add IFERROR to solar summary page (for systems not proposing solar)","Cleared errors from Results and Solar Summary pages"]
["Make >500kW error message, not stop","Changed Data Validation to Warning above 500 kW"]
["Add HPD PM field","Added Project Manager name and email to Contact Information section"]
["Added \"System Type\" to Advanced Inputs page","Allowed mechanically attached price adder and canopy adder to be toggled on and off with System Type on advanced inputs. "]
["Added warning if system size is greater than savings","Added conditional formatting to System Size (Advanced Inputs) to turn the cell red if solar savings are > 110% of annual electricity bill (also applies if User Inputs Electricity Information isn't filled out) "]
["Carbon offset number","added to instructions & assumptions"]
["Rounded PV System Size to 3 decimal places","Fixed bug and rounded PV System Size on Summary and S1 Review to 3 decimal places"]
[]
["Created Project Info Tab - ks","Created Project Info Tab as new first page of screening tool"]
["Reassigned Names to fields in project info tab","Moved named fields to project info tab including: Project Name, Site Address, Name, Company, Email, Developer Name, HPDID, "]
["Remove HPDID from User Inputs Tab","Removed HPDID from User Inputs Tab"]
["Named Fields for Project Info tab fields","Created Named fields for: #Buildings in Project, #BuildingsSolar, HPDPM, HPDPMEmail, HPDProgram, EGCorLeed"]
["Drop down menu options listed on assumptions tab","Created Drop-down menu options in Assumptions Cals & Lookups tab for data validation for - Is Project Proposing Solar? and -is Applicant seeking DOB Exemption Letter?"]
["Hyperlink to DOB Exemption Letter","Added hyperlink to Is Applicant seeking DOB Exemption Letter to lead user to DOB bulletin."]
["Reordered user inputs fields","Reordered User Inputs to group by Construction details, Building Details, Tax Incentive Details (to make faster for user to fill in, especially when using totals for portfolios)"]
["Reworded user inputs fields to match S1 Summary and HPD Approval","Reworded questions to be statements and to match S1 Summary and Review and HPD approval form terminology"]
["Edited Instructional Text for Project Info tab","Created instructional Text for Project info Page and made a edits to User Inputs instructional Text"]
["Edited Instructional Text for Roof Layout Page","Edited instructional text on Roof Layout page to be more explicit about what images to provide and what to write."]
["Moved Applicant Info/Contact info to bottom of page","S1 Summary Page: Moved Applicant Information and HPD information to bottom and project details to top"]
["Consolidated HPD Solar Waiver? + S1 Recommendation fields ","S1 Summary Page: Remove \"Is Building Seeking HPD Solar Waiver\" and move S1 Recommendation to top of Solar Review Section, and change wording to \"S1 Recommendation for HPD Solar Mandate\""]
["Change \"Waiver\" language to \"Exempt\"","S1 Summary Page: HPD Solar Mandate Recommendation Options -changed options to say  \"Exempt\" instead of \"Waiver\" "]
["Add\" Exempt from Some but not All\" option","S1 Summary Page: HPD Solar Mandate Recommendation Options - added \"Exempt from Solar for some but not all buildings\""]
["DOB Exemption Options edits","S1 Summary Page: DOB Exemption Options - changed wording to match project inputs page options, and to include \"Other- see comments\",   , \"yes - solar proposed on some but not all buildings\""]
["Construction Type","Changed \"New Construction/Renovation\" to Construction Type (including New Construction, Sub Rehab, and Mod Rehab)"]
["Project Completion Year","Made Project Completion Year default to current year if field is left blank"]
["MW Block Update","Updated NY-SUN MW block to $0.20/W for 2021"]
["Open Approval Form Ctr+Shft+A","Shortcut added to open HPD Approval Form"]
["HPD ID Data Validation","HPD ID only allows 5 numeric digits"]
["\"Is Project Proposing Solar?\"","Changed \"seeking HPD Mandate Exemption\" to \"Is Project Proposing Solar\" on Project Info tab"]
["HPD Program Dropdown","Added HPD program dropdown to Project Info tab"]
["Hide Approval Form & Summary","Clicking the HPD logo will hide the Solar Approval Form and Solar Summary"]
[]
["2021-02-01"]
["Item","Description"]
["Updated solar tax credits to reflect 2 year extension","Extended federal solar tax credit by two years, pursuant to the Covid-Related Tax Relief Act of 2020 (Dec 2020)."]
["Updated 4% LIHTC to reflect new 4% floor value","Updated 4% LIHTC to reflect the 4.00% permanent floor value, pursuant to the Covid-Related Tax Relief Act of 2020 (Dec 2020)."]
["Added \"Include Solar in LIHTC Basis\" field","If user selects No, this will exclude solar from the LIHTC basis. This will be used for 9% deals where LIHTC is capped."]
["Added Project Name to User Inputs tab",{"$f":"A256","v":"Added Project Name to User Inputs tab"}]
["Added hidden Summary and S1 Review tab which can be displayed using the shortcut \"CNTRL + SHIFT + R\"","Added a tab which Solar One will populate for all projects and save as a PDF for distribution to HPD Sustainability and HPD PM. This form will be hidden from users. It will replace the S1 Review Form in HPD/S1's internal review process."]
["Eliminate CBC for projects completed in 2021","Remove the Customer Benefit Contribution (\"solar tax\") for projects with a 2021 completion year (the PSC delayed this fee on solar customers by one year due to Covid)."]
["Reduced the annual decrease in solar EPC cost from 4% per year to 2% per year","To account for the unfortunate fact that NYSERDA's 4% annual forecast cost improvements experienced industry wide will not necessarily benefit HPD financed projects."]
["5% increase to default solar production factor","Increased shade-free production factor by 5%, to 1,211 kWh/kW-DC. Default assumption is 5% shade losses, so Y1 production factor is 1,150 kWh/kW-DC which is still very conservative, especially for canopies and systems with optimizers."]
["Added Meter Configuration field to Advanced Inputs","Added optional Metering Configuration field to Advanced Inputs so users can state explicitly if a project is Behind-the-Meter of CDG (Solar Export). This value is autocalculated otherwise and drives estimated value of solar, annual escalator and utility fees. Updated Value of Solar calculations to take this field into account."]
["Added Number of Dwelling Units as Use Input","Field is used to inform subsidy impact calculation on HPD Underwriting tab"]
["Added Advanced Inputs to enable accurate modeling of multi-building portfolios (S1 only)","Added: NYSERDA NY-SUN Incentive ($/Watt-DC), Property Tax Abatement Amount ($), NY Residential Income Tax Credit Amount ($) and Narrative Section"]
["Added function to account for the escalation in Y1 Value of Solar between now and Project Completion Year","IF(ORY1VoS<>\"\",ORY1VoS,VOSToday*(1+VoSEscalator)^(ProjectCompletionYear-YEAR(NOW())))"]
["Updated \"Clear Advanced Inputs\" macro","To account for the new field that we added to the page."]
["Updated Solar One contact email","Changed herecomessolar@solar1.org to affordable@solar1.org"]
["Updated Project Completion Year","Removed 2020 as an option on Project Completion Year, added 2024 as an option in dropdown."]
["Updated descriptions","Updated descriptive text at the top of the User Inputs and Instruction and Assumptions pages to reflect HPD's SWF policy and Solar One's formal TA role."]
["Added Developer/Owner Name","Added developer/owner name to get information on  the project developer in addition to the applicant."]
["Re-ran VDER Calculator (v2.5) for updated value of solar for CDG projects","Updated the Y1 value of solar for CDG projects. Modest reduction to value of solar based on latest NYSERDA VDER Calculator (v2.5)."]
[]
["2020-10-01"]
["Item","Description"]
["Added HPD ID","Added HPD ID field to User Input and to the bottom of the Solar Summary tab (displayed under contact info)."]
["Corrected formatting issues with HPD Underwriting tab","Formatted all dollar values as $$."]
[]
["2020-06-01"]
["Item","Description"]
["Added TaxCreditMultiplier","To account for the fact that many of the properties are financed with LIHTC, and HPD uses a standard assumption of 99.99% ownership by the tax equity investor. This assumption is applied universally."]
["Added HPD Underwriting tab","Added tab for HPD's underwriting analysis, which provides another view of the incremental cost and/or benefit of a solar project on an affordable housing development's financials."]
["Updated NY-SUN incentive levels","Reduced NYSERDA's base incentive to $0.40/Watt-DC due to the May 2020 drop in the NY-SUN incentive. Modified the affordable housing adder to reflect NYSERDA's modification to the incentive that ensures affordable housing solar projects up to 200 kW-DC receive a $1.00/Watt-DC incentive."]
["Added \"Annual NEM Customer Benefit Contribution \"","Added to Assumptions Calcs & lookups line 65, and Cash Flow column D. Did not include potential escalator that may be determined in the future. Calculation assumes 70% of CBC for large commercial VDER projects (as recommended by the PSC) Calculation extends to 25 years, however PSC only guarantees rate for 20 years."]
["Cleaned up system size formula on Solar Summary","(changed \"B39\" to RecommendedPVSystemSize)"]
["Added Prevailing Wage option","Added Prevailing wage to user inputs which increases the price by 20%"]
[]
["2020-03-20"]
["Item","Description"]
["Added Instructions and Assumptions tab","Added brief instructions for how to use the tool as well as a detailed description of all key assumptions included in the solar screening tool."]
[]
["2020-02-01"]
["Item","Description"]
["Simplified User Inputs re: Owner Paid Electricity","Moved electricity tariff, usage (kWh), peak demand, and CSRP zone to Advanced Inputs. Added calculations to estimate usage, peak demand and tariff from simplified user inputs (Est. Annual Owner Paid Electricity Costs, Elevator vs Walkup, Master Metered)"]
["Utility Company","Added input for PSEG-LI. If user selects PSEG-LI as their utility, the value of solar calculation is unchanged however the model removes the NYSERDA incentive which is not available in Far Rockaway."]
["Canopy","Created user input where user can specify whether a canopy installation is utilized, and added a pricing increase (and increased power density assumption) to account for this design approach."]
[]
["2019-12-01"]
["Item","Description"]
["Project Completion Year","Added Project Completion Year to user inputs. Created declining incentive schedules and forecast 4% annual turnkey EPC cost reduction to account for projected changes."]
["Advanced Inputs","Created an Advanced Inputs tab with optional inputs that override the default values."]
["NY-SUN Incentive","Modified NY-SUN affordable housing adder to assume that increases to stabilize the incentive at $1.00/Watt-DC as the MW Block steps down."]