{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["P&L Statement","Balance Sheet","SD_Dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":46,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"P&L Statement","index":0,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,1,1,3]]}
["Property Financials"]
["Property Name"]
["HFA Number"]
["Number of Units "]
["Fiscal Year"]
["Beginning Date"]
["Ending Date"]
[]
["1. EFFECTIVE GROSS INCOME"]
["    A. Total Possible Residential Rents"]
["    B. Less Bad Debt Expense-Any other outstanding debt other than vacancies "]
["    C. Commercial Rents"]
["    D. Less Vacancy & Concessions (All-Apt and Comm)"]
["    E. Laundry, Parking & Other Revenue"]
["    F. Other Income not stated above"]
["Total Effective Gross Income",{"$f":"(B10+B12+B14+B15)-B11-B13","v":0}]
["2.  OPERATING EXPENSES"]
["   A. Management Fee"]
["   B. Legal & Audit"]
["   C. Advertising"]
["   D. Gas & Electric, telephone, cable expense"]
["   E. Water & Sewer "]
["   F. Supplies and any replacement costs"]
["   G. Total staff Payroll (wages and benefits including payroll taxes)"]
["   H. Waste Removal/Garbage"]
["   I. Pest Control-All costs associated with extermination contract or otherwise"]
["   J. Repairs-Supplies and material"]
["   K. Maintenance-Contract labor"]
["   L. Grounds-Including grounds maintenance, snow removal, lawn service"]
["   M.  Insurance-All property insurance costs"]
["   N. Other Administrative Expenses that are not addressed above"]
["   O. Depreciation/Amortization"]
["   P. Mortgage Interest Expense"]
["   Q. Interest Expense Other"]
[null,null,"Categorized costs owner felt should be itemized (Identify amount in associated light brown box) "]
[null,null,"Categorized costs owner felt should be itemized (Identify amount in associated light brown box) "]
["3. TAXES & FEES"]
["   A. Real Estate Taxes"]
["   B. State or Local Tax or Other Assessments"]
[null,null,"Any other Tax or Assessment owner felt should be itemized (Identify amount in associated light brown box)"]
["    Total Operating Expenses",{"$f":"SUM(B18:B40)","v":0}]
["    NET INCOME (LOSS)",{"$f":"B16-B41","v":0}]
["    ADD BACK: DEPRECIATION/AMORTIZATION EXPENSE",{"$f":"B32","v":0}]
["    ADD BACK: MORTGAGE INTEREST EXPENSE",{"$f":"+B33+B34","v":0}]
["4. LESS:  REQUIRED RESERVE & OTHER DEPOSITS"]
["   A. Replacement Reserves (Key as a positive amount)"]
["   B. Operating Reserves (Key as a positive amount)"]
["   C. Distributions Paid (Key as a positive amount)"]
["5. TOTAL RESERVE & OTHER DEPOSITS",{"$f":"SUM(B46:B48)","v":0}]
["    NET OPERATING INCOME (NOI)",{"$f":"SUM(B42:B44)-B49","v":0}]
["6 ANNUAL DEBT SERVICE"]
["    1ST MORTGAGE ANNUAL P&I"]
["    2ND MORTGAGE ANNUAL P&I"]
["    OTHER DEBT SERVICE TO BE INCLUDED IN DCR CALC"]
["    TOTAL DEBT SERVICE P&I",{"$f":"SUM(B52:B54)","v":0}]
[" DEBT COVERAGE RATIO",{"$f":"B50/B55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Balance Sheet","index":1,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,1,2,2]]}
["Balance Sheet"]
[]
["Property Name"]
[]
["HFA Number"]
[]
["Fiscal Year End"]
[]
[]
[]
["Cash, Reserves & Investments:"]
["General Fund/Operating Cash"]
["Tenant Security Deposits Cash"]
["Other Cash/Petty Cash"]
["Operating/Other Reserve"]
["Replacement Reserve"]
["Distributions to Partnership  ",{"$f":"B48","v":0}]
["Mortgage Escrow"]
["Investments"]
["Total Cash, Reserves, & Investments",{"$f":"SUM(B12:B19)","v":0}]
[]
["Accounts Receivable:"]
["Tenants"]
["Other AR"]
["Other AR"]
["Total Accounts Receivable",{"$f":"SUM(B23:B25)","v":0}]
[]
["Prepaids:"]
["Prepaid Insurance"]
["Other Prepaid"]
["Total Prepaids",{"$f":"SUM(B29:B30)","v":0}]
[]
["Fixed Assets:"]
["Total Fixed Assets/Property, Equipment and Land"]
["Less:  Accumulated Depreciation"]
["Net Property, Equipment and Land",{"$f":"B34+B35","v":0}]
[]
["Other Assets:"]
["Intangible Assets"]
["Less:  Accumulated Amortization"]
["Other"]
["Net Other Assets",{"$f":"SUM(B39:B41)","v":0}]
[]
["TOTAL ASSETS",{"$f":"B20+B26+B31+B36+B42","v":0}]
[]
[]
[]
[]
["Current Liabilities:"]
["Accounts Payable"]
["Accrued Management Fees/RE Taxes/Prop Ins"]
["Tenant Security Deposits Liability"]
["Unearned Rental Income"]
["Accrued Interest Payable"]
["Current Portion - Mortgage(s) Long Term Debt"]
["Other"]
["Other"]
["Total Current Liabilities",{"$f":"SUM(B50:B57)","v":0}]
[]
["Long-term Liabilities:"]
["Mortgage(s) Payable, Net of Current Portion"]
["Other L/T loans"]
["Other L/T loans"]
["Total Long-term Liabilities",{"$f":"SUM(B61:B63)","v":0}]
[]
["TOTAL LIABILITIES",{"$f":"B58+B64","v":0}]
[]
["Partners' Equity (Deficit)"]
[]
["TOTAL LIABILITIES & OWNER EQUITY/PARTNER CAPITAL",{"$f":"B68+B66","v":0}]
[]
["Balance Sheet out of balance check (Total Assets - Total Liabs. & Equity/Capital should = $0)"]

{"sheet":"SD_Dropdowns","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}