Create an amortization schedule on the Calculator worksheet, as shown in the sample worksheet. The amortization schedule should go to a maximum size of 30 years with 12 payments per year (360 periods). The Remaining Principal, Interest Payment, and Principal Payment formulas should be written so that if any of the input values change, the amounts will be automatically updated. The amortization schedule calculates how the periodic payment is split between principal and interest. As such, the initial value of the loan you are paying off (Remaining Principal) ignores the effect of the property tax and insurance, and is given by: PropertyPrice - DownPayment 9. To avoid #NUM! or #VALUE errors in periods past the end of the loan, nest your principal and interest payment formulas inside an IF or IFERROR function to return a 0 if no further interest or principal payments are required