Worksheet 2 - Purchase Analysis
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]
_________USF
5.
Total USF
[Line 5, Worksheet 1]
__________%
6.
Add-on Factor to obtain Gross Square
Feet
7.
Gross Square Feet
_________GSF
[Line 5 multiplied by (1 + Line 6)]
8.
Present Value of Total Cost of Services
& Utilities per USF
$________/USF
[from Second Column, Line 13,
Worksheet 1]
9.
Lump Sum Cost of Alterations per USF
$________/USF
[Line 8, Worksheet 1 divided by Line 5
above]
10. Market Comparable Purchase Price
$_______/GSF
11. Total Market Comparable Purchase
Price
$________/USF
[Line 7 x Line 10 divided by Line 5]
12. Total Cost to Purchase Real Property
[Line 9 + Line 11]
$________/USF
BENEFIT COST ANALYSIS -- 7 of 11