{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["202 Instructions","VISUALS (Examples)","GENERAL","DEV TEAM","INCOME","EXPENSES","SOURCES","USES","TAX CREDIT","SUMMARY","PRO FORMA","CURR FIN INFO","FIN CAP","INCOME TARGETING","LEV & COST EFFECTIVENESS","SELF-SCORE"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":1,"defined_names":115,"comments":0,"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":"202 Instructions","index":0,"n_rows":185,"n_cols":2,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CDA FORM 202 -- APPLICATION FORM INSTRUCTIONS "]
[null," "]
[null,"This section provides information for completing the application form (CDA Form 202). The specific information that is to be entered into the individual fields on the application form is described in detail below.  General Note:  Blue colored cells are generally, \"locked\" calculated cells.  Yellow colored cells are generally application input cells."]
[null," "]
[]
[null,"VISUALS"]
[]
[null,"Visuals:  Provide a project site plan, rendering/elevations, floor plans or a typical project floor plan.  The information should be formatted such at it can be placed in an Excel file and easily copied in to a Word document.  "]
[]
[null," "]
[null,"GENERAL INFORMATION"]
[]
[]
[null,"Date: Enter 202's current submission date.  DO NOT enter the \"=TODAY()\" formula as the date."]
[]
[null,"Type of Project: Indicate whether the project is either a \"9%\", Competitive Round, application or a \"4%\", Non-competitive Bond, application by selecting the project type by using the provided dropdown box. "]
[null," "]
[null,"Stage of Processing:  A Multifamily Rental Financing Application – CDA Form 202 – must be submitted at each stage of processing which reflects all changes in the project, including current development and operating budgets and pro forma. The application for each processing stage must include all applicable exhibits and attachments described in the applicable submission package.  "]
[null," "]
[null,"Project Name and Location:   Provide the name of the project and address.  If you do not have a specific street address, provide the lot, parcel and tax map numbers for the project’s site.  Other information required includes the project’s census tract, congressional district and legislative district. Optional: If available, provide GPS coordinates."]
[]
[null,"Type of Credit Enhancement:  Indicate type of bond execution.  Choose among FHA 221(d)(4); Risk Sharing, (FHA-CDA Risk Sharing); FTEL (Freddie Mac Tax Exempt Loan); MTEB (FNMA MBS Collateral for Tax Exempt Bonds)"]
[]
[null,"Basis Boost Documentation:  Indicate applicable basis boost option"]
[]
[null,"Applicant Information: Provide the name, mailing address, contact person and title, telephone number, facsimile number and e-mail address of the entity that is applying for financing."]
[null," "]
[null,"Ownership Entity Information:  Provide the name, taxpayer’s identification number, and type of entity that will ultimately be the borrower or recipient of the tax credits and own the project.  If the ownership entity has not yet been formed, please indicate.  A sample organizational chart is included on page 12 of the Application Submission Package. All ownership entities must be formed with taxpayer identification numbers shortly after reservation letters are received.  For corporations and controlling general partners, provide the name, taxpayer identification number, percentage of ownership interest for each individual or entity and whether the entity is a nonprofit corporation."]
[]
[null,"Project Description:  Enter a narrative description that highlights the unique or innovative characteristics of the project."]
[null," "]
[null,"Amenities:  Indicate the amenities planned for the development."]
[]
[null,"Developer Fee Funded Supportive Services/Rent Subsidy/Reserve:  Indicate whether the project will include a developer fee funded reserve."]
[null," "]
[null,"Type of Project:  Indicate the type of development being undertaken by marking all appropriate boxes."]
[null," "]
[null,"Existing Building Information:  For the rehabilitation of existing buildings indicate the current percentage of units occupied; whether the rehabilitation will include compliance with historic standards; whether tenants will be permanently or temporarily relocated during the rehabilitation; and the year the building was originally constructed."]
[null," "]
[null,"Number of Residential Buildings:  Show the total number of each type of building included in the project’s design."]
[null," "]
[null,"Total Land Area:  Show the total acreage of the project site(s)."]
[null," "]
[null,"Total Building Area:  Show the gross square footage of all buildings in the project."]
[null," "]
[null,"Type of Occupancy:  Indicate the number of units that will be occupied by individuals or families, the elderly or for commercial use.  "]
[null," "]
[null,"Housing for Persons with Disabilities:  Show the number of units that will serve persons with disabilities.   "]
[null," "]
[null,"Occupancy Restrictions of Project:  Show the number of units that will be income restricted at each income level. All units in the project should be included.  Changes to income restrictions after approval could cause the loss of a funding reservation."]
[null," "]
[null,"Long Term Use Restrictions: All projects requesting competitive LIHTC, RHFP, and/or RHW must agree to at least 40 years of low-income occupancy restrictions, unless a structured 15 year transition to homeownership is presented and accepted.  Indicate if this is a structured 15 year transition to homeownership."]
[]
[null,"Anticipated Development Schedule:  Indicate the month and year that each stage of the development has been or is scheduled to be completed.  For site control, indicate if the sponsor currently has site control, the date control expires number of contract extensions (if any), length of contract extensions (if any), and the expected date the ownership entity will acquire the site.  For zoning, indicate the current zoning.  If a change or variance of the zoning is necessary, show the date of application, final hearing and final approval. For applications with Low-Income Housing Tax Credits, a sponsor must (a) incur costs in excess of 10% of the reasonably expected basis of the project (the \"10% expenditure test\") by within 12 months of the issuance date of the Carryover Allocation, and (b) place the project in service by the end of the second year following the year of the Carryover Allocation.  Failure to meet these requirements will result in the loss of the Tax Credits for the project.  Provide date evidence will be submitted indicating that 10% of project cost have been incurred. "]
[null," "]
[null,"Substantial completion is generally the date when 90% of the rehabilitation or construction is complete, all certificates of use and occupancy have been issued, and the architect has issued the certificate of substantial completion.  Sustaining occupancy is when the project’s income is sufficient to cover operating expenses and debt service for six consecutive months.  The Construction Loan period is the number months from construction start to permanent loan closing plus four months."]
[null," "]
[null,"DEVELOPMENT TEAM "]
[]
[null,"Development Team Members: Provide the entity’s name, complete mailing address, contact person and title, telephone number, facsimile number and e-mail address for each member of the development team"]
[null," "]
[null,"Lending and Investment Partners: Provide the entity’s name, complete mailing address, contact person and title, telephone number, facsimile number and e-mail address for each lender and/or investor.   "]
[null," "]
[null,"Development Team History:  Answer each question concerning the history or prior performance of the members of the development team.  If you answer yes to any of the questions, provide a brief explanation."]
[null," "]
[null,"PROJECT INCOME "]
[]
[null,"Residential Rental Income: Low Income Units. For all low income units in the project, show: the number of bedrooms and baths per unit; the number of units of this size and type; the unit size in net leasable square footage; tenant paid utilities; the contract rent \"paid by the tenant\"; and rental subsidy (if any) expected for the unit.  The monthly income is the net contract rent, adjusted for utilities, and multiplied by the number of units of this size and type. Calculate annual income by multiplying the monthly income by 12 months. The total net leasable square footage for all units is the sum of the unit size multiplied by the number of units for each size and type. To calculate the vacancy allowance, multiply the total annual income for the low income units in the project by an estimated vacancy rate. The vacancy rate is based upon an analysis of similar projects in the market area.  Subtract the vacancy allowance from the total annual income to determine the effective gross income of the low income units "]
[null," "]
[null,"Residential Rental Income: Market Rate Units.  For all market rate units in the project, show: the number of bedrooms and baths per unit; the number of units of this size and type; the unit size in net leasable square footage; and the contract rent paid by the tenant.  The monthly income is the contract rent multiplied by the number of units of this size and type. Calculate annual income by multiplying the monthly income by 12 months. The total net leasable square footage for all units is the sum of the unit size multiplied by the number of units for each size and type. To calculate the vacancy allowance, multiply the total annual income for the market rate units in the project by an estimated vacancy rate. The vacancy rate is based upon an analysis of similar projects in the market area.  Subtract the vacancy allowance from the total annual income to determine the effective gross income of the market rate units."]
[null," "]
[null,"Tenant Paid Utilities:  If tenants will pay monthly utilities, show the type of utilities by marking the appropriate box."]
[null," "]
[null,"Nonresidential Income: Nonresidential income includes but is not limited to commercial space, parking, laundry facilities and vending machines.  For all nonresidential income in the project, show a description of the income type and/or size; the square footage (if applicable) and the income generated. Calculate annual income by multiplying the monthly income by 12 months. The vacancy allowance is calculated by multiplying the total annual nonresidential income by an estimated vacancy rate that is based upon an analysis of similar projects in the market area.  Subtract the vacancy allowance from the total annual income to determine the effective gross income for nonresidential units."]
[null," "]
[null,"Effective Gross Income:  This is the sum of the effective gross income for all income producing units in the project (low income, market rate) and nonresidential income."]
[null," "]
[null,"Non-Income Producing Units:  For all community and common spaces included in the project, show the number of units (if applicable) and the square footage of each type of space. The total square footage for all units is the sum of the unit size multiplied by the number of units for each size and type.  Manager’s units that will never generate rental income should be included here and should not be included in the number of tax credit units.  "]
[null," "]
[null,"PROJECT EXPENSES"]
[]
[null,"Project Expenses:  Fill in the annual estimated expenses for each type listed that is applicable to the project.  A management fee is calculated by multiplying the Effective Gross Income by an annual percentage rate.  Utility expenses include only those items paid by the owner and should not include tenant paid utilities.  If the local government is providing a Payment in Lieu of Taxes (PILOT) agreement, show the total estimated value of the PILOT, the number of years it will be provided, and the annual payment amount under the agreement."]
[null," "]
[null,"Total Operating Expenses:  This is the sum of total administrative expenses, total utility expenses, total operating and maintenance expenses, total taxes and insurance and reserve for replacement deposits."]
[null," "]
[null,"Net Operating Income:  Calculate the project’s Net Operating Income by subtracting the Total Operating Expenses from the Effective Gross Income for all units."]
[null," "]
[null,"SOURCES OF FUNDS"]
[]
[null,"Debt Service Financing:  For all must pay debt, indicate the type of funds, the name of the bond issuer or lender, loan lien position, the required debt coverage ratio, the total annual payment, the interest rate, the amortization period of the loan, the actual loan term, and the maximum supported loan amount.  Also, show the annual payment associated with any bond insurance premium. For loans receiving credit enhancement, indicate the name of the credit enhancer.  For tax-exempt, 4% LIHTC applications, CDA will initially underwrite the 1st mortgage loan interest rate with a 75-basis point cushion, based on CDA's financial advisor's interest rate guidance.  Refer to calculations on the far right side of the Sources worksheet."]
[null," "]
[null,"Cash Flow Financing and Grants:  For all loans that will be repaid from cash flow, show the type of funds, the name of the lender, loan lien position, and the percentage of cash flow that will be applied to payments due on the loan, the anticipated annual payment, the interest rate, the loan term, and the loan amount. Calculate the maximum loan amount from Rental Housing Funds on the table that follows. Generally, total Rental Housing Fund Program loan(s) [RHP, HOME, and HTF] may not exceed $2.5 million.  A Rental Housing Works loan may not exceed $3.5 million. Generally, Rental Housing Fund and Rental Housing Works loans are expected to be serviced from 75% of available cash flow, see section 4.7.2 of Guide for more information. For grants, show the type of funds, the name of the grantor, the term of the grant (if applicable), and the amount of the grant."]
[null," "]
[null,"Total Debt:  Add the total loan amounts for the cash flow loans and the total maximum mortgage amounts for the debt service financing to determine the total debt.   "]
[null," "]
[null,"Equity:  Indicate the source and amount of equity proceeds generated from the sale of low income and/or historic tax credits.  Also, identify the developer’s equity that is not from syndication proceeds.  Interim income sources must be accompanied with a construction period income and expense budget.  The Department requires that equity from the sale of competitively allocated tax credits be sufficient to cover syndication related costs, guarantees and reserves, developer’s fee and at least 10% of total development costs."]
[null," "]
[null,"Total Sources of Funds:  The total sources of funds are the sum of the total financing and the total equity and must equal the total uses of funds."]
[null," "]
[null,"Maximum Rental Housing Funds and Rental Housing Works Loan Amount:  The maximum Departmental loan amount is calculated on the cost of the project and the amount of gap financing needed.  Subtract the total debt service maximum mortgage amount, HOME financing from non Departmental sources, the amount of any other cash flow loan, historic tax credit syndication proceeds, interim income, Developer Equity, other equity sources, and Low-Income Housing Tax Credit proceeds from the project’s total development costs.   "]
[null," "]
[null,"USES OF FUNDS "]
[]
[null,"Fill in the total estimated amount for each use of funds listed that is applicable to the project.  For applications requesting Low-Income Housing Tax Credits, show the total costs included in the project’s acquisition basis and construction or rehabilitation basis, and those that are not included in the tax credit basis. If you have any questions concerning the costs to be included in the project’s tax credit basis or the Low-Income Housing Tax Credit, please consult your accountant or attorney for more information before submitting an application for funding."]
[null," "]
[null,"Construction or Rehabilitation Costs:  Net construction costs (shown in the Department’s Form 212 – Summary Cost Estimate and Form 215 – Detail Cost Estimate) are construction costs that do not include a builder’s general requirements, builder’s profit, general overhead, bond premium, construction contingency or other fees.  Also indicate the builder’s general requirements, builder’s profit and overhead, as a percentage of net construction costs.  Off-site improvements should not be included as a part of the construction cost; include any off-site improvements under acquisition costs.  For limits on builder’s general requirements, builder’s profit and general overhead refer to the Multifamily Rental Financing Program Guide. Bond premiums include the actual premium paid for performance and payment bonds or the actual cost paid to a lending institution for letters of credit to assure construction completion.  A construction contingency of 5% to 10% of the total construction contract is required to fund unforeseen construction work items.  "]
[null," "]
[null,"Fees Related to Construction and Rehabilitation:  For the architect’s design and supervision fees, show the applicable percentage of the total construction contract. Real Estate Attorney Legal fees directly related to closing the loans are tax credit basis eligible.  Legal fees related to the syndication of tax credits must be included under syndication related costs. For limits on the architect’s design fee and architect’s supervision fee refer to the Multifamily Rental Financing Program Guide."]
[null," "]
[null,"Financing Fees and Charges:  Construction interest is calculated on the funds disbursed during the construction loan period based on a projected monthly draw schedule. Mortgage Insurance Premium is the premium charged for mortgage insurance during the construction loan period only. Title and recording costs are those estimated by the title attorney. A financing (soft cost) contingency may not exceed 2.5% of “Fees Related to Construction or Rehabilitation” and “Financing Fees and Charges”.  Fees due to CDA are detailed in the DHCD Multifamily Program Fees document. The document can be viewed at  "]
[null,"https://dhcd.maryland.gov/HousingDevelopment/Pages/Fees.aspx"]
[]
[null,"Acquisition Costs:  If the site includes existing buildings, allocate the cost between land and buildings.  Generally, there cannot have been any transfer of ownership within the past 10 years for buildings to be eligible for an acquisition tax credit."]
[null," "]
[null,"Total Development Costs:  This is the sum of total construction costs, total fees, total financing fees and charges and total acquisition costs."]
[null," "]
[null,"Maximum Developer’s Fee: The developer’s fee is calculated as a percentage of total development costs. A fee of up to 15% is allowed on the first $10 million of total development costs (less acquisition-related costs construction and soft cost contingencies) and up to 10% on total development costs (less acquisition-related costs and construction and soft cost contingencies) over $10 million.  A fee of up to 10% is allowed on the first $10 million of acquisition-related costs and up to 5% on acquisition-related costs over $10 million. See section 3.9.8.3 of the Guide for more information.  "]
[null," "]
[null,"Syndication Related Costs:  These are costs incurred when syndicating a project with historic tax credits or Low-Income Housing Tax Credits.  Syndication related costs may not be paid with Department loan proceeds.  Generally, these costs are not included in the project’s tax credit basis."]
[null," "]
[null,"Guarantees and Reserves:  Guarantees and reserves should include only funded amounts required by the Department, other lenders or syndication firms and cannot be funded with Department loan proceeds.  Refer to the Multifamily Rental Financing Program Guide for the Department’s requirements for Guarantees and Reserves.  "]
[null," "]
[null,"Total Uses of Funds:  This is the sum of total development costs, developer’s fee, total syndication related costs, and total guarantees and reserves."]
[null," "]
[null,"LOW-INCOME HOUSING TAX CREDIT "]
[]
[null,"Complete this section only if you are applying for a Low-Income Housing Tax Credit from the Department.  If you have any questions concerning this section or the Low Income Housing Tax Credit, please consult your accountant or attorney for more information before submitting an application for funding."]
[null," "]
[null,"Type of Low Income Housing Tax Credit Requested:  Mark each box that applies to the type(s) of tax credit you are requesting.  To be eligible for an acquisition tax credit, the project must also include substantial rehabilitation. The Department’s standard of substantial rehabilitation for threshold review is different than the federal Tax Credit definition.  Refer to the Multifamily Rental Financing Program Guide for the Department’s standard of substantial rehabilitation."]
[null," "]
[null,"Location and Placed-In-Service Information:  If you are requesting an acquisition or rehabilitation tax credit, complete this table for each building in the project.  Show the following information for each building: a specific street address; the type of site control; the date each control document expires; the number of units; the purchase price; the date the building was last placed-in-service; the date the sponsor expects to place the building in service; and the number of years between the sponsor’s anticipated placed-in-service date and the date the building was last placed in service.  Generally, the building must not have been placed in service during the last 10 years to be eligible for an acquisition tax credit.  The total purchase price should be the same as shown for acquisition costs on the Uses of Funds worksheet."]
[null," "]
[null,"Substantial Rehabilitation Determination:  To be eligible for a rehabilitation tax credit, the total costs associated with the rehabilitation must exceed the greater of $7,900 per unit or 20% of the project’s adjusted basis, although the Department requires a minimum of $15,000 per unit in total hard costs.  Check the box that applies to the project."]
[null," "]
[null,"Minimum Set-aside Election:  The sponsor must elect one of the three minimum set-aside elections under the tax credit program.  At least 20% of the units must be occupied by households with income below 50% of the area median, at least 40% of the units must be occupied by households with income below 60% of the area median, or at least 40% of the housing units in the project must be occupied by households with incomes at or below 60% of the area median income so long as the average gross income for the restricted units in the project does not exceed 60% of the area median income.  The overall occupancy restrictions for the project shown on the General Information sheet will be used to calculate the tax credit basis.  Make the election by marking one box only."]
[null," "]
[null,"Rent Floor Election:  Sponsors may elect to establish the rent floor for the project as of the date of allocation or the date the project is placed in service.  Make the election by marking one box only."]
[null," "]
[null,"Syndication Information:  If the project will be syndicated, show the name of the syndication firm, contact person and telephone number, whether the offering is public or private, the type of investors, and the percentage, amount and the dates that funds will be paid into the partnership."]
[null," "]
[null,"Maximum Low-Income Housing Tax Credit Based on Eligible Costs:  This is the amount of tax credit the project is eligible for based on its qualified basis.  The actual amount of tax credit the project receives may be less than the amount for which it is eligible and will be limited to the amount needed for financial feasibility.  Calculate the adjusted project costs by subtracting from the Total Uses of Funds any federal grants financing qualifying costs, other non-qualifying financing, the value of any commercial space in the project, costs associated with any non-qualifying units of higher quality, and any historic tax credit.  The new construction or rehabilitation basis may be increased up to 130% if the project is in a Federally-designated Qualified Census Tract (QCT) or Difficult Development Area (DDA) as published by the U.S. Department of Housing and Urban Development and has a Concerted Revitalization Plan."]
[null,"In addition, any competitive family project located in a Community of Opportunity may also receive up to 130% basis boost. The applicable fraction is the portion of the project that eligible low-income households will occupy. Multiply the eligible basis by the applicable fraction to find the qualified basis.  The applicable percentages are the percentages calculated monthly by the Internal Revenue service based on the present values of the total credits for federally subsidized, acquisition and non-federally subsidized properties. For the applicable percentage on new construction or rehabilitation, enter 4%, if the qualified basis is financed with tax-exempt bonds or other federal subsidy, otherwise, enter 9%.  For the applicable percentage on acquisition costs, enter 4%.  The Low-Income Housing Tax Credit eligible basis is the qualified basis multiplied by the applicable percentage."]
[null," "]
[null,"Estimated Low-Income Housing Tax Credit Syndication Proceeds:  Estimate the syndication proceeds that can be generated from any historic tax credit and the Low-Income Housing Tax Credit. Combine the Low-Income Housing Tax Credits generated by the project’s eligible basis and multiply the total by 10 years to determine the total tax credit received over the period.  Multiply this by the raise ratio from the syndication proposal to determine the gross proceeds generated by the Low-Income Housing Tax Credit.  Add to this the gross proceeds as the result of any historic tax credit for the total equity from syndication proceeds."]
[null," "]
[null,"Maximum Low-Income Housing Tax Credit Based on Proceeds Needed:  This calculates the maximum amount of Low-Income Housing Tax Credit needed for the project.  The proceeds needed are the lesser of the total Equity from Syndication Proceeds or the Financing Gap.  Subtract the gross proceeds of any historic tax credit from the total proceeds needed to determine the proceeds needed from Low-Income Housing Tax Credits.  Divide this by the raise ratio from the syndication proposal to figure the total tax credit received over the tax credit period.  Divide this by the 10-year period to determine the maximum Low-Income Housing Tax Credit requested."]
[null," "]
[null,"Sources of Federal Financing:  Sponsors must disclose the amount of all direct and indirect federal funds that are financing qualified project costs.  Show the federal funds applicable to the project.  If a source of funds is not included, show the amount under other and provide a brief description."]
[null," "]
[null,"Applicable Fraction: The applicable fraction is the portion of the project that eligible low-income households will occupy.  The lesser of the percentage of low-income units to total units or low-income square footage to total square footage determines the applicable fraction."]
[null," "]
[null,"Applicable Percentage:  The percentages generated by the present value calculations are commonly referred to as 4% credits for acquisition or for federally subsidized development or 9% for non-federally subsidized development.   "]
[null," "]
[null,"Historic Tax Credit:  Calculate the gross proceeds from any historic tax credit by multiplying the amount of the historic tax credit by the raise ratio from the syndication proposal."]
[null," "]
[null," "]
[null,"PROJECT SUMMARY INFORMATION "]
[]
[null,"General Information:  Provide the project information, funding applied for, and occupancy restrictions of the project."]
[null," "]
[null,"Project Income:  Indicate total units for the low-income units, market rate units and nonresidential sources from the Project Income worksheet.  The Potential Gross Income will automatically populate based on the information entered in the Project Income worksheet.  Fill in the number of years until sustaining occupancy; the years until sustaining occupancy are the number of years between the application submission date and the estimated date of sustaining occupancy shown in the anticipated development schedule. For the annual trending, fill in the estimated annual increase in rents.  The trend can be based upon experience with similar projects or determined in the market study.  The trended income (at the time of sustaining occupancy) will be calculated by multiplying the annual income by the sum of the years until sustaining occupancy and annual trending rate and adding this result to the annual income. The vacancy allowance is the sum of the trended income multiplied by the vacancy rate for each unit type.  These figures will automatically populate the 20-Year Operating Pro Forma in the next worksheet."]
[null," "]
[null,"Project Expenses and Cash Flow:  The annual expense for each project expense category will automatically populate based on the information entered in the Project Expenses worksheet.  For administrative, utility, operating maintenance, taxes and insurance, and reserve for replacement, indicate the number of years until sustaining occupancy and the annual trending rate.  The management fee is not trended but is always a percentage of effective gross income.  The other expenses will be trended by multiplying the annual expense by the sum of the years until sustaining occupancy and annual trending rate and adding this result to the annual expenses."]
[null," "]
[null,"Sources and Uses of Funds:  The summary information will be drawn from information you completed on the Sources of Funds and Uses of Funds worksheets."]
[null," "]
[]
[]
[]
[]
[]
[null,"20-YEAR OPERATING PRO FORMA"]
[]
[null,"Income:  The trended income will automatically populate based on the information entered in the Project Summary Worksheet.  Each year after that, the annual income for the low income, market rate and nonresidential units should be trended forward by the rate shown in the Project Summary Information worksheet.  Income is trended annually by multiplying the previous year’s income by the trending rate and adding it to the previous year’s annual income.  The vacancy allowance is the sum of the vacancy rate times the gross income for each type of income."]
[null," "]
[null,"Expenses:  The trended expenses will automatically populate based on the information entered in the Project Summary Worksheet. The management fee is not to be trended.  Other expenses are trended annually by multiplying the previous year’s expenses by the trending rate and adding it to the previous year’s expenses.   The trended net operating income is calculated by subtracting the trended expenses from the trended effective gross income."]
[null," "]
[null,"Debt Service Financing:  Annual debt service payments are entered for each year from the Debt Service Financing table in the Project Summary Information section. The debt coverage ratio is calculated by dividing the net operating income by the total debt service payments."]
[null," "]
[null,"Cash Flow Financing:  Annual cash flow payments are calculated for each year by multiplying the cash flow by the Percentage of Cash Flow for Payment shown in the cash flow financing table in the Project Summary Information worksheet.  The remaining cash flow is calculated by deducting debt service and cash flow payments from the trended net operating income. The debt coverage ratio is calculated by dividing the net operating income by the sum of the total debt service payments and the total cash flow debt payments."]
[]
[null,"Cash Flow Financing:  Enter annual cash flow amount (or percent of cash flow distribution) based on the Standard Surplus Cash Repayment Terms (refer to the Multifamily Rental Financing Program Guide 3.7.2) or the Contingent Interest Surplus Cash Repayment Terms (refer to the Multifamily Rental Financing Program Guide 3.7.3)"]
[]
[null,"Leveraging & Cost Effectiveness:  Twin projects will submit a 202 for the 9% component and the 4% component.   Data is keyed into the tan colored cells.  The blue color cells are calculated by formulae.   "]

{"sheet":"VISUALS (Examples)","index":1,"n_rows":46,"n_cols":50,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SAMPLE - Complete Visials (less Photos)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE - Site Plans",null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE - Renderings",null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLE - Floor Plan"]

{"sheet":"GENERAL","index":2,"n_rows":204,"n_cols":14,"rows_kept":204,"cut":false,"hidden":false,"merged":[[177,5,177,6],[176,5,176,6],[183,3,185,10],[103,2,105,3],[144,8,145,11],[138,10,138,11],[142,2,142,3],[139,2,139,3],[140,2,140,3],[140,6,140,8],[140,10,140,11],[127,6,133,6],[13,11,15,11],[108,7,109,9],[139,10,139,11],[108,10,109,10],[139,6,139,8],[138,6,138,8],[69,2,76,11],[61,10,62,10],[61,11,62,11],[1,3,2,10],[25,2,25,3],[26,2,26,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[8,5,8,7],[13,9,15,10],[24,2,24,3],[27,2,27,3],[28,2,28,3]]}
[]
[null,null,null,"MULTIFAMILY RENTAL FINANCING APPLICATION",null,null,null,null,null,null,null,"FORM"]
[null,null,null,null,null,null,null,null,null,null,null,202]
[null,null,null,null,null,null,null,null,null,null,null,"Effective Date: 12/05/2023"]
[null,null,"GENERAL INFORMATION",null,null,null,null,null,null,null,null,null,null,"Non-LIHTC Project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"9% Project"]
[null,null,"Date","2023-12-15",null,"(Enter Application Submission Date)",null,null,null,null,null,null,null,"9% Twinning Project"]
[null,null,null,{"$f":"IF(D7=TODAY(),\"Enter an application submission ''date'' NOT the =(TODAY()) formula\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"4% Project"]
[null,null,"Application Type: (choose)",null,null,"9% Project",null,null,null,null,null,null,null,"4% Twinning Project"]
[]
[null,null,"Stage of Processing  (choose one)",null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"X","  Application for Submission",null,null,"  Commitment Review Submission",null,null,null,"Type of Credit Enhancement: (choose) "]
[null,null,null,"  Viability Review Submission",null,null,"  Viability/Commitment Review Submission"]
[null,null,null,null,null,null,null,null,null,"Basis Boost Documentation                            (if applicable)                      (Choose one)",null,"9%   Family   Project       in a COO"]
[]
[]
[null,null,"Funding Applied For"]
[null,null,"Low Income Housing Tax Credit",null,null,{"$f":"+'TAX CREDIT'!J91","v":0},null,null,null,{"$f":"IF(F9=\"4% Project\",SUM('TAX CREDIT'!I73:K73),IF(F9=\"4% Twinning Project\",SUM('TAX CREDIT'!I73:K73),0))","v":0},"Basis",null,null,"FTEL"]
[null,null,"Multifamily Bonds (taxable)",null,null,{"$f":"+SOURCES!M12","v":0},null,null,null,{"$f":"IF(GENERAL!$F$9=\"4% Project\",USES!J85,IF(GENERAL!$F$9=\"4% Twinning Project\",USES!J85,0))","v":0},"Land",null,null,"Risk Sharing"]
[null,null,"Multifamily Bonds (long term tax-exempt) ",null,null,{"$f":"+SOURCES!M13","v":0},null,null,null,{"$f":"SUM(J18:J19)","v":0},null,null,null,"FHA 221(d)(4)"]
[null,null,"Multifamily Bonds (short term tax-exempt) ",null,null,{"$f":"+SOURCES!M24","v":0},null,null,null,0.53,null,null,null,"L-T GNMA"]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING((J20*J21),5000)","v":0},"T-E Loan Required for 50% Test",null,null,"MTEB"]
[null,null,"DHCD Subordinate Financing",null,null,null,null,"  Assumed DHCD Debt?"]
[null,null,{"$f":"SOURCES!C28","v":"Rental Housing Program Funds"},null,null,{"$f":"+SOURCES!M28","v":0}]
[null,null,{"$f":"SOURCES!C29","v":"Rental Housing Works"},null,null,{"$f":"+SOURCES!M29","v":0}]
[null,null,{"$f":"SOURCES!C30","v":"Housing Trust Funds"},null,null,{"$f":"+SOURCES!M30","v":0}]
[null,null,{"$f":"SOURCES!C31","v":"HOME Funds"},null,null,{"$f":"+SOURCES!M31","v":0}]
[null,null,{"$f":"SOURCES!C32","v":"Multifamily Capital Fund"},null,null,{"$f":"+SOURCES!M32","v":0}]
[null,null,{"$f":"SOURCES!C33","v":"HOME ARP"},null,null,{"$f":"+SOURCES!M33","v":0}]
[null,null,{"$f":"SOURCES!C34","v":"Partnership Rental Housing Program Funds"},null,null,{"$f":"+SOURCES!M34","v":0}]
[null,null,{"$f":"SOURCES!C35","v":"Weinberg"},null,null,{"$f":"+SOURCES!M35","v":0}]
[null,null,"Other:"]
[]
[null,null,"PROJECT NAME AND LOCATION"]
[]
[null,null,"Project Name"]
[null,null,"Complete Mailing Address"]
[null,null,"If no street address indicate lot",null,null,null,null,null,"Parcel",null,"Tax Map"]
[null,null,"City",null,null,null,null,null,"County"]
[null,null,"Zip Code",null,null,null,null,null,"Census Tract"]
[null,null,"Congressional District",null,null,null,null,null,"Legislative District"]
[null,null,null,null,null,null,null,null,"Existing HUD Project No.",null,"(if applicable)"]
[null,null,"APPLICANT INFORMATION"]
[]
[null,null,"Applicant Name"]
[null,null,"Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,null,"E-mail"]
[]
[]
[null,null,"OWNERSHIP ENTITY INFORMATION"]
[]
[null,null,"Owner/Borrower Name"]
[null,null,"Taxpayer ID"]
[]
[null,null,"Type of Ownership  (mark one box only)"]
[null,null,null,"  Individual",null,null,"  General Partnership",null,null,"  Local Government"]
[null,null,null,"  Corporation",null,"X","  Limited Partnership",null,null,"  Other:","Describe"]
[null,null,null,"  Limited Liability Corporation"]
[]
[null,null,"Principals (complete information for corporations and controlling general partners)"]
[null,null,null,null,null,null,null,null,null,null,"Ownership Interest","Nonprofit"]
[null,null,"Name",null,null,null,null,"Taxpayer ID",null,"GP/LP"]
[null,null,null,null,null,null,null,null,null," GP",null,"Yes"]
[null,null,null,null,null,null,null,null,null," Administrative GP",null,"No"]
[null,null,null,null,null,null,null,null,null," LP",null,"No"]
[]
[]
[null,null,"PROJECT DESCRIPTION (This section should NOT be left blank)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PROJECT INFORMATION"]
[]
[null,null,"Amenities (indicate all that apply)"]
[null,null,null,"  Cable Access",null,null,"  Laundry Facilities"]
[null,null,null,"  Transportation Services",null,null,"  Washer/Dryer Hook-up"]
[null,null,null,"  Carpet",null,null,"  High Speed Internet Access"]
[null,null,null,"  Dishwasher",null,null,"  Other:","Describe"]
[null,null,null,"  Disposal",null,null,"  Other:","Describe"]
[null,null,null,"  Microwave",null,null,"  Other:","Describe"]
[]
[]
[null,null,"Type of Project (indicate all that apply)",null,null,"Type of Project (indicate all that apply)"]
[null,null,null,"  Acquisition of Existing Building(s)",null,null,"  New Construction"]
[null,null,null,"  Refinance",null,null,"  Rehabilitation"]
[]
[]
[null,null,"Unit Types - NC and/or Rehab  (indicate all that apply)",null,null,null,null,"UFAS Units  (indicate number of units and AMI)"]
[null,null,null,"  New Construction",null,null,null,null,"Units","AMI"]
[null,null,0,"  Rehabilitation",null,null,null,"UFAS 1 BR ",null,0.6]
[null,null,null,null,null,null,null,"UFAS 2 BR ",null,0.6]
[null,null,null,null,null,null,null,"UFAS 3 BR ",null,0.6]
[null,null,null,null,null,null,null,"UFAS 4+ BR "]
[]
[null,null,"Related Party Transaction  (indicate appropriate choice)",null,null,null,null,null,{"$f":"ROUNDUP(F133*5%,0)","v":0},"Minimum UFAS Units = 5% of Total Units"]
[null,null,"A transaction between parties where familial, business, controlling interests, or other close ties exist prior to the transaction, as defined in Section 3.9.8.1  of the Guide.",null,null,null,null,null,{"$f":"ROUNDUP(F133*2%,0)","v":0},"Minimum Visual/Hearing Impaired Units = 2% of Total Units"]
[]
[]
[]
[null,null,"Existing Building Information (complete all that apply)",null,null,null,null,"Developer Fee Funded Services / Rent Subsidy /Reserve"]
[null,null,"Percentage currently occupied",null,null,0,null,"Developer Fee Funded Supportive Services / Rent Subsidy/Sponsor Note Reserve?"]
[null,null,"Project includes historic rehabilitation?"]
[null,null,"Project involves the permanent relocation of tenants?"]
[null,null,"Project involves the temporary relocation of tenants?"]
[]
[null,null,"Year the building(s) were built",null,null,null,null,"Year the building(s) were built",null,null,"Year the building(s) were built"]
[]
[null,null,"Number of Residential Buildings  (complete all that apply)",null,null,null,null,"Total Land Area (acres)"]
[null,null,"Garden (walk-up)"]
[null,null,"Townhouse",null,null,null,null,"Total Building Area (gross square footage)"]
[null,null,"Cottage, single-family, or semi-detached",null,null,null,null,"Residential Units: Low-Income"]
[null,null,"Elevator (≤ 4 floors w/frame construction)",null,null,null,null,"Residential Units: Market"]
[null,null,"Elevator (≥ 5 floors w/concrete construction)",null,null,null,null,"Nonresidential Units and Staff Units"]
[null,null,"Units Stacked- no elevator",null,null,null,null,"Commercial  Space:",null," Describe"]
[]
[null,null,"Total Buildings",null,null,{"$f":"SUM(F117:F122)","v":0},null,"Common Space:"]
[null,null,null,null,null,null,null,"   Circulation (hallways, stairways etc.)"]
[null,null,null,null,null,null,null,"   Recreation"]
[null,null,"Type of Occupancy  indicate number of units)",null,null,null,null,"    Other:  "," Describe"]
[null,null,"Families",null,null,null,{"$f":"IF(SUM(C97:C98)=$F133,\"\",\"Revise to equal number of units indicated  in ''Unit Types - NC and/or Rehab'' entered above\")","v":""},"    Other:  "," Describe"]
[null,null,"General Occupancy",null,null,null,null,"    Other:  "," Describe"]
[null,null,"Elderly (See Guide, Section 3.2.2)",null,null,0,null,"    Other:  "," Describe"]
[null,null,"Special Needs or Alternative Housing",null,null,null,null,"    Other:  "," Describe"]
[]
[null,null,"Total Residential Units",null,null,{"$f":"SUM(F128:F131)","v":0},null,"Total Gross Square Footage",null,null,{"$f":"SUM(K119:K131)","v":0}]
[null,null,null,null,null,{"$f":"IF(SUM($I98:$I101)>=$I103,\"\",\"Revise UFAS units to equal minimum number of required UFAS Units\")","v":""}]
[null,null,"Commercial Unit(s)"]
[]
[]
[null,null,"Housing for Targeted Populations at or below 30% AMI (See Guide, Section 4.4.2)"]
[null,null,null,null,null,"Units","Targeted Population",null,null,"Units","Targeted Population"]
[null,null,"Target Population(s):                                                (choose population and enter number of units)",null,null,null,"Homeless ",null,null,null,null,null,null,"PWDs – nonelderly"]
[null,null,"Target Population(s):                                                (choose population and enter number of units)",null,null,null,"Homeless ",null,null,null,null,null,null,"PWD – elderly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeless "]
[null,null,"Total Housing Units for Targeted Populations at or below 30% AMI *",null,null,{"$f":"F140+F141+J140+J141","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Youth Aging Out of Foster Care"]
[null,null,null,null,null,null,null,null,"* (Enter specific subsidy information in the Rental Subsidy column in the Project Income tab)"]
[null,null,"Units with Project Based Rental Subsidy (i.e., Section 8, 236, etc.)  *"]
[]
[]
[null,null,"Occupancy Restrictions of Project  (Indicate number of units)"]
[null,null,"Units to be occupied by households with income 20% or less of the area median"]
[]
[null,null,"Units to be occupied by households with income 21-30% of the area median"]
[]
[null,null,"Units to be occupied by households with income at 31-40% of the area median"]
[]
[null,null,"Units to be occupied by households with income at 41-50% of the area median"]
[]
[null,null,"Units to be occupied by households with income at 51-60% of the area median"]
[]
[null,null,"Units to be occupied by households with income at 61-70% of the area median"]
[]
[null,null,"Units to be occupied by households with income at 71-80% of the area median"]
[]
[null,null,"Units to be occupied by households with no income restrictions"]
[]
[null,null,"Staff Residential Unit(s) * ",null,null,null,null,0,"  * (Enter in Project Income tab as Market Rate Units or "]
[]
[null,null,"Total Units",null,null,null,null,{"$f":"SUM(H150:H166)","v":0},"Non-Income Producing Units)"]
[null,null,null,null,null,null,null,{"$f":"IF($H168=$F133,\"\",\"Revise to equal ''Total Residential Units'' above\")","v":""}]
[null,null,"Long Term Use Restrictions and Homeownership Opportunities (See Guide, Section 3.2.3)"]
[null,null,"Is this a structured Year-15 transition to homeownership program?   (choose) "]
[]
[]
[null,null,"ANTICIPATED DEVELOPMENT SCHEDULE (See Guide, Section 3.11)"]
[null,null,"Activity"]
[null,null,"Site Control"]
[null,null,null,"Does the sponsor have site control?",null,null,null,null,null,null,null,null,null,"Deed"]
[null,null,null,"Type of site control?",null,null,null,null,null," Identity of interest between the seller and sponsor/applicant?",null,null,null,"Long Term Lease"]
[null,null,null,"Date site control expires   (each site)",null,null,null,null,null,null,null," No. of extensions",null,"Option"]
[null,null,null,"Date site will be acquired by the ownership entity",null,null,null,null,null," Contract extension period (in days) ",null,null,null,"Purchase Contract"]
[null,null,"Zoning Status",null,null,null,null,null,null,null,{"$f":"IF($G179<=($D7+180),\"\",\"Provide number of and length of contract extensions\")","v":""}]
[null,null,null,"Current Zoning Classification"]
[null,null,null,"Describe Current Classification"]
[]
[]
[]
[null,null,null,"Zoning change, variance or waiver required?  (choose)",null,null,null,null,null,null,null,"Enter: (MM//DD/YY) "]
[null,null,null,"Date application for zoning change, variance or waiver filed"]
[null,null,null,"Date of final hearing on zoning change, variance or waiver"]
[null,null,null,"Date of final approval of zoning change, variance or waiver"]
[null,null,"Date of local planning approval"]
[null,null,"Date financing applications filed with other lenders (public and private)"]
[null,null,"Date firm commitments received from other lenders (public and private)"]
[null,null,"Date final plans and specifications completed"]
[null,null,"Date 10% of project costs incurred (No later than 12 months from carryover allocation.)"]
[null,null,"Date evidence will be provided that 10% of project costs have been incurred"]
[null,null,"Date of construction loan closing"]
[null,null,"Date construction or rehabilitation begins ",null,null,null,null,"The total Construction Period will be",{"$f":"(L200-L198)/30","v":0},"months"]
[null,null,"Date 50% of construction or rehabilitation completed"]
[null,null,"Date of substantial completion of construction or rehabilitation"]
[null,null,"Date first certificate of occupancy received"]
[null,null,"Date final certificate of occupancy received"]
[null,null,"Date sustaining occupancy achieved"]
[null,null,"Date of permanent loan closing",null,null,null,null,"Construction Loan Period",{"$f":"(L204-L198)/30+4","v":4},"months"]

{"sheet":"DEV TEAM","index":3,"n_rows":157,"n_cols":12,"rows_kept":157,"cut":false,"hidden":false,"merged":[[113,4,113,5],[10,4,10,5],[16,4,16,5],[40,4,40,5],[46,4,46,5],[52,4,52,5],[111,9,111,10],[74,9,74,10],[26,9,26,10],[22,4,22,5],[28,4,28,5],[34,4,34,5],[58,4,58,5],[64,4,64,5],[70,4,70,5],[76,4,76,5],[83,4,83,5],[89,4,89,5],[95,4,95,5],[101,4,101,5],[107,4,107,5],[81,9,81,10],[87,9,87,10],[93,9,93,10],[99,9,99,10],[105,9,105,10],[44,9,44,10],[50,9,50,10],[68,9,68,10],[62,9,62,10],[56,9,56,10],[20,9,20,10],[14,9,14,10],[8,9,8,10],[32,9,32,10],[38,9,38,10],[148,2,150,11],[153,2,155,11],[152,2,152,10],[117,2,117,10],[132,2,132,10],[147,2,147,10],[122,2,122,10],[142,2,142,10],[127,2,127,10],[137,2,137,10],[118,2,120,11],[123,2,125,11],[128,2,130,11],[138,2,140,11],[133,2,135,11],[143,2,145,11]]}
[]
[null,null,"DEVELOPMENT TEAM INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"DEVELOPMENT TEAM MEMBERS"]
[null,null,"Developer"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Developer"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Guarantor"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Guarantor"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"General Contractor",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Management Agent",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Consultant",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Architect",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Nonprofit Participant",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"MBE/WBE Participant",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Real Estate Attorney",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Tax Attorney",null,null,null,null,null,null,null,"Related Entity? "]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"LENDING AND INVESTMENT PARTNERS"]
[null,null,"Private/Public Lender"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Private/Public Lender"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Private/Public Lender"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"LIHTC Equity Provider"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"Federal Historic Equity Provider"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"State Historic Equity Provider"]
[null,null,"Enter Complete Mailing Address"]
[null,null,"Contact",null,null,null,null,null,"Phone"]
[null,null,"Title",null,null,null,null,null,"E-mail"]
[null,null,"D&B Duns Number"]
[]
[null,null,"DEVELOPMENT TEAM HISTORY"]
[]
[null,null,"Are there direct or indirect identity of interests, financial or otherwise, among any members of the development team? If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Has any development team member* participated  as owner or manager in the development or operation of a project that has defaulted on a Department or other government or private sector loan in the previous five years?   If yes, explain. Please list the names and dates of projects in question. ",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Has any development team member* consistently failed to provide documentation required by the Department in connection with other loan applications or the management and operation of other, existing developments? If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Does any development team member* have a limited denial of participation from HUD or is any development team member* debarred, suspended or voluntarily excluded from participation in any federal or state program, or have been involuntarily removed within the previous 5 years as a general partner or managing member from any affordable housing project whether or not financed or subsidized by the programs of this Department?  If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Does any development team member* acting in the roles of sponsor, developer, guarantor or owner have any chronic past due accounts, substantial liens or judgments, three or more instances of unpaid taxes (even if cured prior to the application date), foreclosures or bankruptcies, or deeds in lieu of foreclosure within the past five years? If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Has any development team member* acting in the roles of sponsor, developer, guarantor or owner been involved with any project placed on the Department's defaulted loans watch list due to actions that are attributable to the sponsor or development team? If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Has any development team member* received a reservation, allocation or commitment of funding or a carryover allocation of tax credits from the Department within the last four years that it was unable to use, or place their project in service within the time allowed by the tax credit program?  If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,"Does any development team member* have unpaid fees, loan arrearages or other obligations due to the Department on other projects, or for general partners or management agents, have tax credit compliance problems resulting in the issuance of an IRS Form 8823 and that are still outstanding in the following year?  If yes, explain.",null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[null,null,"* Refer to the Multifamily Rental Financing Program Guide for a definition of development team members."]

{"sheet":"INCOME","index":4,"n_rows":83,"n_cols":17,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PROJECT INCOME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"RESIDENTIAL RENTAL INCOME"]
[]
[null,null,"Low-Income Units"]
[null,null,null,"Unit Description",null,null,"Unit Size"]
[null,null,"Median Income","Bedrooms","Baths","Number of Units ","(Net leasable Sq. Ft.)","Tenant Utilities*","\"Resident Paid\" Rent","Rent Subsidy","Rent Subsidy Source","Income       Per Unit","Monthly Income","Annual Income",null,null,"Rent Subsidy?"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(I11:J11)","v":0},{"$f":"F11*L11","v":0},{"$f":"M11*12","v":0},null,null,"Rental Assistance Demonstration (RAD) or other PHA conversion to "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(I12:J12)","v":0},{"$f":"SUM(F12*L12)","v":0},{"$f":"+SUM(M12*12)","v":0},null,null,"based rental assistance. "]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"+SUM(M13*12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"Section 8 New Construction Substantial Rehabilitation"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(I16:J16)","v":0},{"$f":"SUM(F16*L16)","v":0},{"$f":"+SUM(M16*12)","v":0},null,null,"Section 8 Moderate Rehabilitation"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"Section 8 Certificates"]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(F19*L19)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"Section 8 Project Based Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"RD 515 Rental Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"Section 8 Vouchers"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"*Administering Organization:"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(I27:J27)","v":0},{"$f":"SUM(F27*L27)","v":0},{"$f":"+SUM(M27*12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"State Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,"*Administering Organization:"]
[null,null,null,"Total LIHTC",null,{"$f":"SUM(F11:F31)","v":0},{"$f":"SUMPRODUCT((F11:F31),(G11:G31))","v":0},null,null,null,null,null,{"$f":"+SUM(M11:M31)","v":0},{"$f":"0+SUM(N11:N31)","v":0}]
[null,null,null,"Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,7.0000000000000007E-2,null,null,null,null,{"$f":"-(I33*N32)","v":0},null,null,"Other:"]
[null,null,null,"Effective Gross Income/Low Income Units (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N32+N33)","v":0}]
[]
[null,null,"Market Rate Units"]
[null,null,"Unit Description",null,null,"Unit Size"]
[null,null,"Bedrooms","Baths","Number of Units ","(Net Leasable Sq. Ft.)","Resident Paid Rent","Monthly Income","Annual Income"]
[null,null,null,null,null,null,null,{"$f":"+SUM(E39*G39)","v":0},{"$f":"H39*12","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,"Total Market Rate",null,{"$f":"SUM(E39:E49)","v":0},{"$f":"SUMPRODUCT((E39:E49),(F39:F49))","v":0},null,{"$f":"SUM(H39:H49)","v":0},{"$f":"0+SUM(I39:I49)","v":0}]
[]
[null,null,"Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,null,{"$f":"-(G52*I50)","v":0}]
[null,null,"Effective Gross Income/Market Rate Units",null,null,null,null,null,{"$f":"I50+I52","v":0},"(Total Annual Income - Vacancy Allowance)"]
[null,null,"* Tenant Paid Utilities (mark all utilities to be paid by tenants)"]
[null,null,"Yes","  Household Electric",null,"Describe",null,null,null,"Yes","  Cooking ","Describe"]
[null,null,"Yes","  Air Conditioning",null,"Describe",null,null,null,"Yes","  Heat:","Describe"]
[null,null,"Yes","  Hot Water",null,"Describe",null,null,null,"Yes","  Other:","Describe"]
[]
[null,null,"NONRESIDENTIAL INCOME"]
[]
[null,null,"Description of Type and Size",null,null,null,null,null,"Square footage","Monthly Income",null,null,null,"Annual Income"]
[null,null,"Misc. Income",null,"Describe",null,null,null,null,null,null,null,null,{"$f":"J62*12","v":0}]
[null,null,"Misc. Income",null,"Describe",null,null,null,null,null,null,null,null,{"$f":"J63*12","v":0}]
[null,null,"Other:",null,"Describe",null,null,null,null,null,null,null,null,{"$f":"J64*12","v":0}]
[null,null,"Other:",null,"Describe",null,null,null,null,null,null,null,null,{"$f":"J65*12","v":0}]
[null,null,"Commercial Income",null,"Describe",null,null,null,null,null,null,null,null,{"$f":"J66*12","v":0}]
[null,null,"Total Nonresidential",null,null,null,null,null,{"$f":"SUM(I62:I66)","v":0},{"$f":"+SUM(J62:J66)","v":0},null,null,null,{"$f":"SUM(N62:N66)","v":0}]
[]
[null,null,"Vacancy Allowance - Nonresidential (Total Annual Income x Vacancy Rate)",null,null,null,null,null,null,null,null,null,null,{"$f":"-(I69*(N67-N66))","v":0}]
[]
[null,null,"Vacancy Allowance - Commercial Income (Total Annual Income x Vacancy Rate)",null,null,null,null,null,null,null,null,null,null,{"$f":"-(I71*N66)","v":0}]
[null,null,"Effective Gross Income/Nonresidential Space (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,null,{"$f":"N67+SUM(N69:N71)","v":0}]
[null,null,"Effective Gross Income (sum Low Income, Market Rate, Nonresidential totals)",null,null,null,null,null,null,null,null,null,null,{"$f":"N34+I53+N72","v":0}]
[]
[null,null,"NON-INCOME PRODUCING UNITS (including management units, tenant services units, recreation, etc.)"]
[]
[null,null,"Description of Type and Size",null,null,null,null,null,"Number of Units","Square Footage"]
[null,null,"Describe"]
[null,null,"Describe"]
[null,null,"Describe"]
[null,null,"Describe"]
[null,null,"Describe"]
[null,null,"Total Non-income",null,null,null,null,null,{"$f":"SUM(I78:I82)","v":0},{"$f":"SUMPRODUCT((I78:I82),(J78:J82))","v":0}]

{"sheet":"EXPENSES","index":5,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PROJECT EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"ADMINISTRATIVE EXPENSES"]
[]
[null,null,"Advertising and Marketing"]
[null,null,"Other Administrative Expense",null,null,"Describe"]
[null,null,"Office Salaries"]
[null,null,"Office Supplies"]
[null,null,"Office or Model Apartment Rent"]
[null,null,"Management Fee",null,null,null," (Effective Gross Income x Annual Rate of ",null,")",null,{"$f":"H13*INCOME!N73","v":0}]
[null,null,"Manager or Superintendent Rent Free Unit"]
[null,null,"Legal Expenses (project only)"]
[null,null,"Auditing Expenses (project only)"]
[null,null,"Bookkeeping Fees and Accounting Services"]
[null,null,"Telephone and Answering Services"]
[null,null,"Bad Debts"]
[null,null,"Miscellaneous Administrative Expenses",null,null,null,"Describe"]
[null,null,"Annual Tax Credit Compliance Monitoring Fee ($35.00 per tax credit unit)",null,null,null,null,null,{"$f":"INCOME!F32*35","v":0},null,{"$f":"INCOME!F32*35","v":0}]
[null,null,"Total Administrative Expenses",null,null,null,null,null,null,null,{"$f":"+SUM(K8:K21)","v":0}]
[]
[null,null,"UTILITY EXPENSES (paid by owner)"]
[]
[null,null,"Fuel Oil"]
[null,null,"Electricity"]
[null,null,"Gas"]
[null,null,"Water"]
[null,null,"Sewer"]
[null,null,"Total Utility Expenses",null,null,null,null,null,null,null,{"$f":"+SUM(K26:K30)","v":0}]
[]
[null,null,"OPERATING AND MAINTENANCE EXPENSES"]
[]
[null,null,"Janitor and Cleaning Payroll"]
[null,null,"Janitor and Cleaning Supplies"]
[null,null,"Janitor and Cleaning Contract"]
[null,null,"Exterminating Payroll or Contract"]
[null,null,"Exterminating Supplies"]
[null,null,"Garbage and Trash Removal"]
[null,null,"Security Payroll or Contract"]
[null,null,"Grounds Payroll"]
[null,null,"Grounds Supplies"]
[null,null,"Grounds Contract"]
[null,null,"Repairs Payroll"]
[null,null,"Repairs Material"]
[null,null,"Repairs Contract"]
[null,null,"Elevator Maintenance or Contract"]
[null,null,"Heating and Air Conditioning Maintenance or Contract"]
[null,null,"Swimming Pool Maintenance or Contract"]
[null,null,"Snow Removal"]
[null,null,"Decorating Payroll or Contract"]
[null,null,"Decorating Supplies"]
[null,null,"Other Operating and Maintenance Expenses",null,null,null,"Describe"]
[null,null,"Miscellaneous Operating and Maintenance Expenses"]
[null,null,"Total Operating and Maintenance Expenses",null,null,null,null,null,null,null,{"$f":"+SUM(K35:K55)","v":0}]
[]
[null,null,"TAXES AND INSURANCE"]
[]
[null,null,"Real Estate Taxes",null,null,null,null,null,null,null,"$"]
[null,null,"Payment in Lieu of Real Estate Taxes",null,null,"Total: ",null,"Years: ",null,"Annual: "]
[null,null,"Payroll Taxes (FICA)"]
[null,null,"Miscellaneous Taxes, Licenses and Permits"]
[null,null,"Property and Liability Insurance (hazard)"]
[null,null,"Fidelity Bond Insurance"]
[null,null,"Workmen's Compensation"]
[null,null,"Health Insurance and Other Employee Benefits"]
[null,null,"Other Insurance ",null,null,"Describe"]
[null,null,"Total Taxes and Insurance",null,null,null,null,null,null,null,{"$f":"+SUM(K60:K68)","v":0}]
[]
[null,null,"Reserve for Replacement",null,null,null,null,{"$f":"K71/GENERAL!F133","v":{"$error":"#DIV/0!"}},"Per unit"]
[null,null,null,null,null,null,null,{"$f":"K71/12","v":0},"Per month"]
[null,null,"Total Operating Expenses",null,null,null,null,null,null,null,{"$f":"+K22+K31+K56+K69+K71","v":0}]
[null,null,"Net Operating Income (Effective Gross Income - Total Operating Expenses)",null,null,null,null,null,null,null,{"$f":"INCOME!N73-EXPENSES!K73","v":0}]
[]
[null,null,"Per Unit Operating Expenses less Reserve for Replacement",null,null,null,null,null,null,null,{"$f":"IF(GENERAL!F133=\"\",\"$\",((K73-K71)/GENERAL!F133))","v":"$"}]

{"sheet":"SOURCES","index":6,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":false,"merged":[[27,7,32,7],[10,14,10,15],[52,9,52,11],[10,17,10,19],[15,17,15,18],[15,14,15,15],[20,9,20,12],[33,8,33,10],[34,8,34,10]]}
[]
[]
[null,null,"SOURCES OF FUNDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"DEBT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://dhcd.maryland.gov/HousingDevelopment/Documents/mbp/Comparison-Financings.pdf"]
[]
[null,null,"Debt Service Financing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate Guidance as of:","[Enter Date]","[Enter Rate]"]
[]
[null,null,"Type of Funds",null,null,"Source of Funds","Lien Position *","Required Debt Coverage","Annual Payment","Interest Rate","Amortization Term","Loan Term","Loan Amount",null,"1st Mortgage",null,null,"Revised  1st  Mortgage"]
[null,null,"Taxable Bonds",null,null,null,"_",null,null,null,null,null,null,null,"Rate",null,null,{"$f":"IF(T9=\"[Enter Rate]\",0,T9)","v":0},{"$f":"R12+0.75%","v":7.4999999999999997E-3},"Rate w/ 75bp"]
[null,null,"Tax-exempt Bonds (Long Term Only) ",null,null,{"$f":"GENERAL!L12","v":0},"_",null,null,null,null,null,null,null,"Amortization",40,null,"Amortization",{"$f":"P13","v":40},"cushion"]
[null,null,"Private Loan",null,null,"Enter Entity Name","_",null,null,null,null,null,null,null,"Proposed 1st Mortgage",null,null,"New Loan =",{"$f":"P14-0","v":0},"1st  Mtg Gap"]
[null,null,"FHA MIP",null,null,null,null,null,{"$f":"P20","v":0},2.5000000000000001E-3,null,null,null,null,"Annual Payment",{"$f":"-PMT(P12/12,P13*12,P14)*12","v":0},null,"Annual Payment",{"$f":"-PMT(S12/12,S13*12,S14)*12","v":0},{"$f":"IF((P14-S14)<0,0,(P14-S14))","v":0}]
[null,null,"Rental Housing Program Funds",null," (Must pay debt)","Maryland DHCD","_",null,null,null,null,null,null,null,"MIP  (if Applicable)",null,null,"MIP  (if Applicable)"]
[null,null,"HOME ",null," (Must pay debt)","Maryland DHCD","_",null,null,null,null,null,null,null,"Rate",{"$f":"0.25%*0","v":0},null,"Rate",{"$f":"P17","v":0}]
[null,null,"HOME (non-DHCD)",null," (Must pay debt)","Enter Entity Name","_",null,null,null,null,null,null,null,"Amount",{"$f":"P14","v":0},null,"Amount",{"$f":"S14","v":0}]
[null,null,"Other:","Describe",null,"Enter Entity Name"]
[null,null,"Other:","Describe",null,"Enter Entity Name",null,null,null,null,null,null,null,null,"MIP Payment",{"$f":"P17*P18","v":0},null,"MIP Payment",{"$f":"S17*S18","v":0}]
[null,null,"Credit Enhancement",null,"Describe",null,null,null,null,"",null,null,null,null,"Total Payment",{"$f":"P15+P20","v":0},null,"Total Payment",{"$f":"S15+S20","v":0}]
[null,null,"Total Debt Service Financing",null,null,null,null,null,{"$f":"SUM(I12:I21)","v":0},null,null,null,{"$f":"+SUM(M12:M20)","v":0},null,"NOI",{"$f":"'PRO FORMA'!E23","v":0},null,"NOI",{"$f":"P22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSCR",{"$f":"P22/P21","v":{"$error":"#DIV/0!"}},null,"DSCR",{"$f":"S22/S21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Anticipated Short-Term Tax-Exempt Loan, if any: ",{"$f":"GENERAL!J22-M13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Tax-Exempt Loan: ",{"$f":"'TAX CREDIT'!L77","v":0}]
[null,null,"Cash Flow Financing and Grants"]
[null,null,"Type of Funds",null,null,"Source of Funds","Lien Position *","Percent of Cash Flow (Choose One)","Annual Payment","Interest Rate","Amortization Term","Term","Loan Amount"]
[null,null,"Rental Housing Program Funds",null,null,"Maryland DHCD",2,"Surplus Cash Model",{"$f":"-PMT(J28/12,K28*12,M28,0)*12","v":0},0.02,40,40]
[null,null,"Rental Housing Works",null,null,"Maryland DHCD",2,null,0,0.02,40,40]
[null,null,"Housing Trust Funds",null,null,"Maryland DHCD",2,null,0,0.02,40,40]
[null,null,"HOME Funds",null,null,"Maryland DHCD",2,null,0,0.02,40,40]
[null,null,"Multifamily Capital Fund",null,null,"Maryland DHCD",2,null,{"$f":"-PMT(J32/12,K32*12,M32,0)*12","v":0},0.02,40,40]
[null,null,"HOME ARP",null,null,"Maryland DHCD",2,null,{"$f":"-PMT(J33/12,K33*12,M33,0)*12","v":0},0.02,40,40]
[null,null,"Partnership Rental Housing Program Funds",null,null,"Maryland DHCD",2]
[null,null,"Weinberg",null,null,"Maryland DHCD",3]
[null,null,"HOME (non-DHCD)",null,null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Seller Note",null,null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe ",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe ",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Other:","Describe",null,"Enter Entity Name","_",null,null,null,1]
[null,null,"Total Cash Flow Financing",null,null,null,null,null,{"$f":"+SUM(I28:I33)+SUM(I36:I43)","v":0},null,null,null,{"$f":"SUM(M28:M43)","v":0}]
[null,null,"Total Debt (Debt Service + Cash Flow Financing)",null,null,null,null,null,{"$f":"I22+I44","v":0},null,null,null,{"$f":"M22+M44","v":0}]
[]
[null,null,"EQUITY"]
[]
[null,null,"Type of Equity",null,null,null,"Source of Equity",null,null,null,null,null,"Amount"]
[null,null,"Federal Historic Tax Credit Proceeds (from Tax Credit section)",null,null,null,{"$f":"'DEV TEAM'!E104","v":0},null,null,null,null,null,{"$f":"'TAX CREDIT'!G138","v":0},null,{"$f":"'TAX CREDIT'!G138","v":0}]
[null,null,"State Historic Tax Credit Proceeds (from Tax Credit section)",null,null,null,{"$f":"'DEV TEAM'!E110","v":0},null,null,null,null,null,{"$f":"'TAX CREDIT'!H138","v":0},null,{"$f":"'TAX CREDIT'!H138","v":0}]
[null,null,"Low Income Housing Tax Credit Proceeds (from Tax Credit section)",null,null,null,{"$f":"'DEV TEAM'!E98","v":0},null,null,null,null,null,null,null,{"$f":"'TAX CREDIT'!J95","v":{"$error":"#DIV/0!"}}]
[null,null,"Deferred Developer Fee",null,null,null,null,null,null,{"$f":"M53/(USES!J101)","v":{"$error":"#DIV/0!"}}]
[null,null,"Developer Equity (not from syndication proceeds)"]
[null,null,"Interim Income (occupied rehabilitation projects)",null,null,null,null,null,null,null,null,"Provide a construction period income and expense budget"]
[null,null,"Other:","45L Energy Credits"]
[null,null,"Other:","Describe"]
[null,null,"Other:","Describe"]
[null,null,"Other:","Describe"]
[null,null,"Other:","Describe"]
[null,null,"Total Equity",null,null,null,null,null,null,null,null,null,{"$f":"0+SUM(M50:M60)","v":0}]
[null,null,"Total Sources of Funds (Total Debt + Equity)",null,null,null,null,null,null,null,null,null,{"$f":"M45+M61","v":0}]
[null,null,null,null,null,"=IF((USES!I128-M42)>'TAX CREDIT'!J103,'TAX CREDIT'!J103,(USES!I128-M42))",null,null,null,null,null,"Uses",{"$f":"USES!J128","v":2500}]
[null,null,null,null,null,null,null,null,null,null,null,"Surplus / (Gap)",{"$f":"M62-M63","v":-2500}]

{"sheet":"USES","index":7,"n_rows":177,"n_cols":13,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"USES OF FUNDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"TOTAL DEVELOPMENT COSTS"]
[]
[null,null,"Construction  or Rehabilitation Costs"]
[null,null,"Type of Uses",null,null,null,null,null,"Percentage","Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,"01","Net Construction Costs",null,null,null,null,null,null,null,null,{"$f":"J10-K10-L10","v":0}]
[null,null,"02","General Requirements",null,null,null,null,{"$f":"IF(J11=0,\"\",J11/J10)","v":""},null,null,null,0]
[null,null,"03","Builder's Profit",null,null,null,null,{"$f":"IF(J12=0,\"\",J12/J10)","v":""},null,null,null,0]
[null,null,"04","Builder's General Overhead",null,null,{"$f":"SUM(I11:I13)","v":0},null,{"$f":"IF(J13=0,\"\",J13/J10)","v":""},null,null,null,0]
[null,null,"05","Bond Premium",null,null,null,null,null,null,null,null,0]
[null,null,"05a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"05b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"06","Total Construction Contract ",null,null,null,null,null,{"$f":"SUM(J10:J16)","v":0},{"$f":"SUM(K10:K16)","v":0},{"$f":"SUM(L10:L16)","v":0},0]
[null,null,"07","Construction Contingency",null,null,null,null,{"$f":"IF(J18=0,\"\",J18/J17)","v":""},null,null,null,0]
[null,null,"08","Total Construction Costs",null,null,null,null,null,{"$f":"SUM(J17:J18)","v":0},{"$f":"SUM(K17:K18)","v":0},{"$f":"SUM(L17:L18)","v":0},{"$f":"SUM(M17:M18)","v":0}]
[]
[null,null,"Fees Related to Construction or Rehabilitation"]
[null,null,"Type of Uses",null,null,null,null,null,"Percentage","Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,9,"Architect's Design Fee",null,null,null,null,{"$f":"IF(J23=0,\"\",J23/J17)","v":""},null,null,null,{"$f":"J23-K23-L23","v":0}]
[null,null,{"$f":"C23+1","v":10},"Architect's Supervision Fee",null,null,null,null,{"$f":"IF(J24=0,\"\",J24/J17)","v":""},null,null,null,0]
[null,null,{"$f":"C24+1","v":11},"Architect Reimbursable Additional Design",null,null,null,null,{"$f":"IF(J25=0,\"\",J25/J17)","v":""},null,null,null,0]
[null,null,12,"Real Estate Attorney",null,null,null,null,null,null,null,null,0]
[null,null,13,"Civil Engineering Fee",null,null,null,null,{"$f":"IF(J27=0,\"\",J27/J10)","v":""},null,null,null,0]
[null,null,14,"Marketing",null,null,null,null,null,null,null,null,0]
[null,null,"14a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C28+1","v":15},"Surveys",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C30+1","v":16},"Soil Borings",null,null,null,null,null,null,null,null,0]
[null,null,17,"Appraisal",null,null,null,null,null,null,null,null,0]
[null,null,18,"Market Study",null,null,null,null,null,null,null,null,0]
[null,null,19,"Environmental Report",null,null,null,null,null,null,null,null,0]
[null,null,"19a","Environmental Consultant"]
[null,null,{"$f":"C34+1","v":20},"Building Permits and Fees",null,null,null,null,null,null,null,null,0]
[null,null,21,"Tap Fees",null,null,null,null,null,null,null,null,0]
[null,null,22,"FF&E",null,null,null,null,null,null,null,null,0]
[null,null,23,"Accessibility Consultant",null,null,null,null,null,null,null,null,0]
[null,null,"2a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23c","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23d","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23e","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23f","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"23g","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C39+1","v":24},"Total Fees",null,null,null,null,null,{"$f":"+SUM(J23:J46)","v":0},{"$f":"+SUM(K23:K46)","v":0},{"$f":"+SUM(L23:L46)","v":0},{"$f":"+SUM(M23:M46)","v":0}]
[]
[null,null,"Financing Fees and Charges"]
[null,null,"Type of Uses",null,null,null,null,null,null,"Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,{"$f":"C47+1","v":25},"Construction Interest",null,null,null,null,null,null,null,null,{"$f":"J51-K51-L51","v":0}]
[null,null,"25a","Negative Arbitrage",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C51+1","v":26},"Real Estate Taxes",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C53+1","v":27},"Insurance Premium",null,null,null,null,null,null,null,null,0]
[null,null,28,"Mortgage Insurance Premium",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C55+1","v":29},"Title and Recording",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C56+1","v":30},"Financing (soft cost) Contingency",null,null,null,"2.5% maximum =",{"$f":"(J47+J79-J57)*2.5%","v":0},null,null,null,0]
[null,null,{"$f":"C57+1","v":31},"CDA Subordinate Loan Commitment Fees (RHP/RHW/HTF/HOME/PRHP/MCF/HOME-ARP)",null,null,null,null,null,null,null,null,0]
[null,null,32,"CDA Loan Servicing Fee",null,null,null,null,null,null,null,null,0]
[null,null,"32a","CDA Subsidy Layering Fee",null,null,null,1000,"If applicable",null,null,null,0]
[null,null,"32b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C59+1","v":33},"CDA Bond Commitment Fee",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C62+1","v":34},"CDA Trustee Fees (long term loan only)",null,null,null,null,null,null,null,null,0]
[null,null,35,"CDA Trustee Fees (short term taxable/tax-exempt loan only)",null,null,null,null,null,null,null,null,0]
[null,null,36,"CDA/FHA Risk Sharing Fees",null,null,null,null,null,null,null,null,0]
[null,null,37,"CDA Closing Fee",null,"($32K 1st loan + $6K per additional loan)",null,null,null,null,null,null,0]
[null,null,"37a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C66+1","v":38},"Other Lenders' Origination Fees (non-syndication only)",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C68+1","v":39},"Other Lenders' Legal Fees (non-syndication only)",null,null,null,null,null,null,null,null,0]
[null,null,"39a","Other:",null,"FHA Lender Legal"]
[null,null,"39b","Other:",null,"FHA Commitment Fee"]
[null,null,"39c","Other:",null,"FHA Inspection Fee"]
[null,null,"39d","Other:",null,"FHA Lender Fee"]
[null,null,"39e","Other:",null,"FHA Lender Due Diligence"]
[null,null,"39f","Other:",null,"FHA Processing Fee"]
[null,null,{"$f":"C69+1","v":40},"Bond Issuance Costs",null,null,null,null,null,null,null,null,0]
[null,null,"40a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"40b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C76+1","v":41},"Total Financing Fees and Charges",null,null,null,null,null,{"$f":"+SUM(J51:J78)","v":0},{"$f":"+SUM(K51:K78)","v":0},{"$f":"+SUM(L51:L78)","v":0},{"$f":"+SUM(M51:M78)","v":0}]
[]
[null,null,"* Complete for Tax Credit Applications Only"]
[null,null,"Acquisition Costs"]
[null,null,"Type of Uses",null,null,null,null,null,null,"Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,{"$f":"C79+1","v":42},"Building Acquisition",null,null,null,null,null,null,null,null,{"$f":"J84-K84-L84","v":0}]
[null,null,{"$f":"C84+1","v":43},"Land Acquisition",null,null,null,null,"If a rehabilitation project, describe land acquisition cost",null,null,null,0]
[null,null,{"$f":"C85+1","v":44},"Special Assessment",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C86+1","v":45},"Carrying Charges",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C87+1","v":46},"Relocation Costs",null,null,null,null,null,null,null,null,0]
[null,null,47,"Off-Site Improvements",null,null,null,null,null,null,null,null,0]
[null,null,"47a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"47b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C89+1","v":48},"Total Acquisition Costs",null,null,null,null,null,{"$f":"SUM(J84:J91)","v":0},{"$f":"+SUM(K84:K91)","v":0},{"$f":"+SUM(L84:L91)","v":0},{"$f":"+SUM(M84:M91)","v":0}]
[null,null,{"$f":"C92+1","v":49},"Total Development Costs (TDC)",null,null,null,null,null,{"$f":"+SUM(+J19+J47+J79+J92)","v":0},{"$f":"+SUM(+K19+K47+K79+K92)","v":0},{"$f":"+SUM(+L19+L47+L79+L92)","v":0},{"$f":"+SUM(+M19+M47+M79+M92)","v":0}]
[]
[null,null,"OTHER USES OF FUNDS"]
[]
[null,null,"Developer's Fee"]
[null,null,"Type of Uses",null,null,null,null,null,null,"Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,{"$f":"C93+1","v":50},"Fee on Non-Acquisition Costs (calculated below)",null,null,null,null,null,{"$f":"M143","v":0},null,{"$f":"J99","v":0},{"$f":"J99-K99-L99","v":0}]
[null,null,{"$f":"C99+1","v":51},"Fee on Acquisition Costs (calculated below)",null,null,null,null,null,{"$f":"M150","v":0},{"$f":"J100","v":0},null,0]
[null,null,52,"Total Developer's Fee",null,null,null,null,null,{"$f":"SUM(J99:J100)","v":0},{"$f":"SUM(K99:K100)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"IF(GENERAL!$F9=\"4% Twinning Project\",\"$5 million maximum combined developer fee\",IF(GENERAL!$F9=\"9% Twinning Project\",\"$5 million maximum combined developer fee\"))","v":false}]
[null,null,"Syndication Related Costs"]
[null,null,"Type of Uses",null,null,null,null,null,null,"Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,{"$f":"C101+1","v":53},"Syndication Fee",null,null,null,null,null,null,null,null,{"$f":"J105-K105-L105","v":0}]
[null,null,{"$f":"C105+1","v":54},"Legal (syndication only)",null,null,null,null,null,null,null,null,0]
[null,null,55,"Bridge Loan Fees",null,null,null,null,null,null,null,null,0]
[null,null,56,"Bridge Loan Interest",null,null,null,null,null,null,null,null,0]
[null,null,57,"Organizational Costs",null,null,null,null,null,null,null,null,0]
[null,null,58,"Tax Credit Application Fee",null,null,null,null,null,2500,null,null,2500]
[null,null,59,"Tax Credit Allocation Fee",null,null,null,null,{"$f":"'TAX CREDIT'!J109*0.05","v":0},null,null,null,0]
[null,null,60,"Tax Credit Reservation Fee",null,null,null,null,"Include Carryover fee if applicable",null,null,null,0]
[null,null,61,"Accounting and Auditing Fee",null,null,null,null,null,null,null,null,0]
[null,null,"61a","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,"61b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C113+1","v":62},"Total Syndication Related Costs",null,null,null,null,null,{"$f":"SUM(J105:J115)","v":2500},{"$f":"SUM(K105:K115)","v":0},{"$f":"SUM(L105:L115)","v":0},{"$f":"SUM(M105:M115)","v":2500}]
[]
[null,null,"Guarantees and Reserves (funded amounts only)"]
[null,null,"Type of Uses",null,null,null,null,null,null,"Total Budgeted Cost","Acquisition Basis*","Construction Basis*","Not in Basis*"]
[null,null,{"$f":"C116+1","v":63},"Construction Guarantee",null,null,null,null,null,null,null,null,{"$f":"J120-K120-L120","v":0}]
[null,null,{"$f":"C120+1","v":64},"Operating Reserve",null,null,null,"6 mos. =",{"$f":"(SOURCES!I22+EXPENSES!K73)/12*6","v":0},null,null,null,0]
[null,null,65,"Rent-up Reserve",null,null,null,null,null,null,null,null,0]
[null,null,66,"Supportive Services Reserve",null,null,null,null,null,null,null,null,0]
[null,null,67,"Developer Fee Funded Supportive Services / Rent Subsidy / Sponsor Note Reserve ",null,null,null,null,{"$f":"IF(GENERAL!$K109=\"Yes\",M177, 0)","v":0},null,null,null,0]
[null,null,"67a","Other Reserve:",null,"Describe",null,null,null,null,null,null,0]
[null,null,"67b","Other:","Describe",null,null,null,null,null,null,null,0]
[null,null,{"$f":"C124+1","v":68},"Total Guarantees and Reserves",null,null,null,null,null,{"$f":"SUM(J120:J126)","v":0},{"$f":"SUM(K120:K126)","v":0},0,{"$f":"SUM(M120:M126)","v":0}]
[null,null,69,"Total Uses of Funds",null,null,null,null,null,{"$f":"+SUM(+J93+J101+J116+J127)","v":2500},{"$f":"+SUM(+K93+K101+K116+K127)","v":0},{"$f":"+SUM(+L93+L101+L116+L127)","v":0},{"$f":"M127+M116+M101+M93","v":2500}]
[]
[null,null,null,"* Complete for Tax Credit Applications Only"]
[]
[null,null,null,"MAXIMUM DEVELOPER'S FEE"]
[]
[null,null,null,"Fee on Non-acquisition Costs",null,null,null,null,null,"Fee on Costs Over $10 Million","Fee on Costs   $10 Million or Less"]
[null,null,null,"Total Development Costs (from line 49 above)",null,null,null,null,null,{"$f":"J93","v":0}]
[null,null,null,"Less Acquisition Costs (from line 48 above)",null,null,null,null,null,{"$f":"-J92","v":0}]
[null,null,null,"Less Construction Contingency (from line 08 above)",null,null,null,null,null,{"$f":"-J18","v":0}]
[null,null,null,"Less Financing (Soft Cost) Contingency (from line 29 above)",null,null,null,null,null,{"$f":"-J57","v":0}]
[null,null,null,"Non-acquisition Costs",null,null,null,null,null,{"$f":"J135+J136+J137+J138","v":0}]
[null,null,null,"Lesser of $10,000,000 or Non-acquisition Costs (enter on both lines)",null,null,null,null,null,{"$f":"IF(J139>10000000,10000000,J139)","v":0},{"$f":"IF(J139>10000000,10000000,J139)","v":0}]
[null,null,null,"Non-acquisition Fee Basis",null,null,null,null,null,{"$f":"J139-J140","v":0},{"$f":"K140","v":0}]
[null,null,null,"Fee Percentage",null,null,null,null,null,0.1,0.15]
[null,null,null,"Fee on Non-acquisition Costs",null,null,null,null,null,{"$f":"J141*J142","v":0},{"$f":"K141*K142","v":0},"Total =",{"$f":"J143+K143","v":0}]
[]
[null,null,null,"Fee on Acquisition Costs"]
[null,null,null,"Acquisition Costs (from line 45 above)",null,null,null,null,null,{"$f":"J92","v":0}]
[null,null,null,"Lesser of $10,000,000 or Acquisition Costs (enter on both lines)",null,null,null,null,null,{"$f":"IF(J146>10000000,10000000,J146)","v":0},{"$f":"IF(J146>10000000,10000000,J146)","v":0}]
[null,null,null,"Acquisition Fee Basis",null,null,null,null,null,{"$f":"J146-J147","v":0},{"$f":"K147","v":0}]
[null,null,null,"Fee Percentage",null,null,null,null,null,0.05,0.1]
[null,null,null,"Fee on Acquisition Costs",null,null,null,null,null,{"$f":"+J148*J149","v":0},{"$f":"K149*K147","v":0},"Total =",{"$f":"J150+K150","v":0}]
[]
[null,null,null,"Total Developer's Fee (Fee on Non-acquisition Costs + Fee on Acquisition Cost)",null,null,null,null,null,null,null,null,{"$f":"M143+M150","v":0}]
[]
[null,null,null,"See Guide, Section 3.9.8.3 for Limitations on Developer's Fees"]
[]
[]
[null,null,null,"MAXIMUM DEVELOPER FEE FUNDED SUPPORTIVE SERVICES /RENT SUBSIDY/SPONSOR NOTE RESERVE "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(GENERAL!K109=\"No\",\"Fee calculated only if General Tab ''Developer Fee Funded Services / Rent Subsidy / Reserve'' question is answered Yes\")","v":"Fee calculated only if General Tab ''Developer Fee Funded Services / Rent Subsidy / Reserve'' question is answered Yes"}]
[null,null,null,"Fee on Non-acquisition Costs",null,null,null,null,null,"Fee on Costs Over $10 Million","Fee on Costs   $10 Million or Less"]
[null,null,null,"Total Development Costs (from line 49 above)",null,null,null,null,null,{"$f":"J93","v":0}]
[null,null,null,"Less Acquisition Costs (from line 48 above)",null,null,null,null,null,{"$f":"-J92","v":0}]
[null,null,null,"Less Construction Contingency (from line 08 above)",null,null,null,null,null,{"$f":"-J18","v":0}]
[null,null,null,"Less Financing (Soft Cost) Contingency (from line 29 above)",null,null,null,null,null,{"$f":"-J57","v":0}]
[null,null,null,"Non-acquisition Costs",null,null,null,null,null,{"$f":"J135+J136+J137+J138","v":0}]
[null,null,null,"Lesser of $10,000,000 or Non-acquisition Costs (enter on both lines)",null,null,null,null,null,{"$f":"IF(J164>10000000,10000000,J164)","v":0},{"$f":"IF(J139>10000000,10000000,J139)","v":0}]
[null,null,null,"Non-acquisition Fee Basis",null,null,null,null,null,{"$f":"(J164-J165)","v":0},{"$f":"K140","v":0}]
[null,null,null,"Fee Percentage   (5% maximum)",null,null,null,null,{"$f":"IF($J167>5%,\"5% maximum\")","v":false},0.05,0.05,{"$f":"IF($K167>5%,\"5% maximum\")","v":false}]
[null,null,null,"Fee on Non-acquisition Costs",null,null,null,null,null,{"$f":"IF(GENERAL!$K109=\"No\", 0, J166*J167)","v":0},{"$f":"IF(GENERAL!$K109=\"No\", 0, K166*K167)","v":0},"Total =",{"$f":"J168+K168","v":0}]
[]
[null,null,null,"Fee on Acquisition Costs"]
[null,null,null,"Acquisition Costs (from line 45 above)",null,null,null,null,null,{"$f":"J92","v":0}]
[null,null,null,"Lesser of $10,000,000 or Acquisition Costs (enter on both lines)",null,null,null,null,null,{"$f":"IF(J146>10000000,10000000,J146)","v":0},{"$f":"IF(J146>10000000,10000000,J146)","v":0}]
[null,null,null,"Acquisition Fee Basis",null,null,null,null,null,{"$f":"(J171-J172)","v":0},{"$f":"K172","v":0}]
[null,null,null,"Fee Percentage   (5% maximum)",null,null,null,null,{"$f":"IF($J174>5%,\"5% maximum\")","v":false},0.05,0.05]
[null,null,null,"Fee on Acquisition Costs",null,null,null,null,null,{"$f":"IF(GENERAL!$K109=\"No\", 0, J174*J173)","v":0},{"$f":"IF(GENERAL!$K109=\"No\", 0, K172*K174)","v":0},"Total =",{"$f":"J175+K175","v":0}]
[]
[null,null,null,"Total Developer's Fee Attributed to Supportive Services Reserve",null,null,null,null,null,null,null,null,{"$f":"M168+M175","v":0}]

{"sheet":"TAX CREDIT","index":8,"n_rows":138,"n_cols":16,"rows_kept":138,"cut":false,"hidden":false,"merged":[[94,12,98,12],[51,2,51,3],[52,2,52,3],[92,11,93,11],[92,12,93,12],[80,9,81,9],[57,10,57,11]]}
[]
[]
[null,null,"LOW-INCOME HOUSING TAX CREDIT"]
[null,null,"Complete This Section Only If Applying For Low Income Housing Tax Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[null,null,"Type of Low Income Housing Tax Credit Requested (mark all that apply)"]
[null,null,null,"New Construction"]
[null,null,null,"Acquisition (must include substantial rehabilitation as defined in Tax Credit Regulations)"]
[null,null,null,"Substantial Rehabilitation (as defined in Tax Credit Regulations--Department's standard is different)"]
[]
[null,null,"EXISTING BUILDING INFORMATION"]
[]
[null,null,"Location and Placed-in-Service Information"]
[]
[null,null,"Building Address",null,null,"Building Identification Number (BIN) (If Applicable)","Control Document","Date Control Document Expires","Number of Units","Purchase Price",null,"Date Last Placed in Service (PIS)","Sponsor's  Purchase Date","Years Between PIS & Purchase Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I17:I30)","v":0},{"$f":"SUM(J17:J30)","v":0}]
[]
[null,null,"Ten Year Rule Exemption:  Does the building qualify for an exemption to the 10 Year Rule as provided in HR 3221?*",null,null,null,null,null,null,null,"(choose) "]
[null,null,"* If yes, application must include written explanation and legal opinion."]
[]
[null,null,"Substantial Rehabilitation Determination (for Tax Credit eligibility -- Department's standard is different)"]
[null,null,"Total rehabilitation related costs equal:",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Total rehabilitation related costs must exceed the greater of the following tests (choose one option)"]
[null,null,null,"Costs are at least $7,900* per unit:",null,null,"Total Units:",null,"x  $6,000* =",{"$f":"H39*6000","v":0}]
[null,null,null,"Costs are at least 20% of the project's adjusted basis:",null,null,"Basis:",null,"x  20% =",{"$f":"H40*0.2","v":0}]
[null,null,"*Adjusted annually for inflation."]
[]
[null,null,"ELECTIONS"]
[]
[null,null,"Minimum Set-aside Election (choose one option)"]
[null,null,null,"20% of the units will be occupied by households with income below 50% of the area median"]
[null,null,"X","40% of the units will be occupied by households with income below 60% of the area median"]
[null,null,null,"Income Averaging Set-Aside"]
[]
[null,null,"Rent Floor Election"]
[null,null,"The rent floor for the project will be established as of (choose one option)"]
[null,null,null,null,"Date of allocation"]
[null,null,null,null,"Date the project is placed in service"]
[]
[null,null,"SYNDICATION INFORMATION"]
[]
[null,null,"Name of Syndicator",null,{"$f":"'DEV TEAM'!E98","v":0}]
[null,null,"Contact:",null,{"$f":"'DEV TEAM'!E100","v":0},null,null,null,null,"Phone:",{"$f":"'DEV TEAM'!J100","v":0}]
[]
[null,null,"Type of Offering  (choose)",null,null,"Schedule for Funds to be Paid"]
[null,null,null,"Public",null,"Percent Paid","Amount Paid","Date Paid",null,null,null,null,null,null,null,"X"]
[null,null,"X","Private"]
[]
[null,null,"Type of Investors (mark one box only)"]
[null,null,null,"Individuals"]
[null,null,null,"Fund"]
[null,null,"X","Corporation"]
[]
[null,null,"CALCULATION OF TAX CREDIT AMOUNT"]
[]
[null,null,"Maximum Low-Income Housing Tax Credit Based on Eligible Costs"]
[null,null,"Description",null,null,null,null,null,"Acquisition Basis","Construction Basis"]
[null,null,"Total Uses of Funds (from Uses of Funds worksheet)",null,null,null,null,null,{"$f":"USES!K128","v":0},{"$f":"USES!L128","v":0},null,{"$f":"IF(GENERAL!$F9=\"4% Project\",SUM(I73:J73),IF(GENERAL!$F9=\"4% Twinning Project\",SUM(I73:J73),0))","v":0},"Basis"]
[null,null,"Less: Federal Grants Financing Qualifying Costs (list below)",null,null,null,null,null,null,{"$f":"(-G122)","v":0},null,{"$f":"IF(GENERAL!$F$9=\"4% Project\",USES!J85,IF(GENERAL!$F$9=\"4% Twinning Project\",USES!J85,0))","v":0},"Land"]
[null,null,"Less: Other Non-qualifying Financing",null,null,null,null,null,null,null,null,{"$f":"SUM(L73:L74)","v":0}]
[null,null,"Less: Value of Commercial Space",null,null,null,null,null,null,null,null,0.53,null,null,null,"=CEILING((M72*M73),5000)"]
[null,null,"Less: Non-qualifying Units of Higher Quality",null,null,null,null,null,null,null,null,{"$f":"CEILING((L75*L76),5000)","v":0},"T-E Loan Required for 50% Test"]
[null,null,"Less: Federal Historic Tax Credit",null,null,null,null,null,null,{"$f":"-G136","v":0}]
[null,null,"Less: State Historic Tax Credit",null,null,null,null,null,null,{"$f":"-H136","v":0}]
[null,null,"Adjusted Project Costs",null,null,null,null,null,{"$f":"I73+(SUM(I74:I79))","v":0},{"$f":"J73+(SUM(J74:J79))","v":0}]
[null,null,"Adjustment for Federal QCT/DDA  or State Basis Boost (130% maximum)",null,null,null,null,null,null,1]
[null,null,"CENSUS TRACT/DDA # "]
[null,null,"Eligible Basis",null,null,null,null,null,{"$f":"I73-(SUM(I74:I79))","v":0},{"$f":"J80*J81","v":0}]
[null,null,"Applicable Fraction (calculate below)",null,null,null,null,null,{"$f":"MIN($C$132,$F$132)","v":0},{"$f":"MIN($C$132,$F$132)","v":0},null,null,null,null,null,"=IF(GENERAL!$D$8=\"4% Project\",4%,IF(GENERAL!$D$8=\"4% Twinning Project\",4%,9%))"]
[null,null,"Qualified Basis",null,null,null,null,null,{"$f":"I83*I84","v":0},{"$f":"J83*J84","v":0}]
[null,null,"Applicable Percentage (enter correct percentage per IRS rules)",null,null,null,null,null,0.04,{"$f":"IF(GENERAL!$F$9=\"4% Project\",4%,IF(GENERAL!$F$9=\"4% Twinning Project\",4%,9%))","v":0.09}]
[null,null,"Low Income Housing Tax Credit Eligible",null,null,null,null,null,{"$f":"I85*I86","v":0},{"$f":"J85*J86","v":0}]
[]
[null,null,"Estimated Low-Income Housing Tax Credit Syndication Proceeds"]
[null,null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,null,"=IF((J82=9%),MIN(SUM(I83:J83),1500000),(I83+J83))"]
[null,null,"Combined Low Income Housing Tax Credit Eligible ",null,null,null,null,null,"Use calculated formula -or- enter credit amount less than $1.5M  --->>",{"$f":"IF((J86=9%),MIN(SUM(I87:J87),1500000),(I87+J87))","v":0},null,"=IF((J86=9%),MIN(SUM(I87:J87),1500000),(I87+J87))"]
[null,null,"Tax Credit Period (10 years)",null,null,null,null,null,null,"x 10"]
[null,null,"Total Tax Credit Received Over Period",null,null,null,null,null,null,{"$f":"J91*10","v":0},null,{"$f":"L95/J93","v":{"$error":"#DIV/0!"}}," Calculated Raise Ratio"]
[null,null,"Raise Ratio from Syndicator's Proposal",null,null,null,null,null,null,{"$f":"L93","v":{"$error":"#DIV/0!"}}]
[null,null,"Gross Proceeds from Low Income Housing Tax Credit",null,null,null,null,null,null,{"$f":"J93*J94","v":{"$error":"#DIV/0!"}},null,null,"Enter \"LIHTC Proceeds\" amount from the 202's Sources tab"]
[null,null,"Less: Gross Proceeds from Federal Historic Tax Credit (calculate below)",null,null,null,null,null,null,{"$f":"G138","v":0}]
[null,null,"Less: Gross Proceeds from State Historic Tax Credit (calculate below)",null,null,null,null,null,null,{"$f":"H138","v":0}]
[null,null,"Total Equity from Syndication Proceeds",null,null,null,null,null,null,{"$f":"J96+J95","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Maximum Low-Income Housing Tax Credit Based on Proceeds Needed"]
[null,null,"Description",null,null,null,null,null,null,"Amount"]
[null,null,"Proceeds Needed (enter lesser of Total Equity from Syndication Proceeds or Financing Gap)",null,null,null,null,null,null,{"$f":"J98","v":{"$error":"#DIV/0!"}}]
[null,null,"Less: Gross Proceeds from Federal Historic Tax Credit (calculate below)",null,null,null,null,null,null,{"$f":"G138","v":0}]
[null,null,"Less: Gross Proceeds from  State Historic Tax Credit (calculate below)",null,null,null,null,null,null,{"$f":"H138","v":0}]
[null,null,"Low Income Housing Tax Credit Syndication Proceeds (to Sources of Funds worksheet)",null,null,null,null,null,null,{"$f":"J102-J103","v":{"$error":"#DIV/0!"}}]
[null,null,"Raise Ratio from Syndicator's Proposal",null,null,null,null,null,null,{"$f":"J94","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Tax Credit Received Over Period",null,null,null,null,null,null,{"$f":"J93","v":0}]
[null,null,"Tax Credit Period (10 years)",null,null,null,null,null,null,"÷ 10"]
[null,null,"Maximum Low-Income Housing Tax Credit",null,null,null,null,null,null,{"$f":"(J107/10)","v":0}]
[]
[null,null,"Sources of Federal Financing"]
[null,null,"Show all direct and indirect federal funds financing qualified costs below"]
[null,null,null,null,null,null,"Amount Deducted"]
[null,null,null,null,null,"Amount","from Eligible Basis"]
[null,null,"Rural Housing and Community Development Service"]
[null,null,"Community Development Block Grant"]
[null,null,"Rental Rehabilitation Program"]
[null,null,"Urban Development Assistance Grant"]
[null,null,"Housing Development Assistance Grant"]
[null,null,"HOME Investment Program"]
[null,null,"Other","Describe"]
[null,null,"Total Federal Funds",null,null,{"$f":"+SUM(F115:F121)","v":0},{"$f":"+SUM(G115:G121)","v":0}]
[]
[]
[null,null,"Applicable Fraction"]
[null,null,"The applicable fraction is the lesser of the following formulas (complete the Unit Percentage information AND the Square Footage Percentage information)"]
[]
[null,null,"Unit Percentage",null,null,"Square Footage Percentage"]
[]
[null,null,null,"Low Income Units",null,null,"Low Income Sq. Ft."]
[null,null,null,"Total Units",null,null,"Total Residential Units Sq. Ft."]
[null,null,{"$f":"IF(C130=0,\"\",C130/C131)","v":""},"Unit Percentage",null,{"$f":"IF(F130=0,\"\",F130/F131)","v":""},"Sq. Ft. Percentage"]
[]
[]
[null,null,"Gross Proceeds from Historic Tax Credits",null,null,null,"Federal HTC","State HTC","Total HTC"]
[null,null,"Historic Tax Credit",null,null,null,null,null,{"$f":"SUM(G136:H136)","v":0}]
[null,null,"Raise Ratio from Syndicator's Proposal"]
[null,null,"Gross Proceeds from Historic Tax Credit (to Sources of Funds worksheet)",null,null,null,{"$f":"G136*G137","v":0},{"$f":"H136*H137","v":0},{"$f":"SUM(G138:H138)","v":0}]

{"sheet":"SUMMARY","index":9,"n_rows":119,"n_cols":11,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PROJECT SUMMARY INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[null,null,"GENERAL INFORMATION"]
[]
[null,null,"Project Information"]
[null,null,"Project Name",null,{"$f":"GENERAL!F36","v":0}]
[null,null,"Address",null,{"$f":"GENERAL!F37","v":0}]
[null,null,"City",null,{"$f":"GENERAL!F39","v":0},null,null,null,"County:",{"$f":"GENERAL!J39","v":0}]
[null,null,"Sponsor",null,{"$f":"GENERAL!F45","v":0}]
[]
[null,null,"Funding Applied For",null,null,null,null,null,"Occupancy Restrictions"]
[null,null,{"$f":"GENERAL!C18","v":"Low Income Housing Tax Credit"},null,null,null,{"$f":"GENERAL!F18","v":0},null,"Units 20% or less of AMI",null,{"$f":"GENERAL!H150","v":0}]
[null,null,{"$f":"GENERAL!C19","v":"Multifamily Bonds (taxable)"},null,null,null,{"$f":"GENERAL!F19","v":0},null,"Units at 21-30% of AMI",null,{"$f":"GENERAL!H152","v":0}]
[null,null,{"$f":"GENERAL!C20","v":"Multifamily Bonds (long term tax-exempt) "},null,null,null,{"$f":"GENERAL!F20","v":0},null,"Units at 31-40% of AMI",null,{"$f":"GENERAL!H154","v":0}]
[null,null,{"$f":"GENERAL!C21","v":"Multifamily Bonds (short term tax-exempt) "},null,null,null,{"$f":"GENERAL!F21","v":0},null,"Units at 41-50% of AMI",null,{"$f":"GENERAL!H156","v":0}]
[null,null,{"$f":"GENERAL!C23","v":"DHCD Subordinate Financing"},null,null,null,{"$f":"GENERAL!F22","v":0},null,"Units at 51-60% of AMI",null,{"$f":"GENERAL!H158","v":0}]
[null,null,{"$f":"GENERAL!C24","v":"Rental Housing Program Funds"},null,null,null,{"$f":"GENERAL!F24","v":0},null,"Units at 61-70% of AMI",null,{"$f":"GENERAL!H160","v":0}]
[null,null,{"$f":"GENERAL!C25","v":"Rental Housing Works"},null,null,null,{"$f":"GENERAL!F25","v":0},null,"Units at 71-80% of AMI",null,{"$f":"GENERAL!H162","v":0}]
[null,null,{"$f":"GENERAL!C28","v":"Multifamily Capital Fund"},null,null,null,{"$f":"GENERAL!F28","v":0},null,"Units at market rates",null,{"$f":"GENERAL!H164","v":0}]
[null,null,{"$f":"GENERAL!C29","v":"HOME ARP"},null,null,null,{"$f":"GENERAL!F29","v":0},null,"Staff Unit(s)",null,{"$f":"GENERAL!H166","v":0}]
[null,null,{"$f":"GENERAL!C30","v":"Partnership Rental Housing Program Funds"},null,null,null,{"$f":"GENERAL!F30","v":0},null,"Total Units",null,{"$f":"GENERAL!H168","v":0}]
[null,null,{"$f":"GENERAL!C31","v":"Weinberg"},null,null,null,{"$f":"GENERAL!F31","v":0}]
[null,null,{"$f":"GENERAL!C32","v":"Other:"},{"$f":"GENERAL!D32","v":0},null,null,{"$f":"GENERAL!F32","v":0}]
[]
[]
[null,null,"PROJECT INCOME (Effective Gross Income)"]
[]
[null,null,"                         Source of Income",null,null,null,"Total Units","Annual Gross Potential Income","Years Until Sustaining Occupancy","Annual Trending","Trended Income"]
[null,null,"Low Income Units",null,null,null,{"$f":"INCOME!F32","v":0},{"$f":"INCOME!N32","v":0},null,0.02,{"$f":"(H31*J31)+H31","v":0}]
[null,null,"Market Rate Units",null,null,null,{"$f":"INCOME!E50","v":0},{"$f":"INCOME!I50","v":0},null,0.02,{"$f":"(H32*J32)+H32","v":0}]
[null,null,"Nonresidential",null,null,null,null,{"$f":"SUM(INCOME!N62:N65)","v":0},null,0.02,{"$f":"(H33*J33)+H33","v":0}]
[null,null,{"$f":"INCOME!C66","v":"Commercial Income"},null,null,null,{"$f":"INCOME!F35","v":0},{"$f":"INCOME!N66","v":0},null,0.02,{"$f":"(H34*J34)+H34","v":0}]
[null,null,"Total Gross Potential Income",null,null,null,null,{"$f":"SUM(H31:H34)","v":0},null,null,{"$f":"SUM(K31:K34)","v":0}]
[null,null,"Vacancy Allowance",null,null,null,null,null,null,null,{"$f":"(K31*-INCOME!I33)+(K32*-INCOME!G52)+(K33*-INCOME!I69)+(K34*-INCOME!I71)","v":0}]
[null,null,"Trended Effective Gross Income",null,null,null,null,null,null,null,{"$f":"SUM(K35+K36)","v":0}]
[]
[null,null,"PROJECT EXPENSES"]
[]
[null,null,"Expense Categories",null,null,null,null,"Annual Expense","Years Until Sustaining Occupancy","Annual Trending","Trended Expense"]
[null,null,"Administrative",null,null,null,null,{"$f":"EXPENSES!K22-EXPENSES!K13","v":0},null,0.03,{"$f":"(H42*J42)+H42","v":0}]
[null,null,"Management Fee (Effective Gross Income x percentage)",null,null,null,null,{"$f":"EXPENSES!K13","v":0},null,null,{"$f":"K37*EXPENSES!H13","v":0}]
[null,null,"Utilities",null,null,null,null,{"$f":"EXPENSES!K31","v":0},null,0.03,{"$f":"H44+(H44*J44)","v":0}]
[null,null,"Operating and Maintenance",null,null,null,null,{"$f":"EXPENSES!K56","v":0},null,0.03,{"$f":"H45+(H45*J45)","v":0}]
[null,null,"Taxes and Insurance",null,null,null,null,{"$f":"EXPENSES!K69","v":0},null,0.03,{"$f":"H46+(H46*J46)","v":0}]
[null,null,"Reserve for Replacement",null,null,null,null,{"$f":"EXPENSES!K71","v":0},null,null,{"$f":"H47+(H47*J47)","v":0}]
[null,null,"Total Project Expenses",null,null,null,null,{"$f":"+SUM(H42:H47)","v":0},null,null,{"$f":"+SUM(K42:K47)","v":0}]
[null,null,"Trended Net Operating Income (Effective Gross Income - Project Expenses)",null,null,null,null,null,null,null,{"$f":"K37-K48","v":0}]
[null,null,"Annual Debt Service Financing Payments",null,null,null,null,null,null,null,{"$f":"(-J68)","v":0}]
[null,null,"Annual Cash Flow Financing Payments",null,null,null,null,null,null,null,{"$f":"(-J88)","v":0}]
[null,null,"Remaining Cash Flow (Net Operating Income - Financing Payments)",null,null,null,null,null,null,null,{"$f":"K49+K50+K51","v":0}]
[]
[null,null,"SOURCES OF FUNDS"]
[]
[null,null,"Debt Service Financing"]
[null,null,"Source of Funds",null,"Lender","Debt Coverage","Interest Rate","Amortization Term","Loan Term","Annual Payment","Amount"]
[null,null,{"$f":"SOURCES!C12","v":"Taxable Bonds"},null,{"$f":"SOURCES!F12","v":0},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"+SOURCES!J12","v":0},{"$f":"SOURCES!K12","v":0},{"$f":"SOURCES!L12","v":0},{"$f":"SOURCES!I12","v":0},{"$f":"SOURCES!M12","v":0}]
[null,null,{"$f":"SOURCES!C13","v":"Tax-exempt Bonds (Long Term Only) "},null,{"$f":"SOURCES!F13","v":0},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"+SOURCES!J13","v":0},{"$f":"SOURCES!K13","v":0},{"$f":"SOURCES!L13","v":0},{"$f":"SOURCES!I13","v":0},{"$f":"SOURCES!M13","v":0}]
[null,null,{"$f":"SOURCES!C14","v":"Private Loan"},null,null,{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J14","v":0},{"$f":"SOURCES!K14","v":0},{"$f":"SOURCES!L14","v":0},{"$f":"SOURCES!I14","v":0},{"$f":"SOURCES!M14","v":0}]
[null,null,{"$f":"SOURCES!C15","v":"FHA MIP"},null,{"$f":"SOURCES!F14","v":"Enter Entity Name"},null,{"$f":"+SOURCES!J15","v":2.5000000000000001E-3},null,null,{"$f":"SOURCES!I15","v":0}]
[null,null,{"$f":"SOURCES!C16","v":"Rental Housing Program Funds"},null,{"$f":"SOURCES!F16","v":"Maryland DHCD"},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J16","v":0},{"$f":"SOURCES!K16","v":0},{"$f":"SOURCES!L16","v":0},{"$f":"SOURCES!I16","v":0},{"$f":"SOURCES!M16","v":0}]
[null,null,{"$f":"SOURCES!C17","v":"HOME "},null,{"$f":"SOURCES!F17","v":"Maryland DHCD"},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J17","v":0},{"$f":"SOURCES!K17","v":0},{"$f":"SOURCES!L17","v":0},{"$f":"SOURCES!I17","v":0},{"$f":"SOURCES!M17","v":0}]
[null,null,{"$f":"SOURCES!C18","v":"HOME (non-DHCD)"},null,{"$f":"SOURCES!F18","v":"Enter Entity Name"},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J18","v":0},{"$f":"SOURCES!K18","v":0},{"$f":"SOURCES!L18","v":0},{"$f":"SOURCES!I18","v":0},{"$f":"SOURCES!M18","v":0}]
[null,null,{"$f":"SOURCES!C19","v":"Other:"},null,{"$f":"SOURCES!F19","v":"Enter Entity Name"},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J19","v":0},{"$f":"SOURCES!K19","v":0},{"$f":"SOURCES!L19","v":0},{"$f":"SOURCES!I19","v":0},{"$f":"SOURCES!M19","v":0}]
[null,null,{"$f":"SOURCES!C20","v":"Other:"},null,{"$f":"SOURCES!F20","v":"Enter Entity Name"},{"$f":"'PRO FORMA'!$E$38","v":""},{"$f":"SOURCES!J20","v":0},{"$f":"SOURCES!K20","v":0},{"$f":"SOURCES!L20","v":0},{"$f":"SOURCES!I20","v":0},{"$f":"SOURCES!M20","v":0}]
[null,null,{"$f":"SOURCES!C21","v":"Credit Enhancement"},null,{"$f":"SOURCES!F21","v":0},{"$f":"SOURCES!H20","v":0},{"$f":"SOURCES!J21","v":""},{"$f":"SOURCES!K21","v":0},{"$f":"SOURCES!L21","v":0},{"$f":"SOURCES!I21","v":0},{"$f":"SOURCES!M21","v":0}]
[null,null,"Total Debt Service Financing",null,null,null,null,null,null,{"$f":"SUM(J58:J67)","v":0},{"$f":"SUM(K58:K67)","v":0}]
[]
[null,null,"Cash Flow Financing and Grants"]
[null,null,"Source of Funds",null,"Lender",null,null,"Interest Rate","Loan Term","Annual Payment","Amount"]
[null,null,{"$f":"SOURCES!C28","v":"Rental Housing Program Funds"},null,{"$f":"SOURCES!F28","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J28","v":0.02},{"$f":"SOURCES!L28","v":40},null,{"$f":"SOURCES!M28","v":0}]
[null,null,{"$f":"SOURCES!C29","v":"Rental Housing Works"},null,{"$f":"SOURCES!F29","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J29","v":0.02},{"$f":"SOURCES!L29","v":40},null,{"$f":"SOURCES!M29","v":0}]
[null,null,{"$f":"SOURCES!C30","v":"Housing Trust Funds"},null,{"$f":"SOURCES!F31","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J30","v":0.02},{"$f":"SOURCES!L30","v":40},null,{"$f":"SOURCES!M30","v":0}]
[null,null,{"$f":"SOURCES!C31","v":"HOME Funds"},null,{"$f":"SOURCES!F34","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J31","v":0.02},{"$f":"SOURCES!L31","v":40},null,{"$f":"SOURCES!M31","v":0}]
[null,null,{"$f":"SOURCES!C32","v":"Multifamily Capital Fund"},null,{"$f":"SOURCES!F34","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J32","v":0.02},{"$f":"SOURCES!L32","v":40},null,{"$f":"SOURCES!M32","v":0}]
[null,null,{"$f":"SOURCES!C33","v":"HOME ARP"},null,{"$f":"SOURCES!F35","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J33","v":0.02},{"$f":"SOURCES!L33","v":40},null,{"$f":"SOURCES!M33","v":0}]
[null,null,{"$f":"SOURCES!C34","v":"Partnership Rental Housing Program Funds"},null,{"$f":"SOURCES!F35","v":"Maryland DHCD"},null,null,{"$f":"SOURCES!J34","v":0},{"$f":"SOURCES!L34","v":0},null,{"$f":"SOURCES!M34","v":0}]
[null,null,{"$f":"SOURCES!C35","v":"Weinberg"},null,{"$f":"SOURCES!F36","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J35","v":0},{"$f":"SOURCES!L35","v":0},null,{"$f":"SOURCES!M35","v":0}]
[null,null,{"$f":"SOURCES!C36","v":"HOME (non-DHCD)"},null,{"$f":"SOURCES!F37","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J36","v":0},{"$f":"SOURCES!L36","v":0},null,{"$f":"SOURCES!M36","v":0}]
[null,null,{"$f":"SOURCES!C37","v":"Seller Note"},null,{"$f":"SOURCES!F37","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J37","v":0},{"$f":"SOURCES!L37","v":0},null,{"$f":"SOURCES!M37","v":0}]
[null,null,{"$f":"SOURCES!C38","v":"Other:"},null,{"$f":"SOURCES!F38","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J38","v":0},{"$f":"SOURCES!L38","v":0},null,{"$f":"SOURCES!M38","v":0}]
[null,null,{"$f":"SOURCES!C39","v":"Other:"},null,{"$f":"SOURCES!F39","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J39","v":0},{"$f":"SOURCES!L39","v":0},null,{"$f":"SOURCES!M39","v":0}]
[null,null,{"$f":"SOURCES!C40","v":"Other:"},null,{"$f":"SOURCES!F40","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J40","v":0},{"$f":"SOURCES!L40","v":0},null,{"$f":"SOURCES!M40","v":0}]
[null,null,{"$f":"SOURCES!C41","v":"Other:"},null,{"$f":"SOURCES!F41","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J41","v":0},{"$f":"SOURCES!L41","v":0},null,{"$f":"SOURCES!M41","v":0}]
[null,null,{"$f":"SOURCES!C42","v":"Other:"},null,{"$f":"SOURCES!F42","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J42","v":0},{"$f":"SOURCES!L42","v":0},null,{"$f":"SOURCES!M42","v":0}]
[null,null,{"$f":"SOURCES!C43","v":"Other:"},null,{"$f":"SOURCES!F43","v":"Enter Entity Name"},null,null,{"$f":"SOURCES!J43","v":0},{"$f":"SOURCES!L43","v":0},null,{"$f":"SOURCES!M43","v":0}]
[null,null,"Total Cash Flow Financing",null,null,null,null,null,null,{"$f":"+SUM(J72:J77)+SUM(J80:J87)","v":0},{"$f":"+SUM(K72:K87)","v":0}]
[]
[null,null,"Equity"]
[null,null,"Type of Equity",null,null,null,null,"Source of Equity",null,null,"Amount"]
[null,null,{"$f":"SOURCES!C50","v":"Federal Historic Tax Credit Proceeds (from Tax Credit section)"},null,null,null,null,null,null,null,{"$f":"SOURCES!M50","v":0}]
[null,null,{"$f":"SOURCES!C51","v":"State Historic Tax Credit Proceeds (from Tax Credit section)"},null,null,null,null,null,null,null,{"$f":"SOURCES!M51","v":0}]
[null,null,{"$f":"SOURCES!C52","v":"Low Income Housing Tax Credit Proceeds (from Tax Credit section)"},null,null,null,null,null,null,null,{"$f":"SOURCES!M52","v":0}]
[null,null,{"$f":"SOURCES!C53","v":"Deferred Developer Fee"},null,null,null,null,null,null,null,{"$f":"SOURCES!M53","v":0}]
[null,null,{"$f":"SOURCES!C54","v":"Developer Equity (not from syndication proceeds)"},null,null,null,null,null,null,null,{"$f":"SOURCES!M54","v":0}]
[null,null,{"$f":"SOURCES!C55","v":"Interim Income (occupied rehabilitation projects)"},null,null,null,null,null,null,null,{"$f":"SOURCES!M55","v":0}]
[null,null,{"$f":"SOURCES!C56","v":"Other:"},{"$f":"SOURCES!D56","v":"45L Energy Credits"},null,null,null,null,null,null,{"$f":"SOURCES!M56","v":0}]
[null,null,{"$f":"SOURCES!C57","v":"Other:"},{"$f":"SOURCES!D57","v":"Describe"},null,null,null,null,null,null,{"$f":"SOURCES!M57","v":0}]
[null,null,{"$f":"SOURCES!C58","v":"Other:"},{"$f":"SOURCES!D58","v":"Describe"},null,null,null,null,null,null,{"$f":"SOURCES!M58","v":0}]
[null,null,{"$f":"SOURCES!C59","v":"Other:"},{"$f":"SOURCES!D59","v":"Describe"},null,null,null,null,null,null,{"$f":"SOURCES!M59","v":0}]
[null,null,{"$f":"SOURCES!C60","v":"Other:"},{"$f":"SOURCES!D60","v":"Describe"},null,null,null,null,null,null,{"$f":"SOURCES!M60","v":0}]
[null,null,"Total Equity",null,null,null,null,null,null,null,{"$f":"+SUM(K92:K102)","v":0}]
[null,null,"Total Sources of Funds (must equal Total Uses of Funds)",null,null,null,null,null,null,null,{"$f":"K68+K88+K103","v":0}]
[]
[]
[null,null,"USES OF FUNDS"]
[]
[null,null,"Type of Uses",null,null,null,null,null,null,null,"Amount"]
[null,null,"Construction or Rehabilitation Costs",null,null,null,null,null,null,null,{"$f":"USES!J19","v":0}]
[null,null,"Fees Related to Construction or Rehabilitation",null,null,null,null,null,null,null,{"$f":"USES!J47","v":0}]
[null,null,"Financing Fees and Charges",null,null,null,null,null,null,null,{"$f":"USES!J79","v":0}]
[null,null,"Acquisition Costs",null,null,null,null,null,null,null,{"$f":"USES!J92","v":0}]
[null,null,"Total Development Costs",null,null,null,null,null,null,null,{"$f":"+SUM(K110:K113)","v":0}]
[null,null,"Developer's Fee",null,null,null,null,null,null,null,{"$f":"USES!J101","v":0}]
[null,null,"Syndication Related Costs",null,null,null,null,null,null,null,{"$f":"USES!J116","v":2500}]
[null,null,"Guarantees and Reserves",null,null,null,null,null,null,null,{"$f":"USES!J127","v":0}]
[null,null,"Total Uses of Funds",null,null,null,null,null,null,null,{"$f":"+SUM(K114:K117)","v":2500}]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"PRO FORMA","index":10,"n_rows":62,"n_cols":25,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,1,3],[40,2,40,3]]}
[]
[null,null,"20-YEAR OPERATING  PRO FORMA:",null,null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0},null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"},null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
[null,null,"Income"]
[null,null,{"$f":"INCOME!C8","v":"Low-Income Units"},null,{"$f":"SUMMARY!H31","v":0},{"$f":"E7+(SUMMARY!J31*E7)","v":0},{"$f":"F7+(F7*SUMMARY!$J31)","v":0},{"$f":"G7+(G7*SUMMARY!$J31)","v":0},{"$f":"H7+(H7*SUMMARY!$J31)","v":0},{"$f":"I7+(I7*SUMMARY!$J31)","v":0},{"$f":"J7+(J7*SUMMARY!$J31)","v":0},{"$f":"K7+(K7*SUMMARY!$J31)","v":0},{"$f":"L7+(L7*SUMMARY!$J31)","v":0},{"$f":"M7+(M7*SUMMARY!$J31)","v":0},{"$f":"N7+(N7*SUMMARY!$J31)","v":0},{"$f":"O7+(O7*SUMMARY!$J31)","v":0},{"$f":"P7+(P7*SUMMARY!$J31)","v":0},{"$f":"Q7+(Q7*SUMMARY!$J31)","v":0},{"$f":"R7+(R7*SUMMARY!$J31)","v":0},{"$f":"S7+(S7*SUMMARY!$J31)","v":0},{"$f":"T7+(T7*SUMMARY!$J31)","v":0},{"$f":"U7+(U7*SUMMARY!$J31)","v":0},{"$f":"V7+(V7*SUMMARY!$J31)","v":0},{"$f":"W7+(W7*SUMMARY!$J31)","v":0}]
[null,null,{"$f":"INCOME!C36","v":"Market Rate Units"},null,{"$f":"SUMMARY!H32","v":0},{"$f":"E8+(E8*SUMMARY!$J32)","v":0},{"$f":"F8+(F8*SUMMARY!$J32)","v":0},{"$f":"G8+(G8*SUMMARY!$J32)","v":0},{"$f":"H8+(H8*SUMMARY!$J32)","v":0},{"$f":"I8+(I8*SUMMARY!$J32)","v":0},{"$f":"J8+(J8*SUMMARY!$J32)","v":0},{"$f":"K8+(K8*SUMMARY!$J32)","v":0},{"$f":"L8+(L8*SUMMARY!$J32)","v":0},{"$f":"M8+(M8*SUMMARY!$J32)","v":0},{"$f":"N8+(N8*SUMMARY!$J32)","v":0},{"$f":"O8+(O8*SUMMARY!$J32)","v":0},{"$f":"P8+(P8*SUMMARY!$J32)","v":0},{"$f":"Q8+(Q8*SUMMARY!$J32)","v":0},{"$f":"R8+(R8*SUMMARY!$J32)","v":0},{"$f":"S8+(S8*SUMMARY!$J32)","v":0},{"$f":"T8+(T8*SUMMARY!$J32)","v":0},{"$f":"U8+(U8*SUMMARY!$J32)","v":0},{"$f":"V8+(V8*SUMMARY!$J32)","v":0},{"$f":"W8+(W8*SUMMARY!$J32)","v":0}]
[null,null,"Nonresidential",null,{"$f":"SUMMARY!H33","v":0},{"$f":"E9+(E9*SUMMARY!$J33)","v":0},{"$f":"F9+(F9*SUMMARY!$J33)","v":0},{"$f":"G9+(G9*SUMMARY!$J33)","v":0},{"$f":"H9+(H9*SUMMARY!$J33)","v":0},{"$f":"I9+(I9*SUMMARY!$J33)","v":0},{"$f":"J9+(J9*SUMMARY!$J33)","v":0},{"$f":"K9+(K9*SUMMARY!$J33)","v":0},{"$f":"L9+(L9*SUMMARY!$J33)","v":0},{"$f":"M9+(M9*SUMMARY!$J33)","v":0},{"$f":"N9+(N9*SUMMARY!$J33)","v":0},{"$f":"O9+(O9*SUMMARY!$J33)","v":0},{"$f":"P9+(P9*SUMMARY!$J33)","v":0},{"$f":"Q9+(Q9*SUMMARY!$J33)","v":0},{"$f":"R9+(R9*SUMMARY!$J33)","v":0},{"$f":"S9+(S9*SUMMARY!$J33)","v":0},{"$f":"T9+(T9*SUMMARY!$J33)","v":0},{"$f":"U9+(U9*SUMMARY!$J33)","v":0},{"$f":"V9+(V9*SUMMARY!$J33)","v":0},{"$f":"W9+(W9*SUMMARY!$J33)","v":0}]
[null,null,{"$f":"INCOME!C66","v":"Commercial Income"},null,{"$f":"SUMMARY!H34","v":0},{"$f":"E10+(E10*SUMMARY!$J34)","v":0},{"$f":"F10+(F10*SUMMARY!$J34)","v":0},{"$f":"G10+(G10*SUMMARY!$J34)","v":0},{"$f":"H10+(H10*SUMMARY!$J34)","v":0},{"$f":"I10+(I10*SUMMARY!$J34)","v":0},{"$f":"J10+(J10*SUMMARY!$J34)","v":0},{"$f":"K10+(K10*SUMMARY!$J34)","v":0},{"$f":"L10+(L10*SUMMARY!$J34)","v":0},{"$f":"M10+(M10*SUMMARY!$J34)","v":0},{"$f":"N10+(N10*SUMMARY!$J34)","v":0},{"$f":"O10+(O10*SUMMARY!$J34)","v":0},{"$f":"P10+(P10*SUMMARY!$J34)","v":0},{"$f":"Q10+(Q10*SUMMARY!$J34)","v":0},{"$f":"R10+(R10*SUMMARY!$J34)","v":0},{"$f":"S10+(S10*SUMMARY!$J34)","v":0},{"$f":"T10+(T10*SUMMARY!$J34)","v":0},{"$f":"U10+(U10*SUMMARY!$J34)","v":0},{"$f":"V10+(V10*SUMMARY!$J34)","v":0},{"$f":"W10+(W10*SUMMARY!$J34)","v":0}]
[null,null,"Gross Project Income",null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Vacancy Allowances",null,{"$f":"(E7*-INCOME!$I33)+(E8*-INCOME!$G52)+(E9*-INCOME!$I69)+('PRO FORMA'!E10*-INCOME!$I71)","v":0},{"$f":"(F7*-INCOME!$I33)+(F8*-INCOME!$G52)+(F9*-INCOME!$I69)+('PRO FORMA'!F10*-INCOME!$I71)","v":0},{"$f":"(G7*-INCOME!$I33)+(G8*-INCOME!$G52)+(G9*-INCOME!$I69)+('PRO FORMA'!G10*-INCOME!$I71)","v":0},{"$f":"(H7*-INCOME!$I33)+(H8*-INCOME!$G52)+(H9*-INCOME!$I69)+('PRO FORMA'!H10*-INCOME!$I71)","v":0},{"$f":"(I7*-INCOME!$I33)+(I8*-INCOME!$G52)+(I9*-INCOME!$I69)+('PRO FORMA'!I10*-INCOME!$I71)","v":0},{"$f":"(J7*-INCOME!$I33)+(J8*-INCOME!$G52)+(J9*-INCOME!$I69)+('PRO FORMA'!J10*-INCOME!$I71)","v":0},{"$f":"(K7*-INCOME!$I33)+(K8*-INCOME!$G52)+(K9*-INCOME!$I69)+('PRO FORMA'!K10*-INCOME!$I71)","v":0},{"$f":"(L7*-INCOME!$I33)+(L8*-INCOME!$G52)+(L9*-INCOME!$I69)+('PRO FORMA'!L10*-INCOME!$I71)","v":0},{"$f":"(M7*-INCOME!$I33)+(M8*-INCOME!$G52)+(M9*-INCOME!$I69)+('PRO FORMA'!M10*-INCOME!$I71)","v":0},{"$f":"(N7*-INCOME!$I33)+(N8*-INCOME!$G52)+(N9*-INCOME!$I69)+('PRO FORMA'!N10*-INCOME!$I71)","v":0},{"$f":"(O7*-INCOME!$I33)+(O8*-INCOME!$G52)+(O9*-INCOME!$I69)+('PRO FORMA'!O10*-INCOME!$I71)","v":0},{"$f":"(P7*-INCOME!$I33)+(P8*-INCOME!$G52)+(P9*-INCOME!$I69)+('PRO FORMA'!P10*-INCOME!$I71)","v":0},{"$f":"(Q7*-INCOME!$I33)+(Q8*-INCOME!$G52)+(Q9*-INCOME!$I69)+('PRO FORMA'!Q10*-INCOME!$I71)","v":0},{"$f":"(R7*-INCOME!$I33)+(R8*-INCOME!$G52)+(R9*-INCOME!$I69)+('PRO FORMA'!R10*-INCOME!$I71)","v":0},{"$f":"(S7*-INCOME!$I33)+(S8*-INCOME!$G52)+(S9*-INCOME!$I69)+('PRO FORMA'!S10*-INCOME!$I71)","v":0},{"$f":"(T7*-INCOME!$I33)+(T8*-INCOME!$G52)+(T9*-INCOME!$I69)+('PRO FORMA'!T10*-INCOME!$I71)","v":0},{"$f":"(U7*-INCOME!$I33)+(U8*-INCOME!$G52)+(U9*-INCOME!$I69)+('PRO FORMA'!U10*-INCOME!$I71)","v":0},{"$f":"(V7*-INCOME!$I33)+(V8*-INCOME!$G52)+(V9*-INCOME!$I69)+('PRO FORMA'!V10*-INCOME!$I71)","v":0},{"$f":"(W7*-INCOME!$I33)+(W8*-INCOME!$G52)+(W9*-INCOME!$I69)+('PRO FORMA'!W10*-INCOME!$I71)","v":0},{"$f":"(X7*-INCOME!$I33)+(X8*-INCOME!$G52)+(X9*-INCOME!$I69)+('PRO FORMA'!X10*-INCOME!$I71)","v":0}]
[null,null,"Effective Gross Income",null,{"$f":"E11+SUM(E12:E12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Expenses"]
[null,null,"Administrative",null,{"$f":"SUMMARY!H42","v":0},{"$f":"E16+(E16*SUMMARY!$J42)","v":0},{"$f":"F16+(F16*SUMMARY!$J42)","v":0},{"$f":"G16+(G16*SUMMARY!$J42)","v":0},{"$f":"H16+(H16*SUMMARY!$J42)","v":0},{"$f":"I16+(I16*SUMMARY!$J42)","v":0},{"$f":"J16+(J16*SUMMARY!$J42)","v":0},{"$f":"K16+(K16*SUMMARY!$J42)","v":0},{"$f":"L16+(L16*SUMMARY!$J42)","v":0},{"$f":"M16+(M16*SUMMARY!$J42)","v":0},{"$f":"N16+(N16*SUMMARY!$J42)","v":0},{"$f":"O16+(O16*SUMMARY!$J42)","v":0},{"$f":"P16+(P16*SUMMARY!$J42)","v":0},{"$f":"Q16+(Q16*SUMMARY!$J42)","v":0},{"$f":"R16+(R16*SUMMARY!$J42)","v":0},{"$f":"S16+(S16*SUMMARY!$J42)","v":0},{"$f":"T16+(T16*SUMMARY!$J42)","v":0},{"$f":"U16+(U16*SUMMARY!$J42)","v":0},{"$f":"V16+(V16*SUMMARY!$J42)","v":0},{"$f":"W16+(W16*SUMMARY!$J42)","v":0}]
[null,null,"Management Fee",null,{"$f":"SUMMARY!H43","v":0},{"$f":"'PRO FORMA'!F13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!G13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!H13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!I13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!J13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!K13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!L13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!M13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!N13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!O13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!P13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!Q13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!R13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!S13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!T13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!U13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!V13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!W13*EXPENSES!$H13","v":0},{"$f":"'PRO FORMA'!X13*EXPENSES!$H13","v":0}]
[null,null,"Utilities",null,{"$f":"SUMMARY!H44","v":0},{"$f":"E18+(E18*SUMMARY!$J44)","v":0},{"$f":"F18+(F18*SUMMARY!$J44)","v":0},{"$f":"G18+(G18*SUMMARY!$J44)","v":0},{"$f":"H18+(H18*SUMMARY!$J44)","v":0},{"$f":"I18+(I18*SUMMARY!$J44)","v":0},{"$f":"J18+(J18*SUMMARY!$J44)","v":0},{"$f":"K18+(K18*SUMMARY!$J44)","v":0},{"$f":"L18+(L18*SUMMARY!$J44)","v":0},{"$f":"M18+(M18*SUMMARY!$J44)","v":0},{"$f":"N18+(N18*SUMMARY!$J44)","v":0},{"$f":"O18+(O18*SUMMARY!$J44)","v":0},{"$f":"P18+(P18*SUMMARY!$J44)","v":0},{"$f":"Q18+(Q18*SUMMARY!$J44)","v":0},{"$f":"R18+(R18*SUMMARY!$J44)","v":0},{"$f":"S18+(S18*SUMMARY!$J44)","v":0},{"$f":"T18+(T18*SUMMARY!$J44)","v":0},{"$f":"U18+(U18*SUMMARY!$J44)","v":0},{"$f":"V18+(V18*SUMMARY!$J44)","v":0},{"$f":"W18+(W18*SUMMARY!$J44)","v":0}]
[null,null,"Maintenance",null,{"$f":"SUMMARY!H45","v":0},{"$f":"E19+(E19*SUMMARY!$J45)","v":0},{"$f":"F19+(F19*SUMMARY!$J45)","v":0},{"$f":"G19+(G19*SUMMARY!$J45)","v":0},{"$f":"H19+(H19*SUMMARY!$J45)","v":0},{"$f":"I19+(I19*SUMMARY!$J45)","v":0},{"$f":"J19+(J19*SUMMARY!$J45)","v":0},{"$f":"K19+(K19*SUMMARY!$J45)","v":0},{"$f":"L19+(L19*SUMMARY!$J45)","v":0},{"$f":"M19+(M19*SUMMARY!$J45)","v":0},{"$f":"N19+(N19*SUMMARY!$J45)","v":0},{"$f":"O19+(O19*SUMMARY!$J45)","v":0},{"$f":"P19+(P19*SUMMARY!$J45)","v":0},{"$f":"Q19+(Q19*SUMMARY!$J45)","v":0},{"$f":"R19+(R19*SUMMARY!$J45)","v":0},{"$f":"S19+(S19*SUMMARY!$J45)","v":0},{"$f":"T19+(T19*SUMMARY!$J45)","v":0},{"$f":"U19+(U19*SUMMARY!$J45)","v":0},{"$f":"V19+(V19*SUMMARY!$J45)","v":0},{"$f":"W19+(W19*SUMMARY!$J45)","v":0}]
[null,null,"Taxes and Insurance",null,{"$f":"EXPENSES!K69","v":0},{"$f":"E20+(E20*SUMMARY!$J46)","v":0},{"$f":"F20+(F20*SUMMARY!$J46)","v":0},{"$f":"G20+(G20*SUMMARY!$J46)","v":0},{"$f":"H20+(H20*SUMMARY!$J46)","v":0},{"$f":"I20+(I20*SUMMARY!$J46)","v":0},{"$f":"J20+(J20*SUMMARY!$J46)","v":0},{"$f":"K20+(K20*SUMMARY!$J46)","v":0},{"$f":"L20+(L20*SUMMARY!$J46)","v":0},{"$f":"M20+(M20*SUMMARY!$J46)","v":0},{"$f":"N20+(N20*SUMMARY!$J46)","v":0},{"$f":"O20+(O20*SUMMARY!$J46)","v":0},{"$f":"P20+(P20*SUMMARY!$J46)","v":0},{"$f":"Q20+(Q20*SUMMARY!$J46)","v":0},{"$f":"R20+(R20*SUMMARY!$J46)","v":0},{"$f":"S20+(S20*SUMMARY!$J46)","v":0},{"$f":"T20+(T20*SUMMARY!$J46)","v":0},{"$f":"U20+(U20*SUMMARY!$J46)","v":0},{"$f":"V20+(V20*SUMMARY!$J46)","v":0},{"$f":"W20+(W20*SUMMARY!$J46)","v":0}]
[null,null,"Replacement Reserve",null,{"$f":"SUMMARY!H47","v":0},{"$f":"E21+(E21*SUMMARY!$J47)","v":0},{"$f":"F21+(F21*SUMMARY!$J47)","v":0},{"$f":"G21+(G21*SUMMARY!$J47)","v":0},{"$f":"H21+(H21*SUMMARY!$J47)","v":0},{"$f":"I21+(I21*SUMMARY!$J47)","v":0},{"$f":"J21+(J21*SUMMARY!$J47)","v":0},{"$f":"K21+(K21*SUMMARY!$J47)","v":0},{"$f":"L21+(L21*SUMMARY!$J47)","v":0},{"$f":"M21+(M21*SUMMARY!$J47)","v":0},{"$f":"N21+(N21*SUMMARY!$J47)","v":0},{"$f":"O21+(O21*SUMMARY!$J47)","v":0},{"$f":"P21+(P21*SUMMARY!$J47)","v":0},{"$f":"Q21+(Q21*SUMMARY!$J47)","v":0},{"$f":"R21+(R21*SUMMARY!$J47)","v":0},{"$f":"S21+(S21*SUMMARY!$J47)","v":0},{"$f":"T21+(T21*SUMMARY!$J47)","v":0},{"$f":"U21+(U21*SUMMARY!$J47)","v":0},{"$f":"V21+(V21*SUMMARY!$J47)","v":0},{"$f":"W21+(W21*SUMMARY!$J47)","v":0}]
[null,null,"Total Expenses",null,{"$f":"SUM(E16:E21)","v":0},{"$f":"+SUM(F16:F21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Net Operating Income",null,{"$f":"E13-E22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Debt Service Financing"]
[null,null,{"$f":"SOURCES!C12","v":"Taxable Bonds"},null,{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0},{"$f":"SOURCES!$I12","v":0}]
[null,null,{"$f":"SOURCES!C13","v":"Tax-exempt Bonds (Long Term Only) "},null,{"$f":"SOURCES!$I13","v":0},{"$f":"E27","v":0},{"$f":"F27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C15","v":"FHA MIP"},null,{"$f":"SOURCES!$I15","v":0},{"$f":"E28","v":0},{"$f":"F28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C14","v":"Private Loan"},null,{"$f":"SOURCES!$I14","v":0},{"$f":"E29","v":0},{"$f":"F29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C16","v":"Rental Housing Program Funds"},null,{"$f":"SOURCES!$I16","v":0},0,{"$f":"F30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C17","v":"HOME "},null,{"$f":"SOURCES!$I17","v":0},0,{"$f":"F31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C18","v":"HOME (non-DHCD)"},null,{"$f":"SOURCES!$I18","v":0},0,{"$f":"F32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C19","v":"Other:"},{"$f":"SOURCES!D19","v":"Describe"},{"$f":"SOURCES!$I19","v":0},0,{"$f":"F33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SOURCES!C20","v":"Other:"},{"$f":"SOURCES!D20","v":"Describe"},{"$f":"SOURCES!$I20","v":0},0,{"$f":"F34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total Debt Service",null,{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0},{"$f":"SOURCES!$I22","v":0}]
[null,null,"Cash Flow",null,{"$f":"(E23-E36)","v":0},{"$f":"F23-F36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Debt Coverage Ratio",null,{"$f":"IF(E23=0,\"\",E23/E36)","v":""},"","","","","","","","","","","","","","","","","","",""]
[]
[null,null,"Cash Flow Financing"]
[null,null,"Investor Services Fee          (max $3,000)"]
[]
[null,null,null,"Enter % of CF"]
[null,null,"Deferred Developer's Fee",{"$f":"F58","v":0.25},{"$f":"(E37-E41)*$D$44","v":0},{"$f":"(F37-F41)*$D$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SOURCES!M53-SUM(E44:R44)","v":0},{"$f":"(T37-T41)*$H$58","v":0},{"$f":"(U37-U41)*$H$58","v":0},{"$f":"(V37-V41)*$H$58","v":0},{"$f":"(W37-W41)*$H$58","v":0},{"$f":"(X37-X41)*$H$58","v":0}]
[]
[null,null,"CDA Subordinate Debt",{"$f":"F59","v":0.75},{"$f":"(E37-E41)*$D$46","v":0},{"$f":"(F37-F41)*$D$46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(T37-T41)*$H$59","v":0},{"$f":"(U37-U41)*$H$59","v":0},{"$f":"(V37-V41)*$H$59","v":0},{"$f":"(W37-W41)*$H$59","v":0},{"$f":"(X37-X41)*$H$59","v":0},{"$f":"H59","v":0.75}]
[]
[null,null,"Other Gov't Lender: ",{"$f":"F60","v":0},{"$f":"(E37-E41)*$D$48","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(T37-T41)*$H$60","v":0},{"$f":"(U37-U41)*$H$60","v":0},{"$f":"(V37-V41)*$H$60","v":0},{"$f":"(W37-W41)*$H$60","v":0},{"$f":"(X37-X41)*$H$60","v":0}]
[]
[null,null,"Total Cash Flow Debt",null,{"$f":"SUM(E41:E48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Remaining Cash Flow",null,{"$f":"+E37-E50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Debt Coverage Ratio",null,{"$f":"IF(E23=0,\"\",E23/(E36+E50))","v":""},"","","","","","","","","","","","","","","","","","",""]
[]
[]
[null,null,null,null,null,"Years 1 - 15   ",null,"Years 16+",null,"DDF",{"$f":"SOURCES!M53","v":0}]
[null,null,null,null,null,"- OR - ",null,"- OR - ",null,"YR15 *",{"$f":"SUM(E44:S44)","v":0},"* Year-15 or earlier if deferred developer fee is repaid; no later than year-15."]
[null,null,null,null,null,"During DDF Period",null,"Post DDF Period"]
[null,null,null,null,"Deferred Developer Fee ",0.25]
[null,null,null,null,"DHCD Loans ",0.75,null,0.75]
[null,null,null,null,"Local Gov't ",0,null,{"$f":"F60","v":0}]
[null,null,null,null,"Remaining Cash Flow ",null,null,{"$f":"1-H59-H60","v":0.25}]
[null,null,null,null,null,{"$f":"SUM(F58:F61)","v":1},null,{"$f":"SUM(H58:H61)","v":1}]

{"sheet":"CURR FIN INFO","index":11,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Current Financing Information"]
[null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"Existing Debt on the Property:"]
[null,null,"Lien Position","Mortgage","Loan Product","Approximate Balance","Loan Number","Credit Enhancement"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,""]
[null,null,"Total Existing Debt:",null,null,{"$f":"SUM(F8:F15)","v":0}]

{"sheet":"FIN CAP","index":12,"n_rows":86,"n_cols":12,"rows_kept":86,"cut":false,"hidden":false,"merged":[[69,3,69,6],[5,3,5,6],[6,3,6,6],[14,3,14,6],[29,3,29,6],[45,3,45,6],[53,3,53,6]]}
[]
[null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[null,null,null,null,null,null,{"$f":"projname","v":0}]
[]
[null,null,"Developer Financial Capacity ( Sec. 4.1.3 Guide)"]
[null,null,null,"The developer entities and guarantors must have an acceptable credit history and show the current financial to undertake the project."]
[null,null,null,"Net Worth (Developer/Sponsor/General Partner/Managing Member) as a Percentage of Total Development Costs"]
[null,null,null,"Entity","Developer","Co-Developer","2nd Co-Developer"]
[null,null,null,"Date of audited financials","Date","Date","Date"]
[null,null,null,"Total Assets"]
[null,null,null,"Total Liabilities"]
[null,null,null,"Net Worth",{"$f":"E10-E11","v":0},{"$f":"F10-F11","v":0},{"$f":"G10-G11","v":0}]
[null,null,null,"Total Dev Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E13=0,\"\",(E12/E13))","v":""},{"$f":"IF(F13=0,\"\",(F12/F13))","v":""},{"$f":"IF(G13=0,\"\",(G12/G13))","v":""}]
[null,null,null,"Net Worth (Developer/Sponsor/General Partner/Managing Member) as a Percentage of Total Development Costs"]
[null,null,null,"Entity","General Partner","Managing Member","TOTAL"]
[null,null,null,"Date of audited financials","Date","Date"]
[null,null,null,"Total Assets",null,null,{"$f":"E10+F10+G10+E18+F18","v":0}]
[null,null,null,"Total Liabilities",null,null,{"$f":"E11+F11+G11+E19+F19","v":0}]
[null,null,null,"Net Worth",{"$f":"E18-E19","v":0},{"$f":"F18-F19","v":0},{"$f":"E12+F12+G12+F20+E20","v":0}]
[null,null,null,"Total Dev Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E21=0,\"\",(E20/E21))","v":""},{"$f":"IF(F21=0,\"\",(F20/F21))","v":""},{"$f":"IF(G21=0,\"\",(G20/G21))","v":""},null,null,null,0.25]
[]
[null,null,null,null,null,{"$f":"MAX(H26:H28)","v":0}," Points"]
[null,null,"Pts.","Range"]
[null,null,0,"Combined net worth is less than 10% of Total Development Costs (TDC)",null,null,null,{"$f":"-IF(G22<10%,0,0)","v":0},null,null,null,{"$f":"-IF(K22<10%,0,0)","v":0}]
[null,null,1,"Combined net worth is less than 25% but at least 10% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G22>=10%,G22<25%),1,0)","v":0},null,null,null,{"$f":"IF(AND(K22>=10%,K22<25%),1,0)","v":0}]
[null,null,2,"Combined net worth is over 25% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G22>25%,G22<100000000%),2,0)","v":0},null,null,null,{"$f":"IF(AND(K22>25%,K22<100000000%),2,0)","v":0}]
[]
[null,null,null,"Net Worth (net assets for nonprofit organizations) of the Guarantor as a Percentage of Total Development Costs"]
[null,null,null,"Entity","Guarantor: ","Insert Name                  (if applicable)","TOTAL"]
[null,null,null,"Date of audited financials","Date","Date"]
[null,null,null,"Total Assets",null,null,{"$f":"SUM(E33:F33)","v":0}]
[null,null,null,"Total Liabilities",null,null,{"$f":"SUM(E34:F34)","v":0}]
[null,null,null,"Net Worth",{"$f":"E33-E34","v":0},{"$f":"F33-F34","v":0},{"$f":"SUM(E35:F35)","v":0}]
[null,null,null,"Total Dev Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E36=0,\"\",(E35/E36))","v":""},{"$f":"IF(F36=0,\"\",(F35/F36))","v":""},{"$f":"IF(G36=0,\"\",(G35/G36))","v":""},null,null,null,0.25]
[]
[null,null,null,null,null,{"$f":"MAX(H41:H43)","v":0}," Points"]
[null,null,"Pts.","Range"]
[null,null,0,"Combined net worth is less than 10% of Total Development Costs (TDC)",null,null,null,{"$f":"-IF(G37<10%,0,0)","v":0},null,null,null,{"$f":"-IF(K37<10%,0,0)","v":0}]
[null,null,3,"Combined net worth is less than 25% but at least 10% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G37>=10%,G37<25%),3,0)","v":0},null,null,null,{"$f":"IF(AND(K37>=10%,K37<25%),3,0)","v":0}]
[null,null,6,"Combined net worth is 25% or greater of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G37>25%,G37<100000000%),6,0)","v":0},null,null,null,{"$f":"IF(AND(K37>25%,K37<100000000%),6,0)","v":0}]
[]
[]
[null,null,null,"Liquid Assets (Developer/Sponsor/General Partner/Managing Member) as Percentage of Total Development Costs"]
[null,null,null,"Entity",{"$f":"E8","v":"Developer"},"Co-Developer","2nd Co-Developer"]
[null,null,null,"Date of audited financials","Date","Date","Date"]
[null,null,null,"Current Assets"]
[null,null,null,"Current Liabilities"]
[null,null,null,"Working Capital",{"$f":"E49-E50","v":0},{"$f":"F49-F50","v":0},{"$f":"G49-G50","v":0}]
[null,null,null,"Total Dev. Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E52=0,\"\",(E51/E52))","v":""},{"$f":"IF(F52=0,\"\",(F51/F52))","v":""},{"$f":"IF(G52=0,\"\",(G51/G52))","v":""}]
[null,null,null,"Liquid Assets (Developer/Sponsor/General Partner/Managing Member) as Percentage of Total Development Costs"]
[null,null,null,"Entity",{"$f":"E16","v":"General Partner"},{"$f":"F16","v":"Managing Member"},"TOTAL"]
[null,null,null,"Date of audited financials",{"$f":"E17","v":"Date"},{"$f":"F17","v":"Date"}]
[null,null,null,"Current Assets",null,null,{"$f":"E49+F49+G49+E57+F57","v":0}]
[null,null,null,"Current Liabilities",null,null,{"$f":"E50+F50+G50+E58+F58","v":0}]
[null,null,null,"Working Capital",{"$f":"E57-E58","v":0},{"$f":"F57-F58","v":0},{"$f":"E51+F51+G51+E59+F59","v":0}]
[null,null,null,"Total Dev. Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E60=0,\"\",(E59/E60))","v":""},{"$f":"IF(F60=0,\"\",(F59/F60))","v":""},{"$f":"IF(G60=0,\"\",(G59/G60))","v":""},null,null,null,0.10100000000000001]
[]
[null,null,null,null,null,{"$f":"MAX(H65:H68)","v":0}," Points"]
[null,null,"Pts.","Range"]
[null,null,0,"Combined liquid assets are under 2% of Total Development Costs (TDC)",null,null,null,{"$f":"-IF(G61<2%,0,0)","v":0},null,null,null,{"$f":"-IF(K61<2%,0,0)","v":0}]
[null,null,1,"Combined liquid assets are between 2% and 4% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G61>=2%,G61<=4%),1, 0)","v":0},null,null,null,{"$f":"IF(AND(K61>=2%,K61<=4%),1, 0)","v":0}]
[null,null,2,"Combined liquid assets are over 4% but less than 10% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G61>4%,G61<10%),2,0)","v":0},null,null,null,{"$f":"IF(AND(K61>4%,K61<10%),2,0)","v":0}]
[null,null,2.5,"Combined liquid assets are 10% or greater of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G61>10%,G61<100000000%),2.5,0)","v":0},null,null,null,{"$f":"IF(AND(K61>10%,K61<100000000%),2.5,0)","v":2.5}]
[]
[null,null,null,"Liquid Assets (Guarantor) as Percentage of Total Development Costs"]
[null,null,null,"Entity",{"$f":"E31","v":"Guarantor: "},{"$f":"F31","v":"Insert Name                  (if applicable)"},"TOTAL"]
[null,null,null,"Date of audited financials","Date","Date"]
[null,null,null,"Current Assets",null,null,{"$f":"SUM(E73:F73)","v":0}]
[null,null,null,"Current Liabilities",null,null,{"$f":"SUM(E74:F74)","v":0}]
[null,null,null,"Working Capital",{"$f":"E73-E74","v":0},{"$f":"F73-F74","v":0},{"$f":"SUM(E75:F75)","v":0}]
[null,null,null,"Total Dev Costs",{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0},{"$f":"USES!$J$93","v":0}]
[null,null,null,"Percent of TDC",{"$f":"IF(E76=0,\"\",(E75/E76))","v":""},{"$f":"IF(F76=0,\"\",(F75/F76))","v":""},{"$f":"IF(G76=0,\"\",(G75/G76))","v":""},null,null,null,0.1]
[]
[null,null,null,null,null,{"$f":"MAX(H81:H84)","v":0}," Points"]
[null,null,"Pts.","Range"]
[null,null,0,"Combined liquid assets are under 2% of Total Development Costs (TDC)",null,null,null,{"$f":"-IF(G77<2%,0,0)","v":0},null,null,null,{"$f":"-IF(K77<2%,0,0)","v":0}]
[null,null,3,"Combined liquid assets are between 2% and 4% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G77>2%,G77<4%),3, 0)","v":0},null,null,null,{"$f":"IF(AND(K77>2%,K77<4%),3, 0)","v":0}]
[null,null,6,"Combined liquid assets are between 4% and 10% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G77>4%,G77<10%),6, 0)","v":0},null,null,null,{"$f":"IF(AND(K77>4%,K77<10%),6, 0)","v":0}]
[null,null,7.5,"Combined liquid assets are over 10% of Total Development Costs (TDC)",null,null,null,{"$f":"IF(AND(G77>10%,G77<100000000%),7.5,0)","v":0},null,null,null,{"$f":"IF(AND(K77>10%,K77<100000000%),7.5,0)","v":0}]
[]
[null,null,null,null,null,{"$f":"F24+F39+F63+F79","v":0}," Total Score"]

{"sheet":"INCOME TARGETING","index":13,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[10,2,10,9],[12,8,13,9],[35,2,35,9],[12,2,12,3],[17,2,17,3],[18,2,18,3],[11,2,11,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[19,2,19,3],[14,8,16,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[8,2,8,9],[9,2,9,9]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"INCOME TARGETING  (Section 4.4.1 of the Guide)"]
[null,null,"The low-income units in the project must be rented to families with incomes that do not exceed the levels required under the proposed funding source.  To the extent that restricted units will be rented to families with incomes below 60% of the area median income, more points will be awarded. "]
[null,null,"Up to ten (10) points will be awarded to any project based on the weighted average of area median income targeting by bedroom in a project. For the purposes of this calculation, the lowest income level used will be 20% AMI.  SRO and efficiency units will be counted as 0.67 bedrooms, and all weighted averages will be rounded to the nearest full percentage point. To calculate the weighted average, use the following process: "]
[null,null,"1. Determine the number of income-restricted bedrooms serving each percentage of the AMI by multiplying the number of units of a given size by the number of bedrooms per unit. "]
[null,null,"2. Multiply each income-restricted bedroom by the maximum income target and add the sum of those totals together. "]
[null,null,"3. Divide the result by the total number of income restricted bedrooms and round to the nearest one hundredth of a percentage point to determine the weighted average. "]
[null,null,"Note: units restricted at 20% exclude PBV, PBRA contracts, and federal rental assistance programs that serve households at or below 30% AMI"]
[null,null,"Total BRs at each Targeted Inc. Level",null,null,"Proposed %   of Median Income","Weighted Bedrooms"]
[null,null,{"$f":"0*0.67+0*1+0*2+0*3+0*4","v":0},"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.2,{"$f":"C13*F13","v":0},null,"Formula to use for Column C amounts"]
[null,null,0,"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.3,0]
[null,null,0,"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.4,0,null,"= 0BR*0.67 +1BR*1 +2BR*2 +3BR*3 +4BR*4"]
[null,null,0,"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.5,0]
[null,null,0,"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.6,0]
[null,null,{"$f":"0*0.67+0*1+0*2+0*3+0*4","v":0},"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.7,0]
[null,null,{"$f":"0*0.67+0*1+0*2+0*3+0*4","v":0},"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,0.8,0,null,"Total Affordable BRs",{"$f":"SUM(C13:C19)","v":0}]
[null,null,0,"=Summary!D13*0.67+(Summary!D14+Summary!D15)*2+Summary!D16*3+Summary!D17*4",null,"Market Rate",null,null,"Market BRs",{"$f":"C20","v":0}]
[null,null,null,null,null,"Total Weighted BRs / Total # Affordable BRs =",{"$f":"SUM(G13:G19)/J19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total BRs",{"$f":"SUM(J19:J20)","v":0}]
[null,null,"Points","Av. AMI - All Other Projects",null,"Points","Av. AMI - All Other Projects"]
[null,null,10,"32.00% or below"]
[null,null,9.5,"32.01% to 33.50%",null,4.5,"47.01% to 48.50%"]
[null,null,9,"33.51% to 35.00%",null,4,"48.51% to 50.00%"]
[null,null,8.5,"35.01% to 36.50%",null,3.5,"50.01% to 51.00%"]
[null,null,8,"36.51% to 38.00%",null,3,"51.01% to 52.00%"]
[null,null,7.5,"38.01% to 39.50%",null,2.5,"52.01% to 53.00%"]
[null,null,7,"39.51% to 41.00%",null,2,"53.01% to 54.00%"]
[null,null,6.5,"41.01% to 42.50%",null,1.5,"54.01% to 54.50%"]
[null,null,6,"42.51% to 44.00%",null,1,"54.51% to 55.00%"]
[null,null,5.5,"44.01% to 45.50%",null,0.5,"55.01% to 55.50%"]
[null,null,5,"45.51% to 47.00%",null,0,"55.51% or greater",null,null," Points"]
[]
[null,null,"A project will receive five (5) points if at least 10% of the income-restricted units in the project will be income-restricted at 30% of the area median or below for the LIHTC compliance period (including the extended use period). These points are available (1) if the project rent restricts those units at the 30% area median income level for the compliance period or (2) for units supported by the award of a project-based housing choice voucher contract (or a DHCD approved equivalent form of project-based assistance) with a term of fifteen (15) years or more. DHCD will consider project-based housing choice vouchers awarded through a recognized mobility program in awarding points in this section. For initial lease-up, project-based voucher units will be considered 30% units for the purposes of income targeting."]
[null,null,null,"30% Units"]
[null,null,null,"Total Income Restricted Units",null,{"$f":"INCOME!F32","v":0}]
[null,null,null,"Percentage",null,{"$f":"IF(F37=0,0,F37/F38)","v":0}]
[]
[null,null,null,"Points = ",null,{"$f":"IF(F39=0,0,IF(F39<10.5,5,0))","v":0}]
[]
[]
[null,null,null,"TOTAL SCORE =",null,{"$f":"F41+I34","v":0}]

{"sheet":"LEV & COST EFFECTIVENESS","index":14,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[7,12,8,12],[6,8,6,11],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[11,1,11,3],[26,1,26,3],[27,1,27,4],[30,1,30,4],[19,8,20,8],[24,8,26,12]]}
[]
[null,"LEVERAGING AND COST EFFECTIVENESS ",null,null,null,null,null,null,"OPERATING SUBSIDIES"]
[null,null,null,null,null,null,{"$f":"projname","v":0},null,null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"},null,null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[null,"DIRECT LEVERAGING (Sec. 4.5.1 of the Guide)"]
[null,"1.  Relevant Project Scoring Characteristics ",null,null,null,null,null,null,"OPERATING SUBSIDIES (Sec. 4.5.2 of the Guide)"]
[null,"Is the project Located in QCT/DDA?  - or -  A Competitive Round Family project located in COO?",null,null,null,null,null,null,"Points are awarded to projects that include other long-term subsidies."]
[null,"Is project considered a rural transaction?",null,null,null,null,null,null,"Subsidy Type","Project Based Rental Subsidy *","PILOT **","Other","Total"]
[null,"Is the project a \"Twinning\" transaction?"]
[]
[null,"2.  Tax Credit Subsidy",null,null,null,null,null,null,"Annual Subsidy/Unit",null,null,null,{"$f":"SUM(J11:L11)","v":0}]
[null,"Combined Low Income Housing Tax Credit Eligible         (Tax Credit Tab  cell I91)",null,null,"Note: Do not include automatic 4% LIHTC",null,null,null,"Eligible Units"]
[null,"Basis Boost (If any)",null,null,null,{"$f":"IF(F7=\"yes\",F12-F12/1.3,0)","v":0},null,null,"Total Annual Subsidy",{"$f":"J11*J12","v":0},{"$f":"K11*K12","v":0},{"$f":"L11*L12","v":0},{"$f":"SUM(J13:L13)","v":0}]
[null,"Tax Credit less Basis Boost (if any)",null,null,null,{"$f":"F12-F13","v":0},null,null,"Term (Years) *",10,null,0]
[null,"Credit Period",null,null,null,10,null,null,"Total Subsidy",{"$f":"J13*J14","v":0},{"$f":"K13*K14","v":0},{"$f":"L13*L14","v":0},{"$f":"SUM(J15:L15)","v":0}]
[null,"Imputed Raise-Up",null,null,null,0.91,null,null,"Total Affordable/Units in Project **",{"$f":"INCOME!F32","v":0},{"$f":"$J$16","v":0},{"$f":"$J$16","v":0},{"$f":"$J$16","v":0}]
[null,"Imputed Equity",null,null,null,{"$f":"F14*F15*F16","v":0},null,null,"Subsidy/Unit/10 Yrs.",{"$f":"IF(J16=0,\"\",(J15/J16/10))","v":""},{"$f":"IF(K16=0,\"\",(K15/K16/10))","v":""},{"$f":"IF(L16=0,\"\",(L15/L16/10))","v":""},{"$f":"SUM(J17:L17)","v":0}]
[null,"Final Adjusted LIHTC Subsidy",null,null,null,{"$f":"F17","v":0},null,null,null,"* Minimum 10-year term",null,"* Minimum 10-year term"]
[null,null,null,null,null,null,null,null,null,null,"** 15-year maximum re: point scoring"]
[null,"3.  Total DHCD Non-LIHTC Capital Subsidy",null,null,null,null,null,null,"Is this Project located in and Entitlement Jurisdiction?"]
[null,{"$f":"SOURCES!C28","v":"Rental Housing Program Funds"},null,null,null,{"$f":"SOURCES!M28","v":0}]
[null,{"$f":"SOURCES!C29","v":"Rental Housing Works"},null,null,null,{"$f":"SOURCES!M29","v":0},null,null,"Yes",null,null,null,null,{"$f":"IF(IF(I22=\"YES\",((M17/600)*10),((M17/300)*10))<=10,IF(I22=\"YES\",((M17/600)*10),((M17/300)*10)),10)","v":0}]
[null,{"$f":"SOURCES!C30","v":"Housing Trust Funds"},null,null,null,{"$f":"SOURCES!M30","v":0}]
[null,{"$f":"SOURCES!C31","v":"HOME Funds"},null,null,null,{"$f":"SOURCES!M31","v":0}]
[null,{"$f":"SOURCES!C33","v":"HOME ARP"},null,null,null,{"$f":"SOURCES!M33","v":0},null,null,"Maximum points may be awarded for projects with a subsidy of at least $600 per unit per year for a period of 10 years in participating jurisdictions and $300 in non-participating jurisdictions.  Fewer points will be awarded to the extent that the subsidy per unit per year is below $100, the subsidy is for a term of less than 10 years, or repayment terms of the subsidy diminish the overall value to the project."]
[null,{"$f":"SOURCES!C34","v":"Partnership Rental Housing Program Funds"},null,null,null,{"$f":"SOURCES!M34","v":0}]
[null,"Total Other DHCD Resources:                                                                                     (CDBG, Community Legacy, Strategic Demolition, etc.)",null,null,"Note: Do not include Project CORE and MBP Financing"]
[null,"Total DHCD Non-LIHTC Subsidy Funds",null,null,null,{"$f":"SUM(F21:F27)","v":0}]
[]
[null,"4.  Total DHCD Resources"]
[null,"Total of Attributed DHCD Resources",null,null,null,{"$f":"F18+F28","v":0}]
[]
[null,"5.  Adjusted Costs (Proportion of project costs attributable to affordable units.)"]
[null,"# Affordable BRs",null,null,null,{"$f":"'INCOME TARGETING'!J19","v":0}]
[null,"Total BRs",null,null,null,{"$f":"'INCOME TARGETING'!J22","v":0}]
[null,"% Affordable",null,null,null,{"$f":"IF(F35=0,,F34/F35)","v":0}]
[null,"Total Uses",null,null,null,{"$f":"USES!J128","v":2500}]
[null,"Adjusted Total Uses",null,null,null,{"$f":"F36*F37","v":0}]
[null,"Percentage of Total Uses Leveraged",null,null,null,{"$f":"IF(F31=0,0%,(F38-F31)/F38)","v":0}]
[]
[]
[null,null,null,null,"Non-Rural",{"$f":"IF(F8=\"no\",F39/0.06667,\"NA\")","v":"NA"}]
[null,null,null,null,"Rural",{"$f":"IF(F8=\"yes\",F39/0.06,\"NA\")","v":"NA"}]
[]
[null,null,null,null,null,null,"Score"]
[]
[null,null,null,null,null,null,{"$f":"IF(F9=\"no\",MAX(F42,F43),IF(F8=\"no\",MAX(F42+2),MAX(F43+2)))","v":{"$error":"#VALUE!"}}]

{"sheet":"SELF-SCORE","index":15,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[8,9,8,15],[45,2,45,3],[47,3,47,5],[2,2,2,5]]}
[]
[]
[null,null,"Applicant Self-Scoring"]
[null,null,null,null,null,{"$f":"projname","v":0}]
[null,null,null,null,"Date:",{"$f":"GENERAL!D7","v":"2023-12-15"}]
[]
[null,null,"Scoring Summary Table",null,"Maximum        Possible Points","Applicant                          Self-Score",null,"DHCD USE ONLY (Team Score)"]
[null,null,"4.1  Capacity of Development Team"]
[null,null,null,"4.1.1  Development Team Experience",42,0]
[null,null,null,"4.1.2  Deductions from Team experience score (Negative 10 Pts)",-10,0]
[null,null,null,"4.1.3  Developer Financial Capacity",18,0]
[null,null,null,"4.1.4  Nonprofits (NPs), Public Housing Authorities (PHAs) and Minority/Disadvantage Business Enterprises (MBE/DBEs)",14,0]
[null,null,null,"Section Total:",{"$f":"SUM(E9:E12)-E10","v":74},{"$f":"SUM(F9:F12)","v":0},null,{"$f":"SUM(H9:H12)","v":0}]
[null,null,"4.2 Community Context"]
[null,null,null,"4.2.1  Community Impact Projects","16*",0]
[null,null,null,"4.2.2  Communities of Opportunity","16*",0]
[null,null,null,"4.2.3  Defined Planning Areas and Opportunity Zones","16*",0]
[null,null,null,"Section Total:",16,{"$f":"(MIN(SUM(F15:F17),16))","v":0},null,{"$f":"(MIN(SUM(H15:H17),16))","v":0}]
[]
[null,null,"4.3 Transit Oriented Development (TOD)",null,8,0]
[null,null,null,"Section Total:",{"$f":"SUM(E20)","v":8},{"$f":"SUM(F20)","v":0},null,{"$f":"SUM(H20)","v":0}]
[]
[null,null,"4.4 Public Purpose"]
[null,null,null,"4.4.1  Income Targeting",15,0]
[null,null,null,"4.2.2  Targeted Populations: Non-elderly PWD or Special Needs",10,0]
[null,null,null,"4.4.3  Family Housing",8,0]
[null,null,null,"4.4.4  Tenant Services",8,0]
[null,null,null,"4.4.5  Mixed Income Housing",2,0]
[null,null,null,"4.4.6  Policy Incentives",4]
[null,null,null,"Section Total:",{"$f":"SUM(E24:E29)","v":47},{"$f":"SUM(F24:F28)","v":0},null,{"$f":"SUM(H24:H29)","v":0}]
[null,null,"4.5 Leveraging and Cost-Effectiveness"]
[null,null,null,"4.5.1  Direct Leveraging",15,0]
[null,null,null,"4.5.2  Operating Subsidies",10,0]
[null,null,null,"4.5.3  Construction or Rehabilitation Cost Incentives (Negative 8 pts)",-8,0]
[null,null,null,"Section Total:",{"$f":"SUM(E32:E34)-E34","v":25},{"$f":"SUM(F32:F34)","v":0},null,{"$f":"SUM(H32:H34)","v":0}]
[null,null,"4.6 Development Quality"]
[null,null,null,"4.6.1  Green Features",10,0]
[null,null,null,"4.6.2  Energy Efficiency",8,0]
[null,null,null,"4.6.3  Site and Building Design",13,0]
[null,null,null,"4.6.4  Loveable Places",2,0]
[null,null,null,"Section Total:",{"$f":"SUM(E37:E40)","v":33},{"$f":"SUM(F37:F40)","v":0},null,{"$f":"SUM(H37:H40)","v":0}]
[]
[]
[]
[]
[null,null,"GRAND TOTAL:",null,"203 Total Points ",{"$f":"F13+F18+F21+F30+F35+F41","v":0},null,{"$f":"H13+H18+H21+H30+H35+H41+H44","v":0}]
[]
[null,null,null,"*  Project cannot receive points under more than one of the following categories:   Community Impact, Communities of Opportunity, or Defined Planning Areas and Opportunity Zones."]