{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Agent Business Plan","Calculations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Agent Business Plan","index":0,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[[89,1,89,10],[91,1,91,10],[67,3,67,5],[68,3,68,5],[70,1,70,10],[65,10,65,11],[64,1,64,10],[21,1,21,10],[22,2,22,9],[4,2,4,9],[29,5,29,6],[24,2,24,9],[23,2,23,9],[5,2,5,9],[20,1,20,10],[41,3,41,5],[42,3,42,5],[32,3,32,5],[45,1,45,10]]}
[]
[]
[]
[]
[null,null,"Agent Business Plannner"]
[null,null,"Fill in the blue boxes only. All other boxes will be calculated automatically."]
[null,null,"How much do you want to make?",null,null,null,null,"Current Broker",null,"Fathom"]
[null,null,"1)","My income goal for the next 12 months (dream big)",null,null,"   BEGIN HERE    →",100000,null,{"$f":"H8","v":100000}]
[]
[null,null,"Your average home sale information"]
[null,null,"1)","Average Sale Price",null,null,null,220000,null,{"$f":"H11","v":220000}]
[null,null,"2)","Average Commission earned per sale",null,null,null,0.03,null,{"$f":"H12","v":0.03}]
[null,null,"3)","Average Gross Commission per sale (automatically calculated)",null,null,null,{"$f":"SUM(H11*H12)","v":6600},null,{"$f":"SUM(J11*J12)","v":6600}]
[null,null,"4)","Transaction Fee per sale",0.06,null,null,100,null,"Hover for Info"]
[null,null,"5)","Additional Costs per sale",null,null,null,50,null,0]
[null,null,"6)","Agent Split % (How much you keep)",null,null,null,0.7,null,1]
[null,null,"7)","Agent Commission per sale (automatically calculated)",null,null,null,{"$f":"SUM(H13*H16)-(H14+H15)","v":4470},null,{"$f":"SUM(J13*J16-J15)-Calculations!B14","v":6223.0079999999998}]
[]
[null,null,null,null,null,null,null,"Current Broker",null,"Fathom"]
[null,null,"Number of closed sides required to reach your goal:",null,null,null,null,{"$f":"SUM(H8/H17)","v":22.371364653243848},null,{"$f":"SUM(J8/J17)","v":16.069399235867927}]
[]
[null,"PLANNING YOUR YEAR"]
[null,null,"Note: The numbers below represent planning your year based on Fathom Realty's comission structure as seen above in the right column. \nIf you would like to plan your year using your current broker numbers, use the buttons at the bottom of this document to reavel those numbers."]
[null,null,"Listings Vs. Sales"]
[null,null,"Top agents' income is 75% listings sold, 25% sales. Below in the Yellow Boxes you will see the optimum numbers based on that metric"]
[]
[null,null,null,"Optimum Listings Sold  (75%) =",{"$f":"SUM(J20*75%)","v":12.052049426900945},"Optimum Sales Sold  (25%) =",null,{"$f":"SUM(J20*0.25)","v":4.0173498089669817}]
[]
[null,null,"Your numbers"]
[null,null,"1)","What % of your closings are listings?",0.6,"% Sales (auto calculated)",null,{"$f":"SUM(100%-E30)","v":0.4}]
[]
[null,null,null,null,null,null,null,"Optimum Numbers\n(for comparison)"]
[null,null,"3)","What percentage of your listings actually close?",null,null,null,null,null,0.9]
[null,null,null,"(use your percentage, or if new, use your office percentage)"]
[null,null,"4)","What percentage of your sales contracts actually close?",null,null,null,null,null,0.9]
[null,null,null,"(use your percentage, or if new, use your office percentage)"]
[null,null,"5)","How many appointments do you need to obtain 1 listing?",null,null,null,3,null,4]
[null,null,"6)","How many contacts do you need to obtain 1 appointment?",null,null,null,10,null,20]
[]
[null,null,"With this as your basis:"]
[]
[null,null,"1)","Number of listing sides required to close to reach your goal",null,null,null,{"$f":"SUM(J20*75%)","v":12.052049426900945},null,{"$f":"SUM(J20*$E$30)","v":9.641639541520755}]
[null,null,"2)","Number of sale sides required to close to reach your goal",null,null,null,{"$f":"SUM(J20*25%)","v":4.0173498089669817},null,{"$f":"SUM(J20*$H$30)","v":6.4277596943471709}]
[]
[]
[null,"Here's what you need to do in the next 12 months to achieve your income goal with Fathom"]
[]
[null,null,"I.","Number of sales contracts needed to open in next 12 months",null,null,null,{"$f":"SUM(H43/J35)","v":4.4637220099633126},null,{"$f":"SUM(J43/$J$35)","v":7.1419552159413007}]
[null,null,null,"(calculated by dividing #2 above by #4)"]
[null,null,"II.","Number of new listings I will obtain in next 12 months",null,null,null,{"$f":"SUM(H42/J33)","v":13.391166029889938},null,{"$f":"SUM(J42/$J$33)","v":10.712932823911951}]
[null,null,null,"(calculated by dividing #1 above by #3)"]
[null,null,"III.","Number of listing appointments needed annually",null,null,null,{"$f":"SUM(H50*H37)","v":40.173498089669813},null,{"$f":"SUM(J50*$J$37)","v":42.851731295647802}]
[null,null,null,"(calculated by multipyling the above row by #5 above)"]
[null,null,"IV.","Number of listing appointments needed monthly",null,null,null,{"$f":"SUM(H52/12)","v":3.3477915074724844},null,{"$f":"SUM(J52/12)","v":3.5709776079706503}]
[null,null,null,"(calculated by dividing the above row by 12 months)"]
[null,null,"V.","Number of listing appointments needed per week",null,null,null,{"$f":"SUM(H54/4)","v":0.83694787686812111},null,{"$f":"SUM(J54/4)","v":0.89274440199266258}]
[null,null,null,"(calculated by dividing the above row by 4 weeks)"]
[null,null,"VI.","Number of contacts needed per week to hit my listing goal",null,null,null,{"$f":"SUM(H56*H38)","v":8.369478768681212},null,{"$f":"SUM(J56*$J$38)","v":17.85488803985325}]
[null,null,null,"(calculated by multiplying the above row by #6 above)"]
[null,null,"VII.","Number of contacts needed per day to hit my listing goal",null,null,null,{"$f":"SUM(H58/5)","v":1.6738957537362424},null,{"$f":"SUM(J58/5)","v":3.5709776079706499}]
[null,null,null,"(calculated by dividing line V by 5 days)"]
[]
[]
[]
[null,"Your Current Broker"]
[null,null,"With this as your basis:",null,null,null,null,"Optimum Numbers\n(for comparison)",null,null,"Compared to Fathom"]
[]
[null,null,"1)","Number of listing sides required to close to reach your goal",null,null,null,{"$f":"SUM(H20*75%)","v":16.778523489932887},null,{"$f":"SUM(H20*E30)","v":13.422818791946309},{"$f":"J68-J42","v":3.7811792504255539},"more"]
[null,null,"2)","Number of sale sides required to close to reach your goal",null,null,null,{"$f":"SUM(H20*25%)","v":5.592841163310962},null,{"$f":"SUM(H20*H30)","v":8.9485458612975393},{"$f":"J69-J43","v":2.5207861669503684},"more"]
[]
[null,"Here's what you need to do in the next 12 months to achieve your income goal with your current broker"]
[]
[null,null,"I.","Number of sales contracts needed to open in next 12 months",null,null,null,{"$f":"SUM(H69/J35)","v":6.2142679592344017},null,{"$f":"SUM(J69/$J$35)","v":9.942828734775043},{"$f":"J73-J48","v":2.8008735188337424},"more"]
[null,null,null,"(calculated by dividing #2 above by #4)"]
[null,null,"II.","Number of new listings I will obtain in next 12 months",null,null,null,{"$f":"SUM(H68/J33)","v":18.642803877703209},null,{"$f":"SUM(J68/$J$33)","v":14.914243102162565},{"$f":"J75-J50","v":4.2013102782506149},"more"]
[null,null,null,"(calculated by dividing #1 above by #3)"]
[null,null,"III.","Number of listing appointments needed annually",null,null,null,{"$f":"SUM(H75*H37)","v":55.928411633109626},null,{"$f":"SUM(J75*$J$37)","v":59.656972408650262},{"$f":"J77-J52","v":16.805241113002459},"more"]
[null,null,null,"(calculated by multipyling the above row by #5 above)"]
[null,null,"IV.","Number of listing appointments needed monthly",null,null,null,{"$f":"SUM(H77/12)","v":4.6607009694258021},null,{"$f":"SUM(J77/12)","v":4.9714143673875215},{"$f":"J79-J54","v":1.4004367594168712},"more"]
[null,null,null,"(calculated by dividing the above row by 12 months)"]
[null,null,"V.","Number of listing appointments needed per week",null,null,null,{"$f":"SUM(H79/4)","v":1.1651752423564505},null,{"$f":"SUM(J79/4)","v":1.2428535918468804},{"$f":"J81-J56","v":0.35010918985421779},"more"]
[null,null,null,"(calculated by dividing the above row by 4 weeks)"]
[null,null,"VI.","Number of contacts needed per week to hit my listing goal",null,null,null,{"$f":"SUM(H81*H38)","v":11.651752423564506},null,{"$f":"SUM(J81*$J$38)","v":24.857071836937607},{"$f":"J83-J58","v":7.0021837970843563},"more"]
[null,null,null,"(calculated by multiplying the above row by #6 above)"]
[null,null,"VII.","Number of contacts needed per day to hit my listing goal",null,null,null,{"$f":"SUM(H83/5)","v":2.3303504847129011},null,{"$f":"SUM(J83/5)","v":4.9714143673875215},{"$f":"J85-J60","v":1.4004367594168716},"more"]
[null,null,null,"(calculated by dividing line V by 5 days)"]
[]
[]
[]
[null," Note: Always round up."]
[]
[null,"To learn about how Fathom helps their agents achieve their goals, visit www.FathomCareers.com."]

{"sheet":"Calculations","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Quantity","Unit Price"]
[]
[]
[]
["Sales",{"$f":"$B$29","v":15.151515151515152},null,null,"1-12 Sales",1,450]
[null,null,null,null,"13+ Sales",13,99]
[null,null,null,null,null,9999999,99]
[]
[]
[null,null,null,null,null,9999999]
[]
["Total Split to Fathom",{"$f":"SUM(IF(IF(B$5>=F6:F10,F6:F10-F5:F9,$B$5-F5:F9+1)>0,\nIF(B$5>=F6:F10,F6:F10-F5:F9,$B$5-F5:F9+1),0)*G5:G9)","v":5712}]
[]
["Average Split per sale",{"$f":"B12/B5","v":376.99199999999996}]
[]
[]
[]
[]
["My income goal for the next 12 months",{"$f":"'Agent Business Plan'!$J$8","v":100000}]
["Average Sales Price",{"$f":"'Agent Business Plan'!$J$11","v":220000}]
["Average Commission earned per side ",{"$f":"'Agent Business Plan'!$J$12","v":0.03}]
["Average Gross Commission per side",{"$f":"B20*B21","v":6600}]
["Transaction Fee"]
["Additional Costs per sale"]
["Agent Split %",1]
["Agent Gross Commission",{"$f":"(B22*B25)-B23-B24","v":6600}]
[]
[]
["Number of closed sides required to reach your goal",{"$f":"B19/B26","v":15.151515151515152}]