The problem we have here is that without knowing what class this is for, and what method they want you to use to solve it, it could be solved several different ways - it would be difficult to show all ways.

The typical tables that are used for accounting and finance classes would not work for something with 360 payments. (12 montly payments x 30 years = 360 payments.) Most textbooks just don't include something going as high as 360.

Business math books usually have a special table made just for monthly loan payments, and since only mortgages are likely to be 30 years, there's probably a table just for mortgages that go in 5 year increments. You just take the amount on the chart and
multiply by the amount financed.

You can also use a financial calculator, and you can use the PMT formula in Excel. And there's also an algebra formula for this.

Regardless of the method, though, you do need to calculate 20% of the loan as the down payment and subtract that off to find out how much is being financed.

Excel is going to want interest as .085/12 (i.e. interest for the period), a financial calculator or chart will want it kept at 8.5%, not divided down, and not turned into a decimal version. Excel and financial calculator are going to want N which = 360.
(Total number of payments.) And I'm not even going to broach the algebra equation unless I know someone needs it.

As you can see, there's several ways to solve these, and each requires the information in different types of formats.

## Comments

(b) Semiannually

(c) Quarterly

(d) Monthly

(e) Daily

(f) every minute (N = 525,600)

(g) continuously

(h) simple (not compounded)

Comment