{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Overview","Sources & Uses","Cash Flow"],"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":17,"n_cols":14,"rows_kept":17,"merged":[[2,10,12,14],[3,1,3,2],[6,1,6,2],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,1,9,2],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,4,16,5],[14,7,14,8],[15,7,15,8],[16,7,16,8]]}
[]
[null,"PROJECT DETAILS:",null,null,"DEVELOPMENT PROGRAM:",{"$nulls":5},"PROPOSED PUBLIC ASSISTANCE STRUCTURE:"]
[null,"Project name:",null,null,"Residential units:",null,null,"Parking (number of spaces):"]
[{"$nulls":4},"Studio:",null,null,"Structured or surface?"]
[{"$nulls":4},"1-bed:"]
[null,"Location:",null,null,"2-bed:",null,null,"Project amenities:"]
[{"$nulls":4},"3-bed:"]
[{"$nulls":4},"Other:"]
[null,"Developer:",null,null,"Hotel keys:"]
[{"$nulls":4},"Retail rentable SF:"]
[{"$nulls":4},"Office rentable SF:"]
[null,"SF of land:"]
[null,"Building gross SF:",null,null,"Other rentable SF:"]
[null,"Building rentable SF:",null,null,"Description of other rentable SF:"]
[{"$nulls":10},"DEVELOPER TARGET RATE OF RETURN:"]
[null,"Construction start (year):",{"$nulls":8},"Stabilized Yield on Cost:",null,null,"Unleveraged IRR:"]
[null,"Completion year:",{"$nulls":8},"Stabilized Cash-on-Cash Return:",null,null,"Leveraged IRR:"]

{"sheet":"Sources & Uses","index":1,"n_rows":41,"n_cols":9,"rows_kept":41}
[]
[null,"DEVELOPMENT SOURCES",null,null,"DEVELOPMENT BUDGET"]
[null,"Source","Amount",null,"Uses/Development Costs","Amount",null,"Uses/Development Costs","Amount"]
[{"$nulls":4},"Acquisition Costs",null,null,"Soft Costs"]
[]
[]
[null,null,{"v":500,"d":"$500"}]
[{"$nulls":4},"Total Acquisition Costs",{"$f":"SUM(F5:F7)","v":{"v":0,"d":"$0"}}]
[]
[]
[{"$nulls":4},"Site Preparation Costs"]
[]
[null,"TOTAL SOURCES",{"$f":"SUM(C4:C12)","v":{"v":500,"d":"$500"}}]
[]
[null,"Construction Debt",null,null,"Total Site Preparation Costs",{"$f":"SUM(F12:F14)","v":{"v":0,"d":"$0"}}]
[null,"Loan amount"]
[null,"Interest rate",null,null,"Hard Construction Costs"]
[null,"Term",{"$nulls":5},"Total Soft Costs",{"$f":"SUM(I5:I17)","v":{"v":0,"d":"$0"}}]
[null,"Construction period (years)"]
[{"$nulls":7},"Tenant Improvements"]
[null,"Permanent Debt"]
[null,"Loan amount"]
[null,"Interest rate",{"$nulls":5},"Total Tenant Improvements Costs",{"$f":"SUM(I21:I22)","v":{"v":0,"d":"$0"}}]
[null,"Amortization period",500]
[null,"Going-In cap rate assumption",{"$nulls":5},"Financing Costs"]
[]
[]
[{"$nulls":7},"Total Financing Costs",{"$f":"SUM(I26:I27)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":7},"Developer Fees"]
[]
[]
[{"$nulls":7},"Total Developer Fees",{"$f":"SUM(I31:I32)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":7},"Reserves and Other Costs"]
[{"$nulls":4},"Total Hard Construction Costs",{"$f":"SUM(F18:F35)","v":{"v":0,"d":"$0"}}]
[]
[]
[{"$nulls":7},"Total Reserves and Other Costs",{"$f":"SUM(I36:I38)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":7},"TOTAL DEVELOPMENT COSTS",{"$f":"SUM(F8,F15,F36,I18,I23,I28,I33,I39)","v":{"v":0,"d":"$0"}}]

{"sheet":"Cash Flow","index":2,"n_rows":37,"n_cols":12,"rows_kept":37}
[]
[null,"10-YEAR CASH FLOW"]
[null,"Stabilization year: ",{"$nulls":4},"Year 10 terminal cap rate assumption: "]
[]
[null,"Calendar year:"]
[null,"Revenues","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
{"$rows_empty":9}
[null,"Add more rows above, if needed"]
[null,"Total Revenues",{"$f":"SUM(C7:C16)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"SUM(E7:E16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F7:F16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G7:G16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H7:H16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I7:I16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(J7:J16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(K7:K16)","v":{"v":0,"d":"$0"}},{"$f":"SUM(L7:L16)","v":{"v":0,"d":"$0"}}]
[]
[null,"Expenses","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
{"$rows_empty":10}
[null,"Add more rows above, if needed"]
[null,"Total Expenses",{"$f":"SUM(C20:C30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D20:D30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E20:E30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F20:F30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G20:G30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H20:H30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I20:I30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(J20:J30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(K20:K30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(L20:L30)","v":{"v":0,"d":"$0"}}]
[]
[null,"Net Operating Income",{"$f":"C17-C31","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Debt Service"]
[]
[null,"Cash Flow After Debt Service",{"$f":"C33-C35","v":{"v":0,"d":"$0"}},{"$f":"D33-D35","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]