<human>:  How do I prepare an amortization schedule in Excel?
<bot>: Prepare Amortization Schedule in Excel
1. Download the amortization schedule from Microsoft.
2. Open the template in Excel.
3. Fill out your loan data in the "ENTER VALUES" section.
4. Type the bank name as the "LENDER NAME."
5. Save the worksheet as an Excel file.