| % Change | ||||||||||||
| ASSUMPTIONS | ANNUAL EXPENSES | Base Year | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
| Land | ||||||||||||
| Building | $12,098,460 | Operating Expense Increase Schedule: | ||||||||||
| General Contractors Fee | (included) | Payment in Lieu of Property taxes | 230,731 | 0% | 3% | 3% | 3% | |||||
| Construction Eng'g Fee | $362,954 | Gas and Electric | 100,000 | 3% | 3% | 3% | 3% | |||||
| Architectural Fee | $725,908 | Water/sewer | 50,000 | 3% | 3% | 3% | 3% | |||||
| Developer Fee | $1,209,846 | Insurance | 30,000 | 3% | 3% | 3% | 3% | |||||
| Closing Costs | $984,877 | Maintenance-snow, garden, etc | 100,000 | 4% | 4% | 4% | 4% | |||||
| Total Cost | $15,382,044 | 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 | 230,731 | 230,731 | 237,653 | 244,782 | 252,126 | |||||
| Total Cost/Sq Ft | $153.82 | 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 | 15,382,044 | |||||||||||
| Interest Rate | 6.00% | Total Operating Expenses | 580,731 | 592,231 | 611,038 | 630,450 | 650,489 | |||||
| Amortization Period | 20 | |||||||||||
| Annual Payment | $1,341,077 | Debt Service | 1,341,077 | 1,341,077 | 1,341,077 | 1,341,077 | 1,341,077 | |||||
| Equity | $0 | |||||||||||
| Total Annual Expense | 1,921,807 | 1,933,307 | 1,952,114 | 1,971,527 | 1,991,565 | |||||||
| CLOSING COST ESTIMATES | Annual Cost per Square Foot | $19.22 | $19.33 | $19.52 | $19.72 | $19.92 | ||||||
| Loan Fee - 2% | 241,969 | 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) | 725,908 | |||||||||||
| Total Closing | 984,877 | |||||||||||
| Blue numbers are variables | ||||||||||||
| Red numbers are results | ||||||||||||