Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, I need an expert in finance to help mewith two homework assignments. Do not claim the question if you are not sure to provide

image text in transcribed

Hello,

I need an expert in finance to help mewith two homework assignments. Do not claim the question if you are not sure to provide accurate answers.. Please read the instructions and fill in the enterprise valuation template ( my company is exxon mobileand per the instructions you have to pick peer companies). Also, the TV homework template has to be filled

image text in transcribed 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 Peer Average 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 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 Using the following set of parameters: Gross Margin: 40% Fixed costs $2,000 Revenue Growth Rate for Years 1 to 5: 10% FCF Steady Growth Rate after Year 5: 3% Discount Rate: 12% Year 1 Revenue: $5,000 Tax Rate 35% Terminal Year: 5 Please answer the following questions; 1) What percentage of the total enterprise value is attributed to the terminal value? 2) How sensitive is your valuation to the inputs? If each input (revenue growth rate for years 1-5, FCF Steady growth rate, or discount rate) changes by 10% of their original value, which input affects the total enterprise value the most? You will have to change each input separately (3 scenarios) to see which input has the greatest effect. Enterprise Valuation & Terminal Value Given Gross Margin Fixed Costs $ Revenue Growth Rate for Years 1 - 5 FCF Steady Growth Discount Rate Year 1 Revenue $ Tax Rate Terminal Year 40% 2,000 10% 3% 12% 5,000 35% 5 1 Revenues Gross profits Fixed Costs Net Operating Income Taxes Free Cash Flow NPV for Years 1-5 Cash Flows Terminal Value (as of Year 5) PV of Terminal Value Enterprise Value PV of Terminal Value / Enterprise Value 2 3 4 Solution Legend Value given in problem Formula/Calculation/Analysis required Crystal Ball Input Crystal Ball Output 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra with Applications

Authors: Steven J. Leon

7th edition

131857851, 978-0131857858

Students also viewed these Finance questions

Question

Evaluate the role of ethical leadership.

Answered: 1 week ago