Metrovitalization Single Family Home Financial Pro Forma Summary v.1.xlsx

	A	B	D	E
1
2
3
4
5	SINGLE FAMILY HOME DEVELOPMENT PROJECT
6	FINANCIAL PRO FORMA SUMMARY
7
8	PROJECT COSTS		FINANCIAL SUMMARY
9
10	ACQUISITION COSTS	Total	Uses of Funds	Total
11	Land cost	$ 30,000	Acquisition Costs	$ 38,350
12	Broker fees	$ 2,500	Hard Costs	$ 298,298
13	Survey (ALTA)	$ 500	Soft Costs	$ 51,150
14	Appraisal	$ 350	Total Uses of Funds	$ 387,798
15	Closing costs, legal fees, title	$ 5,000
16	Total Acquisition Costs	$ 38,350	Sources of Funds	Total
17			Construction Loan	$ 329,628
18	HARD COSTS	Total	Equity Investment	$ 58,170
19	Site work and temporary utilities	3,800	Total Sources of Funds	$ 387,798
20	Excavation and foundations	26,400
21	Flatwork and slabs	14,600
22	Framing, roof, windows and siding	48,200
23	Rough plumbing, electrical and HVAC (MEPs)	32,300
24	Insulation and drywall	18,200
25	Floors, doors and interior trim	24,350
26	Kitchen and bathrooms	27,480
27	Electrical fixtures	8,800
28	Plumbing fixtures	2,850
29	Paint and clean	7,900
30	Appliances	4,300
31	HVAC systems (furnace and air conditioning)	5,200
32	Garage (turn-key)	28,500
33	Exterior features and lighting	6,900
34	Utility connections	2,800
35	Read deck and patio	6,800
36	Landscaping	1,800
37	Contingency (10%)	27,118
38	TOTAL HARD COSTS	$ 298,298
39
40	SOFT COSTS	Total
41	Architecture & engineering (MEP, struct, landscp)	7,500
42	Surveys	800
43	Soils reports	1,200
44	Permit fees	4,500
45	Legal	1,200
46	Builders risk and general liability insurance	2,500
47	Third-party inspection fees	850
48	Property taxes during construction	500
49	Accounting and bookkeeping	250
50	Municipal impact fees	2,200
51	Financing fees and interest reserve	25,000
52	Soft Cost contingency (10%)	4,650
53	TOTAL SOFT COSTS	$ 51,150
54
55	TOTAL PROJECT COST	$ 387,798
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			HARD COSTS	Total
87			PROPERTY 1 - SITE WORK
88			Demolition, site clearing and fencing (budget)
89			Earthwork, grading, site work (budget)
90			Temporary utilities
91			Civil and infrastructure
92			General conditions
93			Sub Total - Site Work
94
95			PROPERTY 1 - BUILDINGS "A" & "B" - STUDENT HOUSING
96			Building "A" vertical construction
97			Building "B" vertical construction
98			Parking lot and exterior features (budget)
99			Landscaping, exterior lighting and signage (budget)
100			Contingency