Tuesday, October 7, 2014

Rule #1 Investing Spreadsheet / Calculator Version 1.4.2

Thanks for a number of readers for informing me of the significant changes that was made at MSN Money (the source of much of the stock data on the previous version of my Rule #1 Investing Spreadsheet).  10-year data is no longer available there.  As a result, I had to quickly scramble to find another source.  What I found was www.gurufocus.com and the 10-year data that it has is pretty amazing.  Therefore, I was able to revive my spreadsheet fairly quickly.

If you only use the first few tabs of the spreadsheet, you will see very little changes.  The only real change is that Canadian stocks are no longer supported (boo hoo...).  I suspect it would impact a small portion of us Canadians, but I'm mainly invested in US stocks anyway...

Anyway, you can find the new version here: http://goo.gl/GS3RyI .  As usual, to be able to use the sheet, you'd need to click on File > Make a Copy to create a copy for yourself.  You will need a Google account for this.  Cheers!

For reference, read my last post on the spreadsheet.

Wednesday, July 30, 2014

Rule #1 Investing Spreadsheet Version 1.4.1

Update October 7, 2014: Spreadsheet has been updated.  See http://goo.gl/KEm3ar

Hello Readers!  If you've been following me previously, then I must thank you for your loyalty, because my last personal post was written more than 2 years ago!  It's funny how priorities change very quickly in life.  Well, the word "idle" definitely doesn't describe my life over the past 2 years!  Anyhow, I'm glad I actually got around to writing this!

And if it's your first time to this blog, please take a look at all of my older posts...the last 2 years have proven that my wisdom, albeit finite, is not so bad after all.  Do click around and if you like what you see, please subscribe and/or follow (see navigation bar on right)!

Sorry, back on topic.  Although I paused blogging for a while, I definitely haven't stopped investing.  I've also made some tweaks to my Rule #1 Investing spreadsheet.  I give you Version 1.4.1: http://goo.gl/JlQYt4.  In order to use this sheet, you will need a Google account.  Once you're logged in to Google, click on File > Make a Copy and you're good to go.  You now have a copy of the spreadsheet in your Google Drive.  Feel free to make any modifications as you see fit.

Just a quick note of how to work the sheet.  In the "Stock" tab, you will see a "User Inputs" section on the left.  This is the only place where you should be typing in stuff.  Leave everything else alone if you just want to use the sheet as is.  Type in the symbol, select the country, type in any overriding inputs (e.g. estimated growth, etc.).  As soon as you type something, the sheet will automatically update.  It shouldn't take any more than a couple of seconds.

As a final note, I've been using the Fischer valuation model quite a bit and I like it over the Rule #1 model.  You can read all about it here: http://seekingalpha.com/article/960381-shhh-my-secret-valuation-model-revealed.

Have fun investing!  And write me a comment if you get a chance!




Tuesday, July 2, 2013

Property “Flipping” That’s Good for the Soul


Below is a guest post by Frank Bateson.  This is a continuation on our discussion on real estate investing.  If you would like to write a guest post, please contact me.  Click on the About Me link for my contact info.

Frank Bateson is a retired appraiser who is now dipping his toes into blogging. He is considered an expert on Windham NY real estate.  When he's not plugging away at his keyboard, Frank enjoys tracking the stock market and lowering his golf handicap. 

When the great subprime mortgage crash broke in the fall of 2008, I doubt there was anybody working in real estate, banking and finance, development, construction and contracting or any related fields (which means just about everybody) that didn’t feel at least a little sick. For many of us that sensation was the result of several concurrent reactions: anxiety/fear/panic, bewilderment, a mistrust of government and private sector financial prognosticators and experts, apprehension and insecurity about the future, and perhaps the most pervasive (apart from worry) – anger.

In the months that followed a flurry of blame swept through the media and population in general. Who was responsible? Was it Alan Greenspan and his support of deregulation or his replacement Ben Bernanke’s failure to see it coming? Was it President G.W. Bush for likewise backing and pushing deregulation or supporting his Treasury secretary Henry J. Paulson’s 2007 prediction that the subprime crisis was “contained”? Was it the banks and/or Fannie Mae and/or Freddie Mac? Standard and Poor’s, Moody’s and the other rating agencies’ apparent good-ratings-for-profit racket must have played some role in the collapse, right?

All of these entities and individuals mentioned no doubt contributed to the collapse, of course. However, for months if not years after the crisis there was pretty much a 100% chance that any story you encountered on the Great Recession would inevitably contain or close with a high-handed critical rebuke from the story’s author that really, when you got down to it, we were all to blame. If we’d just been a little more responsible maybe we wouldn’t be in this mess. The lion’s share of that blame often seemed to find its way to a particular breed of everyman- the property “flipper”.

Although there are several different subclasses, the species of flipping practitioner most people are familiar with, and the sort that now populates about a dozen television shows (with at least two more reportedly planned by CNBC), is the “fix and flip” artiste. The fix and flipper buys a property listed for less than that property’s value would be if all things were equal. Those unequal things include a house that’s in bad shape or looks like it is, is being foreclosed on, has been seized for whatever reason or often some combination of those. The flipper then fixes the house up and sells it for a profit.

Flippers got a bad rap for a few reasons. They were often considered a predatory symbol of the real estate market’s woes- flash in the pan slicksters who leeched off of honest people by artificially ratcheting up the value of properties that “honest” homeowners would have to pay more for. And unfortunately, there were indeed some scammers who’d work in collusion with each other and either dishonest or inexperienced mortgage brokers, appraisers and loan officers to inflate a property’s real value for shady flipping schemes.
Plus, it’s certainly not unheard of for underhanded hustlers to buy a property with major issues, make some superficial or cosmetic repairs or additions and sell a faulty product as a sound one. One of the most common admonitions of the fix and flip investors, however, was that a house just wasn’t a product meant for the making of a quick buck like doing so with other commodities like electronics, clothes, jewelry or even cars. Houses are meant to be homes and long-term investments that pay off when you move.
There’s something to be said for that perspective, certainly. That being said- even nowadays, with the market the way it is, prospective flippers can buy properties and turn them around for a profit without sacrificing one’s ethical deportment, spiritual commitment, moral code or integrity. In fact, when done right, flipping can do a great deal of good while turning a profit. The keys to doing it right is: having patience, being discerning, being honest and forthright with everyone involved in the process and making a commitment to legitimate property improvement.

Once you’ve gotten into property sales that aren’t costing you sleep at night (at least not because of your conscience) you’ll start to see the positive impact a good flip can have on your community and pocketbook. For instance, every successful real estate turning entrepreneur has an established network of subcontractors and maintenance people in their rolodex. That’s a huge link in the profit chain and obviously you’ll want to establish connections whose credentials, work ethic and honesty you’re sure of. Whenever rehabilitating a property everyone you employ in that network makes an honest buck; and an honest buck that contributes to the quality of a neighborhood.

There’s no neighborhood on the planet that would balk at a house on their block being improved. Improving and beautifying any house, particularly if it was something of an eyesore, raises the property values for everyone in the area. Not to mention that a distressed property has been made livable. Finally, and most importantly, when the house is put on the market an individual and/or their family has a home waiting for them.

As my wife and I bought our first house from a flipper, I know exactly how comforting it is to know that the house you’re buying has recently been inspected, touched up, certified, improved upon and often brought up to code. Had my wife and I bought the house as-is before the flippers had and attempted to hire the various contractors, about whom we’d have known little, and/or work on fixing the house’s quirks and shortcomings on our own, I have no doubt that the money we put in (especially if the hours of labor we’d have spent are included) would have been far more than the final closing cost of the house itself. So all in all, house flipping investors saved us money on the house we bought. Not a bad way to make a buck.