Consider a $10,000 loan with a loan rate of 12% per year, compounded monthly. a. (3 points) If 25 equal monthly payments are made, beginning at the end of the first month, what is the value of each payment? A = P(AlPriming ) A = 10, 050 ( AIP, 2 %, 25 ) = 10650 (0 0 0457 ) = 454.V b. (3 points) What would you enter into Excel to find the principal portion of the 15th payment? c. (6 points) What is the unpaid balance in month 15? Ut = A (p/t, tin-t ) UE = 454 (P/ A, 10, 10 ) Ut = 454 ( 9 . 42 1 3) = 42 99- 97 a. (3 points) What would you enter into Excel to solve the problem in part c? = PV (19%%, 10,- 454) d. (5 points) If the 25 loan payments are deferred and begin at the end of month 4, how much interest is in the first payment? e. (5 points) Consider the original loan payment plan from part a. Immediately after the 15th payment is made, the loan rate is renegotiated and the interest rate changes to 6% per year, compounded monthly. What is the value of the monthly payment that will be made for the rest of the 25-month term