CIS 105 - 3.12

The closing balance for Year 1 cannot be less than the opening balance, what is the correct formula?

• F5 = H5 + G5

• H5 = F4 + G4

• G5 = F5 + H5

• H5 = F5 + G5

What is the correct formula for the interest in Year 1?

• G5 = F5 + D5

• G5 = F4 * D4

• G5 = F4 + D4

• G5 = F5 * D5

The interest is too low for Year 1, is the formula correct?

• Yes

• No

The opening balance after Year 2 is constant, is it possible?

• Yes

• No

What is the correct formula for the opening balance in F6?