N2 1 n 2 Period Interest Rate, i 3 Period 4 567 000 8 9 Beginning-of- period Balance Interest 1 $ 100,000 2 S 92,413 $6,000.00 $13,586.80 $ 92,413 $5,544.79 -$13,586.80 $ 84,371 $5,062.27-$13,586.80 $ 75,847 3 $ 84,371 4 $ 5 $ 6 $ 7 $ 75,847 $4,550.80-$13,586.80 $ 66,811 66,811 $ 4,008.64 $13,586.80 $ 57,233 57,233 $3,433.95 $13,586.80 $ 47,080 47,080 $ 2,824.78 -$13,586.80 $ 36,318 36,318 $ 2,179.06 -$13,586.80 $ 24,910 24,910 $ 1,494.60 $13,586.80 $ 12,818 0 8 $ 9 $ 10 $ 12,818 $ 769.06 -$13,586.80-$ DESENE. 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: B B 10 11 12 13 C 10 6.00% D E End-of- period Repayment Balance Select one: O a. O b. =-PPMT(rate,per,nper, pv,[fv],[type]) O c. =-CUMIPMT(rate,nper, pv,start_period,end_period,type) O d. =CUMINT (rate,nper,pv,start_period,end_period,type) =RATE(rate,nper,pv,start_period,end_period,type) 4

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: Select one: a. =RATE(rate,nper,pv,start_period,end_period,type) b. =-PPMT(rate,per,nper,pv,[fv],[type]) c. =-CUMIPMT(rate,nper,pv, start_period,end_period,type) d. =CUMINT (rate,nper,pv, start_period,end_period,type)