need every value like I/Y P/Y

1 Loan Amortization Schedule 2 3 Required: 4 a) Construct an full amortization schedule for the scenerio below. Details to 5 include pmt #, payment amount, interest portion and principal portion. 6 7 b) Determine how much interest was paid over the term of the loan. 8 9 Details: 10 RBC has provided a $200,000 loan to Capilano Construction Inc. that earns 11 interest at a rate of 3.5% compounded monthly. The loan is to be paid back in 12 13 equal payments at the end of each month over a three-year term. 14 15 1/4 16 PAY 17 CHY 18 N 19 PV 20 FV 21 PMT 22 23 Pmt # Payment Interest Portion Principal Portion Principal Balance 24 25