Analysis of price and financial leverage , Finance Basics

Assignment Help:

The Bayview Investment Partners owns an office building near Shoal Creek and Anderson lane in suburban Dallas. The building is ten years old. Bayview is willing to sell the property for $13,500,000 or $122.7 per square feet which is a firm price. There is an outstanding mortgage balance of $9,045,000 on the property that the buyer could assume since the mortgage is assumable. The contract rate on the mortgage is 9% (monthly payments), with a remaining term/amortization period of 22 years. So the existing first mortgage is a fully amortizing mortgage. If the buyer assumes the outstanding mortgage balance the amount of equity investment that will then be required is $4,455,000. If the first mortgage were assumed by the buyer, the required debt service would be based on the remaining amortization/term of mortgage of 264 months and contract interest rate of 9%. The average market capitalization rate (cap rate) for similar properties in the market area ranges from 8% to 11.50% and the typical gross income multiplier for such properties is about 3.5 to 5.43 times. The property under consideration is an 11 story class A office building rented to a publicly traded firm that is rated single A, and has a total square footage or gross leasable area (GLA) of about 110,000 square feet. The average asking rent in the building is $27.70/year/square feet of GLA. Asking rent for similar properties in the market area range from $25 to $35 per square feet of GLA, and the price square feet for such properties range from $75/square feet to $132/square feet, which is perhaps indicative of the volatility in property prices. Vacancy and bad debt for the building is estimated to be 6.4% of potential gross income (PGI). However, operating expenses are determined to be predominantly variable and as such are stated as 51.62% of effective gross income (EGI).

Alcon Partners L.L.C is seriously considering purchasing the property offered by Bayview and your company, Allan Poots Partnership, has been retained as analyst and consultant to the seller of the property Bayview Investments Partners. Bayview may also chose to not sell the property now. It may hold the property for two years and then refinance the property. As part of this consulting assignment there are a number of analyses that needs to be conducted to assess the feasibility of the options, i.e. Bayview selling the property now via wraparound mortgage or holding the property for two more years and then refinancing the property with better mortgage terms. The series of tasks are stated below.

TASK 1: Analysis of asking Price and Financial Leverage Analysis

Baywiew is exploring the possibility of selling the property and Alcon Partners, the group of equity investors, is interested in buying the property. Both Bayview and the partnership would like know how the asking price of $13.5 M compares with prices for similar properties in the market area. One immediate issue that you need to address in this part of the case is whether the offer or ask price is a competitive and fair offer or is the property overpriced or underpriced? There are a number of performance and valuation metrics we have studied in this course that you can use to address the issues such as cap rate, gross income multiplier, net income multiplier, price per square foot, etc. Of course you are not limited to these metrics. So as an analyst you should feel free to include other meaningful and relevant metrics in your analysis.

Another issue facing Alcorn is potential for negative financial leverage. Alcorn suspects that if it assumes the existing mortgage and invests the required equity amount to complete transaction financial leverage will be negative. In static real estate analysis, negative financial leverage exists whenever ROI (or CAP RATE) < MC; EDR < ROI and EDR

First, analyze the asking price to determine whether the asking price is fair and competitive. Second, determine whether the leverage situation is positive or negative based on the asking price of $13.5M and assuming the Alcorn uses the outstanding mortgage balance of $9,045,000 and the equity investment that will be required to complete the transaction. Write a memo discussing your analysis, conclusions and recommendations

TASK 2: How Best to Finance the Transaction by Alcon Partners:

There are other complicating issues. First, the maximum equity investment that Alcon Partners can make towards the purchase of the property is $2,895,750. The partnership has concluded that any amount of equity investment in excess of this amount is not financially prudent and Alcorn will not invest more than the maximum equity investment of $2,895,750. Furthermore, Alcorn wants an equity dividend rate (EDR) or return on equity (ROE) of at least 10% to make this transaction attractive for the partnership. If Alcorn is correct in its assessment that leverage is in fact negative, this will imply that the EDR from investing in the property will be below its required hurdle EDR of 10%. This is because at the asking price of $13.5M, which is a firm price, and by assuming the existing outstanding balance of $9,045,000, the equity investment will be greater than the maximum equity of $2,895,750 Alcorn can tolerate.

The situation is further complicated. Although adverse national office market conditions have improved, the availability of new commercial mortgage loans is still limited. Market interest rate on straight commercial mortgages hovers around 9.5%, at least. Alcorn is not optimistic about getting a straight loan from a commercial lender at any rate below the market rate figure of 9.5%. However, Bayview Investment Partners (the owner of the property) believes that a wraparound mortgage can be realistically structured to satisfy the constraints of Alcon Partners and make the sale possible, which means that in the process of structuring wraparound mortgage Alcorn Partners (the buyer) must also realize its hurdle rate of at least 10%. Bayview Partners is prepared to make the wraparound and the lender on the existing first mortgage will have no objection to a wraparound mortgage that includes the outstanding amount on the existing first mortgage. However, the wraparound must also satisfy the normal characteristics of wraparounds in terms of its contract rate being below market rate but above the contract rate on the existing first mortgage, and the yield (internal rate of rate return) to the wrap lender (Bayview Investment Partners) must exceed the contract rate on the wraparound mortgage and the prevailing market interest rate.

Taking into consideration the above constraints facing Alcorn Partners, the potential purchasers of the property and the yield requirement of Bayview Investment Partners, your firm has been asked to structure the wraparound mortgage that will satisfy both Alcorn (the buyer of the property), the wrap lender (Bayview, the seller of the property), so as to make the transaction feasible. Your solution must be practical, in the sense that it must satisfy the characteristics normally associated with wraparound mortgages as discussed in the course and above. That is both the lender/seller (Bayview) and the equity investors (Alcorn) must realize their objectives. Please include a memorandum explaining your analysis, major findings, conclusions and recommendations

HINT IN SOLVING THIS PART OF THE CASE: In structuring the wraparound you should note that the term of a loan is not necessarily equal to its amortization period. Therefore, you can take advantage of the balloon mortgage format to structure a feasible wraparound.

TASK 3: Refinancing of the Property by Bayview and Holding it in its Portfolio for 10 years.

It is also likely that market rates would decline in about two years. So as an alternative, Bayview is also considering holding the property for two more years instead of selling it now with a wraparound mortgage. The existing mortgage is three years old at the point of the sale of the property. It is projected that market situation would have improved by the end of the two-year period to permit refinancing of the property at reasonable terms: interest rate of 7.5%, 30-year amortization with monthly payments. The refinancing cost on the new loan is projected to be 3 percent of the amount being refinanced, i.e. the outstanding balance. The old loan also requires a yield-maintenance premium to be paid to the lender for any unscheduled principal payment during the first six years of the loan. Refinancing will occur at end of 5th year (3+2) of the existing loan at which time the balance on the existing loan will be repaid; thus there will be one year remaining in the yield maintenance period. At the time the existing loan was originated the yield on Treasury securities was 6.5 and at the prepayment date when the refinancing is to be undertaken the Treasury yield is forecasted to be 4.75%. After refinancing, Bayview Investments plans to hold property for ten more years and prepay the balance of on the new (refinanced) loan. The discount rate for Bayview Investment on alternative risk of similar risk is 10%.

Now assume your firm is also retained by Bayview to assist in this proposed refinancing decision. Analyze this refinancing proposition by computing the NPV and the internal rate of return from the refinancing.

TASK 4: Your Complete Report

Finally, write a report to the senior partner of Bayview Mr. Will McLean detailing your analysis, findings, and interpretation of the results, conclusions and recommendations. In your report be sure to discuss your analysis of selling price of the property, analysis of the issue of whether or not Bayview should do the wraparound and sell the property now or hold on to the property and refinance two years later. What are the advantages of doing the refinancing? What are the limitations of your analysis? Feel free to include other arguments for and against each scenario.


Related Discussions:- Analysis of price and financial leverage

Cost of retained earnings common equity, Clemson Software is considering a ...

Clemson Software is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciate

Money market mutual funds (), why i cant found date for mmmfs like total as...

why i cant found date for mmmfs like total asset or number of share or return ???? i search alot and i found words instead of number

Debtors or accounts receiver turnover, Debtors or Accounts Receiver Turnove...

Debtors or Accounts Receiver Turnover Formula is as follow: Debtors/accounts receiver turnover  = Annual credit sales/Average debtor The ratio signify the number of ti

Private limited companies, Private Limited Companies These are NOT per...

Private Limited Companies These are NOT permitted to advertise their shares so like to attract public money and so that they sell their shares privately as recognized as priva

WACC, #The following is the existing capital structure of Company XYZ Ltd. ...

#The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.

The equity discount rate , Assume IBM pays out all earnings as dividends. ...

Assume IBM pays out all earnings as dividends. Today is t = 0 and IBM just paid a $2 dividend on $2 of earnings. The market expects dividends will grow each year by 5% until t = 4

Pre-tax cost of debt capital, Current cost of a bond: You know that the aft...

Current cost of a bond: You know that the after-tax cost of debt capital for Bubbles Champagne is 7 percent. If the firm has only one issue of five-year maturity bonds outstanding,

State the realised and expected return, State the Realised and Expected Ret...

State the Realised and Expected Return Return is not as simple a notion as it appears to be as it's not guaranteed, it is mostly expected, and it may or may not be realized.

Determine the weighted average cost of capital, 1. The current interest rat...

1. The current interest rate is 6.83%. CanGo.com's stock has a beta of 2.0. Estimate the cost of equity. 2. CanGo.com has a bond with a semiannual coupon rate of 9% and 5 year m

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd