Question

In: Finance

Suppose that the house of your dreams costs $1,200,000. You manage to scrap a 20 percent...

Suppose that the house of your dreams costs $1,200,000. You manage to scrap a 20 percent down payment. You borrow the rest from a bank. The terms of the loan are:

-30 years

-4.5 percent

-Monthly payments

A) Find the amount of each monthly payment.

B) Suppose you decide to sell the house after 12 years:

-What is the loan balance at the end of 12 years?

-What is the amount of your total payments over the 12 years?

-What is the amount of your total principal payments over the 12 years?

-What is the amount of your total interest payments over the 12 years?

C) Use Excel to set up an amortization table.

Solutions

Expert Solution

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

You just found the house of your dreams. The price of the house is ​$400,000. You...
You just found the house of your dreams. The price of the house is ​$400,000. You have been qualified to get a mortagage loan with AAA Bank. The mortgage loan is for 30 years at an annual interest rate of 36​%. Part​ (A): How much are your monthly payments for the​ loan? Part​ (B): What is the balance of the mortgage loan after2 ​year(s) of​ payments? Part​ (C): After 2 years of​ payments, you want to add extra money to...
You just found the house of your dreams. The price of the house is ​$500,000. You...
You just found the house of your dreams. The price of the house is ​$500,000. You have been qualified to get a mortgage loan with AAA Bank. The mortgage loan is for 30 years at an annual interest rate of 36%. Part​ (A): How much are your monthly payments for the​ loan? Part​ (B): What is the balance of the mortgage loan after 2 ​year(s) of​ payments? Part​ (C): After 2 years of​ payments, you want to add extra money...
You just found the house of your dreams. The price of the house is ​$500,000. You...
You just found the house of your dreams. The price of the house is ​$500,000. You have been qualified to get a mortagage loan with AAA Bank. The mortgage loan is for 20 years at an annual interest rate of 24​%. A. How much are your monthly payments for the​ loan? B.What is the balance of the mortgage loan after 2 ​year(s) of​ payments? C. After 2 years of​ payments, you want to add extra money to the monthly payments...
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following:...
Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following: The annual interest rate on the mortgage is 5%. The bank requires a minimum down payment of 10% at the time of the loan. The annual property tax is 2% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $566 per month. If...
Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following:...
Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 11% at the time of the loan. The annual property tax is 2.5% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $87 Your other long-term debts require payments of $624 per month. If...
Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following:...
Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 19% at the time of the loan. The annual property tax is 2.1% of the cost of the house. The annual homeowner's insurance is 0.6% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $555 per month. If...
Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following:...
Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following: The annual interest rate on the mortgage is 4%. The bank requires a minimum down payment of 18% at the time of the loan. The annual property tax is 1.6% of the cost of the house. The annual homeowner's insurance is 0.7% of the cost of the house. The monthly PMI is $70 Your other long-term debts require payments of $937 per month. If...
Suppose that you decided to buy a new house. The house you want to buy costs...
Suppose that you decided to buy a new house. The house you want to buy costs $520,000 and the interest rate is 7%. You currently have $130,000 and are required to put a 20% down payment plus an additional 3% of the loan amount as closing costs. 1) When will you have enough money for the down payment and closing costs, assuming that the $80,000 is the only investment that you make? 2) Suppose that you plan to buy the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT