You are financing a new home. The loan is for $173,000 and you are getting rate...

You are financing a new home. The loan is for $173,000 and you are getting rate of 3.8% per year compounded monthly. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $300 per month to knock down the principle. You make these payments for 3 years starting on month 1. The last payment is on month 36.

Build the amortization table. What month will you make your last payment? How much will the last payment be?

Show work

Expert Solution

Therefore, in the last month 34.64 amount needs to be paid in the 167th month.

EMI is calculated in EXCEL as below:

=PMT(3.8%/12,15*12,-173000)

Please Upvote and Support!!

Rahul Sunny answered 2 years ago

You have a home loan of $150,000. The interest rate is 5.5% and the loan is...

You have a home loan of $150,000. The interest rate is 5.5% and the loan is for 30 years, with monthly payments. If you make a ONE TIME extra principle payment of $22,000 in period number 18, how much do you SAVE in total interest paid of the life of the loan? A. $22,000 B. $48,814 C. $35,712 D. $61,492

You want to take out a $324,000 mortgage (home loan). The interest rate on the loan...

You want to take out a $324,000 mortgage (home loan). The interest rate on the loan is 5.3%, and the loan is for 30 years. Your monthly payments are $1,799.19. How much will still be owed after making payments for 10 years? $__________Round your answers to the nearest dollar. How much will still be owed after making payments for 15 years? $__________ Round your answers to the nearest dollar. How much will still be owed after making payments for 20...

You took a loan to buy a new car. The monthly interest rate on the loan...

You took a loan to buy a new car. The monthly interest rate on the loan is 1.5% and you have to pay $240 every month for 60 months 1)What is the Present value of the Cash flows if its an ordinary annuity? 2)What is the future value of cash flows if its an ordinary annuity? 3)What is the present value of the cash flows if its an annuity due? 4)What is the future value of cash flows if its...

6. Consider the two loan financing alternatives: Home Value = $180,000 Two Financing Alternatives #1: 70%...

6. Consider the two loan financing alternatives: Home Value = $180,000 Two Financing Alternatives #1: 70% Loan to Value (LTV), 7.5% Interest Rate, 30 Years #2: 80% Loan to Value (LTV), 8% Interest Rate, 30 Years What are the monthly payments with alternatives 1 and 2? What is the incremental borrowing cost for the additional amount borrowed through alternative 2 (i.e., the loan with the higher LTV)? Suppose you expect to relocate after 11 years, but you do not have...

This morning, you took out a loan of $386,000 to purchase a home. The interest rate...

This morning, you took out a loan of $386,000 to purchase a home. The interest rate on the 30-year mortgage is 3.75 percent and you will make monthly payment. You have decided to make additional monthly payment of $360 beginning with the first payment that will occur one month from today. By how many years will you shorten the length of time it will take you to pay off the loan? Group of answer choices 11.06 years 9.33 years 12.84...

You are buying a $1,250,000 property, financing it with an 75% loan-to-value ratio, adjustable rate mortgage...

You are buying a $1,250,000 property, financing it with an 75% loan-to-value ratio, adjustable rate mortgage with a teaser rate of 2.95%. At the end of the first year, the mortgage loan rate adjusts to 3.875%. The loan has a 5 percent payment cap. You expect the property to appreciate 5% each year. 30 year loan/360 months. What is the teaser payment? What is the outstanding balance on the 1-year reset date? How much principal and interest was paid in...

You are financing a new car with a three-year loan at 10.5% annual nominal interest, compounded...

You are financing a new car with a three-year loan at 10.5% annual nominal interest, compounded monthly. The price of the car is $14,500. Your down payment is $1,500. What are your monthly payments at 10.5%? (Assume your payments start one month after the purchase, or at the end of the first period.)

‘A Home For You’ is a company that provides financing for purchasing a home. All mortgage...

‘A Home For You’ is a company that provides financing for purchasing a home. All mortgage applicants must first be approved. All approved applicants are then required to make a deposit on the home loan to cover the various applicable fees. The following information is entered for each applicant:  name  loan amount  age (A valid age is between 18 and 55 inclusive)  monthly income (monthly income > 0 )  credit rating ('G' for good and...

You are getting ready to purchase your first home. You wish to purchase a $400,000 home...

You are getting ready to purchase your first home. You wish to purchase a $400,000 home and the bank requires a 20% deposit. Your father-in-law will provide whatever amount you need after using the governments Homestart scheme and you withdraw your savings from Kiwisaver. Interest rates on a 20-year mortgage with fortnightly payments are 6 percent per annum. a. What will your fortnightly payment be on a 20 year mortgage? b. After 5 years of paying off this mortgage, you...

Amy receives a home improvement loan of $10,000. The loan has a nominal interest rate convertible...

Amy receives a home improvement loan of $10,000. The loan has a nominal interest rate convertible monthly of i(12) = 6%. The term of the loan is three years and Amy is expected to make level end-of-month payments, except that she is allowed to miss one payment so long as she then pays higher level payments for the remainder of the three years, so as to have repaid the loan at the end of the three-year period. Suppose Amy misses...

Question