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
Active Questions
  • Suppose that the time (in hours) that Irene spends on an untimed final exam follows an...
    asked 17 minutes ago
  • The following sample observations were randomly selected. (Round intermediate calculations and final answers to 2 decimal...
    asked 30 minutes ago
  • what type of graph is best suitable for data obtained from customer ratings. The ratings are...
    asked 33 minutes ago
  • Determine the cumulative 15-year 18 kip ESAL’s in the design lane for 2-lane highway for the...
    asked 41 minutes ago
  • Q: Dr.Grimace, the evil dentist, is trying to find out if his patients suffer from periodontal...
    asked 41 minutes ago
  • After collecting data on 19283 dogs, you find that male vallhunds have an average weight of...
    asked 43 minutes ago
  • Research Target Corporation and assess your satisfaction with the company you researched and make recommendations about...
    asked 44 minutes ago
  • Evidence suggests that 70% of FSU students like turtles. Suppose we randomly sampled 15 FSU students....
    asked 44 minutes ago
  • Ulrich challenges the appropriateness of the nearly universal symbolism of the spinning wheel as the marker...
    asked 45 minutes ago
  • Differential Equations: Please try to computer type, if not possible be clear and organize. Thank you...
    asked 45 minutes ago
  • In your opinion, what are the three (3) most important benefits an employer can give to...
    asked 50 minutes ago
  • In a test of the effectiveness of garlic for lowering​ cholesterol, 81 subjects were treated with...
    asked 53 minutes ago