You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?  plesae show steps in excel

Q: Suppose you take out a 30 year mortgage for $ 200000 at 8.5% interest. The monthly payments on this…

A: Here,

Q: You have just sold your house for $ 1 comma 100 comma 000 in cash. Your mortgage was originally a…

A: The objective of this question is to find out how much cash will be left after paying off the…

Q: a) How much is the loan amount going to be? b) What will your monthly payments be? c) How much…

A: Loan payments can be paid off in periodic payments. To understand the periodic payments the loan…

Q: You want to buy a house, and a local bank will lend you $100,000. The loan will be fully amortized…

A: Monthly loan payment: It is the amount of money that is given to the lender by the borrower on the…

Q: You buy a house for $328,000, make a $33,000 down payment, and take out at 15-year mortgage at an…

A: “Since you have posted a question with multiple sub-parts, we will solve the first three sub- parts…

Q: offer 30-year mortgage that requires annual payments and has an interest rate of 5% per year. What…

A: Mortgage amount are paid by monthly payment or annual payment these are fixed periodic instalments…

Q: You want to buy a $240,000 home. You plan to pay 20% as a down payment, and take out a 30 year loan…

A: Home value = $240,000 Down payment = $48,000 (i.e. $240,000 * 0.20) Monthly period (n) = 360 (i.e.…

Q: You have a 30-Year mortgage loan for $300,000 with an interest rate of 6%  If you want to pay off…

A: Mortgage refers to the loan availed against the purchase of the real estate. Mortgage repayment…

Q: You want to buy a $253,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: Mortgage loans are secured loans that are paid by equal fixed monthly payments that carry the…

Q: You buy a house for $230000, and take out a 30-year mortgage at 6% interest. For simplicity, assume…

A: Mortgage refers to borrowing an amount for the purchase of an asset and in return borrowed amount is…

Q: You are looking to invest in a real-estate property to rent out that will cost $100,000. The…

A: Net present value is the difference between the present value of cash flow and initial investment…

Q: You decide to purchase a house for $260,000. You have saved money so you are able to do a down…

A: A loan/mortgage indicates any sum borrowed to meet specific funding needs. The funding requirements…

Q: Suppose you are buying your first condo for $280,000, and you will make a $15,000 down payment. You…

A: The objective of this question is to calculate the monthly mortgage payment for a condo purchase.…

Q: Suppose you take out a 30-year mortgage for $ 275000 at 8.5% interest. The monthly payments on this…

A: A written agreement through which a lender gets the right to take the property that is put as a…

Q: u buy a house of $500,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of…

A: Mortgage loans are taken in the purchase of home and they are paid by equal monthly installments…

Q: The discount rate is _ % per month. (Round to five decimal places.) The monthly mortgage payment is…

A: A mortgage payment is a regular commitment that a borrower makes to a lender in order to pay back a…

Q: Suppose you found your dream house and you intend to buy it with a $197,705, 16-year, 5% APR…

A: Loan Balance at the End of Year 2Here's how to calculate the loan balance at the end of the year 2…

Q: You found your dream house. It will cost you $300000 and you will put down $40000 as a down payment.…

A: Houses are a large ticket item. We do not have the cash to buy a house outright on a cash basis.…

Q: Suppose you are buying your first home for $144,000, and you have $17,000 for your down payment. You…

A: purchasing price = $144,000 down payment = $17,000 loan amount = $144,000 - 17,000…

Q: Suppose you want to buy a $141,000 home. You found a bank that offers a 30-year loan at 3.7% APR.…

A: Given Information:Amount is $141,000 Number of years is 30 APR is 3.7%

Q: Suppose you found a CD that pays 2.9% interest compounded monthly for 5 years. If you deposit…

A: 1) FV = PV * (1 + r / m)m*n FV = future value PV = present value = $12,000 r = rate of interest =…

Q: Suppose you take out a 30 year mortgage for $ 200000 at 7.75% interest. The monthly payments on this…

A: Time period with the new monthly payments and given loan amount and interest rate is calculated by…

Q: Mr Ridge range for a mortgage loan for 65% of the 2.5 million purchase price of a home. The monthly…

A: Loan amount = 65% of purchase price of a home = 0.65×2500000 = 1,625,000 Number of monthly payment…

Q: A house costs $185,000. You take out a mortgage loan and put 20 percent down on the house. The…

A: Loans are paid in equal monthly installments that carry the payment of interest and loan payments.

Q: You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of…

A: You bought a house for $450,000 with a $90,000 down payment and a $360,000 mortgage at 4% for 15…

Q: Let’s assume that you plan to purchase a house which is selling for $350,000 today. You will make a…

A: Formulas that are used:-

Q: You just opened a brokerage account, depositing $4,500. You expect the account to earn an interest…

A:

Q: You can afford a $1300 per month mortgage payment. You've found a 30 year loan at 6% interest. a)…

A: Monthly payment "PMT" = $1300 Number of years = 30 Number of months "NPER" = 30*12 = 360 Annual rate…

Q: You buy a house for $230000, and take out a 30-year mortgage at 6% interest. For simplicity, assume…

A: Given, Loan amount = $230,000 years =30 rate = 6%