Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exhibit 1 Landmark Facility Solutions: Simplified Financial Statements, 2010-2014 ($ millions) Income Statement Net Sales COGS Gross profit Operating expenses Depreciation and amortization Operating
Exhibit 1 Landmark Facility Solutions: Simplified Financial Statements, 2010-2014 ($ millions) Income Statement Net Sales COGS Gross profit Operating expenses Depreciation and amortization Operating profit Interest expense Income taxes Net income EPS Dividend Balance sheet Cash 2010 2011 2012 289.9 259.4 30.5 20.9 1.6 8.0 0.0 2.8 5.2 $1.30 $0.20 3.6 20.7 Accounts receivable Other current assets 6.3 Current assets 30.6 Net PP&E 3.1 Investments and other assets Total assets Accounts payable Bank borrowing 45.0 78.7 5.6 0.0 5.6 Current liabilities Accrued expenses and deferred taxes Other non-current liabilities 13.9 16.6 36.1 42.6 Total liabilities Shareholders' equity Total liabilities and equity - | 78.7 83.6 2013 2014 [E] , |2 2 1 | - e 345.5 310.4 35.1 30.3 1.8 3.0 0.0 1.1 2.0 $0.49 $0.20 0.4 31.0 4.9 36.3 11.2 47.2 94.6 10.4 0.0 10.4 15.5 17.9 43.8 50.8 94.6 Exhibit 2 Broadway Industries: Simplified Financial Statements, 2010-2014 ($ millions) 2010 2011 2012 2013 2014 [E] Income statement Net sales 137.8 143.5 149.5 155.3 161.9 COGS 126.1 131.5 137.1 142.5 148.6 Gross profit 11.7 12.0 12.4 12.8 13.3 Exhibit 3a Five-year Forecast of Landmark's Income and Cash Flow, 2015-2019 (S millions)* Operating expenses 2.9 2.9 2.9 3.0 3.0 Depreciation and amortization 1.8 2.2 2.5 2.8 2.9 2015 2016 2017 2018 2019 Operating profit 7.0 6.9 7.0 7.0 7.4 Net sales 362.8 380.9 Interest expense Operating profit 5.4 5.7 6.0 6.3 6.6 04 0.4 0.4 0.4 0.4 Net income 3.7 4.3 Income taxes. Net income EPS Dividends Balance sheet Cash Accounts receivable Other current assets Current assets Net PP&E Total assets 2.3 2.3 2.3 2.3 2.5 Depreciation and amortization 2.1 24 2.7 3.0 3.3 4.3 4.2 4.3 4.3 4.6 Change in net working capital 1.3 1.3 1.4 1.6 $1.23 $1.21 $1.22 $1.23 $1.30 Capital expenditure 3.6 3.8 4.0 4.2 44 $0.24 $0.24 $0.24 $0.24 $0.24 Total FCR 1.0 1.2 1.4 1.8 1.0 1.9 1.5 2.1 13.1 13.5 14.6 15.2 16.2 Exhibit 3b Five-year Forecast of Broadway's Income and Cash Flow, 2015-2019 ($ millions)* 28 4.0 4.1 4.2 2016 4.2 2017 2018 2019 Net sales 168.4 175.1 182.1 189.4 197.0 17.7 18.5 20.6 20.9 22.5 Operating profit 6.7 7.0 7.3 7.6 7.9 16.0 174 18.6 19.7 20.9 Interest expense 0.4 0.4 0.4 0.4 0.4 Investments and other assets 35.9 38.6 41.8 43.2 43.5 Net income 4.1 4.3 4.5 4.7 4.9 69.6 74.5 81.1 83.8 86.8 Depreciation and amortization 3.1 3.3 3.5 3.7 3.9 Accounts payable 9.3 9.9 10.4 11.0 11.5 Change in net working capital 0.4 0.4 0.4 0.4 0.4 Long-term debt, current portion Capital expenditure 4.4 4.6 4.7 0.4 0.4 0.4 0.4 0.4 Total FCF 3.1 3.3 3.5 3.7 Current Liabilities 9.7 10.3 11.4 11.9 Long-term debt 8.2 7.7 87 8.3 7.9 "Numbers in the exhibits are based on the assumption that Broadway does not acquire Landmark Accrued expenses and deferred taxes 11.6 12.8 13.1 13.3 13.0 Other non-current liabilities 11.0 11.2 12.5 114 10.9 Total liabilities 40.5 42.0 45.1 44.4 43.7 Shareholders' equity 29.1 32.5 36.0 39.4 43.1 Total liabilities and equity 69.6 74.5 81.1 83.8 86.8 a Interest rate on long-term debt outstanding is at 4.5% per year. b Principal amount of long-term debt is amortized at $0.4m per year. Exhibit 4 Financial Data of Publically Traded Competitors, 2014 ($ millions, except for per share) Comparable Company 1 Comparable Company 2 Comparable Company 3 Sales 13,945.7 6,417.2 836.9 Net income 219.4 123.8 12.1 EPS $0.95 $1.84 $0.55 Share price 26.76 46.83 22.73 Number of shares outstanding 231.2 67.3 22.0 Market capitalization 6,186.9 3,151.7 500.1 Debt 5,887.0 355.0 289.0 Assets 10,267.1 3,465,9 862.4 Equity beta 1.69 1.25 1.56 Exhibit 5 Selected Capital Markets Information, as of September 1, 2014 Treasury rates: 3-month Treasury bill 1-year Treasury note 10-year Treasury note 0.04% 0.10% 2.56% Corporate bond yields: Aaa 4.16% Aa 4.34% A 4.52% Baa 4.70% Market risk premium: 5.90% Appendix F: PV of Broadway Pre-Acquisition: Pre-Acquisition Five-year Forecast of Broadway's Income and Cash Flow, 2015-2019 (U.S. $ millions)* 2015 2016 Terminal 2017 2018 2019 Value Net Sales 168.4 175.1 182.1 189.4 197.0 Operating Profit 6.7 7.0 7.3 7.6 7.9 Interest Expense 0.4 0.4 0.4 0.4 0.4 Net Income 4.1 4.3 4.5 4.7 4.9 Depreciation and Amortization 3.1 3.3 3.5 3.7 3.9 Change in Net Working Capital 0.4 0.4 0.4 0.4 0.4 Capital Expenditure 4.2 4.4 4.6 4.7 4.9 WACC Total FCF PV FCF Total PV FCF 0.0875 2.8 0.0875 0.0875 0.0875 0.0875 0.0875 3.1 3.3 3.5 3.7 90.98 2.68 87.32 2.84 2.89 2.93 2.97 73.01 FCF = Net Income + Depreciation - Capital Expenditures - Increase in Net Working Capital TV (FCFn (1 + g)) / (WACC - g) TV= 3.7 (1.045) / (0.0875 -0.045) = 90.98 PV FCF = FCFt/ (1 + WACC)^t Total PV FCF= 2.68 +2.84 +2.89 +2.93 +2.97+73.01 = 87.32 Appendix E: PV of Broadway Post-Acquisition: Post-Acquisition Five-year Forecast of Broadway's Income and Cash Flow, 2015-2019 FCF 2020 for Termina (U.S. $ millions)* 2015 Net Sales 2016 2017 2018 2019 145.71 131.14 142.94 155.81 169.83 TV 1 Value 177.47 Gross Margin 8.5% 8.5% 9% 9% 9.5% 12.39 11.15 12.86 14.02 16.13 Operating Expenses 2% 2% 2% 2% 2% 2% 2.91 2.62 2.86 3.12 3.40 Operating Profit 9.48 8.53 10 10.9 12.73 Net Income 6.16 5.54 6.5 7.09 8.27 Depreciation and Amortization 3.10 3.3 3.5 3.7 3.9 4.1 Net Working Capital Change in Net Working Capital Capital expenditure 3.06 2.75 3.0 3.27 3.57 3.73 FCF WACC N/A Present Value of FCF Total PV of FCF N/A FCF = Net Income + Depreciation - Capital Expenditures - Increase in Net Working Capital TV = (FCFn* (1+ g)) / (WACC - g) Where: TV = terminal value g=perpetual growth rate of FCF n= FCF in year 2019 TV 200/700010 0016101 The task force suggested that with the new premium pricing strategy, Broadway's revenue would decline by 10% a year in both 2015 and 2016, but would then grow at 9% a year for three years, and 4.5% thereafter. It expected that the premium pricing strategy would improve Broadway's gross margin to 8.5% in 2015 and 2016, 9% in 2017 and 2018, and 9.5% thereafter. The task force also expected that operating expenses as a percentage of sales would remain constant at 2%, starting in 2015. Capital expenditure would be reduced to 2.1% of annual sales. Depreciation would grow by $200,000 a year. It expected the corporate tax rate to remain at 35% per year for both companies. Nonetheless, the task force had doubts about its assumptions regarding management and net working capital. Nor was it certain whether Broadway's accounting team and financial officers could manage the larger, more complex organization. Managing a combined entity double the size of Broadway, with coast-to-coast operations, would be challenging. The premium pricing strategy might not work, and forecasted increases in operating margins might be too optimistic. In a pessimistic scenario, Landmark's net working capital would be 7% of sales from 2015 to 2017 and 6.5% in 2018 and thereafter. Its operating margin would reach a steady state of 2.5% by 2017 and thereafter. The premium pricing strategy might result in a 15% decline in revenue a year for Broadway, in 2015 and 2016, before it would grow again at 8% a year for three years, and at 3.5% a year thereafter-lower than the long- term growth rate of Broadway, without the acquisition. Broadway's gross margin would be 8.5% from 2015 to 2017, and 9% in 2018 and thereafter. Operating expenses as a percentage of sales would be 2.4% in 2015 and thereafter. All other projections would be the same as in the expected scenario. The market reaction to the proposed acquisition had been mixed. Some investment banks reacted negatively to it, citing concern about whether Broadway could manage the combined business and
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started