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 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.

A. What is your monthly payment?

B. Amortize the first and second payments.

C. What is the mortgage balance after 5 years?

D. What percentage of the principal is paid off after 5 years?

E. 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?

F. 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!

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) You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a...

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...

THE ANSWER IS C. JUSTNEED STEP BY STEP SOLUTION. At 25C, the Ka of the hydrogen carbonate ion HCO3 is 4.8 x 10-1 and the Ka of the hydrogen sulfite ion HSO3 is 6.2 x 10-8. Based on this information,...

Manuela stop dividing at this point? If so, why? What are all the factors of 90?

Explain each of the "dont cares" in COD Figure 4 . 1 8 ( The setting of the control lines... )

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

3. What interview questions can help to reveal the accuracy of a candidates CV?

1. Why do people tell lies on their CVs?

2. What is the difference between an embellishment and a lie?