Zoho Sheets = Live Embedded Spreadsheets

zoho_sheet_logo12

So I will admit – I’m an Excel freak. If there is a project, workflow, or experiment to be made – you can bet that I have created an Excel sheet for it. That being said – it does have it’s limitations and when I was faced with a recent predicament that even the almighty Google couldn’t accomplish I had to think outside the box and revisit my old friend Zoho.

Recently, one of my agents and I were talking about the importance of proper pricing and what a seller actually “pays” and “nets” by overpricing their home. That led me to create the below spreadsheet that based on a simple mortgage formula and summing up the monthly costs of ownership for a home-owner (mortgage, taxes, assessments, etc.) Once we have this number we can simply pull simple data using MLS info OR (my personal favorite – Agent Metrics from Terradatum) and plug in the numbers for DOM (days on market) and SP/OLP (sales price to Original List Price ratio).

So this was cool, and I have had a number of agent use this in their listing presentations to either 1. Get the price they want from the start or 2. Show what it has cost the seller already (if they have previously been listed). It’s great info and really drives the point home – however I was stumped when an agent approached me and said, “I’d really like to embed this on my website so that I can drive traffic there from my farm.”

Take 1 = I fooled around with Excel and found that I could export it as a webpage (great) which I could then open with Notepad to see the HTML code (awesome). However, this being a Microsoft based program – I soon found the problem in my ways when viewing this in Firefox:

Internet Explorer 5.0.1???

Internet Explorer 5.0.1???

Take 2 = So I scrapped that idea and went the “cloud based” route and opened up a quick Google Doc. Upload – Activate – Format – Share. Got the code and placed it on my site. Result = #fail Where the sheet showed up fine, the functionality of the sheet was removed and the consumer could not take advantage of putting in their home value, taxes, assessments, etc. (NOTE – I am not saying that I didn’t overlook something, so if I mistaken – please leave my error in the comments section)

Take 3 = I have played around with the suite of solutions put together by Zoho.com off and on over the years. I can’t tell you why i don’t use them more often other than the fact that I (like many) am a slave to Google. So after logging into my Zoho Account – make my way over to Zoho Sheets – upload the document – and presto! See the finished piece below.

Take a look at the functionality in this sheet – the consumer can actually fill in their information on their own and see the true value in correct pricing. Feel free to download and use with your clients – and as always, I’m open and eager for any suggestions on how I could make this better!

~ Matt

Comments

  1. Love it, Matt.

    We should chat — call me or something.

    Couple of things that stand out — I think you need to recover some of the equity in the “costs incurred”. Depending on where the homeowner is in his amort schedule, he may recover more of the payment than one might think.

    Also, isn’t his tax rate relevant to the cost vs. benefit analysis, since he can deduct his mortgage interest, right?

    I know that makes the spreadsheet larger and more complex, but…

    The key thing, however, seems to me to be the correlation between pricing and DOM. If that is just an agent’s gut feeling, not sure how convincing that is. Why not reduce to $2M and bring DOM down to 5 days? Is there a clear correlation?

    -rsh

  2. Thank you for modeling good practices for the real estate industry. I would love to see the actual spreadsheet. The Excel download produced an error and the View Full Screen showed values only. Maybe I’ll try a different browser.

    Your statistical arguement is interesting… Anything that helps sellers see the light of day!