1. The financial statements comprise the Income Statement and Balance Sheet
2. The financial statements comprise the Income Statement and Balance Sheet
a) Provides income statement framework by drawing lines on the cells shown in Figure 5.
b) Enter income statement data by typing labels and values on the cells shown in Figure 5.
3. Calculates income statement data with the following formulas:
a) D7: +C5-C6
b) B13: +B11-B12
c) C17: @sum (B13..B16)
d) C18: +C10+C17
e) D20: +C18-C19
f) D21: +D7-D20
g) D24: +C23+C24
h) D25: +D21+D24
i) D33: @sum (C27..C32)
j) D34: +D25-D33
4. The preparation of the Balance Sheet Statement is as follows:
a) Provides a Balance Sheet Statement frame by drawing lines on the cells shown in Figure 6.
b) Enter the balance sheet data by typing the labels and values on the cells shown in Figure 6.
5. Calculates Balance Sheet data with the following formulas:
a) C7: +B5-B6
b) D9: +C7+C8
c) C14: +B12-B13
d) C17: +C11+C14+C15+C16
e) D22: +C17-C21
f) C21: +B19+B20
g) D23: +D9+D22