View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default need a loan payment schedule

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