a)You take out a $175,000 Canadian mortgage with a 25-year amortization period, a 5-year term, and a 6% posted mortgage interest rate. Assume 6-month compounding period. What is your monthly mortgage payment? (Round your answer to the nearest cent.)

Consider a home mortgage of $125,000 at a fixed APR of 4.5% for 25 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. ..... a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)

Problem:  Please answer the following questions regarding a $300,000 Mortgage Loan with monthly amortization over 30 years and an annual interest rate of 6%.    What is the loan payment for a (30 year loan (360 monthly payments) of $300,000 at 6%?   Question Answer What is the monthly payment amount? Loan Monthly Payment: How much interest and how much is principle on the first payment? Interest: Principle: How much interest and how much is principle on the second payment? Interest: Principle: If after the second payment an addition $10,000 was paid on principle.  How much would the interest be on the third payment? Interest:

Please eolve this question on excell and show formulas please.

Use chart.

What is the monthly payment (beginning) of a 30 year, 4.8%, $200,000 mortgage?

Problem: You are interested in a fixed-rate mortgage for $399,000 and need to choose the between options: a 15-year mortgage or a 30- year mortgage. The current mortgage rate is 3.75% for the 15-year mortgage, and 3.25% for the 30-year mortgage. Both require a 15% down payment. (Hint: make use of the amortization formula from Chapter 12). (a) What are the monthly principal and interest payments for EACH loan? Show your work. (b) What is the total amount of interest paid on EACH loan? Show your work. (c) Overall, how much more interest is paid by choosing the 30-year mortgage? Show your work.