A debt of $ 21,000,000 is to be paid in monthly payments for 5 years. With a monthly rate of 1.71%. What is the value of the periodic fee? And if the debt of $ 21,000,000 is going to be canceled in monthly payments for 5 years and makes two extraordinary payments, the first of $ 2,000,000 in month 12 and another for $ 5,000,000 in month 30. With a rate of 1.71% monthly. What is the value of the ordinary fee?

Solve in excel and show formulae