Question

You need a 25-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 8.6 percent APR for this 300-month loan. However, you can afford monthly payments of only $800, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. Required: How large will this balloon payment have to be for you to keep your monthly payments at $800?

Answer 1

Answer:

the balloon payment after 300 months is $1,205,266.38

Explanation:

In order to pay the loan completely after 300 months, your monthly payment should be $1,948.75. Since you can only pay $800 per month, the loan's balance after 300 payments will be $1,205,266.38. This is irrational since you will end up owing 4 times the initial amount. You will never even be close to paying even the interest expense, so the principal increases every month.

I prepared an amortization schedule using an excel spreadsheet