Mоrtgаges аnd оther cоnsumer loаns when taken by an individual have an interest rate charged by the bank ‘r’. The borrower pays back the loan in periodic uniform payments of ‘A’ each. The people involved in the loan market, however, use specific and sometimes confusing jargon. For example, interest rates are quoted in percent per year, but are compounded monthly thus, r/12 is more accurately designated as the monthly rate. Letting ‘rm’ = r/12. With such repayments lenders are often required by law to provide the borrower with an amortization schedule, which is a list of all the payments with portion of the payment that is applied to interest and portion of the payment that is applied to the loan principal. Additionally, we define the remaining principal after payment M, RPm, as the present value (in time M dollars) of the payments remaining after a particular loan payment is made; the interest portion of payment M, Im, as the monthly interest rate multiplied by the remaining principal after the previous payment; and the total interest paid, TI, as the sum of the interest payments across all M. Suppose that you take a home loan of $300,000, the quoted interest rate (APR) is 7% per year, and the duration of the loan is 30 years (360 months). Calculate: What is the effective annual interest rate for this problem, ieff? What is the equivalent interest for the time period, iper? Periodic payment amount, A What is the remaining balance at the end of 12 years, RP144? Develop an excel model to check your above answers and to: Generate an amortization schedule for this loan Determine the total interest paid, TI?