Strasburg is a census-designated place in Adams and Arapahoe counties in the U.S. state of Colorado....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Strasburg is a census-designated place in Adams and Arapahoe counties in the U.S. state of Colorado. The population of Strasburg is approximately 5,000. The Strasburg Post Office has the ZIP Code 80136. The Town of Strasburg is about 40 miles east of Denver along I-70 and sits at an elevation of 5,381 feet. You have an opportunity to purchase the post office building in Strasburg, Colorado. Te U.S. Postal Service has just signed a 5 year extension of the current lease on the 2,000 Rft? office building at $24.00 per square foot per year. The tenant pays most all expenses in terms of maintenance and upkeep. Your only out of pocket costs are for utilities, which are projected to be $3.00 psf this year and will increase, you believe, at a rate of 5% per year for the next several years. Strasburg is a very small town in Eastern Colorado and thus the demand for office space is quite low. However, of the office buildings in the market there is currently no vacancy. Typical rents range between $21.00 and $27.00 per square foot with typical owner expenses amounting to about $9.00 per square foot (taxes, utilities, insurance, general maintenance). The postal service plans to build a new facility, perhaps a bit larger, by the time in the lease period is over. The investor who currently owns the building is offering it for sale at $375,000. The Assumptions: You assume you will be able to secure a cash buyer for the property at the end of year 5 at a 10% cap on the sixth years projected market NOI. Assume all of your analyses before tax Assume the property would rent for $25.50 today if not for the postal service lease. Also assume typical expenses of $9.00 psf. Compound both amounts forward at 5% to figure the sixth year's NOI. • Assume an all cash transaction, both purchase and sale, with no transaction costs. • Important. Assume you are in Strasburg, needing to make a decision within the nelt couple hours and all you have is your phone and a pad of paper. The Calculations & Questions: 1. Set up and calculate a 5 year projection from PGI to NOI. (Note that in this all cash scenario NOI = BTCF) 2. Calculate the reversion based upon the projected market sixth year NOI. 3. Calculate the acquisition Cap Rate 4. Calculate Cash/Cash year 1; assuming $375,000 purchase price. Assuming the purchase price of $375,000 and the projected cash flows and reversion. What is the IRR? 5. 6. Let's say you wish to achieve a rate of return of 14% (your discount rate). What is the gross present value of this investment? Strasburg is a census-designated place in Adams and Arapahoe counties in the U.S. state of Colorado. The population of Strasburg is approximately 5,000. The Strasburg Post Office has the ZIP Code 80136. The Town of Strasburg is about 40 miles east of Denver along I-70 and sits at an elevation of 5,381 feet. You have an opportunity to purchase the post office building in Strasburg, Colorado. Te U.S. Postal Service has just signed a 5 year extension of the current lease on the 2,000 Rft? office building at $24.00 per square foot per year. The tenant pays most all expenses in terms of maintenance and upkeep. Your only out of pocket costs are for utilities, which are projected to be $3.00 psf this year and will increase, you believe, at a rate of 5% per year for the next several years. Strasburg is a very small town in Eastern Colorado and thus the demand for office space is quite low. However, of the office buildings in the market there is currently no vacancy. Typical rents range between $21.00 and $27.00 per square foot with typical owner expenses amounting to about $9.00 per square foot (taxes, utilities, insurance, general maintenance). The postal service plans to build a new facility, perhaps a bit larger, by the time in the lease period is over. The investor who currently owns the building is offering it for sale at $375,000. The Assumptions: You assume you will be able to secure a cash buyer for the property at the end of year 5 at a 10% cap on the sixth years projected market NOI. Assume all of your analyses before tax Assume the property would rent for $25.50 today if not for the postal service lease. Also assume typical expenses of $9.00 psf. Compound both amounts forward at 5% to figure the sixth year's NOI. • Assume an all cash transaction, both purchase and sale, with no transaction costs. • Important. Assume you are in Strasburg, needing to make a decision within the nelt couple hours and all you have is your phone and a pad of paper. The Calculations & Questions: 1. Set up and calculate a 5 year projection from PGI to NOI. (Note that in this all cash scenario NOI = BTCF) 2. Calculate the reversion based upon the projected market sixth year NOI. 3. Calculate the acquisition Cap Rate 4. Calculate Cash/Cash year 1; assuming $375,000 purchase price. Assuming the purchase price of $375,000 and the projected cash flows and reversion. What is the IRR? 5. 6. Let's say you wish to achieve a rate of return of 14% (your discount rate). What is the gross present value of this investment?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
You have an opportunity to purchase a private competitor called Fernand in Mexico. You will use only your funds if you decide to purchase the company. a. When you attempt to determine the value of...
-
You have an opportunity to purchase a piece of vacant land for $30,000 cash. If you buy the property, you plan to hold it for 15 years and then sell it at a profit. During this period, you would have...
-
You have the opportunity to purchase an insurance policy for your newborn son. You must make the payments shown in the table. After his fifth birthday no more payments are required. If your son...
-
Goddard Company has used the FIFO method of inventory valuation since it began operations in 2015. Goddard decided to change to the average cost method for determining inventory costs at the...
-
Dan O'Connor paid $ 125 to have the University of Notre Dame's leprechaun mascot tattooed on his upper arm with the words Fighting Irish inscribed above the little gnome. The tattoo parlor inscribed...
-
Carnival Corporation has recently placed into service some of the largest cruise ships in the world. One of these ships, the Carnival Breeze, can hold up to 3,600 passengers, and it can cost $750...
-
We have seen that the heart produces a magnetic field that can be used to diagnose problems with the heart. The magnetic field of the heart is a dipole field produced by a loop current in the outer...
-
Suppose availability and purchase costs for V8 short blocks at Juarez and New Orleans are the same as in problem #2 (without tariffs). However, suppose that HP does not pay shipping from Juarez or...
-
GM has the total assets of $264,037 million, total liabilities of $191,753 million, the earnings before interests and taxes of $10,314 million, interest expenses of $987 million, and depreciation of...
-
a. Johnson plans to use the preceding ratios as the starting point for discussions with RR's operating team. Based on the data, does RR seem to be following a relaxed, moderate, or restricted current...
-
A company is expected to pay a dividend of $1.06 per share one year from now and $1.66 in two years. You estimate the risk-free rate to be 3.3% per year and the expected market risk premium to be...
-
A taxpayer has $5,000 in cash donations to various charitable organizations during the year. $2,000 of these are not substantiated with a contemporaneous written acknowledgement from the donee...
-
Commercial Carpets manufactures custom mats. The details on its standard run of a 1 m x 2 m mat is as follows: Quantity Unit Selling Price Unit Variable Cost Fixed Costs 3 2 0 $ 5 6 $ 3 1 $ 1 , 9 0 0...
-
In an X-ray powder camera using incident copper radiation of wavelength 1.5418 , a diffraction line is produced at 20= 45.8. determine the miller indices for the reflecting planes if a = 3.44 .
-
A taxpayer gets into rocky straits with their spouse and begins the process of filing for divorce, choosing to file separately for TY2023. The taxpayer initially begins as the sole owner of their...
-
An agreement is reached for an American company to purchase a machine from a foreign vendor for 100,000 euros. At the time of the agreement, the exchange rate is 1.20 dollars per euro. At the time of...
-
1. Consider a portfolio of a stock and a short call option with the following properties. A. Stock price is currently $30. B. In 3 months, it will be either $32 or $28. C. Call option expiration is 3...
-
A non-charmed baryon has strangeness S = 2 and electric charge Q = 0. What are the possible values of its isospin I and of its third component I z ? What is it usually called if I = 1/2?
-
For a standard normal random variable Z, let n = E[Zn]. Show that Start by expanding the moment generating function of Z into a Taylor series about 0 to obtain 0 when n is odd (2j) 2ij! n when n = 21...
-
Verify Equation (1.2).
-
From a set of n randomly chosen people, let Eij denote the event that persons i and j have the same birthday. Assume that each person is equally likely to have any of the 365 days of the year as his...
-
Which of the following best describes the underlying rationale for a written investment policy statement (IPS)? A. A written IPS communicates a plan for trying to achieve investment success. B. A...
-
Which of the following is least important as a reason for a written investment policy statement (IPS)? A. The IPS may be required by regulation. B. Having a written IPS is part of best practice for a...
-
Which of the following typical topics in an investment policy statement (IPS) is most closely linked to the clients distinctive needs? A. Procedures. B. Investment Guidelines. C. Statement of Duties...
Study smarter with the SolutionInn App