% Change
ASSUMPTIONS   ANNUAL INCOME & EXPENSES Base Year Year 2 Year 3 Year 4 Year 5
Land
Building $6,286,544 Operating Expense Increase Schedule:
General Contractors Fee (included) Payment in Lieu of Property taxes 120,014 0% 3% 3% 3%
Construction Eng'g Fee $188,596 Gas and Electric 25,000 3% 3% 3% 3%
Architectural Fee $377,193 Water/sewer 0 3% 3% 3% 3%
Developer Fee $628,654 Insurance 10,000 3% 3% 3% 3%
Closing Costs $519,924 Maintenance-snow, garden, etc 25,000 4% 4% 4% 4%
  Total Cost $8,000,911 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 120,014 120,014 123,614 127,322 131,142
Total Cost/Sq Ft $80.01 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,000,911
Interest Rate 6.00%   Total Operating Expenses 190,014 192,364 198,395 204,617 211,037
Amortization Period 20
Annual Payment $697,556 Debt Service 697,556 697,556 697,556 697,556 697,556
Equity $0
Total Annual Expense 887,570 889,920 895,950 902,173 908,592
CLOSING COST ESTIMATES Annual Cost per Square Foot 8.88 8.90 8.96 9.02 9.09
Loan Fee - 2% 125,731 Annual Revenue per Square Foot 9.24 9.70 10.19 10.70 11.23
Appraisal 5,000 Annual Gain/(Loss) per Square Foot 0.36 0.80 1.23 1.67 2.15
Survey 5,000
Improvements 0 Annual Cost per Parking Spot 2,219 2,225 2,240 2,255 2,271
Title 5,000 Annual Revenue per Parking Spot 2,310 2,426 2,547 2,674 2,808
Recording Fee 2,000 Annual Gain/(Loss) per Parking Spot 91.08 200.70 306.90 418.68 536.34
Prepaid Interest 377,193
Annual Gain/(Loss) Total 36,430 80,280 122,760 167,473 214,535
  Total Closing 519,924
Blue numbers are variables
Red numbers are results