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.
__________________
I'm putting random letters here as a celebration of free speech: xigrakgrah misorojeq rkemeseit.
Last edited by Rain Man; 05-13-2008 at 06:29 PM..
|