{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Totals"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":"Totals","index":0,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[80,0,83,3],[41,4,43,5],[72,0,72,3],[73,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[77,0,77,3],[27,3,28,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3]]}
[2020,null,null,"Your Name Here"]
["Simple Business Plan","Fill in Yellow Boxes. OVER WRITE Samples!",null,"Blue Boxes autofill. "]
[null,null,null,"Corner red arrows are notes… Hover over upper right corner for info"]
["Section 1 - 2019 Review","Questions? Email Info@YourCoachingMatters.com"]
["List your primary 3 Life Intentions",1,2,3]
["Progress Toward Each Scale 1-5","1 - 2 - 3 - 4 - 5","1 - 2 - 3 - 4 - 5","1 - 2 - 3 - 4 - 5"]
["List your Standards of Integrity",1,2,3]
["Up to 9 of them ",4,5,6]
["Need to do the Exercise again? Ask",7,8,9]
["Total income paid or to be paid 2019 = ",375000,"OK to estimate"]
["Total business expenses paid or to be paid= ",158000,"OK to estimate"]
["Profit from real estate = ",{"$f":"B10-B11","v":217000}]
["Listing appointments =",42,{"$f":"B27/B13","v":80.952380952380949},"# contacts/listing appt"]
["Listings taken = ",36,{"$f":"B14/B13","v":0.8571428571428571},"% taken"]
["Listings sold =",31,{"$f":"B15/B14","v":0.86111111111111116},"% sold"]
["Buyer appointments =",99,"OK to estimate"]
["Buyers closed =",22,{"$f":"B15/B19","v":0.58490566037735847},"percent from listings sold"]
["Ratio of Buyer Appts to Closed =",{"$f":"B17/B16","v":0.22222222222222221},{"$f":"B17/B19","v":0.41509433962264153},"percent from buyer sales"]
["Total closed deals = ",{"$f":"B15+B17","v":53}]
["Average sales price = ",295000,{"$f":"B20*B19","v":15635000},"Total $ volume"]
[" Average commission check =  ",{"$f":"B10/B19","v":7075.4716981132078},{"$f":"B21/B20","v":2.398464982411257E-2},"Ave commission % you kept"]
[" Average hours worked per week = ",40,{"$f":"B10/(B22*B25)","v":46.875},"$$/hr INCOME over year"]
[" Present pendings= ",10,{"$f":"B12/(B22*B25)","v":27.125},"$$/hr PROFIT over year"]
[" Present inventory = ",5]
[" Total days worked (estimate)= ",200,{"$f":"B10/B27","v":110.29411764705883},"Income per contact"]
[" Total contacts per work day (estimate) =",17]
[" Total Estimated contacts =  ",{"$f":"B26*B25","v":3400},{"$f":"B27/B19","v":64.15094339622641},"Number of contacts/closing"]
[null,null,null,"Listings + Closings + Pendings ="]
["Look at your Listings, Pendings & Closings in 2019 for this Section!"]
["Section 2 … Sourcing Your Business",null,"Total =",{"$f":"B24+B19+B23","v":68}]
["Client Source","Number","%"]
["FSBO",10,{"$f":"B32/D30","v":0.14705882352941177}]
["Expired",4,{"$f":"B33/D30","v":5.8823529411764705E-2}]
["Zillow",2,{"$f":"B34/D30","v":2.9411764705882353E-2}]
["Past Client ",10,{"$f":"B35/D30","v":0.14705882352941177}]
["COI",11,{"$f":"B36/D30","v":0.16176470588235295}]
["Referral from PC/COI",12,{"$f":"B37/D30","v":0.17647058823529413}]
["Sign call",5,{"$f":"B38/D30","v":7.3529411764705885E-2}]
["Mailer",5,{"$f":"B39/D30","v":7.3529411764705885E-2}]
["FB",3,{"$f":"B40/D30","v":4.4117647058823532E-2}]
["Website",1,{"$f":"B41/D30","v":1.4705882352941176E-2}]
["Landing Pages",1,{"$f":"B42/D30","v":1.4705882352941176E-2}]
["Referral with a Fee",4,{"$f":"B43/D30","v":5.8823529411764705E-2}]
[{"$f":"IFERROR(B44=D30,OK)","v":true},{"$f":"SUM(B32:B43)","v":68},{"$f":"SUM(C32:C43)","v":0.99999999999999978},"If false, this isn't"]
[null,null,null,"matching Section 1, so"]
[null,null,null,"Check B19, B23 & B24"]
["Section 3 THE FUN PART! 2020 GOALS! ","Make it your BEST YEAR SO FAR!"]
["(General Rule: If your goal is over 25 deals you should have an assistant hired &"]
["in place by January 1.  If over 75, you should have 2 MINIMUM & Team started)"]
["Closed deals goal = ",75]
["Average Sales Price=",310000,{"$f":"B51*B50","v":23250000},"Volume Goal"]
["Average Commission =",2.3E-2,{"$f":"B52*B51","v":7130},"Average commission"]
["Income goal = ",{"$f":"C52*B50","v":534750},"Exciting??"]
["Business Expenses",220000,"Estimate"]
["Profit from Real Estate",{"$f":"B53-B54","v":314750},"Profit is the name of the game!"]
["% of 2020 Closings from Listings",0.6,"Use last year's or put in a reasonable improvement"]
["% of 2020 Closings from Buyers",{"$f":"1-B56","v":0.4},"Use last year's or put in a reasonable improvement"]
["Listings Sold Goal = ",{"$f":"B50*B56","v":45},"Auto calculates"]
["% of Listings taken that close",0.85,"Estimate from C15 above"]
["Listings taken goal =",{"$f":"B58/B59","v":52.941176470588239},"Auto calculates",null," "]
["% of Listing appointments taken",0.75,"Estimate from C14 above"]
["Listing Appointment goal =",{"$f":"B60/B61","v":70.588235294117652},"Auto calculates",null," "]
["Buyer sales goal = ",{"$f":"B50*B57","v":30},{"$f":"B58+B63","v":75},"Total deals double checked"]
["Contact goal = ",18,"per day"]
["2020 Planned Days Prospecting",200,{"$f":"B64*B65","v":3600},"Contacts for next year"]
["Income per contact plannned for 2020",{"$f":"B53/C65","v":148.54166666666666},"Auto calculates"]
[]
["Section 4 CLEARLY DEFINE what you'll do differently (SAMPLE TO WRITE OVER)",null,null,"Click Here"]
["1.  Completely update Database Plan for entire year before Jan 1 & have in my schedule",null,null,null,"Change for YOUR needs… "]
["2.  Increase My DB's COI by XX people by XX date",null,null,null,"Just a few examples! "]
["3.  Add 5 handwritten notes daily to vendors, coop agents, leads, past clients",null,null,null,"You should over-write this section!"]
["4. Increase total team contacts to 50 a day - 18 for me. Monitor at weekly meeting."]
["5. Make higher Quality Contacts by dropping low conversion source XX and adding ZZ.",null,null,null,null,"2020 Planned Days Prospecting"]
["6. Use Formula 1 minimum 4 days a week."]
["7. Change minimum standard to no further than 25 min from home/office"]
["8. Create a commission/service program to compete with Discounters"]
["9. Hire another assistant by Feb 1 to handle Marketing and DB Management"]
["10. Take 2 YCM Courses by Summer"]
[]
["Section 5 … Coaches Suggestions or Recommendations"]
["Fill in after talking with your Coach"]