What is the Enterprise Value of this company? ...

90.2K

Verified Solution

Question

Accounting

What is the Enterprise Value of this company?
image
image
image
image
The company is Dollar General
40 Exhibit 5 Recent Deals/Transaction Multiples (All in million $ except multiples data) Transaction Value/ Value Acquirer Target Value EBITDA EBITDA Revenue Revenue Bain Capital Dollarama $ 1,218.00 100.00 12.18 600.00 2.03 North West Company Cost-U-Less $ 52.42 7.10 224.70 0.23 Sun Capital Partners Shopko Stores $ 905.00 184.78 4. 9 3,091.38 0.29 Average Transaction Value/EBITDA = 8.15 Average Transaction Value/Revenue = 0.85 Industry Average Premium over Market Price = 26% 7.38 Exhibit 6 (Modified) Market Multiples (All in million $ except multiples data) Market Value Equity Book Value (MV) Equity (BV) MV/BV 99 Cent Only Stores $ 1,027.1 $ 519.23 1.98 Biglots $ 3,750.2 $ 1,129.70 3.32 Dollar Tree $ 2,184.3 $ 1,167.70 1.87 Family Dollar $ 3,645.2 $ 1,208.39 3.02 Average Market Value/Book Value of Equity - 2.55 Average Market Value/EBITDA - 13.21 Average Market Value/Net Income = 41.38 MV Debt - - 250.00 250.00 EBITDA 39.2 269.1 469.8 451. 9 Cash 80.0 306.0 281.0 3 07.0 MV/ EBITDA 26.17 $ 13.94 $ 4.65 $ 8.07 $ Net Income (NI) 9.76 124.05 192.00 195.11 MV/NI 105.2 $ 30.2 $ 11.4 $ 18.7 $ EPS 0.14 1.12 1.86 1.26 Appendix 3 Dollar General's Consolidated Income Statements in thousands except per share amounts) February 2, 2007 (52 weeks) For the years enddd February 3, 2006 (53 weeks) January 28, 2005 (52 weeks) Net sales Cost of goods sold Gross profit Selling, general and administrative Operating profit Interest income Interest expense Income before income taxes Income taxes Net Income 9,169,822 6,801,6171 2,368,205 2,119,9291 248,276 -7,002 34,9151 220,363 82,420 137,943 8,582,237 6,117,4131 2,464,824 1,902,9571 561,867 -9,001 26,226 544,642 194,487 350,155 7,660,927 5,397,735 2,263,192 1,706,216 556,976 -6,575 28,794 534,757 190,567 344,190 Earnings per share: Basic 0.44 1.09 1.04 Diluted 0.44 1.08 1.04 Weighted average shares: Basic Diluted 312,556 313,510 321,835 324,133 329,376 332,068 Source: Dollar General 2006 10-K Report Actual Revenues COGS SG&A EBITDA Depreciation EBIT 2007 9,169,822 6,801,617 1,919,321 448,884 200,608 248,276 Appendix 5 (Modified) Projected Financials for Dollar General (in thousands) Projected 2008 2009 2010 2011 10,086,804 11,095,485 12,205,033 13,425,536 7,161,631 7,877,794 8,665,573 9,532,131 1,916,493 2,108,142 2,318,956 2,550,852 1,008,680 1,109,548 1,220,503 1,342,554 221,910 244,101 268,511 295,362 786,771 865,448 951,993 1,047,192 2012 14,768,090 10,485,344 2,805,937 1,476,809 324,898 1,151,911 Balance Sheet Items Cash Net Working Capital Total Debt Actual 2007 189,288 720,589 261,958 2008 201,736.08 706,076.08 4,500,000 2009 221,909.7 776,683.7 4,200,000 Projected 2010 244,100.66 854,352.66 3,700,000 2011 268,510.72 939.787.72 3,000,000 2012 295,361.8 1.033.766.8 2.200.000 Notes: Capital expenditures (CAPEX) is expected to equal depreciation each year. The average interest rate on the different tranches of debt in the Dollar General transaction is 9%. The tax rate is 34% Dollar General's current equity beta is 0.90 The 10-year U.S. Treasury Rate is 4.8% The equity risk premium over the 10-year Treasury is 7%. Dollar General's current stock price is $16.75. Dollar General's shares outstanding are 312,346 in 000s. 40 Exhibit 5 Recent Deals/Transaction Multiples (All in million $ except multiples data) Transaction Value/ Value Acquirer Target Value EBITDA EBITDA Revenue Revenue Bain Capital Dollarama $ 1,218.00 100.00 12.18 600.00 2.03 North West Company Cost-U-Less $ 52.42 7.10 224.70 0.23 Sun Capital Partners Shopko Stores $ 905.00 184.78 4. 9 3,091.38 0.29 Average Transaction Value/EBITDA = 8.15 Average Transaction Value/Revenue = 0.85 Industry Average Premium over Market Price = 26% 7.38 Exhibit 6 (Modified) Market Multiples (All in million $ except multiples data) Market Value Equity Book Value (MV) Equity (BV) MV/BV 99 Cent Only Stores $ 1,027.1 $ 519.23 1.98 Biglots $ 3,750.2 $ 1,129.70 3.32 Dollar Tree $ 2,184.3 $ 1,167.70 1.87 Family Dollar $ 3,645.2 $ 1,208.39 3.02 Average Market Value/Book Value of Equity - 2.55 Average Market Value/EBITDA - 13.21 Average Market Value/Net Income = 41.38 MV Debt - - 250.00 250.00 EBITDA 39.2 269.1 469.8 451. 9 Cash 80.0 306.0 281.0 3 07.0 MV/ EBITDA 26.17 $ 13.94 $ 4.65 $ 8.07 $ Net Income (NI) 9.76 124.05 192.00 195.11 MV/NI 105.2 $ 30.2 $ 11.4 $ 18.7 $ EPS 0.14 1.12 1.86 1.26 Appendix 3 Dollar General's Consolidated Income Statements in thousands except per share amounts) February 2, 2007 (52 weeks) For the years enddd February 3, 2006 (53 weeks) January 28, 2005 (52 weeks) Net sales Cost of goods sold Gross profit Selling, general and administrative Operating profit Interest income Interest expense Income before income taxes Income taxes Net Income 9,169,822 6,801,6171 2,368,205 2,119,9291 248,276 -7,002 34,9151 220,363 82,420 137,943 8,582,237 6,117,4131 2,464,824 1,902,9571 561,867 -9,001 26,226 544,642 194,487 350,155 7,660,927 5,397,735 2,263,192 1,706,216 556,976 -6,575 28,794 534,757 190,567 344,190 Earnings per share: Basic 0.44 1.09 1.04 Diluted 0.44 1.08 1.04 Weighted average shares: Basic Diluted 312,556 313,510 321,835 324,133 329,376 332,068 Source: Dollar General 2006 10-K Report Actual Revenues COGS SG&A EBITDA Depreciation EBIT 2007 9,169,822 6,801,617 1,919,321 448,884 200,608 248,276 Appendix 5 (Modified) Projected Financials for Dollar General (in thousands) Projected 2008 2009 2010 2011 10,086,804 11,095,485 12,205,033 13,425,536 7,161,631 7,877,794 8,665,573 9,532,131 1,916,493 2,108,142 2,318,956 2,550,852 1,008,680 1,109,548 1,220,503 1,342,554 221,910 244,101 268,511 295,362 786,771 865,448 951,993 1,047,192 2012 14,768,090 10,485,344 2,805,937 1,476,809 324,898 1,151,911 Balance Sheet Items Cash Net Working Capital Total Debt Actual 2007 189,288 720,589 261,958 2008 201,736.08 706,076.08 4,500,000 2009 221,909.7 776,683.7 4,200,000 Projected 2010 244,100.66 854,352.66 3,700,000 2011 268,510.72 939.787.72 3,000,000 2012 295,361.8 1.033.766.8 2.200.000 Notes: Capital expenditures (CAPEX) is expected to equal depreciation each year. The average interest rate on the different tranches of debt in the Dollar General transaction is 9%. The tax rate is 34% Dollar General's current equity beta is 0.90 The 10-year U.S. Treasury Rate is 4.8% The equity risk premium over the 10-year Treasury is 7%. Dollar General's current stock price is $16.75. Dollar General's shares outstanding are 312,346 in 000s

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students