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

Calculate the yield to maturity, Suppose the current yield curve is as foll...

Suppose the current yield curve is as follows: (a) Calculate the current market prices of two bonds with the following annual cash flows: Bond A: A coupon of $60 is due

Methods of analyzing investment, Methods of Analyzing Investment Capit...

Methods of Analyzing Investment Capital Budgeting Methods There are two process of analyzing the viability of such investment as: a) Traditional process Pay

Factors affecting share prices, Factors Affecting Share Prices The ent...

Factors Affecting Share Prices The entire sorts of influences affect share prices. These influences involves as: 1. The current profit record of the company particularly th

1, what will happen to the loss on account of premium redemption of debentu...

what will happen to the loss on account of premium redemption of debenture through sinking fund? Where do i close this account to?

Agency relationship between auditors and shareholders, Agency Relationship ...

Agency Relationship between Auditors and Shareholders Shareholders appoint auditors as per the provisions of Section 159(1)-(6) of the Companies Act. The auditors are believed

What is the process of investing in securities, What is the Process of Inve...

What is the Process of Investing in Securities ? There are several process of investing in securities:- (1) Finding a Broker (2) Selection of Brokers (3) Opening an Account w

Explain financial funds and supply , What does it mean to say that individu...

What does it mean to say that individuals as a group are net suppliers of funds for financial institutions? What do you think the consequences might be in financial markets if indi

Compound interest and compound amount.., a debt off Rs1000 with interest at...

a debt off Rs1000 with interest at 10% compounded quarterly will be repaid by payments Rs. 200 at the end of 3 months and three equal payments at the end of 6 9 and 12 months. find

Dividend cover ratio, Dividend Cover Ratio Dividend cover = EPS/ DPS =...

Dividend Cover Ratio Dividend cover = EPS/ DPS = Earning to ordinary shares/Dividend paid       This signifies the number of times dividend can be paid from earnin

Bank draft, what is bank draft?How it can be prepared?

what is bank draft?How it can be prepared?

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