The Mortgage info is used to fill out the Amortization schedule.

Mortgage info

Property Price $350,000

Loan Amount $280,000

Down Payment $

LTV $

Interest Rate 5.5% (annual)

Compounding Monthly

Term 15 (years)

Loan Payment $ (principal & interest only)

****I need to find the Down payment, LTV, and Loan Payment.****

Amortization Schedule

Month Beg balance Payment Interest Principal End Balance

1

2

3

4

5

6

7

8

9

10

*****I'm having trouble getting the entries for the amortization schedule started as well. I'm using excel to fill it out, the schedule is actually 180 months long. I just did 10 months for an example. No need to do all 10, if I'm showed how to do it within the first couple of entries.*****