Worksheet 3 - Construction Analysis Worksheet
Assumptions
1.
Firm Term (years)
[Line 1, Worksheet 1]
________Years
2.
Renewal Term (years)
[Line 2, Worksheet 1]
________Years
3.
Holding Period (years)
[Line 1 + Line 2]
________Years
4.
Discount Rate
[Line 4, Worksheet 1]
5.
Total Usable Square Feet
_________USF
[Line 5, Worksheet 1]
6.
Add-on Factor to obtain Gross Square
Feet. [Line 6, Worksheet 2]
___________%
7.
Gross Square Feet
_________GSF
[Line 5 multiplied by (1+ Line 6)]
8.
Present Value of Total Cost of Services
and Utilities per USF
$________/USF
[Line 8, Worksheet 2]
9.
Lump Sum Cost of Alterations
[Line 8, Worksheet 1]
$____________
10. Estimated Construction Cost of Shell
$_______/GSF
11. Total Construction Cost of Shell
[Line 7 x Line 10]
$____________
12. Purchase Price of Land
$____________
13. Total Cost of Construction
$____________
[Line 9 plus Line 11 plus Line 12]
BENEFIT COST ANALYSIS -- 9 of 11