Help with Part C. please.You want to buy a house that costs $140,000. You have...

Help with Part C. please.

You want to buy a house that costs $140,000. You have $14,000 for a down payment, but your credit is such that mort- gage companies will not lend you the required $126,000. However, the realtor persuades the seller to take a $126,000 mortgage (called a seller take-back mortgage) at a rate of 5%, provided the loan is paid off in full in 3 years. You expect to inherit $140,000 in 3 years, but right now all you have is $14,000, and you can afford to make payments of no more than $22,000 per year given your salary. (The loan would call for monthly payments, but assume end-of-year annual payments to simplify things.)

a. If the loan was amortized over 3 years, how large would each annual payment be?
Could you afford those payments?
b. If the loan was amortized over 30 years, what would each payment be? Could you afford those payments?
c. To satisfy the seller, the 30-year mortgage loan would be written as a balloon note, which means that at the end of the third year, you would have to make the regular payment plus the remaining balance on the loan. What would the loan balance be at the end of Year 3, and what would the balloon payment be?

Solutions

Expert Solution

Formulas used:-

Annual payment=PMT(B192,B191,-B190)
Loan Value at Year 3=FV(B192,3,B194,-B190)
Total amount paid At Year3=B196+B194

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Case Study for Financial Management. Case 1 You want to buy a house that costs $140,000....

Case Study for Financial Management. Case 1 You want to buy a house that costs $140,000. You have $14,000 for a down payment, but your credit is such that mort- gage companies will not lend you the required $126,000. However, the realtor persuades the seller to take a $126,000 mortgage (called a seller take-back mortgage) at a rate of 5%, provided the loan is paid off in full in 3 years. You expect to inherit $140,000 in 3 years, but...

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...

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

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

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

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

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

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

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 want to buy a house that costs $100,000. You have $10,000 for a down payment,...

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

You want to buy a house in Whittier CA that costs $1,067,000. You have a down...

You want to buy a house in Whittier CA that costs $1,067,000. You have a down payment equal to 23% of that price, and you have found a bank that will loan you the remainder (ignore closing costs, property taxes, etc..). The interest rate on this mortgage is 4.75% p.a. with monthly compounding (APR), this rate is fixed for 30 years, and payments on the loan are made monthly (in arrears, as with most mortgages). Assume that you will take...

Youu want to buy a house that costs $150,000. You have $15,000 for a down payment,...

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

You want to buy a house. You have found the house you like and have agreed...

You want to buy a house. You have found the house you like and have agreed to purchase the house for $300,000. You go to the bank to get a loan and have decided that a 30 year mortgage loan is the best loan duration. What do you think the interst rate will be on your loan given the following data? "Real" interest rate given current macro econmomic conditions = 2.0% The inflation rate forecasted for the future is =...

Subjects