Income Statement AnalysisFY16 to FY18
An interactive rebuild of my Excel project. Pick a fiscal year to update the KPI cards and charts, then read the statement in three views and open any line to see its accounts.
Fiscal year
Key figures
Total revenues
26.28EGP m
▲ +1.0% vs FY17
Gross profit
20.60EGP m
▲ +0.2% vs FY1778.4% margin
EBITDA
7.54EGP m
▲ >150% vs FY1728.7% margin
Net income
0.78EGP m
▲ +112.8% vs FY173.0% margin
Revenues and profit by year
EGP millions, net margin on the right axis
From revenues to net income
Profit bridge for the selected year, EGP millions
Margin trend
Gross, EBITDA and net margin, % of revenues
Cost structure
Each cost line as % of revenues, selected year vs previous year
| Line item | FY16 | FY17 | FY18 |
|---|---|---|---|
| Net Sales | 14.50 | 16.15 | 15.05 |
| Other revenues | 4.80 | 6.96 | 6.37 |
| 3.19 | 2.92 | 4.85 | |
| Corporate recharges | 3.22 | 2.92 | 4.89 |
| Charges and contributions | (0.03) | (0.01) | (0.04) |
| Total Revenues | 22.48 | 26.03 | 26.28 |
| Direct costs | (4.43) | (5.46) | (5.67) |
| Gross Profit | 18.05 | 20.56 | 20.60 |
| (2.76) | (2.67) | (4.29) | |
| R&D expenses | (2.26) | (2.07) | (3.70) |
| Freight outbound expenses | (0.02) | (0.34) | (0.35) |
| Insurance expenses | (0.21) | (0.05) | (0.07) |
| Software&IT | (0.20) | (0.01) | (0.02) |
| Misc costs | (0.01) | (0.02) | (0.11) |
| Non-recurring costs | (0.02) | (0.08) | (0.01) |
| Marketing expenses | (0.02) | (0.07) | 0.00 |
| Utility charges | 0.00 | (0.02) | (0.02) |
| Operating expenses for utilities | 0.00 | 0.00 | (0.01) |
| Utility expenses | (0.01) | (0.02) | 0.00 |
| Repairs/Maintenance costs | 0.00 | 0.00 | 0.00 |
| (6.17) | (12.20) | (5.77) | |
| Wages and salaries | (4.68) | (5.51) | (3.98) |
| Pension contributions | (1.38) | (0.30) | (0.29) |
| Social security payments | 0.00 | (1.75) | (1.42) |
| Severance indemnity contribution | (0.11) | (0.50) | (0.14) |
| Reimbursements+compensation for damages | 0.00 | 0.00 | 0.06 |
| Other personnel expenses | 0.00 | (0.01) | 0.00 |
| Impairment of participation | 0.00 | (4.13) | 0.00 |
| Leasing | (1.13) | (1.06) | 1.60 |
| (2.61) | (2.22) | (2.12) | |
| Service expenses | (2.54) | (1.84) | (1.96) |
| Legal expenses | (0.04) | (0.21) | (0.11) |
| Consulting fees | (0.02) | (0.17) | (0.06) |
| Travel costs | (1.81) | (2.42) | (2.51) |
| 0.00 | (0.21) | 0.05 | |
| Other income | 0.00 | (0.01) | 0.05 |
| Other operative currency differences | 0.00 | (0.02) | 0.00 |
| Gains from disposal of PP&E | 0.00 | 0.12 | 0.00 |
| Losses fr disposal of PPE | 0.00 | (0.31) | 0.00 |
| Capitalized costs | 4.41 | 0.75 | 0.00 |
| EBITDA | 7.98 | 0.54 | 7.54 |
| D&A | (2.05) | (2.04) | (1.89) |
| EBIT | 5.94 | (1.51) | 5.66 |
| (1.98) | (2.71) | (2.25) | |
| Interest expenses | (2.93) | (2.75) | (2.33) |
| Capitalized interest | 0.86 | 0.00 | 0.00 |
| Interest income | 0.09 | 0.04 | 0.07 |
| Extraordinary items | (0.56) | (0.82) | (2.26) |
| EBT | 3.39 | (5.04) | 1.15 |
| (0.49) | (1.03) | (0.37) | |
| Regional taxes | (0.52) | (0.48) | (0.52) |
| Deferred taxes | (0.02) | (0.01) | 0.16 |
| Current taxes | 0.05 | (0.50) | 0.00 |
| Property tax | 0.00 | (0.05) | 0.00 |
| Net income / (loss) | 2.91 | (6.07) | 0.78 |
| Line item | FY17 vs FY16 | FY18 vs FY17 | ||
|---|---|---|---|---|
| Change | % | Change | % | |
| Net Sales | +1.65 | +11.4% | -1.10 | -6.8% |
| Other revenues | +2.17 | +45.2% | -0.59 | -8.4% |
| Recharges | -0.27 | -8.5% | +1.94 | +66.4% |
| Total Revenues | +3.54 | +15.8% | +0.25 | +1.0% |
| Direct costs | -1.03 | -23.3% | -0.21 | -3.9% |
| Gross Profit | +2.51 | +13.9% | +0.04 | +0.2% |
| Other operating expenses | +0.09 | +3.2% | -1.62 | -60.7% |
| Personnel expenses | -6.03 | -97.7% | +6.43 | +52.7% |
| Leasing | +0.07 | +6.4% | +2.65 | >150% |
| Services | +0.39 | +15.0% | +0.09 | +4.2% |
| Travel costs | -0.60 | -33.2% | -0.10 | -4.0% |
| Other income | -0.21 | n/a | +0.26 | +122.6% |
| Capitalized costs | -3.66 | -83.1% | -0.74 | -100.0% |
| EBITDA | -7.45 | -93.3% | +7.01 | >150% |
| D&A | +0.00 | +0.0% | +0.16 | +7.6% |
| EBIT | -7.45 | -125.4% | +7.17 | >150% |
| Financial items | -0.73 | -36.9% | +0.46 | +17.0% |
| Extraordinary items | -0.26 | -45.4% | -1.44 | <-150% |
| EBT | -8.43 | <-150% | +6.18 | +122.7% |
| Taxes | -0.55 | -111.9% | +0.67 | +64.7% |
| Net income / (loss) | -8.98 | <-150% | +6.85 | +112.8% |
| Line item | FY16 | FY17 | FY18 |
|---|---|---|---|
| Net Sales | 64.5% | 62.0% | 57.3% |
| Other revenues | 21.3% | 26.7% | 24.3% |
| Recharges | 14.2% | 11.2% | 18.5% |
| Total Revenues | 100.0% | 100.0% | 100.0% |
| Direct costs | (19.7%) | (21.0%) | (21.6%) |
| Gross Profit | 80.3% | 79.0% | 78.4% |
| Other operating expenses | (12.3%) | (10.3%) | (16.3%) |
| Personnel expenses | (27.4%) | (46.9%) | (22.0%) |
| Leasing | (5.0%) | (4.1%) | 6.1% |
| Services | (11.6%) | (8.5%) | (8.1%) |
| Travel costs | (8.1%) | (9.3%) | (9.6%) |
| Other income | 0.0% | (0.8%) | 0.2% |
| Capitalized costs | 19.6% | 2.9% | 0.0% |
| EBITDA | 35.5% | 2.1% | 28.7% |
| D&A | (9.1%) | (7.9%) | (7.2%) |
| EBIT | 26.4% | (5.8%) | 21.5% |
| Financial items | (8.8%) | (10.4%) | (8.6%) |
| Extraordinary items | (2.5%) | (3.2%) | (8.6%) |
| EBT | 15.1% | (19.4%) | 4.4% |
| Taxes | (2.2%) | (4.0%) | (1.4%) |
| Net income / (loss) | 12.9% | (23.3%) | 3.0% |
Figures come from the training data set used in the project: three years of raw P&L accounts, cleaned and mapped into this statement. Amounts are in EGP millions.
- 01
Raw P&L account data is cleaned and given one code per account and partner company.
- 02
A database holds the 3 fiscal years in one structure, and a mapping table assigns each account to a statement line.
- 03
The statement, variance and common-size views are all calculated from that single source.
- 04
In Excel a VBA button switches the fiscal year. Here the switcher above does the same job.
Dashboards
More live dashboards
Finance projects rebuilt for the web from the same data. Switch years, filter and click through them like the originals.
