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.
Welcome to NFL Sunday! At 11:00 see Peyton Manning flip off the top rope and clothesline Clay Matthews! At 2:00 Drew Brees will hit Terrell Suggs with a chair! Buy your Andrew Luck jersey and let's get reeeeeady to rummmmmble!
Last edited by Rain Man; 05-13-2008 at 06:29 PM..