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: 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: Give typing answer with explanation and conclusion Paying 13 mortgage payments instead of 12 per…

A: > Given data:> Amount of mortgage = $ 175000> Interest rate= 6%/12 = 0.5% per month>…

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: 1)You have taken out a loan of 3,000,000 to buy an apartment. The loan is an annuity loan of 30…

A: The loan is a facility provided by financial institution to buy an asset and repay it in future in…

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: ou want to buy a $224,000 home. You plan to pay 15% as a down payment, and take out a 20 year loan…

A: Monthly payments on an amortized loan refer to a fixed amount of money that a borrower pays each…

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

A: Monthly payment (P) = $1300 Period = 30 Years Number of monthly paymenst (n) = 30*12 = 360 Interest…

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: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 5.14% interest. Suppose…

A: Present value of annuity.PV = A × Where,PV = present value of annuity A = periodic payments r =…

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

A: Purchase Price of House= 300,000  Down payment = 45,000  Loan Amount = Purchase Price - Down payment…

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 want to buy a $189,000 home. You plan to pay 15% as a down payment, and take out a 30 year loan…

A: Home value = $189,000Down payment = 0.15 (15%)Monthly interest rate (r) = 0.003291666667 (0.0395 /…

Q: You are a loan officer trying to structure a 5/25 ARM mortgage. The interest rate in the first 5…

A: A mortgage refers to a loan used for the purchase of real estate. The loan is covered by the real…

Q: ou just borrowed $490,000 for a mortgage on your new home. The mortgage has a 30​-year term with…

A: Mortgage loans make home buying home easy because paid by easy monthly payments that carry payment…

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

A: Loan Payments: These are payments comprising interest & principal amounts. Such payments are…

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: 6. You purchase a house for $250,000 by getting a mortgage for $200,000 and paying a $50,000 down…

A: Monthly Mortgage Payments Monthly mortgage payment is the repayment of a mortgage loan by paying…

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

A: Cost of home = $169,000Down payment = 20%Interest rate = 4.85%Number of years = 30 years

Q: 6) You buy a $400,000 house. The loan is for 25 years and is at 4.5% monthly. What is the monthly…

A: Loan is a contract between lender & borrower where lender provides funds to borrower for…

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: Suppose you purchased a house 7 years ago and took out a mortgage for $400,000 with a 5.6% interest…

A: Here,

Q: Solve the problem with complete solution. 10. You purchase a house and lot for 1,850,000 and obtain…

A: The equivalent cost is the periodic payment made towards the acquisition of an asset or security for…

Q: Suppose you are planning to buy a house with a $223,420, 24-year, 9% 6/1 Hybrid loan, where interest…

A: The objective of the question is to calculate the monthly payment for a 6/1 Hybrid loan after the…

Q: Suppose you want to purchase a $ 210000 house. If you put 20% down and finance the rest in a 15 year…

A: Mortgage is a loan contact used to buy capital assets such as houses. In Mortgages, title of asset…

Q: You want to buy a $220000 home with a down payment of  $66000  and take out a 30 year loan at 3.75%…

A: A mortgage refers to a covered loan that is borrowed for purchasing a property with the property…

Q: You found your dream home, and your bid has been accepted. The house costs $250,000; you put down…

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

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: Please make an excel spreadsheet and show the formulas in the cells for the problem below and please…

A: To calculate how much money you will make in book after 3 years, we need to break down the…

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

A: The question is calculation of amortization of mortgage loan at fixed monthly repayments. Formula…

Q: You take out a mortgage to buy a house worth $648,000. The down payment is 29%, the annual interest…

A: Present value of annuity formula.PV = A* wherePV = Present value of annuityA= periodic paymentsr =…

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: A real estate property is on the market.  You have estimated it will give you net cash flows of…

A: The concept of time value of money states that the money received today is worth more than that the…

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%

Q: Suppose you save $4,000 per year at the beginning  of each year for 3 years and earn 5% interest per…

A: The formula for the calculation of future value of annuity due is as follows: Future value of…

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

A: Cost of house is $202,000 Down payment is 20% Time period is  30 years Interest rate is 5.5% To…

Q: Suppose you want to purchase a home for $375,000 with a 30-year mortgage at 5.14% interest. Suppose…

A: When the lender lends a loan to the borrower, he charges a rate of interest on the borrowed amount.…