The Mortgage info is used to fill out the Amortization schedule.
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.*****
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
