Using appraisal for real estate, could you help me answer NPV and IRR and also could you show your calculations for equity investment, after tax cash flows, after tax equity reversion, interest, depreciation, and tax calculations pls?

You are considering the purchase of a Class A office building. You plan to purchase the office building on January 1st, 2017 and sell the building 5 years later on December 31st, 2021. After careful research you have determined the following:

Total acquisition price: $1,100,000.

Property consists of 10 office suites, 5 on the first floor and 5 on the second.

Contract rents: 5 suites at $2,000 per month and 5 at $1,600 per month.

Annual market rent increases: 3.0 % per year (first increase on 01/01/2018)

Vacancy and collection losses: 6.0% per year.

Operating expenses: 40% of effective gross income each year.

Capital expenditures: 5.0% of expected gross income each year.

Expected holding period: 5 years.

Property value is expected to increase 3.25% per year.

Selling expenses are expected to be 8.0% of selling price.

Loan information: 75% LTV, 9.0%, 30 years

Up-front financing costs: 3.5% of loan amount.

Depreciation: 90% of the acquisition price

Ordinary income tax rate: 30%

Capital gain tax rate: 15%

Depreciation recapture rate: 25%

Required return: 12%

Would you invest in the project based on your calculated NPV and IRR? Refer to your supporting documents.

Supporting documentation: show your calculations for: Equity Investment, after tax cash flows, after tax equity reversion, interest, depreciation, and tax calculations.