On Mortgage Spreadsheets and Old French Origins

Khan Academy Mortgage spreadsheetI was scouring the interwebs lately for a financial education project I’m doing and I came across Sal Khan’s joint educational venture with Bank of America called www.bettermoneyhabits.com

There’s some very good stuff there, but I was drawn in particular to his “How does a mortgage work” video.

I recommend checking it out here.

I happen to have this weird belief that everybody who takes out a mortgage (or car loan, or business loan, whatever) should be required – as a pre-condition of their borrowing the money – to build their own ‘loan spreadsheet,’  in order to learn the nuts and bolts of how it works. If you’ve programmed it into a spreadsheet, and calculated how the principal and interest gets paid every month, and how it amortizes, you gain insight into interest rates and cash flows that you can’t get any other way.

Anyway, I know this weird belief will not be implemented by any lender anytime soon, so the next best thing is to introduce people to pre-made spreadsheets on mortgages, and to walk them through the component parts. As a master teacher, Sal Khan is suited to do this very well. There are a ton of pre-made mortgage spreadsheet available online, but Khan Academy’s is as good as any.

Khan Academy makes available a pre-made spreadsheet under the “Fixed Mortgage Calculator” link here, that lets you input amounts, and fixed interest rates and even tax rates to calculate interest savings.

Also, I had no idea that Mortgage comes from Old French meaning Dead-Contract, since presumably the contract or title to the real estate gets killed off over time, eventually releasing the borrower from the lien. Fun!




Post read (2938) times.

On Housing, Part II – The Risks

Monopoly hotelsIn my previous post on housing I posit that the money we spend on housing may be thought of as fulfilling a combination of functions – namely necessity, consumption, and investment.  To do the investment part right, we should try to separate in a clear-headed way which function we’re spending money on.  Housing as an investment has many advantages, but its also not a slam dunk.  I review here some of the biggest risks of investing in your house.


1. Negative Cash Flow – Residential real estate generally is a negative cash-flow investment.  Unlike stocks or bonds, for example, which typically generate cash for their owners, real estate always costs money to own.  There are taxes of course, but also frequently utilities, complicated electrical and mechanical systems to repair, housing association fees, and lawns to cut.

In addition, if you borrow money to own real estate, the loan often constitutes your largest source of negative cash flow.  If you are like most people, negative cash flow under many scenarios can turn the whole investment into a nightmare.

2. Illiquidity – Real estate notoriously sells slowly and expensively.  Residential real estate cannot be transferred from one owner to another without thousands of dollars in transaction costs, and fees that constitute a meaningful percentage of value.[1]

The non-uniform nature of residential real estate also contributes to illiquidity.  An exchange-traded stock or a bond shares uniform characteristics with millions or billions of dollars in value of identical securities, allowing for easy transactions and uniform pricing. 

Every housing unit, by contrast, differs in price from every other unit.  Physical wear and tear of course alters from unit to unit.  Unlike a stock or bond, once a house is ‘born’ it begins to diverge in price even from its identical twin house.

Even identical floor-plan apartments can vary in price, due to differences in view, angle of light, height, or expected noise from the street. 

All of this variation leads to price uncertainty, partly justifying the high transaction costs for real estate brokers.

3. Degradation – While stocks and bond may fluctuate in value, the brutal elements of the physical world do not fray financial securities like it does real estate.  We don’t care if the paper certificate is ripped or dog-chewed or hole-punched, as the value of a stock or bond is electronic, notional, and immune to inclement weather.  Broken windows, chipped paint, and flooded basements, however, don’t fix themselves.  You can’t ever just let an improved property sit for 30 years the way you can with a stock or bond.

4. Leverage – Or: What goes up, can come down.  Conventional mortgages allow you to put down 20% of purchase value on a house, and obtain four times that amount in debt – something unavailable to small-time investors in any other investing situation.  With ordinary price appreciation or real estate inflation over time, the financial return on your down payment jumps dramatically.  When real estate declines in value, however, you end up losing your down payment just as quickly. 

Borrowing money, by itself, doesn’t make you money.  Borrowing money to make an investment just exaggerates the rate of return on your investment in whatever direction the asset moves, for better or worse.  This is why big-time real estate developers periodically lose extraordinary fortunes in economic downturns – it’s all about the leverage.  It’s also why declining real estate value in a city – like Detroit since the 1980s – eviscerates any home-owning middle class.  It’s all about the leverage.

Before you buy your shelter rather than rent it, I recommend digging into each of these risks as they apply to your own situation  If you decide, upon a review of the risks, that renting makes more sense, that’s ok.  I am certain that in the past decade we had too many buyers of their shelter, rather than renters.  Undoing the damage of too many buyers of shelter is painful and destructive for individual households and the economy.

Of course I don’t recommend renting forever.  In the next post I review some of the great personal finance opportunities only available through home ownership.

See previous post On Housing, Part I – What we do when we invest in a house

And subsequent post On Housing, Part III – The Opportunities

[1] Real Estate broker fees on residential real estate still start at 6%, while additional transaction fees push costs up from there.  Frequently to the 8% of sale value range and above.

Post read (13499) times.