Financial Analysis
Financial Analysis
Financial Analysis
Income Statemment
Revenue 150,000.0 165,000.0 181,500.0 199,650.0 219,615.0 241,576.5 265,734.2
COGS 67,500.0 74,250.0 81,675.0 89,842.5 98,826.8 108,709.4 119,580.4
Gross Profit 82,500.0 90,750.0 99,825.0 109,807.5 120,788.3 132,867.1 146,153.8
SG&A 16,500.0 18,150.0 20,000.0 20,000.0 20,000.0 20,000.0 20,000.0
EBITDA 66,000.0 72,600.0 79,825.0 89,807.5 100,788.3 112,867.1 126,153.8
Deprecition 6,600.0 7,260.0 9,075.0 9,982.5 10,980.8 12,078.8 13,286.7
Interest 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0
EBT 58,400.0 64,340.0 69,750.0 78,825.0 88,807.5 99,788.3 111,867.1
Taxes 17,520.0 19,302.0 20,925.0 23,647.5 26,642.3 29,936.5 33,560.1
Net Income 40,880.0 45,038.0 48,825.0 55,177.5 62,165.3 69,851.8 78,307.0
Assumptions
Revenue growth 10.0% 10% 10% 10% 10% 10%
COGS % of revenue 45.0% 45.0% 45% 45% 45% 45% 45%
SG&A 16,500.0 18,150.0 20,000.0 20,000.0 20,000.0 20,000.0 20,000.0
Deprecition % revenue 4.4% 4.4% 5% 5% 5% 5% 5%
Interest 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0
Tax rate 30.0% 30.0% 30% 30% 30% 30% 30%
Cost Analysis
COGS 10 67,500.0 74,250.0 81,675.0 89,842.5 98,826.8 108,709.4 119,580.4
SG&A 10 16,500.0 18,150.0 20,000.0 20,000.0 20,000.0 20,000.0 20,000.0
Deprecition 5 6,600.0 7,260.0 9,075.0 9,982.5 10,980.8 12,078.8 13,286.7
Interest 5 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0 1,000.0
Taxes 0 17,520.0 19,302.0 20,925.0 23,647.5 26,642.3 29,936.5 33,560.1
Total 30 109,120.0 119,962.0 132,675.0 144,472.5 157,449.8 171,724.7 187,427.2
Error Check OK OK OK OK OK OK OK
Rounding 30,000.0
300000
292666.66667
Absolute (29,266.7)
29266.666667
Div/0 0 na na na na na na na
Adding with an error 0.0 0.0 0.0 0.0 0.0 0.0 0.0
USD $000's 2014A 2015A 2016E 2017E 2018E 2019E 2020E
Assumptions
Analysis
300,000.0
Scenarios Running: 1
200,000.0
Summary Data
100,000.0
Financial Valuation
0.0
Charts & Graphs
(300,000.0)
2014A 2015A 2016A
2014A 2015A 2016A 2017A 2018A 2019A 2020A
Income Statement
Revenue 150000 165000
COGS 67500 74250
Gross Profit 82500 90750
SG&A 16500 18150
EBITDA 66000 72600
Depreciation 6600 7260
Interest 1000 1000
EBT 58400 64340
Taxes 17520 19302
Net Income 40880 45038