Scott Adams Must Be Eavesdropping on My Email

This sounds like a couple of my students. For some reason, family deaths always seem to increase around exam time.

Spreadsheets, Spreadsheet, and More Spreadsheets.

Yesterday, I thought I was coming down with something - I had a sore throat when I went to bed, and I woke up this morning feeling kind of blah. So, I thought I'd muddle through my classes (unfortunately, it's my long teaching day), and then come home and go to bed. By the end of the day, I felt like I'd been beaten with a stick - sore and feeling heavy-limbed all over.

But, it was the Unknown Daughter's birthday, so we had festivities first.

Then, I thought I'd put in a little work on before going to bed. Big mistake.

I started working on some spreadsheet models for my Fixed Income class at about 9 (just for an hour or so, I thought). Before I realized it, it's 3 a.m., and I've stayed up too late once again.

So far, I've made two spreadsheet models. One calculates duration and convexity for any combination of coupon, maturity, frequency, and yield, along with some graphs. The other calculates the average life of a mortgage pass-through based on various prepayment assumptions (multiples of PSA). While they're not pretty (I'm not exactly a wizard at formatting), I'm pretty happy with them, because they both use fairly complicated (for me) nested IF statements.

Next up will be a model for a sequential-pay CMO. That should be fun.

I'll end up eventually turning all the models into video tutorials (probably over the break), and will assign them for the students to replicate the next time I teach the class.

My basic approach to teaching is that if they can't calculate it, they don't understand it. So hopefully these will help.

The Unknown Colonoscopy

Disclaimer: the following post is not for the faint of heart (or for those who have an overly developed sense of propriety). But then again, most of my readers aren't in those categories anyway.

Since I recently turned 50, I got to have that little procedure that comes with the turf - a colonoscopy. The actual deed wasn't bad at all, but the prelude was, shall we say, less than enjoyable. Since the docs want a clear "field of play". they make you go on a clear-liquid diet for the day prior to the procedure. So, I got to teach 3 classes on a diet of Jello, black coffee, and chicken bullion - not the easiest thing to do.

More importantly, they give you what they call "prep". the best way to give you a feel for what that involves is to point you towards this this classic video (warning: may not be safe for work - so turn the audio down a bit). The "prep" is essentially laxative mixed with rocket fuel. On the bright side, I got to read a couple of books I hadn't recently had time for while "parked" in the little room.

In any event, the actual procedure went fine, and there was nothing of concern down below deck. All I can say about it is "thank goodness for high-quality sedatives" - I went to sleep just before they started, and woke up in the recovery room after, with no memory of anything.

Once it was done, I grabbed lunch and went home to sleep off the remaining effects of the sedative (this took most of the afternoon). Of course, there was only one food that was appropriate for the first mean after waking. Luckily, since I married well above myself, the Unknown Wife was ready with pancakes and BACON for dinner.

For those of you that want a better sense of what the whole thing was like, no one says it better than Dave Barry. Just don't read it with any liquid in your mouth, or you'll be cleaning off your monitor (seat belt, indeed!). Then go sign up for a colonoscopy, if you are over 5o and haven't had one yet.

Damodaran on the Equity Risk Premium

The Equity Risk Premium is one of the central concepts of finance theory and practice. However, when we teach it in class (usually as part of the CAPM), we tend to do a lot of hand-waving and tell students to use historical ERPs. Aswath Damodaran of New York University has an excellent piece on SSRN titled "Equity Risk Premiums: Determinants, Estimation, and Implications" that's a must-read whether you're a professor, student, or practitioner. Here's the abstract:

Equity risk premiums are a central component of every risk and return model in finance and are a key input into estimating costs of equity and capital in both corporate finance and valuation. Given their importance, it is surprising how haphazard the estimation of equity risk premiums remains in practice. In the standard approach to estimating equity risk premiums, historical returns are used, with the difference in annual returns on stocks versus bonds over a long time period comprising the expected risk premium. We note the limitations of this approach, even in markets like the United States, which have long periods of historical data available, and its complete failure in emerging markets, where the historical data tends to be limited and volatile. We look at two other approaches to estimating equity risk premiums - the survey approach, where investors and managers are asked to assess the risk premium and the implied approach, where a forward-looking estimate of the premium is estimated using either current equity prices or risk premiums in non-equity markets. We close the paper by examining why different approaches yield different values for the equity risk premium, and how to choose the "right" number to use in analysis. (In an addendum, we also look at equity risk premiums during the market crisis, starting on September 12, 2008 through October 16, 2008.)

Read the whole thing here.

I'd Eat That

I just stopped by my favorite (on campus) coffee, bagel, and sandwich shoppe - I'm spending the afternoon grading exams that are due back tomorrow (groan).

Their latest sandwich offering is a Veggie Burger with Tomato, Onion, Provolone cheese, and Bacon. That's right - a veggie burger with bacon - probably the only way I'd eat one of those. Actually, it sounds pretty good. Bacon improves just about everything.