mo c D 10 Period interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period Balance interest Repayment Balance 1 $ 100,000 $ 6,000.00 $13,586.80 $ 92,413 2 $ 92,413$ 5,544.79 -$13,586.80 $ 84,371 31 $ 84,371 $ 5,062.27 $13,586.80 $ 75,847 7 4 $ 75,847 $ 4,550.80 $13,586.80 $ 66,811 5 $ 66,811 $ 4,008.64 -$13,586.80 $ 57,233 9 6 $ 57,233 $ 3,433.95 $13,586.80 $ 47,080 10 71 $ 47,080 $ 2,824.78 $13,586.80 $ 36,318 11 8 $ 36,318 $ 2.179.06 -$13,586.80 $ 24,910 12 9 $ 24,910 $ 1,494.60 $13,586.80 $ 12,818 13 10 $ 12,818 $ 769.06 -$13,586.80 $ 0 To enter the repayment amount in cell D4, before it is copied down to cells D5 to D13, we are best to input: Select one: O A. =PMT(C$2,C$1,B4) O B. =PMT(C$2,C$1,B$4) OC. =PMT(C1,C2,B4) OD=IPMT(C2,C1,B4)