A n B E 1 10 2 Period Interest Rate, 6.00% End-of Beginning of period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $6,000.00 $13,586,800 $. 92,413 5 21 S 92.413 S 5,544.79 513586 80 $ 84,371 6 3 $ 84,371 $5,062.27 $13 586.50 $ 75,847 45 75,8475 4,550.00 $13,586.80 $ 66,811 SIS 66,811 S 4.008.64 $13,586.80 $ 57,233 6 s $2,233 $3.433.95 -$13,586.80 $ 47,080 10 7 $ 47,080 S 2.824.78513,586.80 $ 36,318 11 8S 36,318 S 2,179.06 S13 586.80 $ 24,910 12 9 s 24,910S 1.494.60 $13.586.80 $ 12,818 10 S 12.8185 769.06 $13.586.80-S 13 0 Refer to the above loan amortisation schedule. To calculate the amount of the principal repaid within the $13,586,80 paid in period 8, we could use the formula: O a Select one: =RATE(rate,nper,pv,start_period, end period, type) O b. =CUMINT (rate, nper,pv,start_period, end period, type) =-PPMT(rate, per, nper,pv,[fv].[type]) O d. =-CUMIPMT(rate, nper,pv,start_period, end period type) OC