Question

Part B: Planning problems using Excel Mortgage payments : ( 10 % of this assignment) Loan...

Part B: Planning problems using Excel

  1. Mortgage payments : ( 10 % of this assignment)
    • Loan amount : $200,000
    • Interest rate (annual): 4.00 %
    • Term : 30 years
    • Calculate
      1. monthly payments: ( Hint : Rate and number of periods should be adjusted for monthly)
      2. Total interest amount over the life of the loan

  1. In reference to (1, above). ( 10 % of this assignment)

  1. Calculate PMT ( Monthly payments) if you want to pay of the above loan in 20 years
  2. How much less interest will you pay over the life of the loan ( versus paying in 30 years)

Homework Answers

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
You are planning to buy a $200,000 house using a 30-year mortgage that requires equal monthly...
You are planning to buy a $200,000 house using a 30-year mortgage that requires equal monthly payments starting one month from today. Annual interest rate is 6.6%, compounded monthly. Calculate your monthly payments. How much have you paid off the mortgage after 10 years? Suppose you are planning to refinance this mortgage after 10 years at an annual interest of 4.8%, compounded monthly, for the remainder of the term. However, you are going to be charged a 10% prepayment fee....
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price...
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price of $405,000 using pencil and paper. Your down payment is 10% of your own money apart from the loan. Calculate the total paid for your home after paying the monthly payment for 30 years factoring in the rate of 2.990%. You can use arithmetic. How much money will you pay in interest over 30 years? All Calculations must be shown.
EXHIBIT 5.9 A Table of Monthly Mortgage Payments (Monthly Payments Necessary to Repay a $10,000 Loan)...
EXHIBIT 5.9 A Table of Monthly Mortgage Payments (Monthly Payments Necessary to Repay a $10,000 Loan) The monthly loan payments on a mortgage vary not only by the amount of the loan, but also by the rate of interest and loan maturity. LOAN MATURITY Rate of Interest 10 Years 15 Years 20 Years 25 Years 30 Years 5.0% $106.07 $79.08 $66.00 $58.46 $53.68 5.5 108.53 81.71 68.79 61.41 56.79 6.0 111.02 84.39 71.64 64.43 59.96 6.5 113.55 87.11 74.56 67.52...
A borrower has a 30-year fully amortizing mortgage loan for $200,000 with an interest rate of...
A borrower has a 30-year fully amortizing mortgage loan for $200,000 with an interest rate of 6% and monthly payments. If she wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? (I know the correct answer would be $175,545, but how to find the amount that goes in interest and principal?)
13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals...
13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You’ve decided to buy a house that is valued at $1 million. You have $200,000 to use as a down payment on the house, and want to take out a mortgage...
Tom buys a $240,000 home. He must make monthly mortgage payments for 30 years, with the...
Tom buys a $240,000 home. He must make monthly mortgage payments for 30 years, with the first payment to be made a month from now. The annual effective rate of interest is 8%. After 15 years Tom doubles his monthly payment to pay the mortgage off more quickly. Calculate the interest paid over the duration of the loan.
Problem 37.8 The interest rate on a 30 year mortgage is 12% compounded monthly. Lauren is...
Problem 37.8 The interest rate on a 30 year mortgage is 12% compounded monthly. Lauren is repaying the mortgage by paying monthly payments of 700. Additionally, to pay o the loan early, Lauren has made additional payments of 1,000 at the end of each year. Calculate the outstanding balance at the end of 10 years. Answer should be: $45,435.32
15. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals...
15. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You’ve decided to buy a house that is valued at $1 million. You have $250,000 to use as a down payment on the house, and want to take out a mortgage...
13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals...
13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You’ve decided to buy a house that is valued at $1 million. You have $300,000 to use as a down payment on the house, and want to take out a mortgage...
Using this table as needed, calculate the required information for the mortgage. Table states Monthly Payments...
Using this table as needed, calculate the required information for the mortgage. Table states Monthly Payments to Amortize Principal and Interest per $1,000 Financed = 7.34 Amount Financed Interest Rate Term of Loan (years) Number of $1,000s Financed Table Factor (in $) Monthly Payment (in $) Total Interest (in $) $66,500 8.00% 30 $ $ $