{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["CashFlow"],"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":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"100 S Cherry St Wallingford CT"]
[null,"$2,850,000 Acquisition Cost"]
[null,"$10,933,849 Budget Cost"]
[null,"Monthly Operating Income","As Is ",null,"Rent Breakdown","Price","Units"]
[null,"Number of Units",66.0,null,"1 Bedroom",2000.0,23.0]
[null,"Average Monthly Rent per Unit",{"$f":"C7/C5","v":2172.2},null,"1 Bedroom (Affordable)",1629.0,10.0]
[null,"Total Rental Income",143365.2,null,"2 Bedroom",2675.0,23.0]
[null,"% Vacancy and Credit Losses",0.05,null,"2 Bedroom (Affordable)",1955.0,10.0]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":7168.26},null,"TOTAL",{"$f":"(F5*G5)+(F6*G6)+(F7*G7)+(F8*G8)","v":143365},{"$f":"SUM(G5:G8)","v":66}]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":136196.94}]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",{"$f":"C11*0.05","v":6809.847},"5% Rule of Thumb"]
[null,"Repairs and Maintenance",{"$f":"C11*0.03","v":4085.9082},"3% Rule of Thumb"]
[null,"Real Estate Taxes",16666.66]
[null,"Rental Property Insurance",5500.0]
[null,"Landscaping ",416.67]
[null,"Common Utilities",null,"Common Utiltiies "]
[null,"- Water and Sewer",1791.67]
[null,"- Garbage",750.0]
[null,"- Electric",250.0]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C23)","v":36270.7552}]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":1634363.28}]
[null,"Total Annual Operating Expense",{"$f":"C24*12","v":435249.0624}]
[null,"Annual Net Operating Income",{"$f":"C27-C28","v":1199114.218}]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.0625]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C32=0,\" - \",C29/C32)","v":19185827.48}]
[null,"Actual Purchase Price",{"$f":"2850000+10933849","v":13783849},"Acquisition + Construction Cost"]
[null,"Actual Capitalization Rate",{"$f":"IF(C34=0,\" - \",C29/C34)","v":0.08699414928}]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C34*0.25","v":3445962.25},"25% Down"]
[null,"Loan Amount",{"$f":"C34-C38","v":10337886.75},"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C34*0.0075","v":103378.8675},".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0]
[null,"Annual Interest Rate",0.0575]
[null,"Initial Investment",{"$f":"C38+C40","v":3549341.118}]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C39=0,0,-PMT(C42/12,C41*12,C39))","v":60329.101}]
[null,"Annual Interest",{"$f":"IF(C39=0,0,-CUMIPMT(C42/12,C41*12,C39,1,12,0))","v":590959.9653}]
[null,"Annual Principal",{"$f":"IF(C39=0,0,-CUMPRINC(C42/12,C41*12,C39,1,12,0))","v":132989.2467}]
[null,"Total Annual Debt Service",{"$f":"C44*12","v":723949.212}]
[null,"DEBT SERVICE RATIO",{"$f":"C29/C47","v":1.656351299}]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C24-C44","v":39597.0838}]
[null,"Total Annual Cash Flow",{"$f":"C29-C47","v":475165.0056}]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C43=0,\" \",C52/C43)","v":0.1338741445}]
[]
[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."]