This Assignment uses Wal Mart Inc and Shack Shack

• Choose peer companies for your company and download their relevant financial data. You don't have to download entire financial statements ? only the items used in multiples valuation
• Using approach similar to the one described in this module's Excel file, find valuation multiples (ratios) of peer companies.
• Estimate your company's equity value and enterprise value

I suggest starting from the "Multiples Valuation Template" in Module 4 Excel file and adjust it accordingly

This exam requires you, among other things, to estimate the stock price for Virgin America (Ticker: VA), and provide the analysis as requested. You will need to use \"Sources of Financial Data\" listed in Course Content to obtain the necessary financial info/statements for Virgin America Inc., to identify its peer companies and to obtain pricing and financial information for them. A. Choose several peer companies for Virgin America Inc. and justify your choice. Choose several valuation multiples and using comparable ratios of peer companies (as we did in Project 2 and discussed in Conferences) and Virgin America Inc. financial information from prospectus, estimate the company's equity value on April 3, 2016. It is required for this question to list your major assumptions and properly reference sources of information that you used in your calculations. (in millions) (in millions) (in millions) (in millions) Using the same company as in Module 1 assignment and its peers, find multiple ratios of peer companies and then estimate your company's equity value and enterprise value. Peer Companies: Ticker PERIOD ENDING Peer 1 Peer 2 From Income Statement and Balance Sheet Balance Sheet Insert Relevant Items here Peer 3 Your Company Insert Relevant Items here Income Statement Insert Relevant Items here Calculated Multiples EV/EBITDA Multiple P/E Multiple Market to Book Multiple Price/Revenue Multiple Your Company Valuation Enterprise Value based on EV/EBITDA multiple Plus: Your Company Cash Less: Your Company Interest-bearing debt Total Equity value based on EBITDA VA Shares Outstanding (millions) Equity value per share Equity value per share based on P/E multiple Total Equity value based on P/E multiple Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on P/E multiple Equity value per share based on MTB Ratio Total Equity value based on MTB ratio Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on MTB ratio Equity value per share based on P/Revenue ratio Total Equity value based on P/Revenue ratio Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on P/Revenue ratio ide the essary financial ion for them. multiples and America Inc. for this r calculations. hen estimate your Solution Legend Downloaded data Formula/Calculation/Analysis required Your Company $0 $0 - $0 $0 $0 $0 $0 $0 This exam requires you, among other things, to estimate the stock price for Virgin America (Ticker: VA), and provide the analysis as requested. You will need to use \"Sources of Financial Data\" listed in Course Content to obtain the necessary financial info/statements for Virgin America Inc., to identify its peer companies and to obtain pricing and financial information for them. A. Choose several peer companies for Virgin America Inc. and justify your choice. Choose several valuation multiples and using comparable ratios of peer companies (as we did in Project 2 and discussed in Conferences) and Virgin America Inc. financial information from prospectus, estimate the company's equity value on April 3, 2016. It is required for this question to list your major assumptions and properly reference sources of information that you used in your calculations. (in millions) (in millions) (in millions) (in millions) Using the same company as in Module 1 assignment and its peers, find multiple ratios of peer companies and then estimate your company's equity value and enterprise value. Peer Companies: Ticker PERIOD ENDING Current Assets Cash and Cash Equivalents Net Receivables Inventory Total Current Assets Fixed Assets Goodwill Total Assets Current Liabilities Accounts Payable Target Costoco TGT COST 1/30/2016 8/28/2016 From Income Statement and Balance Sheet Balance Sheet (Value's '000s) Kroger KR 1/28/2017 Wal-mart WMT 1/31/2016 $2,512,000 $322,000 $1,649,000 $6,561,000 $10,340,000 $21,016,000 $3,031,000 $36,505,000 $8,705,000 $5,624,000 $44,469,000 $60,239,000 $116,516,000 $16,695,000 $199,581,000 $8,309,000 $11,990,000 $24,658,000 $3,379,000 $1,252,000 $8,969,000 $15,218,000 $17,043,000 37,431,000 $33,163,000 $10,989,000 $11,110,000 $7,303,000 $58,615,000 Short-Term Debt / Current Portion of Long-Term Debt Total Current Liabilities Long-Term Debt Deferred Liability Charges Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Other Equity Total Equity Total Liabilities & Equity $1,718,000 $12,708,000 $11,031,000 $861,000 $1,100,000 $15,575,000 $4,061,000 $7,303,000 $26,478,000 $253,000 $21,084,000 $12,860,000 $11,825,000 $1,927,000 $12,000 $29,807,000 $6,004,000 $64,619,000 $44,030,000 $7,321,000 $3,065,000 $119,035,000 $46,000 $5,661,000 $5,884,000 ($638,000) $10,953,000 $37,431,000 $2,000 $5,490,000 $7,686,000 ($1,099,000) $12,079,000 $33,163,000 $1,918,000 $3,070,000 $15,543,000 ($13,833,000) $6,698,000 $36,505,000 $317,000 $1,805,000 $90,021,000 ($11,597,000) $80,546,000 $199,581,000 $69,495,000 $118,719,000 $48,872,000 $102,901,000 $20,623,000 $15,818,000 $115,337,000 $89,502,000 $25,835,000 $482,130,000 $360,984,000 $121,146,000 $22,399,000 $3,436,000 $97,041,000 $24,105,000 $81,000 $24,186,000 $2,548,000 $21,638,000 $6,558,000 ($386,000) $15,080,000 $14,694,000 $14,694,000 Income Statement Total Revenue Cost of Revenue Gross Profit Operating Expenses Sales, General and Admin. Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders Calculated Multiples $16,878,000 $4,969,000 $4,969,000 $1,004,000 $3,965,000 $1,296,000 $2,669,000 $2,737,000 $2,737,000 $12,068,000 $3,672,000 $80,000 $3,752,000 $133,000 $3,619,000 $1,243,000 ($26,000) $2,350,000 $2,350,000 $2,350,000 $3,436,000 $522,000 $2,914,000 $957,000 $18,000 $1,975,000 $1,975,000 $1,975,000 EV/EBITDA Multiple P/E Multiple Market to Book Multiple Price/Revenue Multiple Your Company Valuation Enterprise Value based on EV/EBITDA multiple Plus: Your Company Cash Less: Your Company Interest-bearing debt Total Equity value based on EBITDA VA Shares Outstanding (millions) Equity value per share Equity value per share based on P/E multiple Total Equity value based on P/E multiple Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on P/E multiple Equity value per share based on MTB Ratio Total Equity value based on MTB ratio Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on MTB ratio Equity value per share based on P/Revenue ratio Total Equity value based on P/Revenue ratio 5.61 11.03 2.80 0.50 14.29 28.42 5.92 0.60 7.05 14.46 4.00 0.20 7.99 16.42 2.88 0.50 Plus: Your Company Interest-bearing debt Less: Your Company Cash and equivalents Enterprise value based on P/Revenue ratio alysis as tatements for nd using nancial ist your major ate your Solution Legend Downloaded data Formula/Calculation/Analysis required Wal-mart #REF! #REF! 15,080,000 #REF! #REF! #REF! #REF! #REF! #REF