Loan amortization

[Jammer Six]

I'm sure everyone and their brother wants a loan amortization template,
and I would be happy with the one that comes with Excel 2004, but I
need one that will allow me to set the payment.

I have a real estate problem that has a set PV, interest rate and
payment, and what I need to do is calculate FV's at various stages.

Is there such a template out there?

Thanks!

 

[JE McGimpsey]

I'm sure everyone and their brother wants a loan amortization template,
and I would be happy with the one that comes with Excel 2004, but I
need one that will allow me to set the payment.

I have a real estate problem that has a set PV, interest rate and
payment, and what I need to do is calculate FV's at various stages.

Is there such a template out there?

Don't know about a template, but the formula isn't difficult.


Try:

A B
1 Principal $100,000
2 Interest Rate 5%
3 Monthly Payment $1,000
4
5 Period (Month) FV
6 1 =ROUND($B$1-($B$3-$B$1*$B$2/12),2)
7 2 =ROUND($B6-($B$3-$B6*$B$2/12),2)

Copy B7 down as far as necessary.