Answer the following questions using excel to do a cash flow projection Cash flow assumptions: - 100,000 sf building Year 1 rent $20 PSF Year 1 expenses $8 PSF Lease structure NNN ( Tenant reimburses 100% of expenses) Annual rent growth of 3.5% Annual expense growth of 3% Capital reserves of $0.25 PSF per year Roof replacement in year 3 for $100k Hold period 5 years Exit cap rate 7% Cost of sale of 2% Purchase price of $30.OM Questions: 1. What is the 5 year IRR 2. What is year 4 Net operating income 3. What is year 3 net cash flow 4. What is the exit value PSF ( before sales costs) Answer the following questions using excel to do a cash flow projection Cash flow assumptions: - 100,000 sf building Year 1 rent $20 PSF Year 1 expenses $8 PSF Lease structure NNN ( Tenant reimburses 100% of expenses) Annual rent growth of 3.5% Annual expense growth of 3% Capital reserves of $0.25 PSF per year Roof replacement in year 3 for $100k Hold period 5 years Exit cap rate 7% Cost of sale of 2% Purchase price of $30.OM Questions: 1. What is the 5 year IRR 2. What is year 4 Net operating income 3. What is year 3 net cash flow 4. What is the exit value PSF ( before sales costs)