It should be noted that instead of C26 you have to substitute the last line number in your table, such as C24. Drag the fill handle to the right, fill the cells in three columns. Amounts in the opening balance and turnover were calculated. For calculating the amounts at the end of the period should introduce a more complicated formula.… (more…)