Tuesday, November 10, 2009

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.

No comments: