MAKE A COPY - ICE VENDING P&L

	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4
5	Ice Vending
6
7		Startup Costs			Financing			Instruction.
8		Item	Cost		Item	Cost		Change cells in this color.
9		Vending Machine	$175,000		Amount	$30,000		If a cost does not apply, leave as 0.
10		Delivery	$100,000		Downpayment	$2,000		*Disclaimer: Note these costs can vary by location. Do your own
11		Total Cost	$275,000		Loan Interest	7%		research to come up with figures for your specific
12					Loan Term	6		situation.
13					Monthly payment	$416
14
15		10 year projections
16	Total pounds	Avg Vends/Day		10lb	15	20lb	5		Seasonality
17	10	Avg vend price			$1.75		$3.00		# of non seasonal months	3
18	4200	Vends /week			105		35		Non season month decrease	60%	756	$1,323.00
19	20	Vends / month			420		140
20	2800	Vends / year			5040		1680
21	7000	Year	1	2	3	4	5	6	7	8	9	10
22	3.5	Gross Income
23		Ice vends	6720	6720	6720	6720	6720	6720	6720	6720	6720	6720
24		GAI	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00	$16,800.00
25		Less seasonal %	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00	$1,323.00
26		Total Income	$4,971.00	$4,971.00	$4,971.00	$4,971.00	$4,971.00	$4,971.00	$9,963.00	$9,963.00	$9,963.00	$9,963.00
27
28		Operating Expenses
29		Service/Maintenance	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100
30		Site Rental	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300
31		Loan	$416	$416	$416	$416	$416	$416	0	0	0	0
32		Bags $0.10	$56.00	$56.00	$56.00	$56.00	$56.00	$56.00	$56.00	$56.00	$56.00	$56.00
33	$0.05/100lb ice	Utilities	$4	4	4	4	4	4	4	4	4	4
34		Total Costs	$10,506	10506	10506	10506	10506	10506	5514	5514	5514	5514
35
36
37
38
39
40
41
42
43
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