Question: Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You

Question 1 (mortgage problem) (Try to work this question WITHOUT using

Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI insurance. 1. What is your monthly payment? 2. Amortize the first and second payments. 3. What is the mortgage balance after 5 years? 4. What percentage of the principal is paid off after 5 years? 5. Suppose after 5 years you refinance at 6% the remaining balance at a cost of $10,000, for 30 years. What is your new monthly payment? 6. Further, suppose you maintain the same payments as in (1), i.e. pre-pay on the principal, how many YEARS until you payoff the mortgage

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Advanced Time Value of Money Problems Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a...

Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI...

Advanced Time Value of Money Problems Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel,Please get the calculation in detail.) You purchase a house that costs $625,000 with...

*work this question WITHOUT using Excel* You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI insurance. 1)What is your monthly payment? 2)...

Question 1 (mortgage problem) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI insurance. What is your monthly payment? Amortize the...

Question 1 (mortgage problem) (Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with a 8%, 30-year mortgage. In order to avoid PMI insurance, you decide to...

Question 1 (mortgage problem)(Try to work this question WITHOUT using Excel) You purchase a house that costs $625,000 with a 8%, 30-year mortgage. In order to avoid PMI insurance, you decide to...

answer this question by using excel You purchase a house that costs $625,000 with a 8%, 30-year mortgage. In order to avoid PMI insurance, you decide to follow a conforming mortgage by making a down...

really just need help with part 2 and the part 3 on this. Part 1: Mortgage A mortgage is a loan used to purchase a home. It is usually paid back over a period of 15, 20, or 30 years. The interest...

I need some assistance. Please review the attached pdf file. I Need These Assignments Completed in an Excel (xls) file. Please show all your work and be accurate. I will tip you for doing a good job...

On December 31, 2013, Pantech Company invests $20,000 in softplus, a variable interest entity. In contractual agreements completed on that date, Pantech established itself as the primary beneficiary...

The steel bar shown below is 8 ft in length with a square cross- section, 4 inches sides, and is subjected to an axial tensile force of 300 Kips. Find the axial stress acting on the bar. 300 Kips 300...

There are several reasons why Andy probably cannot get an MLO license, identify at least two of them.

A grocery store is MOST likely which of the following layout types? O circular O product O hybrid O fixed position O inverted

List four examples of feedback you can give to a speaker that would indicate you understand his or her message. (Objective 4)

Teamwork. Conduct the following exercise with teams of five people. The instructor will read a factual story (from a newspaper, magazine, or other source) to one member of each team. That person will...

Good listeners can be described as patient and sincere; bad listeners can be described as self-centered and intolerant. What other words describe good listeners? bad listeners? List at least three...