% Change
ASSUMPTIONS   ANNUAL EXPENSES Base Year Year 2 Year 3 Year 4 Year 5
Land
Building $13,308,306 Operating Expense Increase Schedule:
General Contractors Fee (included) Payment in Lieu of Property taxes 253,778 0% 3% 3% 3%
Construction Eng'g Fee $399,249 Gas and Electric 100,000 3% 3% 3% 3%
Architectural Fee $798,498 Water/sewer 50,000 3% 3% 3% 3%
Developer Fee $1,330,831 Insurance 30,000 3% 3% 3% 3%
Closing Costs $1,081,664 Maintenance-snow, garden, etc 100,000 4% 4% 4% 4%
  Total Cost $16,918,549 Janitorial 70,000 3% 3% 3% 3%
0% 0% 0% 0%
Land Value 15%
Operating Expenses:
Square Footage 100,000 Payment in Lieu of Property taxes 253,778 253,778 261,392 269,233 277,310
Total Cost/Sq Ft $169.19 Gas and Electric 100,000 103,000 106,090 109,273 112,551
Water/sewer 50,000 51,500 53,045 54,636 56,275
Insurance 30,000 30,900 31,827 32,782 33,765
FINANCING Maintenance-snow, garden, etc 100,000 104,000 108,160 112,486 116,986
Loan to Value 100% Janitorial 70,000 72,100 74,263 76,491 78,786
Total Debt 16,918,549
Interest Rate 7.00%   Total Operating Expenses 603,778 615,278 634,777 654,901 675,673
Amortization Period 20
Annual Payment $1,596,991 Debt Service 1,596,991 1,596,991 1,596,991 1,596,991 1,596,991
Equity $0
Total Annual Expense 2,200,770 2,212,270 2,231,768 2,251,893 2,272,665
CLOSING COST ESTIMATES Annual Cost per Square Foot $22.01 $22.12 $22.32 $22.52 $22.73
Loan Fee - 2% 266,166    to the University of Michigan
Appraisal 5,000
Survey 5,000
Improvements 0
Title 5,000
Recording Fee 2,000
Interest Res. (12% Constr loan) 798,498
  Total Closing 1,081,664
Blue numbers are variables
Red numbers are results