| % Change | ||||||||||||
| ASSUMPTIONS | ANNUAL EXPENSES | Base Year | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
| Land | ||||||||||||
| Building | $10,888,614 | Operating Expense Increase Schedule: | ||||||||||
| General Contractors Fee | (included) | Payment in Lieu of Property taxes | 207,683 | 0% | 3% | 3% | 3% | |||||
| Construction Eng'g Fee | $326,658 | Gas and Electric | 100,000 | 3% | 3% | 3% | 3% | |||||
| Architectural Fee | $653,317 | Water/sewer | 50,000 | 3% | 3% | 3% | 3% | |||||
| Developer Fee | $1,088,861 | Insurance | 30,000 | 3% | 3% | 3% | 3% | |||||
| Closing Costs | $888,089 | Maintenance-snow, garden, etc | 100,000 | 4% | 4% | 4% | 4% | |||||
| Total Cost | $13,845,540 | 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 | 207,683 | 207,683 | 213,914 | 220,331 | 226,941 | |||||
| Total Cost/Sq Ft | $138.46 | 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 | 13,845,540 | |||||||||||
| Interest Rate | 5.00% | Total Operating Expenses | 557,683 | 569,183 | 587,299 | 605,999 | 625,304 | |||||
| Amortization Period | 20 | |||||||||||
| Annual Payment | $1,111,002 | Debt Service | 1,111,002 | 1,111,002 | 1,111,002 | 1,111,002 | 1,111,002 | |||||
| Equity | $0 | |||||||||||
| Total Annual Expense | 1,668,685 | 1,680,185 | 1,698,301 | 1,717,001 | 1,736,306 | |||||||
| CLOSING COST ESTIMATES | Annual Cost per Square Foot | $16.69 | $16.80 | $16.98 | $17.17 | $17.36 | ||||||
| Loan Fee - 2% | 217,772 | 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) | 653,317 | |||||||||||
| Total Closing | 888,089 | |||||||||||
| Blue numbers are variables | ||||||||||||
| Red numbers are results | ||||||||||||