The Trouble with Lenders: Subtleties in the Debt Financing of Commercial Real Estate: Harvard Case Solution & Analysis

The Trouble with Lenders: Subtleties in the Debt Financing of Commercial Real Estate: Case Solution

Recommendations:

After the detailed qualitative and quantitative analysis, we concluded that Stanley Cirano should refinance the property (Brook line Road Shopping Center) by taking the loan from the Fourth Second Bank because it is giving the lowest interest rate 3.625% with the highest forecasted average ratio of DSCR, which is 3.66. The forecasted capital gain in Market value is 5.3%, which is greater than other alternatives.

Columbus Festival Plaza & its Alternatives:

Columbus Festival Plaza is based on 113,572 Square foot size, located in Class B Shopping Center Elm Park. It was acquired in 2010 by Stanley Cirano through the 55% debt and 45% equity. Now he is confused either to sell it or refinance it through 2 alternatives. First is to finance it by taking the loan from Oakwood Bank and second one is to take the loan from National Bank.For evaluation we took the average of three similar properties for Market Value of Columbus Festival Plaza (Excluding Fox Run Square because it posses the high Market Value which will lead to the unacceptable high average Market value of Columbus Festival Plaza).

Property  Price
 Fox Run Square  Excluded Due to High Value
 363 N Weberr Rd                                           6,400,000
 The Landings                                           9,500,000
 Prairie Point SC                                        18,151,363
 Value of Brook line Road Shopping Center                                        11,350,454

 

For further analysis, we have calculated the Average Growth in Net Operating Income, Average Growth in Net Operating Cash Flow and Average Capital Cost / Net Operating Income Ratio for this property with the assumptions of the 5-year refinancing.

Through above calculated values, we generated the Net Cash Flows of Property by dividing with the Capital Rate provided in the Exhibit 8, is 7.79%. Then we calculated the Present value to find the Capital gain after refinancing for 5-year.

After calculations, we started to compare all the two alternatives for Columbus Festival Plaza, the results will be shown in later.

Alternative 1 (Oakwood Bank Loan):

For Oakwood Bank Loan, we have 65% LTV with 4.9% interest rate and the 25-year Amortization period. The minimum DSCR ratio is 1.25 with the yearly payments of $518,238. Here our forecasted DSCR average ratio is 2.45 with the capital gain in Market value of Columbus Festival Plaza is -14.55%.

Alternative 2 (National Bank Loan):

For National Bank Loan, we have  60% LTV with 4.13% interest rate and the 30-year Amortization period. The minimum DSCR ratio is 1.4 with the yearly payments of $399,838. Here our forecasted DSCR average ratio is 3.17 with the capital gain in Market value of Columbus Festival Plaza is -1.16%.

Recommendations:

After the detailed qualitative and quantitative analysis, we concluded that, Stanley Cirano should sell this property because after analyzing the both alternatives, there is a high chance of declination of the Columbus Festival Plaza’s Market Value in the future because of the forecasted Capital gain from both alternatives is in negative, that means in future they might lose their capital value.

 

Exhibits:

 

Share This

SALE SALE

Save Up To

30%

IN ONLINE CASE STUDY

FOR FREE CASES AND PROJECTS INCLUDING EXCITING DEALS PLEASE REGISTER YOURSELF !!

Register now and save up to 30%.