Question 3: You plan to borrow $400,000 at a 5% annual interest rate for your mortgage. The terms require you to amortize the loan with 30 year equal end-of-month payments (i.e., totally 30*12=360 payments).

(1) In Year 3 (i.e., payment #25 - Payment #36), how much principal and interest will be paid respectively?

(2) In Year 10, how much principal and interest will be paid respectively?

(3) In Year 20, how much principal and interest will be paid respectively?

(4) In Year 30, how much principal and interest will be paid respectively?

Hint: Since it's monthly payment, you need to convert the annual interest rate into monthly interest rate when you calculate (i.e., 5%/12=0.4167)

Please show the excel calculations or manual