% Change
ASSUMPTIONS   ANNUAL INCOME & EXPENSES Base Year Year 2 Year 3 Year 4 Year 5
Land
Building $6,915,198 Operating Expense Increase Schedule:
General Contractors Fee (included) Payment in Lieu of Property taxes 131,990 0% 3% 3% 3%
Construction Eng'g Fee $207,456 Gas and Electric 25,000 3% 3% 3% 3%
Architectural Fee $414,912 Water/sewer 0 3% 3% 3% 3%
Developer Fee $691,520 Insurance 10,000 3% 3% 3% 3%
Closing Costs $570,216 Maintenance-snow, garden, etc 25,000 4% 4% 4% 4%
  Total Cost $8,799,302 Janitorial 10,000 3% 3% 3% 3%
0% 0% 0% 0%
Land Value 15%
Less Operating Expenses:
Square Footage 100,000 Payment in Lieu of Property taxes 131,990 131,990 135,949 140,028 144,229
Total Cost/Sq Ft $87.99 Gas and Electric 25,000 25,750 26,523 27,318 28,138
Water/sewer 0 0 0 0 0
Insurance 10,000 10,300 10,609 10,927 11,255
FINANCING Maintenance-snow, garden, etc 25,000 26,000 27,040 28,122 29,246
Loan to Value 100% Janitorial 10,000 10,300 10,609 10,927 11,255
Total Debt 8,799,302
Interest Rate 7.00%   Total Operating Expenses 201,990 204,340 210,730 217,322 224,123
Amortization Period 20
Annual Payment $830,592 Debt Service 830,592 830,592 830,592 830,592 830,592
Equity $0
Total Annual Expense 1,032,581 1,034,931 1,041,322 1,047,914 1,054,715
CLOSING COST ESTIMATES Annual Cost per Square Foot 10.33 10.35 10.41 10.48 10.55
Loan Fee - 2% 138,304 Annual Revenue per Square Foot 8.32 8.73 9.17 9.63 10.11
Appraisal 5,000 Annual Gain/(Loss) per Square Foot (2.01) (1.62) (1.24) (0.85) (0.44)
Survey 5,000
Improvements 0 Annual Cost per Parking Spot 2,581 2,587 2,603 2,620 2,637
Title 5,000 Annual Revenue per Parking Spot 2,079 2,183 2,292 2,407 2,527
Recording Fee 2,000 Annual Gain/(Loss) per Parking Spot (502.45) (404.38) (311.21) (213.08) (109.75)
Prepaid Interest 414,912
Annual Gain/(Loss) Total (200,981) (161,751) (124,483) (85,233) (43,900)
  Total Closing 570,216
Blue numbers are variables
Red numbers are results