1. What is quantity 1?

2. What is quantity 2?

3. What is the absolute value of quantity 3?

4. What is the absolute value of quantity 4?

5. What is quanity 5?

6. What is quantity 6?

7. What is quantity 7?

8. According to this model, should your firm buy UBA?

YES

No.

Valuing an Entity with Buy-Manage-Sell Model Introduction Urstadt Biddle Properties Inc. (UBA) is a profitable, debt-free REIT that invests in grocery-store, pharmacy and dollar store buildings. Although the company has been operating in steady-stare for years, its share price has collapsed during the Covid Pandemic, along with REITs focused on office buildings and theatres. (The above is a simplified but basically true story. The numbers below are simplified for this problem). Your PE firm is considering buying UBA at the asking price of: $400 MM This corresponds to a PE ratio of: 5.86 Your firm believes that an optimal capital structure for the firm would be: 40% D/(D+E) If your firm buys UBA, it will: - Pay (1-D/D+E))% of the purchase price with your firm's funds. - Have the firm take out a loan at the moment of close, to pay the current owners the rest of the purchase price. - Operate UBA in its recapitalized steady-state for four years. - Sell UBA at the end of this time, when you believe the entity's PE ratio will have recovered to a more normal value of: 7.9121 Existing As purchased $400 $400.0 Financing Structure D+E = CAP tot D/D+E) = WD D E 40.0% 0.0% $0.0 $400.0 1 2 Key Rates ID (Pre-tax) Existing As purchased 6.0000% 7.0000% 6.5000% 8.8833% 35.00% I'E Income Tax rate Free Cash Flows FCF E = Free Cash Flows to Shareholders Existing Income Statement D= $0.0 Revenue $400.00 - Depreciation ($150.00) - Other Expenses ($145.00) = EBIT $105.00 As Purchased $400.00 ($150.00 ($145.00) $105.00 -Interest - Tax = NI $0.00 ($36.75) $68.25 3 4 $60.9700 Accept this as correct, even if it does not add up for you. - A Working Capital + Depreciation = CF operations. E $0.00 $150.00 $218.25 - CAPX + A Debt = FCFE ($150.00) $0.00 $68.25 5 Valuation at T=0 NPVE = -Pp, e + FCFe, i/ (1 + Te)Ti + Sp, e/ (1+re)14 SpE 6 NPVE = 7 Valuing an Entity with Buy-Manage-Sell Model Introduction Urstadt Biddle Properties Inc. (UBA) is a profitable, debt-free REIT that invests in grocery-store, pharmacy and dollar store buildings. Although the company has been operating in steady-stare for years, its share price has collapsed during the Covid Pandemic, along with REITs focused on office buildings and theatres. (The above is a simplified but basically true story. The numbers below are simplified for this problem). Your PE firm is considering buying UBA at the asking price of: $400 MM This corresponds to a PE ratio of: 5.86 Your firm believes that an optimal capital structure for the firm would be: 40% D/(D+E) If your firm buys UBA, it will: - Pay (1-D/D+E))% of the purchase price with your firm's funds. - Have the firm take out a loan at the moment of close, to pay the current owners the rest of the purchase price. - Operate UBA in its recapitalized steady-state for four years. - Sell UBA at the end of this time, when you believe the entity's PE ratio will have recovered to a more normal value of: 7.9121 Existing As purchased $400 $400.0 Financing Structure D+E = CAP tot D/D+E) = WD D E 40.0% 0.0% $0.0 $400.0 1 2 Key Rates ID (Pre-tax) Existing As purchased 6.0000% 7.0000% 6.5000% 8.8833% 35.00% I'E Income Tax rate Free Cash Flows FCF E = Free Cash Flows to Shareholders Existing Income Statement D= $0.0 Revenue $400.00 - Depreciation ($150.00) - Other Expenses ($145.00) = EBIT $105.00 As Purchased $400.00 ($150.00 ($145.00) $105.00 -Interest - Tax = NI $0.00 ($36.75) $68.25 3 4 $60.9700 Accept this as correct, even if it does not add up for you. - A Working Capital + Depreciation = CF operations. E $0.00 $150.00 $218.25 - CAPX + A Debt = FCFE ($150.00) $0.00 $68.25 5 Valuation at T=0 NPVE = -Pp, e + FCFe, i/ (1 + Te)Ti + Sp, e/ (1+re)14 SpE 6 NPVE = 7