1 Cost -Stage 1- January 2023 -Paco

	#	Concept	Units	Quantity	Price	Row Total	Concept Total	A	B	C
	Collaboration powered by Smartsheet   |   Report Abuse
1									$1,800,000.00
2	1	Soft Costs					$72,000.00	5%
3		Design and Engineering	each	1%	$1,800,000.00	$18,000.00
4		Permits and Licenses	each	1%	$1,800,000.00	$18,000.00
5		Legal and Business Mexico	each	2%	$1,800,000.00	$36,000.00
6
7	2	Preliminary					$68,500.00	5%
8		Surveyor crew	days	30	$150.00	$4,500.00
9		Perimeter Fence. Posts @ 3.00 meters . Height 1.50	m	2000	$7.00	$14,000.00
10		Green barriers	m	1000	$25.00	$25,000.00
11		Perimeter running/ bike trail	m	2500	$10.00	$25,000.00
12
13	3	Association Hub					$140,000.00	11%
14		Building 24 -Offices, maintenance, employees	m2	200	$500.00	$100,000.00
15		Entrance buildings		60	$500.00	$30,000.00
16		Infrastructure		1	$10,000.00	$10,000.00
17
18	4	Green House Facility	sqm	220	$200.00	$44,000.00	$44,000.00	3%
19
20	5	Country Club Residential	sqm	150	$800.00	$120,000.00	$120,000.00	9%
21
22	6	Sports Facilities					$200,000.00	15%
23		Tennis courts	each	2	$20,000.00	$40,000.00
24		Pickle ball courts	each	2	$10,000.00	$20,000.00
25		Pool	sqm	400	$200.00	$80,000.00
26		7vs7 soccer		1	$12,000.00	$12,000.00
27		Restroom and cafeteria	sqm	80	$600.00	$48,000.00
28
29	7	Roads	m2	13000			$336,680.00	26%
30		Excavation and removal of top soil	m3	3900	$5.00	$19,500.00
31		Transporting Top soil	m3	5460	$8.00	$43,680.00
32		20 centimeters base for the gravel road, including compact of the soil and grading	m3	2600	$35.00	$91,000.00
33		25 centimeters Gravel	m3	3250	$50.00	$162,500.00
34		Retaining walls using local stone . 3' height	m	500	$40.00	$20,000.00
35
36	8	Water System	each	41			$50,600.00	4%
37		4" Main supply line	m	600	$21.00	$12,600.00
38		2" secondary lines	m	1500	$12.00	$18,000.00
39		Water tank and pump house	each	1	$15,000.00	$15,000.00
40		Pump equipment	each	1	$5,000.00	$5,000.00
41
42	9	Internet Infrastructure	each	41	$750.00	$30,750.00	$30,750.00	2%
43
44	10	Electric: 50 amps per house	each	41	$4,000.00	$164,000.00	$164,000.00	13%
45
46	11	Sewer System					$63,000.00	5%
47		6" - 4" PVC pipe main lines	m	1400	$20.00	$28,000.00
48		Recirculating sand system plant	each	1	$25,000.00	$25,000.00
49		Trench drain field	m2	1000	$10.00	$10,000.00
50
51	12	Infrastructure Public Areas	each	1	$20,000.00	$20,000.00	$20,000.00	2%
52									Cost square meter
53						Development	$1,309,530.00	$31,939.76	53.23
54
55
56	13	Zona Federal & Club de Playa					$568,000.00	$13,853.66	23.09
57		Federal land and fisherman's wharf improvement	sqm	2000	$50.00	$100,000.00
58
59		Beach Club, restaurant and pool
60		Restaurant	sqm	120	$900.00	$108,000.00
61		Spa Facilities	sqm	200	$1,000.00	$200,000.00
62		Pool	sqm	600	$200.00	$120,000.00
63		Infrastructure beach club	each	1	$20,000.00	$20,000.00
64		Landscaping and trees	sqm	400	$50.00	$20,000.00
65
66
67
68								Cost per lot	Cost square meter
69						COST = Development + Beach + Federal Zone	$1,877,530.00	$45,793.41	76.32
70
71				Lot Size SQM	600			Per Lot	Cost square meter
72				Land (proportional)	0.263	24,600	$92,085.56	2,245.99	$3.74
73
74
75						Development + Land	$1,969,615.56	Lot Sales Price	Lot Sales Price SQM
76					Profit percentaje	22%	$2,525,148.16	$61,588.98	102.65
77						LESS SALES COMMISSION	3%	$59,741.31
78						Revenue Lots	$499,979.33
79
80								Construction SQM	Construction SQFT
81		HOME				Construction HOME	$181,562.50	$1,068.01	$99.22
82		House (1800 sqft)	sqm	170	$650.00	$110,500.00
83		Solar panels for 200 amps -20 solar panels-	each	1	$25,000.00	$25,000.00
84		1000 Gallons septic tank	each	1	$1,000.00	$1,000.00
85		Landscaping and miscellaneous	sqm	350	$25.00	$8,750.00
86		Construction administration	%	0.2	$145,250.00	$36,312.50
87
88						Land and building	$243,151.48
89						Revenue Construction	$1,452,500.00
90
91						Revenue Land + Homes	$1,952,479.33
92
93		OPERATIONS OF THE PROPERTY
94
95			QTTY	Month	Annual	Benefits	Total
96
97		Administrator	1	$500.00	$6,000.00	50%	$9,000.00
98		Assistance	1	$300.00	$3,600.00	50%	$5,400.00
99		Landscape and Maintainance	2	$300.00	$7,200.00	50%	$10,800.00
100		Security	4	$300.00	$14,400.00	50%	$21,600.00
101		Beach Club	3	$300.00	$10,800.00	50%	$16,200.00
102		Country Club	2	$300.00	$7,200.00	50%	$10,800.00
103		Insurance	%		$1,877,530.00	0.50%	$9,387.65
104		Utilities	%		$1,877,530.00	1.00%	$18,775.30
105		Maintainance	%		$1,877,530.00	1.50%	$28,162.95
106		Property taxes common area	%		$1,877,530.00	0.50%	$9,387.65
107
108							$139,513.55	Per Lot / Per month	283.56
109							Profit	25%	354.46
110
111		As of 03/27/23
112		Nicely		$50,000.00	17.99%
113		Amor		$27,000.00	9.72%
114		Cruz		$103,068.19	37.09%
115		Knights		$50,000.00	17.99%		Caballeros	$0.35
116		ThemeX		$40,000.00	14.40%
117		BKnight		$7,800.00	2.81%
118
119				$277,868.19	$1.00
120
121					Key money (Permits, zoning, marketing, etc.)	Existing Shares	New Equity Contribution (Payment of the land)	Total Equity	Shares
122		Nicely		$50,000.00		18%		$50,000.00	11%
123		Amor		$27,000.00		10%	$3,000.00	$30,000.00	7%
124		Cruz		$103,068.19		37%	$75,000.00	$178,068.19	39%
125		Knights		$50,000.00		18%	$0.00	$50,000.00	11%
126		PKnight		$40,000.00		14%	$100,000.00	$140,000.00	31%
127		BKnight		$7,800.00		3%	$1,200.00	$9,000.00	2%
128		Partner A			$0.00		$0.00	$0.00	0%
129		Partner B			$0.00		$0.00	$0.00	0%
130		Partner C			$0.00		$0.00	$0.00	0%
131		Partner D			$0.00		$0.00	$0.00	0%
132		Partner E			$0.00		$0.00	$0.00	0%
133		Partner F			$0.00		$0.00	$0.00	0%
134
135				$277,868.19	$0.00	$1.00	$179,200.00	$457,068.19	$1.00
136
137
138
139
140				Sep 30 2023	Pagos 2027	Total	Final Shares
141
142		Beto y Mila		$631,365.40	$555,750.00	$1,187,115.40	13.18%
143		Paco and Susy		$1,200,000.00	$2,929,276.66	$4,129,276.66	45.86%	59.04%
144		Spencer y Lori		$1,051,250.00		$1,051,250.00	11.67%
145		Ruben y Conchita		$2,037,000.00		$2,037,000.00	22.62%
146		Elena		$600,000.00		$600,000.00	6.66%
147
148				$5,519,615.40	$3,485,026.66	$9,004,642.06	$1.00
149
150					Price in Dlls	$529,684.83	$17.00
151					Price per square meter	$3.12