How much in total do you have to pay back to the bank

Assignment Help Financial Management

Reference no: EM131835360

You want to purchase a condo in downtown Boston for $1,200,000. You can finance 80% of its cost by receiving a 20-year mortgage. Considering your income and your credit score, your bank offered 4.5% interest on your mortgage. For simplicity assume that you make yearly payments to your mortgage. Build an amortization schedule for this loan in Excel and answer the following questions.

a. How much in total do you have to pay back to the bank?

b. How much do you owe to the bank at the end of year 10?

c. At the end of year 10, you decide to refinance your home with a new 15-year 3.5% mortgage. How much is your new yearly payment?

d. Consider the initial mortgage (not the case where you refinanced). Starting from year 11, you decide to increase your yearly payments by 10% hoping that it helps you pay off your mortgage sooner. In this case, how long does it take for you to pay off your mortgage?

Reference no: EM131835360

Questions Cloud

At what price will the stock reach equilibrium : At what price will the stock reach an “equilibrium” at which it is perceived as fairly priced today?

Calculate the total cost for both options-leasing vs. buying : Calculate the total cost for both options. Leasing vs. buying: which is the best option for your small business and why?

Examples of the securities transacted in each market : Describe Primary and Secondary Financial Market activities and provide examples of the securities transacted in each Market.

What position in futures contracts on hedge the portfolio : What position in futures contracts on the S&P 500 is necessary to hedge the portfolio?

How much in total do you have to pay back to the bank : How much in total do you have to pay back to the bank? How much do you owe to the bank at the end of year 10?

Market value of equity immediately after the announcement : will be the firm’s total market value of equity immediately after the announcement? do you expect the stock price to be immediately after the announcement?

Firm currently is an all equity firm with market value : A firm currently is an all equity firm with a market value of $600,000,000. What will the market value of the firm be the moment after this deal is announced?

Each three principal types of financial institutions : Briefly discuss the purpose and role that each three principal types of financial institutions (depositary, contractual, and investment) play in U.S. economy.

What is the change in price to british consumers : What is the change in price to British consumers (assuming all costs are passed down to consumers)

User Account

All Pages