Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

creat a report by using a data for Delta airlines, make sure to include the CEO, CFO, the background and all valubale informmation about the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
creat a report by using a data for Delta airlines, make sure to include the CEO, CFO, the background and all valubale informmation about the company
urgently needed
Your SAR Stock \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} Your SAR Stock \\ Free cash flow to the firm (FCFF) forecast \end{tabular}}} & & \multicolumn{5}{|c|}{ Model values the stock at P(0) - Today's value } \\ \hline & & & & & \multicolumn{5}{|c|}{ Change FCFF(0) to calculate P(1) - One year from today } \\ \hline & & & & & (FCFF(O) (1+g) & & & & \\ \hline \multicolumn{10}{|c|}{ USS in millions, except per share data } \\ \hline Year & \multicolumn{2}{|l|}{ Value } & Growth & FCFF (t) or TV(t) & Present value at & WACC & 3.53% & & \\ \hline 0 & FCFF(0) & 2022 & \multirow[b]{2}{*}{3.5%} & (5,190,720,000) & (5,190,720,000) & & & & \\ \hline 1 & FCFF(1) & 2023 & & (5,372,395,200) & (5,189,355,739) & & & & \\ \hline 2 & FCFF(2) & 2024 & 2.2% & (5,490,163,743) & (5,122,432,913) & & & & \\ \hline 3 & FCFF(3) & 2025 & 0.9% & (5,538,708,318) & (4,991,659,670) & & & & \\ \hline 4 & FCFF(4) & 2026 & 0.4% & (5,515,241,639) & (4,801,163,643) & & & & \\ \hline 5 & FCFF(5) & 2027 & 1.7% & (5,419,740,814) & (4,557,282,730) & & & & \\ \hline 6 & FCFF(6) & 2028 & 3.0% & (5,255,009,143) & (4,268,216,316) & & & & \\ \hline 7 & FCFF(7) & 2029 & 4.3% & (5,026,554,446) & (3,943,563,404) & & & & \\ \hline 8 & FCFF(8) & 2030 & 5.7% & (4,742,289,466) & (3,593,784,135) & & & & \\ \hline 9 & FCFF(9) & 2031 & 7.0% & (4,412,076,257) & (3,229,627,457) & & & & \\ \hline 10 & FCFF(10) & 2032 & 9.6 & (3,989,445,671) & (2,820,768,627) & & 2.6% & \multicolumn{2}{|c|}{ Growth CAGR } \\ \hline 10 & TV(10) & & & (27,523,688,765) & (19,460,838,462) & & & & \\ \hline \multicolumn{5}{|c|}{ Enterprise Value } & \multirow{2}{*}{\begin{tabular}{r} (67,169,413,095) \\ (44,872,000,000) \end{tabular}} & & & & \\ \hline \multicolumn{4}{|c|}{ Less: Finance lease liabilities (fair value) } & & & WACCDebt & & & \\ \hline \multicolumn{4}{|c|}{ Intrinsic value of common stock } & & (112,041,413,095) & & & & \\ \hline & \multicolumn{3}{|c|}{ Shares Outstanding (Morningstar) } & & 639,000,000 & \multicolumn{2}{|l|}{ WACC, Shares } & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{5}{|c|}{ Intrinsic value of Facebook Inc.'s common stock (per share) } & \multicolumn{3}{|c|}{$175.34 Intrinsic Value } & & \\ \hline \multicolumn{5}{|c|}{ Current share price } & $40.47 & \multicolumn{2}{|c|}{7 WACC, Stock Price } & & \\ \hline & & & & & & & & & \\ \hline & & & & & & 7 & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular} our SAR Stock Jke Energy :8.68 vigus Close en 'reasury If Futures-ic Class Exercise: Use this full calculator for simulation 5 (4 points) Your SAR Stock \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} Your SAR Stock \\ Free cash flow to the firm (FCFF) forecast \end{tabular}}} & & \multicolumn{5}{|c|}{ Model values the stock at P(0) - Today's value } \\ \hline & & & & & \multicolumn{5}{|c|}{ Change FCFF(0) to calculate P(1) - One year from today } \\ \hline & & & & & (FCFF(O) (1+g) & & & & \\ \hline \multicolumn{10}{|c|}{ USS in millions, except per share data } \\ \hline Year & \multicolumn{2}{|l|}{ Value } & Growth & FCFF (t) or TV(t) & Present value at & WACC & 3.53% & & \\ \hline 0 & FCFF(0) & 2022 & \multirow[b]{2}{*}{3.5%} & (5,190,720,000) & (5,190,720,000) & & & & \\ \hline 1 & FCFF(1) & 2023 & & (5,372,395,200) & (5,189,355,739) & & & & \\ \hline 2 & FCFF(2) & 2024 & 2.2% & (5,490,163,743) & (5,122,432,913) & & & & \\ \hline 3 & FCFF(3) & 2025 & 0.9% & (5,538,708,318) & (4,991,659,670) & & & & \\ \hline 4 & FCFF(4) & 2026 & 0.4% & (5,515,241,639) & (4,801,163,643) & & & & \\ \hline 5 & FCFF(5) & 2027 & 1.7% & (5,419,740,814) & (4,557,282,730) & & & & \\ \hline 6 & FCFF(6) & 2028 & 3.0% & (5,255,009,143) & (4,268,216,316) & & & & \\ \hline 7 & FCFF(7) & 2029 & 4.3% & (5,026,554,446) & (3,943,563,404) & & & & \\ \hline 8 & FCFF(8) & 2030 & 5.7% & (4,742,289,466) & (3,593,784,135) & & & & \\ \hline 9 & FCFF(9) & 2031 & 7.0% & (4,412,076,257) & (3,229,627,457) & & & & \\ \hline 10 & FCFF(10) & 2032 & 9.6 & (3,989,445,671) & (2,820,768,627) & & 2.6% & \multicolumn{2}{|c|}{ Growth CAGR } \\ \hline 10 & TV(10) & & & (27,523,688,765) & (19,460,838,462) & & & & \\ \hline \multicolumn{5}{|c|}{ Enterprise Value } & \multirow{2}{*}{\begin{tabular}{r} (67,169,413,095) \\ (44,872,000,000) \end{tabular}} & & & & \\ \hline \multicolumn{4}{|c|}{ Less: Finance lease liabilities (fair value) } & & & WACCDebt & & & \\ \hline \multicolumn{4}{|c|}{ Intrinsic value of common stock } & & (112,041,413,095) & & & & \\ \hline & \multicolumn{3}{|c|}{ Shares Outstanding (Morningstar) } & & 639,000,000 & \multicolumn{2}{|l|}{ WACC, Shares } & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{5}{|c|}{ Intrinsic value of Facebook Inc.'s common stock (per share) } & \multicolumn{3}{|c|}{$175.34 Intrinsic Value } & & \\ \hline \multicolumn{5}{|c|}{ Current share price } & $40.47 & \multicolumn{2}{|c|}{7 WACC, Stock Price } & & \\ \hline & & & & & & & & & \\ \hline & & & & & & 7 & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular} our SAR Stock Jke Energy :8.68 vigus Close en 'reasury If Futures-ic Class Exercise: Use this full calculator for simulation 5 (4 points)

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

Students also viewed these Finance questions