{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Sheet1","index":0,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["MULTIFAMILY"]
["Broker"]
["Google Doc",null,"Sales Price",725000.0]
["Property","22 2nd Ave, Troy, NY 12180","Loan Amount",{"$f":"D7*D3","v":543750}]
[null,"Troy","Down Payment",{"$f":"D3-D4","v":181250}]
["Link",null,"Interest Rate",0.07]
["# units","8 units","Loan to Value",0.75]
[null,null,"Term Mo.",360.0]
[{"$nulls":4},"RENT ROLL"]
[null,"Use  Annual Figures"]
[null,"Gross Income",null,null,null,"Pro forma ","Exiting "]
[null,"Apartment Units",{"$f":"SUM(F23)","v":113172},null,"Unit 1",1131.0,1131.0,1.0,"bd"]
[null,"Retail/Commercial Units",null,null,"Unit 2",1150.0,775.0,1.0,"bd"]
[null,"Laundry",null,null,"Unit 3",1150.0,1200.0,2.0,"bd"]
[null,"Gross Income",{"$f":"SUM(C12:C14)","v":113172},null,"Unit 4",1275.0,1250.0,2.0,"bd"]
[{"$nulls":4},"Unit 5",1150.0,1050.0,1.0,"bd"]
[{"$nulls":4},"Unit 6",1150.0,1100.0,1.0,"bd"]
[{"$nulls":4},"Unit 7",1275.0,1100.0,2.0,"bd"]
[{"$nulls":4},"Unit 8",1150.0,1125.0,1.0,"bd"]
[]
[null,"Vacancy Factor"]
[null,"Residential 5%",{"$f":"SUM(C15*0.05)","v":5658.6},null,"Monthly",{"$f":"SUM(F12:F21)","v":9431}]
[null,"Commercial 10%",null,null,"Yearly",{"$f":"SUM(F22*12)","v":113172}]
[]
[null,"Total",{"$f":"SUM(C22:C23)","v":5658.6}]
[null,"Effective gross Income",{"$f":"SUM(C15-C25)","v":107513.4}]
[]
[" ","Expenses Annual Figures"]
[null,"R/E Taxes",17374.0]
[null,"Insurance Premium",5679.04,null," "]
[null,"Water/Sewer",0.0]
[null,"Heat/Hot Water",0.0]
[null,"Common Electric",500.0]
[null,"Trash",null,"city pick up"]
[null,"Maintenance",{"$f":"SUM(C26*0.05)","v":5375.67},"(5% EGI)"]
[null,"Management",{"$f":"SUM(C26*0.06)","v":6450.804},"(6% EGI)"]
[null,"Total Expenses",{"$f":"SUM(C29:C36)","v":35379.514}]
[]
[null,"Net Operating Income (NOI)",{"$f":"SUM(C26-C37)","v":72133.886}]
[null,"Principle and Interest Pmt",{"$f":"-PMT(D6/12,D8,D4)*12","v":43410.98781}]
[null,"2nd Mtg Pmt (if applicable)",0.0]
[null,"NOI/PI",{"$f":"SUM(C40:C41)","v":43410.98781}]
[]
[null,"Debt Service Coverage Ratio",{"$f":"SUM(C39/C42)","v":1.661650417}]
[]
[null,"Monthly mortgage payment",{"$f":"-PMT((D6/12),(D8),D4)","v":3617.582318}]
[null,"Net income after mortgage",{"$f":"C39-C46*12","v":28722.89819}]
[null,"Return on investment (ROI)",{"$f":"C47/(D3-D4)","v":0.1584711624}]
[]
[null,"Cap rate",{"$f":"C39/D3","v":0.09949501517}]
[]
[null,"Information contained on and in  this document regarding this listing has been compiled from various sources"]
[null,"all of which may not be completely accurate. "]
[null," All information that influences a decision to purchase a listed property should be independently verified by the purchaser."]