{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["SSHP Download","CHFA Download","5yr SSHP History","5yr CHFA History","Input","Cashflow","Amortization","Rent Roll","Prepay Calc","Cap Rate","Property Valuation","Module1","Notes","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":33,"comments":6,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":11,"reason":"part_missing"}],"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":"SSHP Download","index":0,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":true,"merged":[[11,0,11,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[23,0,23,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[35,0,35,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[47,0,47,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1]]}
["Rental Income - Tenant Payments",null,3100]
[" Rental Income - Excess of Base",null,3100.1]
[" Excess Utilities ",null,3110]
[" Surcharges ",null,3120]
[" Total Rental Income ",null,3199]
[" Less: Dwelling Vacancy ",null,3210]
[" Dwelling Vacancy Subsidy(Sec 8) ",null,3220]
[" Net Rental Income ",null,3299]
[" Non-Dwelling Rentals ",null,3300]
[" Sales & Services to Tenants ",null,3510]
[" Interest Income ",null,3610]
[" Other Income ",null,3620]
[" TOTAL EFFECTIVE GROSS INCOME ",null,3999]
[" Salaries-Office ",null,4120]
[" Compensated Absences - Adm Salaries ",null,4120.1000000000004]
[" Legal&Other Outside Services ",null,4130]
[" Legal Costs to Tenants ",null,4130.1000000000004]
[" Fiscal and Other Fees ",null,4131]
[" Consulting ",null,4131.1000000000004]
[" Management Fees ",null,4132]
[" Office Supplies ",null,4151]
[" Rents ",null,4152]
[" Travel ",null,4153]
[" Other Office expense ",null,4159]
[" Pensions & Other Funds ",null,4160]
[" Payroll Taxes ",null,4161]
[" TOTAL ADMIN. ",null,4199]
[" Water ",null,4310]
[" Electricity ",null,4320]
[" Gas ",null,4330]
[" Fuel ",null,4340]
[" Cable Television ",null,4350]
[" Sewer ",null,4360]
[" TOTAL UTILITIES ",null,4399]
[" Personal Services ",null,4410]
[" Compensated Absences - Maint. Wages ",null,4410.1000000000004]
[" Materials & Supplies ",null,4420]
[" Contractual Services ",null,4430]
[" Maintenance Shop & Equipment ",null,4440]
[" TOTAL MAINTENANCE ",null,4499]
[" Refuse Removal ",null,4710]
[" Insurance ",null,4711]
[" PILOT ",null,4715]
[" State Service Charge ",null,4716]
[" Interest Expense ",null,4717]
[" Total Other Expense ",null,4799]
[" TOTAL OPERATING EXP. ",null,4999]
[" NET OPERATING INCOME ",null,5999]
[" Provision for RM&R ",null,4810]
[" Provision for Collection Loss ",null,4820]
[" Princ. Pmnt - Mortgage ",null,4910]
[" Princ. Pmnt - Rehab Loan ",null,4920]
[" ROI ",null,5000]
[" Extraordinary Income ",null,6100]
[" Extraordinary Expense ",null,6200]
[" NET RESULT OF OPERATIONS ",null,6299]
[" Gain/Loss ",null,6399]

{"sheet":"CHFA Download","index":1,"n_rows":120,"n_cols":3,"rows_kept":120,"cut":false,"hidden":true,"merged":[[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[102,0,102,1],[103,0,103,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[107,0,107,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[118,0,118,1],[119,0,119,1],[108,0,108,1],[109,0,109,1],[110,0,110,1],[111,0,111,1],[112,0,112,1],[113,0,113,1]]}
["Rent Revenue- Gross Potential",null,5120]
["Tenant Assistance Payments (HAP Receipts)",null,5121]
["Furniture and Equipment",null,5130]
["Rent Revenue- Stores & Commercial",null,5140]
["Rent Revenue- Garage & Parking",null,5170]
["Flexible Subsidy Revenue",null,5180]
["Miscellaneous Rent Revenue**",null,5190]
["Excess Rent",null,5191]
["Rent Revenue - Insurance",null,5192]
["Special Claims Revenue",null,5193]
["Retained Excess Income",null,5194]
["Total Rent Revenue (GPI @ 100% Occupancy)",null,5100]
["Apartments- Vacancy",null,5220]
["Furniture and Equipment",null,5230]
["Stores & Commercial- Vacancy",null,5240]
["Rental Concessions",null,5250]
["Garage & Parking- Vacancy",null,5270]
["Miscellaneous** (other vacancy)",null,5290]
["Total Vacancies",null,5200]
["Net Rental Revenue ( Rent Revenue Less Vacancy)",null,5125]
["Elderly & Congregate Service Income (attach schedule)",null,5300]
["Financial Revenue-Project Operations",null,5410]
["Revenue from Investments- Residual Receipts",null,5430]
["Revenue from Investments- Replacement Reserves",null,5440]
["Revenue from Investments- Miscellaneous **",null,5490]
["Total Financial Revenue",null,5400]
["Laundry & Vending Revenue",null,5910]
["NSF & Late Charges",null,5915]
["Damages & Cleaning Fees",null,5930]
["Forfeited Tenant Security Deposits",null,5940]
["Interest Reduction Payments",null,5945]
["Miscellaneous (Specify) **",null,5990]
["Total Other Revenue",null,5900]
["Total Revenue",null,5000]
["Conventions & Meetings",null,6203]
["Management Consultants",null,6204]
["Advertising & Marketing",null,6210]
["Apartment Resale Expenses (Coops)",null,6235]
["Other Renting Expenses",null,6250]
["Office Salaries",null,6310]
["Office Supplies",null,6315]
["Office or Model Apartment Rent",null,6312]
["Management Fee",null,6320]
["Manager or Superintendent Salaries",null,6330]
["Administrative Rent Free Unit",null,6331]
["Legal Expense (Project)",null,6340]
["Audit Expense",null,6350]
["Bookkeeping Fees/Accounting Services",null,6351]
["Telephone/Answering Service",null,6360]
["Bad Debts",null,6370]
["Miscellaneous Administrative Expenses **",null,6390]
["Total Administrative Expenses",null,6263]
["Fuel Oil/ Coal",null,6420]
["Electricity",null,6450]
["Water",null,6451]
["Gas",null,6452]
["Sewer",null,6453]
["Total Utilities Expense",null,6400]
["Janitor and Cleaning Payroll",null,6511]
["Janitor and Cleaning Supplies",null,6516]
["Janitor and Cleaning Contracts",null,6517]
["Exterminating Payroll/Contracts",null,6519]
["Operating & Maintenance Rent Free Unit",null,6521]
["Exterminating Supplies",null,6522]
["Garbage & Trash Removal",null,6525]
["Security Payroll/ Contracts",null,6530]
["Security Rent Free Unit",null,6531]
["Grounds Payroll",null,6535]
["Grounds Supplies",null,6536]
["Grounds Contract",null,6537]
["Maintenance Payroll",null,6540]
["Repairs Material",null,6541]
["Repairs Contract",null,6542]
["Elevator Maintenance/Contract",null,6545]
["Heating & AC Maintenance/Repairs",null,6546]
["Pool Maintenance/Contract",null,6547]
["Snow Removal",null,6548]
["Decorating (Painting) Contract/Payroll",null,6560]
["Decorating Supplies",null,6561]
["Vechicle & Maintenance Equipment Oper. & Repairs",null,6570]
["Miscellaneous Oper. & Maintenance Expenses",null,6590]
["Total Operating & Maintenance Expenses",null,6500]
["Real Estate Taxes",null,6710]
["Employers Payroll Taxes (Project Share)",null,6711]
["Miscellaneous Taxes, Licenses &  Permits",null,6719]
["Property & Liability Insurance",null,6720]
["Fidelity Bond Insurance",null,6721]
["Workmens Compennsation",null,6722]
["Employee Health & Life Insurance",null,6723]
["Other Insurance",null,6790]
["Total Taxes & Insurance",null,6700]
["Interest on Bonds Payable",null,6810]
["Interest on Mortgage Payable",null,6820]
["Interest on Notes Payable Long Term",null,6830]
["Interest on Notes Payable Short Term",null,6840]
["Mortgage Insurance Premium/Service Charge",null,6850]
["Miscellaneous Fiancial Expenses",null,6890]
["Total Financial Expenses",null,6800]
["Elderly & Congregate Service Expenses",null,6900]
["Total Cost of OPS before Depreciation",null,6000]
["Profit (Loss) Before Depreciation",null,5060]
["Depreciation Expense",null,6600]
["Amoritization Expense",null,6610]
["Total Depreciation & Amortization Expense",null,6611]
["Operating Profit or Loss",null,5061]
["Officers Saleries (Entity)",null,7110]
["Legal Expense (Entity)",null,7120]
["Federal, State & Other Income Taxes (Entity)",null,7130]
["Interest Income (Entity)",null,7140]
["Interest on Notes Payable (Entity)",null,7141]
["Interest on Mortgage Payable (Entity)",null,7142]
["Other Expenses (Entity)",null,7190]
["Net Entity Expenses",null,7100]
["Net Profit (Loss)",null,3250]
["Principal Mortgage Payment (Schedule)",null,1301]
["Replacement Reserve Deposits",null,1302]
["Replacement/Paint Reserve Releases included as exp.",null,1303]
["Project Improvement Reserve Releases",null,1304]
["Cash & AR/AP - Quick Ratio",null,9991]
["Cashflow/AP - Coverage Ratio",null,9992]

{"sheet":"5yr SSHP History","index":2,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[61,0,61,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[52,0,52,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[40,0,40,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[28,0,28,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[16,0,16,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
["5 Year Income & Expense Comparison "]
["Property:             "]
[null,null,null,null,"% ",null,"% ",null,"% ",null,"% ",null,null,null,"Current Approved Budget","Actual Annualized","Current Operating  # of months","Application Proforma"]
["Account Description",null,"Account #",2018,"Change",{"$f":"D4-1","v":2017},"Change",{"$f":"F4-1","v":2016},"Change",{"$f":"H4-1","v":2015},"Change",{"$f":"J4-1","v":2014},"Average",null,2019,2019,3]
[]
["Rental Income - Base Rent",null,3100,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L6+J6+H6+F6+D6)<>0,AVERAGE(L6,J6,H6,F6,D6),0)","v":0},null,0,{"$f":"IF(+Q6<>0,+(+Q6/$Q$4)*12,0)","v":0},0,0]
[" Rental Income - Excess of Base",null,3100.1,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L7+J7+H7+F7+D7)<>0,AVERAGE(L7,J7,H7,F7,D7),0)","v":0},null,0,{"$f":"IF(+Q7<>0,+(+Q7/$Q$4)*12,0)","v":0},0,0]
[" Excess Utilities ",null,3110,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Surcharges ",null,3120,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Total Rental Income ",null,3199,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O6:O9)","v":0},0,{"$f":"SUM(Q6:Q9)","v":0},{"$f":"SUM(R6:R9)","v":0}]
[" Less: Dwelling Vacancy ",null,3210,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Dwelling Vacancy Subsidy(Sec 8) ",null,3220,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Net Rental Income ",null,3299,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O11:O12)","v":0},0,{"$f":"SUM(Q11:Q12)","v":0},{"$f":"SUM(R11:R12)","v":0}]
[" Non-Dwelling Rentals ",null,3300,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Sales & Services to Tenants ",null,3510,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Interest Income ",null,3610,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Other Income ",null,3620,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" TOTAL EFFECTIVE GROSS INCOME ",null,3999,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O10+O13+O14+O15+O16+O17","v":0},0,{"$f":"+Q10+Q13+Q14+Q15+Q16+Q17","v":0},{"$f":"+R10+R13+R14+R15+R16+R17","v":0}]
[" Salaries-Office ",null,4120,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Compensated Absences - Adm Salaries ",null,4120.1000000000004,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Legal&Other Outside Services ",null,4130,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Legal Costs to Tenants ",null,4130.1000000000004,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Fiscal and Other Fees ",null,4131,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Consulting ",null,4131.1000000000004,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Management Fees ",null,4132,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Office Supplies ",null,4151,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Rents ",null,4152,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Travel ",null,4153,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Other Office expense ",null,4159,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Pensions & Other Funds ",null,4160,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Payroll Taxes ",null,4161,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" TOTAL ADMIN. ",null,4199,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O19:O31)","v":0},0,{"$f":"SUM(Q19:Q31)","v":0},{"$f":"SUM(R19:R31)","v":0}]
[" Water ",null,4310,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Electricity ",null,4320,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Gas ",null,4330,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Fuel ",null,4340,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Cable Television ",null,4350,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Sewer ",null,4360,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" TOTAL UTILITIES ",null,4399,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O33:O38)","v":0},0,{"$f":"SUM(Q33:Q38)","v":0},{"$f":"SUM(R33:R38)","v":0}]
[" Personal Services ",null,4410,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Compensated Absences - Maint. Wages ",null,4410.1000000000004,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Materials & Supplies ",null,4420,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Contractual Services ",null,4430,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Maintenance Shop & Equipment ",null,4440,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" TOTAL MAINTENANCE ",null,4499,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O40:O44)","v":0},0,{"$f":"SUM(Q40:Q44)","v":0},{"$f":"SUM(R40:R44)","v":0}]
[" Refuse Removal ",null,4710,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Insurance ",null,4711,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" PILOT ",null,4715,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" State Service Charge ",null,4716,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Interest Expense ",null,4717,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Total Other Expense ",null,4799,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O46:O50)","v":0},0,{"$f":"SUM(Q46:Q50)","v":0},{"$f":"SUM(R46:R50)","v":0}]
[" TOTAL OPERATING EXP. ",null,4999,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O51+O45+O39+O32","v":0},0,{"$f":"+Q51+Q45+Q39+Q32","v":0},{"$f":"+R51+R45+R39+R32","v":0}]
[" NET OPERATING INCOME ",null,5999,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O18-O52","v":0},0,{"$f":"+Q18-Q52","v":0},{"$f":"+R18-R52","v":0}]
[" Provision for RM&R ",null,4810,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Provision for Collection Loss ",null,4820,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Princ. Pmnt - Mortgage ",null,4910,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Princ. Pmnt - Rehab Loan ",null,4920,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" ROI ",null,5000,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Extraordinary Income ",null,6100,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" Extraordinary Expense ",null,6200,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0]
[" NET RESULT OF OPERATIONS ",null,6299,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O53-O54-O55-O56-O57-O58+O59-O60","v":0},0,{"$f":"+Q53-Q54-Q55-Q56-Q57-Q58+Q59-Q60","v":0},{"$f":"+R53-R54-R55-R56-R57-R58+R59-R60","v":0}]
[" Gain/Loss ",null,6399,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O61","v":0},0,{"$f":"+Q61","v":0},{"$f":"+R61","v":0}]
[]
[null,"= cells not carried forward to cashflow page"]

{"sheet":"5yr CHFA History","index":3,"n_rows":128,"n_cols":18,"rows_kept":128,"cut":false,"hidden":true,"merged":[[92,0,92,1],[123,0,123,1],[124,0,124,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[121,0,121,1],[122,0,122,1],[120,0,120,1],[119,0,119,1],[118,0,118,1],[109,0,109,1],[117,0,117,1],[107,0,107,1],[103,0,103,1],[104,0,104,1],[105,0,105,1],[108,0,108,1],[110,0,110,1],[111,0,111,1],[112,0,112,1],[93,0,93,1],[94,0,94,1],[96,0,96,1],[95,0,95,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[106,0,106,1],[84,0,84,1],[85,0,85,1],[88,0,88,1],[89,0,89,1],[91,0,91,1],[86,0,86,1],[87,0,87,1],[90,0,90,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[60,0,60,1],[61,0,61,1],[63,0,63,1],[64,0,64,1],[62,0,62,1],[65,0,65,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[56,0,56,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[39,0,39,1],[40,0,40,1],[37,0,37,1],[38,0,38,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[31,0,31,1],[32,0,32,1],[30,0,30,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]]}
["5 Year Income & Expense Comparison "]
["Property:             ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Approved","Actual","Current Operating"]
[null,null,null,null,"% ",null,"% ",null,"% ",null,"% ",null,null,null,"Budget","Annualized","# Months","Proforma"]
["Account Description",null,"Account #",2016,"Change",{"$f":"D4-1","v":2015},"Change",{"$f":"F4-1","v":2014},"Change",{"$f":"H4-1","v":2013},"Change",{"$f":"J4-1","v":2012},"Average"]
[]
["Rent Revenue- Gross Potential",null,5120,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L6+J6+H6+F6+D6)<>0,AVERAGE(L6,J6,H6,F6,D6),0)","v":0},null,null,{"$f":"IF(Q6<>0,(+Q6/$Q$4)*12,0)","v":0},null,0]
["Tenant Assistance Payments (HAP Receipts)",null,5121,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L7+J7+H7+F7+D7)<>0,AVERAGE(L7,J7,H7,F7,D7),0)","v":0},null,null,{"$f":"IF(Q7<>0,(+Q7/$Q$4)*12,0)","v":0},null,0]
["Furniture and Equipment",null,5130,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Rent Revenue- Stores & Commercial",null,5140,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Rent Revenue- Garage & Parking",null,5170,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Flexible Subsidy Revenue",null,5180,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous Rent Revenue**",null,5190,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Excess Rent",null,5191,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Rent Revenue - Insurance",null,5192,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Special Claims Revenue",null,5193,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Retained Excess Income",null,5194,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Rent Revenue (GPI @ 100% Occupancy)",null,5100,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O6:O16)","v":0},0,{"$f":"SUM(Q6:Q16)","v":0},{"$f":"SUM(R6:R16)","v":0}]
["Apartments- Vacancy",null,5220,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Furniture and Equipment",null,5230,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Stores & Commercial- Vacancy",null,5240,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Rental Concessions",null,5250,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Garage & Parking- Vacancy",null,5270,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous** (other vacancy)",null,5290,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Vacancies",null,5200,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O18:O23)","v":0},0,{"$f":"SUM(Q18:Q23)","v":0},0]
["Net Rental Revenue ( Rent Revenue Less Vacancy)",null,5125,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O17-O24","v":0},0,{"$f":"+Q17-Q24","v":0},{"$f":"+R17-R24","v":0}]
["Elderly & Congregate Service Income (attach schedule)",null,5300,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Financial Revenue-Project Operations",null,5410,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Revenue from Investments- Residual Receipts",null,5430,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Revenue from Investments- Replacement Reserves",null,5440,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Revenue from Investments- Miscellaneous **",null,5490,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Financial Revenue",null,5400,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O27:O30)","v":0},0,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0}]
["Laundry & Vending Revenue",null,5910,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["NSF & Late Charges",null,5915,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Damages & Cleaning Fees",null,5930,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Forfeited Tenant Security Deposits",null,5940,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Interest Reduction Payments",null,5945,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous (Specify) **",null,5990,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Other Revenue",null,5900,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O32:O37)","v":0},0,{"$f":"SUM(Q32:Q37)","v":0},{"$f":"SUM(R32:R37)","v":0}]
["Total Revenue",null,5000,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O25+O31+O38","v":0},0,{"$f":"+Q25+Q31+Q38","v":0},{"$f":"+R25+R31+R38","v":0}]
["Conventions & Meetings",null,6203,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Management Consultants",null,6204,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Advertising & Marketing",null,6210,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Apartment Resale Expenses (Coops)",null,6235,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Other Renting Expenses",null,6250,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Office Salaries",null,6310,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Office Supplies",null,6315,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Office or Model Apartment Rent",null,6312,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Management Fee",null,6320,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Manager or Superintendent Salaries",null,6330,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Administrative Rent Free Unit",null,6331,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Legal Expense (Project)",null,6340,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Audit Expense",null,6350,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Bookkeeping Fees/Accounting Services",null,6351,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Telephone/Answering Service",null,6360,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Bad Debts",null,6370,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous Administrative Expenses **",null,6390,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Administrative Expenses",null,6263,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O40:O56)","v":0},0,{"$f":"SUM(Q40:Q56)","v":0},{"$f":"SUM(R40:R56)","v":0}]
["Fuel Oil/ Coal",null,6420,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Electricity",null,6450,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Water",null,6451,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Gas",null,6452,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Sewer",null,6453,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Utilities Expense",null,6400,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O58:O62)","v":0},0,{"$f":"SUM(Q58:Q62)","v":0},{"$f":"SUM(R58:R62)","v":0}]
["Janitor and Cleaning Payroll",null,6511,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Janitor and Cleaning Supplies",null,6516,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Janitor and Cleaning Contracts",null,6517,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Exterminating Payroll/Contracts",null,6519,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Operating & Maintenance Rent Free Unit",null,6521,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Exterminating Supplies",null,6522,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Garbage & Trash Removal",null,6525,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Security Payroll/ Contracts",null,6530,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L71+J71+H71+F71+D71)<>0,AVERAGE(L71,J71,H71,F71,D71),0)","v":0},null,null,{"$f":"IF(Q71<>0,(+Q71/$Q$4)*12,0)","v":0},null,0]
["Security Rent Free Unit",null,6531,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Grounds Payroll",null,6535,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Grounds Supplies",null,6536,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Grounds Contract",null,6537,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Maintenance Payroll",null,6540,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Repairs Material",null,6541,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Repairs Contract",null,6542,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Elevator Maintenance/Contract",null,6545,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Heating & AC Maintenance/Repairs",null,6546,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Pool Maintenance/Contract",null,6547,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Snow Removal",null,6548,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Decorating (Painting) Contract/Payroll",null,6560,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Decorating Supplies",null,6561,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Vechicle & Maintenance Equipment Oper. & Repairs",null,6570,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous Oper. & Maintenance Expenses",null,6590,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Operating & Maintenance Expenses",null,6500,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O64:O86)","v":0},0,{"$f":"SUM(Q64:Q86)","v":0},{"$f":"SUM(R64:R86)","v":0}]
["Real Estate Taxes",null,6710,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Employers Payroll Taxes (Project Share)",null,6711,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous Taxes, Licenses &  Permits",null,6719,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Property & Liability Insurance",null,6720,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Fidelity Bond Insurance",null,6721,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Workmens Compennsation",null,6722,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Employee Health & Life Insurance",null,6723,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Other Insurance",null,6790,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Taxes & Insurance",null,6700,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O88:O95)","v":0},0,{"$f":"SUM(Q88:Q95)","v":0},{"$f":"SUM(R88:R95)","v":0}]
["Interest on Bonds Payable",null,6810,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Interest on Mortgage Payable",null,6820,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Interest on Notes Payable Long Term",null,6830,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Interest on Notes Payable Short Term",null,6840,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Mortgage Insurance Premium/Service Charge",null,6850,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Miscellaneous Fiancial Expenses",null,6890,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0]
["Total Financial Expenses",null,6800,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O97:O102)","v":0},0,{"$f":"SUM(Q97:Q102)","v":0},{"$f":"SUM(R97:R102)","v":0}]
["Elderly & Congregate Service Expenses",null,6900,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Total Cost of OPS before Depreciation",null,6000,null,null,null,null,null,null,null,null,null,0,null,{"$f":"O104+O96+O87+O63+O57+O103","v":0},0,{"$f":"Q104+Q96+Q87+Q63+Q57+Q103","v":0},{"$f":"R104+R96+R87+R63+R57+R103","v":0}]
["Profit (Loss) Before Depreciation",null,5060,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O39-O105","v":0},0,{"$f":"+Q39-Q105","v":0},{"$f":"+R39-R105","v":0}]
["Depreciation Expense",null,6600,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Amoritization Expense",null,6610,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Total Depreciation & Amortization Expense",null,6611,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O107:O108)","v":0},0,{"$f":"SUM(Q107:Q108)","v":0},{"$f":"SUM(R107:R108)","v":0}]
["Operating Profit or Loss",null,5061,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O106-O109","v":0},0,{"$f":"+Q106-Q109","v":0},{"$f":"+R106-R109","v":0}]
["Officers Saleries (Entity)",null,7110,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Legal Expense (Entity)",null,7120,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Federal, State & Other Income Taxes (Entity)",null,7130,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Interest Income (Entity)",null,7140,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Interest on Notes Payable (Entity)",null,7141,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Interest on Mortgage Payable (Entity)",null,7142,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Other Expenses (Entity)",null,7190,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Net Entity Expenses",null,7100,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(O111:O117)","v":0},0,{"$f":"SUM(Q111:Q117)","v":0},{"$f":"SUM(R111:R117)","v":0}]
["Net Profit (Loss)",null,3250,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+O110-O118","v":0},0,{"$f":"+Q110-Q118","v":0},{"$f":"+R110-R118","v":0}]
["Principal Mortgage Payment (Schedule)",null,1301,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Replacement Reserve Deposits",null,1302,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Replacement/Paint Reserve Releases included as exp.",null,1303,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Project Improvement Reserve Releases",null,1304,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Cash & AR/AP - Quick Ratio",null,9991,null,null,null,null,null,null,null,null,null,0]
["Cashflow/AP - Coverage Ratio",null,9992,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"= cells not carried forward to cashflow page"]

{"sheet":"Input","index":4,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,7,42,10],[11,7,11,13],[14,7,14,14],[15,7,15,16],[16,7,16,13],[17,7,17,13],[21,7,21,14],[32,7,32,15],[13,7,13,14],[40,7,40,10],[8,7,8,13],[3,7,3,14],[41,7,41,10],[0,1,0,4],[1,7,1,15],[4,7,4,14],[39,7,39,10],[24,7,24,14],[34,2,34,3],[12,7,12,12],[20,7,20,12],[27,7,27,12],[19,7,19,11],[22,7,22,12]]}
["Property",{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!B2,'5yr SSHP History'!B2)","v":0}]
["Units",null,null,null,0,null,null," Comments"]
["First Year ",null,null,null,"Proforma","Adjustment","First Year"]
["Gross Potential Rent Revenue (Tenant)",null,null,null,{"$f":"IF(Cashflow!C9=\"X\",'5yr CHFA History'!R6,'5yr SSHP History'!R7+'5yr SSHP History'!R6)","v":0},null,{"$f":"+E4+F4","v":0}]
["Gross Potential Rent Revenue (HAP)",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R7,0)","v":0},null,0]
["Vacancy Rate",0.02,null,"Input",{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R24,'5yr SSHP History'!R11+'5yr SSHP History'!R12)","v":0},{"$f":"IF(-E6>(E4+E5)*B6,0,((E4+E5)*B6)+E6)*-1","v":0},{"$f":"+E6+F6","v":0}]
["Elderly & Congregate Services Income",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!R26,0)","v":0},null,0]
["Financial Revenue",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!R31,'5yr SSHP History'!R16)","v":0},null,0]
["Other Revenue",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R8+'5yr CHFA History'!R9+'5yr CHFA History'!R10+'5yr CHFA History'!R11+'5yr CHFA History'!R12+'5yr CHFA History'!R13+'5yr CHFA History'!R14+'5yr CHFA History'!R15+'5yr CHFA History'!R16+'5yr CHFA History'!R38,'5yr SSHP History'!R9+'5yr SSHP History'!R8+'5yr SSHP History'!R14+'5yr SSHP History'!R15+'5yr SSHP History'!R17+'5yr SSHP History'!R59)","v":0},null,0]
["Effective Income",null,null,null,{"$f":"SUM(E4:E9)","v":0},{"$f":"SUM(F4:F9)","v":0},{"$f":"SUM(G4:G9)","v":0}]
[]
["Administrative",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R57-'5yr CHFA History'!R48,'5yr SSHP History'!R32-'5yr SSHP History'!R25-'5yr SSHP History'!R30-'5yr SSHP History'!R31+'5yr SSHP History'!R55)","v":0},null,{"$f":"+E12+F12","v":0}]
["Management Fees/ %/yr",0.05,{"$f":"+E10*B13","v":0},null,{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!R48,'5yr SSHP History'!R25)","v":0},null,{"$f":"+E13+F13","v":0}]
["Utilities",null,null,null,{"$f":"IF(Cashflow!C9=\"X\",'5yr CHFA History'!R63,'5yr SSHP History'!R39-'5yr SSHP History'!R37)","v":0},null,0]
["Operating & Maintenance ",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R87,'5yr SSHP History'!R45+'5yr SSHP History'!R46+'5yr SSHP History'!R60+'5yr SSHP History'!R37)","v":0},null,0]
["Property Taxes",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R88,'5yr SSHP History'!R48)","v":0},null,0]
["Property Insurance",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R91,'5yr SSHP History'!R47)","v":0},null,0]
["Other Taxes & Insurance",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R90+'5yr CHFA History'!R89+'5yr CHFA History'!R92+'5yr CHFA History'!R93+'5yr CHFA History'!R94+'5yr CHFA History'!R95,'5yr SSHP History'!R30+'5yr SSHP History'!R31)","v":0},null,0]
["Misc Financial Expenses",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!R101+'5yr CHFA History'!R102,0)","v":0},null,0]
["Repl Rsv/per unit/yr",400,{"$f":"+B20*E2","v":0},null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R121,'5yr SSHP History'!R54)","v":0},null,0]
["State Service Fees*",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",0,'5yr SSHP History'!R49)","v":0},null,0]
["Resident Services Coordinator",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",'5yr CHFA History'!R104,0)","v":0},null,0]
["Total Operating Expenses",null,null,null,{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},{"$f":"SUM(G12:G22)","v":0}]
["NOI",null,null,null,{"$f":"+E10-E23","v":0},{"$f":"+F10-F23","v":0},{"$f":"+G10-G23","v":0}]
["Secondary Debt Services and Expenses",null,null,null,{"$f":"IF(Cashflow!C9=\"x\",+'5yr CHFA History'!R97+'5yr CHFA History'!R99+'5yr CHFA History'!R100,'5yr SSHP History'!R50+'5yr SSHP History'!R56+'5yr SSHP History'!R57)","v":0},null,{"$f":"+E25+F25","v":0}]
["Net profit Loss (w/o 1st mortgage)",null,null,null,{"$f":"+E24-E25","v":0},{"$f":"+F24-F25","v":0},{"$f":"+G24-G25","v":0}]
[]
["Mortgage Balance",0.01,null,"Input",{"$f":"+B28","v":0.01}]
["Proposed New Mortgage",0,null,"Input",{"$f":"+B29","v":0}]
["Total Debt",null,null,null,{"$f":"SUM(E28:E29)","v":0.01}]
["Proposed New Mortgage term (in years)",null,null,null,0.01]
["Source of Funds",null,"ITA rate","Spread"]
["Interest Rate",null,0,null,{"$f":"C33+D33","v":0}]
[]
["Replacement Reserve Balance",null,0]
[]
["Debt Analysis"]
["Max Debt Capacity Calculation @ "]
["Max DS @",1.1499999999999999,null,null,{"$f":"(G26/B39)","v":0}]
["Mortgage Constant",null,null,null,{"$f":"-PMT(E33,E31,1)","v":100}]
["Max Debt ",null,null,null,{"$f":"E39/E40","v":0}]
["Proforma Debt Service",null,null,null,{"$f":"+Amortization!C13","v":0}]
["Proforma DSCR",null,null,null,{"$f":"G26/E42","v":{"$error":"#DIV/0!"}}]

{"sheet":"Cashflow","index":5,"n_rows":50,"n_cols":46,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,12,46,15],[7,7,7,11],[6,16,7,16],[6,17,7,17],[7,12,7,13],[44,12,44,13],[43,12,43,13],[40,12,40,15],[6,14,6,15]]}
[1,"Assumptions:",null,null,null,null,null,null,null,{"$f":"+Input!B1","v":0}]
[{"$f":"A1+1","v":2},"Number of Units",null,null,null,null,null,{"$f":"Input!E2","v":0}]
[3,"Tenant's Rent Inflation",null,null,null,null,null,0.02]
[4,"Growth Rate in HAP",null,null,null,null,null,0.02]
[5,"Expense Inflation",null,null,null,null,null,0.03]
[6,"Replacement Reserves Inflation",null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORROWER'S CURRENT",null,"First Year"]
[8,null,null,null,null,null,null,"DOWNLOADED HISTORIC STATEMENTS",null,null,null,null,"Historical",null,"Budget","Annualized*"]
[9,null,null,"Private",null,"X","Public",null,null,null,null,null,null,"Annual",null,null,1,{"$f":"1+Q9","v":2},3,4,5,6,7,8,{"$f":"1+X9","v":9},10,11,12,13,14,15,16,17,{"$f":"1+AG9","v":18},19,20,21,22,23,24,25,26,27,28,29,30]
[10,null,null,null,null," ",null,{"$f":"IF($C9=\"X\",'5yr CHFA History'!L4,'5yr SSHP History'!L4)","v":2014},{"$f":"IF($C9=\"X\",'5yr CHFA History'!J4,'5yr SSHP History'!J4)","v":2015},{"$f":"IF($C9=\"X\",'5yr CHFA History'!H4,'5yr SSHP History'!H4)","v":2016},{"$f":"IF($C9=\"X\",'5yr CHFA History'!F4,'5yr SSHP History'!F4)","v":2017},{"$f":"IF($C9=\"X\",'5yr CHFA History'!D4,'5yr SSHP History'!D4)","v":2018},"Average","Growth %",{"$f":"+'5yr SSHP History'!O4","v":2019},{"$f":"+'5yr SSHP History'!P4","v":2019},{"$f":"+Input!B3","v":0},{"$f":"+Q10+1","v":1},{"$f":"+R10+1","v":2},3,4,5,6,7,{"$f":"+X10+1","v":8},9,10,11,12,13,14,15,16,{"$f":"+AG10+1","v":17},18,19,20,21,22,23,24,25,26,27,28,29]
[11,"SOURCES"]
[12,"Gross Potential Rent Revenue (Tenant)",null,null,null,null,null,{"$f":"IF($C9=\"X\",'5yr CHFA History'!L6,'5yr SSHP History'!L6+'5yr SSHP History'!L7)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!J6,'5yr SSHP History'!J6+'5yr SSHP History'!J7)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!H6,'5yr SSHP History'!H6+'5yr SSHP History'!H7)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!F6,'5yr SSHP History'!F6+'5yr SSHP History'!F7)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!D6,'5yr SSHP History'!D7+'5yr SSHP History'!D6)","v":0},{"$f":"IF(SUM(H12:L12)<>0,SUM(H12:L12)/(SUMPRODUCT((H12:L12<>0)*1)),0)","v":0},{"$f":"IF(M12=0,0,(L12/H12)^0.2-1)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!O6,'5yr SSHP History'!O7+'5yr SSHP History'!O6)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!P6,'5yr SSHP History'!P7+'5yr SSHP History'!P6)","v":0},{"$f":"+Input!G4","v":0},{"$f":"Q12*(1+$H$3)","v":0},{"$f":"R12*(1+$H$3)","v":0},{"$f":"S12*(1+$H$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Gross Potential Rent Revenue (HAP)",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L7,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J7,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H7,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F7,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D7,0)","v":0},{"$f":"IF(SUM(H13:L13)<>0,SUM(H13:L13)/(SUMPRODUCT((H13:L13<>0)*1)),0)","v":0},{"$f":"IF(M13=0,0,(L13/H13)^0.2-1)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!O7,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P7,0)","v":0},{"$f":"+Input!G5","v":0},{"$f":"Q13*(1+$H$4)","v":0},{"$f":"R13*(1+$H$4)","v":0},{"$f":"S13*(1+$H$4)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,"Total Gross Potential",null,null,null,null,null,{"$f":"H12+H13","v":0},0,0,0,0,0,0,{"$f":"O12+O13","v":0},{"$f":"P12+P13","v":0},{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:R13)","v":0},{"$f":"SUM(S12:S13)","v":0},{"$f":"SUM(T12:T13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"Vacancies",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L24,'5yr SSHP History'!L11+'5yr SSHP History'!L12)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J24,'5yr SSHP History'!J11+'5yr SSHP History'!J12)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H24,'5yr SSHP History'!H11+'5yr SSHP History'!H12)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F24,'5yr SSHP History'!F11+'5yr SSHP History'!F12)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D24,'5yr SSHP History'!D11+'5yr SSHP History'!D12)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O24,'5yr SSHP History'!O11+'5yr SSHP History'!O12)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P24,'5yr SSHP History'!P11+'5yr SSHP History'!P12)","v":0},{"$f":"+Input!G6","v":0},{"$f":"Q15*(1+$H$5)","v":0},{"$f":"R15*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,"Net Rental Revenue ",null,null,null,null,null,{"$f":"H14+H15","v":0},{"$f":"I14+I15","v":0},{"$f":"J14+J15","v":0},{"$f":"K14+K15","v":0},{"$f":"L14+L15","v":0},0,{"$f":"IF(M16=0,0,(L16/H16)^0.2+1)","v":0},{"$f":"O14+O15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,"Elderly & Congregate Service Income",null,null,null,null,null,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!L26,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!J26,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!H26,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!F26,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!D26,0)","v":0},0,0,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!O26,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!P26,0)","v":0},{"$f":"+Input!G7","v":0},{"$f":"Q17*(1+$H$3)","v":0},{"$f":"R17*(1+$H$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,"Financial Revenue",null,null,null,null,null,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!L31,'5yr SSHP History'!L16)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!J31,'5yr SSHP History'!J16)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!H31,'5yr SSHP History'!H16)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!F31,'5yr SSHP History'!F16)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!D31,'5yr SSHP History'!D16)","v":0},0,0,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!O31,'5yr SSHP History'!O16)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!P31,'5yr SSHP History'!P16)","v":0},{"$f":"+Input!G8","v":0},{"$f":"Q18*(1+$H$3)","v":0},{"$f":"R18*(1+$H$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[19,"Other Revenue",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L8+'5yr CHFA History'!L9+'5yr CHFA History'!L10+'5yr CHFA History'!L11+'5yr CHFA History'!L12+'5yr CHFA History'!L13+'5yr CHFA History'!L14+'5yr CHFA History'!L15+'5yr CHFA History'!L16+'5yr CHFA History'!L38,'5yr SSHP History'!L9+'5yr SSHP History'!L8+'5yr SSHP History'!L14+'5yr SSHP History'!L15+'5yr SSHP History'!L17+'5yr SSHP History'!L59)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J8+'5yr CHFA History'!J9+'5yr CHFA History'!J10+'5yr CHFA History'!J11+'5yr CHFA History'!J12+'5yr CHFA History'!J13+'5yr CHFA History'!J14+'5yr CHFA History'!J15+'5yr CHFA History'!J16+'5yr CHFA History'!J38,'5yr SSHP History'!J9+'5yr SSHP History'!J8+'5yr SSHP History'!J14+'5yr SSHP History'!J15+'5yr SSHP History'!J17+'5yr SSHP History'!J59)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H8+'5yr CHFA History'!H9+'5yr CHFA History'!H10+'5yr CHFA History'!H11+'5yr CHFA History'!H12+'5yr CHFA History'!H13+'5yr CHFA History'!H14+'5yr CHFA History'!H15+'5yr CHFA History'!H16+'5yr CHFA History'!H38,'5yr SSHP History'!H9+'5yr SSHP History'!H8+'5yr SSHP History'!H14+'5yr SSHP History'!H15+'5yr SSHP History'!H17+'5yr SSHP History'!H59)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F8+'5yr CHFA History'!F9+'5yr CHFA History'!F10+'5yr CHFA History'!F11+'5yr CHFA History'!F12+'5yr CHFA History'!F13+'5yr CHFA History'!F14+'5yr CHFA History'!F15+'5yr CHFA History'!F16+'5yr CHFA History'!F38,'5yr SSHP History'!F9+'5yr SSHP History'!F8+'5yr SSHP History'!F14+'5yr SSHP History'!F15+'5yr SSHP History'!F17+'5yr SSHP History'!F59)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D8+'5yr CHFA History'!D9+'5yr CHFA History'!D10+'5yr CHFA History'!D11+'5yr CHFA History'!D12+'5yr CHFA History'!D13+'5yr CHFA History'!D14+'5yr CHFA History'!D15+'5yr CHFA History'!D16+'5yr CHFA History'!D38,'5yr SSHP History'!D9+'5yr SSHP History'!D8+'5yr SSHP History'!D14+'5yr SSHP History'!D15+'5yr SSHP History'!D17+'5yr SSHP History'!D59)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O8+'5yr CHFA History'!O9+'5yr CHFA History'!O10+'5yr CHFA History'!O11+'5yr CHFA History'!O12+'5yr CHFA History'!O13+'5yr CHFA History'!O14+'5yr CHFA History'!O15+'5yr CHFA History'!O16+'5yr CHFA History'!O38,'5yr SSHP History'!O9+'5yr SSHP History'!O8+'5yr SSHP History'!O14+'5yr SSHP History'!O15+'5yr SSHP History'!O17+'5yr SSHP History'!O59)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P8+'5yr CHFA History'!P9+'5yr CHFA History'!P10+'5yr CHFA History'!P11+'5yr CHFA History'!P12+'5yr CHFA History'!P13+'5yr CHFA History'!P14+'5yr CHFA History'!P15+'5yr CHFA History'!P16+'5yr CHFA History'!P38,'5yr SSHP History'!P9+'5yr SSHP History'!P8+'5yr SSHP History'!P14+'5yr SSHP History'!P15+'5yr SSHP History'!P17+'5yr SSHP History'!P59)","v":0},{"$f":"Input!G9","v":0},{"$f":"Q19*(1+$H$3)","v":0},{"$f":"R19*(1+$H$3)","v":0},{"$f":"S19*(1+$H$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,"Total Revenue",null,null,null,null,null,{"$f":"H16+H17+H18+H19","v":0},0,0,0,0,0,0,{"$f":"O16+O17+O18+O19","v":0},{"$f":"P16+P17+P18+P19","v":0},{"$f":"SUM(Q16:Q19)","v":0},{"$f":"SUM(R16:R19)","v":0},{"$f":"SUM(S16:S19)","v":0},{"$f":"SUM(T16:T19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[21,"EXPENSES"]
[22,"Administrative",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L57-'5yr CHFA History'!L48,'5yr SSHP History'!L32-'5yr SSHP History'!L25-'5yr SSHP History'!L31-'5yr SSHP History'!L30+'5yr SSHP History'!L55)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J57-'5yr CHFA History'!J48,'5yr SSHP History'!J32-'5yr SSHP History'!J25-'5yr SSHP History'!J30-'5yr SSHP History'!J31+'5yr SSHP History'!J55)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H57-'5yr CHFA History'!H48,'5yr SSHP History'!H32-'5yr SSHP History'!H25-'5yr SSHP History'!H30-'5yr SSHP History'!H31+'5yr SSHP History'!H55)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F57-'5yr CHFA History'!F48,'5yr SSHP History'!F32-'5yr SSHP History'!F25-'5yr SSHP History'!F30-'5yr SSHP History'!F31+'5yr SSHP History'!F55)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D57-'5yr CHFA History'!D48,'5yr SSHP History'!D32-'5yr SSHP History'!D25-'5yr SSHP History'!D30-'5yr SSHP History'!D31+'5yr SSHP History'!D55)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O57-'5yr CHFA History'!O48,'5yr SSHP History'!O32-'5yr SSHP History'!O25-'5yr SSHP History'!O30-'5yr SSHP History'!O31+'5yr SSHP History'!O55)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P57-'5yr CHFA History'!P48,'5yr SSHP History'!P32-'5yr SSHP History'!P25-'5yr SSHP History'!P30+'5yr SSHP History'!P29+'5yr SSHP History'!P55)","v":0},{"$f":"+Input!G12","v":0},{"$f":"Q22*(1+$H$5)","v":0},{"$f":"R22*(1+$H$5)","v":0},{"$f":"S22*(1+$H$5)","v":0},{"$f":"T22*(1+$H$5)","v":0},{"$f":"U22*(1+$H$5)","v":0},{"$f":"V22*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[23,"Management Fees",null,null,null,null,null,{"$f":"IF($C9=\"X\",'5yr CHFA History'!L48,'5yr SSHP History'!L25)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!J48,'5yr SSHP History'!J25)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!H48,'5yr SSHP History'!H25)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!F48,'5yr SSHP History'!F25)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!D48,'5yr SSHP History'!D25)","v":0},0,0,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!O48,'5yr SSHP History'!O25)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!P48,'5yr SSHP History'!P25)","v":0},{"$f":"+Input!G13","v":0},{"$f":"Q23*(1+$H$5)","v":0},{"$f":"R23*(1+$H$5)","v":0},0,0,0,{"$f":"V23*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[24,"Utilities",null,null,null,null,null,{"$f":"IF($C9=\"X\",'5yr CHFA History'!L63,'5yr SSHP History'!L39-'5yr SSHP History'!L37)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!J63,'5yr SSHP History'!J39-'5yr SSHP History'!J37)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!H63,'5yr SSHP History'!H39-'5yr SSHP History'!H37)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!F63,'5yr SSHP History'!F39-'5yr SSHP History'!F37)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!D63,'5yr SSHP History'!D39-'5yr SSHP History'!D37)","v":0},0,0,{"$f":"IF($C9=\"X\",'5yr CHFA History'!O63,'5yr SSHP History'!O39-'5yr SSHP History'!O37)","v":0},{"$f":"IF($C9=\"X\",'5yr CHFA History'!P63,'5yr SSHP History'!P39)","v":0},{"$f":"+Input!G14","v":0},0,0,0,0,0,{"$f":"V24*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[25,"  Operating & Maintenance",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L87,'5yr SSHP History'!L45+'5yr SSHP History'!L46+'5yr SSHP History'!L60+'5yr SSHP History'!L37)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J87,'5yr SSHP History'!J45+'5yr SSHP History'!J46+'5yr SSHP History'!J60+'5yr SSHP History'!J37)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H87,'5yr SSHP History'!H45+'5yr SSHP History'!H46+'5yr SSHP History'!H60+'5yr SSHP History'!H37)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F87,'5yr SSHP History'!F45+'5yr SSHP History'!F46+'5yr SSHP History'!F60+'5yr SSHP History'!F37)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D87,'5yr SSHP History'!D45+'5yr SSHP History'!D46+'5yr SSHP History'!D60+'5yr SSHP History'!D37)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O87,'5yr SSHP History'!O45+'5yr SSHP History'!O46+'5yr SSHP History'!O60+'5yr SSHP History'!O37)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P87,'5yr SSHP History'!P45+'5yr SSHP History'!P46+'5yr SSHP History'!P60)","v":0},{"$f":"+Input!G15","v":0},0,0,0,0,0,{"$f":"V25*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[26,"Property Taxes",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L88,'5yr SSHP History'!L48)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J88,'5yr SSHP History'!J48)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H88,'5yr SSHP History'!H48)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F88,'5yr SSHP History'!F48)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D88,'5yr SSHP History'!D48)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O88,'5yr SSHP History'!O48)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P88,'5yr SSHP History'!P48)","v":0},{"$f":"+Input!G16","v":0},0,0,0,0,0,{"$f":"V26*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[27,"Property Insurance",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L91,'5yr SSHP History'!L47)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J91,'5yr SSHP History'!J47)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H91,'5yr SSHP History'!H47)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F91,'5yr SSHP History'!F47)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D91,'5yr SSHP History'!D47)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O91,'5yr SSHP History'!O47)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P91,'5yr SSHP History'!P47)","v":0},{"$f":"+Input!G17","v":0},0,0,0,0,0,{"$f":"V27*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[28,"Other Taxes, Insurance",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L90+'5yr CHFA History'!L89+'5yr CHFA History'!L92+'5yr CHFA History'!L93+'5yr CHFA History'!L94+'5yr CHFA History'!L95,'5yr SSHP History'!L30+'5yr SSHP History'!L31)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J90+'5yr CHFA History'!J89+'5yr CHFA History'!J92+'5yr CHFA History'!J93+'5yr CHFA History'!J94+'5yr CHFA History'!J95,'5yr SSHP History'!J30+'5yr SSHP History'!J31)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H90+'5yr CHFA History'!H89+'5yr CHFA History'!H92+'5yr CHFA History'!H93+'5yr CHFA History'!H94+'5yr CHFA History'!H95,'5yr SSHP History'!H30+'5yr SSHP History'!H31)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F90+'5yr CHFA History'!F89+'5yr CHFA History'!F92+'5yr CHFA History'!F93+'5yr CHFA History'!F94+'5yr CHFA History'!F95,'5yr SSHP History'!F30+'5yr SSHP History'!F31)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D90+'5yr CHFA History'!D89+'5yr CHFA History'!D92+'5yr CHFA History'!D93+'5yr CHFA History'!D94+'5yr CHFA History'!D95,'5yr SSHP History'!D30+'5yr SSHP History'!D31)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O90+'5yr CHFA History'!O89+'5yr CHFA History'!O92+'5yr CHFA History'!O93+'5yr CHFA History'!O94+'5yr CHFA History'!O95,'5yr SSHP History'!O30+'5yr SSHP History'!O31)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P90+'5yr CHFA History'!P89+'5yr CHFA History'!P92+'5yr CHFA History'!P93+'5yr CHFA History'!P94+'5yr CHFA History'!P95,'5yr SSHP History'!P30+'5yr SSHP History'!P31)","v":0},{"$f":"+Input!G18","v":0},0,0,0,0,0,{"$f":"V28*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[29,"Misc. Financial Expense",null,null,null,null,null,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!L101+'5yr CHFA History'!L102,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!J101+'5yr CHFA History'!J102,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!H101+'5yr CHFA History'!H102,0)","v":0},{"$f":"IF(C9=\"x\",+'5yr CHFA History'!F101+'5yr CHFA History'!F102,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!D101+'5yr CHFA History'!D102,0)","v":0},0,0,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!O101+'5yr CHFA History'!O102,0)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!P101+'5yr CHFA History'!P102,0)","v":0},{"$f":"+Input!G19","v":0},0,{"$f":"R29*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[30,"Replacement Reserves",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L121,'5yr SSHP History'!L54)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J121,'5yr SSHP History'!J54)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H121,'5yr SSHP History'!H54)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F121,'5yr SSHP History'!F54)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D121,'5yr SSHP History'!D54)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O121,'5yr SSHP History'!O54)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P121,'5yr SSHP History'!P54)","v":0},{"$f":"+Input!G20","v":0},{"$f":"Q30*(1+$H$6)","v":0},{"$f":"R30*(1+$H$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[31,"State Service Fees",null,null,null,null,null,{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!L49)","v":0},{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!J49)","v":0},{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!H49)","v":0},{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!F49)","v":0},{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!D49)","v":0},0,0,{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!O49)","v":0},{"$f":"IF($C9=\"x\",0,'5yr SSHP History'!P49)","v":0},{"$f":"+Input!G21","v":0},0,0,0,0,0,{"$f":"V31*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[32,"RSC / Elderly & Congregate Svc Expense",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L104,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J104,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H104,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F104,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D104,0)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O104,0)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P104,0)","v":0},{"$f":"+Input!G22","v":0},0,0,0,0,0,{"$f":"V32*(1+$H$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[33,"Total Operating expenses",null,null,null,null,null,{"$f":"SUM(H22:H32)","v":0},0,0,0,0,0,0,{"$f":"SUM(O22:O32)","v":0},{"$f":"SUM(P22:P32)","v":0},{"$f":"SUM(Q22:Q32)","v":0},{"$f":"SUM(R22:R32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[34,"Net operating Income",null,null,null,null,null,{"$f":"H20-H33","v":0},0,0,0,0,0,0,{"$f":"O20-O33","v":0},{"$f":"P20-P33","v":0},{"$f":"+Q20-Q33","v":0},{"$f":"R20-R33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[35,"Additional Debt & Expenses",null,null,null,null,null,{"$f":"IF($C9=\"X\",+'5yr CHFA History'!L97+'5yr CHFA History'!L99+'5yr CHFA History'!L100,'5yr SSHP History'!L57)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!J97+'5yr CHFA History'!J99+'5yr CHFA History'!J100,'5yr SSHP History'!J57)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!H97+'5yr CHFA History'!H99+'5yr CHFA History'!H100,'5yr SSHP History'!H57)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!F97+'5yr CHFA History'!F99+'5yr CHFA History'!F100,'5yr SSHP History'!F57)","v":0},{"$f":"IF($C9=\"x\",+'5yr CHFA History'!D97+'5yr CHFA History'!D99+'5yr CHFA History'!D100,'5yr SSHP History'!D57)","v":0},0,0,{"$f":"IF($C9=\"x\",+'5yr CHFA History'!O97+'5yr CHFA History'!O99+'5yr CHFA History'!O100,'5yr SSHP History'!O57)","v":0},{"$f":"IF($C9=\"X\",+'5yr CHFA History'!P97+'5yr CHFA History'!P99+'5yr CHFA History'!P100,'5yr SSHP History'!P57)","v":0},{"$f":"+Input!G25","v":0},{"$f":"$Q$35","v":0},0,0,0,0,0,0,0,0,0,0]
[36,"Debt Service",null,null,null,null,null,{"$f":"IF($C9=\"x\",'5yr CHFA History'!L98+'5yr CHFA History'!L120,'5yr SSHP History'!L50+'5yr SSHP History'!L56)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!J98+'5yr CHFA History'!J120,'5yr SSHP History'!J50+'5yr SSHP History'!J56)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!H98+'5yr CHFA History'!H120,'5yr SSHP History'!H50+'5yr SSHP History'!H56)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!F98+'5yr CHFA History'!F120,'5yr SSHP History'!F50+'5yr SSHP History'!F56)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!D98+'5yr CHFA History'!D120,'5yr SSHP History'!D50+'5yr SSHP History'!D56)","v":0},0,0,{"$f":"IF($C9=\"x\",'5yr CHFA History'!O98+'5yr CHFA History'!O120,'5yr SSHP History'!O50+'5yr SSHP History'!O56)","v":0},{"$f":"IF($C9=\"x\",'5yr CHFA History'!P98+'5yr CHFA History'!P120,'5yr SSHP History'!P50+'5yr SSHP History'!P56)","v":0},{"$f":"Input!E42","v":0},{"$f":"Q36","v":0},{"$f":"R36","v":0},{"$f":"S36","v":0},{"$f":"T36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[37,"Net Cash Flow after Debt Service",null,null,null,null,null,{"$f":"H34-(H35+H36)","v":0},0,0,0,0,0,0,{"$f":"O34-(O35+O36)","v":0},0,{"$f":"Q34-(Q35+Q36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[38,"Debt Service Coverage (DSCR)",null,null,null,null,null,{"$f":"H34/(H35+H36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(O35+O36=0,0,O34/(O35+O36))","v":0},{"$f":"IF(P35+P36=0,0,P34/(P35+P36))","v":0},{"$f":"IF(Q35+Q36=0,0,Q34/(Q35+Q36))","v":0},{"$f":"IF(R35+R36=0,0,R34/(R35+R36))","v":0},{"$f":"IF(S35+S36=0,0,S34/(S35+S36))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,-1,null,null,null,null,"Capital Expenditure Summary",null,null,null,{"$f":"+Q10","v":0},{"$f":"Q41+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Planned Expenditures"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Provision",{"$f":"+Q30","v":0},{"$f":"+R30","v":0},{"$f":"+S30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Beginning Balance R/R",null,null,"Outside Capital",null,{"$f":"+R37","v":0},{"$f":"+S37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!C35","v":0},null,null,"Cumulative Reserve Balance",{"$f":"+M45-Q42+Q43+Q44","v":0},{"$f":"+Q45-R42+R43+R44","v":0},{"$f":"+R45-S42+S43+S44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capital Plan Property Assessment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Capital Needs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Transaction Capital Needs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Subsidy Need"]

{"sheet":"Amortization","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Amortization Schedule"]
[]
["Loan Amount:",null,{"$f":"Input!B29","v":0}]
["Term:",null,{"$f":"Input!E31","v":0.01},"Years"]
["Index Rate:",null,{"$f":"Input!C33","v":0}]
["Spread (includes 20 bp of servicing):",null,{"$f":"Input!D33","v":0}]
["Interest Rate:",null,{"$f":"C8+C9","v":0}]
["Servicing fee",null,0]
["Debt Constant:",null,{"$f":"PMT(C10,C7,-1,0)","v":100}]
["Annual Payment:",null,{"$f":"C6*C12","v":0}]
[]
[null,"Beginning","Debt",null,null,null,"Total","Ending"]
["Year","Balance","Service","Interest","Servicing","Principal","Payment","Balance"]
[1,{"$f":"C6","v":0},{"$f":"C12*B17","v":0},{"$f":"B17*$C$8","v":0},0,{"$f":"C17-D17","v":0},{"$f":"C17+E17","v":0},{"$f":"B17-F17","v":0}]
[{"$f":"A17+1","v":2},{"$f":"H17","v":0},{"$f":"IF(B18=0,0,C17)","v":0},{"$f":"B18*$C$8","v":0},{"$f":"$C$11*B18","v":0},{"$f":"C18-D18-E18","v":0},{"$f":"C18+E18","v":0},{"$f":"B18-F18","v":0}]
[3,0,0,0,0,0,0,0]
[4,0,0,0,0,0,0,0]
[5,0,0,0,0,0,0,0]
[6,0,0,0,0,0,0,0]
[7,0,0,0,0,0,0,0]
[8,0,0,0,0,0,0,0]
[9,0,0,0,0,0,0,0]
[10,0,0,0,0,0,0,0]
[11,0,0,0,0,0,0,0]
[12,0,0,0,0,0,0,0]
[13,0,0,0,0,0,0,0]
[14,0,0,0,0,0,0,0]
[15,0,0,0,0,0,0,0]
[16,0,0,0,0,0,0,0]
[17,0,0,0,0,0,0,0]
[18,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0]
[20,0,0,0,0,0,0,0]
[21,0,0,0,0,0,0,0]
[22,0,0,0,0,0,0,0]
[23,0,0,0,0,0,0,0]
[24,0,0,0,0,0,0,0,{"$f":"SUM(G29:G40)","v":0}]
[25,0,0,0,0,0,0,0]
[26,0,0,0,0,0,0,0]
[27,0,0,0,0,0,0,0]
[28,0,0,0,0,0,0,0]
[29,0,0,0,0,0,0,0]
[30,0,0,0,0,0,0,0]

{"sheet":"Rent Roll","index":7,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,2011]
[null,"Rent",null,"Current","Rent ","New","% "]
["Br Size","at 50% AMI","No Units","Rent","Increase","Base Rent","Change","Months","GPR"]
[1,null,null,null,null,{"$f":"D4+E4","v":0},{"$f":"E4/D4","v":{"$error":"#DIV/0!"}},12,{"$f":"C4*F4*H4","v":0}]
[2,null,null,null,0,{"$f":"D5+E5","v":0},{"$error":"#DIV/0!"},12,{"$f":"C5*F5*H5","v":0}]
[3,null,null,null,0,{"$f":"D6+E6","v":0},{"$error":"#DIV/0!"},12,{"$f":"C6*F6*H6","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I4:I9)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I11/12/28","v":0}]
[null,null,null,null,null,2012]
[null,"Rent*",null,"Current","Rent ","New","% "]
["Br Size","at 50% AMI","No Units","Rent","Increase","Base Rent","Change","Months","GPR"]
[1,{"$f":"B4*1.02","v":0},null,null,0,{"$f":"D16+E16","v":0},{"$f":"E16/D16","v":{"$error":"#DIV/0!"}},6,{"$f":"C16*F16*H16","v":0}]
[2,{"$f":"B5*1.02","v":0},null,null,0,0,{"$error":"#DIV/0!"},6,0]
[3,{"$f":"B6*1.02","v":0},null,null,0,0,{"$error":"#DIV/0!"},6,0]
[1,null,null,{"$f":"F16","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[2,null,null,{"$f":"F17","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[3,null,null,{"$f":"F18","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I16:I21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I23/12/28","v":0}]
[]
[null,null,null,null,null,"2013*"]
[null,"Rent*",null,"Current","Rent ","New","% "]
["Br Size","at 50% AMI","No Units","Rent","Increase","Base Rent","Change","Months","GPR"]
[1,{"$f":"B16*1.02","v":0},null,{"$f":"F19","v":0},0,{"$f":"D29+E29","v":0},{"$f":"E29/D29","v":{"$error":"#DIV/0!"}},6,{"$f":"C29*F29*H29","v":0}]
[2,{"$f":"B17*1.02","v":0},null,{"$f":"F20","v":0},0,0,{"$error":"#DIV/0!"},6,0]
[3,{"$f":"B18*1.02","v":0},null,{"$f":"F21","v":0},0,0,{"$error":"#DIV/0!"},6,0]
[1,null,null,{"$f":"F29","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[2,null,null,{"$f":"F30","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[3,null,null,{"$f":"F31","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I29:I34)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I36/12/28","v":0}]
[]
[null,null,null,null,null,2014]
[null,"Rent*",null,"Current","Rent ","New","% "]
["Br Size","at 50% AMI","No Units","Rent","Increase","Base Rent","Change","Months","GPR"]
[1,{"$f":"B29*1.02","v":0},null,null,0,{"$f":"D42+E42","v":0},{"$f":"E42/D42","v":{"$error":"#DIV/0!"}},6,{"$f":"C42*F42*H42","v":0}]
[2,{"$f":"B30*1.02","v":0},null,null,0,0,{"$error":"#DIV/0!"},6,0]
[3,{"$f":"B31*1.02","v":0},null,{"$f":"F34","v":0},0,0,{"$error":"#DIV/0!"},6,0]
[null,null,null,{"$f":"D42","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[null,null,null,{"$f":"D43","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[null,null,null,{"$f":"F44","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I42:I47)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I49/12/28","v":0}]
[]
[null,null,null,null,null,2015]
[null,"Rent*",null,"Current","Rent ","New","% "]
["Br Size","at 50% AMI","No Units","Rent","Increase","Base Rent","Change","Months","GPR"]
[1,{"$f":"B42*1.02","v":0},null,{"$f":"F45","v":0},0,{"$f":"D55+E55","v":0},{"$f":"E55/D55","v":{"$error":"#DIV/0!"}},6,{"$f":"C55*F55*H55","v":0}]
[2,{"$f":"B43*1.02","v":0},null,{"$f":"F46","v":0},0,0,{"$error":"#DIV/0!"},6,0]
[3,{"$f":"B44*1.02","v":0},null,{"$f":"F47","v":0},0,0,{"$error":"#DIV/0!"},6,0]
[1,null,null,{"$f":"F45","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[2,null,null,{"$f":"F56","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[3,null,null,{"$f":"F57","v":0},null,0,{"$error":"#DIV/0!"},6,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I55:I60)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I62/12/28","v":0}]

{"sheet":"Prepay Calc","index":8,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":true,"merged":[[14,7,14,8]]}
["Name:",{"$f":"IF(+Input!B1=0,\"\",+Input!B1)","v":""}]
["Start Date"]
["Maturity date"]
["Remaining Term to Maturity (in months)",null,null,null,null,null,{"$f":"DAYS360(G2,G3)/360*12","v":0}]
["Balance Prepaid",null,null,null,null,null,{"$f":"IF(G6=0,0,PV(G6/12,G4,-G9))","v":0}]
["INTEREST RATE "]
["ORIGINAL TERM"]
["PAYMENTS PER YEAR",null,null,null,null,null,12]
["CURRENT P&I"]
["REINVESTMENT RATE",null,null,null,null,null,0.04]
["STIFF RATE",null,null,null,null,null,2.0999999999999999E-3]
[null,null,null,null,null,"TEST CALC",{"$f":"PMT(G6/12,G4,-G5)","v":{"$error":"#NUM!"}}]
[]
[]
[null,null,null,null,null,null,null," Interest Income",null,null,null,"PV OF"]
["Rem.","Payment","Beginning","Total","Interest","Principal","Ending"," @","@","Income","PV","Promised"]
["Periods","Date","Principal","Payment","Payment (A)","Payment","Principal",{"$f":"G6","v":0},"STIFF","Differential","Factor","Interest"]
[0,"2011-09-01",0,0,{"$f":"C18*$G$6/12","v":0},{"$f":"D18-E18","v":0},{"$f":"+G5","v":0},{"$f":"E18","v":0},{"$f":"C18*$G$11/12","v":0},{"$f":"H18-I18","v":0},{"$f":"1/(1+$G$11/12)^A18","v":1},{"$f":"H18*K18","v":0}]
[{"$f":"A18+1","v":1},"2011-10-01",{"$f":"G18","v":0},{"$f":"+$G$9","v":0},{"$f":"C19*$G$6/12","v":0},{"$f":"D19-E19","v":0},{"$f":"C19-F19","v":0},{"$f":"E19","v":0},{"$f":"C19*$G$11/12","v":0},{"$f":"H19-I19","v":0},{"$f":"1/(1+$G$11/12)^A19","v":0.99982503061964156},{"$f":"H19*K19","v":0}]
[2,"2011-11-01",{"$f":"G19","v":0},0,0,0,0,0,{"$f":"C20*$G$11/12","v":0},{"$f":"H20-I20","v":0},{"$f":"1/(1+$G$11/12)^A20","v":0.99965009185356701},{"$f":"H20*K20","v":0}]
[3,"2011-12-01",0,0,0,0,0,0,0,0,0.99947518369642008,0]
[4,"2012-01-01",0,0,0,0,0,0,0,0,0.99930030614284515,0]
[5,"2012-02-01",0,0,0,0,0,0,0,0,0.9991254591874873,0]
[6,"2012-03-01",0,0,0,0,0,0,0,0,0.99895064282499269,0]
[7,"2012-04-01",0,0,0,0,0,0,0,0,0.99877585705000893,0]
[8,"2012-05-01",0,0,0,0,0,0,0,0,0.99860110185718387,0]
[9,"2012-06-01",0,0,0,0,0,0,0,0,0.99842637724116656,0]
[10,"2012-07-01",0,0,0,0,0,0,0,0,0.99825168319660695,0]
[11,"2012-08-01",0,0,0,0,0,0,0,0,0.99807701971815643,0]
[12,"2012-09-01",0,0,0,0,0,0,0,0,0.99790238680046628,0]
[13,"2012-10-01",0,0,0,0,0,0,0,0,0.99772778443818966,0]
[14,"2012-11-01",0,0,0,0,0,0,0,0,0.99755321262597973,0]
[15,"2012-12-01",0,0,0,0,0,0,0,0,0.99737867135849201,0]
[16,"2013-01-01",0,0,0,0,0,0,0,0,0.99720416063038164,0]
[17,"2013-02-01",0,0,0,0,0,0,0,0,0.99702968043630513,0]
[18,"2013-03-01",0,0,0,0,0,0,0,0,0.99685523077092031,0]
[19,"2013-04-01",0,0,0,0,0,0,0,0,0.99668081162888511,0]
[20,"2013-05-01",0,0,0,0,0,0,0,0,0.99650642300485925,0]
[21,"2013-06-01",0,0,0,0,0,0,0,0,0.99633206489350301,0]
[22,"2013-07-01",0,0,0,0,0,0,0,0,0.99615773728947687,0]
[23,"2013-08-01",0,0,0,0,0,0,0,0,0.99598344018744422,0]
[24,"2013-09-01",0,0,0,0,0,{"$f":"E42","v":0},{"$f":"C42*$G$10/12","v":0},{"$f":"H42-I42","v":0},{"$f":"1/(1+$G$10/12)^A42","v":0.92323916390167238},{"$f":"J42*K42","v":0}]
[25,"2013-10-01",0,0,0,0,0,0,0,0,0.92017192415449078,0]
[26,"2013-11-01",0,0,0,0,0,0,0,0,0.91711487457258201,0]
[27,"2013-12-01",0,0,0,0,0,0,0,0,0.91406798130157663,0]
[28,"2014-01-01",0,0,0,0,0,0,0,0,0.91103121059957792,0]
[29,"2014-01-01",{"$f":"G46","v":0},0,{"$f":"C47*$G$6/12","v":0},{"$f":"D47-E47","v":0},{"$f":"C47-F47","v":0},0,0,0,0.90800452883678873,0]
[null,"Totals",null,{"$f":"SUM(D18:D46)","v":0},{"$f":"SUM(E18:E46)","v":0},{"$f":"SUM(F18:F46)","v":0},null,{"$f":"SUM(H18:H46)","v":0},{"$f":"SUM(I18:I46)","v":0},{"$f":"SUM(J18:J46)","v":0},null,{"$f":"SUM(L18:L46)","v":0}]
[]
["(A)","PV of 24 months prepaid interest",null,null,{"$f":"SUM(L17:L42)","v":0}]
["(B)","PV  of remaining interest.",null,null,{"$f":"SUM(L43:L47)","v":0}]
["(C)","Total Premium",null,null,{"$f":"E50+E51","v":0}]
["(D)","Prepaid Balance",null,null,{"$f":"G5","v":0}]
[null,"Total  Due ",null,null,{"$f":"E52+E53","v":0}]

{"sheet":"Cap Rate","index":9,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Determining an implied Cap Rate for Valuation calculated within the model."]
[]
[null,null,null,"Return on Equity","Mortage "]
[null,null,"CHFA Internal","Allowed by","Constant"]
[null,null,"Policy LTV","Regulatory","Used for Debt","Cap"]
[null,null,"(Underwriting)","Agreement","Service","Rate"]
[null,"Debt (LOAN)",0.8,null,{"$f":"+Amortization!C12","v":100},{"$f":"C10*E10","v":80}]
[null,"Equity",{"$f":"1-C10","v":0.19999999999999996},0.1,null,{"$f":"C11*D11","v":1.9999999999999997E-2}]
[null,"Total",{"$f":"C10+C11","v":1},null,null,{"$f":"F10+F11","v":80.02}]
[null,"Stabilized "]
[null,"NOI",null,null,null,{"$f":"+Cashflow!R34","v":0}]
[null,"Estimated Value",null,null,null,{"$f":"F14/F12","v":0}]
[]
[null,"Loan",null,null,null,{"$f":"+Input!B29","v":0}]
[null,"LOAN TO VALUE",null,null,null,{"$f":"F17/F15","v":{"$error":"#DIV/0!"}},"LTV"]

{"sheet":"Property Valuation","index":10,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"DESK TOP VALUATION OF PROPERTY"]
[null,null,"CHFA's cost of capital Index",null,0.04]
[null,null,"Property default spread*****",null,1.4999999999999999E-2]
[null,null,"Total Discount rate applied to cash flows",null,{"$f":"E3+E4","v":5.5E-2}]
[null,null,null,null,null,null,"PV of","Col C * Col F"]
[null,null,null,null,null,null,"The ","PV of "]
[null,0,"NOI****","TerminaL Value**",null,"PVIF","Terminal Value","NOI's"]
[null,1,{"$f":"Cashflow!Q34","v":0},null,null,{"$f":"1/(1+$E$5)^B9","v":0.94786729857819907},null,{"$f":"C9*F9","v":0}]
[null,{"$f":"B9+1","v":2},{"$f":"Cashflow!R$34","v":0},null,null,{"$f":"1/(1+$E$5)^B10","v":0.89845241571393286},null,{"$f":"C10*F10","v":0}]
[null,{"$f":"B10+1","v":3},{"$f":"Cashflow!S34","v":0},null,null,0.85161366418382267,null,0]
[null,4,{"$f":"Cashflow!T34","v":0},null,null,0.80721674330220161,null,0]
[null,5,{"$f":"Cashflow!U34","v":0},null,null,0.76513435384094941,null,0]
[null,6,{"$f":"Cashflow!V34","v":0},null,null,0.72524583302459655,null,0]
[null,7,{"$f":"Cashflow!W34","v":0},null,null,0.68743680855412004,null,0]
[null,8,{"$f":"Cashflow!X34","v":0},null,null,0.6515988706674124,null,0]
[null,9,{"$f":"Cashflow!Y34","v":0},null,null,0.6176292612961255,null,0]
[null,10,{"$f":"Cashflow!Z34","v":0},{"$f":"C19/F23","v":0},null,0.58543057942760712,{"$f":"D18*F18","v":0},{"$f":"(C18*F18)+G18","v":0}]
[null,11,{"$f":"Cashflow!AA34","v":0}]
[null,null,"ESTIMATED VALUE ******",null,null,"PV",null,{"$f":"SUM(H9:H18)","v":0}]
[]
[]
[null,null,"Discount Rate + spread for a declining NOI* = Term CAP***",null,null,{"$f":"(E5-(-0.02))","v":7.4999999999999997E-2}]
[null,null,"NOTES"]
[null,null,"* Reasonable to use the 2% growth rate in rent"]
[]
[null,null,"** Terminal Value in year 10 = 11th year NOI/Terminal Cap rate. This terminal value is then discounted at the "]
[null,null,"total discount rate developed in cell E5"]
[null,null,"*** The terminal cap rate is based on the formula: (CHFA's required rate of return - growth rate in rental income)."]
[null,null,"This computation is applicable when the average long run growth rate in NOI is expected to be declining. This is the case in most of our deals"]
[null,null,"where NOI is declining and eventually crosses operating expenses (otherwise known as \"it crashes\")."]
[null,null,"The term cap rate should be higher in older buildings as they depreciate faster."]
[null,null,"**** NOI is before debt service, which is the correct measure for valuing properties."]
[null,null,"***** Property default spread captures the risk in the cash flows. If the property has section 8, the spread may be lowered to 1%. However,"]
[null,null,"The term cap rate should be increased by that amount to reflect the uncertainty of a HAP renewal in the out years."]
[null,null,"****** Estimated Value = PV of the NOI's + the Present Value of the property."]

{"sheet":"Notes","index":12,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,1,17,7]]}
["Summary Master"]
[null,"Input numbers into the yellow areas, the blue areas will adjust accordingly."]
[]
["Capital Needs"]
[null," Input manually."]
[]
["Summary Back-up"]
[null,"All formulas.  Print to see % change scenarios"]
[]
["Current RR"]
[null,"Input tenant information in columns 1,2,4,7"]
[null,"Columns S & U can be used to calculate mid year rent increases. "]
[null,null,"(mgt plan will need to be adapted.)"]
["Working RR"]
[null,"Formulas"]
[null,"Columns S & U can be used to calculate mid year rent increases. "]
["Mgt Plan"]
[null,"Enter #'s where appropriate.  Rent area might need to be adjusted for mid year increases."]
[]
["Cash Flow"]
[0.3]
[0.31]
[0.32]
[0.33]
[0.34]
[0.35]

{"sheet":"Sheet1","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}