Question
Your client is purchasing, a 50, 000 square foot retail strip center in Orange, CT. There is a 30,000 square foot grocery anchor and eight
Your client is purchasing, a 50, 000 square foot retail strip center in Orange, CT. There is a 30,000 square foot grocery anchor and eight 2,500 square foot retail stores. Two units are vacant. The grocery anchor pays $10.00 per square foot net rent and has 9 years remaining on their lease. The 6 occupied retail tenants pay $12.00 per square foot net and remaining lease terms range from 6 to 9 years. Market rent for comparable retail space is $15.00 net + CAM. All leases for the subject property are net plus CAM (Common Area Maintenance) charges. Operating Expenses are: RE Taxes $4.00 per square foot per annum. Property insurance is $0.75 per square foot per annum. Property Management is 5.0% of Gross operating income. Repairs and Maintenance is $0.50 per square foot per annum. Common Utilities run about $0.85 per square foot per annum. Legal fees and accounting run about $2,000 per year Advertising runs about $3,000 per year. Snow removal averages about $12,000 per year, Ground care runs about $11,000 per year. HVAC Contract is $1,500 per quarter. Financing: Financing is available for $4,604,025 at 5.25% for a 20-year amortization with monthly payments and a 5- year term. The lender is charging 1 point. Develop a 5 Year Cashflow After Tax Analysis, Vacancy rate for years 1 is at 10.0% and declines the second year forward to 6.0% Rental income will increase in year two 2.5% thereafter. Other income will increase 3.0% each year. Expense escalation will be 2.0% year 2 and 3.0% thereafter. Holding period 5 Years - Year of acquisition Buy in January - Year of disposition Sell in December-Cost at acquisition is $15,000 and Sale cost 5.5% of sale price. Taxes: Assessor's records indicate 20% allocation to land and 80% to improvements. Marginal tax rate is Federal 28%-State 5%- Federal Capital Gain Tax=20% State =6% Federal recapture tax is 25%- You Buy the property in January and sell it in December in sale year. Cap Rates: Going in cap rate of 6.5% and going out cap rate 6.0%
What is the estimated purchase price of the subject property? 2) What is the estimated sale price at the end of the 5-year holding period? 3) What is my effective Tax Rate? 4) What is the 2022 median income for Orange CT? 5) How much is spent on Food at Home and away per annum in Orange CT? 6) How many Households are there in 2022 and 2027? 7) What is the HH Size for 2022& 2027? 8) How many Lifestyles are there in Orange CT? 9) Which Lifestyle has the largest net worth and median Income, 10) What % are college graduates in the largest lifestyle? 11) Largest lifestyle- What is their labor participation rate? 12) Largest lifestyle-Do they embrace technology? 13) Largest lifestyle-What percent rent? 14) In Orange- what is the expenditure index for furniture? 15) What is the average dollar amount spent on furniture in Orange?
Year acquired Full years held (2-27.5) Year of sale Year Year acquired (1) Full years held (2-39) Year of sale (40) 1 3.485 3.636 0.152 1 2.461 2 3.182 0.107 3.636 0.458 2 2.564 2.564 IRS Cost-Recovery Percentages for Residential Property 0.321 3 2.879 2.576 4 3 2.247 2.033 1.819 3.636 3.636 3.636 3.636 5 2.273 2.564 2.564 0.535 0.749 IRS Cost-Recovery Percentages for Non-Residential Real Property Month 0.758 1.061 1.364 1.667 1970 2.273 2.576 2.879 3.182 5 Month 6 7 1.970 1.667 1.606 2.564 6 8 9 10 1.364 1.061 0.758 7 3.636 3.636 3.636 3.636 3.636 3.636 1.391 1.177 8 0.963 0.749 2.564 2.564 2.564 0.963 1.177 1.391 1.605 9 2.564 11 10 0.458 0.535 11 12 0.152 0.321 3.485 12 0.107 2.564 2.564 2.564 1.819 2.033 2.247 2.461
Step by Step Solution
3.45 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
1 The estimated purchase price of the subject property is 4604025 This is based on the financing amount of 4604025 and the 5year term 2 The estimated ...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