Balance Sheet Logic
- Former user (Deleted)
- Support
- tobias.bitterli (Deactivated)
Owned by Former user (Deleted)
The Balance Sheet gets calculated from the closing Balance Sheet of the previous period and from the difference between the Profit & Loss statement and the Cashflow statement of the actual period.
Balance Sheet(t) = Balance Sheet(t - 1) + Profit & Loss statement(t) - Cashflow statement(t)
The following example explains this functionality:
| ∑ | 01.2016 | 02.2016 | 03.2016 | 04.2016 | 05.2016 | 06.2016 | 07.2016 | 08.2016 | 09.2016 | 10.2016 | 11.2016 | 12.2016 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Profit & Loss statement | 48 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| Cashflow statement | 48 | 0 | 0 | 12 | 0 | 0 | 12 | 0 | 0 | 12 | 0 | 0 | 12 |
| Balance Sheet | 4 | 8 | 0 | 4 | 8 | 0 | 4 | 8 | 0 | 4 | 8 | 0 |
For 06 / 2016 the book value is calculated as follows:
Balance Sheet(06.2016) = 8 + 4 - 12 = 0