How do I make an Amortization schedule in Excel?

amortization
Becky D asked:


This is my HW question:
Create an Amortization schedule for a long term loan in an Excel Spreadsheet.
Use 340,000 for the amount financed for 30 years with a rate of 6.25 %
and print out 24 months of the schedule. (It may be helpful to fill in values before you enter
the formula for calculating monthly payment.)

I have no idea how to put this into excel.

http://1mortgagecalculator.info

One Response to How do I make an Amortization schedule in Excel?

  1. Msean

    Here’s a youtube video

    Here’s some other videos if that one isn’t right for your needs.

    =&aq=f

Leave a Reply