Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Company Name Net debt + pfd equity + minority int Enterprise value Number of shares Stock price Earnings / share EBITDA Revenue EBIT Book value
Company Name | Net debt + pfd equity + minority int | Enterprise value | Number of shares | Stock price | Earnings / share | EBITDA | Revenue | EBIT | Book value / share | |||||||||
Peer | Bloomin' Brands, Inc. (NasdaqGS:BLMN) | 1,249.5 | 3,424.5 | $97.10 | $5.80 | 265.4 | 3,664.6 | 148.8 | $22.80 | EV/EBITDA | EV/EBIT | EV/Revenue | P/E | P/B | ||||
Peer | Brinker International, Inc. (NYSE:EAT) | 2,293.9 | 4,194.2 | $39.10 | $1.80 | 349.8 | 4,077.4 | 154.5 | -$12.10 | For each multiple, what is the 25th percentile for the relevant peer group? | ||||||||
Peer | BT Brands, Inc. (NasdaqCM:BTBD) | (9.2) | 25.0 | $1.10 | -$0.30 | 4.4 | 12.8 | 6.1 | $0.40 | For each multiple, what is the 40th percentile for the relevant peer group? | ||||||||
Peer | Chipotle Mexican Grill, Inc. (NYSE:CMG) | (3.4) | 9.8 | $2.00 | $0.20 | 0.6 | 12.3 | 0.1 | $1.50 | For each multiple, what is the median for the relevant peer group? | ||||||||
Peer | Chuy's Holdings, Inc. (NasdaqGS:CHUY) | 119.7 | 660.7 | $29.40 | $1.40 | 51.8 | 477.2 | 30.3 | $11.40 | For each multiple, what is the mean for the relevant peer group? | ||||||||
Peer | Cracker Barrel Old Country Store, Inc. (NasdaqGS:CBRL) | (11.8) | 42.6 | $1.70 | -$0.40 | 5.5 | 31.0 | 6.2 | $0.40 | For each multiple, what is the 60th percentile for the relevant peer group? | ||||||||
Peer | Domino's Pizza, Inc. (NYSE:DPZ) | 1,988.8 | 3,218.4 | $9.90 | $0.30 | 582.2 | 2,959.4 | (108.5) | $1.00 | For each multiple, what is the 75th percentile for the relevant peer group? | ||||||||
Peer | Freshii Inc. (TSX:FRII) | 30.7 | 427.5 | $10.90 | $0.60 | 32.1 | 29.2 | 26.6 | -$1.40 | |||||||||
Peer | McDonald's Corporation (NYSE:MCD) | 45,932.7 | 288,536.2 | $297.60 | $8.10 | 12,248.9 | 25,382.3 | 11,447.9 | -$14.10 | EV/EBITDA | EV/EBIT | EV/Revenue | P/E | P/B | ||||
Peer | Muscle Maker, Inc. (NasdaqCM:GRIL) | 1,849.5 | 3,785.6 | $36.60 | $1.10 | 192.3 | 3,470.6 | 96.2 | $1.60 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the 25th percentile for the relevant peer group? | ||||||||
Peer | Pizza Pizza Royalty Corp. (TSX:PZA) | 16,612.2 | 40,965.4 | $69.90 | $3.60 | 2,374.3 | 6,864.6 | 2,124.2 | -$52.90 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the 40th percentile for the relevant peer group? | ||||||||
Peer | Restaurant Brands International Inc. (NYSE:QSR) | 5,496.0 | 19,824.0 | $374.10 | $14.00 | 894.1 | 5,147.9 | 763.3 | -$26.90 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the median for the relevant peer group? | ||||||||
Peer | Starbucks Corporation (NasdaqGS:SBUX) | 660.2 | 7,505.8 | $99.50 | $3.90 | 478.4 | 4,131.2 | 335.3 | $13.30 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the mean for the relevant peer group? | ||||||||
Peer | Super Foods (NYSE:SF) | 12,106.7 | 51,310.7 | $135.00 | $4.70 | 2,401.2 | 7,203.0 | 2,239.5 | -$34.10 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the 60th percentile for the relevant peer group? | ||||||||
Peer | Texas Roadhouse, Inc. (NasdaqGS:TXRH) | 2,268.1 | 4,218.0 | $20.70 | $1.10 | 545.9 | 4,416.6 | 347.8 | -$6.10 | For each multiple, what is the estimated share price for Darden Restaurants based on a peer multiple computed from the 75th percentile for the relevant peer group? | ||||||||
Peer | The Cheesecake Factory Incorporated (NasdaqGS:CAKE) | 2,948.2 | 46,187.8 | $1,527.90 | $30.90 | 1,399.9 | 9,348.7 | 1,196.6 | $95.60 | |||||||||
Peer | Yum! Brands, Inc. (NYSE:YUM) | 22,270.1 | 144,625.6 | $106.60 | $2.80 | 6,188.4 | 36,410.6 | 4,924.0 | -$11.50 | What is the floor (based on the 25th percentile) of the estimated share price from market comps for Darden Restaurants if estimates based on various multiples are given the weights noted in the table below | ||||||||
Subject | Darden Restaurants, Inc. (NYSE:DRI) | 6,196.9 | 27,294.9 | 137.0 | $154.00 | $7.50 | 1,646.2 | 10,453.7 | 1,239.4 | $1.60 | What is the ceiling (based on the 75th percentile) of the estimated share price from market comps for Darden Restaurants if estimates based on various multiples are given the weights noted in the table below | |||||||
Work Area | Do not add any rows or columns to this spreadsheet, but you can work as much as you want in the area below | Multiple | EV/EBITDA | EV/EBIT | EV/sales | P/E | P/B | |||||||||||
Weight | 17% | 31% | 3% | 46% | 3% | |||||||||||||
Step by Step Solution
★★★★★
3.51 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
To calculate the estimated share price for Darden Restaurants based on peer multiples computed from the 25th percentile for the relevant peer group we need to find the peer multiples that fall at the ...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