For an Excel solution, take your pick:

http://office.microsoft.com/en-us/te...tion&av=TPL000

--
Steve

"gls858" wrote in message
...
gls858 wrote:
I need to show a loan amortization and I don't have a clue what to do.

Here's the data.

8.5% interest rate compounded monthly
loan amount 47,500.00
24 payments

I would like to show the interest and principle paid each month.

TIA

gls858

I'm so used to looking here for solutions I forgot to check the web.
I found a site that gave me exactly what I wanted.

Thanks to Bret Whissel at

http://www.bretwhissel.net/cgi-bin/amortize


gls858