In: Finance
For the following fixed-rate, level-payment mortgage: maturity = 15 years, amount borrowed = 90% of the appraised home value, appraised home value = $500,000, and annual note rate = 6%
(a) Construct an amortization schedule for the first 3 months.
(b) What will the mortgage balance be at the end of the 15th year assuming no prepayments?
(c) Without constructing an amortization schedule, what is the mortgage balance at the end of the 7th year assuming no prepayments?
(d) What is the loan to value ratio (LTV, stated as a percentage) for this mortgage at the end of the 3rd month?
(a) Construct an amortization schedule for the first 3 months.
Provided in Image
(b) What will the mortgage balance be at the end of the 15th year assuming no prepayments?
Mortgage Balance after 15 years will be equal to Zero
(c) Without constructing an amortization schedule, what is the mortgage balance at the end of the 7th year assuming no prepayments?
Mortgage Balance after 7 years = $288960.61
(d) What is the loan to value ratio (LTV, stated as a percentage) for this mortgage at the end of the 3rd month?
LTV ratio at the end of month 3 = Loan O/s / Appraised Value
LTV ratio at the end of month 3 = 445334.68 / 500000
LTV ratio at the end of month 3 = 89.07%
Please dont forget to upvote