You want to purchase a condo in downtown boston for 1200000, Ask an Expert

Finance

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?

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92663721

Have any Question?Write your Review or question?

Related Questions in Financial Management

Reflection papernbsp instructionsas you continue on your

Reflection Paper : Instructions As you continue on your quest for academic success, it is important to share your knowledge with others. In fact, you have been asked to provide advice to future students on academic inte ...

Exercise benefits us in so many ways including improving

Exercise benefits us in so many ways, including: improving our physical and mental health; reducing our risk of cardiovascular disease; increasing our energy, stamina, strength, and agility; promoting better sleep; impro ...

Topic dash dietthere are many different diets weight loss

Topic: DASH DIET There are many different diets, weight loss treatments, and medications that proclaim to be the panacea for weight loss. For this discussion forum, you will be researching a diet or treatment approach fo ...

Answer each question in 75 words a piece use references if

Answer EACH question in 75 words A PIECE. Use references, if needed and cite. 1. Embark on a virtual field trip. Researching online, explore different career fields that interest you. Share with your classmates which car ...

Introductionthroughout this course the focus has been on

Introduction Throughout this course, the focus has been on the problem-solving model and learning how to complete the steps. In addition, you learned how to utilize analysis tools to help you with some of the problem-sol ...

Use the internet to locate information regarding a

Use the Internet to locate information regarding a negotiation from the past 6 months that you would consider to be integrative in nature. Examine the differences between distributive and integrative negotiation. Determi ...

Discussionbull profits and risks of off-balance-sheet

Discussion • Profits and Risks of Off-Balance-Sheet Activities • The difference between spot and forward exchange rates. What role do currency swaps play? • The Federal Open Market Committee • Multiple Deposit Creation a ...

Topics to choose frombullfailure of the Topics to choose from • Failure of the

Topics to choose from • Failure of the Originate-to-Distribute Model and the Financial Crisis of 2007-8 • Monoline Insurers and the Subprime Financial Crisis and Problems with Rating Agencies • The Liquidity Crisis and t ...

Assignment -complete a research topic and prepare a

Assignment - Complete a research topic and prepare a write-up, and a presentation. SECTION A: Financial Analysis and Pricing Select a portfolio of five firms from the industry of your choice. Please then see me for appro ...

Part aweek 1in order to properly implement a strategic plan

Part A Week 1: In order to properly implement a strategic plan, organizations use structure, various control systems (budgets, variance analysis, policies and procedures, company rules), and culture. Let us revisit Gener ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert