Question

In: Finance

You have just sold your house for $1,050,000 in cash. Your mortgage was originally a​ 30-year...

You have just sold your house for $1,050,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $700,000. The mortgage is currently exactly 18.5 years​ old, and you have just made a payment. If the interest rate on the mortgage is 5.25% ​(APR with​ semi-annual compounding), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)

a.  Compute the discount rate for the mortgage. (4 decimals)

b.  Compute the mortgage payments. (4 decimals)

c.  Compute the remaining balance on the mortgage. (4 demicals)

d.  Find the cash from the sale once the mortgage has been paid off. (4 demicals)

Solutions

Expert Solution

Part (a):

Discount rate of the mortgage: APR of 5.25% compounded semi annually is equal to monthly rate of 0.4328% as follows:

Part (b):

Monthly mortgage payment= $ 3,840.9583 as follows:

Part (c):

Remaining balance in the mortgage after 18.5 years is the PV of remaining installments

= $ 398453.1185 as follows:

Part (d):

Sale value= $1,050,000

Cash from sale after paying off the mortgage= $1,050,000-$398453.118480 = $651,546.8815


Related Solutions

You have just sold your house for$1,000,000 in cash. Your mortgage was originally a​ 30-year mortgage...
You have just sold your house for$1,000,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of$800,000.The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 5.25% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) Cash that remains...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and had an initial balance of $800,000. The mortgage is currently exactly 18.5 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% p.a. (with monthly compounding), how much cash will you have from the sale once you pay off the mortgage? (Round to the nearest dollar). a. $540.661 b. $459,340 c....
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 6.25% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $700,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 7.75% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)
You have just sold your house for $900,000 in cash. Your mortgage was originally a? 30-year...
You have just sold your house for $900,000 in cash. Your mortgage was originally a? 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly? 18½ years? old, and you have just made a payment. If the interest rate on the mortgage is 5.25% ?(APR), how much cash will you have from the sale once you pay off the? mortgage? ?
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $750,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 7.75% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and had an initial balance of $800,000. The mortgage is currently exactly 18.5 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% p.a. (with monthly compounding), how much cash will you have from the sale once you pay off the mortgage? (Round to the nearest dollar). a. $456,931 b. $626,635 c....
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 18½ years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage?
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 18½ years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Complete the steps below using cell references to given data or previous calculations. In...
You have just sold your house for $ 1,100,000 in cash. Your mortgage was originally a?...
You have just sold your house for $ 1,100,000 in cash. Your mortgage was originally a? 30-year mortgage with monthly payments and an initial balance of $ 750,000. The mortgage is currently exactly? 18½ years? old, and you have just made a payment. If the interest rate on the mortgage is 6.25 % ?(APR), how much cash will you have from the sale once you pay off the? mortgage? 1.Cash that remains after payoff of mortgage is ?$_____ (Round to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT