You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price.

You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 4.55%. What will your monthly payments be if you sign up for this mortgage? Create the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan. Form a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan.

Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.95%. What would the monthly payment be for this mortgage? Form a new amortization schedule in a separate Excel sheet. Calculate the total amount of interest paid throughout the life of the loan. How much would you save if you choose the 15-year over the 30-year mortgage

Solutions

Expert Solution

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

You want to buy a house that costs $230,000. You have $23,000 for a down payment,...

You want to buy a house that costs $230,000. You have $23,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $207,000. However, the realtor persuades the seller to take a $207,000 mortgage (called a seller take-back mortgage) at a rate of 8%, provided the loan is paid off in full in 3 years. You expect to inherit $230,000 in 3 years, but right now all you have is $23,000, and...

You are thinking of purchasing a house. The house costs 300000.You have 43000 in cash...

You are thinking of purchasing a house. The house costs 300000. You have 43000 in cash that you can use as a down payment on the house but you need to borrow the rest of the purchase price. The bank is offering a 30yr mortgage that requires annual payments and has an interest rate of 5 percent per year. What will be the annual payment?

You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash...

You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash that you can use as a down payment on the house, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires annual payments and has an interest rate of 7% per year. What will be your annual payment if you sign this mortgage?

You are thinking of purchasing a house. The house costs $250,000. You have $36,000 in cash...

You are thinking of purchasing a house. The house costs $250,000. You have $36,000 in cash that you can use as a down payment on the house, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires annual payments and has an interest rate of 8% per year. What will be your annual payment if you sign this mortgage?

You are thinking of purchasing a house that costs $245,000. You have $13,000 in cash that...

You are thinking of purchasing a house that costs $245,000. You have $13,000 in cash that you can use as a down payment but you need to borrow the rest of the purchase price. The bank is offering a 30 year mortgage that requires monthly payments and has an annual interest rate of 4.35% per year. What will your monthly payments be if you sign up for this mortgage? Draw the amortization schedule on a monthly basis using Excel. Calculate...

You are thinking of purchasing a house that costs $450,000. You have $55,000 in cash that...

You are thinking of purchasing a house that costs $450,000. You have $55,000 in cash that you can use as a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 6.32% per year. What will your monthly payments be if you sign up for this mortgage? Present the amortization schedule (Beginning balance, Monthly payment, Principal payment, Interest payment,...

You borrow $20,000 from your parents to make a house down payment at a mutually agreedupon...

You borrow $20,000 from your parents to make a house down payment at a mutually agreedupon annual interest rate of 5%, and a payback period of 5 years (direct reduction loan). What will be your annual, or monthly, payment amounts?

Part A You are thinking of purchasing a house. The house costs $350,000. You have $50,000...

Part A You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but you need to borrow rest of the purchase price. The bank is offering a 20-year mortgage that requires monthly payments and has an annual interest rate of 5% per year. Determine your monthly payments if you sign up for this mortgage. Draw the amortization schedule, monthly, using Excel. Calculate the...

You have $20,000. You plan on purchasing a house in one year, but you will need...

You have $20,000. You plan on purchasing a house in one year, but you will need to have $22,500 for the downpayment. Which of the following is a good investment opportunity to ensure you have the money necessary to make your downpayment in a year? A portfolio with an expected return of $24,000 and a standard deviation of 10%. A portfolio with an expected return of $30,000 and a standard deviation of 15%. All of these options would be a...

if you are buying a house valued at $210,000 with 10% down payment. You will borrow...

if you are buying a house valued at $210,000 with 10% down payment. You will borrow the remaininf 90% of the purchase prices at 6% APR and the loan will be paid off in 30 years, how much do you still owe two months from now?

Subjects