Q1-4
ASSUMPTIONS
Sales Price per Unit $49.99
Gross Margin = (Revenues - cost of goods sold) / Revenues 25%
Depreciation & amortization as a % of capital expenditures 25%
Tax Rate 35%
Year 2014 2015 2016 2017 2018
Units Sold 200,000
Growth Rate Of Unit Sold 5% 13% 15% 9%
Operating Expenses as % of Sales (2014 Only) 10%
Operating Expense Growth Rate 4% 4% 4% 4%
Capital Expenditures $1,750,000 $1,775,000 $1,800,000 $1,825,000 $1,850,000
Interest Expense $0 $10,000 $10,000 $10,000 $12,500
Income Statement
Year 2014 2015 2016 2017 2018
Units Sold
Price per Unit
Revenue
Cost of goods sold
Gross Profit (defined as Revenue - COGS)
Operating Expenses
Earnings Before Interest Taxes Depreciation And Amortization (Ebitda)
EBITDA / Revenue (%)
Depreciation and Amortization
Operating Income (defined as EBITDA - Depreciation and Amortization)
Interest Expense
Pre-tax Net Income (Operating Income - Interest Expense)
Income Taxes
Net Income (Pret-tax Net Income - Income Taxes)
Q5-19
Date Invoice Number Item Code Sales Rep Manager Ticket Price Price Per Unit Discount Given Sales Price Per Unit Cost per Unit Quantity Postal Code
1-Jan-14 1 9 Sarah Smith Fred Rubble 37.95 0.00% 37.95 22.85 18 94023
1-Jan-14 2 39 Amy Adams Fred Rubble 19.95 15.00% 16.96 7.25 12 93434
1-Jan-14 3 38 John Mack Fred Rubble 29.95 0.00% 29.95 12.96 36 93620
1-Jan-14 4 5 Sarah Smith Fred Rubble 58.95 0.00% 58.95 16.78 46 93589
1-Jan-14 5 26 Sarah Smith Fred Rubble 7.95 0.00% 7.95 2.54 18 93992
1-Jan-14 5 14 Sarah Smith Fred Rubble 31.95 0.00% 31.95 18.25 54 93992
1-Jan-14 6 15 John Mack Fred Rubble 30.95 0.00% 30.95 16.57 3 93527
1-Jan-14 7 10 Sarah Smith Fred Rubble 68.95 15.00% 58.61 38.69 16 93403
1-Jan-14 8 6 John Mack Fred Rubble 23.95 35.00% 15.57 10.76 36 93620
1-Jan-14 9 10 Sarah Smith Fred Rubble 68.95 15.00% 58.61 38.69 6 93775
1-Jan-14 10 44 Amy Adams Fred Rubble 41.95 0.00% 41.95 23.05 10 93434
1-Jan-14 10 25 Amy Adams Fred Rubble 3.95 0.00% 3.95 1.14 18 93434
1-Jan-14 10 28 Amy Adams Fred Rubble 43.95 0.00% 43.95 16.23 6 93434
1-Jan-14 11 38 Sarah Smith Fred Rubble 29.95 0.00% 29.95 12.96 28 93372
1-Jan-14 12 44 Amy Adams Fred Rubble 41.95 0.00% 41.95 23.05 3 93465
1-Jan-14 12 49 Amy Adams Fred Rubble 27.95 0.00% 27.95 12.86 4 93465
1-Jan-14 12 12 Amy Adams Fred Rubble 29.95 0.00% 29.95 13.98 28 93465
1-Jan-14 13 22 Sarah Smith Fred Rubble 5.95 0.00% 5.95 2.40 19 93651
1-Jan-14 14 2 John Mack Fred Rubble 62.95 0.00% 62.95 29.45 10 93620
1-Jan-14 15 40 Amy Adams Fred Rubble 21.95 0.00% 21.95 10.70 42 93992
1-Jan-14 16 50 Sarah Smith Fred Rubble 46.95 0.00% 46.95 26.32 9 93527
1-Jan-14 17 18 Amy Adams Fred Rubble 52.95 0.00% 52.95 25.49 52 93713
1-Jan-14 18 50 Sarah Smith Fred Rubble 46.95 0.00% 46.95 26.32 25 93868
1-Jan-14 19 15 John Mack Fred Rubble 30.95 0.00% 30.95 16.57 4 93930
1-Jan-14 20 44 Amy Adams Fred Rubble 41.95 0.00% 41.95 23.05 4 94023
1-Jan-14 21 41 John Mack Fred Rubble 38.95 0.00% 38.95 20.97 4 93496
1-Jan-14 21 46 John Mack Fred Rubble 31.95 0.00% 31.95 9.58 40 93496
2-Jan-14 22 30 Oliver Winslow Tim King 3.95 0.00% 3.95 1.06 6 93496
2-Jan-14 23 41 Rob Stewart Tim King 38.95 0.00% 38.95 20.97 3 93682
2-Jan-14 23 9 Rob Stewart Tim King 37.95 0.00% 37.95 22.85 6 93682
2-Jan-14 24 38 Oliver Winslow Tim King 29.95 0.00% 29.95 12.96 22 93589
2-Jan-14 24 39 Oliver Winslow Tim King 19.95 0.00% 19.95 7.25 36 93589
2-Jan-14 24 5 Oliver Winslow Tim King 58.95 0.00% 58.95 16.78 27 93589
2-Jan-14 25 9 Rob Stewart Tim King 37.95 0.00% 37.95 22.85 13 93403
2-Jan-14 26 9 Oliver Winslow Tim King 37.95 0.00% 37.95 22.85 6 93310
2-Jan-14 27 1 Rob Stewart Tim King 47.95 0.00% 47.95 28.67 3 93868
3-Jan-14 28 27 Amy Adams Tim King 3.95 15.00% 3.36 1.22 4 94023
3-Jan-14 29 20 Sarah Smith Tim King 29.95 0.00% 29.95 13.14 31 93713
3-Jan-14 30 4 Amy Adams Tim King 27.95 0.00% 27.95 12.99 12 93682
3-Jan-14 30 39 Amy Adams Tim King 19.95 0.00% 19.95 7.25 27 93682
3-Jan-14 31 47 Amy Adams Tim King 6.95 0.00% 6.95 2.15 33 93589
3-Jan-14 32 35 Sarah Smith Tim King 29.95 0.00% 29.95 13.25 30 93775
3-Jan-14 32 40 Sarah Smith Tim King 21.95 0.00% 21.95 10.70 31 93775
3-Jan-14 32 29 Sarah Smith Tim King 13.95 0.00% 13.95 5.52 12 93775
3-Jan-14 33 4 Amy Adams Tim King 27.95 0.00% 27.95 12.99 12 93868
3-Jan-14 34 7 Sarah Smith Tim King 10.95 15.00% 9.31 5.25 21 94023
3-Jan-14 35 30 Sarah Smith Tim King 3.95 0.00% 3.95 1.06 27 94023
3-Jan-14 35 28 Sarah Smith Tim King 43.95 0.00% 43.95 16.23 3 94023
3-Jan-14 36 49 Amy Adams Tim King 27.95 0.00% 27.95 12.86 4 93465
3-Jan-14 37 6 Sarah Smith Tim King 23.95 0.00% 23.95 10.76 16 93310
3-Jan-14 38 49 Sarah Smith Tim King 27.95 0.00% 27.95 12.86 6 93899
3-Jan-14 39 32 Amy Adams Tim King 22.95 0.00% 22.95 10.50 21 93744
3-Jan-14 39 24 Amy Adams Tim King 3.95 0.00% 3.95 1.07 34 93744
4-Jan-14 40 10 Rob Stewart Tim King 68.95 0.00% 68.95 38.69 25 93682
4-Jan-14 41 19 John Mack Tim King 19.95 0.00% 19.95 7.48 16 93930
4-Jan-14 42 27 Rob Stewart Tim King 3.95 0.00% 3.95 1.22 31 93961
4-Jan-14 43 39 John Mack Tim King 19.95 0.00% 19.95 7.25 25 93527
4-Jan-14 44 24 John Mack Tim King 3.95 0.00% 3.95 1.07 10 93558
4-Jan-14 44 40 John Mack Tim King 21.95 0.00% 21.95 10.70 25 93558
4-Jan-14 44 50 John Mack Tim King 46.95 0.00% 46.95 26.32 9 93558
4-Jan-14 45 42 Rob Stewart Tim King 14.95 0.00% 14.95 4.04 12 93527
4-Jan-14 46 2 John Mack Tim King 62.95 0.00% 62.95 29.45 9 93403
5-Jan-14 47 1 Amy Adams Tim King 47.95 0.00% 47.95 28.67 6 93775
5-Jan-14 47 33 Amy Adams Tim King 40.95 0.00% 40.95 16.07 13 93775
5-Jan-14 48 8 Amy Adams Tim King 51.95 0.00% 51.95 25.24 15 93372
5-Jan-14 48 16 Amy Adams Tim King 52.95 0.00% 52.95 24.65 43 93372
5-Jan-14 49 16 John Mack Tim King 52.95 0.00% 52.95 24.65 55 93403
5-Jan-14 50 48 Amy Adams Tim King 66.95 0.00% 66.95 27.82 4 93465
5-Jan-14 50 5 Amy Adams Tim King 58.95 0.00% 58.95 16.78 39 93465
5-Jan-14 51 3 John Mack Tim King 76.95 0.00% 76.95 39.58 3 93961
5-Jan-14 52 20 Amy Adams Tim King 29.95 0.00% 29.95 13.14 12 93868
5-Jan-14 53 39 John Mack Tim King 19.95 0.00% 19.95 7.25 43 93899
6-Jan-14 54 25 Oliver Winslow Fred Rubble 3.95 0.00% 3.95 1.14 30 93372
6-Jan-14 54 38 Oliver Winslow Fred Rubble 29.95 15.00% 25.46 12.96 16 93372
6-Jan-14 54 23 Oliver Winslow Fred Rubble 30.95 0.00% 30.95 17.52 54 93372
6-Jan-14 55 5 Rob Stewart Fred Rubble 58.95 0.00% 58.95 16.78 24 93744
6-Jan-14 56 17 Oliver Winslow Fred Rubble 57.95 0.00% 57.95 27.37 30 93620
6-Jan-14 57 5 Rob Stewart Fred Rubble 58.95 15.00% 50.11 16.78 33 93713
6-Jan-14 58 36 Oliver Winslow Fred Rubble 27.95 0.00% 27.95 10.10 4 93558
7-Jan-14 59 18 Sarah Smith Fred Rubble 52.95 0.00% 52.95 25.49 28 93868
7-Jan-14 60 9 Oliver Winslow Fred Rubble 37.95 0.00% 37.95 22.85 19 93775
7-Jan-14 61 34 Sarah Smith Fred Rubble 3.95 0.00% 3.95 1.19 3 93496
7-Jan-14 62 37 Rob Stewart Fred Rubble 27.95 0.00% 27.95 12.20 3 93372
8-Jan-14 63 34 Sarah Smith Fred Rubble 3.95 0.00% 3.95 1.19 45 93744
8-Jan-14 64 40 John Mack Fred Rubble 21.95 0.00% 21.95 10.70 18 93930
8-Jan-14 65 42 John Mack Fred Rubble 14.95 0.00% 14.95 4.04 18 94023
8-Jan-14 66 32 Amy Adams Fred Rubble 22.95 0.00% 22.95 10.50 36 93775
8-Jan-14 66 24 Amy Adams Fred Rubble 3.95 15.00% 3.36 1.07 18 93775
8-Jan-14 66 33 Amy Adams Fred Rubble 40.95 0.00% 40.95 16.07 10 93775
8-Jan-14 67 44 Amy Adams Fred Rubble 41.95 15.00% 35.66 23.05 10 93434
8-Jan-14 68 18 John Mack Fred Rubble 52.95 0.00% 52.95 25.49 48 93403
8-Jan-14 68 13 John Mack Fred Rubble 34.95 0.00% 34.95 18.10 7 93403
8-Jan-14 69 16 Amy Adams Fred Rubble 52.95 0.00% 52.95 24.65 36 93682
8-Jan-14 70 35 Amy Adams Fred Rubble 29.95 0.00% 29.95 13.25 10 93651
8-Jan-14 71 25 John Mack Fred Rubble 3.95 0.00% 3.95 1.14 9 93527
8-Jan-14 72 37 John Mack Fred Rubble 27.95 0.00% 27.95 12.20 4 93930
8-Jan-14 73 42 Amy Adams Fred Rubble 14.95 15.00% 12.71 4.04 13 93992
8-Jan-14 74 28 Sarah Smith Fred Rubble 43.95 0.00% 43.95 16.23 6 93713
8-Jan-14 74 22 Sarah Smith Fred Rubble 5.95 0.00% 5.95 2.40 16 93713
8-Jan-14 74 41 Sarah Smith Fred Rubble 38.95 15.00% 33.11 20.97 4 93713
8-Jan-14 75 14 John Mack Fred Rubble 31.95 15.00% 27.16 18.25 19 93496
8-Jan-14 76 26 Amy Adams Fred Rubble 7.95 15.00% 6.76 2.54 3 93837
8-Jan-14 77 12 Sarah Smith Fred Rubble 29.95 15.00% 25.46 13.98 25 94023
8-Jan-14 78 13 John Mack Fred Rubble 34.95 0.00% 34.95 18.10 3 93310
8-Jan-14 79 23 Amy Adams Fred Rubble 30.95 0.00% 30.95 17.52 22 93465
8-Jan-14 80 1 Sarah Smith Fred Rubble 47.95 0.00% 47.95 28.67 15 93496
9-Jan-14 81 14 Oliver Winslow Tim King 31.95 0.00% 31.95 18.25 51 93372
9-Jan-14 82 31 Rob Stewart Tim King 25.95 0.00% 25.95 12.50 3 93527
9-Jan-14 83 11 Oliver Winslow Tim King 50.95 0.00% 50.95 21.42 4 93930
9-Jan-14 84 25 Rob Stewart Tim King 3.95 0.00% 3.95 1.14 16 93930
9-Jan-14 84 49 Rob Stewart Tim King 27.95 0.00% 27.95 12.86 6 93930
10-Jan-14 85 18 Amy Adams Tim King 52.95 0.00% 52.95 25.49 48 93651
10-Jan-14 85 21 Amy Adams Tim King 3.95 0.00% 3.95 1.29 4 93651
10-Jan-14 86 36 Sarah Smith Tim King 27.95 0.00% 27.95 10.10 6 93744
10-Jan-14 87 43 Sarah Smith Tim King 41.95 0.00% 41.95 25.48 16 93806
10-Jan-14 87 43 Sarah Smith Tim King 41.95 0.00% 41.95 25.48 33 93806
10-Jan-14 87 20 Sarah Smith Tim King 29.95 0.00% 29.95 13.14 19 93806
10-Jan-14 88 26 Sarah Smith Tim King 7.95 0.00% 7.95 2.54 13 93837
10-Jan-14 89 12 Sarah Smith Tim King 29.95 0.00% 29.95 13.98 21 93992
10-Jan-14 89 50 Sarah Smith Tim King 46.95 15.00% 39.91 26.32 3 93992
11-Jan-14 90 32 Rob Stewart Tim King 22.95 0.00% 22.95 10.50 43 93837
11-Jan-14 91 10 John Mack Tim King 68.95 0.00% 68.95 38.69 13 93372
11-Jan-14 91 27 John Mack Tim King 3.95 0.00% 3.95 1.22 51 93372
12-Jan-14 92 9 John Mack Tim King 37.95 0.00% 37.95 22.85 15 93589
12-Jan-14 92 4 John Mack Tim King 27.95 0.00% 27.95 12.99 12 93589
12-Jan-14 92 31 John Mack Tim King 25.95 15.00% 22.06 12.50 9 93589
12-Jan-14 92 43 John Mack Tim King 41.95 0.00% 41.95 25.48 7 93589
12-Jan-14 93 26 John Mack Tim King 7.95 0.00% 7.95 2.54 15 93651
12-Jan-14 94 38 John Mack Tim King 29.95 0.00% 29.95 12.96 12 93434
12-Jan-14 94 45 John Mack Tim King 58.95 0.00% 58.95 33.19 37 93434
12-Jan-14 94 47 John Mack Tim King 6.95 0.00% 6.95 2.15 25 93434
12-Jan-14 94 45 John Mack Tim King 58.95 0.00% 58.95 33.19 36 93434
12-Jan-14 94 29 John Mack Tim King 13.95 0.00% 13.95 5.52 42 93434
12-Jan-14 94 34 John Mack Tim King 3.95 0.00% 3.95 1.19 33 93434
12-Jan-14 94 3 John Mack Tim King 76.95 0.00% 76.95 39.58 3 93434
12-Jan-14 95 36 Amy Adams Tim King 27.95 15.00% 23.76 10.10 13 93403
12-Jan-14 96 9 Amy Adams Tim King 37.95 0.00% 37.95 22.85 10 93527
12-Jan-14 96 46 Amy Adams Tim King 31.95 15.00% 27.16 9.58 31 93527
12-Jan-14 97 32 John Mack Tim King 22.95 0.00% 22.95 10.50 4 93403
12-Jan-14 98 8 Amy Adams Tim King 51.95 0.00% 51.95 25.24 36 93744
12-Jan-14 99 39 John Mack Tim King 19.95 0.00% 19.95 7.25 19 93682
12-Jan-14 100 11 Amy Adams Tim King 50.95 0.00% 50.95 21.42 7 93651
12-Jan-14 100 48 Amy Adams Tim King 66.95 0.00% 66.95 27.82 3 93651
12-Jan-14 100 47 Amy Adams Tim King 6.95 0.00% 6.95 2.15 37 93651
12-Jan-14 101 19 John Mack Tim King 19.95 0.00% 19.95 7.48 16 93434
12-Jan-14 102 47 Amy Adams Tim King 6.95 0.00% 6.95 2.15 25 93372
12-Jan-14 103 27 John Mack Tim King 3.95 35.00% 2.57 1.22 10 93496
12-Jan-14 103 30 John Mack Tim King 3.95 0.00% 3.95 1.06 4 93496
12-Jan-14 103 21 John Mack Tim King 3.95 0.00% 3.95 1.29 16 93496
12-Jan-14 104 22 Amy Adams Tim King 5.95 15.00% 5.06 2.40 10 93837