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.

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

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