1. A generic data input table must appear at the top, allowing the user to input each of the following:

• Principal, Currency format
• Number of years, Number format
• Compounding periods/year, Number format
• Annual interest rate, Percentage format

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. Use the Excel payment function or TVM formula
• Interest Paid, Currency format
• Principal Paid, Currency format
• Ending Balance, Currency format
• Extra Principal Paid, Currency format (possibility of Early or Balloon Payments)

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, 10-year loan or 20-year loan).

• Amortization table must be blank after zero ending balance (no $0 dollars or negative values).
• A 10-year loan with monthly payments should only have 120 rows.
• In the same schedule, a 20-year loan (changing the input variables) with monthly payments should have 240 rows.