ss:Formula="=SUM(Assumptions!R[196]C[27]:R[196]C[38])*RC[-2]">190475.37127416593
413030.37044440175 |
489653.29684305738 |
106745.89711437505 |
Permits |
3000000 |
0 |
450000.00000000006 |
2550000 |
0 |
0 |
Water & Sewer and Impact Fees |
5350000 |
0 |
5350000 |
0 |
0 |
0 |
Property Taxes |
340000 |
340000 |
0 |
0 |
0 |
0 |
Legal/Outside Accounting |
400000 |
270000 |
130000.00000000009 |
0 |
0 |
0 |
General and Administrative |
359971.34096399997 |
359971.34096399997 |
0 |
0 |
0 |
0 |
Pre-Opening Expenses |
7040099 |
0 |
1760024.75 |
1760024.75 |
1760024.75 |
1760024.75 |
Soft Cost Contingency |
449799.50553280005 |
0 |
112449.75276653589 |
112449.75276653589 |
112449.75276653589 |
112449.75276653589 |
Total Soft Costs |
22939774.782172803 |
4969971.3409639997 |
8232949.8740407014 |
5035504.8732109377 |
2542127.7996095936 |
2159220.3998809112 |
|
|
|
|
|
|
|
|
|
Hard-Costs |
|
|
|
|
|
|
GENERAL REQUIREMENTS |
6200000 |
0 |
558000 |
1984000.0000000005 |
2294000 |
1364000 |
Existing Conditions |
0 |
0 |
0 |
0 |
0 |
0 |
Concrete |
74524546.446153805 |
0 |
19376382.07599999 |
31300309.507384591 |
23847854.862769209 |
0 |
Masonry |
2675713 |
0 |
0 |
1364613.6300000004 |
1311099.3700000001 |
0 |
Metals |
14121363.2600684 |
0 |
2118204.48901026 |
5648545.304027359 |
5648545.304027359 |
706068.16300341999 |
Wood, Plastics, and Composites |
906817.85 |
0 |
0 |
544090.71 |
317386.2475 |
45340.892500000009 |
Thermal and Moisture Protection |
2539867.5499999998 |
0 |
507973.51 |
253986.755 |
1320731.1259999997 |
457176.15899999993 |
Openings |
25942126.323958199 |
0 |
1297106.3161979101 |
9079744.2133853696 |
14268169.478177007 |
1297106.3161979101 |
Finishes |
18084415 |
0 |
0 |
2712662.2500000005 |
10850649 |
4521103.7499999991 |
Specialties |
749782.94 |
0 |
0 |
0 |
299913.17599999998 |
449869.76399999997 |
Equipment |
3135682 |
0 |
0 |
0 |
1881409.2 |
1254272.7999999998 |
Furnishings |
1722007 |
0 |
0 |
258301.05 |
1033204.2 |
430501.74999999994 |
Special Construction |
1228743 |
0 |
0 |
0 |
860120.10000000009 |
368622.89999999997 |
Conveying Equipment |
15336377.890000001 |
0 |
1533637.7890000001 |
8435007.8394999988 |
3680730.6935999994 |
1687001.5678999999 |
Fire Suppression |
2722500 |
0 |
54450 |
898424.99999999988 |
1361249.9999999998 |
408375.00000000006 |
Plumbing |
6159300 |
0 |
123186 |
2032568.9999999998 |
3695580 |
307965 |
HVAC |
14750000 |
0 |
0 |
5162500 |
8112499.9999999991 |
1474999.9999999998 |
Electrical |
15464438.5 |
0 |
1855732.6199999999 |
4175398.3949999996 |
6804352.9399999985 |
2628954.5450000004 |
Communications |
500000 |
0 |
0 |
199999.99999999997 |
199999.99999999997 |
99999.999999999985 |
Earthwork |
6900283 |
0 |
6072249.0399999982 |
0 |
0 |
828033.96000000008 |
Exterior Improvements |
645432.35 |
0 |
0 |
0 |
0 |
645432.35000000009 |
Utilities |
815571 |
0 |
652456.80000000028 |
0 |
0 |
163114.19999999998 |
Construction Contingency |
4302499 |
0 |
1075624.75 |
1075624.75 |
1075624.75 |
1075624.75 |
Subcontractor Default Insurance |
1742512.2335924611 |
0 |
1742512.4671849532 |
0 |
0 |
0 |
Builders Risk Insurance |
2000000 |
0 |
317484.10329999396 |
688438.48902364832 |
816153.48397112382 |
177923.92370523381 |
Insurance Program (Owner to Provide Insurance Requirements) |
1400000 |
0 |
499999.99999999994 |
299999.99999999988 |
299999.99999999988 |
299999.99999999988 |
CM Payment and Performance Bond |
2000000 |
0 |
2000000 |
0 |
0 |
0 |
Warranty Reserve |
750000 |
0 |
0 |
0 |
0 |
750000 |
General Conditions (Reduced GCs Due to Okan Staffing) |
13500000 |
0 |
2399999.9999999995 |
3800000.0000000005 |
5000000.0000000009 |
2300000 |
Total Hard Costs |
240819978.34377286 |
0 |
42184999.960693106 |
79914216.893320963 |
94979273.9320447 |
23741487.791306566 |
|
|
|
|
|
|
Sales, Marketing and Other Costs and Schedule |
|
|
|
|
|
|
Marketing & Admin |
5000000 |
0 |
2250000 |
1000000 |
500000 |
1250000 |
Sales Commission (Pre-Operations) |
3166450.0000000005 |
0 |
1424902.5 |
633290.00000000012 |
316645.00000000006 |
791612.50000000012 |
Total Sales and Marketing Costs |
8166450 |
0 |
3674902.5 |
1633290 |
816645 |
2041612.5 |
|
|
|
|
|
|
|
Transaction Costs |
3062835.5753630386 |
0 |
3062835.5753630386 |
0 |
0 |
0 |
|
|
|
|
|
|
|
Total Construction Costs (including Land of $ 20,000,000) |
294989038.70130873 |
4969971.3409639997 |
57155687.910096847 |
86583011.7665319 |
98338046.731654286 |
27942320.691187479 |
|
|
|
SheetHidden
600
600
85
15
3
48
9
False
False
Cost Breakup |
Total Costs |
Pre Construction |
2020 |
2021 |
2022 |
2023 |
|
|
|
|
|
Soft-Costs |
|
|
|
|
|
|
Architectural, Design, Engineering |
4800000 |
4000000 |
239999.99999999997 |
200000.00000000006 |
180000 |
180000 |
Inspections |
1199904.9356760001 |
0 |
190475.37127416593 |
413030.37044440175 |
489653.29684305738 |
106745.89711437505 |
Permits |
3000000 |
0 |
450000.00000000006 |
2550000 |
0 |
0 |
Water & Sewer and Impact Fees |
5350000 |
0 |
5350000 |
0 |
0 |
0 |
Property Taxes |
340000 |
340000 |
0 |
0 |
0 |
0 |
Legal/Outside Accounting |
400000 |
270000 |
130000.00000000009 |
0 |
0 |
0 |
General and Administrative |
359971.34096399997 |
359971.34096399997 |
0 |
0 |
0 |
0 |
Pre-Opening Expenses |
7040099 |
0 |
1760024.75 |
1760024.75 |
1760024.75 |
1760024.75 |
Soft Cost Contingency |
449799.50553280005 |
0 |
112449.75276653589 |
112449.75276653589 |
112449.75276653589 |
112449.75276653589 |
Other Soft Costs |
5749675.7821728 |
969971.34096399997 |
882925.12404070201 |
3075480.1232109377 |
602103.04960959323 |
219195.64988091093 |
Total Soft Costs |
22939774.782172803 |
4969971.3409639997 |
8232949.8740407014 |
5035504.8732109377 |
2542127.7996095936 |
2159220.3998809112 |
|
|
|
|
|
|
|
|
|
Hard-Costs |
|
|
|
|
|
|
GENERAL REQUIREMENTS |
6200000 |
0 |
558000 |
1984000.0000000005 |
2294000 |
1364000 |
Existing Conditions |
0 |
0 |
0 |
0 |
0 |
0 |
Concrete |
74524546.446153805 |
0 |
19376382.07599999 |
31300309.507384591 |
23847854.862769209 |
0 |
Masonry |
2675713 |
0 |
0 |
1364613.6300000004 |
1311099.3700000001 |
0 |
Metals |
14121363.2600684 |
0 |
2118204.48901026 |
5648545.304027359 |
5648545.304027359 |
706068.16300341999 |
Wood, Plastics, and Composites |
906817.85 |
0 |
0 |
544090.71 |
317386.2475 |
45340.892500000009 |
Thermal and Moisture Protection |
2539867.5499999998 |
0 |
507973.51 |
253986.755 |
1320731.1259999997 |
457176.15899999993 |
Openings |
25942126.323958199 |
0 |
1297106.3161979101 |
9079744.2133853696 |
14268169.478177007 |
1297106.3161979101 |
Finishes |
18084415 |
0 |
0 |
2712662.2500000005 |
10850649 |
4521103.7499999991 |
Specialties |
749782.94 |
0 |
0 |
0 |
299913.17599999998 |
449869.76399999997 |
Equipment |
3135682 |
0 |
0 |
0 |
1881409.2 |
1254272.7999999998 |
Furnishings |
1722007 |
0 |
0 |
258301.05 |
1033204.2 |
430501.74999999994 |
Special Construction |
1228743 |
0 |
0 |
0 |
860120.10000000009 |
368622.89999999997 |
Conveying Equipment |
15336377.890000001 |
0 |
1533637.7890000001 |
8435007.8394999988 |
3680730.6935999994 |
1687001.5678999999 |
Fire Suppression |
2722500 |
0 |
54450 |
898424.99999999988 |
1361249.9999999998 |
408375.00000000006 |
Plumbing |
6159300 |
0 |
123186 |
2032568.9999999998 |
3695580 |
307965 |
HVAC |
14750000 |
0 |
0 |
5162500 |
8112499.9999999991 |
1474999.9999999998 |
Electrical |
15464438.5 |
0 |
1855732.6199999999 |
4175398.3949999996 |
6804352.9399999985 |
2628954.5450000004 |
Communications |
500000 |
0 |
0 |
199999.99999999997 |
199999.99999999997 |
99999.999999999985 |
Earthwork |
6900283 |
0 |
6072249.0399999982 |
0 |
0 |
828033.96000000008 |
Exterior Improvements |
645432.35 |
0 |
0 |
0 |
0 |
645432.35000000009 |
Utilities |
815571 |
0 |
652456.80000000028 |
0 |
0 |
163114.19999999998 |
Construction Contingency |
4302499 |
0 |
1075624.75 |
1075624.75 |
1075624.75 |
1075624.75 |
Subcontractor Default Insurance |
1742512.2335924611 |
0 |
1742512.4671849532 |
0 |
0 |
0 |
Builders Risk Insurance |
2000000 |
0 |
317484.10329999396 |
688438.48902364832 |
816153.48397112382 |
177923.92370523381 |
Insurance Program (Owner to Provide Insurance Requirements) |
1400000 |
0 |
499999.99999999994 |
299999.99999999988 |
299999.99999999988 |
299999.99999999988 |
CM Payment and Performance Bond |
2000000 |
0 |
2000000 |
0 |
0 |
0 |
Warranty Reserve |
750000 |
0 |
0 |
0 |
0 |
750000 |
General Conditions (Reduced GCs Due to Okan Staffing) |
13500000 |
0 |
2399999.9999999995 |
3800000.0000000005 |
5000000.0000000009 |
2300000 |
Other Hard Costs |
36037127.923592463 |
0 |
7408501.6304849479 |
7567480.3840236478 |
13070891.653471123 |
7990254.4892052338 |
Total Hard Costs |
240819978.34377286 |
0 |
42184999.960693106 |
79914216.893320963 |
94979273.9320447 |
23741487.791306566 |
|
|
|
|
|
|
Sales, Marketing and Other Costs and Schedule |
|
|
|
|
|
|
Marketing & Admin |
5000000 |
0 |
2250000 |
1000000 |
500000 |
1250000 |
Sales Commission (Pre-Operations) |
3166450.0000000005 |
0 |
1424902.5 |
633290.00000000012 |
316645.00000000006 |
791612.50000000012 |
Total Sales and Marketing Costs |
8166450 |
0 |
3674902.5 |
1633290 |
816645 |
2041612.5 |
|
|
|
|
|
|
|
Transaction Costs |
3062835.5753630386 |
0 |
3062835.5753630386 |
0 |
0 |
0 |
|
|
|
|
|
|
|
Total Construction Costs (including Land of $ 20,000,000) |
294989038.70130873 |
4969971.3409639997 |
57155687.910096847 |
86583011.7665319 |
98338046.731654286 |
27942320.691187479 |
|
|
|
SheetHidden
600
600
85
9
1
3
16
2
False
False
Cost Breakup |
Total Costs |
Pre Construction |
2020 |
2021 |
2022 |
2023 |
|
|
|
|
|
Soft-Costs |
|
|
|
|
|
|
Architectural, Design, Engineering |
4800000 |
4000000 |
239999.99999999997 |
200000.00000000006 |
180000 |
180000 |
Water & Sewer and Impact Fees |
5350000 |
0 |
5350000 |
0 |
0 |
0 |
Pre-Opening Expenses |
7040099 |
0 |
1760024.75 |
1760024.75 |
1760024.75 |
1760024.75 |
Other Soft Costs |
5749675.7821728 |
969971.34096399997 |
882925.12404070201 |
3075480.1232109377 |
602103.04960959323 |
219195.64988091093 |
Total Soft Costs |
22939774.782172799 |
4969971.3409639997 |
8232949.8740407024 |
5035504.8732109377 |
2542127.7996095931 |
2159220.3998809108 |
|
|
|
|
|
|
|
|
|
Hard-Costs |
|
|
|
|
|
|
Concrete |
74524546.446153805 |
0 |
19376382.07599999 |
31300309.507384591 |
23847854.862769209 |
0 |
Metals |
14121363.2600684 |
0 |
2118204.48901026 |
5648545.304027359 |
5648545.304027359 |
706068.16300341999 |
Openings |
25942126.323958199 |
0 |
1297106.3161979101 |
9079744.2133853696 |
14268169.478177007 |
1297106.3161979101 |
Finishes |
18084415 |
0 |
0 |
2712662.2500000005 |
10850649 |
4521103.7499999991 |
Conveying Equipment |
15336377.890000001 |
0 |
1533637.7890000001 |
8435007.8394999988 |
3680730.6935999994 |
1687001.5678999999 |
Plumbing |
6159300 |
0 |
123186 |
2032568.9999999998 |
3695580 |
307965 |
HVAC |
14750000 |
0 |
0 |
5162500 |
8112499.9999999991 |
1474999.9999999998 |
Electrical |
15464438.5 |
0 |
1855732.6199999999 |
4175398.3949999996 |
6804352.9399999985 |
2628954.5450000004 |
Earthwork |
6900283 |
0 |
6072249.0399999982 |
0 |
0 |
828033.96000000008 |
General Conditions (Reduced GCs Due to Okan Staffing) |
13500000 |
0 |
2399999.9999999995 |
3800000.0000000005 |
5000000.0000000009 |
2300000 |
Other Hard Costs |
36037127.923592463 |
0 |
7408501.6304849479 |
7567480.3840236478 |
13070891.653471123 |
7990254.4892052338 |
Total Hard Costs |
240819978.34377289 |
0 |
42184999.960693106 |
79914216.893320963 |
94979273.9320447 |
23741487.791306563 |
|
|
|
|
|
|
Sales, Marketing and Other Costs and Schedule |
|
|
|
|
|
|
Marketing & Admin |
5000000 |
0 |
2250000 |
1000000 |
500000 |
1250000 |
Sales Commission (Pre-Operations) |
3166450.0000000005 |
0 |
1424902.5 |
633290.00000000012 |
316645.00000000006 |
791612.50000000012 |
Total Sales and Marketing Costs |
8166450 |
0 |
3674902.5 |
1633290 |
816645 |
2041612.5 |
|
|
|
|
|
|
|
Transaction Costs |
3062835.5753630386 |
0 |
3062835.5753630386 |
0 |
0 |
0 |
|
|
|
|
|
|
|
Total Construction Costs (including Land of $ 20,000,000) |
294989038.70130873 |
4969971.3409639997 |
57155687.910096847 |
86583011.7665319 |
98338046.731654286 |
27942320.691187475 |
|
|
|
SheetHidden
600
600
85
1
3
6
23
False
False