Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started