Question

Use the table provided in the handbook. Marsh Terban bought a home for $120,000 with a...

Use the table provided in the handbook. Marsh Terban bought a home for $120,000 with a down payment of $30,000. Her rate of interest is 12 1/2 percent for 35 years. Calculate her (A) monthly payment, (B) first payment broken down into interest and principal and (C) balance of mortgage at end of month.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Home Cost = $ 120000, Down Payment = $ 30000, Mortgage = 120000 - 30000 = $ 90000

Tenure = 35 years or (35 x 12) = 420 months and Interest Rate = 12.5 %

Applicable Monthly Interest Rate = 12.5/12 = 1.04167 %

Let the monthly mortgage payments be $ m

Therefore, 90000 = m x (1/0.0104167) x [1-{1/(1.0104167)^(420)}]

90000 = m x 94.7639

m = 90000 / 94.7639 = $ 949.729 ~ $ 949.73

Interest Accrued over 1st Month = Beginning Mortgage Balance x Monthly Interest Rate = 90000 x 0.0104167 = $ 937.5

Interest Portion of 1st Monthly Payment = Interest Accrued over 1st Month = $ 937.5

Principal Repaid = 949.729 - 937.5 = $ 12.23

Balance of Mortgage post 1st Month = 90000 - 12.23 = $ 89987.77

Add a comment
Know the answer?
Add Answer to:
Use the table provided in the handbook. Marsh Terban bought a home for $120,000 with a...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to...

    Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into— Selling price Down payment Amount mortgage Rate Years Monthly payment Interest Principal Balance at end of month $136,000 $30,000 $106,000 6.5% 30 $ $ $ $

  • PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET Problem #3: Create a table...

    PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET Problem #3: Create a table showing the payment of a mortgage of $138,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 32 years, and the nominal interest rate is 9.95% (a) What is the monthly payment? (b) What is the interest paid at the...

  • Name: SID: nment 5 Barbara borrowed $12 000.00 from the bank at 9% compounded monthly. The...

    Name: SID: nment 5 Barbara borrowed $12 000.00 from the bank at 9% compounded monthly. The loan is amortized with end-of-month payments over five years. a) Calculate the interest included in the 20th payment. b) Calculate the principal repaid in the 36th payment. c) Construct a partial amortization schedule showing the details of the first two payments, the 20th payment, the 36th payment, and the last two payments. d) Calculate the totals of amount paid, interest paid, and the principal...

  • all answered in microsoft excel thank you! Problem #3: Create a table showing the payment of...

    all answered in microsoft excel thank you! Problem #3: Create a table showing the payment of a mortgage of $161,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 32 years, and the nominal interest rate is 4.66% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th...

  • On September 1, the home mortgage balance was $146,000 for the home owned by Frank Sanchez

     On September 1, the home mortgage balance was $146,000 for the home owned by Frank Sanchez. The interest rate for the loan is 8 percent. Assuming that Frank makes the September monthly mortgage payment of $1460, calculate the following: (a) The amount of interest included in the September payment (round your answer to the nearest cent). (b) The amount of the monthly mortgage payment that will be used to reduce the principal balance. (c) The new balance after Frank makes this monthly mortgage...

  • 1.         You have purchased a home for $150,000. Fortunately, you were able to make a down...

    1.         You have purchased a home for $150,000. Fortunately, you were able to make a down payment of $15,000, but took out a 30-year mortgage for the $135,000 balance. The note payments are $1,388.63 per month at 12% annual interest.                         A.        Prepare the amortization schedule for the first 12 months of payments. B.       Calculate the subtotal for the amounts of cash payments, interest payments, and principal payments for the first12 months of payments.                         C.        Calculate the total...

  • Amanda Rice has just arranged to purchase a $560,000 vacation home in the Bahamas with a...

    Amanda Rice has just arranged to purchase a $560,000 vacation home in the Bahamas with a 25 percent down payment. The mortgage has a 6.2 percent APR compounded monthly and calls for equal monthly payments over the next 30 years. Her first payment will be due one month from now. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. There were no other transaction...

  • Amanda Rice has just arranged to purchase a $460,000 vacation home in the Bahamas with a...

    Amanda Rice has just arranged to purchase a $460,000 vacation home in the Bahamas with a 25 percent down payment. The mortgage has a 5.2 percent APR compounded monthly and calls for equal monthly payments over the next 30 years. Her first payment will be due one month from now. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. There were no other transaction...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

  • You buy a new home for $500,000 on the first day of the month. You put...

    You buy a new home for $500,000 on the first day of the month. You put down $50,000 and finance the rest with a mortgage at 6% annual interest compounded monthly on the last day of the month. Your monthly payments including principal and interest are 2500. Your payments are due on the first day of the month, starting next month. What is your loan balance after your third monthly payment ?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT