Copy of example: financial(P/L) with row-tags and column-tags
You can switch modes('Freeze' or 'Calculating')
Period Ended | Sept. 30, 2016 | Dec. 31, 2016 | Mar. 31, 2017 | Jun. 30, 2017 |
|---|---|---|---|---|
Revenues | ||||
Subscription | 249,931 | 56,326 | 63,369 | 72,502 |
Maintenance | 61,741 | 65,060 | 67,072 | 71,648 |
Perpetual license | 17,501 | 18,210 | 19,495 | 19,359 |
Other | 7,614 | 9,313 | 9,973 | 10,822 |
Total revenues | ||||
Cost of revenues (1)(2) | 22,562 | 26,899 | 32,895 | 36,805 |
Gross profit | ||||
Operating expenses | ||||
Research and development (1) | 67,458 | 69,758 | 82,262 | 90,691 |
Marketing and sales (1)(2) | 24,980 | 27,416 | 36,625 | 45,887 |
General and administrative (1) | 26,915 | 27,475 | 31,190 | 33,204 |
Total operating expenses | 119,353 | 124,649 | 150,077 | 169,782 |
Operating income (loss) | ||||
Other income (expense), net | (63) | (251) | (492) | (536) |
Finance income | 1,322 | 1,441 | 1,040 | 1,048 |
Finance costs | (7) | (38) | (6) | (24) |
Income (loss) before income tax benefit (expense) | (3,876) | (1,487) | (22,521) | (31,768) |
Income tax benefit (expense) | 1,239 | (211) | 5,060 | 11,060 |
Net income (loss) | (2,637) | (1,698) | (17,461) | (20,708) |
Settings
Period Ended | Sept. 30, 2016 | Dec. 31, 2016 | Mar. 31, 2017 | Jun. 30, 2017 |
|---|---|---|---|---|
Revenues | ||||
Subscription | 49,931 | 56,326 | 63,369 | 72,502 |
Maintenance | 61,741 | 65,060 | 67,072 | 71,648 |
Perpetual license | 17,501 | 18,210 | 19,495 | 19,359 |
Other | 7,614 | 9,313 | 9,973 | 10,822 |
Total revenues |   | Same almost as on the left | Same almost as on the left | Same almost as on the left |
Cost of revenues (1)(2) | 22,562 | 26,899 | 32,895 | 36,805 |
Gross profit | 114,225 | 122,010 | 127,014 | 137,526 |
Operating expenses | ||||
Research and development (1) | 67,458 | 69,758 | 82,262 | 90,691 |
Marketing and sales (1)(2) | 24,980 | 27,416 | 36,625 | 45,887 |
General and administrative (1) | 26,915 | 27,475 | 31,190 | 33,204 |
Total operating expenses | 119,353 | 124,649 | 150,077 | 169,782 |
Operating income (loss) | Same almost as on the left | Same almost as on the left | Same almost as on the left | |
Other income (expense), net | (63) | (251) | (492) | (536) |
Finance income | 1,322 | 1,441 | 1,040 | 1,048 |
Finance costs | (7) | (38) | (6) | (24) |
Income (loss) before income tax benefit (expense) | (3,876) | (1,487) | (22,521) | (31,768) |
Income tax benefit (expense) | 1,239 | (211) | 5,060 | 11,060 |
Net income (loss) | (2,637) | (1,698) | (17,461) | (20,708) |