Skip to content
Dashboards

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.

Project dataEGP millions

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

EGP millions. Open a line to see the accounts mapped to it
Multi-year income statement, EGP millions
Line itemFY16FY17FY18
Net Sales14.5016.1515.05
Other revenues4.806.966.37
3.192.924.85
Total Revenues22.4826.0326.28
Direct costs(4.43)(5.46)(5.67)
Gross Profit18.0520.5620.60
(2.76)(2.67)(4.29)
(6.17)(12.20)(5.77)
Leasing(1.13)(1.06)1.60
(2.61)(2.22)(2.12)
Travel costs(1.81)(2.42)(2.51)
0.00(0.21)0.05
Capitalized costs4.410.750.00
EBITDA7.980.547.54
D&A(2.05)(2.04)(1.89)
EBIT5.94(1.51)5.66
(1.98)(2.71)(2.25)
Extraordinary items(0.56)(0.82)(2.26)
EBT3.39(5.04)1.15
(0.49)(1.03)(0.37)
Net income / (loss)2.91(6.07)0.78
Variance analysis: year over year change, EGP millions and %
Line itemFY17 vs FY16FY18 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.21n/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%
Common-size analysis: each line as % of total revenues
Line itemFY16FY17FY18
Net Sales64.5%62.0%57.3%
Other revenues21.3%26.7%24.3%
Recharges14.2%11.2%18.5%
Total Revenues100.0%100.0%100.0%
Direct costs(19.7%)(21.0%)(21.6%)
Gross Profit80.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 income0.0%(0.8%)0.2%
Capitalized costs19.6%2.9%0.0%
EBITDA35.5%2.1%28.7%
D&A(9.1%)(7.9%)(7.2%)
EBIT26.4%(5.8%)21.5%
Financial items(8.8%)(10.4%)(8.6%)
Extraordinary items(2.5%)(3.2%)(8.6%)
EBT15.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.

Approach

How it is built

Read the case study
  1. 01

    Raw P&L account data is cleaned and given one code per account and partner company.

  2. 02

    A database holds the 3 fiscal years in one structure, and a mapping table assigns each account to a statement line.

  3. 03

    The statement, variance and common-size views are all calculated from that single source.

  4. 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.

Explore all dashboards
Chat on WhatsApp