You are the chair of a nonprofit pottery studio, $$You are Fired.$$ The board has been offered the opportunity to purchase studio space for $$1,000,000,$ and can use part of its reserve fund to pay for the $$200,000$ down payment. It can get a fifteen$-$year mortgage with end$-$of$-$month payments at a $3$ percent annual rate of interest. Please answer the questions below: $**$Format answers with commas to separate thousands, hundred thousands and provide decimal places as noted in the question.

a$.$ How much will the organization have to finance with the mortgage? Please round to the dollar $($e$.$g$.,1,200,000,$ not $1,200,000\mathrm{.}00).$

$$[$A$]$

b$.$ What is the effective periodic interest rate and number of periods for this mortage?

Periodic Interest Rate: $[$B$]($Please round to four decimal places, e$.$g$.,0\mathrm{.}0020,$ not $0\mathrm{.}002$ or $0\mathrm{.}2$ percent$)$

Number of Periods: $[$C$]($Please round to the one, e$.$g$,450,$ not $450\mathrm{.}00)$

c$.$ Use the information from $($a$)$ and $($b$)$ and the payment function in Excel to determine the amount of the mortgage payment.

PMT $=$ $$[$D$]($Please round to the dollar $($e$.$g$.,45,001,$ not $45,001\mathrm{.}25)$