Question

You have been saving money to buy a home and today, you decided to buy a home and take out $350,000 mortgage loan from a bank. This loan requires you to make a monthly payment for 30 years and the interest rate on your loan is 4% APR compounded monthly. What is your monthly mortgage payment for this loan? Please show your excel formula in your answer and explain step-by-step calculation to arrive to your answer.

Answer #1

Excel formula: PMT(rate, nper, pv, [fv], [type])

rate = 4%/12 = 0.003333333333

nper = 30 * 12 = 360

pv = 350,000

We can ignore [fv] and [type]. They are optional.

PMT(0.003333333333, 360, 350000)

PMT = -1,670.9535340756

(Ignore negative sign, it just indicates payment is a cash outflow)

Monthly payments will be $1,670.9535340756

Using formula

PV = 350,000

Monthly interest rate, r = 4%/12 = 0.003333333333

n = 30 * 12 = 360 monthly payments

Monthly payments will be $1,670.9535340756

Steve is buying home that costs $500,000. You have been offered
a 30-year mortgage that requires a 20% down payment for the house.
The loan is to be repaid in equal monthly installments. The APR of
the mortgage is 4%. Compute the EAR and the amount of your monthly
payment on the mortgage. Show all calculations. you need to find
the amount of the monthly payment in two different ways: 1) using
the built-in Excel function 2) using the annuity...

1) You have decided that you want to buy a home in 6
years. You believe you can afford a house that is
$190,000.
a) If you want to have 15% for a down payment, how much
will you need to have for the down payment?
Down payment = $.
DO NOT TYPE COMMAS OR ANSWERS WILL BE MARKED INCORRECT.
Round your answer to 2 decimal places as needed.
b) You decide to start investing money now so that you...

3. You take a $500,000 mortgage to buy a vacation home. The
mortgage entails equal monthly payments for 10 years, 120 payments
in all, with the first payment in one month. The bank charges you
an interest rate of 9.6% (APR with monthly compounding).
a. How much of your first payment is interest, and how much is
repayment of principal?
b. What is the loan balance immediately after the 10th payment?
(Calculate the loan balance using the annuity formula.)
c....

You are planning to buy a house worth $500,000 today. You plan
to live there for 15 years and then sell it. Suppose you have
$100,000 savings for the down payment. There are two financing
options: a 15-year fixed-rate mortgage (4.00% APR) and a 30-year
fixed-rate mortgage (5.00% APR). The benefit of borrowing a 30-year
loan is that the monthly payment is lower. But since you only plan
to hold the house for 15 years, when you sell the house...

You need a 25-year, fixed-rate mortgage to buy a new home for
$190,000. Your mortgage bank will lend you the money at a 9.1
percent APR for this 300-month loan. However, you can afford
monthly payments of only $800, so you offer to pay off any
remaining loan balance at the end of the loan in the form of a
single balloon payment.
How large will this balloon payment have to be for you to keep
your monthly payments at...

You need a 20-year, fixed-rate mortgage to buy a new home for
$220,000. Your mortgage bank will lend you the money at a 6.6
percent APR for this 240-month loan. However, you can afford
monthly payments of only $950, so you offer to pay off any
remaining loan balance at the end of the loan in the form of a
single balloon payment.
How large will this balloon payment have to be for you to keep
your monthly payments at...

You need a 25-year, fixed-rate mortgage to buy a new home for
$240,000. Your mortgage bank will lend you the money at a 6.1
percent APR for this 300-month loan. However, you can afford
monthly payments of only $800, so you offer to pay off any
remaining loan balance at the end of the loan in the form of a
single balloon payment.
Required: How large will this balloon payment have to be for you
to keep your monthly payments...

You need a 25-year, fixed-rate mortgage to buy a new home for
$250,000. Your mortgage bank will lend you the money at a 7.1
percent APR for this 300-month loan. However, you can afford
monthly payments of only $900, so you offer to pay off any
remaining loan balance at the end of the loan in the form of a
single balloon payment.
Required:
How large will this balloon payment have to be for you to keep
your monthly payments...

You need a 30-year, ﬁxed-rate mortgage to buy a new home for
$450,000. Your mortgage bank will lend you the money at a 6 percent
APR for this loan. However, you can afford monthly payments of only
$2,000, so you offer to pay off any remaining loan balance at the
end of the loan in the form of a single lump sum payment. How large
is this lump sum payment?

You have decided to begin saving for a vacation to Hawaii. You
believe that the full cost of the vacation, with airfare,
accommodations, and dining will be $5,000. You are going to begin
saving $150 per month, beginning one month from today. If your
account pays interest at a rate of 7.2% APR compounded monthly, how
many months will it take to save $5,000? Round your answer UP to
the nearest whole month.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 15 minutes ago

asked 18 minutes ago

asked 46 minutes ago

asked 49 minutes ago

asked 50 minutes ago

asked 51 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago