I have an assignment due tomorrow can you help me? It's due at midnight tomorrow I have attached the instructions on the word doc and the spreadsheet.

Thanks,

This Assignment uses the same company as in Modules 2 and 3 1. 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 2. Using approach similar to the one described in this module's Excel file, find valuation multiples (ratios) of peer companies. 3. 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 analysis as requested. You will need to use \"Sources of Financial Data\" listed in Course Content to obtain th info/statements for Virgin America Inc., to identify its peer companies and to obtain pricing and financial in A. Choose several peer companies for Virgin America Inc. and justify your choice. Choose several valua using comparable ratios of peer companies (as we did in Project 2 and discussed in Conferences) and V financial information from prospectus, estimate the company's equity value on April 3, 2016. It is req question to list your major assumptions and properly reference sources of information that you used (in millions) (in millions) Using the same company as in Module 1 assignment and its peers, find multiple ratios of peer companies 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 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 n America (Ticker: VA), and provide the Course Content to obtain the necessary financial ain pricing and financial information for them. hoice. Choose several valuation multiples and ussed in Conferences) and Virgin America Inc. e on April 3, 2016. It is required for this information that you used in your calculations. (in millions) (in millions) ple ratios of peer companies and then estimate your nce Sheet here Peer 3 Your Company Solution Legend Downloaded data Formula/Calculation/Analysis required here Your Company $0 $0 - $0 $0 $0 $0 $0 $0