$015$

vvvdots$vv{f}_x$

A

B

C

D

E

F

G

$H$

$1$

J

K

L

M

N

$0$

P

Mortgage calculation

PV

Interest rate

Years

Payments per year RATE NPER

PMT

$$300,000$

$6\%$

$30$

$12$

$0\mathrm{.}50\%$

$360$

$$1,798\mathrm{.}65$

Above you will see the calcuclations for a mortgage payment $($PMT$).$ Please complete the data tables below.

In the first data table $($one variable$)$ you will calculate the PMT for different annual interest rates. In the second data table $($two variable$)$ you will calculate the payment for different combinations of loan maturity $($years$)$ and annual interest rates. You must use the Data Table tool.

One variable Data Table

Two variable Data Table

$\backslash$table$[[$Interest Rate,$$1,798\mathrm{.}65$