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...