If you want to purchase a home. You have $10,000 to put down. All you can...

If you want to purchase a home. You have $10,000 to put down. All you can afford is $1000.00 per month and you do not want to finance for more than 15 years @ 5%, (your taxes will be $55.00 per month and insurance $60.00 a month), what is the amount you can pay for the house? (Show all your work)

Solutions

Expert Solution

Monthly maximum mortgage payment on loan = 1000 - 55 - 60 = 885

Present value of loan payments is equal to loan amount:

a	Present value of annuity=	P* [ [1- (1+r)-n ]/r ]

P=	Periodic payment	885.00
r=	Rate of interest per period
	Annual interest	5.00%
	Number of payments per year	12
	Interest rate per period	0.05/12=
	Interest rate per period	0.417%

n=	number of periods:
	Number of years	15
	Periods per year	12
	number of payments	180

	Present value of annuity=	885* [ (1- (1+0.00417)^-180)/0.00417 ]
	Loan amount	111,912.89
	Plus down payment	10,000.00
	Maximum home purchase	121,912.89

Answer is 121,912.89

please rate.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You put 20% down on a home with a purchase price of $250,000. The down payment...

You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. A bank will loan you this remaining balance at 3.91% APR. You will make monthly end-of-the-period payments with a 30-year payment schedule. What is the monthly annuity payment under this schedule?

I. Suppose an apartment you want to purchase costs $500,000. You can put down 20% in...

I. Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. a. Suppose the loan calls for equal monthly payments. Please set up a monthly amortization schedule table for the loan (Input setting: 20%, creating and copying formulas and Excel finance functions: 40%)....

Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash...

Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. Suppose the loan calls for equal monthly payments. Set up a monthly amortization schedule table for the loan (Input: 20%, creating and copying formulas and Excel finance functions: 30%). What is the sum...

Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash...

Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. Suppose the loan calls for equal monthly payments. 1. Set up a monthly amortization schedule table for the loan (Input: 20%, creating and copying formulas and Excel finance functions: 30%). Use 360 months...

Suppose that you want to purchase a home for $220,000 using a down payment as described...

Suppose that you want to purchase a home for $220,000 using a down payment as described below and you finance the rest of the purchase by taking out a 15-year mortgage at 4.5% interest compounded monthly. The amount of the down payment is $56,083. Construct an amortization table for the entire length of the loan making sure to include columns for the payment number, the amount of the payment, the amount of each payment that goes towards the principal, the amount...

Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take...

Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take a loan from the bank for the remaining amount. The bank has offered you a 30-year loan with a 4.5% APR (compounded monthly). Calculate the total interest paid to the bank in the 2nd year of the loan. (Round to 2 decimals)

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 $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 have saved $10,000 for a down payment on the purchase of a new car, however,...

You have saved $10,000 for a down payment on the purchase of a new car, however, since you plan to buy the car one year from today, you need to decide how to invest the money for one year. You are limited to one of two choices: 1. A Bond Fund with an expected return of 3%/year 2. A Stock Fund with an expected return of 7%/year. Which fund is best? Explain why!

You have $10,000 now. You want to purchase a car that costs $14,000. Current available interest...

You have $10,000 now. You want to purchase a car that costs $14,000. Current available interest rate is 5% annually. Considering that the price of the car remains the same, how much time will it take you to be able to purchase the car?

Subjects