The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for...

The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for 4.63% annual interest rate compounded monthly. Calculate the payment needed for this loan and put your answer in F6. Then fill out the amortization schedule for the first year. After the table is done find the total interest paid in the first year and the total paid to principle for the first year. ON EXCELL!!

Solutions

Expert Solution

Answer:

payment needed for this loan = $ 1790.25 p.m

total interest paid in the first year = $15996.95

total principle paid in the first year = $5486.01

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

You decide to buy a house for a total of $305,469. To get amortgage loan,...

You decide to buy a house for a total of $305,469. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 4% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage?Enter your answer in dollars, rounded to the nearest cent (2 decimals).

You decide to buy a house for a total of $214452. To get a mortgage loan,...

You decide to buy a house for a total of $214452. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 5% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage?

16. John is buying a house for $1,000,000. He can get a 30-year loan on 80%...

16. John is buying a house for $1,000,000. He can get a 30-year loan on 80% of the purchase price at 7.25% with monthly payments, or he can get a 15-year monthly payment loan at 6.5% with the 20% downpayment. a. What would his payments be for each loan? [$5457.41; $6968.86] b. How much interest is paid over the life of each loan? [$1,164,667.60; $454,394.80]

1.You decide to buy a house for a total of $198842. To get a mortgage loan,...

1.You decide to buy a house for a total of $198842. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 6% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage? 2.A company has $96 million in outstanding bonds, and 10 million shares of stock...

You borrow $250,000 to buy a home. The terms of the loan are as follows: 30-year...

You borrow $250,000 to buy a home. The terms of the loan are as follows: 30-year mortgage loan at a rate of 4.50 percent with monthly payments. What percentage of your first month's payment goes toward interest? A. 67 percent B. 43 percent C. 74 percent D. 89 percent E. 58 percent

You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How...

You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How much will your monthly payments be? B) How much will go toward principal in the 75th month? How much will go toward interest in the 75th month? What will be the balance after 75 months? C) How much interest will you pay in total over the 30 years? D) If you do a 15-year loan instead of a 30-year one, how much will you...

$200,000 house at 5.0% interest, 30 year loan, the LTV is 90%. Assume that the PMI...

$200,000 house at 5.0% interest, 30 year loan, the LTV is 90%. Assume that the PMI has an upfront premium of 2% and an annual premium of 0.2%. 1. How much is the upfront PMI payment and how much is the monthly PMI payment? 2. How many months you have to pay PMI (when can you call your lender to request drop PMI payment)? 3. How many months your lender have to drop your PMI payment?

You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How...

You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How much will your monthly payments be? B. How much will go toward principal in the 55th month? How much will go toward interest in the 55th month? What will be the balance after 55 months? C. How much interest will you pay in total over the 30 years? D. If you do a 15-year loan instead of a 30-year one, how much will you...

Derek borrows $327,651.00 to buy a house. He has a 30-year mortgage with a rate of...

Derek borrows $327,651.00 to buy a house. He has a 30-year mortgage with a rate of 5.94%. After making 134.00 payments, how much does he owe on the mortgage?

Derek borrows $290,341.00 to buy a house. He has a 30 year mortgage with a rate...

Derek borrows $290,341.00 to buy a house. He has a 30 year mortgage with a rate of 4.09%. After making 86 payments, how much does he owe on the mortgage?

Subjects