{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dev Project List","Dev Fin Capacity"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"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":"Dev Project List","index":0,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,2,17]]}
[]
["Complete this table by detailing up to five of the housing developments undertaken by your organization in the past four (4) years. Do not leave any column items blank. If your organization performed more than one role per project make sure you repeat that project on another line so all roles are disclosed. If needed, additional experience may be submitted in a separate worksheet containing all column headers below. Describe changes to the development team that occured since projects were completed, if applicable. Please use the examples below as a guide. "]
[]
[]
[null,"Project Name","Project Address","City","State","Developer Name","Prior Developer Name (if applicable)","Development Team Members Involved","Role in Past Development","# of Units","New Construction or Rehab?","For-Sale or Rent?","Year Completed or Management Assumed","% Complete (if applicable)","Permit Number","Primary Source of Funds","Secondary Source of Funds","Occupancy Percentage"]
["Example","Project X","1234 Apple Ln.","Cleveland","Ohio","XYZ Developers","ABC Developers","John Doe","Developer",4,"Rehab","Rent","1905-07-11",1,"B12345678","Bank Loan","Developer Equity"]
["Example",null,null,null,null,null,null,"Jane Jones","Contractor"]
["Example","Project Y","5678 Pear Rd.","Cleveland","Ohio","XYZ Developers","ABC Developers","John Doe","Developer",5,"New Construction","For-Sale","1905-07-12",0.6,"B10000001","Developer Equity","Local Grant"]
["Example",null,null,null,null,null,null,"Bill Smith","Project Manager"]
[]
[1]
[{"$f":"A11+1","v":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]
[30]
[31]
[32]
[33]
[34]
[35]

{"sheet":"Dev Fin Capacity","index":1,"n_rows":137,"n_cols":6,"rows_kept":137,"cut":false,"hidden":true,"merged":[[132,5,136,5],[59,5,64,5],[67,5,69,5],[72,5,74,5],[77,5,83,5],[89,5,92,5],[94,5,97,5],[99,5,102,5],[105,5,107,5],[110,5,112,5],[118,5,121,5],[126,5,129,5]]}
["Instructions for Completing the Financial Analysis Sheet "]
[]
["The HOME regulations require the City to evaluate the fiscal soundness of applicants seeking HOME funds. The City must determine if the "]
["applicant has acceptable financial capacity based on the size, scope and complexity of the project. "]
["The City will determine if the developer has the financial capacity necessary to complete the proposed project and will evaluate the developer's net worth,"]
["portfolio risk, pre-development funding and liquidity. Developers with limited financial resources will only be considered for projects where cash needs"]
["will not exceed the developer's net or liquid assets. "]
[]
["This sheet contains the spreadsheets for the 2020 HTF RFP application to facilitate the analysis of the applicant's finances.  "]
[]
["Submitting the financial analysis:"]
["Hard (paper) copy: must be submitted as the appropriate exhibit in your application along with the appropriate audited financial statements."]
["Electronic copy: may be submitted with your application, either on disk or via email to ",null,null,"CD-DND@city.cleveland.oh.us"]
[]
["Filling out the financial analysis workbook:"]
["The worksheets have been protected.  Applicants should  complete the information on the data entry sheet using the organizations stand alone figures from "]
[" their audited financial statement.  The page number for each entry should be referenced on the form in the gray cell.    "]
[]
["Use the TAB key to navigate through the worksheet: it will bring your cursor only to those cells that need entries.  Excel will calculate figures for the "]
["Income Statement Ratio, Balance Sheet Ratio and Operating Cycle Ratio.  Please review these worksheets. Use the yellow cells  next to these calculation "]
["to provide explanation or mitigating factors.   Reference page number in the audit if appropriate.  "]
[]
["If you have questions, or have special circumstances and need to further manipulate the spreadsheets, please contact Michael McBride at 216-664-2005 or "]
["mmcbride@city.cleveland.oh.us"]
[]
[]
["**Input data in cream colored fields.**"]
["FIELD ",2016,2017,2018,2019,"Comments"]
["Income Statement"]
["Revenue"]
["Operating Expenses "]
["Depreciation"]
["Taxes & Insurance"]
[]
["Balance Sheet"]
["Cash & Marketable Securities & Other Investments"]
["Receivables"]
["Current Assets"]
["Non Current Assets"]
["Non-Current Related-party receivables"]
["Payables"]
["Current Liabilities"]
["Long Term Liabilities"]
["Unrestricted Net Assets"]
[]
["Cash Flows"]
["Net Cash After Operating Activities"]
["Net Cash Used in Investing Activities"]
["Net Cash Used in Capital Expenditures"]
["Net Cash Provided by Financing Activities"]
["Net Increase/Decrease in Cash"]
["Cash at Beginning of Year"]
["Cash at End of Year"]
[]
[]
["Calculating Income Statement Ratios and Cash flow Analysis"]
[]
[null,{"$f":"+B28","v":2016},{"$f":"+C28","v":2017},2018,2019,"Developer's Analysis Comments "]
["Revenue Growth - How much has the Company's Revenue Grown"]
["This Year's Revenue",null,{"$f":"C30","v":0},{"$f":"D30","v":0},{"$f":"E30","v":0}]
["- Last year's Revenue",null,{"$f":"B30","v":0},{"$f":"C30","v":0},{"$f":"D30","v":0}]
["= Revenue Difference",null,{"$f":"C60-C61","v":0},{"$f":"D60-D61","v":0},{"$f":"E60-E61","v":0}]
["/ Last Year's Revenue",null,{"$f":"C62/C61","v":{"$error":"#DIV/0!"}},{"$f":"D62/D61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["x 100"]
["=% of Revenue Growth",null,{"$f":"C63","v":{"$error":"#DIV/0!"}},{"$f":"D63","v":{"$error":"#DIV/0!"}},{"$f":"E63","v":{"$error":"#DIV/0!"}}]
[]
["Operating Profit/Revenue:  Has the company maintained its Gross Profit Margin?"]
["Operating Profit",{"$f":"B30-B31","v":0},{"$f":"C30-C31","v":0},{"$f":"D30-D31","v":0},{"$f":"E30-E31","v":0}]
["/Revenue",{"$f":"B30","v":0},{"$f":"C30","v":0},{"$f":"D30","v":0},{"$f":"E30","v":0}]
["= as % of Revenue",{"$f":"B68/B69","v":{"$error":"#DIV/0!"}},{"$f":"C68/C69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Operating Expenses/Revenue:  Has the company been able to control its operating costs?"]
["Operating Expenses ",{"$f":"B31","v":0},{"$f":"C31","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0}]
["/Revenue",{"$f":"B30","v":0},{"$f":"C30","v":0},{"$f":"D30","v":0},{"$f":"E30","v":0}]
["= as % of Revenue",{"$f":"B73/B74","v":{"$error":"#DIV/0!"}},{"$f":"C73/C74","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[" Cash Flow Analysis"]
["Net Increase/Decrease in Cash",{"$f":"B51","v":0},{"$f":"C51","v":0},{"$f":"D51","v":0},{"$f":"E51","v":0}]
["Net Cash After Operating Activities",{"$f":"B47","v":0},0,0,0]
["Net Cash Used in Investing Activities",0,0,0,0]
["Net Cash Used in Capital Expenditures",0,0,0,0]
["Net Cash Provided by Financing Activities",0,0,0,0]
["Cash and Cash Equivalents, end of year",{"$f":"B36","v":0},{"$f":"C36","v":0},{"$f":"D36","v":0},{"$f":"E36","v":0}]
["Days Cash  ",{"$f":"(B36/B31)*360","v":{"$error":"#DIV/0!"}},{"$f":"(C36/C31)*360","v":{"$error":"#DIV/0!"}},{"$f":"(D36/D31)*360","v":{"$error":"#DIV/0!"}},{"$f":"(E36/E31)*360","v":{"$error":"#DIV/0!"}}]
[]
[]
["Calculating Balance Sheet Ratios"]
[null,{"$f":"+B58","v":2016},{"$f":"+C58","v":2017},2018,2019,"Developer's Analysis Comments "]
["Current Ratio:  Can company generate current/operating cash to pay bills due in next 12 months"]
["Current Assets",{"$f":"B38","v":0},{"$f":"C38","v":0},{"$f":"D38","v":0},{"$f":"E38","v":0}]
["/Current Liabilities",{"$f":"B42","v":0},{"$f":"C42","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0}]
["= Current Ratio",{"$f":"B90/B91","v":{"$error":"#DIV/0!"}},{"$f":"C90/C91","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Working Capital:  How much cash remains after the company pays its bills in next 12 months"]
["Current Assets",{"$f":"B38","v":0},{"$f":"C38","v":0},{"$f":"D38","v":0},{"$f":"E38","v":0}]
[" -Current Liabilities",{"$f":"B42","v":0},{"$f":"C42","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0}]
["= Working Capital",{"$f":"B95-B96","v":0},{"$f":"C95-C96","v":0},0,0]
[]
["Days Current Assets:  How many days cash is available"]
["Current Assets",{"$f":"B38","v":0},{"$f":"C38","v":0},{"$f":"D38","v":0},{"$f":"E38","v":0}]
["/Operating Expense",{"$f":"B31","v":0},{"$f":"C31","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0}]
["x 360 days in Period",{"$f":"B100/B101","v":{"$error":"#DIV/0!"}},{"$f":"C100/C101","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["= Days Cash on total current assets",{"$f":"B102*360","v":{"$error":"#DIV/0!"}},{"$f":"C102*360","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Debt Ratio:  How has the company financed operations between debt & assets?"]
["Total Liabilities (assuming Current Liabilities and Long Term Liabilities)",{"$f":"B42+B43","v":0},{"$f":"C42+C43","v":0},{"$f":"D42+D43","v":0},{"$f":"E42+E43","v":0}]
["/ Total Assets (assuming Current Assets+Non-Current Assets)",{"$f":"B39+B38","v":0},{"$f":"C39+C38","v":0},{"$f":"D39+D38","v":0},{"$f":"E39+E38","v":0}]
["= Debt Ratio",{"$f":"B106/B107","v":{"$error":"#DIV/0!"}},{"$f":"C106/C107","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Debt to Equity Ratio:  "]
["Total Liabilities",{"$f":"B42+B43","v":0},{"$f":"C42+C43","v":0},{"$f":"D42+D43","v":0},{"$f":"E42+E43","v":0}]
["/ Net Unrestricted Assets",{"$f":"B44","v":0},{"$f":"C44","v":0},{"$f":"D44","v":0},{"$f":"E44","v":0}]
["= Debt to Equity Ratio",{"$f":"B111/B112","v":{"$error":"#DIV/0!"}},{"$f":"C111/C112","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Operating Cycle Ratios"]
[]
[null,{"$f":"+B88","v":2016},{"$f":"+C88","v":2017},2018,2019,"Developer's Analysis Comments "]
["Days Receivable:  How long, on average, does the company take to collect ?"]
["Receivables",{"$f":"B37","v":0},{"$f":"C37","v":0},{"$f":"D37","v":0},{"$f":"E37","v":0}]
["/Revenue",{"$f":"B30","v":0},{"$f":"C30","v":0},{"$f":"D30","v":0},{"$f":"E30","v":0}]
["x 360 days in Period",{"$f":"B119/B120","v":{"$error":"#DIV/0!"}},{"$f":"C119/C120","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["= Days Receivable",{"$f":"B121*360","v":{"$error":"#DIV/0!"}},{"$f":"C121*360","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Non Current  related Party  Receivables",{"$f":"B40","v":0},{"$f":"C40","v":0},{"$f":"D40","v":0},{"$f":"E40","v":0}]
[]
["Days Payable:  How long, on average, does the company take to pay its suppliers?"]
["Payables",{"$f":"B41","v":0},{"$f":"C41","v":0},{"$f":"D41","v":0},{"$f":"E41","v":0}]
["/operating expense",{"$f":"B31","v":0},{"$f":"C31","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0}]
["x 360 days in Period",{"$f":"B127/B128","v":{"$error":"#DIV/0!"}},{"$f":"C127/C128","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["= Days Payable",{"$f":"B129*360","v":{"$error":"#DIV/0!"}},{"$f":"C129*360","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Operating Cycle:  How long, on average, does the company have its cash tied up in the operations of the business"]
["+ Days Receivable",{"$f":"B122","v":{"$error":"#DIV/0!"}},{"$f":"C122","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" - Days Payable",{"$f":"B130","v":{"$error":"#DIV/0!"}},{"$f":"C130","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["= Operating Cycle",{"$f":"B133+B134","v":{"$error":"#DIV/0!"}},{"$f":"C133+C134","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Days Cash-liquid assets",{"$f":"(B36/B31)*365","v":{"$error":"#DIV/0!"}},{"$f":"(C36/C31)*365","v":{"$error":"#DIV/0!"}},{"$f":"(D36/D31)*365","v":{"$error":"#DIV/0!"}},{"$f":"(E36/E31)*365","v":{"$error":"#DIV/0!"}}]
["Days Cash - total current assets",{"$f":"B103","v":{"$error":"#DIV/0!"}},{"$f":"C103","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]