MODEL 5: LOAN AMOTIZATION TABLE, VERSION 2 The Problem Create a model to produce an amortization table for a fixed rate loan. The loan is to be repaid in equal annual instalments over its life and the first payment is to be made at the end of the first year. Instead of using Excel's built-in financial functions, use Goal Seek to calculate the required constant annual payment. The model should validate the user inputs for appropriateness and ask the user to modify any input that is not appropriate