Question

In: Finance

Let’s say that we have a 20-year mortgage with an original loan balance of $150,000 at...

Let’s say that we have a 20-year mortgage with an original loan balance of $150,000 at 7% interest per year. How much money (i.e., balance) do you still owe after the 7th year of the loan? (The loan is compounded monthly)

.

1. $129,385

2.

Cannot be determined

3.

$118,902

4.

$133,722

Solutions

Expert Solution

Step 1 : Calculation of monthly payment
EMI = [P x R x (1+R)^N]/[(1+R)^N-1]
Where,
EMI= Equal Monthly Payment
P= Loan Amount
R= Interest rate per period   =7%/12 =0.5833333%
N= Number of periods =20*12 =240
= [ $150000x0.0058333333 x (1+0.0058333333)^240]/[(1+0.0058333333)^240 -1]
= [ $874.999995( 1.0058333333 )^240] / [(1.0058333333 )^240 -1
=$1162.95
Step 2 : Calculation of loan balance after 7 years payment
Present Value Of An Annuity
= C*[1-(1+i)^-n]/i]
Where,
C= Cash Flow per period
i = interest rate per period =7%/12 =0.583333%
n=number of period =(20-7) *12 = 156
= $1162.95[ 1-(1+0.00583333)^-156 /0.00583333]
= $1162.95[ 1-(1.00583333)^-156 /0.00583333]
= $1162.95[ (0.5964) ] /0.00583333
= $1,18,902.06
\ Correct Answer = $118902
NOTE: ASK YOUR QUERIES.PLEASE DO UPVOTE

Related Solutions

Suppose John takes a 15 year mortgage loan of $150,000 at 4.8% (12). a. What is...
Suppose John takes a 15 year mortgage loan of $150,000 at 4.8% (12). a. What is the monthly payment? b. If he wants to pay off the loan after 10 years, (i.e., on the 120th payment), what is the payoff amount?
Loan 3: 15-year versus 30-year mortgage Amortize a mortgage for a $225,000 house with a 20%...
Loan 3: 15-year versus 30-year mortgage Amortize a mortgage for a $225,000 house with a 20% down payment for both a 15-year mortgage at 3.625% and a 30-year mortgage at 4.125%. 15-year mortgage monthly payment? What is the total interest cost over the life of the 15-year loan? 30-year mortgage monthly payment? What is the total interest cost over the life of the 30-year loan? Difference in interest costs between a 15-year and a 30-year mortgage?
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
Common information for problems 4 and 5 A 20-year loan of 150,000 is negotiated with the...
Common information for problems 4 and 5 A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
Let’s say that a seller has a house she wants to sell for $150,000. She asks...
Let’s say that a seller has a house she wants to sell for $150,000. She asks the real estate agent to list it for sale at $160,000, but tells the agent not to entertain any bid below $140,000. An interested buyer, who can afford a mortgage at current rates if the total price is below $145,000 (his limit), looks at the house and likes it enough to put in an offer of $138,000. This situation could be characterized as: Group...
For a 20 year mortgage of $150,000 at 7.5% interest, one additional payment $5000is pai in...
For a 20 year mortgage of $150,000 at 7.5% interest, one additional payment $5000is pai in mortgage after 2 years of making regular payments. How many monthly payments will be eliminated from the amortization becasue of this additional payments?
Let’s say you have an unfair six-sided die that lands on 2 exactly 20% of the...
Let’s say you have an unfair six-sided die that lands on 2 exactly 20% of the time. If you roll this “loaded” die 5 times, what are the odds that you: (a) never roll a 2, (b) roll a 2 two times, or (c) roll a 2 more than two times? (use excel and show functions)
Consider a 4-year, adjustable rate mortgage with an original balance of 15,000 and an initial interest...
Consider a 4-year, adjustable rate mortgage with an original balance of 15,000 and an initial interest rate of 5.9%. Suppose right after the month 6 payment has been made, the interest rate goes up by 0.8%. What is the new monthly payment in the following month?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT