Excel Instant Amortization Table - Baylor University

[Pages:1]Nonprofit Technology Collaboration

Excel Instant Amortization Table

An amortization table displays each periodic payment on a loan so you can see the impact on your loan balance over time. Excel allows you to instantly generate an amortization table.

1. Right click on any worksheet tab and choose Insert.

2. Navigate to the Spreadsheet Solutions tab and then double click on Loan Amortization.

3. Fill in the information at the top left corner of the worksheet.

4. Hit Enter and a table of periodic payments will be automatically generated.

Last Updated: 08/07/2012

Excel Instant Amortization Table

Page 1 of 1

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download