ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Generous Money
2
INPUT
3
The tabs below need to filled out, applicable to your situation.
4
Only blue cells can be filled with data. All other cells are calculations.
5
Not all blue cells need to be filled in, only the ones that are relevant to your company.
6
7
OUTPUT
8
The tabs P&L (Profit & Loss statement), BS (Balance Sheet) and CFS (Cash Flow Statement) are outputs.
9
The Dashboard tabs contains charts of KPI's.
10
Control tab contains 'checks and balances' and all value should be 'zero'.
11
12
AreaInstructions
13
14
SalesSales (= Revenues) are Price x Units sold.
15
If there are many different kinds of products and/or different prices, you may also set units at 1 and price at total revenues.
16
17
COGSCost of Goods Sold - if applicable - is a percentage of Revenues.
18
COGS are Sales-related such as raw materials or purchased trading goods.
19
Difference between Sales and COGS is Gross Margin (see P&L).
20
21
OpexOperating Expenses are expenses or costs for normal business operations. Often abbreviated as OPEX or Opex.
22
Please use the relevant expense type (e.g. Personnel Costs, Rent etc.) as much as possible, or indicate/describe "Other".
23
If you receive government compensation towards wages from NOW (Noodmaatregel Overbrugging voor Werkgelegenheid), the compensation should be deducted from the Personnel Cost.
24
25
Capex & FACapital Expenditures (CAPEX or Capex) are funds used to acquire, upgrade, and maintain Fixed Assets such as buildings, plants, land, machines, office equipment etc. Capex is about investments that are 'capitalized' (= put on the Balance Sheet) and written-off over a period of time (= Depreciation).
26
Investments can also be made in Intangle Assets, such as Software of IP (Intellectual Property).
27
Goodwill is also an Intangle Assets.
28
Writing off intangle assets is called Amortization.
29
30
WCWorking Capital is about Current Assets and Current Liabilities.
31
De 'driver' in the model for Accounts Receivable is DSO (Days Sales Outstanding) = the average number of days that it takes to collect payment from clients after a sale has been made.
32
De 'driver' in the model for Inventory DIO (Days Inventory Outstanding) = the average time in days to turn inventory into sales.
33
De 'driver' in the model for the Accounts Payables is DPO (Days Payables Outstanding) = the average time in days to pay invoices to trade creditors (suppliers, vendors).
34
35
FinancingThere are several financing options such as:
36
37
1 Loans from Banks: take repayment ("aflossing") and interest ("rente") into consideration.
38
39
2 Shareholder Loans: take repayment ("aflossing") and interest ("rente") into consideration.
40
41
3 Factoring: put DSO under Working Capital at 0 (or close to 0) and take factoring cost into consideration.
42
43
4 Leasing, usually of fixed assets such as company cars, as an alternative to buying/investing in fixed assets (Capex). Take leasing cost into consideration.
44
45
5 RC ("Rekening Courant") credit facility = an arrangement with the bank that allows to borrow a particular amount of money for different purposes for a particular period of time. Simply said: it allows a company to have a negative balance ("rood staan") on its bank account.
46
The RC limit is the max credit amount.
47
Take interest expenses due to using the credit facility into consideration.
48
49
6 Grants & Subsidies are "gifts" that do not have to be paid back (otherwise it would be a loan).
50
There are many sorts of grants, such as:
51
SHI = Subsidieregeling voor demonstratieprojecten, haalbaarheidsstudies en investeringsvoorbereidingsprojecten.
52
53
7 Capital contributions: A capital contribution is financing by the business owners (shareholders) themselves.
54
55
ProvisionsProvisions ("voorzieningen") are obligations that have already been provided for, but for which the expenditure will only take place in the future.
56
They are shown as a liability on the balance sheet.
57
58
Retained EarningsProfits (or losses) are added (or subtracted) from the retained earnings.
59
Dividends paid out in cash are the be subtracted from the retained earning as they lower total equity.
60
61
Extraordinary itemsExtraordinary gains or losses come from events that are infrequent and unusual. Examples:
62
Gain: sale/divestment of an asset at a price higher than book value => fill-in a positive number.
63
Loss: restructuring costs => fill-in a positive number.
64
65
Corporate Income Tax
"Vennootschapsbelasting": 15% until € 245.000 profit and 25% for profit > € 245.000.
66
The model contains a simplified calculation.
67
Special fiscal rules and exceptions may apply and should be discussed with a tax specialist.
68
69
22M23M24QThis is a 'special' tab and allows for the P&L and CFS per month (2022 & 2023) and quarter (2024).
70
Totals should align with the P&L and CFS per year.
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
97
98
99
100