Opening «cashflow-2026.xlsm»
Reading the workbook…
0 s
AutoSave
кабинка-7cb28539540a70990cfc164f
Home

Clipboard

Paste
Font

Copy, cut, and paste visible cells from the current selection and active cell.

Главная

Шрифт

Абзац

Font, size, colour and borders apply to the current visible selection.

Главная

Выравнивание

Alignment applies to the current visible selection. Extended print layout and automatic row/column resizing remain separate tasks.

Главная

Перенос и объединение

Wrap

Wrap, shrink to fit and merge apply to the current visible selection; extended print layout remains a separate task.

Home

Number

Number

Basic number, percentage, currency, date, time, and text formats apply to the current visible selection.

Главная

Стили

Conditional formatting applies visible styles to the selected numeric cells.

Главная

Ячейки

Ячейки

Insert, delete, hide, unhide and autofit work on the visible rows and columns of the current workbook.

Главная

Редактирование

Change Case: select a visible text cell.

Editing

Editing works on the visible cell, the formula bar, clear, cut, copy, paste and filling the selected range.

Paste
Clipboard
Font
Alignment
Paragraph
Cells
Number
Styles
Cells

Change Case: select a visible text cell.

Editing
A1

Choose data source

Choose a data source to connect through Power Query.

12 data sources

Connect to data source

SharePoint Online list

Online services

Learn more

Connection settings

Connection credentials

Sign in with an organizational account to continue.

Рабочая область листа

Сетка, выделение и ввод работают в видимой области текущего листа.

kind=default-ltr-session-placeholder; workbook=ltr; active=ltr; writing=horizontal-tbНаправление листа применяется к текущему виду.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1Northwind Tools — cash flow 2026 and the 2027 forecast
2Actuals come from the bank export (query MonthlyCashflow, Data → Queries). Fill the three assumptions in I5:I7 and the 2027 forecast recalculates. The macro FlagCashGaps marks the months where cash runs out.
3
4MonthInflowsOutflowsNetCumulativeStatusForecast assumptions
5Jan 20262151961818Revenue growth
6Feb 2026139209-70-52Cost inflation
7Mar 202622620225-27Opening cash 2027
8Apr 202623220527-500
9May 20262422123030
10Jun 20262392142454Summary — written by the macro FlagCashGaps
11Jul 20262192101064
12Aug 2026150207-577
13Sep 20262452153036
14Oct 20262572193874
15Nov 202626422539113
16Dec 202628123645159
17Total 20262,708,6002,550,100159
18
19Forecast 2027 — from the actuals and the assumptions above
20MonthInflowsOutflowsNetCumulativeStatus
21Jan 20272151961818
22Feb 2027139209-70-52
23Mar 202722620225-27
24Apr 202723220527-500
25May 20272422123030
26Jun 20272392142454
27Jul 20272192101064
28Aug 2027150207-577
29Sep 20272452153036
30Oct 20272572193874
31Nov 202726422539113
32Dec 202728123645159
33Total 20272,708,6002,550,100159
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Canvas grid keeps keyboard focus on the visible cell selection. Arrow keys move the active cell inside the visible window. Alt+Up/Down and bottom-bar buttons move through visible read-only surface objects. Escape returns from object selection to cells.