{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["P&L Top Dog"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":6,"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":"P&L Top Dog","index":0,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,2,3,8],[31,6,31,7]]}
[null,"                                                                                                                                99-101 E Main St Milton, MA 01757"]
{"$rows_empty":9}
[null,"INSTRUCTIONS - INPUT DATA IN GREEN FIELDS ONLY.  DO NOT ENTER ANYWHERE ELSE OR FORMULAS WILL BE CORRUPTED."]
[]
[null,"Price",975000]
[null,"Equity",{"$f":"C13*D14","v":243750},{"$f":"+D16-D15","v":0.25}]
[null,"Mortgage",{"$f":"C13*D15","v":731250},0.75]
[null,null,null,1]
[]
[null,"Mortgage Interest Rate",7.0000000000000007E-2]
[null,"Mortgage Term - years",25]
[]
[null,"Number of units",6]
[null,"Price per unit",{"$f":"+C13/C21","v":162500}]
[{"$nulls":4},2025,null,"2026 Projections"]
[null,"NOI cap rate",null,null,{"$f":"E67/C13","v":6.5890461538461537E-2},null,{"$f":"G67/C13","v":8.7123282051282044E-2}]
[null,"Return on Investment (Net Cashflow before Mortgage Amortization / Equity)",null,null,{"$f":"+(E75/C14)","v":3.3773002640471755E-2},null,{"$f":"+G75/(C14)","v":0.11392890007636922}]
[null,"Return on Investment (Net Cashflow after Mortgage Amortization / Equity)",null,null,{"$f":"+(E75-E77)/C14","v":-1.0457741788263785E-2},null,{"$f":"+(G75-G77)/C14","v":6.9698155647633681E-2}]
[null,"DSCR (Cashflow after Cap Reserve / Total Debt Repayment)",null,null,{"$f":"+E71/E79","v":0.95889906938804448},null,{"$f":"+G71/G79","v":1.2739271170636033}]
[null,"DSCR (Cashflow after Cap Reserve / Mortgage Interest)",null,null,{"$f":"+E71/E73","v":1.1606633373333977},null,{"$f":"+G71/G73","v":1.5419771969892277}]
[null,"Breakeven occupancy (excluding capital reserves)",null,null,{"$f":"(E65+E73)/E51","v":0.8637523112729969},null,{"$f":"(G65+G73)/G51","v":0.7161026093792956}]
[null,"Income Multiplier",null,null,{"$f":"+C13/E51","v":10.214986170480261},null,{"$f":"+C13/G51","v":8.2120477056802095}]
[]
[{"$nulls":4},"Rent",null,"Potential Rent"]
[null,null,"SF","Baths","Current",null,"Month","Year"]
[null,"101 A&B (Barber Shop)",1800,0.5,1600,null,2500,{"$f":"+G34*12","v":30000}]
[null,"99 (NE Liquidators)",700,0.5,1500,null,1500,18000]
[null,"3 Middleton (Unit A)",800,1,1200,null,1500,18000]
[null,"3 Middleton (Unit B)",800,1,1200,null,1500,18000]
[null,"99 ½ E Main st (Unit C)",800,1,1200,null,1500,18000]
[null,"Warehouse",1500,0.5,1500,null,1700,20400]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[null,null,{"$f":"SUM(C34:C44)","v":6400},{"$f":"SUM(D34:D44)","v":4.5},{"$f":"SUM(E34:E44)","v":8200},null,{"$f":"SUM(G34:G44)","v":10200},{"$f":"SUM(H34:H44)","v":122400}]
[]
[{"$nulls":4},"2025 Rent & Expenses",null,"Potential Rent & Projected Expenses"]
[null,"INCOME"]
[null,"  Gross Rents",null,null,{"$f":"E45*12","v":98400},null,{"$f":"+H45","v":122400}]
[null,"   Vacancy rate",0.03,null,{"$f":"+E49*C50","v":2952},null,{"$f":"+G49*C50","v":3672}]
[null,"  Net Rents",null,null,{"$f":"E49-E50","v":95448},null,{"$f":"+G49-G50","v":118728}]
[null,"  Laundry"]
[null,"OPERATING EXPENSES"]
[null,"  Insurance",null,null,8500,null,8500]
[null,"  Real Estate Taxes",null,null,10000,null,10000]
[null,"  Repairs & Maintenance",0.05,null,{"$f":"+E51*C56","v":4772.4000000000005},null,{"$f":"+G51*C56","v":5936.4000000000005}]
[null,"  Management Fee",0.05,null,{"$f":"+E51*C57","v":4772.4000000000005},null,{"$f":"+G51*C57","v":5936.4000000000005}]
[null,"  Dumpster Fee"]
[null,"  Land scape/Snow removal",null,null,1000,null,1000]
[null,"  Utilities Electric",null,null,300,null,350]
[null,"  Fire Alarm Quarterly",null,null,360,null,360]
[null,"  Water",null,null,1000,null,1100]
[null,"  Sewer ",null,null,500,1,600]
[null,"Parking Expense",null,null,0,null,0]
[null,"  Total Operating Expenses",null,null,{"$f":"SUM(E54:E64)","v":31204.800000000003},null,{"$f":"SUM(G54:G64)","v":33782.800000000003}]
[]
[null,"Net Operating Income (NOI)",null,null,{"$f":"E51+E52-E65","v":64243.199999999997},null,{"$f":"G51+G52-G65","v":84945.2}]
[]
[null,"Capital Reserves",0.05,null,{"$f":"+E51*C69","v":4772.4000000000005},null,{"$f":"+G51*C69","v":5936.4000000000005}]
[]
[null,"Cash flow after cap reserve and before mortgage int.",null,null,{"$f":"E67-E69","v":59470.799999999996},null,{"$f":"G67-G69","v":79008.800000000003}]
[]
[null,"Mortgage Interest",null,null,{"$f":"PMT(C18/12,99*12,-C15)*12","v":51238.630606385006},null,{"$f":"PMT(C18/12,99*12,-C15)*12","v":51238.630606385006}]
[]
[null,"Net Cashflow",null,null,{"$f":"E71-E73","v":8232.1693936149895},null,{"$f":"G71-G73","v":27770.169393614997}]
[]
[null,"Mortgage Amortization",null,null,{"$f":"PMT(C18/12,C19*12,-C15)*12-PMT(C18/12,99*12,-C15)*12","v":10781.243954504287},null,{"$f":"PMT(C18/12,C19*12,-C15)*12-PMT(C18/12,99*12,-C15)*12","v":10781.243954504287}]
[]
[null,"Total Annual Mortgage Payment",null,null,{"$f":"+E77+E73","v":62019.874560889293},null,{"$f":"+G77+G73","v":62019.874560889293}]