Question

In: Finance

You want to buy a house that is sold for $250,000. Given your income, you are...

You want to buy a house that is sold for $250,000. Given your income, you are able tonpay $1,050 monthly mortgage payment per month. You want to borrow a 30-year fixed rate mortgage. The rate is 4.125. How much down payment do you have to make so as to close the transaction? (ignore the closing cost)

Solutions

Expert Solution

Calculation & Formula given below

Answer
Down Payment= Purchase Value - Loan Amount
Down Payment= $250,000- $216651
Down Payment to be made $33,349
Calculation
Loan Amount Calculated Number ( Using Goal SeeK) $216,651 This formula is under Excel>Data > What if Analysis
Interest 4.125%
Repaymnet Mode Monthly
No of Years 30
Interest rate Converted Monthly 4.125%/12 0.344%
Number of months 30*12 360
Year EMI Interest Pricipal Remianing Balance
1 $1,050 $745 $305 $216,346
2 $1,050 $744 $306 $216,040
Up to 360 Months
359 $1,050 $7 $1,043 $1,046
360 $1,050 $4 $1,046 ($0)


Related Solutions

You want to buy a house that worth $250,000. You put done $60,000 down payment and...
You want to buy a house that worth $250,000. You put done $60,000 down payment and borrow the rest from a bank with interest rate 4.5% per year compounded monthly for 15 years. What is you monthly payment to the bank? How much interest you will pay to the bank in 15 years? How much interest you pay in the FIRST year?
You want to buy a new house. Your options are a tradition house for $350,000 and...
You want to buy a new house. Your options are a tradition house for $350,000 and a 3D printed concrete house for $100,000. These houses are built over a plot that increases 5% every year. You want to keep this house for 20 years and make a bit of money at the end. Which house would be the better option if both homes lose 2% of its value, but also increase due to an inflation of 3.22% every year?
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...
4. You want to buy a house valued at $1.2 million. For a house this valuable,...
4. You want to buy a house valued at $1.2 million. For a house this valuable, the lenders demand a down payment of 25% and insist that the monthly payment on the 25 year mortgage loan is no more than 30% of your monthly gross income. The quoted rate on a 25 year fixed rate mortgage loan is 2.94% per year. Assume that you can make the down payment. (a): What is the least amount of your yearly gross income...
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 =...
You want to buy your dream house by borrowing $300,000 for 15 years, with monthly payments....
You want to buy your dream house by borrowing $300,000 for 15 years, with monthly payments. The bank quotes a fixed rate of 5.5%. What is the total interest you paid by the end of the 5th year?
You want to buy a house and will need to borrow $245,000. The interest rate on...
You want to buy a house and will need to borrow $245,000. The interest rate on your loan is 5.77 percent compounded monthly and the loan is for 30 years. What are your monthly mortgage payments?
You are looking to buy your first house. The cost of the house is $325,000. The...
You are looking to buy your first house. The cost of the house is $325,000. The bank has agreed to make a loan to you for 30 years at 3.15% if you can make a down payment of 7.00%, and the loan payments do not exceed 36% of your gross monthly income. Based upon this information: What is the amount of the mortgage loan that the bank will lend to you? What will be the amount of your monthly payments?...
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 $194,000. You plan on making downpayment of 10%....
You want to buy a house that costs $194,000. You plan on making downpayment of 10%. You found a loan with a 5.9% annual rate compounded monthly for 20 years. How much interest is paid over the life of the loan. Round your answer to two decimal places. Do not include the $ sign in your answer.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT