Mr. Ramos buys a house and lot that cost P450,000. He pays P75,000 as down payment and promises to pay the balance by monthly installment for 25 years. If money is worth 12% compounded monthly,

a. How much is the monthly amortization?

b. What is the outstanding balance at the end of 15 years?

c. What part of Mr. Ramos payment goes to the interest?

d. What part of the 181st payment goes to repayment of the principal?

e. Find the total interest paid on the transaction? Please do on excel