The monthly mortgage payment on the loan is calculated using the following equation
Monthly mortgage payment = $1,479.38
Amortization schedule first 3 months | |||||
Month | Beginning balance | Monthly payment | Interest | Principal | Ending balance |
1 | $200,000 | $1,479.38 | $666.67 | $812.71 | $199,187.29 |
2 | $199,187.29 | $1,479.38 | $663.96 | $815.42 | $198,371.86 |
3 | $198,371.86 | $1,479.38 | $661.24 | $818.14 | $197,553.72 |
In the first month, interest = ( 0.04 12) $ 200,000 = $ 666.67
Principal part 1st month = $ 1479.38 - $ 666.67 = $ 812.71
Ending balance 1st month = $ 200,000 - $ 812.71 = $199,187.29
Second month interest = ( 0.04 12) $199,187.29 = $ 663.96
Principal second month = $ 1479.38 - $ 663.96 = $ 815.42
Ending balance second month = $199,187.29 - $ 815.42 = $198,371.86
After 2 months, reduction in principal = $200,000 - $198,371.86 = $1,628.14
Robert and Rebecca Richardson have just signed a 15-year, 4% fixed rate mortgage for $200,000 to...
2-13 interest Idle P J. R. Smith plans to borrow $200,000 through a 30-year mortgage from his bank to buy a home. If the bank charges him an interest rate of 7 percent, find the (a) Monthly mortgage payment (b) Amortization schedule for the first 3 months: balance after each payment: principal and interest portions of each payment. (c) For the first 221 payments, what is the total interest paid and the total principal. (d) How much would J. R....
You just entered into a $150,000 30-year home mortgage at an annual interest rate of 4.25% making monthly payments of $737.91. Suppose you add an additional payment of $295.97 each month to the $737.91 house payment making your total monthly payments equal to $1,033.88. This extra amount is applied against the principal of the original loan. How long will it take you to pay off your loan of $150,000? Use a calculator to determine your answer. a. It will take...
You need to borrow $200,000. E-Click loans will make a 30 year, fully amortizing mortgage loan with monthly payments, with no points at an interest rate of 8%. (a) Construct a loan amortization schedule for the first 4 months of the loan. (b) What is the principal amount of your loan outstanding after 7 years (84 months) of making payments? Show that you can determine this by finding the FV of the loan after 7 years. Highlight your final answer
Complete the first two months of an amortization schedule for the fixed-rate mortgage Mortgage: Interest rate: Term of loan: $117.950 6.25% 13 years Complete the first two payments of the amortization schedule below. (Do not round until the final answer. Then round to the nearest cent as needed.) Payment Total Interest Principal Balance of Principal Number Payment Payment Payment
13. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward the purchase of a home at 6% APR. The amortization schedule of your mortgage is set in the monthly payments for the next 30 years. A) What is the monthly loan payment? B) What is the balance of the loan after 20 years of loan payments? C) From the previous mortgage loan question, what will be the principal and the total interest that you...
3. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward the purchase of a home at 6% APR. The amortization schedule of your mortgage is set in the monthly payments for the next 30 years. A) What is the monthly loan payment? B) What is the balance of the loan after 20 years of loan payments? C) From the previous mortgage loan question, what will be the principal and the total interest that...
1. You have just purchased a new house and taken a mortgage for $100,000. The interest rate is 12% compounded monthly and you will make payments for 25 years. a) Find the size of the monthly payment. b) The bank has a policy of rounding the payments up to the next cent. Find the new monthly payment and compute a new n. c) What was the balance of the loan after three periods? d) How much of your third payment was Principal? Interest? e) How much did...
You have just purchased a house and have obtained a 15-year, $200,000 mortgage with an interest rate of 10 percent. Use Excel and show all work—use formulas where useful—do not just key in answers. Assume annual payments and use tables provided. Required: What is your annual payment? Assuming you bought the house on January 1, what is the principal balance after one year? After 10 years? After four years, mortgage rates drop to 8 percent for 15-year fixed-rate mortgages. Assume...
You plan to purchase a $330,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.30 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the mortgage. How much total interest is paid on this mortgage?
3. You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on the loan is 8%, and payments will be made monthly. Estimate your monthly payments.