Operationg Expenses For Startups

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

Net Revenues 1,000,000 5,250,000 9,750,000 16,250,000

Sales & Marketing


Drivers
Salaries and Benefits 69,000 270,250 432,900 624,000
Commissions % of Revenue 5% 50,000 262,500 487,500 812,500
Direct Mail Campaign 50,000 150,000 300,000 500,000

All other expenses % of Revenue 6% 60,000 315,000 585,000 975,000


Total Sales and Marketing 229,000 997,750 1,805,400 2,911,500
% of Revenue 22.9% 19.0% 18.5% 17.9%
General & Administration
Drivers
Salaries and Benefits 125,000 300,150 388,440 573,600
Depreciation 6,667 40,000 106,667 183,333
Rent and Utilities 20,000 20,000 100,000 110,000

All other expenses % of Revenue 2% 20,000 105,000 195,000 325,000

Total General & Administration 171,667 465,150 790,107 1,191,933


% of Revenue 17.2% 8.9% 8.1% 7.3%

Sales & Marketing by Months & Quarters


($)
Year 1 Year 2 Year 3 Year 4
Month 1 0 49,888 0 0
Month 2 0 49,888 0 0
Month 3 0 69,843 0 0
Total 1st Quarter 0 169,618 370,338 537,508
Month 4 11,450 59,865 0 0
Month 5 18,320 69,843 0 0
Month 6 22,900 69,843 0 0
Total 2nd Quarter 52,670 199,550 462,923 716,677
Month 7 22,900 79,820 0 0
Month 8 27,480 99,775 0 0
Month 9 34,350 99,775 0 0
Total 3rd Quarter 84,730 279,370 462,923 806,262
Month 10 27,480 109,753 0 0
Month 11 29,770 119,730 0 0
Month 12 34,350 119,730 0 0
Total 4th Quarter 91,600 349,213 509,215 851,054
Total for year 229,000 997,750 1,805,400 2,911,500

Research & Development by Months & Quarters


($)
Year 1 Year 2 Year 3 Year 4
Month 1 0 20,650 0 0
Month 2 0 20,650 0 0
Month 3 0 28,910 0 0
Total 1st Quarter 0 70,210 144,113 229,200
Month 4 7,450 24,780 0 0
Month 5 11,920 28,910 0 0
Month 6 14,900 28,910 0 0
Total 2nd Quarter 34,270 82,600 180,141 305,600
Month 7 14,900 33,040 0 0
Month 8 17,880 41,300 0 0
Month 9 22,350 41,300 0 0
Total 3rd Quarter 55,130 115,640 180,141 343,800
Month 10 17,880 45,430 0 0
Month 11 19,370 49,560 0 0
Month 12 22,350 49,560 0 0
Total 4th Quarter 59,600 144,550 198,155 362,900
Total for year 149,000 413,000 702,550 1,241,500

General & Administrative by Months & Quarters


($)
Year 1 Year 2 Year 3 Year 4
Month 1 0 23,258 0 0
Month 2 0 23,258 0 0
Month 3 0 32,561 0 0
Total 1st Quarter 0 79,076 162,073 220,049
Month 4 8,583 27,909 0 0
Month 5 13,733 32,561 0 0
Month 6 17,167 32,561 0 0
Total 2nd Quarter 39,483 93,030 202,591 293,399
Month 7 17,167 37,212 0 0
Month 8 20,600 46,515 0 0
Month 9 25,750 46,515 0 0
Total 3rd Quarter 63,517 130,242 202,591 330,074
Month 10 20,600 51,167 0 0
Month 11 22,317 55,818 0 0
Month 12 25,750 55,818 0 0
Total 4th Quarter 68,667 162,803 222,851 348,411
Total for year 171,667 465,150 790,107 1,191,933
26,000,000

816,000
1,300,000
1,000,000

1,560,000
4,676,000
18.0%

784,800
266,667
200,000

520,000

1,771,467
6.8%

Year 5
0
0
0
899,231
0
0
0
1,079,077
0
0
0
1,258,923
0
0
0
1,438,769 Note: total expenses for the year must
4,676,000 equal the annual projections above.

Year 5
0
0
0
336,923
0
0
0
404,308
0
0
0
471,692
0
0
0
539,077 Note: total expenses for the year must
1,752,000 equal the annual projections above.

Year 5
0
0
0
340,667
0
0
0
408,800
0
0
0
476,933
0
0
0
545,067 Note: total expenses for the year must
1,771,467 equal the annual projections above.

You might also like