Here's how I'd do it. I didn't bother to separate out the principal and interest, though that would be easy to do.
I used two methods - one using Excel's FV function, and the other calculated manually. The manual method is using a continuous growth assumption, so it's off a tad bit, I'll bet.
In the final seven games of the 2013 season, the Chiefs averaged 34.6 points per game, scored 38 points or more 4 times, and went 2-5. The NFL has ruined the sport.
Last edited by Rain Man; 05-13-2008 at 06:29 PM..