You are a real estate investment manager at a state pension fund with a very large...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a real estate investment manager at a state pension fund with a very large diversified portfolio. Your real estate allocation has fallen below the fund's target portion of the overall portfolio because your stock market investment allocation gained value last year. Also, your managing director and you think there are some very interesting opportunities available at the moment due to market conditions. You are fortunate in that the fund will allow you to invest in debt, equity or real estate, but the volatile economy (US and overseas) provides no clear direction in the market. Despite this, you have found three distinct opportunities, each of which can consume the entire $100 million allocation you need to place within the next month. You are otherwise sufficiently diversified such that a $100 million acquisition of any of the following will not adversely impact the fund's balance. The opportunities are: • A 300,000 SF office building in a CBD that can be purchased at an unlevered 5% capitalization rate. You're not sure if it's a bit pricey, and you will have to finance it within six months and lever the return to meet your goals. You may assume that the due diligence has been done and you are satisfied that the property is appropriate for the fund. The property is "in transition" with one-third of the leases expiring within two years and another third in five years. • A portfolio of CMBS bonds issued in 2019 with the bonds maturing over various terms depending upon tranche--choose from the Citigroup Commercial Mortgage Trust 2019-SMRT or Ready Capital Mortgage Trust 2019-5 deals discussed in class. Look at the next page for pricing information, yields, and average life of the tranches. • A secondary stock offering for a large retail REIT (rated Baa1) with a diversified portfolio by geography and tenant throughout the USA. The issuer plans to raise $500 million of new equity. The REIT's dividend yield is 6.3% (to be paid in cash, not stock per 2009 IRS guidelines). Gross assets are approximately $13 billion. The REIT's portfolio is levered at 42% (debt + preferred/gross assets), secured debt/gross assets is 4.2%, Net debt/EBITDA is 6x, and fixed charge coverage is 3.5x at YE18. The prospectus includes the typical statement that the money will be used for operations, to pay down debt and to make future opportunistic acquisitions. Your managing director wants a review of the pros and cons of each investment, plus your recommendation for the fund's actual investment. You will have 15 minutes (approximately a 3 to 5- page memo) to present to the investment committee, so your arguments for and against must be concise, cogent and persuasive. Bullet points are fine. The investment committee reviews all investments of the pension fund, not just real estate, so your overall real estate experience (i.e., your other coursework and work experience) will be helpful. Your thought process since we completed our initial overview of capital markets, CMBS and REITs is most important- discuss pros, cons, conclusion for each alternative. You may use any outside information sources, but cite references to these sources as plagiarism is unacceptable. Supplemental graphs/resources may be attached in an Appendix, but refer to them- do no drop them into the paper without a purpose. PRICING of CMBS DEALS BANK 2020-BNK27 MORTGAGE TRUST INITIAL PRICING: BANK, 2020-BNK27 Amt Sub Class $min A-1 2.53 Level % 30.00 23.00 AAA AAA Aaa A-SB 4.34 30.00 7.32 AAA AAA Aaa A-4 130.00 30.00 9.47 AAA AAA Aaa A-5 274.01 30.00 9.61 AAA AAA Aaa A-S 68.97 18.25 9.72 AAA AAA Aa2 24.21 14.125 9.74 AA-AA- NR 10.50 9.80 A- A- NR 7.625 9.80 BBB BBB NR 6.625 9.80 BBB-BBB- NR 10.57 4.875 9.80 BB+ BB- NR 5.87 3.875 9.80 B+ B- INR H 22.76 0.00 9.80 NR NR NR RR 30.89 0.00 9.58 ΝΑ NA ΝΑ X-A 410.88 NA NA AAA AAA Aaa X-B 114.46 NA ΝΑ X-D 16.88 NA C 21.27 D 16.88 E 5.87 A- AAA NR NA BBB BBB NR AABUD EFGH Avg Rating Rating Rating Pricing Life (yrs) Fitch Kroll Moody's *Notional amount, interest only Pricing Date: 19 June, 2020 Collateral balance: $617.86 million One Bryant Park Trust (OBP) 2019-OBP ABS CMBS OBP 2019-OBP (USD 903m) A B HRR CLASS CCY SZE(M) WAL WALX MO SP FI DR USD 902.500 10.07 USD 47.500 10.07 Aaa Yield% 99.998 1.110 +85 102.995 1.819 +130 100.999 1.784 +114 102.994 1.802 +115 102.993 2.207 +155 102.998 2.559 +190 98.105 3.512 +285 81.512 4.912 +425 Aaa Durst Organization KR AAA AAA Bnch Final Pricing (bp) mark MS C/E swaps swaps swaps swaps swaps swaps swaps swaps swaps Treas Treas Treas Treas Treas Treas Treas LTV TYPE Fixed BNCH GONC 938 BAM USOA Aug 7, 2019 SPRO CPN YLD PRICE 100 2.52% 2.519 % 100.00000 Retained You are a real estate investment manager at a state pension fund with a very large diversified portfolio. Your real estate allocation has fallen below the fund's target portion of the overall portfolio because your stock market investment allocation gained value last year. Also, your managing director and you think there are some very interesting opportunities available at the moment due to market conditions. You are fortunate in that the fund will allow you to invest in debt, equity or real estate, but the volatile economy (US and overseas) provides no clear direction in the market. Despite this, you have found three distinct opportunities, each of which can consume the entire $100 million allocation you need to place within the next month. You are otherwise sufficiently diversified such that a $100 million acquisition of any of the following will not adversely impact the fund's balance. The opportunities are: • A 300,000 SF office building in a CBD that can be purchased at an unlevered 5% capitalization rate. You're not sure if it's a bit pricey, and you will have to finance it within six months and lever the return to meet your goals. You may assume that the due diligence has been done and you are satisfied that the property is appropriate for the fund. The property is "in transition" with one-third of the leases expiring within two years and another third in five years. • A portfolio of CMBS bonds issued in 2019 with the bonds maturing over various terms depending upon tranche--choose from the Citigroup Commercial Mortgage Trust 2019-SMRT or Ready Capital Mortgage Trust 2019-5 deals discussed in class. Look at the next page for pricing information, yields, and average life of the tranches. • A secondary stock offering for a large retail REIT (rated Baa1) with a diversified portfolio by geography and tenant throughout the USA. The issuer plans to raise $500 million of new equity. The REIT's dividend yield is 6.3% (to be paid in cash, not stock per 2009 IRS guidelines). Gross assets are approximately $13 billion. The REIT's portfolio is levered at 42% (debt + preferred/gross assets), secured debt/gross assets is 4.2%, Net debt/EBITDA is 6x, and fixed charge coverage is 3.5x at YE18. The prospectus includes the typical statement that the money will be used for operations, to pay down debt and to make future opportunistic acquisitions. Your managing director wants a review of the pros and cons of each investment, plus your recommendation for the fund's actual investment. You will have 15 minutes (approximately a 3 to 5- page memo) to present to the investment committee, so your arguments for and against must be concise, cogent and persuasive. Bullet points are fine. The investment committee reviews all investments of the pension fund, not just real estate, so your overall real estate experience (i.e., your other coursework and work experience) will be helpful. Your thought process since we completed our initial overview of capital markets, CMBS and REITs is most important- discuss pros, cons, conclusion for each alternative. You may use any outside information sources, but cite references to these sources as plagiarism is unacceptable. Supplemental graphs/resources may be attached in an Appendix, but refer to them- do no drop them into the paper without a purpose. PRICING of CMBS DEALS BANK 2020-BNK27 MORTGAGE TRUST INITIAL PRICING: BANK, 2020-BNK27 Amt Sub Class $min A-1 2.53 Level % 30.00 23.00 AAA AAA Aaa A-SB 4.34 30.00 7.32 AAA AAA Aaa A-4 130.00 30.00 9.47 AAA AAA Aaa A-5 274.01 30.00 9.61 AAA AAA Aaa A-S 68.97 18.25 9.72 AAA AAA Aa2 24.21 14.125 9.74 AA-AA- NR 10.50 9.80 A- A- NR 7.625 9.80 BBB BBB NR 6.625 9.80 BBB-BBB- NR 10.57 4.875 9.80 BB+ BB- NR 5.87 3.875 9.80 B+ B- INR H 22.76 0.00 9.80 NR NR NR RR 30.89 0.00 9.58 ΝΑ NA ΝΑ X-A 410.88 NA NA AAA AAA Aaa X-B 114.46 NA ΝΑ X-D 16.88 NA C 21.27 D 16.88 E 5.87 A- AAA NR NA BBB BBB NR AABUD EFGH Avg Rating Rating Rating Pricing Life (yrs) Fitch Kroll Moody's *Notional amount, interest only Pricing Date: 19 June, 2020 Collateral balance: $617.86 million One Bryant Park Trust (OBP) 2019-OBP ABS CMBS OBP 2019-OBP (USD 903m) A B HRR CLASS CCY SZE(M) WAL WALX MO SP FI DR USD 902.500 10.07 USD 47.500 10.07 Aaa Yield% 99.998 1.110 +85 102.995 1.819 +130 100.999 1.784 +114 102.994 1.802 +115 102.993 2.207 +155 102.998 2.559 +190 98.105 3.512 +285 81.512 4.912 +425 Aaa Durst Organization KR AAA AAA Bnch Final Pricing (bp) mark MS C/E swaps swaps swaps swaps swaps swaps swaps swaps swaps Treas Treas Treas Treas Treas Treas Treas LTV TYPE Fixed BNCH GONC 938 BAM USOA Aug 7, 2019 SPRO CPN YLD PRICE 100 2.52% 2.519 % 100.00000 Retained
Expert Answer:
Related Book For
Basic Business Statistics Concepts and Applications
ISBN: 978-0132168380
12th edition
Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel
Posted Date:
Students also viewed these finance questions
-
A real estate investment of $5,000,000 is expected to generate an NOI of $600,000 per year and will be resold at a cap rate of 8 % in 3 years. If the available financing is $3,000,000 at 6% with no...
-
Calculate the molality, the molarity, and the mole fraction of NH3 in an 9.50 mass % aqueous solution (d=0.9651 g/mL). m M mole fraction
-
What are some of the pros and cons of family ownership?
-
A wooden bookshelf has external dimensions as follows :Height = 110cm, Depth = 25cm, Breadth = 85cm (see figure). The thickness of the plank is 5 cm everywhere. The external faces are to be polished...
-
Use the double-declining-balance method to make a depreciation schedule for a piece of equipment that costs $2,780 and has a salvage value of $300. The equipment is expected to be used for four...
-
Discuss the various control techniques that will be used with this specific design. Develop a hypothetical research scenario that would necessitate the use of an A-B-A Design. The research will be...
-
A \(45^{\circ}\) off-axis tensile test specimen has three strain gages attached. Two of the gages are mounted as shown in Figure 2.18 so as to measure the normal strains \(\varepsilon_{x}\) and...
-
Assume that you just won the state lottery. Your prize can be taken either in the form of $40,000 at the end of each of the next 25 years (that is, $1,000,000 over 25 years) or as a single amount of...
-
On April 30, 2025, the market price of Seabury Occupational Therapy, Inc.'s common stock was $13 per share and the company declared a 5% stock dividend. The stock was distributed on May 15. Read the...
-
Suppose the following information was taken from the 2022 financial statements of pharmaceutical giant Merck and Co. (All dollar amounts are in millions.) Instructions a. After analyzing the data,...
-
What is the solubility product constant for Ba(103)2 that has a molar solubility of 3.93 x 10 5 M in 0.02 M of Ba(NO,), solution? Select one O 1.6 x 109 O 12 x 1010* O 2.2 x 10 O 1.0x 1011 2.0 x 10-5
-
What is the output of the following C code? 1 int x=6; 2 int *q=&x, &qq=*x; 3 4 5 (q)=2; (*qq)+-3; int y-(*qq)*((*q)-2); printf("%d",y);
-
Critical values for quick reference during this activity. Confidence level Critical value 0.90 z* = 1.645 0.95 z* = 1.960 0.99 z* = 2.576 469062.3288744.qx3zqy7 Jump to level 1 A poll for a statewide...
-
Below is a hypothetical situation that will allow you to compare two investment options. Your assignment is to review both options and determine which is better and explain why. Assume the following...
-
There are two goods in the economy, apples and bananas. The price of an apple is p = 7. The price of a banana is q = 6. The consumer has wealth equal to W = 168. Let x denote the number of apples and...
-
KN, needed to Question 4: (10 Points): The pump shown below delivers a head of 50 m to the water through 30 cm diameter with pipe length=500 m. The turbine head =20 m. If the head loss is Ly given by...
-
(a) Expand the function 1 f(z) = 22(2-3)2 in a Laurent series on 0
-
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...
-
A chef in a restaurant that specializes in pasta dishes was experiencing difficulty in getting brands of pasta to be al dente-that is, cooked enough so as not to feel starchy or hard but still feel...
-
In NewYork State, savings banks are permitted to sell a form of life insurance called savings bank life insurance (SBLI). The approval process consists of underwriting, which includes a review of the...
-
In forecasting daily time-series data, how many dummy variables are needed to account for the seasonal component day of the week?
-
The English scores for a sample of 14 students Find the mean, the median, and the mode of the data, if possible. If any measure cannot be found or does not represent the center of the data, explain...
-
The salaries (in thousand dollars) of a sample of 10 employees Find the mean, the median, and the mode of the data, if possible. If any measure cannot be found or does not represent the center of the...
-
The durations (in minutes) of idle times at a factory in the last 10 months Find the mean, the median, and the mode of the data, if possible. If any measure cannot be found or does not represent the...
Study smarter with the SolutionInn App