$(\frac{1}{12})$ since it is monthly.

How much is still owed on the loan just after $110$ payments.

$

Just after the $110$ payment, how much has been paid in interest?

$

What is the owner's equity just after the $110$ payment?

$

Find the size of the last payment.

$

How much interest in total did you spend on the house?

$

For the $30$ year option, at which payment does more of the payment go to principal than to interest?

Now save the first part of your spreadsheet by going to File then Save.

How much is still owed on the loan just after $60$ payments.

$

Find the size of the last payment.

$

How much interest in total did you spend on the house?

$

For the $15$ year option, at which payment does more of the payment go to principal then to interest?

Determine the total amount of interest saved on the loan by getting a $15$ year loan instead of a $30$ year loan.

PLEASE USE AN EXCEL OR GOOGLE SPREAD SHEET FOR THIS