Please help me with these. I am struggling with this chapter. Even formulas would be an excellent help for me to plug in the numbers and better understand this concept. Thank you!

Consider this information for all the following questions. Errata: The line reading "Pay (1-D/(D+E))%.." should read "Pay (1-D)/(D+E)%..." 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 Financing Structure D + E = CAP to DI (D+E) = WD D E Existing As purchased $400 $400.0 0.0% 40.0% $0.0 1 $400.0 2 Existing As purchased 6.0000% 7.0000% Key Rates Ip (Pre-tax) TE Income Tax rate 6.5000% 8.8833% 35.00% 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 + $0.00 $150.00 $218.25 = CF operations, E - CAPX + A Debt = FCFE ($150.00) $0.00 $68.25 5 Valuation at T=0 NPVE = -PP, e + S FCFg,i/ (1 + Te)" + Sp.E/ (1+re)T4 E Spe= = 6 NPVE = = 7 Question 3 What is the absolute value of quantity 3? 0 Question 4 What is the absolute value of quantity 4? 36.75 Question 5 What is quanity 5? 72.17 Question 6 What is quantity 6? 411 Question 7 What is quantity 7? 256.6 Consider this information for all the following questions. Errata: The line reading "Pay (1-D/(D+E))%.." should read "Pay (1-D)/(D+E)%..." 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 Financing Structure D + E = CAP to DI (D+E) = WD D E Existing As purchased $400 $400.0 0.0% 40.0% $0.0 1 $400.0 2 Existing As purchased 6.0000% 7.0000% Key Rates Ip (Pre-tax) TE Income Tax rate 6.5000% 8.8833% 35.00% 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 + $0.00 $150.00 $218.25 = CF operations, E - CAPX + A Debt = FCFE ($150.00) $0.00 $68.25 5 Valuation at T=0 NPVE = -PP, e + S FCFg,i/ (1 + Te)" + Sp.E/ (1+re)T4 E Spe= = 6 NPVE = = 7 Question 3 What is the absolute value of quantity 3? 0 Question 4 What is the absolute value of quantity 4? 36.75 Question 5 What is quanity 5? 72.17 Question 6 What is quantity 6? 411 Question 7 What is quantity 7? 256.6