Potential Income For TaxiTop Units Calculator

	A	B	C	D	F	G	H	I	J
1
2	Estimated Potential Income for TaxiTop Units Calculator		Total Qty Year 1		Total Qty Year 2			Total Qty Year 3
3			70		100			150
4	Entre number of taxicabs		70		100			150
5
6			Year 1		Year 2			Year 3
7	Estimated cost:		QTY or $		QTY or $			QTY or $
8		Quantity of rooftop LED displays purchased*	50		30			30
9		Quantity of rooftop LEDdisplays installed	25		30			30
10		Number of headrest displays purchased*	0		30			30
11		Number of headrest displays installed	0		0			0
12		Total cost of purchase of LED rooftop diplays ($1,800 ea)	$1,800.00	$36,000.00	$1,800.00	$54,000.00		$1,800.00	$54,000.00
13		Total cost of purchase of headsent diplays ($150 ea)	$300.00	$6,000.00	$300.00	$9,000.00		$300.00	$9,000.00
14		Totl Cost of Data + DigitStream Subscription per unit	$60	$14,400.00	$60	$21,600.00		$60	$21,600.00
15		Other expenses (installation fee, Wi-Fi, racks, etc.)		$5,000.00		$7,500.00			$7,500.00
16
17		Total cost		$61,400.00		$92,100.00			$92,100.00
18
19	Estimated income:
20		Potential Income generated per taxicab per month (16hrs)	$1,106.10		$1,106.10			$1,106.10
21		Total income generated in the first year		$265,462.60		$663,656.50			$1,061,850.30
22
23	Estimated net profit:			$204,062.60		$571,556.50			$969,750.30
24
25	Cash Profit			$111,962.60		$479,456.50			$969,750.30
26
27
28
29
30	This analysis is done for the first year
31	Number of taxicabs needed to breakeven assuming each generates $750/month			4.626			Assumptions
32							Digital Ad CMP Rate		$12.50
33	Return per taxicab per month at breakeven			$255.80			Enter your city population		1,100,000.00
34	Estimeted CPM at breakeven			$2.89			Estimate CPM for your location		$5.00
35	Avg CPM	cost per thousand impressions (every 10 second video is 1 impression)		$8.00			Impression Generated Per Taxi		20,160.00
36							Hous Per Day Car Runs Ads		8
37
38	Assumptions:
39	You are able to place a full inventory of ads to your system for all taxis
40	Charge a CPM rate as per highlighted cell
41	Prices vary from location to location, examples are given for Buffalo, New York and similar sized cities
42	Cost of hardware and other expenses are approximate and need to be determined for your location
43	Cost of Data assumes its $50/month for 3G and $10/month for Enroute Subscription platform
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100