{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CashFlow","Rent Roll"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":"CashFlow","index":0,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,"456 Lombard St, New Haven, Ct"]
[null,"1(Studio), 5(1 beds), 4 (2 beds), 4 (3 beds), 2 (4 beds)- From Co Star "]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",16,16]
[null,"Average Monthly Rent per Unit",2000,2200]
[null,"Total Rental Income",{"$f":"'Rent Roll'!C18","v":31833},{"$f":"'Rent Roll'!D18","v":35033}]
[null,"% Vacancy and Credit Losses",0.05,0.05]
[null,"Total Vacancy Loss",{"$f":"C7*C8","v":1591.65},1751.65]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":30241.35},33281.35]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",{"$f":"C$7*0.04","v":1273.32},1401.32,"4% Management From Seller"]
[null,"Repairs and Maintenance",{"$f":"6000/12","v":500},500,"Direct From Seller"]
[null,"Real Estate Taxes",3697.25,3697]
[null,"Rental Property Insurance",1250,1250]
[null,"Landscaping ",41.67,41.67]
[null,"Cleaning "]
[null,"Common Utilities",null,null,"Common Utiltiies "]
[null,"- Water ",416.67,416.67]
[null,"- Sewer",416.67,416.67]
[null,"- Electric",350,350]
[null,"-Trash",480,480]
[null,"- Heat  ",0,0]
[null,"Pest Control",0,0]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C27)","v":8425.58},8553.33]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":362896.19999999995},399376.19999999995]
[null,"Total Annual Operating Expense",{"$f":"C28*12","v":101106.95999999999},102639.95999999999]
[null,"Annual Net Operating Income",{"$f":"C31-C32","v":261789.23999999996},296736.24]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C36=0,\" - \",C33/C36)","v":4027526.7692307686},4239089.1428571427]
[null,"Actual Purchase Price",3852000,3852000]
[null,"Actual Capitalization Rate",{"$f":"IF(C38=0,\" - \",C33/C38)","v":6.7961900311526463E-2},7.7034330218068534E-2]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C38*0.3","v":1155600},1155600,"30% Down"]
[null,"Loan Amount",{"$f":"C38-C42","v":2696400},2696400,"70% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C38*0.0075","v":28890},28890,".75% of Ask Price"]
[null,"Length of Mortgage (years)",25,25]
[null,"Annual Interest Rate",0.06,0.06]
[null,"Initial Investment",{"$f":"C42+C44","v":1184490},1184490]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C43=0,0,-PMT(C46/12,C45*12,C43))","v":17372.942989655254},17372.942989655254]
[null,"Annual Interest",{"$f":"IF(C43=0,0,-CUMIPMT(C46/12,C45*12,C43,1,12,0))","v":160478.345937573},160478.345937573]
[null,"Annual Principal",{"$f":"IF(C43=0,0,-CUMPRINC(C46/12,C45*12,C43,1,12,0))","v":47996.969938290029},47996.969938290029]
[null,"Total Annual Debt Service",{"$f":"C48*12","v":208475.31587586305},208475.31587586305]
[null,"DEBT SERVICE RATIO",{"$f":"C33/C51","v":1.2557325499191605},1.4233639064333738]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C28-C48","v":4442.827010344743},7355.077010344743]
[null,"Total Annual Cash Flow",{"$f":"C33-C51","v":53313.924124136916},88260.924124136945]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C47=0,\" \",C56/C47)","v":4.501002467233739E-2},7.4513861766783124E-2]
[]
[null,"Note: This spreadsheet should only be used for informational and educational purposes. Please verify"]
[null,"calculations and seek professional assistance before making financial decisions."]

{"sheet":"Rent Roll","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes"]
[101,null,1950,2150,null,"Leased"]
[102,null,1750,1950,null,"Leased"]
[103,null,1800,2000,null,"Leased"]
[104,null,1500,1700,null,"Leased"]
[105,null,2000,2200,null,"Leased"]
[106,null,2000,2200,null,"Leased"]
[201,null,2100,2300,null,"Leased"]
[202,null,1958,2158,null,"MTM"]
[203,null,2100,2300,null,"MTM"]
[204,null,2100,2300,null,"Leased"]
[206,null,2100,2300,null,"MTM"]
[207,null,1625,1825,null,"MTM"]
[208,null,2500,2700,null,"Leased"]
["BT1",null,2400,2600,null,"Leased"]
["BT2",null,2400,2600,null,"Leased"]
["Just finished renovetion ",null,1550,1750,"VACANT"]
["Total",null,{"$f":"SUM(C2:C17)","v":31833},35033]