0% found this document useful (0 votes)
63 views6 pages

Tempest FA Template FH 2023

This document contains financial statements and key performance indicators for a company over three years (N-2, N-1, N). The income statement shows increasing revenues but decreasing profits over the period. The balance sheet indicates growing assets but stable shareholder equity. Several ratios are included to analyze margins, returns, leverage, liquidity, and operating and financial risk. Appendices provide additional details on items in the financial statements.

Uploaded by

Gts Pierre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
63 views6 pages

Tempest FA Template FH 2023

This document contains financial statements and key performance indicators for a company over three years (N-2, N-1, N). The income statement shows increasing revenues but decreasing profits over the period. The balance sheet indicates growing assets but stable shareholder equity. Several ratios are included to analyze margins, returns, leverage, liquidity, and operating and financial risk. Appendices provide additional details on items in the financial statements.

Uploaded by

Gts Pierre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Language GB

Tempest SA Historical data

Template

Income Statement
in K€ N-2 N-1 N

Goods sold 0 0 0
Production sold 40,307 63,157 78,388
Revenues 40,307 63,157 78,388
Production stored 2,381 1,592 3,154
Production capitalized 0 0 0
Other products 0 0 0
Total 42,688 64,749 81,542

Purchases of goods 0 0 0
Change in inventories (goods) 0 0 0
Raw mat and other purchases 15,287 31,240 41,564
Change in inventories (aw mat & other) -822 -1,228 -1,896
Gross margin 28,223 34,737 41,874

External charges 2,161 4,651 6,061


Taxes 922 1,021 1,052
Payroll 20,214 25,267 30,321
EBITDA 4,926 3,798 4,440

Depreciations & provisions 1,232 2,229 2,869


Total 38,994 63,180 79,971

Ebit 3,694 1,569 1,571

Financial products 5 0 0
Cost of debt 477 1,004 1,487
Financial result -472 -1,004 -1,487

PBT 3,222 565 83

Exceptional revenues 81 1,451 24


Exceptional expenses 42 65 89
Employees benefit 0 0 0
Income tax 1,207 663 6

Net profit/loss 2,055 1,288 12


Balance Sheet
in K€ N-2 N-1 N
Intangibles 328 601 573
Tangibles 5,002 17,876 16,468
Financials 0 0 0
Total net fixed assets 5,330 18,477 17,041

Inventories 5,194 8,052 11,603


Receivables 8,561 9,315 12,127
Other receivables 130 171 177

Cash & cash equivalent 74 11 1


Total current assets 13,959 17,549 23,908

Total assets 19,289 36,026 40,949

Paid in Capital 1,755 6,755 6,755


Reserves 2,730 4,415 5,368
Net result 2,055 1,288 12
Total shareholder equity 6,540 12,458 12,135

Provisions 181 234 254

Financial debt 5,517 8,617 9,264


Payables 3,156 9,163 12,657
fiscal and social debt 2,744 4,012 4,985
Miscellaneous 1,151 1,542 1,654
Total liabilities 12,568 23,334 28,560

Total liabilities & SE 19,289 36,026 40,949


verif 19,289 36,026 40,949

o/w dividends 370 335

Economic Balance Sheet N-2 N-1 N


Net fixed assets 5,330 18,477 17,041
Operating WCR o/w 11,321 13,633 16,457
Current op assets 13,885 17,538 23,907
current op liabilities 7,051 14,717 19,296
Restatements (see appendices) 4,487 10,812 11,846
discounted bills 4,258 9,493 10,556
non operating receivables 53 35 10
non operating liabilities 282 1,354 1,300

CE 16,651 32,110 33,498

Total shareholder equity (ex div) 6,540 12,088 11,800


Net Fin debt 9,701 18,099 19,819
Provisions and Non op WCR 410 1,923 1,879 to be reported here
CE 16,651 32,110 33,498
Provisions & Non op WCR 410 1,923 1,879 to be reported in economic BS
Provisions for Risk and liabilities 181 234 254
Other non op receivables -53 -35 -10
Debt related to fixed assets 282 1,354 1,300
Dividends to be paid 0 370 335
Other non op liabilities

KPIs & ratios


N-2 N-1 N
Margin analysis
revenue growth na +51.7% +25.9%
change in Ebit na -57.5% +0.1%
Ebit margin 9.2% 2.5% 2.0% EBIT/sales

Return analysis
RoCE before tax 22.2% 4.9% 4.7% EBIT/CE
RoCE after tax 14.0% 3.2% 3.1% EBITx(1-Tax)/CE
Capital intensity or productivity 2.4x 2.0x 2.3x Sales/CE

ROE 31.4% 10.7% 0.1% NI/Equity (after dividends)

Operating risk
Total operating costs 37762 60951 78998
o/w Variable costs 20,410 38,619 50,659
100% cost of supplies 15,287 31,240 41,564
50% external charges 1,081 2,326 3,031
20% staff costs 4,043 5,053 6,064
o/w Fixed costs 17352 22332 28339
Fixed/total costs 46.0% 36.6% 35.9%

Revenues 42,688 64,749 81,542


Variable costs -20,410 -38,619 -50,659
Margin on Variable costs 22,278 26,130 30,883
margin on VC as % of rev 52% 40% 38% MVC/sales

Breakeven point 33248.92 55337.76 74825.01 Fixed Costs /Margin rate on VC

Operating leverage (DOL : degree of ope6.03077964 16.6557668 19.66257583 Margin on VC / EBIT

Financial risk
NFD/E 148.3% 149.7% 168.0%
EBIT/cost of debt 7.8x 1.6x 1.1x should be >3

NFD/Ebitda 2.0x 4.8x 4.5x Should be <3.5


Liquidity & WCR Management
inventories/sales x 365 47.0x 46.5x 54.0x DIO (days inventories outstanding)
A/R restated / (sales+VAT) x 365 71.7x 51.7x 53.6x DSO (days sales outstanding)
A/P / ((cost of supplies + External charg 66.0x 93.2x 97.0x DPO (days payables outstanding)
(A/R+Cash)/Current liabilities 122.5% 63.4% 62.9% Quick ratio

Appendices
N-2 N-1 N
Miscellaneous information
Undue discounted bills 4,258 9,493 10,556
Gross receivables 9,129 9,637 12,133
Other receivables (details)
from current operations 77 136 167
not from current operations 53 35 10

Payables
from current operations 2,874 7,809 11,357
Related to fixed assets 282 1,354 1,300

Other current liabilities (details)


from current operations 1,151 1,542 1,654
not from current operations

Fiscal and social debt (details)


social security 2,744 4,012 4,985
income tax 0 0 0

Capital increase 0 5,000 0

capital expenditure 750 15,520 464


Tangibles 750 15,210 464
intangibles 310
disposals 0 0 0

average headcount - number of employ 780 1,050 1,300

dividend to be paid next year 370 335 0


P/O payout ratio 18% 26% 0%

tax rate 37% 34% 34%

Cost of debt (avge) 6.5% 7.2% 7.9%

VAT rate 20% 20% 20%

Debt term 5,517 8,617 9,264


Less than 1Y 385 187 4,057
More than 1Y 5,132 8,430 5,207
New loans 5,000 4,000
Loans repaid 1,000 1,900 3,353
ed in economic BS

fter dividends)

/Margin rate on VC
ventories outstanding)
ales outstanding)
ayables outstanding)

You might also like