Question

Lynn bought a $300,000 house, paying 10% down, and financing the
rest at 6.5% interest for 30 years.

a. What are the monthly payments?

b. How much interest will she pay over the life of the loan?

c. What percentage of your total payment was the interest?

((Can the work be done in excel? Please?))

Answer #1

Yes, the work can be done in excel. The following formulae would help.

Price of the house = $300,000

Down payment = 10%

Loan amount (PV) = 300,000*(1-10%) = $ 270,000

Rate = 6.5%/12

Number of years (nper) = 30*12 = 360 periods

a)

**Monthly payments (PMT) = = $
1,706.58**

b)

**Interest paid over the life of the loan =
**

**= 344,370.12**

c)

Total payments over the period = $ 1,706.58 * 360 =$ 614,370.12

**% interest paid over the total payments
= (344,370.12/ 614,370.12) = 56.05%**

suppose that 10 years ago you bought a home for $140,000, paying
10% as a down payment, and financing the rest at 9% interest for 30
years.
a. how much money did you pay as your down payment?
b. how much money was your existing mortgage loan for?
c. what is your current monthly payment on your existing
mortgage?
d. how much total interest will you pay over the life of the
existing loan?

Suppose that 10 years ago you bought a home for $120,000, paying
10% as a down payment, and financing the rest at 7% interest for 30
years.
This year (10 years after you first took out the loan), you check
your loan balance. Only part of your payments have been going to
pay down the loan; the rest has been going towards interest. You
see that you still have $92,678 left to pay on your loan. Your
house is now...

A house that was bought 8 years ago for $150,000 is now worth
$300,000. Originally,the house was purchased by paying 20% down
with the rest financed through a 25-year mortage at 10.5%. The
owner (after making 96 equal monthly payments) is in need of cash,
and would like to refinance the house. The finance company is
willing to loan 80% of the new value of the house amortized over 25
years with the same interest rate. How much cash will...

suppose that 10
years ago you bought a home for 120,000, paying 10% as a down
payment, and financing the rest at 9% interest for 30 years.
this year (10 years after you first took at the loan) you
check your loan balance. only part of your payments have been going
to pay fown the loan; the rest has been going towards interest. you
see that you still have 96,584 left to pay on your loan. your house
is now...

3. Your aunt bought a house for $300,000 and put 20% as down
payment. Six years later, she sells the house for $400,000. In
between, she paid off $20,000 of the bank loan. How much equity did
your aunt have when she sold the house and what annual return on
the house's Equity did she make?

The Gomez family bought a house for $175,000. They paid 20% down
and amortized the rest with a 30-year fixed mortgage loan at 4.5%
compounded monthly. Find their monthly loan payment.

An engineer bought a house four years ago for $70,000. She paid
cash equal to 10% of the purchase price as the down payment. The
rest she financed with two loans. One is a company subsidized loan
of 12% for $20,000, with equal monthly payments for 20 years. The
other loan (for the remainder of the money needed) was provided by
a local bank, with an interest rate of 15%, also payable over 20
years, with uniform monthly payments.
What...

You just bought a house for $500,000 and made a $119,418.84 down
payment. You obtained a 30-year loan for the remaining amount.
Payments were made monthly. The nominal annual interest rate
(compounded monthly) is 9%. What was his monthly loan payment?

You bought a house for 150,000. The bank required a
20% down payment and gave you a 30-year mortgage loan for the
remainder. Assume an annual interest rate of 3.5% and a
monthly repayment schedule. What is your monthly
payment? After 18 years of payments, how much do you
still owe?

Someone just bought our house (I wish) which is valued at
$245.500. They will put 10% down and finance the rest with a
30-year mortgage loan at 3% interest, compounded monthly. How much
is their monthly loan payment, rounded to the nearest whole
dollar?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 14 minutes ago

asked 14 minutes ago

asked 25 minutes ago

asked 31 minutes ago

asked 40 minutes ago

asked 45 minutes ago

asked 45 minutes ago

asked 47 minutes ago

asked 54 minutes ago

asked 56 minutes ago

asked 56 minutes ago

asked 57 minutes ago