Laon Amortization Schedule in Excel

Question 1:An input table allowing the user to enter data as per the following:

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

Question 2: There should be at least 7 columns of numbers and formulas Period, as explained under:

• Beginning Balance, should b in Currency format
• Total Payment, should be in Currency format.(Excel payment function or TVM formula)
• Interest Paid, should be in Currency format
• Principal Paid, should be in Currency format
• Ending Balance, should be in Currency format
• Extra Principal Paid, should be in Currency format (possibility of Early or Balloon Payments)

Requirements:

• The table should allow for360 total periodsof amortization.
• Include formatting or if-then statements to make the amortization table match the loan.
• table must be blank after zero ending balance (no $0 dollars or negative values).