The accompanying Homeownership spreadsheet contains a partially completed spreadsheet model for computing the monthly costs of home ownership. Complete the spreadsheet model by inserting the formulas for monthly mortgage payment $($B$12),$ monthly property tax $($B$13),$ monthly homeowner insurance premium $($B$14),$ monthly maintenance costs $($B$15),$ and total $($B$16)$ in the appropriate cells.

Image of questions needing help are below.

I have no more check my work so please be accurate.

Exel Data:

Variables:

House value: $$508,500\mathrm{.}00$

Interest rate: $4\mathrm{.}25\%$

Down payment $(\%$ of house value$)$: $20\%$

Number of years: $30$

Property tax rate: $1\mathrm{.}25\%$

Annual homeowner insurance premium: $$1,411\mathrm{.}00$

Maintenance cost rate $(\%$ of house value$)$: $1\%$

Monthly Cost of Home Ownership

Monthly mortgage payment:

Monthly property tax:

Monthly homeower insurance premium:

Monthly maintenance costs:

Total:

$-----------------------------------------------$

Annual maintenance cost rate

c$.$ What is the monthly total of home ownership using the assumptions stated in the spreadsheet?

Note: Round your answer to $2$ decimal places.

Answer is complete but not entirely correct.

d$.$ How much does the monthly total of home ownership increase if the owner decides to get a $15-$year mortgage instead of a $30-$year

mortgage?

Note: Round your answer to $2$ decimal places.

Answer is complete but not entirely correct. Variables:

House value:

Interest rate:

Down payment $(\%$ of house value$)$:

Number of years:

Property tax rate:

Annual homeowner insurance premium: $$1,411\mathrm{.}00$

Maintenance cost rate $(\%$ of house value $,1\%$

Monthly Cost of Home Ownership

Monthly mortgage payment:

Monthly property tax:

Monthly homeower insurance premium:

Monthly maintenance costs:

Total: