My company is considering putting in an offer on a property located in a small college...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
My company is considering putting in an offer on a property located in a small college town. The property has the following attributes: 7,000 square feet of total rentable space in a 13 year old building ● 100% fully leased with four tenants-Subway, Dominos, Starbucks, and Campus Liquor • Average blended rental rates for the tenants is $12.50/saft/xr. . Rental rates are projected to increase annually by 5% Total operating expenses for the center are $5.25/sqft/yr and are projected to increase by $0.25/saft/yr for the entire analysis period-operating expenses include CAM, property management costs, insurance and property taxes Tenants reimburse us 100 % of all operating expenses-full pass through ● ● ● All four leases are long-term leases but we project that we will experience some rent collection difficulties due to summer-time lulls in activity. We will assume a collection reserve of 5% of rents and reimbursable expenses • Capital expenditures are estimated to total $1.00/sqft/yr Initial Cap Rate at purchase= .075 (7.5%) Reversion (sale) Cap Rate= .070 (7.0%) ● Sales Costs at reversion = 2% of gross proceeds • Building is depreciable over 39 years (straight line) ● Debt Info: . ● > 70% LTV ► 20-year amortization period > 5.25% interest rate Assume a Three-year Hold with Sale at the end of year 3. Sales price will be based on the Year 3 NOI using the Reversion Cap Rate above From this information, create a detailed pro forma for the hold period (preferably using Excel if you are comfortable doing so). If you feel that certain information is missing that is essential to completing the pro forma, identify what it is and then make an educated assumption to fill the data void so you can proceed with the pro forma development. Ultimately, you will want to determine the following: 1) What is the approximate price I should offer for this property based on the cap rate given and applied against the project NOI for Year 1 determined using the information above? 2) What is the IRR for the project from the standpoint of the equity investors? Assume sale of the property at the end of year 3's operations. Disregard taxes to investors but if you will feel better knowing about taxes, assume they are 30% to the equity investors. 3) Summarize key items you may have had to assume to arrive at your answers and let me know if you would pursue this purchase or not if the equity investors generally demand a 12% return on their investment. My company is considering putting in an offer on a property located in a small college town. The property has the following attributes: 7,000 square feet of total rentable space in a 13 year old building ● 100% fully leased with four tenants-Subway, Dominos, Starbucks, and Campus Liquor • Average blended rental rates for the tenants is $12.50/saft/xr. . Rental rates are projected to increase annually by 5% Total operating expenses for the center are $5.25/sqft/yr and are projected to increase by $0.25/saft/yr for the entire analysis period-operating expenses include CAM, property management costs, insurance and property taxes Tenants reimburse us 100 % of all operating expenses-full pass through ● ● ● All four leases are long-term leases but we project that we will experience some rent collection difficulties due to summer-time lulls in activity. We will assume a collection reserve of 5% of rents and reimbursable expenses • Capital expenditures are estimated to total $1.00/sqft/yr Initial Cap Rate at purchase= .075 (7.5%) Reversion (sale) Cap Rate= .070 (7.0%) ● Sales Costs at reversion = 2% of gross proceeds • Building is depreciable over 39 years (straight line) ● Debt Info: . ● > 70% LTV ► 20-year amortization period > 5.25% interest rate Assume a Three-year Hold with Sale at the end of year 3. Sales price will be based on the Year 3 NOI using the Reversion Cap Rate above From this information, create a detailed pro forma for the hold period (preferably using Excel if you are comfortable doing so). If you feel that certain information is missing that is essential to completing the pro forma, identify what it is and then make an educated assumption to fill the data void so you can proceed with the pro forma development. Ultimately, you will want to determine the following: 1) What is the approximate price I should offer for this property based on the cap rate given and applied against the project NOI for Year 1 determined using the information above? 2) What is the IRR for the project from the standpoint of the equity investors? Assume sale of the property at the end of year 3's operations. Disregard taxes to investors but if you will feel better knowing about taxes, assume they are 30% to the equity investors. 3) Summarize key items you may have had to assume to arrive at your answers and let me know if you would pursue this purchase or not if the equity investors generally demand a 12% return on their investment.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these corporate finance questions
-
A buyer makes an offer on a property and asks the Seller's broker to recommend a good home inspector. The Seller's broker may A recommend a specific home inspector. B. provide the complete list of...
-
Hotel prices worldwide are projected to increase by 3% next year (Lodging Magazine website, June 15, 2016), but is there a difference between Europe and the U.S.? Suppose we have projected changes in...
-
You have just made an offer on a new home and are seeking a mortgage. You need to borrow $ 564 comma 000. a. The bank offers a 25-year mortgage with fixed monthly payments and an interest rate of...
-
Direct Materials Budget The MSC Company has anticipated its unit sales for the first half of 2022 as follows: 2022 Units January 12,000 February 14,000 March 15,000 16,000 17,000 18,000 April May...
-
Suppose there were call options and forward contracts available on coal, but no put options. Show how a financial engineer could synthesize a put option using the available contracts. What does your...
-
Table shows supply and demand schedules for the British pound. Assume that exchange rates are flexible. a. The equilibrium exchange rate equals____. At this exchange rate, how many pounds will be...
-
Two residents of California filed a lawsuit against Hertz Corporation on behalf of a group of people arguing that the companys labor practices were illegal. The corporation was labeling workers as...
-
Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided...
-
4. A pharma company you work for makes jars with cream. It claims that the average amount of cream in a jar is at least 90 g. To prove that claim to the customers you decide to test the claim at a...
-
Construct annual incremental operating cash flow statements. Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by...
-
what should a director of manufacturing do if one of their products is recalled, or has something that's causing harm when using?
-
= In the Diffie-Hellman Key Exchange, let the public keys be p 79, g = 48, and the secret keys be a = 36 and b = 67, where a is Alice's secret key and b is Bob's secret key. What value does Alice...
-
Corporations are important elements of the communities in which they operate. As a corporate citizen, an organization should be moved to interact with and contribute to its local, regional, national,...
-
5. Testing EMH. On February 18th, Ohio State announced that it had entered into exclu- sive contracts with two companies (company ABC and XYZ) to manufacture all university- related apparel. No...
-
Suppose a company had an initial investment of $40,000. The cash flow for the next five years are $19,000, $17,000, $13,000, $19,000, and $18,000, respectively. The interest rate is 7%. What is the...
-
1) Which elements should a contract include for it to be legally binding? 2) Provide three examples of what could constitute an unfair contract term under consumer law. 3) Explain the purpose of an...
-
A. If the risk-free rate is 0.95% and the expected market return is 7.63%, what is the expected return for a given stock with a beta of 1.28? B. You have a $102,000 ten-stock portfolio with a beta of...
-
For a nonzero constant a, find the intercepts of the graph of (x 2 + y 2 ) 2 = a 2 (x 2 - y 2 ). Then test for symmetry with respect to the x-axis, the y-axis, and the origin.
-
Robert Ramos (age 36) is a single taxpayer, living at 8765 Bay Dr., Monterey, CA 93940. His Social Security number is 976-23-5132. Robert's earnings and income tax withholding as the manager of a...
-
Brian and Kim have a 12-year-old child, Stan. For 2012, Brian and Kim have taxable income of $52,000, and Stan has nonqualifying dividend income of $4,500 and investment expenses of $250. No election...
-
Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...
-
To test \(H_{0}: \sigma=50\) versus \(H_{1}: \sigma <50\), a random sample of size \(n=24\) is obtained from a population that is known to be normally distributed. (a) If the sample standard...
-
In Example 2 from Section 10.3, the quality-control engineer for M\&MMars tested whether the mean weight of fun-size Snickers was 20.1 grams. Suppose that the standard deviation of the weight of the...
-
(a) Determine the critical values for a right-tailed test of a standard population deviation with 18 degrees of freedom at \(\alpha=0.1\) level of significance. (b) Determine the critical values for...
Study smarter with the SolutionInn App