70.2K

Verified Solution

Link Copied!

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

Required: Analyze and explain each vertical 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, 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 2016 $ 151,800 126,195 25,605 19,819 146,014 5,786 998 6,784 2,184 4,600 4,600 4,589 14,503 5,786 3,973 3,999 1.16 $1.15 2015 $149,558 124,446 25,112 10,763 135,209 14,349 (4,097) 10,252 2,881 7,371 7,371 7,373 22,315 14,349 3,969 4,002 1.86 $1.84 Increase (Decrease) 2016 2015 100.00% 100.00% 83.13% 83.21% 16.87% 16.79% 13.06% 7.20% 96.19% 90.41% 3.81% 9.59% 0.66% (2.74%) 4.47% 6.85% 1.44% 1.93% 3.03% 4.93% 3.03% 4.93% 3.02% 4.93% 9.55% 14.92% 3.81% 9.59% 2.62% 2.65% 2.63% 2.68% 0.00% 0.00% 0.00% 0.00% Ford Company Income statement Year ended December 31, 2018 160338 136269 24069 20866 157135 3203 1142 4345 650 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 2017 156776 131321 25455 20574 151895 4881 3278 8159 402 7757 7757 7731 13453 4881 3975 3998 1.94 1.93 Increase (Decrease) 2018 2017 100.00% 100.00% 84.99% 83.76% 15.01% 16.24% 13.01% 13.12% 98.00% 96.89% 2.00% 3.11% 0.71% 2.09% 2.71% 5.20% 0.41% 0.26% 2.30% 4.95% 2.30% 4.95% 2.29% 4.93% 7.24% 8.58% 2.00% 3.11% 2.48% 2.54% 2.49% 2.55% 0.00% 0.00% 0.00% 0.00% 3695 3695 3677 11616 3203 3974 3998 0.93 0.92 Ford Company Balance Sheet Year ended December 31, Cash on Hand Receivables Inventory Other Current Assets Total Current Assets Properly, Plant, And Equipment Long-Term Investment Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long-Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Share Holder Equity Total Liabilities and Share Holders Equity 2016 $ 38,827 11,102 8,898 3,368 108,461 32,072 32,133 5,656 129,490 237,951 90,281 93,301 24,395 118,483 203,764 41 15,634 (7,013) 29,187 $ 237,951 2015 $35,176 11,042 8,319 2,913 102,587 30,163 30,317 4,795 122,338 224,925 82,336 89,879 23,457 113,932 196,268 41 14,414 (6,257) 28,657 $ 224,925 Increase (Decrease) 2016 2015 100.00% 100.00% 28.59% 31.39% 22.92% 23.65% 8.67% 8.28% 279.34% 291.64% 82.60% 85.75% 82.76% 86.19% 14.57% 13.63% 333.51% 347.79% 612.85% 639.43% 232.52% 234.07% 240.30% 255.51% 62.83% 66.68% 305.16% 323.89% 524.80% 557.96% 0.11% 0.12% 40.27% 40.98% -18.06% -17.79% 75.17% 81.47% 612.85% 639.43% Ford Company Balance Sheet Year ended December 31, Cash on Hand Accounts Receivable Inventory Other Current Assets Total Current Assets Properly, Plant, And Equipment Long-Term Investment Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long-Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Share Holder Equity Total Liabilities and Share Holders Equity 2018 $ 33,951 11,195 11,220 3,930 114,649 36,178 31,828 7,929 141,891 256,540 95,569 100,720 23,588 125,005 220,574 41 22,668 (7,366) 35,966 $ 256,540 2017 $38,927 10,599 11,176 3,889 116,801 35,327 31,320 8,104 141,695 258,496 94,600 102,666 24,711 128,290 222,890 41 21,906 (6,959) 35,606 $ 258,496 Increase (Decrease) 2018 2017 100.00% 100.00% 32.97% 27.23% 33.05% 28.71% 11.58% 9.99% 337.69% 300.05% 106.56% 90.75% 93.75% 80.46% 23.35% 20.82% 417.93% 364.00% 755.62% 664.05% 281.49% 243.02% 296.66% 263.74% 69.48% 63.48% 368.19% 329.57% 649.68% 572.58% 0.12% 0.11% 66.77% 56.27% -21.70% -17.88% 105.94% 91.47% 755.62% 664.05%

Answer & Explanation Solved by verified expert

See Answer