Question

Pam is buying a townhome that costs $145,000. She is making a down payment of $15,000...

Pam is buying a townhome that costs $145,000. She is making a down payment of $15,000 and getting a 30-year mortgage with a 6.25% APR for the rest.

Calculate Pam's loan amount: $145,000 - $15,000 = $130,000

Now use the PMT formula in Excel to calculate Pam's monthly payment on her mortgage.

Determine the payment, interest, principle, and balance for months 1 and 16.

Homework Answers

Answer #1

plz leave rating thank you

cell reference

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
suppose you are buying your first condo for 145,000 and you will make $15,000 down payment....
suppose you are buying your first condo for 145,000 and you will make $15,000 down payment. you have arranged to finnace the remainder with a 30 year monthly payment amortized mortgage at a 55 nominal interest rate with first payment due in one month what will your monthly payments be? how much of first month payment is the prindipal
Suppose you are buying your first home for $145,000, and you have $15,000 for your down...
Suppose you are buying your first home for $145,000, and you have $15,000 for your down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 6.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? Group of answer choices $741.57 $862.77 $821.69 $780.60 $905.91
Nancy Brock is buying her first home. It costs $85,000, and she will make a down...
Nancy Brock is buying her first home. It costs $85,000, and she will make a down payment of $15,000. She is planning on a 30-year loan at 8% interest. a. What is the exact monthly payment she will pay to the mortgage company? b. If Nancy is transferred to a new job in another city after owning the home for six years, what is the balance due the loan company when she sells the house?
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...
Nancy Karnes bought a home for $143,000 with a down payment of $15,000. Her rate of...
Nancy Karnes bought a home for $143,000 with a down payment of $15,000. Her rate of interest is 9% for 35 years. Calculate her: A. Monthly payment B. First payment broken down into interest and principal (Round your answers to the nearest cent.) C. Balance of mortgage at end of month A. Monthly payment B. First payment: interest principal C. Balance of mortgage
A​ 22-year old college graduate just got a job in Nashville. She is considering buying a...
A​ 22-year old college graduate just got a job in Nashville. She is considering buying a house with a $150,000 mortgage. The APR is 14% compounded monthly for her monthly mortgage payments on a 32-year fixed rate loan. If she can get her FICO score up to​ 750, the APR drops to 13.6%. How much in interest cost will she save over the life of the loan assuming she can increase her FICO score to​ 750? so using the information...
1. Nancy Baker is buying a condominium for $390,000. She is making a down payment of...
1. Nancy Baker is buying a condominium for $390,000. She is making a down payment of $75,000. At the closing, she must pay the bank 1.5 points. What is the cost of the 1.5 points owed to the bank? 2. Mel Jones bought a set of new tires for his car at a cost of $1,100.00 The sales tax rate is 5.75% and the excise tax rate is 8% What is the total cost of the tires? 3. Alice Jennings...
Christie is buying a new car today and is paying a $7500 cash down payment. She...
Christie is buying a new car today and is paying a $7500 cash down payment. She will finance the balance at 7.25 percent interest. Her loan requires 36 equal monthly payments of $450 each with the first payment due 30 days from today. Which one of the following statements is correct concerning this purchase? A. The future value of the loan is equal to 37 x 450. B. The present value of the car is equal to $7500 + (36...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value of the house and received a mortgage for the rest of the amount at 4.62% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. b. Calculate the principal balance at the end of the 5 year term. c. Calculate the monthly payment amount if the mortgage was renewed for another 5...
Sharon is considering the purchase of a car. After making the down payment, she will finance...
Sharon is considering the purchase of a car. After making the down payment, she will finance $15,500.00. Sharon is offered three maturities. On a four-year loan, Sharon will pay $371.17 per month. On a five-year loan, Sharon's monthly payments will be $306.99. On a six-year loan, they will be $264.26. Sharon rejects the four-year loan, as it is not within her budget. How much interest will Sharon pay over the life of the loan on the five-year loan? How much...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT