{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions and Assumptions","Project Info","Building Info","Advanced Inputs","HPD Approval Form","Summary and S1 Review","Roof Layout","Results","Assumptions Calcs & Lookups","HPD Underwriting","25 Year Cash Flow","Change Log"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":160,"comments":7,"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":306,"n_cols":7,"rows_kept":306,"cut":false,"hidden":false,"merged":[[49,6,49,7],[58,4,58,5],[59,4,59,5],[60,4,60,5],[59,2,59,3],[267,2,276,7],[288,2,294,7],[296,2,299,7],[283,2,283,3],[283,4,283,5],[283,6,283,7],[284,2,284,3],[285,2,285,3],[286,2,286,3],[284,4,284,5],[285,4,285,5],[286,4,286,5],[284,6,284,7],[281,1,282,7],[97,1,100,7],[107,1,109,7],[50,2,50,3],[51,2,51,3],[278,2,278,7],[36,1,39,7],[305,1,309,7],[237,2,241,7],[63,1,64,7],[243,2,256,7],[233,2,235,7],[220,2,224,7],[226,2,230,7],[185,1,188,7],[197,1,199,7],[206,1,207,7],[209,2,213,7],[158,1,162,7],[169,1,174,7],[175,1,175,7],[53,2,53,3],[54,2,54,3],[48,2,48,7],[49,2,49,3],[285,6,285,7],[286,6,286,7],[201,1,201,7],[191,3,191,4],[301,2,301,7],[5,1,5,7],[6,1,11,7],[13,1,13,7],[15,1,15,7],[17,1,17,7],[111,1,111,7],[103,1,103,7],[106,1,106,7],[124,1,124,7],[101,1,101,7],[102,1,102,7],[110,1,110,7],[19,1,19,7],[23,1,23,7],[35,1,35,7],[42,1,44,7],[96,1,96,7],[21,1,21,7],[25,1,25,7],[58,2,58,3],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,2,52,3],[259,3,259,4],[259,5,259,6],[258,2,258,6],[194,3,194,4],[192,3,192,4],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[86,3,86,5],[87,3,87,5],[193,3,193,4],[82,3,82,5],[83,3,83,5],[84,3,84,5],[85,3,85,5],[88,3,88,5],[128,3,128,7],[129,3,129,7],[130,3,130,7],[178,2,183,7],[146,1,156,7],[2,3,2,6],[3,3,3,6],[32,3,32,6],[33,3,33,6],[76,3,76,6],[60,6,60,7],[61,6,61,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[66,1,69,7],[60,2,60,3],[61,2,61,3],[61,4,61,5],[55,2,55,3],[56,2,56,3],[57,2,57,3],[134,1,135,7],[137,1,139,7],[141,1,144,7],[164,1,166,7],[190,3,190,5],[77,3,77,5],[78,3,78,5],[79,3,79,5],[80,3,80,5],[81,3,81,5],[125,1,125,7],[112,1,117,7],[120,1,123,7],[118,1,118,7],[119,1,119,7],[131,3,131,7],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[131,1,131,2],[126,3,126,7],[127,3,127,7]]}
[]
[]
[null,null,null,"SOLAR FEASIBILITY ANALYSIS"]
[null,null,null,"        Version 2.3, Updated December 2023"]
[]
[null,"Instructions"]
[null,"The Solar Feasibility Analysis tool can be used to complete a preliminary assessment of solar financial viability for a New York City affordable housing property. 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 electric systems on affordable housing properties participating in HPD programs. Completing this Solar Feasibility Analysis is an HPD requirement for all New Construction, Substantial Rehabilitation, and Preservation projects."]
[]
[]
[]
[]
[]
[]
[null,"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."]
[]
[null,"2. Advanced Inputs (Optional): if you have specific 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."]
[]
[null,"3. Roof Layout: include an image of the Sustainable Roofing Zone or the solar panel layout on the Roof Layout tab, and provide a brief (1-2 sentence) description in the blue text area at the bottom of the page. If the project has a separate roof plan which includes a detailed solar array, please note this on the Roof Layout tab, but still include a screenshot of the design in the Solar Feasibility Analysis."]
[]
[null,"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 Utility Savings, and Payback Period."]
[]
[null,"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."]
[]
[null,"6. Submission: once you have completed the HPD Solar Feasibility Analysis for your property, submit it along with the Roof Plan and any additional documentation, using the instructions on HPD's Solar Where Feasible website: https://www1.nyc.gov/site/hpd/services-and-information/solar-where-feasible.page  "]
[]
[null,"Questions: if you have questions or feedback regarding this tool, feel free to contact Solar One:"]
[null,null,null,null,null,"Email:","affordable@solar1.org"]
[]
[]
[]
[]
[]
[null,null,null,"SOLAR FEASIBILITY ANALYSIS"]
[null,null,null,{"$f":"D4","v":"        Version 2.3, Updated December 2023"}]
[]
[null,"Assumptions"]
[null,"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."]
[]
[]
[]
[]
[null,"Solar Energy System Costs"]
[null,"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. "]
[]
[]
[]
[null,"First, a base price is estimated based on system size:"]
[]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A3","v":"System Price Estimate ($/Watt-DC)"}]
[null,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,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.5}]
[null,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.6750000000000007}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A7","v":20},null,{"$f":"'Assumptions Calcs & Lookups'!B7","v":29.99},null,{"$f":"'Assumptions Calcs & Lookups'!C7","v":3.9600000000000004}]
[null,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.63}]
[null,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.4100000000000006}]
[null,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.2450000000000006}]
[null,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.1350000000000002}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A12","v":100},null,{"$f":"'Assumptions Calcs & Lookups'!B12","v":149.99},null,{"$f":"'Assumptions Calcs & Lookups'!C12","v":2.9700000000000006}]
[null,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.75}]
[null,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.5299999999999998}]
[null,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.4200000000000004}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A16","v":750},null,{"$f":"'Assumptions Calcs & Lookups'!B16","v":0},null,{"$f":"'Assumptions Calcs & Lookups'!C16","v":2.3100000000000005}]
[]
[null,"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."]
[]
[]
[null,"Note: The base prices may be overridden using the Turnkey 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%)."]
[]
[]
[]
[]
[]
[]
[]
[null,"Next, pricing adders are applied based on the project's complexity:"]
[]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A19","v":"Pricing Adders"}]
[null,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,null,{"$f":"'Assumptions Calcs & Lookups'!A21","v":"Canopy Adder ($/Watt-DC)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B21","v":1.2}]
[null,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,null,{"$f":"'Assumptions Calcs & Lookups'!A23","v":"Tall Building First Adder Threshold (>70ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B23","v":70}]
[null,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,null,{"$f":"'Assumptions Calcs & Lookups'!A25","v":"Tall Building Second Adder Threshold (>150ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B25","v":150}]
[null,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,null,{"$f":"'Assumptions Calcs & Lookups'!A27","v":"Tall Building Third Adder Threshold (>200ft)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B27","v":200}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A28","v":"Landmarks Adder ($/Project)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B28","v":1250}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A29","v":"New Meter Adder ($/Project)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B29","v":1500}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A30","v":"Prevailing Wage Adder (%)"},null,null,{"$f":"'Assumptions Calcs & Lookups'!B30","v":0.2}]
[]
[null,"The Mechanically Attached Adder is applied for system < 15 kW-DC or more than 100 feet tall."]
[null,"The Canopy Adder is applied if \"Solar Canopy Design\" = \"Yes\"."]
[null,"The Tall Building Adders are applied on top of any other pricing adders based on the building height."]
[null,"The Landmarks Adder is applied if \"Landmarks or Historic District\" = \"Yes\"."]
[null,"The New Meter Adder is applied if the system will be installed as a Community Solar (or CDG) type system. "]
[null,"A Prevailing Wage Adder of 20% is applied to all projects where Prevailing Wages are required."]
[]
[null,"Solar Energy System Size"]
[null,"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. "]
[]
[]
[]
[]
[null,"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,null,"Standard Power Density: 12 Watts-DC/sq ft"]
[null,null,"Canopy Power Density: 14 Watts-DC/sq ft"]
[]
[null,"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."]
[]
[]
[]
[null,"Solar Energy Production"]
[null,"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."]
[]
[]
[]
[]
[]
[]
[null,"Utility Bill Savings"]
[null,"Unless a user enters override values for the Value of Solar ($/kWh) fields using Advanced Inputs, utility 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:"]
[]
[]
[]
[]
[null,"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:"]
[null,"Con Edison Tariff",null,"Description"]
[null,"EL9",null,"Large Commercial (typical electricity tariff for elevator building common areas with individually metered apartments)"]
[null,"EL2",null,"Small Commercial (typical electricity tariff for walk up building common areas with individually metered apartments)"]
[null,"EL8",null,"Master Metered Residential Rate"]
[null,"EL1",null,"Residential and Religious Rate (most common for individual apartments or houses of worship)"]
[null,"EL12",null,"Master Metered Residential Rate w/Electric Resistance Heating"]
[]
[]
[null,"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:"]
[]
[]
[null,"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.30/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.34/kWh to estimate annual usage."]
[]
[]
[]
[null,"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."]
[]
[]
[]
[]
[null,"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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Net Energy Metering"]
[null,"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.30/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. "]
[]
[]
[]
[]
[]
[null,"Customer Benefit Contribution: 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 whose solar project is compensated under Net Energy Metering, the fee is estimated to be $1.09/kW-DC/month. "]
[]
[]
[]
[null,"Value of Distributed Energy Resources (VDER)"]
[null,"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:"]
[]
[]
[]
[]
[]
[null,"https://www.nyserda.ny.gov/All-Programs/Programs/NY-Sun/Contractors/Value-of-Distributed-Energy-Resources/Solar-Value-Stack-Calculator"]
[]
[null,null,"Commercial System Relief Program (CSRP) Zone"]
[null,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."]
[]
[]
[]
[]
[]
[]
[null,"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 lowest value CSRP Zone unless otherwise indicated using the Advanced Inputs."]
[]
[]
[]
[]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A61","v":"VDER: Value of Solar by CSRP Load Zone ($/kWh)"}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A62","v":"11:00 AM-3:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B62","v":0.18909999999999999}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A63","v":"2:00 PM-6:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B63","v":0.16550000000000001}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A64","v":"4:00 PM-8:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B64","v":0.13439999999999999}]
[null,null,null,{"$f":"'Assumptions Calcs & Lookups'!A65","v":"7:00 PM-11:00 PM"},null,{"$f":"'Assumptions Calcs & Lookups'!B65","v":0.1124}]
[null,null,null,"Last updated May 2022 using Version 2.6 of the NYSERDA VDER Calculator."]
[]
[null,"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."]
[]
[]
[]
[null,"New Meter Fees: solar projects compensated under the Community Distributed Generation program require new Con Edison meters. The monthly meter fee is estimated to be $27/month."]
[]
[]
[]
[null,"Solar Incentives"]
[null,"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,null,"Federal Tax Credit: solar projects installed in the United States are eligible for a federal income tax credit. The tax credit is current 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,null,"https://www.energy.gov/eere/solar/homeowners-guide-federal-tax-credit-solar-photovoltaics "]
[null,null,"and the ITC here: "]
[null,null,"https://www.energy.gov/eere/solar/federal-solar-tax-credits-businesses"]
[null,null,"and Elective/Direct Pay and Transferability here: "]
[null,null,"https://www.irs.gov/credits-deductions/elective-pay-and-transferability"]
[]
[null,null,"New York State Residential Tax Credit: 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 for owner-occupied buildings only."]
[]
[]
[]
[]
[]
[null,null,"New York State Historic Rehabilitation Tax Credit: 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 for owner-occupied buildings where Landmark/Historic District = Yes and Income-Qualifying Census Tract = Yes. Learn more about this incentive program here:"]
[]
[]
[]
[]
[null,null,"https://parks.ny.gov/shpo/tax-credit-programs/"]
[]
[null,null,"Interaction Between NY State Incentives and Federal Income Taxes: 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,null,"NYC Solar Property Tax Abatement: 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 over the course of four year. 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,null,"Accelerated Depreciation: solar 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. The federal basis for depreciation is the total cost of the solar energy system minus half of the federal tax credit. The state basis for depreciation is the cost of the solar energy system minus the NY-SUN incentive. Please note that an owner's ability to take advantage of depreciation depends on their business' taxable passive income, income tax rates and total tax liability. If a user indicates that they are not able to benefit from Accelerated Depreciation or that they are not eligible for solar tax incentives, the value of this incentive is calculated to be zero. Unless a user specifies federal and state income tax rates using Advanced Inputs, the assumed federal income tax rate for calculating the value of depreciation is 21% and the state income tax rate is 7.1%. The federal year one bonus depreciation is dependent on the project completion year stepping down to 20% in 2026. The table below shows the depreciation schedule according to the project completion year entered in this tool:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A93","v":"Depreciation Schedules"}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A94","v":"Year"},{"$f":"'Assumptions Calcs & Lookups'!B94","v":"Federal Accelerated Depreciation (MACRS)"},null,{"$f":"'Assumptions Calcs & Lookups'!C94","v":"State Depreciation"}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A95","v":1},{"$f":"'Assumptions Calcs & Lookups'!B95","v":0.2},null,{"$f":"'Assumptions Calcs & Lookups'!C95","v":0.2}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A96","v":2},{"$f":"'Assumptions Calcs & Lookups'!B96","v":0.32},null,{"$f":"'Assumptions Calcs & Lookups'!C96","v":0.32}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A97","v":3},{"$f":"'Assumptions Calcs & Lookups'!B97","v":0.192},null,{"$f":"'Assumptions Calcs & Lookups'!C97","v":0.192}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A98","v":4},{"$f":"'Assumptions Calcs & Lookups'!B98","v":0.115},null,{"$f":"'Assumptions Calcs & Lookups'!C98","v":0.115}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A99","v":5},{"$f":"'Assumptions Calcs & Lookups'!B99","v":0.115},null,{"$f":"'Assumptions Calcs & Lookups'!C99","v":0.115}]
[null,null,{"$f":"'Assumptions Calcs & Lookups'!A100","v":6},{"$f":"'Assumptions Calcs & Lookups'!B100","v":5.8000000000000003E-2},null,{"$f":"'Assumptions Calcs & Lookups'!C100","v":5.8000000000000003E-2}]
[]
[null,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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Note regarding tax incentives: this preliminary feasibility tool evaluates a solar project's economics holistically. The tool includes the value of tax incentives as they accrue to the owner / tax credit investor over a period of up to ten years, including LIHTC, ITC and depreciation. Often, affordable housing developers prefer to consider the amount of tax equity they will receive as an upfront source, essentially collapsing the LIHTC, ITC and depreciation into a tax equity investment amount. The value of accelerated depreciation is often what allows tax investors to include a raise per credit > 1.0. This alternative method of analysis is also an important way to look at a solar project's economics, and can be done outside of this tool."]
[]
[null,"NY-SUN Incentives"]
[null,"NYSERDA offers a capacity-based incentive for solar projects in New York, as a base incentive plus a multifamily affordable housing adder 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,null,"Con Edison NY_SUN Incentive",null,"Project Size (kW-DC)",null,"Incentive Rate ($/W)"]
[null,null,"Small",null,"0-200 kW",null,{"$f":"'Assumptions Calcs & Lookups'!M5","v":1}]
[null,null,"Medium",null,"200-1,000 kW",null,{"$f":"'Assumptions Calcs & Lookups'!L5","v":1}]
[null,null,"Large",null,">1,000 kW",null,{"$f":"'Assumptions Calcs & Lookups'!K5","v":0.5}]
[]
[null,null,"NY-SUN Multifamily Affordable Incentive: 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,null,"NY-SUN Affordable CDG Incentive: 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,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 corporte income tax rate."]
[]
[null,"Other Assumptions"]
[]
[null,"Solar Operations & Maintenance: 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":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,0,30,6],[5,0,5,6],[4,0,4,6],[26,0,26,1],[6,0,6,6],[7,0,7,1],[7,2,7,6],[16,0,16,1],[16,2,16,6],[18,0,18,1],[18,2,18,6],[17,0,17,1],[17,2,17,6],[8,0,8,1],[8,2,8,6],[13,0,13,6],[15,0,15,1],[29,2,29,6],[29,0,29,1],[15,2,15,6],[11,0,11,1],[11,2,11,6],[23,2,23,6],[24,2,24,6],[12,0,12,1],[12,2,12,6],[27,0,27,1],[26,2,26,6],[27,2,27,6],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[33,0,41,6],[32,0,32,6],[9,0,9,1],[9,2,9,6],[14,0,14,1],[14,2,14,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[25,0,25,6],[10,0,10,1],[10,2,10,6],[28,0,28,1],[28,2,28,6],[31,0,31,6],[19,0,19,6]]}
[null,null,"USER INPUTS"]
[null,null,{"$f":"RIGHT(Results!A2,35)","v":" Version 2.3, Updated December 2023"}]
[]
[]
["PROJECT INFORMATION"]
["Please fill in all information on the following tabs of the Solar Feasibility Analysis: Project Info, Building Info, and Roof Layout. Advanced Inputs are optional. After Applicant sends the completed analysis to Solar One (S1), S1 will provide feedback to applicant or send its recommendation to HPD for approval, and HPD will generate the Solar Approval Form. This tool can be used for single buildings or an aggregated analysis for multi-building portfolios. Please contact affordable@solar1.org for further instructions on using the tool for multiple buildings."]
["Project Details"]
["Project Name (per HPD)"]
["Site Address/es"]
["Construction Type"]
["# of Buildings in Project"]
["Roof Condition"]
["Project includes electrification/energy efficiency"]
["Applicant Information"]
["Submission Date"]
["Applicant Name"]
["Applicant Company"]
["Applicant Email"]
["Owner/Developer Name"]
["HPD Information"]
["HPD Project ID (5 digits)"]
["HPD Project Manager"]
["HPD Project Manager Email"]
["HPD Program"]
["Is Project EGC or LEED?"]
["Agency Approvals"]
["Is Project Proposing Solar?"]
["Seeking DOB LL92/94 Exemption Letter?"]
["# of Buildings Proposing Solar"]
["Is project subject to DEP Stormwater rules?*"]
["*Note: A project may require a DEP Stormwater Construction Permit if the project disturbs 20,000 sf of soil or creates 5,000 sf of new impervious surface. Projects should assess their DEP stormwater requirements before assessing for solar."]
["Applicant Comments"]
["Please write any comments on project explaining why Applicant believes project should include solar or be exempt from including solar."]

{"sheet":"Building Info","index":2,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,0,22,2],[18,0,18,3],[15,0,15,2],[14,0,14,2],[0,0,0,3],[1,0,1,3],[9,0,9,2],[11,0,11,2],[4,0,5,3],[3,0,3,3],[10,0,10,2],[12,0,12,2],[13,0,13,2],[8,0,8,2],[7,0,7,3],[37,0,38,3],[26,0,26,2],[40,0,42,3],[31,0,31,2],[16,0,16,2],[20,0,20,2],[32,0,32,2],[28,0,28,3],[30,0,30,2],[24,0,24,2],[25,0,25,2],[29,0,29,2],[21,0,21,2],[17,0,17,2],[23,0,23,2],[19,0,19,2]]}
["USER INPUTS"]
[{"$f":"'Instructions and Assumptions'!D4","v":"        Version 2.3, Updated December 2023"}]
[]
["BUILDING INFORMATION"]
["Use this portion of the tool to complete a preliminary assessment of solar financial viability for a New York City affordable housing property. Questions? Please review the Instructions and Assumptions tab, and email affordable@solar1.org if you need help completing this form, have questions about incentives, or for free solar consultation & technical assistance."]
[]
[]
["Project Details"]
["Project Name",null,null,{"$f":"ProjectName","v":0}]
["Site Address/es",null,null,{"$f":"SiteAddress","v":0}]
["Construction Type",null,null,{"$f":"ConstructionType","v":0}]
["Ownership Type"]
["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"]
["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?"]
["Can the project benefit from Accelerated Depreciation?"]
["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",null,null,"Con Edison"]
["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":"Advanced Inputs","index":3,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,43,3],[7,0,7,3],[8,0,8,2],[10,0,10,2],[14,0,14,3],[20,0,20,2],[23,0,23,3],[21,0,21,2],[22,0,22,2],[26,0,26,2],[31,0,31,2],[19,0,19,2],[16,0,16,2],[32,0,32,2],[33,0,33,3],[34,0,37,3],[28,0,28,2],[30,0,30,2],[29,0,29,2],[27,0,27,2],[4,0,4,3],[9,0,9,2],[5,0,6,3],[12,0,12,2],[25,0,25,2],[15,0,15,2],[11,0,11,2],[13,0,13,2],[17,0,17,2],[18,0,18,2],[24,0,24,2]]}
[]
[null,null,"ADVANCED INPUTS"]
[null,null,{"$f":"'Building Info'!A2","v":"        Version 2.3, Updated December 2023"}]
[]
["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)"]
["Turnkey Solar Energy System Price ($/Watt-DC)"]
["Year One Production (kWh)"]
["Annual Solar Performance Degradation"]
["System Type"]
["Total Price Adjustment % (e.g. GC markup)"]
["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"]
["NYSERDA NY-SUN Incentive ($/Watt-DC)"]
["Federal Solar Tax Credit (%)"]
["Low Income Housing Tax Credit (%)"]
["Property Tax Abatement Amount ($)"]
["Eligible for Residential State Income Tax Credit?"]
["Residential State Income Tax Credit Amount ($)"]
["Owner Federal Income Tax Rate (%)"]
["Owner State Income Tax Rate (%)"]
["Regulated Affordable Housing?"]
["Use this space to highlight any additional costs 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":4,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[[19,0,19,1],[19,3,19,4],[20,0,20,2],[20,3,20,5],[32,0,32,1],[28,0,28,2],[29,0,29,2],[25,3,25,4],[31,0,31,5],[30,0,30,5],[26,0,26,5],[27,0,27,5],[28,3,28,5],[29,3,29,5],[25,0,25,1],[24,0,24,1],[24,3,24,4],[21,0,21,1],[21,3,21,4],[23,0,23,1],[22,3,22,4],[23,3,23,4],[22,0,22,1],[8,3,8,5],[9,3,9,5],[17,0,17,1],[18,0,18,1],[18,3,18,4],[15,0,15,2],[14,3,14,5],[14,0,14,2],[15,3,15,5],[16,3,16,4],[17,3,17,4],[10,0,10,5],[16,0,16,1],[32,2,32,3],[0,0,2,5],[12,3,12,5],[13,3,13,5],[12,0,12,2],[13,0,13,2],[4,0,4,5],[5,0,5,2],[6,0,6,2],[7,0,7,2],[11,0,11,5],[8,0,8,2],[9,0,9,2],[5,3,5,5],[6,3,6,5],[7,3,7,5]]}
["HPD SOLAR APPROVAL FORM"]
[]
[]
[]
["Project Details"]
["Project Name",null,null,{"$f":"ProjectName","v":0}]
["Site Address/es",null,null,{"$f":"SiteAddress","v":0}]
["Construction Type",null,null,{"$f":"ConstructionType","v":0}]
["# Buildings in Project",null,null,{"$f":"NumberBuildings","v":0}]
["# Buildings Proposing Solar",null,null,{"$f":"NumberBuildingsSolar","v":0}]
["Projected System Details"]
["Note: When multiple buildings are calculated, the below numbers are project totals and averages. See Site Address/es for details."]
["System Size (kW)",null,null,{"$f":"IFERROR(ROUND(PVSystemSize,2)&\" kW-DC\",0)","v":"0 kW-DC"}]
["System Design Type",null,null,{"$f":"'Summary and S1 Review'!D17","v":"Ballasted"}]
["Est. Y1 Production (kWh)",null,null,{"$f":"IFERROR(Y1SolarProduction,0)","v":0}]
["Estimated Savings",null,null,"Estimated Costs and Incentives1"]
["Est. Y1 Utility Savings ($)",null,{"$f":"IFERROR(Results!B12,0)","v":0},"Est. Cost ($/Watt-DC)",null,{"$f":"IFERROR(AdjustedEPCPricePerWattDC,0)","v":0}]
["Est. Y1 GHG Reduction",null,{"$f":"IFERROR(ROUND('HPD Underwriting'!D45,1)&\" mtCO2e\",0)","v":"0 mtCO2e"},"Est. Total Cost",null,{"$f":"IFERROR(-TotalEPCPrice,0)","v":0}]
["Est. Lifetime Utility Savings",null,{"$f":"IFERROR(SUM('25 Year Cash Flow'!F5:F29),0)","v":0},"Est. Upfront Cost After NY-SUN Incentive",null,{"$f":"IFERROR(-UpfrontCost,0)","v":0}]
["Est. Payback Period",null,{"$f":"Results!B28","v":"0 years"},"Est. Cost After NY-SUN & Tax Incentives",null,{"$f":"Results!B24","v":0}]
["Applicant Information",null,null,"HPD Information"]
["Submission Date",null,{"$f":"IF(Date=0,\"0\",Date)","v":"0"},"HPD ID",null,{"$f":"HPDID","v":0}]
["Applicant Company",null,{"$f":"Company","v":0},"HPD PM",null,{"$f":"HPDPM","v":0}]
["Applicant Name",null,{"$f":"Name","v":0},"HPD Email",null,{"$f":"HPDPMEmail","v":0}]
["Applicant Email",null,{"$f":"Email","v":0},"HPD Program",null,{"$f":"HPDProgram","v":0}]
["Owner/Developer Name",null,{"$f":"DeveloperName","v":0},"Is Project EGC or LEED2",null,{"$f":"EGCorLEED","v":0}]
["HPD Approval"]
["1Estimated costs do not include GC markup.\n2Projects certifying with EGC or LEED must be signed by HPD Sustainability Office, Mod Rehabs must be signed by HPD Preservation PM.\n3Any waivers or DOB Exemptions noted here are for HPD’s Solar Where Feasible requirement only and should not be construed to exempt a project from a DEP stormwater requirement."]
["HPD Determination"]
["Is HPD-issued letter for DOB LL92/94 Exemption Required?3"]
["HPD Comments: \n"]
[]
["HPD Signature (Constitutes HPD Approval)",null,null,null,"Date",{"$f":"NOW()","v":"2023-12-20T20:26:03.590"}]

{"sheet":"Summary and S1 Review","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":true,"merged":[[23,4,23,6],[1,1,1,6],[28,5,28,6],[0,1,0,6],[19,4,19,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[13,1,13,3],[6,1,6,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[8,1,8,2],[13,4,13,6],[8,3,8,6],[9,4,9,5],[10,4,10,5],[5,1,5,6],[7,3,7,6],[6,3,6,6],[11,1,11,2],[11,4,11,5],[34,1,34,2],[30,1,30,2],[31,1,31,2],[24,1,24,3],[24,4,24,6],[28,2,28,3],[25,5,25,6],[26,5,26,6],[27,5,27,6],[23,1,23,2],[16,1,16,2],[25,2,25,3],[26,2,26,3],[27,2,27,3],[14,1,14,6],[33,1,33,6],[31,3,31,6],[30,3,30,6],[34,3,34,4],[29,1,29,6],[20,4,20,5],[21,4,21,5],[22,4,22,5],[15,1,15,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[17,1,17,2],[19,1,19,2],[18,1,18,3]]}
[null,{"$f":"D7&\" Solar Summary\"","v":"0 Solar Summary"}]
[null,{"$f":"RIGHT(Results!A2,35)","v":" Version 2.3, Updated December 2023"}]
[null,null,null,null,null," "]
[]
[]
[null,"Project Details"]
[null,"Project Name",null,{"$f":"ProjectName","v":0}]
[null,"Site Address/es",null,{"$f":"SiteAddress","v":0}]
[null,"Est. Annual Owner-Paid Electricity Costs",null,{"$f":"AnnualElectricBill","v":0}]
[null,"# Buildings in Project",null,{"$f":"NumberBuildings","v":0},"Total Number of Dwelling Units",null,{"$f":"DwellingUnits","v":0}]
[null,"# Buildings Proposing Solar",null,{"$f":"NumberBuildingsSolar","v":0},"Eligible for Federal Solar Tax Credit",null,{"$f":"TaxIncentiveEligible","v":0}]
[null,"Construction Type",null,{"$f":"ConstructionType","v":0},"LIHTC Project",null,{"$f":"LIHTCEligible","v":0}]
[null,"Is Project EGC or LEED?",null,{"$f":"EGCorLEED","v":0},"Includes Solar in LIHTC Eligible Basis",null,{"$f":"IF(IncludeLIHTC=0, \"N/A\", IncludeLIHTC)","v":"N/A"}]
[null,"Projected System Details",null,null,"Solar Costs and Incentives"]
[null,"Note: When multiple buildings are calculated, the below numbers are project totals or averages."]
[null,"System Size (kW)",null,{"$f":"IFERROR(ROUND(PVSystemSize,3)&\" kW-DC\",0)","v":"0 kW-DC"},"Est. Total Cost (pre-incentive)",null,{"$f":"IFERROR(-TotalEPCPrice,0)","v":0}]
[null,"System Design Type",null,{"$f":"IF(Canopy=\"Yes\",\"Canopy\",IF(SystemType<>\"\",SystemType,\"Ballasted\"))","v":"Ballasted"},"NYSERDA NY-SUN Incentive",null,{"$f":"IFERROR(-NYSunIncentive,)","v":0}]
[null,"Est. Cost ($/Watt-DC)",null,{"$f":"IFERROR(AdjustedEPCPricePerWattDC,0)","v":0},"Est. Upfront Cost",null,{"$f":"IFERROR(-UpfrontCost,0)","v":0}]
[null,"Solar Savings",null,null,"Solar Federal Tax Credit",null,{"$f":"IFERROR(-ITC,0)","v":0}]
[null,"Est. Y1 Production (kWh)",null,{"$f":"IFERROR(Y1SolarProduction,0)","v":0},"Additional LIHTC from Solar",null,{"$f":"IFERROR(-TenYearLIHTCValue,0)","v":0}]
[null,"Est. Y1 Utility Savings ($)",null,{"$f":"Results!B12","v":0},"Accelerated Depreciation",null,{"$f":"-Results!B23","v":0}]
[null,"Est. Y1 GHG Reduction",null,{"$f":"IFERROR(ROUND('HPD Underwriting'!D45,1)&\" mtCO2e\",0)","v":"0 mtCO2e"},"NYC Property Tax Abatement",null,{"$f":"-NYCPTA","v":0}]
[null,"Est. Lifetime Utility Savings",null,{"$f":"IFERROR(SUM('25 Year Cash Flow'!F5:F29),0)","v":0},"Residential State Income Tax Credits",null,{"$f":"IFERROR(-(NYSResidentialTaxCredit+NYSHistoricTaxCredit),0)","v":0}]
[null,"Est. Payback Period",null,{"$f":"Results!B28","v":"0 years"},"Please note: tax credits all assume a multiple of 1.0 (no raise). Upfront Cost is cost after the NY-SUN incentive (for budgeting) and before accounting for tax incentives."]
[null,"Applicant Information",null,null,"HPD Information"]
[null,"Applicant Company",{"$f":"Company","v":0},null,"HPD ID",{"$f":"HPDID","v":0}]
[null,"Applicant Name",{"$f":"Name","v":0},null,"HPD PM",{"$f":"HPDPM","v":0}]
[null,"Applicant Email",{"$f":"Email","v":0},null,"HPD PM Email",{"$f":"HPDPMEmail","v":0}]
[null,"Owner/Developer Name",{"$f":"DeveloperName","v":0},null,"HPD Program",{"$f":"HPDProgram","v":0}]
[null,"Solar One Review"]
[null,"S1 Recommendation for HPD"]
[null,"DOB LL92/94 Exemption Letter Required?"]
[null,"Solar One Comments: "]
[]
[null,"Solar One Signature",null,null,null,"Date",{"$f":"NOW()","v":"2023-12-20T20:26:03.590"}]

{"sheet":"Roof Layout","index":6,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,6],[37,0,42,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[5,0,6,6],[35,0,35,6],[9,0,9,3]]}
[]
["ROOF LAYOUT"]
[{"$f":"'Building Info'!A2","v":"        Version 2.3, Updated December 2023"}]
[]
["SOLAR PV SYSTEM LAYOUT OR USABLE ROOF AREA"]
["Provide image/s of roof plan(s) with solar layout or usable roof area. Please include any existing or planned equipment (e.g. HVAC systems, electrification equipment, cell towers, antennas, roof decks, etc.).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":7,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,5],[1,0,1,5],[0,0,0,5],[30,3,30,5],[31,3,36,5],[4,0,7,5],[3,0,3,5],[30,0,30,1],[8,0,8,1],[8,3,8,5],[15,0,15,1],[25,0,25,1],[35,0,36,1]]}
["SOLAR FEASIBILITY ANALYSIS RESULTS"]
[{"$f":"\"           \"&'Roof Layout'!A3","v":"                   Version 2.3, Updated December 2023"}]
[]
[{"$f":"\"PRELIMINARY SOLAR FINANCIAL ANALYSIS: \"&ProjectName","v":"PRELIMINARY SOLAR FINANCIAL ANALYSIS: "}]
["Solar electric 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. The payback period captures incentives listed, but do not necessarily impact HPD's budget or underwriting. "]
[]
[]
[]
["PROJECTED SYSTEM PERFORMANCE",null,null,"ESTIMATED COSTS"]
["Solar Energy System Size (kW-DC)",{"$f":"IFERROR(IF(RecommendedPVSystemSize<4,\"System Too Small\",RecommendedPVSystemSize),0)","v":0},null,"Pre-Incentive Cost Estimate ",null,{"$f":"ABS(IFERROR('Assumptions Calcs & Lookups'!$B$113,0))","v":0}]
["Est. Year One Solar Production (kWh)",{"$f":"IFERROR(Y1SolarProduction,0)","v":0},null,"NY-SUN Incentive","-",{"$f":"ABS(IFERROR(NYSunIncentive,0))","v":0}]
["Year One Utility Bill Savings",{"$f":"IFERROR('25 Year Cash Flow'!F5,0)","v":0},null,"Upfront Cost Estimate"," =",{"$f":"ABS(IFERROR(F10-F11,\"\"))","v":0}]
["NY-SUN $/Watt",{"$f":"IFERROR(NYSUNDollarPerWattDC,0)","v":0}]
["Total Cost ($/Watt-DC)",{"$f":"IFERROR(F10/(PVSystemSize*1000),0)","v":0}]
[]
["AVAILABLE TAX INCENTIVES"]
["Federal Tax Credit %",{"$f":"FedTaxCreditPercent","v":0}]
["Federal Tax Credit",{"$f":"IFERROR(ITC,0)","v":0}]
["Federal Taxes Due to State Incentives",{"$f":"IFERROR('Assumptions Calcs & Lookups'!B122,0)","v":0}]
["Additional LIHTC From Solar",{"$f":"IFERROR(TenYearLIHTCValue,0)","v":0}]
["NYC Property Tax Abatement",{"$f":"IFERROR(NYCPTA,\"\")","v":0}]
["Residential State Income Tax Credits",{"$f":"IFERROR(NYSResidentialTaxCredit+NYSHistoricTaxCredit,0)","v":0}]
["Depreciation (Federal and State)",{"$f":"IFERROR('Assumptions Calcs & Lookups'!B118,\"\")","v":0}]
["Total Tax Incentives",{"$f":"SUM(B18:B23)","v":0}]
[]
["TAKEAWAYS"]
["Internal Rate of Return",{"$f":"IFERROR(IRR('25 Year Cash Flow'!S4:S29,0.1),0)","v":0}]
["Payback Period",{"$f":"IF(COUNTIF('25 Year Cash Flow'!Q4:Q29,\"<0\")&\" years\"=\"26 years\", \"N/A\",COUNTIF('25 Year Cash Flow'!Q4:Q29,\"<0\")&\" years\")","v":"0 years"}]
["Lifetime Net Savings",{"$f":"IFERROR('25 Year Cash Flow'!Q29,0)","v":0}]
[]
["FEASIBILITY REPORT SUBMITTED BY",null,null,"NEXT STEPS"]
["Name",{"$f":"Name","v":0},null,"1. Submit Solar Feasibility Analysis to HPD.\n2. HPD approves project, exempts project, or requires a Solar Consultation.\n3. Refine solar design as needed.\n4. Solicit bids from NYSERDA-qualified solar installation companies."]
["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":"Assumptions Calcs & Lookups","index":8,"n_rows":196,"n_cols":15,"rows_kept":196,"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],[2,7,2,14],[18,8,18,10],[19,8,19,10],[20,8,20,10],[31,0,31,1],[110,0,110,1],[52,0,52,1],[60,0,60,1],[34,0,34,1],[73,0,73,1],[86,0,86,1],[92,0,92,2],[104,0,104,1],[45,0,45,1],[32,0,32,1]]}
["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"]
["Min (kW-DC)","Max (kW-DC)","Price ($/Watt-DC)",null,null,null,null,"Year","ITC","RETC","NY-SUN >1 MW","NY-SUN >200kW","NY-SUN <200kW","NY-SUN Affordable Adder","NY-SUN Affordable CDG"]
[4,9.99,5.5,null,null,null,null,2024,0.3,0.3,0.5,1,1,0.6,0.4]
[10,19.989999999999998,4.6750000000000007,null,null,null,null,2025,0.3,0.3]
[20,29.99,3.9600000000000004,null,null,null,null,2026,0.3,0.3]
[30,44.99,3.63,null,null,null,null,2027,0.3,0.3]
[45,64.989999999999995,3.4100000000000006,null,null,null,null,2028,0.3,0.3]
[65,79.989999999999995,3.2450000000000006,null,null,null,null,2029,0.3,0.3]
[80,99.99,3.1350000000000002,null,null,null,null,2030,0.3,0.3]
[100,149.99,2.9700000000000006]
[150,249.99,2.75,null,null,null,null,"EPC Price Decrease by Project Completion Year"]
[250,499.99,2.5299999999999998,null,null,null,null,"Year","Base Price Percentage"]
[500,749.99,2.4200000000000004,null,null,null,null,2024,1]
[750,null,2.3100000000000005,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,{"$f":"I16","v":1}]
[null,null,null,null,null,null,null,2027,{"$f":"I17","v":1}]
["Pricing Adders",null,"Applies?",null,null,null,null,2028,{"$f":"I18","v":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","v":0},{"$f":"IF(Price_Adjustment<>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(PriceAdjustmentApplies=\"Yes\",EPCPricePerWattDC*(1+B31),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":"(B36*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*B40/1000,UsableRoofArea*B39/1000)","v":0},"<- Max system size based on available roof area (not considering electric bill)."]
["Recommended System Size (kW-DC)",{"$f":"IF(ORPVSystemSize<>\"\",ORPVSystemSize,IF(OR(ElectricTariff=\"EL2\",ElectricTariff=\"EL1\"),IF(MaxPVSystemSize*B36*SolarAccess<AnnualUsagekWh,MaxPVSystemSize,MaxPVSystemSize*(AnnualUsagekWh/(B41*B36*SolarAccess))),IF(MaxPVSystemSize*B36*SolarAccess*Y1VoS<AnnualElectricBill,MaxPVSystemSize,MaxPVSystemSize*(AnnualElectricBill/(MaxPVSystemSize*B36*SolarAccess*Y1VoS)))))","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*B36*SolarAccess)","v":{"$error":"#N/A"}}]
["Annual PV Performance Degradation",{"$f":"IF(ORAnnualPVDegradation<>\"\",ORAnnualPVDegradation,0.5%)","v":5.0000000000000001E-3}]
[]
["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/EL2_,IF(OR(ElectricTariff=\"EL2\",ElectricTariff=\"EL1\"),AnnualElectricBill/(EL2_+0.04),)))","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.3]
["EL2",0.3]
["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.18909999999999999,"Source: NYSERDA VDER Calculator Version 2.6, published May 2022. Last updated May 2022."]
["2:00 PM-6:00 PM",0.16550000000000001]
["4:00 PM-8:00 PM",0.13439999999999999]
["7:00 PM-11:00 PM",0.1124]
[]
["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."]
[]
["Annual NEM Customer Benefit Contribution ",{"$f":"IF(Utility=\"PSEG-LI\",0,IF(MeteringConfiguration=\"CDG (Solar Export Meter)\",0,IF(OR(ElectricTariff=\"EL1\",ElectricTariff=\"EL2\"),-PVSystemSize*1.09*12,)))","v":0},"<- $1.09/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,-27*12))","v":0},"<- Only applied for projects where solar export meter is recommended."]
[]
["Solar Incentives",null,"<- Update every 12 months"]
["NYSERDA NY-SUN Incentive <200 kW ($/Watt-DC)",{"$f":"IF(RecommendedPVSystemSize<200,$M$5,0)","v":{"$error":"#N/A"}},"<- References ProjectCompletionYear"]
["NYSERDA NY-SUN Incentive 200-1000 kW ($/Watt-DC)",{"$f":"IF(AND(RecommendedPVSystemSize>=200,RecommendedPVSystemSize<1000),$L$5,0)","v":{"$error":"#N/A"}}]
["NYSERDA NY-SUN Incentive >1,000 kW ($/Watt-DC)",{"$f":"IF(RecommendedPVSystemSize>=1000,$K$5,0)","v":{"$error":"#N/A"}}]
["NYSERDA NY-SUN Affordable Housing Adder ($/Watt-DC)",{"$f":"IF(AffordHousing<>\"No\",$N$5,0)","v":0.6},"<- Only applicable for the first 200 kW-DC of any solar project."]
["NYSERDA 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($M$5,$B$78,$B$79),IF(RecommendedPVSystemSize>200,IF(AffordHousing<>\"No\",(((200*SUM($M$5,$B$78,$B$79))+((RecommendedPVSystemSize-200)*SUM($B$75:$B$77)))/RecommendedPVSystemSize),SUM($B$75:$B$77)),\"\")))","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((COUNTIF(TaxIncentiveEligible,\"*Yes*\"))=1,\nIF(ORFedTaxCreditPercent<>\"\",ORFedTaxCreditPercent,\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)\n),0)","v":0},"<- References OwnerType and ProjectCompletionYear"]
["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$93+((1-$D$93)*C95)","v":0.2},0.2,{"$f":"SUM(FedDepBasis*CorpFedTaxRate*$B95,StateDepBasis*CorpStateTaxRate*$C95)","v":0}]
[2,{"$f":"(1-$D$93)*$C96","v":0.32},0.32,0]
[3,{"$f":"(1-$D$93)*$C97","v":0.192},0.192,0]
[4,{"$f":"(1-$D$93)*$C98","v":0.115},0.115,0]
[5,{"$f":"(1-$D$93)*$C99","v":0.115},0.115,0]
[6,{"$f":"(1-$D$93)*$C100","v":5.8000000000000003E-2},5.8000000000000003E-2,0]
[]
["Federal Depreciation Basis",{"$f":"IF(EligibleDepreciation=\"Yes\",-TotalEPCPrice-(ITC/2)*TaxIncentiveMultiplier,0)","v":0},"<- Total System Cost minus 50% of the value of the Federal Investment Tax Credit * Tax Incentive Multiplier"]
["State Depreciation Basis",{"$f":"IF(EligibleDepreciation=\"Yes\",-UpfrontCost*TaxIncentiveMultiplier,0)","v":0},"<- 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%\",B107,IF(LIHTCEligible=\"Yes 4%\",B108,)))))","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."]
["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)",{"$f":"SUM('25 Year Cash Flow'!N5:O10)","v":0}]
["NY State Residential Tax Credit",{"$f":"IF(ORNYSResidentialTaxCredit<>\"\",ORNYSResidentialTaxCredit,\n        IF(StateSolarTaxElig=\"No\",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":{"$error":"#N/A"}}]
["NY Historic Tax Credit",{"$f":"IF(AND(OwnerType=\"Co-op/Condo\",Landmark=\"Yes\",QualifyingCensusTract=\"Yes\",OR(ConstructionType=\"Mod Rehab\",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(FedTaxCreditPercent>0,(-SUM(B119:B120)*ResiFedTaxRate)-IF(OwnerType=\"For-Profit Rental\",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(B115:B122)","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."]
[]
["Project Inputs - Is Project Proposing Solar? - Dropdown Options"]
["Yes - project proposing solar"]
["Yes - proposing solar for some buildings but not all"]
["No - project includes green roof over 90% of roof area"]
["No - project cannot support > 4kW"]
["No - solar is not cost effective"]
["No - see comments"]
[]
["Project Inputs - Seeking DOB Exemption Letter - Dropdown Options"]
["No - project design complies with LL92/94"]
["No - project not subject to LL92/94"]
["Yes - project not pursuing solar or green roof"]
["Yes - solar/green roof proposed but doesn't comply w. LL92/94"]
["Yes - solar proposed on some but not all buildings"]
[]
["S1 Review and HPD Approval - DOB Exemption Letter - Dropdown Options"]
["No - project design complies with LL92/94"]
["No - project not subject to LL92/94"]
["Yes - project not pursuing solar or green roof"]
["Yes - solar/green roof proposed but doesn't comply w. LL92/94"]
["Yes - solar proposed on some but not all buildings"]
["Other - see comments"]
[]
["S1 Review and HPD Approval - Solar Mandate Approval - Dropdown Options"]
["Solar Required - payback period ≤ 10 years"]
["Solar Required on some but not all buildings - see comments"]
["Solar Strongly Recommended - see comments"]
["Solar Recommended - see comments"]
["Solar Not Required - because green roof over 90% roof area"]
["Solar Not Required - cannot support >4kW"]
["Solar Not Required - payback period > 10 years"]
["Solar Not Required - other reason, see comments"]
["Project should be redesigned and submitted"]
[]
["HPD Program - Dropdown Options"]
["421a"]
["ANCP"]
["ELLA"]
["GHPP"]
["HRP"]
["HUD Multi Family"]
["LIHTC YR 15"]
["M2"]
["Mix & Match"]
["NCP"]
["Open Door"]
["PLP"]
["Reso A"]
["SARA"]
["SHLP"]
["TPT"]
[]
["Construction Type"]
["New Construction"]
["Sub Rehab"]
["Mod Rehab"]
["Gut Rehab"]
["Maintenance Only"]
[]
["Roof Condition"]
["Roof was resurfaced or replaced in the last 5 years"]
["Roof is getting resurfaced or replaced as part of scope"]
["Other (explain in the Roof Layout comments section)"]
[]
["Electrification"]
["No"]
["Yes (please explain further in the Applicant comments)"]

{"sheet":"HPD Underwriting","index":9,"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 2.3, Updated December 2023"}]
[]
["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!F12","v":0}]
["Estimated Payback (in years)",null,null,{"$f":"Results!B28","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":10,"n_rows":29,"n_cols":19,"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","Federal Accelerated Depreciation","State Depreciation","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,null,null,{"$f":"SUM(F4:P4)","v":{"$error":"#N/A"}},{"$f":"Q4","v":{"$error":"#N/A"}},{"$f":"SUM(F4:P4)","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","v":{"$error":"#N/A"}},{"$f":"TenYearLIHTCValue/10","v":{"$error":"#N/A"}},{"$f":"NYCPTA/4","v":0},{"$f":"NYSResidentialTaxCredit","v":{"$error":"#N/A"}},{"$f":"NYSHistoricTaxCredit","v":0},{"$f":"'Assumptions Calcs & Lookups'!B102*'Assumptions Calcs & Lookups'!B95*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C95*'Assumptions Calcs & Lookups'!$B$90","v":0},{"$f":"IncreasedFedTaxesDue_to_State_Incentives","v":0},{"$f":"Q4+SUM(F5:P5)","v":{"$error":"#N/A"}},{"$f":"R4+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,{"$f":"'Assumptions Calcs & Lookups'!$B$102*'Assumptions Calcs & Lookups'!B96*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C96*'Assumptions Calcs & Lookups'!$B$90","v":0},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,{"$f":"'Assumptions Calcs & Lookups'!$B$102*'Assumptions Calcs & Lookups'!B97*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C97*'Assumptions Calcs & Lookups'!$B$90","v":0},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,{"$f":"'Assumptions Calcs & Lookups'!$B$102*'Assumptions Calcs & Lookups'!B98*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C98*'Assumptions Calcs & Lookups'!$B$90","v":0},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,{"$f":"'Assumptions Calcs & Lookups'!$B$102*'Assumptions Calcs & Lookups'!B99*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C99*'Assumptions Calcs & Lookups'!$B$90","v":0},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,{"$f":"'Assumptions Calcs & Lookups'!$B$102*'Assumptions Calcs & Lookups'!B100*'Assumptions Calcs & Lookups'!$B$89","v":0},{"$f":"'Assumptions Calcs & Lookups'!$B$103*'Assumptions Calcs & Lookups'!C100*'Assumptions Calcs & Lookups'!$B$90","v":0},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,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,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,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,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,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,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,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,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'!B91*1000","v":{"$error":"#N/A"}},null,null,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,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,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,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,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,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,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,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,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,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,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Change Log","index":11,"n_rows":223,"n_cols":3,"rows_kept":223,"cut":false,"hidden":true,"merged":[[218,0,218,1],[212,0,212,1]]}
["CHANGE LOG"]
["Last updated by Alex Federico on 12/15/2023"]
["2023-12-14"]
["Item","Description"]
["Assumptions Calcs & Lookups","B50 - updated electricity rate used to calculate annual kWh usage to draw from NEM EL1 rate"]
["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."]
["Assumptions Calcs & Lookups","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":"A179","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."]