Monday, October 19, 2009

Formula For Success

So far, this is the sweetest Excel formula I've pumped out tonight:

=(BZ7/(BZ3-BZ5))*(1-((1+BZ5)/(1+BZ3))^2)+(BZ11/(1+BZ3)^2)

It's most of the Two-Stage Growth formula for valuing stocks with nonconstant dividend growth. Just thought I'd share because I almost frisbeed my laptop across the room in a fit of glee when the answer came out right. Don't ask what the freak I'm doing out there in column BZ. I don't even know. I think I'm going to want that formula on my cheat sheet, but I better not need to use it on the mid-term.

- Erik Rasmussen

No comments:

Post a Comment