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?
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...
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?
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)
Ann obtains a $150,000, 20-year mortgage with a bank at 9% p.a., compounded monthly. a. What...
Ann obtains a $150,000, 20-year mortgage with a bank at 9% p.a., compounded monthly. a. What is her monthly repayment? b. Suppose that after 5 years, Ann plans to repay the loan by making an additional payment each month along with her regular payment. How much must Ann pay each month if she wishes to pay off the loan in 10 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT