6)

Refer to the above loan amortisation schedule.

To calculate the amount of the principal repaid between end of period 4 and end of period 5, we could use the formula:

Select one:

a.

=-CUMIPMT(rate,nper,pv,start_period,end_period,type)

b.

=CUMINT (rate,nper,pv,start_period,end_period,type)

c.

=E7-E8

d.

=$B4-$E8