Exercise Two: As part of your plan to become a first time, homeowner, you take a

mortgage from your local bank. The principal loan amount is $$1,250,000,$ the tenor is $30$

years, and the interest rate is $3\mathrm{.}75\%.$ Assuming a fixed total monthly payment model for

this mortgage, $($a$)$ Compute the fixed monthly payment for this loan and verify your answer

by using the PMT function as shown in class, $($b$)$ Create an amortization schedule for your

mortgage, $($c$)$ using a bar chart, graph the cash flows $($i$.$e$.,$ Total Payment, Interest Paid, and

Principal Paid$)$ on the y$-$axis versus time on the x$-$axis, $($d$)$ if possible, add data labels to

your series, so that you can easily visualize the data. $(4$ Points$).$