Question
In: Finance
You are ready to buy a house and you have $50,000 for a down payment and...
- You are ready to buy a house and you have $50,000 for a down
payment and closing costs. Closing costs are estimated to be 2.5%
of the loan value. You have an annual salary of
$200,000. The bank is willing to allow your housing costs –
mortgage, property tax and homeowners insurance to be equal to 28%
of your monthly income. You have estimated that property tax will
be $1,000/month and homeowner’s insurance will be $100/month. The
interest rate on the loan is 3.4% per year with monthly compounding
for a 30-year fixed rate loan.
- How much money will the bank loan you?
- How much can you offer for the house?
- Create a loan amortization table in Excel and submit the spreadsheet. This should be done with monthly payments.
Solutions
Expert Solution
Maximum permissible monthly payments= $3,566.67 as follows:
Maximum permissible monthly payments= $3,566.67 as follows:
Loan given by the Bank= $804,242.98
Amount offered for the house= $834,136.90
Details of calculation and amortization schedule (with initial and closing entries) are given below:
Details of calculation:
Amortization schedule below:
jeff jeffy answered 2 years agoRelated Solutions
You are ready to buy a house and you have $50,000 for a down payment and...
You are ready to buy a house and you have $50,000 for a down
payment and closing costs. Closing costs are estimated to be 2.5%
of the loan value. You have an annual salary of
$200,000. The bank is willing to allow your housing costs –
mortgage, property tax and homeowners insurance to be equal to 28%
of your monthly income. You have estimated that property tax will
be $1,000/month and homeowner’s insurance will be $100/month. The
interest rate on...
You are ready to buy a house and you have $50,000 for a down payment and...
You are ready to buy a house and you have $50,000 for a down
payment and closing costs. Closing costs are estimated to be 2.5%
of the loan value. You have an annual salary of
$200,000. The bank is willing to allow your housing costs –
mortgage, property tax and homeowners insurance to be equal to 28%
of your monthly income. You have estimated that property tax will
be $1,000/month and homeowner’s insurance will be $100/month. The
interest rate on...
You are ready to buy a house, and you have $25,000 for a down payment and...
You are ready to buy a house, and you have $25,000 for a down
payment and closing costs. Closing costs are estimated to be 4% of
the loan value. You have an annual salary of $48,000 (monthly
income $4000) , and the bank is willing to allow your monthly
mortgage payment to be equal to 25% of your monthly income. The
interest rate on the loan is 7.2% per year with monthly compounding
(.6% per month) for a 30-year fixed...
Imagine you have $50,000 for a house down payment for a $250,000 home. What are the...
Imagine you have $50,000 for a house down payment for a $250,000
home. What are the monthly payments on a 30-year, fixed-rate
mortgage of $200,000 assuming your mortgage carries a 5% interest
rate. If you pay off the mortgage after thirty years, how much will
you have paid in interest beyond the price of the house itself?
Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000....
Ann would like to buy a house.
It costs $2,500,000.
Her down payment will be $50,000.
She will take out a mortgage for the remainder.
It will be a 30 year, fully amortizing, FRM, with constant
monthly payments and monthly compounding.
The annual interest rate is 4.50%.
She will pay $5,000 in closing costs at origination.
She will also pay 1.75% of the balance in buy-down points at
origination.
Note: the home is bought and the loan is taken in...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- java programing project Implement a program that computes the Fibonacci of a specified number, the factorial...
- Team Case #3: Rural Utility Your consulting team has been brought in by the Board chairperson...
- I have a question pertaining to ruby on rails. I was wondering if there is a...
- For the past two years, the United States has imposed tariffs (tax) on imports from China....
- Module 2 Course Work 1. Read Pages 12-30. 2. Use the week 1 video's and this...
- 6. Solve the following recurrence relations t(n) = t(n-1) + 3 for n>1 t(1) = 0...
- In C programming using C11 library, how can we validate command line arguments? meaning for example...
ADVERTISEMENT