{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WorkSheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"WorkSheet","index":0,"n_rows":126,"n_cols":9,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["Budget Worksheet",null,null,null,null,"U.S. Department of Housing",null,null,"OMB Approval No. 2502-0324"]
["Income and Expense Projections",null,null,null,null,"and Urban Development",null,null,"(exp. 12/31/2014)"]
[null,null,null,null,null,"Office of Housing"]
[null,null,null,null,null,"Federal Housing Commissioner"]
[]
["Public reporting burden for this collection of information is estimated to average 1.5 hours per response, including the time for reviewing instructions,"]
["searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.    This agency"]
["may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number."]
[]
["This information is collected in accordance with Title II of the National Housing Act which requires that HUD regulate rents for certain cooperative and"]
["subsidized rental projects.  The Department formulated the processes by which owners could request increases.  The requirement for tenant participation"]
["in the rent increase process, which is included in Section 202(b) of the HCD Amendments of 1978, necessitated that the Department design procedures"]
["to give consideration to tenant comments.   The information gathered is not of a confidential nature.  The information is required in order to obtain benefits."]
["Project Number",null,null,null,"Name of Project"]
[]
[]
["Description of Account",null,null,null,null,"Acct.No.","Statement of Profit/Loss FY__ ","Current FY  (no. of mos.    ) ","Budget from (          ) to (           )"]
["Rental","Rent Revenue - Gross Potential",null,null,null,"5120"]
["Income","Tenant Assistance Payments",null,null,null,"5121"]
["5100","Rent Revenue - Stores and Commercial",null,null,null,5140]
[null,"Garage and Parking Spaces",null,null,null,"5170"]
[null,"Flexible Subsidy Revenue",null,null,null,"5180"]
[null,"Miscellaneous Rent Revenue",null,null,null,"5190"]
[null,"Excess Rent",null,null,null,"5191"]
[null,"Rent Revenue/ Insurance",null,null,null,"5192"]
[null,"Special Claims Revenue",null,null,null,"5193"]
[null,"Retained Excess Income",null,null,null,"5194"]
[null,"Total Rent Revenue Potential at 100% Occupancy",null,null,null,"5100T",{"$f":"SUM(G18:G27)","v":0},{"$f":"SUM(H18:H27)","v":0},{"$f":"SUM(I18:I27)","v":0}]
["Vacancies","Apartments",null,null,null,"5220"]
["5200","Stores and Commercial",null,null,null,"5240"]
[null,"Rental Concessions",null,null,null,"5250"]
[null,"Garage and Parking Spaces",null,null,null,"5270"]
[null,"Miscellaneous",null,null,null,"5290"]
[null,"Total Vacancies",null,null,null,"5200T",{"$f":"SUM(G29:G33)","v":0},{"$f":"SUM(H29:H33)","v":0},0]
[null,"Net Rental Revenue (Rent Revenue less Vacancies)",null,null,null,"5152N",{"$f":"G28-G34","v":0},{"$f":"H28-H34","v":0},{"$f":"I28-I34","v":0}]
["Income","Nursing Homes/ Assisted Living/ Board & Care/",null,null,null,"5300"]
["5300","Other Elderly Care/ Coop/ Other Revenues"]
["Financial","Financial Revenue -Project Operations ",null,null,null,5410]
["Revenue","Revenue from Investments-Residual Receipts ",null,null,null,5430]
["5400","Revenue from Investments-Replacement Reserve",null,null,null,"5440"]
[null,"Revenue from Investments-Miscellaneous ",null,null,null,5490]
[null,"Total Financial Revenue",null,null,null,"5400T",{"$f":"SUM(G38:G41)","v":0},{"$f":"SUM(H38:H41)","v":0},{"$f":"SUM(I38:I41)","v":0}]
["Other","Laundry and Vending Revenue",null,null,null,"5910"]
["Revenue","Tenant Charges",null,null,null,"5920"]
["5900","Interest Reduction Payments Revenue",null,null,null,"5945"]
[null,"Gifts (nonprofits)",null,null,null,"5970"]
[null,"Miscellaneous Revenue",null,null,null,"5990"]
[null,"Total Other Revenue",null,null,null,"5900T",{"$f":"SUM(G43:G47)","v":0},{"$f":"SUM(H43:H47)","v":0},0]
[null,"Total Revenue",null,null,null,"5000T",{"$f":"SUM(G35+G36+G37+G42+G48)","v":0},{"$f":"SUM(H35+H36+H37+H42+H48)","v":0},{"$f":"SUM(I35+I36+I37+I42+I48)","v":0}]
["Admin.","Conventions and Meetings",null,null,null,"6203"]
["Expenses","Management Consulants",null,null,null,"6204"]
["6200/","Advertising and Marketing",null,null,null,"6210"]
["6300","Other Renting Expense",null,null,null,"6250"]
[null,"Office Salaries",null,null,null,"6310"]
[null,"Office Expenses",null,null,null,"6311"]
[null,"Office or Model Apartment Rent",null,null,null,"6312"]
[null,"Management Fee",null,null,null,"6320"]
[null,"Manager or Superintendent Salaries",null,null,null,"6330"]
[null,"Administrative Rent Free Unit",null,null,null,"6331"]
[null,"Legal Expenses - Project",null,null,null,"6340"]
[null,"Audit Expenses",null,null,null,"6350"]
[null,"Bookkeeping Fees/Accounting Services ",null,null,null,6351]
[null,"Miscellaneous Administrative Expenses",null,null,null,"6390"]
[null,"Total Administrative Expenses",null,null,null,"6263T",{"$f":"SUM(G50:G63)","v":0},{"$f":"SUM(H50:H63)","v":0},0]
[]
[]
[]
[]
["Previous editions are obsolete",null,null,null,null,null,"page 1 of 2","       ref. Handook 4350.1            form HUD-92547-A  (8/2000)"]
["Description of Account",null,null,null,null,"Acct.No.",{"$f":"G17","v":"Statement of Profit/Loss FY__ "},{"$f":"H17","v":"Current FY  (no. of mos.    ) "},{"$f":"I17","v":"Budget from (          ) to (           )"}]
["Utilities","Fuel Oil/Coal",null,null,null,"6420"]
["6400","Electricity",null,null,null,"6450"]
[null,"Water",null,null,null,"6451"]
[null,"Gas",null,null,null,"6452"]
[null,"Sewer",null,null,null,"6453"]
[null,"Total Utilities Expense",null,null,null,"6400T",{"$f":"SUM(G71:G75)","v":0},{"$f":"SUM(H71:H75)","v":0},0]
["Operating","Payroll",null,null,null,"6510"]
["& Mainten.","Supplies",null,null,null,"6515"]
["Expenses","Contracts",null,null,null,"6520"]
["6500","Operating and Maintenance Rent Free Unit ",null,null,null,6521]
[null,"Garbage and Trash Removal",null,null,null,"6525"]
[null,"Security Payroll/Contract",null,null,null,"6530"]
[null,"Security Rent Free Unit",null,null,null,"6531"]
[null,"Heating/Cooling Repairs and Maintenance",null,null,null,6546]
[null,"Snow Removal",null,null,null,"6548"]
[null,"Vehicle & Maint. Equip. Oper. and Repair",null,null,null,"6570"]
[null,"Misc. Operating & Maintenance Expenses ",null,null,null,6590]
[null,"Total Operating & Maintenance Expenses",null,null,null,"6500T",{"$f":"SUM(G77:G87)","v":0},{"$f":"SUM(H77:H87)","v":0},0]
["Taxes and","Real Estate Taxes",null,null,null,"6710"]
["Insurance","Payroll Taxes (Project's share)",null,null,null,"6711"]
["6700","Property and Liability Insurance (Hazard) ",null,null,null,6720]
[null,"Fidelity Bond Insurance",null,null,null,"6721"]
[null,"Workmen\\uc1\\u8217Xs Compensation",null,null,null,"6722"]
[null,"Health Insurance & Other Employee Benefits ",null,null,null,6723]
[null,"Misc. Taxes, Licen., Permits, & Insurance",null,null,null,6790]
[null,"Total  Taxes & Insurance",null,null,null,"6700T",{"$f":"SUM(G89:G95)","v":0},{"$f":"SUM(H89:H95)","v":0},0]
["Financial","Interest on Mortgage Payable",null,null,null,"6820"]
["Expenses","Interest on Notes Payable (Long-Term) * ",null,null,null,6830]
["6800","Interest on Notes Payable (Short-Term) *",null,null,null,"6840"]
[null,"Mortgage Insurance Premium/Service Charge ",null,null,null,6850]
[null,"Miscellaneous Financial Expenses",null,null,null,"6890"]
[null,"Total  Financial Expenses",null,null,null,"6800T",{"$f":"SUM(G97:G101)","v":0},{"$f":"SUM(H97:H101)","v":0},0]
["Expenses","Nursing Homes/ Assisted Living/ Board & Care/",null,null,null,6900]
["6900","Other Elderly Care/ Coop/  Other Revenues"]
[null,"Total Cost of Operations",null,null,null,"6000T",{"$f":"SUM(G64+G76+G88+G96+G102+G103+G104)","v":0},{"$f":"SUM(H64+H76+H88+H96+H102+H103+H104)","v":0},{"$f":"SUM(I64+I76+I88+I96+I102+I103+I104)","v":0}]
[null,"Reserve for Replacements Dep. Required"]
[null,"Principal Payments Required"]
[null,"Debt Service for other approved loans"]
[null,"Debt Service Reserve (if required)"]
[null,"General Operating Reserve (Coops)"]
[null,"Total Cash Requirements",null,null,null,null,{"$f":"G105+SUM(G106:G110)","v":0},{"$f":"H105+SUM(H106:H110)","v":0},{"$f":"I105+SUM(I106:I110)","v":0}]
[null,"Less Total Revenue",null,null,null,null,{"$f":"G49","v":0},{"$f":"H49","v":0},0]
[null,"Net Cash Surplus (Deficiency)",null,null,null,null,{"$f":"G112-G111","v":0},{"$f":"H112-H111","v":0},0]
[]
[]
[]
[]
[]
[]
["I hereby certify that all the information stated herein, as well as any information provided in the accompaniment herewith, is true and accurate."]
["Warning:  HUD will prosecute false claims and statements.  Conviction may result in criminal and/or civil penalties.  (18 U.S.C. 1001, 1010, 1012;   31 U.S.C. 3729, 3802)"]
["(Signature)",null,null,null,null,null,null,null,"Date (mm/dd/yyyy)"]
[]
[]
["Previous editions are obsolete",null,null,"* HUD Approved Secondary Financing",null,null,"page 2 of 2","       ref. Handook 4350.1            form HUD-92547-A  (8/2000)"]
[null,null,null,"Only for Budget Projections."]