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?

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

support your answer using the data presented. (5 points). 4. based on the information you used to schedule and curve, which product would you recommend the shoe hut focus on, and why? provide details that support your answer. (5 points).