70.2K

Verified Solution

Link Copied!

A Ford Company has the following information from its 2018-2015

Required: Analyze and explain each trend analysis ( balance sheet and income statement) give explanation in each data.

In each given horizontal analysis. Find what does the data means and explain it

Ford Company Income Statement Year ended December 31 (In million) 2019 2018 2017 2016 2015 2019 2018 2017 2016 2015 (%) (%) (%) (%) (%) $155,900 $160,338 $156,776 $151,800 $149,558 104.24 107.21 104.83 101.50 100 134,693 136,269 131,321 126,195 124,446 108.23 109.50 105.52 | 101.41 100 21,207 24,069 25,455 25,605 25,112 84.45 95.85 101.37 101.96 100 20,633 20,866 20,574 19,819 10,763 191.70 193.87 191.15 184.14 100 155,326 157,135 151,895 146,014 135,209 114.88 116.22 112.34 107.99 100 574 3,203 4,881 5,786 14,349 4.00 22.32 34.02 40.32 100 (1,214) 1,142 3,278 998 (4,097) 29.63 -27.87 -80.01 -24.36 100 Revenue Cost of Goods Sold Gross profit SG&A Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre-Tax Income Income Taxes Income After Taxes Income from Continuous Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earning Per Share (640) (724) 84 84 4,345 650 3,695 3,695 8,159 402 7,757 7,757 6,784 2,184 4,600 4,600 10,252 2,881 7,371 7,371 -6.24 -25.13 1.14 1.14 42.38 22.56 50.13 50.13 79.58 13.95 105.24 105.24 66.17 75.81 62.41 62.41 100 100 100 100 47 9,064 574 3,972 4,004 0.01 $0.01 3,677 11,616 3,203 3,974 3,998 0.93 $0.92 7,731 13,453 4,881 3,975 3,998 1.94 $1.93 4,589 14,503 5,786 3,973 3,999 1.16 $1.15 7,373 22,315 14,349 3,969 4,002 1.86 $1.84 0.64 49.87 104.86 62.24 100 40.62 52.05 60.29 64.99 100 4.00 22.32 34.02 40.32 100 100.08 100.13 100.15 100.10 100 100.05 99.90 99.90 99.93 100 0.54 50.00 104.30 62.37 100 0.54 50.00 104.89 62.50 100 Ford Company Balance Sheet Year ended December 31 (In million) 2019 2018 2017 2016 2015 2019 2018 2017 2016 2015 (%) (%) (%) (%) (%) Cash on Hand $34,651 $33,951 $38,927 $38,827 $35,176 98.51 96.52 110.66 110.38 100 Receivables 9,237 11,195 10,599 11,102 11,042 83.65 101.39 95.99 100.54 100 Inventory 10,786 11,220 11,176 8,898 8,319 129.66 134.87 134.34 106.96 100 Other Current Assets 5,722 3,930 3,889 3,368 2,913 196.43 134.91 | 133.50 115.62 100 Total Current Assets 114,047 114,649 116,801 108,461 102,587 111.17 111.76 113.86 105.73100 Properly, Plant, And 36,469 36,178 35,327 32,072 30,163 120.91 119.94 117.12 106.33 100 Equipment Long-Term Investment 31,749 31,828 31,320 32,133 30,317 104.72 104.98 103.31 105.99 100 Other Long-Term Assets 10,706 7,929 8,104 5,656 4,795 223.27 165.36 169.01 117.96 100 Total Long-Term Assets 144,490 141,891 141,695 129,490 122,338 118.11 115.98 115.82 105.85 100 Total Assets 258,573 256,540 258,496 237,951 224,925 114.96 114.06 114.93 105.79 100 Total Current Liabilities 98,132 95,569 94,600 90,281 82,336 119.18 | 116.07 114.90 109.65 100 Long Term Debt 101,361 100,720 102,666 93,301 89,879 112.77 112.06 114.23 103.81 100 Other Non-Current 25,324 23,588 24,711 24,395 23,457 107.96 100.56 105.35 104.00 100 Liabilities Total Long-Term Liabilities 127,175 125,005 128,290 118,483 113,932 111.62 109.72 112.60 103.99 100 Total Liabilities 225,307 220,574 222,890 203,764 196,268 114.80 112.38 113.56 103.82 100 Common Stock Net 41 41 41 41 41 100.00 100.00 100.00 100.00 100 Retained Earnings 20,320 22,668 21,906 15,634 14,414 140.97 157.26 151.98 108.46 100 (Accumulated Deficit) Comprehensive Income (7728) (7,366) (6,959) (7,013) (6,257) 123.51 117.72 111.22 112.08 100 Share Holder Equity 33,230 35,966 35,606 29,187 28,657 115.96 125.51 | 124.25 101.85 100 Total Liabilities and Share $258,537 $256,540 $258,496 $237,951 $224,925 114.94 114.06 114.93 105.79 100 Holders Equity

Answer & Explanation Solved by verified expert

See Answer