Amortization Schedule - Excel

1. Create a generic data input table at the top, allowing the user to input each of the following:

• Principal
• Number of years
• Compounding periods/year
• Annual interest rate

2. The spreadsheet must contain, at a minimum, the following 7 columns of numbers and formulas

• Period
• Beginning Balance: Currency format
• Total Payment: Currency format.
• Interest Paid: Currency format
• Principal Paid: Currency format
• Ending Balance: Currency format
• Extra Principal Paid: Currency format

3. The table should allow for up to 360 total periods of amortization.

4. Include formatting or if-then statements to make the amortization table match the loan (for example: A 10-year loan with monthly payments should only have 120 rows)