Pod Insights The Property Academy Podcast Misleading spreadsheets: Excel is more dangerous than you think⎥Ep. 1958 About this episode In this episode, we discuss the drawbacks of using spreadsheets as a property investor. This includes the potential to be misled if you think that the spreadsheet shows you exactly what will happen in the future. So, we share the mindset that property investors and homeowners should have when they use a spreadsheet to make property decisions. For more from Opes Partners: Sign up for the weekly Private Property newsletter Instagram TikTok
Transcript 0:08 Speaker 00 Hello and welcome along to the Property Academy Podcast by Opes Partners. I'm your host, Stephen Knight.
0:12 Speaker 01 And I'm Andrew Nichol.
0:13 Speaker 00 And today on the show, we're talking about why spreadsheets suck. That includes why you can't believe spreadsheets when you run your numbers.
0:20 Speaker 01 Well, well, well, well, well.
0:22 Speaker 00 I'm not finished. We're also going to learn the mean things that other financial advisers have said about my spreadsheets and what I think about it. And also how to make sure that you're not bamboozled by a spreadsheet to make the wrong financial decision. And it's quite interesting because I saw on Facebook the other day that somebody had said something mean about my spreadsheets, saying that they were, quote, borderline misleading. And it got me thinking, look, I love a good spreadsheet. You love a good spreadsheet. Everyone loves a good spreadsheet, but there are some bad things about them. And I think it's important to dig into that and say, okay, well, when could spreadsheets be borderline misleading? And what do we mean by that? So Andrew, are we officially spreadsheet skeptics now?
1:03 Speaker 01 Well, I wouldn't say that, but I think what everyone needs to realise is that spreadsheets almost never match reality. It's very unlikely if you're doing some projections for anything, like a business projection, or a property investment projection, or a managed fund projection, you're not going to be right. And so if you're looking at it in a spreadsheet, you've just got to remember that spreadsheet is giving an outcome based on what you're inputting into it, or your financial advisor is putting into it, and they're making an educated guess, or you're making an educated guess if you're doing it yourself. And it actually reminds me, I remember one of our financial advisers had one of their investors come to me with a bit of a complaint once. And they had the spreadsheet and they
1:44 Speaker 01 said, we've owned this property for a year now, and it has not gone up 6% like it said it was going to on the spreadsheet. And so what I had to explain is, hey, this is looking at a long-term average. It's not going to be correct year on year. But it was really interesting for me just to understand that people had taken that and thought, oh, that's what I can expect next year. And so we really had to do some education around making sure people understood that's not guaranteed. That's just a best guess of what it might look like over the long term.
2:13 Speaker 00 Yeah, it is a model of what could happen, not a model of what will happen. Those two things are are quite different and it's important that you understand that. Because I can certainly understand what that person on Facebook was thinking when they say, oh, well, is it a bit misleading to say? This is what the future could look like. And I suppose if you sit down and you think that the spreadsheet is telling you this is what will happen. Then yes, the spreadsheet will mislead you, right? Because that is not what is going to happen. But it's about understanding what could potentially happen and understanding the future and getting a better view of what could happen rather than just guessing. Because having some model of how all the numbers could work out is probably going to help you make a better decision
2:56 Speaker 00 than just guessing and having no information at all. And I think one of the big issues when you create a spreadsheet and it's it's whether you use ours or anybody else's or you make your own, is you're typically going to create what we call a central scenario. So you might assume that rents go up by four point seven percent a year. And yes, that's because that's what the average has been over time. But when you say that the average is four point seven percent, that means there's a fifty percent chance that rents go up by more than that next year. And there's about a fifty percent chance that rents go up by less than that over the next year. And it's quite hard to model out the fact that that's not going to be the case every single year. Because there's a lot of volatility. Sometimes rents will go up by eight percent per year and sometimes they'll go down by one percent per year.
3:41 Speaker 00 So those unexpected ups and downs are quite hard to model out in a spreadsheet, not impossible. And I do work on some more sophisticated modeling for our investors to kind of show a range of outcomes. But typically quite difficult to show. So I think the mindset you've got to have, if you are not going to be misled by a spreadsheet, is to say, this is just a spreadsheet scenario. Yeah, this is a computer scenario that we are creating. And the computer is probably not going to match up with reality. It can help me figure out what might happen, but it will not show me what will happen. So the spreadsheet is not there to help you predict the Future, but help you think through potential scenarios for what could happen. So you can make a decision.
4:26 Speaker 00 And then spreadsheets have errors, Andrew.
4:28 Speaker 01 Yeah, even Edward McKnight had a couple of errors. When he, when he sent off his spreadsheet to a world champion, he found errors in it. He said, I can't believe I've got mistakes in there, but I'm sure.
4:37 Speaker 00 No, I could believe.
4:38 Speaker 01 Yeah, yeah, but, but I'm sure you felt better when, I know you sent me that article from Forbes. And it said that eighty eight percent of spreadsheets have errors in them. And probably the other twelve percent just haven't had them found yet. And you're just going to remember, human beings are what make spreadsheets. And as they become more and more complex and then you add features on or you change things around. It's inevitable that you're going to end up with a calculation error somewhere along the way. And that's just human nature, that a mistake will happen somewhere along the way. And actually, it kind of makes me think about the fact that I would say, you know, at least once a month. I'll be working with an investor and they will want to get their heads around an investment and the numbers of an investment.
5:20 Speaker 01 And they might be analytical, they might be an engineer, or they might be a teacher or something like that. And so they build their own spreadsheet. And then they can't get the numbers to match up what we've got in Opus Plus, for example. And they say, well, where's the difference? And then, of course, when you go through it and you're trying to figure out, well, where has the mistake occurred? And the spreadsheet, what's been missed or what's been calculated twice? That we're getting a different outcome and it's just because, again, there's lots of moving parts.
5:47 Speaker 00 And spreadsheets are a bit like creating a novel. Like if I write a book, I'll write it a specific way. If another person writes a book, they'll write it in a slightly different way. Now, the stories can have similar themes, but the exact words that are written, the exact outcomes will be slightly different. And so a lot of it comes down to assumptions. And one of the big ones I often find when people send me their spreadsheets is tax. They've miscalculated how tax works.
6:12 Speaker 01 Yeah, that's, that is the most common that I see as well.
6:14 Speaker 00 And it might be that you're not factoring in things like chattel depreciation. Or you might not be factoring in things like, if you have a principal and interest mortgage. You can't just say, oh, cool, I'm earning fifty thousand dollars of rental income. And I've got a forty thousand dollar mortgage, so my taxable. Profit is $10,000. Uh, no, no, no, no, no. If you're paying principal, if you're paying down that debt, that part's not tax deductible. So the IRD might say, hold on, hold on, hold on. You're making a $20,000 profit that you've got to pay tax on. That's a, that's a classic one that I see quite frequently. And just on the errors, Andrew, some people will be quite concerned with that. The big thing that you've always got to ask when it comes to spreadsheet errors are, are they material? And would they change the decision?
6:59 Speaker 00 So the test for whether something is material or not is typically whether it is over a couple of percent. If it affects the outcome that much, typically the errors we find are quite small. But one thing I'd just say for anybody who's using things like Opus Plus or some of the spreadsheets I've put out. Most of the important ones for analyzing investment properties, I've had audited twice. Once by my fiduciary, which is a very well respected investment company in Auckland. And even after I had that spreadsheet audited and then I sent it off to one of my Microsoft Excel champions. They still found spreadsheet errors after it had passed the audit. So it is very common that there will be small immaterial errors that come through different spreadsheets. That's just the reality of life.
7:43 Speaker 00 The question is whether it would have changed your, your decision, whether to invest in a particular asset or not. And what I would just say is a spelling mistake in a book doesn't mean the whole argument for the book was wrong. A stumble in a speech or a podcast, of which we obviously have many, doesn't render the whole speech or podcast inadequate. The wrong figure quoted in an article doesn't necessarily mean the argument of the article was wrong. So just be aware that not all errors are material. The word error itself can sound quite scary. Big errors are scary, small ones might not change your decision. And Andrew, I think even if you use data in the wrong way, people can be misled by data.
8:21 Speaker 01 Yeah, I think one of the common ones is seeing what the average growth of a particular area is over X period of time. So let's say you pull up a graph of Auckland house prices and you see, okay, over 20 years, they go up by a lot. But when you look at that graph, that's an average of all houses in Auckland and the average will always be smoother than an individual person's experience. Now, your property value might bounce around a whole lot more than the average because the average helps smooth out those fluctuations. But when you're looking at your specific scenario, you're talking about one property. So it can be a lot more volatile rather than just that average.
8:59 Speaker 00 I'll give you an example of that. Some of the investors who have investment properties that are managed by Opus Property Management, some of them have dropped their rent by a very, very large number, fifty five to sixty dollars a week. And when you put in some numbers into a spreadsheet, like rents go up by four to four point seven percent a year, the spreadsheet will say, okay, you might have negative cash flow, but we don't expect, or the spreadsheet doesn't model out that your rent's going to decrease. So what happened in that situation? How did that happen? Well, in this case, the investor made the decision to drop the rent to get a tenant in quick before Christmas. Now, that is not the average experience.
9:41 Speaker 00 In fact, the average experience is that some people are increasing their rents by ten dollars a week and some people are dropping it by ten dollars a week and it kind of averages out to a pretty flat market. But in some extreme examples, people will be able to increase their rents by a lot or decrease their rents by a lot, and a spreadsheet won't factor that in.
9:58 Speaker 01 Yeah, and actually, I'll give you an example of a real investor that I worked with back in two thousand and sixteen. So they bought a property in Wigan and Christchurch for four hundred and eighty nine thousand. God, those were the good old days. And for the next three years, the property price was pretty flat. And then a couple of years after that, it took off and then they came crashing back down. Now, CoreLogic and One Roof have the value today at seven hundred and forty five thousand dollars. So the investor has made two hundred and fifty six thousand dollars on paper, so an average of five point four percent per year. Now, that's above what we would normally forecast of a Christchurch growth rate of five percent per year. And it's worked out that, yes, they've achieved that, but it's been quite a bumpy ride to get there.
10:41 Speaker 01 Like, in the first few years of topping up that mortgage and getting no growth, they probably felt a little bit frustrated, but then over the long term, you see it all kind of play out.
10:51 Speaker 00 And that's made me think there's a difference between something being misleading versus somebody being misled. And what I mean by that is that if somebody put together a spreadsheet that said, house prices are going to go up by ten percent per year. To me, I would say, well, that's very misleading because it's so. Unlikely and in fact, there's no data to suggest that that's probably going to be the case. Even over the last five years in Christchurch, I think property prices are still up fifty percent. So you might say, oh, wow, property prices, they're going to be up ten percent on an ongoing basis. I'd say that's highly unlikely. That's probably quite a misleading assumption because I don't think the data supports it. Well, that is very different from a spreadsheet that's been created.
11:34 Speaker 00 If you don't understand that, well, this is, this is a model. This isn't, this isn't the crystal ball. This is a scenario for what could happen. Now, if you misuse the spreadsheet, you do have the potential to be misled. And so what we're really saying is, just to be very clear, you can't take anybody's spreadsheet as gospel. You can't take any forecast as this is what it is going to be. And I remember seeing, it was either on Facebook or Reddit, somebody said, oh, it's really interesting, you know. You guys on the podcast put out these spreadsheets and models, are the results accurate? So if I created a spreadsheet five years ago, would the results have looked like this? The answer is absolutely not, of course not.
12:16 Speaker 00 Because what we didn't predict at the time, five years ago, was that interest rates were going to drop. And what we didn't predict five years ago is that if you bought a house in two thousand and nineteen, in twenty twenty one, Labour changed the tax rules, that meant that your property, even if you bought it as a new build, would then be considered an existing property. And your tax benefits would have been phased out. And then what you wouldn't have been able to predict back in two thousand and nineteen is that then Christopher Luxons, a government gets elected and then the tax rules get changed back again. And then what you couldn't have predicted is that actually interest deductibility got phased back in at a faster rate than national campaigned on at the election. And then interest rates spiked and inflation and all of these different things. What you also couldn't have predicted is that house prices spiked a hell of a lot during the COVID nineteen pandemic.
12:59 Speaker 00 And so any model that you create, any spreadsheet that you create will be wrong. I don't even like saying, I think what we said at the start, which is that they are almost always wrong. They are always wrong in terms of creating a forecast. And what you've got to treat it as, as, well, I am doing the best job I can, and not me, but you. In terms of making a decision and running scenarios so that I can understand the future and whether I can deal with whatever the future could look like, you're doing as much as you possibly can to make the best decision possible. And my challenge to people is often create something better. If you think I've done something wrong, create something better because I'm not here saying that the things that I create are the be all and
13:43 Speaker 00 end all. What I'm trying to do is provide more clarity, more understanding of how much money you can borrow or what your investment property might do in the future or any of the other spreadsheets we put out, what your portfolio looks like when you put it all together and give you more understanding of your own situation than you currently have. And I think this idea of pulling other people's work down when the alternative or the status quo is, well, just don't have any analysis, insight or scenario planning, I think is the wrong way to go. And I think is really indicative of quite a small minded mindset where we say, other people are doing more than me. I don't like it. I want you to use my services of my mortgage broking business in Kaitya or wherever it happens
14:27 Speaker 00 to be. Not, not, not, not dissing anybody, no, that's the wonderful, wonderful town of Kaitya. But often it is a town on the smaller side where some of these advisors come from. And my challenge is please make something better because if you can, I would love to learn from you. Right, let's wrap it up there. But please don't forget to rate, review and subscribe to the podcast. It really does help us get the message out to more people.
14:54 Speaker 00 Thanks for listening to the Property Academy Podcast. I'm your host Steve Attnight. And I'm Andrew Lickle. We're going to be back here tomorrow with even more daily strategies, tactics and insights to help you get the most out of the New Zealand property market. Until next time.
Previous We create financial plans for NZ millionaires (and it's JUICY)⎥Ep. 1957 Next How to sell 1 investment property to buy 2 ⎥ Ep. 1959 Page updated November 15, 2026 · transcript and summary are machine-generated