{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Proforma","1","Sheet3"],"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":"Proforma","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Proforma for 26 units at the Flats at 120 2nd Street, Winder, GA"]
[]
["Estimated Value",3000000]
["Down Payment Percent",0.3]
["Down Payment amount",{"$f":"B3*B4","v":900000}]
["New First Mortgage",{"$f":"B3-B5","v":2100000}]
["New first mortgage rate",5.5E-2]
["Mortgage Rate (Monthly- Calcuated)",{"$f":"B7/12","v":4.5833333333333334E-3}]
["Mortgage Term (Months)",300]
["Management Fee",0.06]
["Vacancy/Collection Loss",0.05]
[]
[null,"Proforma Rent","Annual Proforma"]
["Market Rent ($1100 for 1/1 and $1300 for 2/1)",29000,{"$f":"B14*12","v":348000}]
["Utility Income (Water)",835,10020]
["Late Fees, Convienece Fees, Other",600,7200]
["Pet Fees",280,3360]
["Less Vacancy",{"$f":"B14*0.05*-1","v":-1450},-17400]
["Net Income",{"$f":"B14-B16+B18+B17","v":27230},{"$f":"B19*12","v":326760}]
[]
["Expenses"]
["Management Fee ",{"$f":"B19*B10","v":1633.8},{"$f":"B22*12","v":19605.599999999999}]
["Utilities, Water, Garbage and vacant units",1200,14400]
["Pest Control",390,4680]
["Maintenance and Supplies",2000,24000]
["Lawn",150,1800]
["Property Taxes",1000,12000]
["Insurance",1280,15360]
[]
["Total Expenses",{"$f":"SUM(B22:B29)","v":7653.8},91845.6]
[]
["Net Operating Income",{"$f":"B19-B30","v":19576.2},234914.4]
[]
["1st Mortgage Debt Service",{"$f":"PMT(B8,B9,B6)*-1","v":12895.837337910874},{"$f":"B34*12","v":154750.04805493049}]
["Net Income After Debt Service",{"$f":"B32-B34","v":6680.3626620891264},80164.351945069517]
["GRM",null,{"$f":"B3/C19","v":9.1810503121557101}]
["CAP Rate ",null,{"$f":"C32/B3*100","v":7.8304799999999997}]
["Cash on Cash ROI year one",null,{"$f":"C35/B5","v":8.9071502161188351E-2}]
["DCR",null,{"$f":"B32/B34","v":1.51802473054234}]

{"sheet":"1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}