5454542121 Cor rigé T D 1 - cou rs PRO MOTION IMM OBILIERE

	A	B	C	D	E	F	G	H	I	J	K	L	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AV
1	OPERATION	COURS PROMOTION IMMOBILIERE					BILAN PREVISIONNEL 1
2
3								VALEUR			en	EUROS		studio	25
4								RESPONSABLE						2p	37
5								MISE A JOUR		11/5/11				3p	60
6														4p	86
7	PROGRAMME	SURFACE TERRAIN		3,654		PROGRAMME	TOTAL	LOGEMENTS		COMMERCES	ACTIVITES	RESERVES		5p	100
8		COS LOGEMENTS		2.50		SHON AUTOR.	9,135							6p	120
9
10						Surf. Habitable	7,765
11		SHON AUTORISEE		9,135		Coef. RendemT	85.00%
12						Surface Moy App.	67
13						NB. LGTS.	116
14						NB. PK	116
15
16	RECETTES	LOGEMENTS	Nb	m² SHA	Pv m2 ha	TOTAL TTC
17		Appartements	116	7,765	4,000	31,060,000
18
19
20
21
22		TOTAL
23
24
25		PK	Nb	Pv UNITE		TOTAL TTC
26		Parking	116	12,500		1,450,000
27
28		TOTAL RECETTES TTC				32,510,000
29													BAT A	BAT B	BAT C	BAT D	BAT E1	BAT E2	BAT F	BAT G	BAT H	TOTAL
30										TOTAL HT	TVA	TOTAL TTC	1,542	1,365	2,700	1,951	2,487	2,418	2,103	1,521	1,592	17,679
31	TOTAL RECETTES OPERATION									27,182,274		32,510,000
32
33	PRIX DE REVIENT									TOTAL HT	TVA	TOTAL TTC
34	FONCIER	TERRAIN			HT m2 SHON PROJET					1,366,500	267,834	1,634,334	142,550	126,187	249,601	180,360	229,911	223,532	194,412	140,609	147,172	1,634,334
35		NOTAIRE			2.00%	du terrain HT				27,330	5,357	32,687	2,851	2,524	4,992	3,607	4,598	4,471	3,888	2,812	2,943	32,687
36		DATION			3.00%	du terrain HT				40,995	8,035	49,030	4,277	3,786	7,488	5,411	6,897	6,706	5,832	4,218	4,415	49,030
37		INTERMEDIAIRE			3.5%	du terrain HT				47,828	9,374	57,202	4,989	4,417	8,736	6,313	8,047	7,824	6,804	4,921	5,151	57,202
38		Recherche archéologiques				valeur				10,000	1,960	11,960	1,043	923	1,827	1,320	1,682	1,636	1,423	1,029	1,077	11,960
39		REDEVANCE pour PK manquants								0	0	0	0	0	0	0	0	0	0	0	0	0
40		PLD > 1,8 sur la base de valeur de terrain décl.					m2 nu et libre			0	0	0											#REF!
41		TLE catégorie 5		m2	9,135	valeur	112 €	taux	4.23%	43,278	0	43,278	3,775	3,342	6,610	4,776	6,088	5,919	5,148	3,723	3,897	43,278
42		BRANCHEMENTS					0			10,000	1,960	11,960	1,043	923	1,827	1,320	1,682	1,636	1,423	1,029	1,077	11,960
43		SONDAGE								10,000	1,960	11,960	1,043	923	1,827	1,320	1,682	1,636	1,423	1,029	1,077	11,960
44		DEMOLITION								10,000	1,960	11,960	1,043	923	1,827	1,320	1,682	1,636	1,423	1,029	1,077	11,960
45		VRD EXTERIEURES			LGTS					50,000	9,800	59,800	5,216	4,617	9,133	6,599	8,412	8,179	7,113	5,145	5,385	59,800
46							TOTAL FONCIER			1,615,930	308,240	1,924,170	167,830	148,566	293,866	212,346	270,683	263,173	228,889	165,545	173,272	1,924,170	#REF!
47	COUT	CONST.LGTS.		1,500 €	HT m2 shon					13,702,500	2,685,690	16,388,190	1,429,413	1,265,336	2,502,863	1,808,550	2,305,415	2,241,453	1,949,452	1,409,946	1,475,762	16,388,190
48	TECHNIQUE	CONST.ACTIVITES			HT m2 SU					0	0	0	0	0	0	0	0	0	0	0	0	0
49		CONST.COMM.			HT m2 SU					0	0	0	0	0	0	0	0	0	0	0	0	0
50		CONST. PARKINGS		15000	116					1,740,000	341,040	2,081,040	181,513	160,678	317,824	229,657	292,751	284,629	247,549	179,041	187,398	2,081,040
51		ALEAS SUR TRAVAUX		taux	2.00%	des travaux				308,850	60,535	369,385	32,219	28,520	56,414	40,764	51,963	50,522	43,940	31,780	33,263	369,385
52							sous total construction			15,751,350	3,087,265	18,838,615	1,643,144	1,454,534	2,877,100	2,078,971	2,650,129	2,576,603	2,240,942	1,620,767	1,696,424	18,838,615
53		MO Conception		3.00%	HT des travaux HT					472,541	92,618	565,158	49,294	43,636	86,313	62,369	79,504	77,298	67,228	48,623	50,893	565,158
54		MO exécution		3.00%	HT des travaux HT					472,541	92,618	565,158	49,294	43,636	86,313	62,369	79,504	77,298	67,228	48,623	50,893	565,158
55		ETUDE DE SOL/geomètre								8,000	1,568	9,568	835	739	1,461	1,056	1,346	1,309	1,138	823	862	9,568
56		BET		1.00%	HT des travaux HT					157,514	30,873	188,386
57		COOR. SECURITE		0.50%	HT des travaux TTC					94,193	18,462	112,655
58		ASSURANCES		3.00%	des travaux TTC et honoraires					599,068	117,417	716,485	62,493	55,320	109,424	79,069	100,792	97,995	85,229	61,642	64,520	716,485
59		CONTROLE		0.50%	HT des travaux TTC					94,193	18,462	112,655	9,826	8,698	17,205	12,432	15,848	15,408	13,401	9,692	10,145	112,655
60							sous total honoraires			1,898,049	372,018	2,270,066	198,000	175,272	346,693	250,518	319,342	310,482	270,035	195,303	204,420	2,270,066
61							TOTAL COUTS TECHNIQUES			17,649,399	3,459,282	21,108,681	1,841,144	1,629,807	3,223,793	2,329,489	2,969,472	2,887,086	2,510,977	1,816,070	1,900,844	21,108,681	6,178,727
62	FRAIS	GESTION LGTS.		7.00%	HT DU CA TTC					2,275,700	446,037	2,721,737	237,396	210,146	415,673	300,363	382,881	372,259	323,763	234,163	245,093	2,721,737	19.01%
63	ANNEXES	GESTION ACTIVITES			HT PV HT					0	0	0	0	0	0	0	0	0	0	0	0	0
64		COMMERC. LGTS.		4.00%	HT PV TTC					1,300,400	254,878	1,555,278	135,655	120,083	237,528	171,636	218,789	212,719	185,008	133,807	140,053	1,555,278
65		COMMERC. BUREAUX			HT PV HT					0	0	0	0	0	0	0	0	0	0	0	0	0
66		COMMERC. COMM.			HT PV HT	3.50%				0	0	0	0	0	0	0	0	0	0	0	0	0
67		PUBLICITE		2.50%	HT DU CA TTC					812,750	159,299	972,049	84,784	75,052	148,455	107,272	136,743	132,950	115,630	83,630	87,533	972,049
68		FRAIS DIVERS		1.00%	HT PV HT					271,823	53,277	325,100	28,356	25,101	49,650	35,877	45,734	44,465	38,672	27,970	29,275	325,100
69		GARANTIE D'ACHEV.		0.60%	DU CA TTC					195,060	38,232	233,292	20,348	18,013	35,629	25,745	32,818	31,908	27,751	20,071	21,008	233,292
70		COMM.ENGAGEMENT		0.35%	DU COUT TECHNIQUE TTC					73,880	14,481	88,361	7,707	6,822	13,495	9,751	12,430	12,085	10,511	7,602	7,957	88,361
71		FRAIS FINANCIERS		2.50%	DU CA TTC					812,750	159,299	972,049	84,784	75,052	148,455	107,272	136,743	132,950	115,630	83,630	87,533	972,049
72							TOTAL FRAIS ANNEXES			5,742,363	1,125,503	6,867,866	599,030	530,270	1,048,885	757,917	966,140	939,335	816,965	590,872	618,454	6,867,866	6,867,866
73													0	0	0	0	0	0	0	0	0	0	21.13%
74								PX DE REVIENT		25,007,692	4,893,025	29,900,717	2,608,004	2,308,642	4,566,544	3,299,751	4,206,295	4,089,594	3,556,831	2,572,487	2,692,570	29,900,717
75													0	0	0	0	0	0	0	0	0	0
76								RECETTES		27,182,274	5,327,726	32,510,000	2,835,591	2,510,105	4,965,043	3,587,703	4,573,357	4,446,472	3,867,217	2,796,974	2,927,537	32,510,000
77													0	0	0	0	0	0	0	0	0	0
78								MARGE		2,174,582			0	0	0	0	0	0	0	0	0	0
79
80								TAUX MARGE		8%
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100