Balance Sheet Data
Magic Software Enterprises Ltd. (MGIC)
$9.19
-0.17 (-1.82%)
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Total Cash | 113.92 | 95.51 | 89.65 | 94.82 | 86.97 | 173.48 | 206.40 | 245.56 | 292.16 | 347.60 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 97.34 | 109.54 | 121.57 | 151.96 | 164.02 | 217.40 | 258.66 | 307.74 | 366.13 | 435.61 |
Account Receivables (%) | ||||||||||
Inventories | -3.71 | -4.25 | -4.85 | -6.27 | -7.40 | -8.80 | -10.47 | -12.46 | -14.82 | -17.64 |
Inventories (%) | ||||||||||
Accounts Payable | 14.04 | 10.99 | 14.25 | 24.71 | 27.65 | 29.90 | 35.58 | 42.33 | 50.36 | 59.92 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -4.53 | -5.52 | -6.07 | -4.63 | -7.66 | -9.77 | -11.62 | -13.82 | -16.45 | -19.57 |
Capital Expenditure (%) |
To support growth, companies need to keep investing in capital items – including property, plants and equipment.
To calculate this net investment,we take capital expenditure (found in the company’s statement of cash flows)
and subtract non-cash depreciation (found on the income statement).
Working capital refers to the cash a company needs for day-to-day operations.
The faster a company expands, the more cash it will need.
To calculate working capital, we take current assets and subtract current liabilities.
You can find both of these on a company’s balance sheet, which is published in its quarterly and annual financial statements.