thanks for the help. I will thumbs up!

Complete and Submit on Excel worksheet Using annualized figures, calculate the Net Present Value of the cash flow from an office building with the following characteristics. Ignore land value and debt service Building Size: 30,000 square feet Construction Costs: $175 per square foot Rent: $32 per square foot per year, gross (tenants pay their own utilities) Vacancy Factor: 6% Holding Period: 7 years Rent & Expenses Escalation: 3% per year beginning year 2 Property Taxes: $4 per square foot/year Insurance: $1 per square foot/year Maintenance: $2 per square foot/year Property Sale: End of Year 7 @ Year 7 Potential Gross Rent x GRM of 9 Discount Rate: 5.75% per year