{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["HOME","QUICK CHECK","COMPARISON","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"HOME","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"3 MINUTE RENTAL PROPERTY ANALYZER"]
[]
[]
["Property Name"]
[]
["Property Address"]
[]
[]
[]
["Listed Price",null,null,"Annual Mortgage"]
[]
["25% Down",null,null,"Points Charged"]
[]
["Mortgage Amount",null,null,"Points in Dollars"]
[]
["Number of Units",null,null,"Closing Costs"]
[]
["Cost Per Unit",null,null,"Down Payment"]
[]
["Monthly Rental Income",null,null,"Rehab Allowance"]
[]
["Income Per Unit",null,null,"Cash in Deal"]
[]
["Other Income",null,null,"Cash On-Cash"]
[]
["Gross Rent Multiplier",null,null,"Actual CAP Rate"]
[]
["Gross Income",null,null,"Market CAP Rate"]
[]
["Vacancy",null,null,"Annual NOI"]
[]
["EGI",null,null,"Monthly NOI"]
[]
["Net Operating Income",null,null,"Mo. Cash Flow"]
[]
["Yrly Expenses 50% Rule",null,null,"Annual Cash Flow"]
[]
["Mo Expenses 50% Rule",null,null,"Property Value"]
[]
["Monthly Mortgage",null,null,"Sales Price Minus Value"]
[]
["Return on Investment",null,null,"Debt Coverage"]

{"sheet":"QUICK CHECK","index":1,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,16,4,16],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15]]}
["THIS FORM CAN ALSO BE USED INSTEAD OF THE POP-UP.  JUST FILL-IN THE DATA IN THE YELLOW CELLS"]
[]
["3 MINUTE RENTAL PROPERTY ANALYZER"]
[null,"Listed Price","25% Down","Mortgage Amount","Number of Units","Cost Per Unit","Mo Rental Income","Income Per Unit","Other Income","Gross Rent Multiplier","Gross Income","Vacancy","EGI","Net Operating Income","Yrly Expenses 50% Rule","Mo Expenses 50% Rule","Monthly Mortgage","Return on"]
["Property Name and Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investment"]
["SAMPLE PROPERTY",350000,{"$f":"B6*0.25","v":87500},{"$f":"B6-C6","v":262500},20,{"$f":"B6/E6","v":17500},7035,{"$f":"G6/E6","v":351.75},0,{"$f":"B6/K6","v":4.1459369817578775},{"$f":"(G6+I6)*12","v":84420},0.05,{"$f":"K6-(K6*L6)","v":80199},{"$f":"M6-P6","v":76681.5},{"$f":"K6/2","v":42210},{"$f":"O6/12","v":3517.5},1605,{"$f":"SUM(+C6+G10)/P10","v":0.36194687935981468}]
["123 Main St"]
["Anytown, CA 12345","Annual","Points","Points","Closing","Down","Rehab","Cash in","Cash","Actual","Market","Annual","Monthly","Mo. Cash","Annual ","Property","Sales Price","Debt"]
[null,"Mortgage","Charged","in Dollars","Costs","Payment","Allowance","Deal","On-Cash","CAP Rate","CAP Rate","NOI","NOI","Flow","Cash Flow","Value","Minus Value","Coverage"]
[" ",{"$f":"Q6*12","v":19260},1.4999999999999999E-2,{"$f":"D6*C10","v":3937.5},5000,{"$f":"C6","v":87500},50000,{"$f":"D10+F10+G10","v":141437.5},{"$f":"O10/H10","v":0.16226248342907645},{"$f":"N6/B6","v":0.21909000000000001},0.1,{"$f":"+M6-O6","v":37989},{"$f":"L10/12","v":3165.75},{"$f":"(G6*0.5)-Q6","v":1912.5},{"$f":"N10*12","v":22950},{"$f":"L10*10","v":379890},{"$f":"P10-B6","v":29890},{"$f":"L10/B10","v":1.9724299065420561}]
[]
[]
[null,null,null,null,null," "]
[]
["Fill-In cells"]
["*Mortgage Calulator  http://bit.ly/1TYrKOZ"]
[null,null,null,null,null," "," "," "]
["* This is a link to a mortgage calculator you can use to calculate payment amounts."]

{"sheet":"COMPARISON","index":2,"n_rows":107,"n_cols":25,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["QUICK PROPERTY COMPARISONS","Listed",0.25,"# of","Price","Monthly","Income",null,"Annual",0.5,"Net","Mortgage","Mortgage","Down","Cash","Cap","Market","Annual","Monthly","Mo. Cash","Flow","Annual ",null,null,"Debt"]
["Name","Price","Down","Units","Per Door","Income","Per Unit","GRM","Income","Expenses","Op Income","Amount","Payment","Payment","On-Cash","Rate","CAP Rate","NOI","NOI","Flow","Per Unit","Cash Flow","Value","DIFF","Coverage"]
["sample property",141000,{"$f":"IF(SUM(B3*0.25)=0,\"\",SUM(B3*0.25))","v":35250},2,{"$f":"IFERROR(B3/D3,\"\")","v":70500},2200,{"$f":"IFERROR(F3/D3,\"\")","v":1100},{"$f":"IFERROR(B3/I3,\"\")","v":5.3409090909090908},{"$f":"IF(F3*12=0,\"\",F3*12)","v":26400},{"$f":"IFERROR(IF(I3*0.5=0,\"\",I3*0.5),\"\")","v":13200},{"$f":"IFERROR(IF(I3-J3=0,\"\",I3-J3),\"\")","v":13200},{"$f":"IFERROR(IF(B3-C3=0,\"\",B3-C3),\"\")","v":105750},498,{"$f":"C3","v":35250},{"$f":"IFERROR(V3/N3,\"\")","v":0.20493617021276594},{"$f":"IFERROR(K3/B3, \"\")","v":9.3617021276595741E-2},0.1,{"$f":"IFERROR(IF(I3-J3=0,\"\",I3-J3),\"\")","v":13200},{"$f":"IFERROR(R3/12,\"\")","v":1100},{"$f":"IFERROR(IF(S3-M3=0,\"\",S3-M3),\"\")","v":602},{"$f":"IFERROR(T3/D3,\"\")","v":301},{"$f":"IFERROR(IF(T3*12=0,\"\",T3*12),\"\")","v":7224},{"$f":"IFERROR(K3*10,\"\")","v":132000},{"$f":"IFERROR(W3-B3,\"\")","v":-9000},{"$f":"IFERROR(T3/M3,\"\")","v":1.2088353413654618}]
[]
[]
[]
[null,null,{"$f":"IF(SUM(B7*0.25)=0,\"\",SUM(B7*0.25))","v":""},null,"",null,"",{"$f":"IFERROR(B7/I7,\"\")","v":""},{"$f":"IF(F7*12=0,\"\",F7*12)","v":""},{"$f":"IFERROR(IF(I7*0.5=0,\"\",I7*0.5),\"\")","v":""},{"$f":"IFERROR(IF(I7-J7=0,\"\",I7-J7),\"\")","v":""},{"$f":"IFERROR(IF(B7-C7=0,\"\",B7-C7),\"\")","v":""},null,"",{"$f":"IFERROR(V7/N7,\"\")","v":""},{"$f":"IFERROR(K7/B7, \"\")","v":""},null,{"$f":"IFERROR(IF(I7-J7=0,\"\",I7-J7),\"\")","v":""},{"$f":"IFERROR(R7/12,\"\")","v":""},{"$f":"IFERROR(IF(S7-M7=0,\"\",S7-M7),\"\")","v":""},{"$f":"IFERROR(T7/D7,\"\")","v":""},{"$f":"IFERROR(IF(T7*12=0,\"\",T7*12),\"\")","v":""},{"$f":"IFERROR(K7*10,\"\")","v":""},{"$f":"IFERROR(W7-B7,\"\")","v":""},{"$f":"IFERROR(T7/M7,\"\")","v":""}]
[null,null,"",null,"",null,"",{"$f":"IFERROR(B8/I8,\"\")","v":""},"","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,{"$f":"IFERROR(B9/D9,\"\")","v":""},null,{"$f":"IFERROR(F9/D9,\"\")","v":""},"","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,{"$f":"IFERROR(F16/D16,\"\")","v":""},{"$f":"IFERROR(B16/I16,\"\")","v":""},{"$f":"IF(F16*12=0,\"\",F16*12)","v":""},"",{"$f":"IFERROR(IF(I16-J16=0,\"\",I16-J16),\"\")","v":""},{"$f":"IFERROR(IF(B16-C16=0,\"\",B16-C16),\"\")","v":""},null,{"$f":"C16","v":""},{"$f":"IFERROR(V16/N16,\"\")","v":""},{"$f":"IFERROR(K16/B16, \"\")","v":""},null,{"$f":"IFERROR(IF(I16-J16=0,\"\",I16-J16),\"\")","v":""},"",{"$f":"IFERROR(IF(S16-M16=0,\"\",S16-M16),\"\")","v":""},{"$f":"IFERROR(T16/D16,\"\")","v":""},{"$f":"IFERROR(IF(T16*12=0,\"\",T16*12),\"\")","v":""},{"$f":"IFERROR(K16*10,\"\")","v":""},{"$f":"IFERROR(W16-B16,\"\")","v":""},{"$f":"IFERROR(T16/M16,\"\")","v":""}]
[null,null,"",null,{"$f":"IFERROR(B17/D17,\"\")","v":""},null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,null,null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,{"$f":"IFERROR(B80/D80,\"\")","v":""},null,{"$f":"IFERROR(F80/D80,\"\")","v":""},{"$f":"IFERROR(B80/I80,\"\")","v":""},{"$f":"IF(F80*12=0,\"\",F80*12)","v":""},"",{"$f":"IFERROR(IF(I80-J80=0,\"\",I80-J80),\"\")","v":""},{"$f":"IFERROR(IF(B80-C80=0,\"\",B80-C80),\"\")","v":""},null,{"$f":"C80","v":""},{"$f":"IFERROR(V80/N80,\"\")","v":""},{"$f":"IFERROR(K80/B80, \"\")","v":""},null,{"$f":"IFERROR(IF(I80-J80=0,\"\",I80-J80),\"\")","v":""},"",{"$f":"IFERROR(IF(S80-M80=0,\"\",S80-M80),\"\")","v":""},{"$f":"IFERROR(T80/D80,\"\")","v":""},{"$f":"IFERROR(IF(T80*12=0,\"\",T80*12),\"\")","v":""},{"$f":"IFERROR(K80*10,\"\")","v":""},{"$f":"IFERROR(W80-B80,\"\")","v":""},{"$f":"IFERROR(T80/M80,\"\")","v":""}]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]
[null,null,"",null,"",null,"","","","","","",null,"","","",null,"","","","","","","",""]

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