Thread: need a loan payment schedule
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
  
Posts: 209
Default need a loan payment schedule
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
Reply With QuoteReply With Quote