Question: For Delta Air Line do a DCF valuation. 3 . Discounted Cash Flows ( DCF ) Valuation 1 . Historical Balance Sheet and Income Statement
For Delta Air Line do a DCF valuation.
Discounted Cash Flows DCF Valuation Historical Balance Sheet and Income Statement Analysis A brief onepage summary format of balance sheet and income statement for the last three years. Show the yearly changes in percentages in an additional column for each accounting item horizontal analysis Do you see any pattern over the years? Can this pattern be based for future values? Is there any anomaly? Compare CAPX Capital Expenditures with Longterm Debt. Does company make wise use of leverage? ie avoid it Form a chart of financial ratios for each year. Start with the basic ratios such as current assetstotal assets, fixed assetstotal assets as well as CAPXtotal assets, PPETotal Assets, similarly Net SalesTotal Assets, Gross Profit GrossmarginNet Sales, EBITDA margin, Marketing & Selling ExpensesSales etc. Then show Liquidity Ratios Current Ratio, Quick Ratio, Receivables Turnover, Inventory Turnover and market performances EP Dividend Yield DP etc. All these ratios will help you set the future values of your income and balance sheet items through which you will derive equityfree cash flows. Projections In the light of your historical values of income and balance sheet items and news that you collected from several investment portals regarding the prospect of the company as well as your intuitive assumptions, you will build up forecasted values of cash flow statements for the next five years. Beta Calculation Cost of Equity or Cost of Capital Calculation Discount all the future free cash flows or equity cash flows with the derived cost of capital or cost of equity Add the terminal value horizon value to the discounted cash flows. Implement a sensitivity analysis Implement a sensitivity analysis
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
