Empire_Students_F23 (2)

xlsx

School

University of Waterloo *

*We aren’t endorsed by this school

Course

373

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

22

Uploaded by BrigadierTitaniumTrout16

Report
EXHIBIT 1 - EMPIRE COMPANY LTD. FINANCIAL STATEMENTS Empire Company Ltd. Consolidated Balance Sheet April 30 (in thousands of dollars) 1998 1997 Assets Current Assets Cash $ 28,268 $ 32,185 Receivables 89,153 78,701 Inventories 197,650 194,126 Prepaid Expenses 15,319 14,100 Investments, at cost (quoted market value $246,418; 1997 $211,468) 156,388 148,746 486,778 467,858 Investments, at equity (quoted market value $800,436; 1997 $575,133) 325,579 300,447 Current assets and marketable investments 812,357 768,305 Fixed assets 1,069,026 1,001,873 Other assets 25,850 27,193 $ 1,907,233 $ 1,797,371 Liabilities and Shareholders' Equity Current Liabilities Bank loans and notes payable $ 286,532 $ 239,757 Payables and accruals 338,774 298,550 Income taxes payable 9,712 11,462 Long term debts due within one year 24,222 89,702 659,240 639,471 Long term debt 616,571 606,843 Minority interest - 171 Deferred income taxes 73,083 71,336 1,348,894 1,317,821 Shareholders' Equity Capital stock 229,889 234,130 Retained earnings 305,422 228,254 Foreign currency translation 23,028 17,166 558,339 479,550 $ 1,907,233 $ 1,797,371 Source: Empire Company Limited Annual Report, 1998
EXHIBIT 1 - EMPIRE COMPANY LTD. FINANCIAL STATEMENTS Empire Company Ltd. Consolidated Income Statement April 30 (in thousands of dollars) 1998 1997 Revenue $ 3,320,000 $ 3,149,773 Cost of sales, selling and administrative expenses 3,127,112 2,971,925 192,888 177,848 Depreciation 70,404 65,433 122,484 112,415 Investment income 41,253 35,568 Operating income 163,737 147,983 Interest expense Long term debt 64,340 70,512 Short term debt 12,328 8,746 76,668 79,258 87,069 68,725 Gain on sale of investments and properties 6,524 1,447 93,593 70,172 Gain on sale of investment in Jannock Limited 35,868 - Share of asset impairment provision by equity accounted investment (8,788) - 120,673 70,172 Income taxes Sale of investment in Jannock Limited 7,792 - Other operations 25,092 16,930 32,884 16,930 Minority interest 7 363 $ 32,891 $ 17,293 Net earnings $ 87,782 $ 52,879 Source: Empire Company Limited Annual Report, 1998
EXHIBIT 3 - OSHAWA GROUP LTD. FINANCIAL STATEMENTS Oshawa Group Limited Consolidated Balance Sheets January 24, 1998 and January 25, 1997 (in millions of dollars) 1998 1997 Assets Current Assets Cash and short-term invetments $ 65.0 $ 20.1 Accounts receivable 318.5 294.8 Income taxes receivable 5.6 0.8 Inventories 302.6 274.2 Prepaid expenses 17.4 16.9 Net assets of discontinued operations - 99.7 709.1 706.5 Fixed assets 501.8 509.7 Other assets 294.7 219.2 $ 1,505.6 $ 1,435.4 Liabilities and Shareholders' Equity Current Liabilities Bank indebtedness $ 17.1 $ 36.0 Accounts payable and accrued liabilities 429.5 379.0 446.6 415.0 Long-term debt 128.6 120.0 Deferred income taxes 36.2 53.9 Unearned revenue 36.4 24.6 647.8 613.5 Shareholders' equity Capital stock 255.9 252.9 Retained earnings 601.9 569.0 857.8 821.9 $ 1,505.6 $ 1,435.4 Source: Oshawa Group Limited Annual Report, 1998
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EXHIBIT 3 - OSHAWA GROUP LTD. FINANCIAL STATEMENTS Oshawa Group Limited Consolidated Statements of Earnings January 24, 1998 and January 25, 1997 (in millions of dollars) 1998 1997 Sales and other revenues - continuing operations $ 6,813.1 $ 5,987.6 Cost of sales and expenses 6,651.7 5,837.5 Depreciation and amortization 66.2 59.7 Earnings from continuing operations 95.2 90.4 Interest (7.9) (6.5) Unusual items (20.3) 8.8 Earnings before income taxes 67.0 92.7 Income taxes (26.9) (38.1) Net earnings from continuing operations 40.1 54.6 Discontinued operations 13.9 0.6 Net earnings $ 54.0 $ 55.2 Source: Oshawa Group Limited Annual Report, 1998
EXHIBIT 6 - SHARE PRICE APPRECIATION OF CANADIAN GROCERY COMPANIES 1997 Two Year Three Year Five Year TSE Food Stores Index 63.2% 32.6% 31.3% 17.6% Empire 64.2% 29.4% 16.5% 15.7% Loblaws 83.0% 58.6% 48.2% 31.9% Metro-Richelieu 42.9% 26.5% 38.7% 26.2% Provigo 55.9% 2.4% 20.1% 2.2% Average 61.8% 29.9% 30.6% 18.7% Oshawa 23.5% 2.1% 10.3% 1.9% Source: Scotia Capital Markets as of December 31, 1997
EXHIBIT 9 - CANADIAN FOOD STORE COMPANY COMPARISON (in millions of dollars) Empire Oshawa Loblaws Provigo Market Value of Equity (as of 2/13/98) 776 951 6,735 850 990 Total Debt 918 135 876 77 327 Enterprise Value* 1,695 1,086 7,629 927 1,317 Revenues 3,208 7,052 10,554 3,432 5,859 EBITDA 219 165 534 155 232 EBITDA Margin 6.8% 2.4% 5.1% 4.5% 4.0% Net Income 59 49 199 66 90 Net Margin 1.8% 0.7% 1.9% 1.9% 1.5% Beta** 0.74 0.77 0.55 0.59 1.20 Credit Rating*** A AA A n/a BBB Source: Bloomberg, Scotia Capital Markets All information based on latest twelve months * Market value of equity, plus market value of debt, less cash ** Beta based on weekly returns over two years *** Canadian Bond Rating Service Rating of Senior Unsecured Debt Risk premiums over government yields were currently around 75 basis points for AAA-rated firms, 100 for AA and 125 for A, and 150 for BBB Metro- Richelieu
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EXHIBIT 10 - HISTORICAL TRANSACTION DATA Target Acquiror Announcement Transaction Size Premium to Enterprise Value to Price to Date Equity Enterprise Consideration 20 Day Avg Revenue EBITDA EBIT Earnings Book (Latest twelve months) (LTM) Carr-Gottstein Safeway Inc. 6-Aug-98 $ 113 $ 319 cash 56.3% 0.55x 6.9x 10.8x n/a 4.4x American Stores Co. Albertson's 3-Aug-98 $ 8,939 $ 11,930 shares 25.8% 0.62x 9.5x 15.4x 26.8x 3.8x Delchamps Inc. Jitney-Jungle Stores 8-Jul-97 $ 227 $ 240 cash 0.4% 0.22x 5.8x 13.5x 26.8x 3.1x Riser Foods Giant Eagle 14-May-97 $ 426 $ 480 cash 15.3% 0.36x 8.5x 13.0x 17.2x 4.9x Vons Companies Safeway Inc. 30-Oct-96 $ 2,498 $ 3,025 shares 25.1% 0.56x 8.8x 13.7x 26.9x 0.9x Kash 'n' Karry Food Stores Food Lion 31-Oct-96 $ 126 $ 347 cash 14.5% 0.34x 6.3x 11.7x n/a 6.5x Stop & Shop Royal Ahold NV 28-Mar-96 $ 1,682 $ 2,795 cash 20.6% 0.68x 8.9x 12.4x 22.3x 1.2x National Convenience Stores Diamond Shamrock 8-Nov-95 $ 186 $ 250 cash 9.9% 0.28x 6.8x 10.9x 19.6x 3.8x Super Rite Richfood Holdings 26-Jun-95 $ 212 $ 327 shares 29.4% 0.22x 6.6x 8.9x 15.9x 5.3x Bruno's KKR 20-Apr-95 $ 947 $ 1,167 97% cash, 3% shares 29.7% 0.41x 9.3x 15.9x 27.9x 2.2x Source: Scotia Capital Markets
EXHIBIT 11 - TRADING RATIOS OF SELECTED CANADIAN GROCERY RETAILERS Year End Enterprise Value to EBITDA Price to Earnings 1997 1998E 1999E 1998E 1999E Empire April 9.5x 7.8x 7.1x 14.6x 11.8x Loblaws December 15.9x 13.6x 11.4x 31.4x 27.0x Metro-Richelieu September 6.5x 6.0x 5.5x 12.4x 11.4x Provigo January 6.0x 5.8x 5.5x 14.8x 12.3x Oshawa January 6.8x 6.7x 5.7x 17.9x 14.6x Source: Scotia Capital Markets
EXHIBIT 12 - 5 YEAR SELECTED HISTORICAL FINANCIAL INFORMATION 1998 1997 1996 1995 1994 1993 Empire Sales 3,320.0 3,149.7 2,915.2 2,699.5 2,577.4 Dep. & Amort. 70.4 65.4 60.0 57.5 50.7 Working Capital 153.1 128.8 178.5 183.6 204.3 Capital Expend. 137.5 82.7 125.7 120.1 98.1 Oshawa Sales 6,813.0 5,988.0 5,765.0 5,650.0 5,305.0 Dep. & Amort. 66.0 60.0 57.0 55.0 50.0 Working Capital 262.0 292.0 193.0 223.0 201.0 Capital Expend. 130.0 135.0 106.0 60.0 59.0 Loblaws Sales 11,008.0 9,848.0 9,854.0 10,000.0 9,356.0 Dep. & Amort. 147.0 122.0 129.0 138.0 126.0 Working Capital 202.0 154.0 179.0 29.0 148.0 Capital Expend. 517.0 389.0 302.0 339.0 315.0 Metro-Richelieu Sales 3,432.3 3,266.0 3,145.6 2,909.0 2,772.7 Dep. & Amort. 39.2 37.0 38.7 40.4 37.1 Working Capital 4.6 1.0 3.8 (4.7) (8.7) Capital Expend. 79.1 57.1 38.0 40.5 19.5 Provigo Sales 5,956.2 5,832.5 5,725.2 5,542.5 5,433.4 Dep. & Amort. 77.6 70.9 62.1 61.0 59.7 Working Capital (45.0) (104.9) (104.3) (24.5) (209.9) Capital Expend. 184.0 171.4 95.3 37.5 41.9 Safeway Sales 22,483.8 17,269.0 16,397.5 15,626.6 15,214.5 Dep. & Amort. 455.8 338.5 329.7 326.4 330.2 Working Capital n/a n/a n/a n/a n/a Capex 829.4 620.3 503.2 352.2 290.2 A&P Sales 10,179.4 10,262.2 10,089.0 10,101.4 10,332.0 Dep. & Amort. 233.7 234.2 230.7 225.4 235.4 Working Capital 90.0 262.1 215.4 191.0 92.3 Capex 438.3 267.6 296.9 236.1 214.9 Source: Annual reports of listed companies
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
WACC (Kc) assumptions: Target Current Weight of debt -- Wd 12.40% Exh.9 Weight of equity -- We 87.60% Risk-free rate -- Rf 10-yr Gov Bond Debt premium exhibit Cost of debt -- Kd (before-tax) Cost of debt -- Kd (after-tax) Kd (before-tax) * (1-t) Beta of equity (levered) 0.77 unlevered Market risk premium (MRP) 5.0% 5.0%assumed Cost of equity -- Ke Rf + B*MRP WACC (Kc) Wd*Kd(after-tax) + We*Ke WACC INPUT BELOW Exh.9 at current D/(D+E)
VALUING OSHAWA 1998 1999 2000 2001 2002 Cash flow assumptions: 0 1 2 3 4 Sales (last 12 months) 7000 $ 7,000 Sales growth for next 5 years (per annum) EBITDA margin (% of sales) -D & A (% of sales) Exh. 12 EBIT -ebit*tax rate est. EBIT*(1-t) +D&A Capital exp year 1 (% of sales) Incremental cap ex years 2-5 (% of sales) -Working capital increase (% of sales change) Exh. 12 FCFF each year (1,2,3,4,5) Terminal value@Time=5 (assume g = 5%!) PV_TerminalValue(5) Tl Ent Value (TEV) = PV_FCFF Less: Debt $ (135)Exh.9 PV of Oshawa Equity (DCF method) shares o/s (millions) 38.6 combine common and class A (assume they have the same valu approx Price/share (DCF method) $ - PV_FCFF_(,1,2,..5) per share (A and common)
Multiples Analysis Oshawa Empire Food appropriate EBITDA x appropriate TEV/EBITDA Multiple TEV estimate Less: debt $ (135) Equity value est.(Multiples method) OSHAWA's EQUITY VALUE: Best estimate, stand alone value judgement call, based on combined DCF and Multples estimate Estimated synergy value cell B21 from synergies template Estimated value of Oshawa if acquired Current market value (price*shares o/s) Total value (NPV) created if acquired How much to offer/bid for Oshawa? Decide how to split the Total NPV between Empire and Oshwa, RESTRUCTURING AND FORM OF PAYMENT: Valuing New Sobeys $million Estimated TEV of Oshawa if acquired similar to Oshawa's equity value in B53, bu from D44 NewCo TEV Less: Debt adopted from Oshawa (assume none from Empire) $ 135 New Debt issued by NewCo (per recommendation) ? Experiment with differing amounts of debt Total NewCo debt Estimated Empire Food TEV
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
NewCo Equity value =TEV-Debt Market D/(D+E) = #DIV/0! Bid Composition (cash + shares of Newco) Total Bid Value for Oshawa Equity $ - Above Cash offered from NewCo new debt proceeds ? Experiment with differing amounts of debt Extra Cash offered from Empire HQ $ 200 Given Total cash consideration #VALUE! $ value of NewCo Equity offered #VALUE! Follows from debt issuance choice #VALUE! % cash = #VALUE! Summary: Empire's percentage ownership of NewCo #VALUE! NPV of deal to Oshawa (premium to market) ? NPV of deal to Empire (total NPV - Oshawa NPV) ? % of NewCo Equity value offered
.. .
beta = ?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2003 5 ue)
es above , i.e., how much to offer Oshawa in your bid. Use precedent transactions, and judgement from your assessment of the situ ut add debt to get TEV, i.e., B53 + 135 debt since TEV=EQUITY + DEBT values) t issued by New Sobeys, and implication for bid composition below
t issued by NewCo (NewSobeys)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
uation.
WACC assumption FCF terminal growth in synergies 0.0% assume no growth, just perpetuity of savings
1998 1999 2000 2001 2002 Cash flow assumptions: 0 1 2 3 4 Sales (last 12 months) 7000 $ 7,000 Sales growth for next 5 years (per annum) EBITDA marg. IMPROVE % (versus 1998) EBITDA marg. IMPROVE $ Cost Synergies Potential EBIT synergy increase -ebit*tax rate EBIT synergy increase*(1-t) FCFF synergy increase Terminal value@Time=5 PV_TV(5) PV_FCFF synergy increases Merger costs upfront (after 40% tax) PV_FCFF synergy increases (net of merger costs) divided by #million shares 38.6 synergy per share $ - Return to DCF base template… Partially realised: PV_FCFF_(,1,2,..5)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2003 5
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help