A construction manager borrows $$1,200,000$ at $5\mathrm{.}5\%$ per annum, compounded monthly. The loan is to beretired in five years.a$.$ Draw the CFD from the lenders perspective. $(0\mathrm{.}10$ pt$.)$b$.$ What is the effective interest rate per month? $(0\mathrm{.}15$ pt$.)$c$.$ What is the effective annual interest rate? $(0\mathrm{.}25$ pt$.)$d$.$ Calculate the monthly payment for the loan. $(0\mathrm{.}25$ pt$.)$e$.$ Using a spreadsheet, prepare an amortization table for the loan showing the month, beginningbalance, total payment, interest component, principal component, and unpaid beginning balancefor the first $25$ payments. $(0\mathrm{.}5$ pt$.)$