Answer
WMT | TGT | ||||||
Sales | 485.70 | 73.10 | |||||
EBIT | 26.60 | 4.50 | |||||
Depriciation and Amortization | 9.20 | 2.10 | |||||
Net Income | 16.20 | 2.50 | |||||
Market Cap | 235.60 | 52.90 | |||||
Cash | 9.10 | 2.20 | |||||
Debt | 48.80 | 12.80 | |||||
EBIT Margin | 0.05 | 0.06 | EBIT/SALES | ||||
Net Profit margin | 0.03 | 0.03 | NET INCOME/SALES | ||||
P/E ratio | 14.54 | 21.16 | MARKET CAP / NET INCOME | ||||
Enterprise Value | 195.90 | 42.30 | MARKET CAP - DEBT + CASH | ||||
Enterprise Value to Sales | 0.40 | 0.58 | ENTERPRISE VALUE / SALES | ||||
Enterprise Value to EBIT | 12.09 | 16.92 | ENTERPRISE VALUE / NET INCOME | ||||
Enterprise Value to EBITDA | 7.36 | 9.40 | ENTERPRISE VALUE / EBIT | ||||
Problem Consider the following data as of July 2015 for Walmart and Target Corporation (in $...
You are trying to find an implied value for Target Corporation using financial information from Walmart. You have collected the following: Walmart Statistics: Value: $263,07 billion Market capitalization of common stock $58.78 billion Market value of debt Cash $9.90 billion $36.84 billion EBITDA Target Statistics: Value: Market value of debt $14.69 billion $1.82 billion Cash $8.17 billion EBITDA Shares Outstanding 0.66 billion What is the enterprise value of Walmart? (express answer as xx.xx billion) Submit Answer format: Currency: Round to:...
Consider the following data for the airline industry for July 2018 (EV=enterprise value, Book=equity book value). Suppose Alaska Air (ALK) has 123123 million shares outstanding. Estimate Alaska Air's share value using each of the five valuation multiples, based on the median valuation multiple of the other seven airlines shown. Market Capitalization Enterprise Value (EV) EV/Sales EV/EBITDA EV/EBIT P/E Forward P/E Total Shares Alaska Air (ALK) 7,286 8,207 1.02 5.1 6.7 7.7 12.5 123 Peer Data American Airlines (AAL) 17,879 37,327...
Consider the following data for the airline industry for December 2015 (EV=enterprise value, Book=equity book value) Suppose Hawaiian Airlines (HA) has 52.9 million shares outstanding. Estimate Hawaiian’s share value using each of the five valuation multiples in Table, based on the median valuation multiple of the other seven airlines shown. Market Capitalization Enterprise Value (EV) EV/Sales EV/EBITDA EV/EBIT P/E P/Book Delta Air Lines (DAL) 40857 45846 1.1x 6.0x 7.6x 15.0x 4.0x American Airlines (AAL) 27249...