The formulas to be used & the resulting values are shown in the following screenshots:
Resulting values:
So the final cash from the sale will be $543,068.59
Problem 5-21 You have just sold your house for $1,000,000 in cash. Your mortgage was originally...
plz do it through excel, thank you X == General Times New Roman - 14 - AA BIU - OA . Paste Wrap Text Merge & Center - EE $ -% Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment GH Problem 5-21 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 1872 years old,...
Your 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.50 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? (Ignore any real estate transaction costs.) The discount rate is _______ % per month. (Round...
2- 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 $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% (simple rate), how much cash will you have from the sale once you pay off the mortgage?
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 $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.)
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 $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.)...
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 1872 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 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 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 $ 1 comma 000 comma 000$1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $ 700 comma 000$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 6.25 %6.25% (APR), how much cash will you have from the sale once you pay off the mortgage? (Note: Be careful not to...
Your 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 $750,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 7.75% (APR with semi-annual compounding), how much cash will you have from the sale once you pay off the mortgage? a) The discount rate for the mortgage is___? b) Mortgage payments...
Please include cell references. Problem 6-12 Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.74 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the...