Offsetting the balance sheet
Use Case
You have simulated various balance sheet items and now want to offset your simulated balance sheet.
Calculation
Your simulated balance sheet looks as follows:
Balance sheet position | Account number | Amount |
|---|---|---|
Cash and cash equivalents | 10001 | 27,800.00 |
Balance sheet position B | 10002 | 55,400.00 |
Balance sheet position C | 10003 | 36,800.00 |
Total Assets | 101 | 120,000.00 |
Long-term debt | 20001 | 22,500.00 |
Balance sheet position E | 20002 | 60,100.00 |
Balance sheet position F | 20003 | 42,000.00 |
Total Liabilities | 201 | 124,600.00 |
The balance sheet offset can be performed by calling up the functions Sum and Conditions in the Control File as follows:
[101] = sum [10001] to [10003]
[201] = sum [20001] to [20003]
[10001] = if [101] < [201] then [10001] + [201] - [101] else [10001]
[20001] = if [101] >= [201] then [20001] + [101] - [201] else [20001]
[101] = sum [10001] to [10003]
[201] = sum [20001] to [20003]Result
As the sum of the assets in the simulated balance sheet is less than the sum of the liabilities, a profit was made, so that the balance sheet account ‘Cash and cash equivalents’ is increased by the difference:
Balance sheet position | Account number | Amount |
|---|---|---|
Cash and cash equivalents | 10001 | 32,400.00 |
Balance sheet position B | 10002 | 55,400.00 |
Balance sheet position C | 10003 | 36,800.00 |
Total Assets | 101 | 124,600.00 |
Long-term debt | 20001 | 22,500.00 |
Balance sheet position E | 20002 | 60,100.00 |
Balance sheet position F | 20003 | 42,000.00 |
Total Liabilities | 201 | 124,600.00 |
Variant
In your simulated balance sheet, the sum of the assets is greater than the sum of the liabilities:
Balance sheet position | Account number | Amount |
|---|---|---|
Cash and cash equivalents | 10001 | 27,800.00 |
Balance sheet position B | 10002 | 55,400.00 |
Balance sheet position C | 10003 | 46,800.00 |
Total Assets | 101 | 130,000.00 |
Long-term debt | 20001 | 22,500.00 |
Balance sheet position E | 20002 | 60,100.00 |
Balance sheet position F | 20003 | 42,000.00 |
Total Liabilities | 201 | 124,600.00 |
Also in this case, the balance sheet can be offset by calling up the functions Sum and Conditions in the Control File analogously to the above situation:
[101] = sum [10001] to [10003]
[201] = sum [20001] to [20003]
[10001] = if [101] < [201] then [10001] + [201] - [101] else [10001]
[20001] = if [101] >= [201] then [20001] + [101] - [201] else [20001]
[101] = sum [10001] to [10003]
[201] = sum [20001] to [20003]As a loss was made in the simulated balance sheet, the balance sheet account ‘Long-term debt’ is increased by the difference:
Balance sheet position | Account number | Amount |
|---|---|---|
Cash and cash equivalents | 10001 | 27,800.00 |
Balance sheet position B | 10002 | 55,400.00 |
Balance sheet position C | 10003 | 46,800.00 |
Total Assets | 101 | 130,000.00 |
Long-term debt | 20001 | 27,900.00 |
Balance sheet position E | 20002 | 60,100.00 |
Balance sheet position F | 20003 | 42,000.00 |
Total Liabilities | 201 | 130,000.00 |