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
- This is all one question, thank you so much in advance! You must evaluate the purchase...
- 10. Consider a market in which there is a monopoly manufacturer and a mo nopoly retailer....
- Write a function fun(x) that takes as input a positive number x and solves the following...
- Describe the principles and operations of movement sensors: Doppler-Effect Velocity sensor and Spring-Mass Accelerometor; State the...
- This is all one question, thank you so much in advance. The Bigbee Bottling Company is...
- For Questions 1-3: consider the following code: public class A { private int number; protected String...
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
ADVERTISEMENT