Course Hero Logo
Question
Answered step-by-step

Hello, I need help with my Finance Assignment. I uploaded the...

Hello,

I need help with my Finance Assignment. I uploaded the instructions and the Excel template that we have to use.

Please let me know if you have any questions.

Thank you for your help.

2 Attachments
This Assignment uses the same company as in Modules 2 and 3 Company Selected: Delta Air Lines (DAL) 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
Background image of page 1
1 page
Enterprise Valuation & Terminal Value Given Gross Margin 40% Fixed Costs $ 2,000 Revenue Growth Rate for Years 1 - 5 10% FCF Steady Growth 3% Discount Rate 12% Year 1 Revenue $ 5,000 Tax Rate 35% Terminal Year 5 1 2 3 4 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
Background image of page 1
2 pages
Answer & Explanation
Verified Solved by verified expert
Rated

rem ipsum dolor sit amet, consectetur adipiscing elit. Nam laci

, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum d

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Step-by-step explanation

ur laoreet. Nam risus ante, dapibus a molestie consequat,

congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui
1 Attachment
Revised Completed Homework Template.xlsx
xlsx
Student reviews
67% (3 ratings)