need a loan payment schedule

[gls858]

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

 

[gls858]

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

 

[AltaEgo]

For an Excel solution, take your pick:

http://office.microsoft.com/en-us/templates/results.aspx?qu=amortization&av=TPL000

 

[gls858]

For an Excel solution, take your pick:

http://office.microsoft.com/en-us/templates/results.aspx?qu=amortization&av=TPL000

Thanks ALtaEgo. Another good source I had forgotten about.

gls858