{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cash Flow"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Cash Flow","index":0,"n_rows":53,"n_cols":3,"rows_kept":53,"merged":[[0,0,0,2],[2,0,2,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[37,0,37,2],[47,0,47,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2]]}
["FinePoint Associates Template for Annual Cash Flow Reporting "]
[]
["HOME, AHTF, CIPF, CATNHP, HTF, HSF, TOD programs:\nCash flow template can be substituted with a fiscal year annual cash flow report which provides the same information requested below, including annual cash flow net depreciation and amorization. Statement of cash flows from audited financials will not be accepted for this requirement.  "]
[]
["DEVELOPER:"]
["PROJECT:"]
["YEAR END:"]
["TOTAL UNITS:"]
[null,null,"From Profit and Loss Statement (note on accrual basis) or Cash Flow Statement \n(note on cash basis)"]
["FUNDS RECEIVED"]
["Base Rental",null,"Profit and Loss"]
["less vacancies",null,"Profit and Loss"]
["less bad debts",null,"Profit and Loss"]
["Effective Rental Income",{"$f":"B11-B12-B13","v":{"v":0,"d":"$0.00"}},"(Base Rental minus vacancies minus bad debts)"]
["Interest Income",null,"Profit and Loss"]
["Miscellaneous Income",null,"Please Describe ___________________________"]
["Effective Income",{"$f":"B14+B15+B16","v":{"v":0,"d":"$0.00"}},"(Effective Rental Income plus Interest Income plus Misc. Income)"]
["Received from Reserves",null,"Cash Flow"]
["Received from Escrows",null,"Cash Flow"]
["TOTAL FUNDS RECEIVED",{"$f":"B17+B18+B19","v":{"v":0,"d":"$0.00"}},"(Effective Income plus Received from Reserves and Escrows)"]
[]
["FUNDS DISBURSED"]
["Administration",null,"Profit and Loss"]
["Utilities",null,"Profit and Loss"]
["Maintenance",null,"Profit and Loss"]
["Marketing and Leasing",null,"Profit and Loss"]
["Resident Services",null,"Profit and Loss"]
["Taxes and Insurance",null,"Profit and Loss"]
["Deposits to Reserves",null,"Cash Flow"]
["Deposits to Escrows",null,"Cash Flow"]
["Capital Expenditures",null,"Cash Flow"]
["Debt Service*",null,"Cash Flow for Principal and Profit and Loss for Interest"]
["Miscellaneous Disbursed",null,"Please Describe ________________________________________"]
["TOTAL FUNDS DISBURSED",{"$f":"SUM(B23:B33)","v":{"v":0,"d":"$0.00"}},"(Sum of Funds Disbursed)"]
[]
["NET FUNDS FLOW",{"$f":"B20-B34","v":{"v":0,"d":"$0.00"}},"(Total Funds Received minus Total Funds Disbursed)"]
["PER UNIT FUNDS FLOW",{"$f":"B36/B8","v":{"$error":"#DIV/0!"}}]
[]
["FOR HIF, CBH, and FCF projects only"]
["FUNDS FLOW RATIO",{"$f":"B20/B34","v":{"$error":"#DIV/0!"}},"(Total Funds Received divided by Total Funds Disbursed)"]
["FLOW ALLOWED**",{"$f":"B34*1.05","v":{"v":0,"d":"$0.00"}},"(Total Funds Disbursed multiplied by 1.05) "]
["SURPLUS FUNDS",{"$f":"B20-B41","v":{"v":0,"d":"$0.00"}},"(Total Funds Received minus Funds Allowed)"]
[]
[]
["*- only include Debt Service that has been paid in the past year or that is a current payable"]
["**- if HIF I change cell to 1.15 from 1.05"]
[]
["Disclaimer- This template includes a sample of standard items. If your project has unique additional items, please customize the template to fit your situation."]
[]
["Prepared By "]
["Date:"]
["Phone Number: "]
["Email: "]