Question

You have been saving money to buy a home and today, you decided to buy a...

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.

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires...
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...
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...
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...
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...
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...
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...
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...
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, fixed-rate mortgage to buy a new home for $450,000. Your mortgage bank...
You need a 30-year, fixed-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...
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.