{"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":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,"1 Tucks Rd, Brookfield"]
[]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",11,12]
[null,"Average Monthly Rent per Unit",880,925]
[null,"Total Rental Income",{"$f":"SUM(C5*C6)","v":9680},11100]
[null,"% Vacancy and Credit Losses"]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":0},0]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":9680},11100]
[]
[null,"Monthly Operating Expenses"]
[null,"Real Estate Taxes",816,816]
[null,"Rental Property Insurance",1000,1000]
[null,"Landscaping "]
[null,"Cleaning "]
[null,"Common Utilities"]
[null,"- Oil",352.49,352.49]
[null,"- Trash",167.06,167.06]
[null,"- Electric",755,755]
[null,"- Heat  ",null,0]
[null,"Septic",25,25]
[null,"Accounting and Legal"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C25)","v":3115.5499999999997},3115.5499999999997]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":116160},133200]
[null,"Total Annual Operating Expense",{"$f":"C26*12","v":37386.6},37386.6]
[null,"Annual Net Operating Income",{"$f":"C29-C30","v":78773.399999999994},95813.4]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",6.5000000000000002E-2,7.2499999999999995E-2]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C34=0,\" - \",C31/C34)","v":1211898.4615384615},1321564.1379310344]
[null,"Actual Purchase Price",1150000,1150000]
[null,"Actual Capitalization Rate",{"$f":"IF(C36=0,\" - \",C31/C36)","v":6.8498608695652163E-2},8.3316000000000001E-2]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C36*0.25","v":287500},287500,"25% Down"]
[null,"Loan Amount",{"$f":"C36-C40","v":862500},862500,"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C36*0.0075","v":8625},8625,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30,30]
[null,"Annual Interest Rate",0.06,0.06]
[null,"Initial Investment",{"$f":"C40+C42","v":296125},296125]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C41=0,0,-PMT(C44/12,C43*12,C41))","v":5171.1232794424886},5171.1232794424886]
[null,"Annual Interest",{"$f":"IF(C41=0,0,-CUMIPMT(C44/12,C43*12,C41,1,12,0))","v":51461.878334923167},51461.878334923167]
[null,"Annual Principal",{"$f":"IF(C41=0,0,-CUMPRINC(C44/12,C43*12,C41,1,12,0))","v":10591.601018386697},10591.601018386697]
[null,"Total Annual Debt Service",{"$f":"C46*12","v":62053.479353309864},62053.479353309864]
[null,"DEBT SERVICE RATIO",{"$f":"C31/C49","v":1.2694437253307427},1.5440455716346453]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C26-C46","v":1393.3267205575121},2813.3267205575121]
[null,"Total Annual Cash Flow",{"$f":"C31-C49","v":16719.920646690131},33759.920646690131]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C45=0,\" \",C54/C45)","v":5.6462374492832861E-2},0.11400564169418365]
[]
[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":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Current Rent","Tenancy","Phone","Utilities Included"]
["Store","$1,300 / month","5 years","914-774-9486","No"]
["1","$210 / week",null,"413-799-0142","Yes"]
["2","$220 / biweekly","8 years","203-600-0398","Yes"]
["3","$190 / week",null,"203-512-6527","Yes"]
["4","$240 / biweekly","18 years"," ","Yes"]
["5","$170 / week","5+ years","860-759-5914","Yes"]
["6","$190 / biweekly","6 years","203-739-9446","Yes"]
[7,"$190 / week","1 year","959-901-1797","Yes"]
["8","$190 / week","1 month","203-512-2052","Yes"]
["9","$190 / week","1 year","203-241-0970","Yes"]
["10","$210 / week","3 years","203-948-6316","Yes"]