Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the Delta Financial Analysis (FY 2013 FY 2010) and Key Ratio Comparison, calculate the missing values. (Enter your answers in thousands of dollars. Round

Using the Delta Financial Analysis (FY 2013 FY 2010) and Key Ratio Comparison, calculate the missing values. (Enter your answers in thousands of dollars. Round your answers to 2 decimal place. Omit the "$" & "%" signs in your response.)

Delta Strategic Financial Analysis
(data in thousands [000s], excluding per share data and financial ratios)
FY end date 31-Jan
FY 2014
Revenue $ 40,362,000
Cost of Revenue 32,172,000
Gross Profit ?
Gross Profit Margin ?
EBIT 2,922,000
Income Tax 413,000
NOPAT (Net Operating Profit After Taxes) 2,509,000
Net Income (includes discontinued operations) $ (659,000)
Diluted Weighted Average Shares 845,000
Dividends per Share ?
Diluted Normalized EPS (includes discontinued operations) (0.78)
Cash Cycle FY 2014
Revenue per day ?
Accounts Receivable 3,222,000
Receivable Days ?
Inventory 852,000
Inventory Days ?
Accounts Payable 2,622,000
Payable Days ?
Cash Cycle (days) ?
Key Ratios FY 2014
Market Value of Book Equity ?
Price per share* 48.72
Earnings per share (includes discontinued operations) ?
P/E Ratio ?
Return on Invested Capital 0.05
Return on Assets ?
Return on Equity ?
Return on Revenue ?
Total Assets 54,121,000
Current Assets 12,465,000
Current Liabilities 16,879,000
Current Ratio ?
Total Liabilities ?
Liabilities/Equity Ratio ?
Total Equity (book value) 8,813,000
Shareholders' Equity (minority interests) -
Market to Book Value ?
Per Employee FY 2014
Number of Employees (continuing operations) 79.7
Revenue ?
Net Income ?
Market Value ?

image text in transcribed

image text in transcribed

Delta Strategic Financial Analysis (data in thousands [000s, excluding per share data and financial ratios) FY end date 31-Dec 31-Dec 31-Dec 31-Dec FY 2013 FY 2012 FY 2011 FY 2010 37,773,000 $ 36,670,000 $ Revenue 35,115,000 31,755,000 Cost of Revenue 29,190,000 29,296,000 28,065,000 24,422,000 Gross Profit 7,374,000 7,050,000 7,333,000 8,583,000 Gross Profit Margin 0.23 0.20 0.20 0.23 2,627,000 EBIT 3,802,000 2,217,000 2,677,000 Income Tax (8,013,000) 16,000 (85,000) 15,000 NOPAT (Net Operating Profit After Taxes) Net Income (includes discontinued operations) 2,662,000 11,815,000 2,611,000 2,302,000 10.540.000 $ 854,000 $ 593,000 1,009,000 Diluted Weighted Average Shares 858.000 850,000 844,000 843,000 Dividends per Share Diluted Normalized EPS (includes discontinued operations) 0.12 12.29 1.19 1.01 0.70 Cash Cycle Revenue per day Y 2013 FY 2012 FY 2011 FY 2010 87,000 103.488 100,466 96,205 Accounts Receivable 1,609,000 1,693,000 1,563,000 1,456,000 Receivable Days 16 17 16 17 318.000 Inventory Inventory Days 1,063,000 1,023,000 367,000 10 10 4 Accounts Payable Payable Days Cash Cycle (days) 2,300,000 2,293,000 1,600,000 1,713,000 22 23 17 20 4 4 Key Ratios Market Value of Book Equity Price per share FY 2013 FY 2012 FY 2011 FY 2010 6,676,040 23.157.420 9,860,000 10,377,330 26.99 11.60 7.91 12.31 Earnings per share (includes discontinued operations) P/E Ratio 1.19 1.01 0.70 12.29 2.20 9.75 7.83 17.59 Return on Invested Capital 0.23 0.06 0.05 0.06 Return on Assets 0.20 0.02 0.02 0.01 Return on Equity 0.91 (0.47) (0.61) 0.66 Return on Revenue 0.28 0.03 0.02 0.02 Total Assets 52,252.000 44,550,000 43,499,000 43,188,000 9,651,000 14,152,000 7,729,000 7,307,000 Current Assets 8,272,000 Current Liabilities 13,270,000 12,701,000 11,385,000 Current Ratio 0.68 0.62. 0.61 0.64 Total Liabilities 42,291.000 40,609,000 46,681,000 44,895,000 Liabilities/Equity Ratio 3,49 (21.91) (32.16) 47.15 Total Equity (book value) Shareholders' Equity (minority interests) 11,643,000 (2,131,000) (1,396,000) 897,000 Market to Book Value (4.63) (4.78) 11.57 1.99 Per Employee Number of Employees (continuing operations) FY 2013 FY 2012 FY 2011 FY 2010 77.8 73.6 78.4 79.7 Revenue 485.8 498.5 447.9 398.5 Net Income 135.6 13.7 10.9 7,4 Market Value 297.8 134.0 85.2 130.2 Stock Price obtained from Yahoo Finance at close of final day of FY Source: 5&P Capital IQ Compustat 8 Competitor Strategic Financial Analysis (data in thousands [000], excluding per share data and financial ratios) 31-Dec FY end date 31-Dec 31-Dec 31-Dec Delta American Southwest United FY 2014 Revenue 40,362,000 $ 42,650,000 $ 18,605,000 $ 38,901,000 Cost of Revenue 29,511,000 29,263,000 32,172,000 13,111,000 Gross Profit 13,139,000 9,638,000 5,494,000 Gross Profit Margin 0.31 0.30 0.25 2,816,000 EBIT 2,922,000 5,073,000 2,351,000 (4,000) Income Tax 413,000 330,000 680,000 NOPAT (Net Operating Profit After Taxes) 2,509,000 4,743,000 1,671,000 2,820,000 Net Income (includes discontinued operations) 659.000 $ 2.882.000 $ 1.136.000 S 1.132.000 Diluted Weighted Average Shares 845,000 734,016 696,000 390,000 Dividends per Share Diluted Normalized EPS (includes discontinued operati 0.20 0.20 0.78 3.93 1.64 2.93 Cash Cycle Delta American Southwest United Revenue per day 116.849 50,973 106,578 Accounts Receivable 3,222.000 1,771,000 365,000 1,146,000 Receivable Days 15 7 11 Inventory Inventory Days 852,000 1,004,000 342,000 666,000 6 9 7 Accounts Payable 2,622,000 1,377,000 522,000 1,882,000 Payable Days 10 12 18 Cash Cycle (days) (1) 12 4 Key Ratios Market Value of Equity American Delta Southwest United 39,027,631 29,259,840 26,087,100 Price per share 48.72 53.17 42.04 66.89 Earnings per share (includes discontinued operations) 3.93 1.64 2.93 P/E Ratio 13.53 25.63 22.83 Return on Invested Capital 0.05 0.11 0.08 0.08 Return on Assets 0.07 0.06 0.03 Return on Equity 143 0.17 0.47 Return on Revenue 0.07 0.06 0.03 Total Assets 54,121,000 43,771,000 20,200,000 37,353,000 Current Assets 12.465,000 12,112.000 4,404,000 8,138,000 Current Liabilities 16,879,000 13,435,000 5,923,000 12,508,000 Current Ratio 0.90 0.74 0.65 13.425,000 Total Liabilities 41,750,000 34,957,000 Liabilities/Equity Ratio 1.98 14.59 20.66 Total Equity (book value) 8,813,000 2,021,000 6,775,000 2,396,000 Shareholders' Equity (minority interests) Market to Book Value 19.31 4.32 10.89 Per Employee Number of Employees (continuing operations) Delta American Southwest United 79.7 113.3 46.3 84.0 Revenue 376.4 402.0 463.1 Net Income 25.4 24.5 13.5 Market Value 344.5 632.3 310.6 *Stock Price obtained from Yahoo Finance at close of final day of FY Source: S&P Capital IQ Compustat Delta Strategic Financial Analysis (data in thousands [000s, excluding per share data and financial ratios) FY end date 31-Dec 31-Dec 31-Dec 31-Dec FY 2013 FY 2012 FY 2011 FY 2010 37,773,000 $ 36,670,000 $ Revenue 35,115,000 31,755,000 Cost of Revenue 29,190,000 29,296,000 28,065,000 24,422,000 Gross Profit 7,374,000 7,050,000 7,333,000 8,583,000 Gross Profit Margin 0.23 0.20 0.20 0.23 2,627,000 EBIT 3,802,000 2,217,000 2,677,000 Income Tax (8,013,000) 16,000 (85,000) 15,000 NOPAT (Net Operating Profit After Taxes) Net Income (includes discontinued operations) 2,662,000 11,815,000 2,611,000 2,302,000 10.540.000 $ 854,000 $ 593,000 1,009,000 Diluted Weighted Average Shares 858.000 850,000 844,000 843,000 Dividends per Share Diluted Normalized EPS (includes discontinued operations) 0.12 12.29 1.19 1.01 0.70 Cash Cycle Revenue per day Y 2013 FY 2012 FY 2011 FY 2010 87,000 103.488 100,466 96,205 Accounts Receivable 1,609,000 1,693,000 1,563,000 1,456,000 Receivable Days 16 17 16 17 318.000 Inventory Inventory Days 1,063,000 1,023,000 367,000 10 10 4 Accounts Payable Payable Days Cash Cycle (days) 2,300,000 2,293,000 1,600,000 1,713,000 22 23 17 20 4 4 Key Ratios Market Value of Book Equity Price per share FY 2013 FY 2012 FY 2011 FY 2010 6,676,040 23.157.420 9,860,000 10,377,330 26.99 11.60 7.91 12.31 Earnings per share (includes discontinued operations) P/E Ratio 1.19 1.01 0.70 12.29 2.20 9.75 7.83 17.59 Return on Invested Capital 0.23 0.06 0.05 0.06 Return on Assets 0.20 0.02 0.02 0.01 Return on Equity 0.91 (0.47) (0.61) 0.66 Return on Revenue 0.28 0.03 0.02 0.02 Total Assets 52,252.000 44,550,000 43,499,000 43,188,000 9,651,000 14,152,000 7,729,000 7,307,000 Current Assets 8,272,000 Current Liabilities 13,270,000 12,701,000 11,385,000 Current Ratio 0.68 0.62. 0.61 0.64 Total Liabilities 42,291.000 40,609,000 46,681,000 44,895,000 Liabilities/Equity Ratio 3,49 (21.91) (32.16) 47.15 Total Equity (book value) Shareholders' Equity (minority interests) 11,643,000 (2,131,000) (1,396,000) 897,000 Market to Book Value (4.63) (4.78) 11.57 1.99 Per Employee Number of Employees (continuing operations) FY 2013 FY 2012 FY 2011 FY 2010 77.8 73.6 78.4 79.7 Revenue 485.8 498.5 447.9 398.5 Net Income 135.6 13.7 10.9 7,4 Market Value 297.8 134.0 85.2 130.2 Stock Price obtained from Yahoo Finance at close of final day of FY Source: 5&P Capital IQ Compustat 8 Competitor Strategic Financial Analysis (data in thousands [000], excluding per share data and financial ratios) 31-Dec FY end date 31-Dec 31-Dec 31-Dec Delta American Southwest United FY 2014 Revenue 40,362,000 $ 42,650,000 $ 18,605,000 $ 38,901,000 Cost of Revenue 29,511,000 29,263,000 32,172,000 13,111,000 Gross Profit 13,139,000 9,638,000 5,494,000 Gross Profit Margin 0.31 0.30 0.25 2,816,000 EBIT 2,922,000 5,073,000 2,351,000 (4,000) Income Tax 413,000 330,000 680,000 NOPAT (Net Operating Profit After Taxes) 2,509,000 4,743,000 1,671,000 2,820,000 Net Income (includes discontinued operations) 659.000 $ 2.882.000 $ 1.136.000 S 1.132.000 Diluted Weighted Average Shares 845,000 734,016 696,000 390,000 Dividends per Share Diluted Normalized EPS (includes discontinued operati 0.20 0.20 0.78 3.93 1.64 2.93 Cash Cycle Delta American Southwest United Revenue per day 116.849 50,973 106,578 Accounts Receivable 3,222.000 1,771,000 365,000 1,146,000 Receivable Days 15 7 11 Inventory Inventory Days 852,000 1,004,000 342,000 666,000 6 9 7 Accounts Payable 2,622,000 1,377,000 522,000 1,882,000 Payable Days 10 12 18 Cash Cycle (days) (1) 12 4 Key Ratios Market Value of Equity American Delta Southwest United 39,027,631 29,259,840 26,087,100 Price per share 48.72 53.17 42.04 66.89 Earnings per share (includes discontinued operations) 3.93 1.64 2.93 P/E Ratio 13.53 25.63 22.83 Return on Invested Capital 0.05 0.11 0.08 0.08 Return on Assets 0.07 0.06 0.03 Return on Equity 143 0.17 0.47 Return on Revenue 0.07 0.06 0.03 Total Assets 54,121,000 43,771,000 20,200,000 37,353,000 Current Assets 12.465,000 12,112.000 4,404,000 8,138,000 Current Liabilities 16,879,000 13,435,000 5,923,000 12,508,000 Current Ratio 0.90 0.74 0.65 13.425,000 Total Liabilities 41,750,000 34,957,000 Liabilities/Equity Ratio 1.98 14.59 20.66 Total Equity (book value) 8,813,000 2,021,000 6,775,000 2,396,000 Shareholders' Equity (minority interests) Market to Book Value 19.31 4.32 10.89 Per Employee Number of Employees (continuing operations) Delta American Southwest United 79.7 113.3 46.3 84.0 Revenue 376.4 402.0 463.1 Net Income 25.4 24.5 13.5 Market Value 344.5 632.3 310.6 *Stock Price obtained from Yahoo Finance at close of final day of FY Source: S&P Capital IQ Compustat

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Information Systems Control And Audit

Authors: Et Al. Hyo-Jeong Kim, Michael Mannino, Compiled By Koros Press Editorial Board

1st Edition

1781639426, 978-1781639429

More Books

Students also viewed these Accounting questions

Question

What is Working Capital ? Explain its types.

Answered: 1 week ago