% Change
ASSUMPTIONS   ANNUAL INCOME & EXPENSES Base Year Year 2 Year 3 Year 4 Year 5
Land
Building $5,657,890 Operating Expense Increase Schedule:
General Contractors Fee (included) Payment in Lieu of Property taxes 108,038 0% 3% 3% 3%
Construction Eng'g Fee $169,737 Gas and Electric 25,000 3% 3% 3% 3%
Architectural Fee $339,473 Water/sewer 0 3% 3% 3% 3%
Developer Fee $565,789 Insurance 10,000 3% 3% 3% 3%
Closing Costs $469,631 Maintenance-snow, garden, etc 25,000 4% 4% 4% 4%
  Total Cost $7,202,520 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 108,038 108,038 111,279 114,617 118,056
Total Cost/Sq Ft $72.03 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 7,202,520
Interest Rate 5.00%   Total Operating Expenses 178,038 180,388 186,059 191,912 197,950
Amortization Period 20
Annual Payment $577,949 Debt Service 577,949 577,949 577,949 577,949 577,949
Equity $0
Total Annual Expense 755,987 758,337 764,008 769,860 775,899
CLOSING COST ESTIMATES Annual Cost per Square Foot 7.56 7.58 7.64 7.70 7.76
Loan Fee - 2% 113,158 Annual Revenue per Square Foot 10.16 10.67 11.21 11.77 12.35
Appraisal 5,000 Annual Gain/(Loss) per Square Foot 2.60 3.09 3.57 4.07 4.60
Survey 5,000
Improvements 0 Annual Cost per Parking Spot 1,890 1,896 1,910 1,925 1,940
Title 5,000 Annual Revenue per Parking Spot 2,541 2,668 2,801 2,942 3,089
Recording Fee 2,000 Annual Gain/(Loss) per Parking Spot 651.03 772.21 891.43 1,016.87 1,148.85
Prepaid Interest 339,473
Annual Gain/(Loss) Total 260,413 308,883 356,573 406,750 459,542
  Total Closing 469,631
Blue numbers are variables
Red numbers are results