Balance Sheet Data

Magic Software Enterprises Ltd. (MGIC)

$9.31

+0.14 (+1.53%)

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.9295.5189.6594.8286.97173.48206.40245.56292.16347.60
Total Cash (%)
Account Receivables 97.34109.54121.57151.96164.02217.40258.66307.74366.13435.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.0410.9914.2524.7127.6529.9035.5842.3350.3659.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.