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

Government - measuring business performance, Government - Measuring Busines...

Government - Measuring Business Performance Government The Government is interested particularly in utility companies as KPLC, KPTC and such will offers public services -

Find the costs of financing, Find the costs of financing for two schedules ...

Find the costs of financing for two schedules of monthly payments on a 25-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6%

Constraints of venture capital in us, Constraints of Venture Capital in US ...

Constraints of Venture Capital in US 1. Require of rich investors in US, thus inadequate equity capital. 2. Inefficiencies of stock market - NSE is investors and inefficien

Healthcare Finance, If Metropolis Healthcare Systems have 1,150,000 in cash...

If Metropolis Healthcare Systems have 1,150,000 in cash. How long will it take them to accumulate 2,000,000 in cash? Assume an interest rate of 5%..

Advantages of bonus matter, Advantages of Bonus Matter a) Tax advanta...

Advantages of Bonus Matter a) Tax advantages         Shareholders can sell new shares, and create cash in form of capital gains such is tax exempt unlike cash dividends wh

Origination fees, jack needs to borrow $1000 for the next year. Bank south ...

jack needs to borrow $1000 for the next year. Bank south will give him the loan at 9%. Suncoast will give him the loan at 7% with a $50 loan orgination fee. First national will giv

Financial position, what is the financial position of the company in term...

what is the financial position of the company in term of leverage, liquidity and fluidity? Were the position better in 2013 compared to 2012 ? Possible ratios : - Levera

Foreign credit insurance association (fcia), Foreign Credit Insurance Assoc...

Foreign Credit Insurance Association (FCIA) An agent of the Export/Import Bank, FCIA gives exporters with insurance coverage beside both commercial and political risk. The main

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