Copy of Proforma Template3.xlsx

	A	B	C	D	E	F	G	H
1	Table 1
2

3		Land
4		Lot Size	Insert the area of the parcel(s) of your choice in sqf	12,000.00	12,000.00	12000	12000
5
6		FSR		1.00	2	3	4	etc.
7		Buildable square feet	Is the result of your FSR X the parcel area (how much you can build)	12,000.00	24,000.00	36000	48000
8		Unit size	Size of your dwelling unit at your choice	1,000.00	1,000.00	1000	1000
9		Numer of units		12.00	24.00	36.00
10		Costs
11		Land Cost	Is the result of you lot size X $400 a sqf we are considering	4,800,000.00	4,800,000.00	4,800,000	4,800,000	4,800,000
12		Operating Costs.	25 percent to be met by rents
13		Hard costs	$300 per buildable sqf	3,600,000.00	7,200,000.00	10,800,000.00	14,400,000.00	0.00
14		Soft costs	$75 per buildable sqf	900,000.00	1,800,000.00	2,700,000.00	3,600,000.00	0.00
15		Total Construction Cost		4,500,000.00	9,000,000.00	13,500,000.00	18,000,000.00	0.00
16		Total Cost	Land Cost + Total Construction Cost	9,300,000.00	13,800,000.00	18,300,000.00	22,800,000.00	4,800,000.00
17
18		Loan
19		Loan amount		9,300,000.00	13,800,000.00	18,300,000.00
20		Monthly pay		26,132.74	38,777.62	51,419.68	<Use amortization tables at 2% over 45 years to compute this number	https://www.amortization-calc.com/
21		Operating costs	city taxes and maintenance @ 25 percent of monthly mortgage costs	6,533.19	9,694.41	12,854.92
22		Total monthly	Mortgage plus operating	32,665.93	48,472.03	64,274.60
23		Monthly revenue
24		Unit rent at HIL levels	$1,688 for a 2 bedroom maximum	13,504.00	30,384.00	33,760.00
25		Unit rent at Market Levels	$2,200 for a 2 bedroom - market levels	8,800.00	13,200.00	33,000.00
26		Total revenue in Rent		22,304.00	43,584.00	66,760.00	0.00
27		ROI (target 6% of revenue.)		-10,361.93	-4,888.03	2,485.40
28
29
30
31
32
33
34
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