Lesson input file
january-february.xlsx
files/input/january-february.xlsx
Reading view of visible worksheets. Stored values are not recalculated; formatting and hidden sheets remain in the original Excel file.
Income Statement
| Line | Amount EUR |
|---|---|
| Revenue | 230000 |
| Cost of sales | -140000 |
| Operating expenses | -37000 |
| Operating profit | 53000 |
Balance Sheet
| Line | Amount EUR |
|---|---|
| Cash | 32000 |
| Trade receivables | 48000 |
| Inventory | 40000 |
| Equipment | 85000 |
| Trade payables | -52000 |
| Bank loan | -65000 |
| Equity | -88000 |
| Balance check | 0 |
Cash Flow
| Line | Amount EUR |
|---|---|
| Operating cash flow | 37000 |
| Investing cash flow | -5000 |
| Financing cash flow | -25000 |
| Cash movement | 7000 |