Write a Financial Statement analysis including a write up with Intro, Profitability, margin analysis, asset turnover, short term liquidity, long term solvency, market ratios, conclusion.
Pro Forma Balance Sheet 12 months 12 months 12 months Sep-30- Sep-30- Sep-30 Sep-30-2017 2018E 2019E 2020E USD USD USD USD Restated Oct-03-2015 USD Sep-27-2014 USD Oct-01-2016 USD 1 Tyson Foods, Inc. (NYSE:TSN) >Balance Sheet 3 Balance Sheet (as stated) ( Balance Sheet as of: : 4 Sep-28-2013 5 Currency USD 6 in milions of the reported currency, except per share items. 7 ASSETS 8 Cash And Equivalents 1,145 9 Short Term Investments 1 10 Total Cash & ST Investments 1,146 11 12 Accounts Receivable 1,497 13 Total Receivables 1,497 14 15 Inventory 2,817 16 Other Current Assets 144 17 Total Current Assets 5,604 438 1 439 688 2 690 349 4 4 353 318 3 321 1,082 3 1,085 1,160 3 1,164 1,221 4 1,224 1.684 1,684 1,620 1,620 1.542 1,542 1.675 1,675 2.509 2,509 2,691 2,691 2,831 2,831 5,011 3.274 824 6.221 2,878 193 5,381 2.732 261 4.888 3.239 1,023 6,258 4.673 657 8,925 705 5,273 741 10,070 9,570 9,202 (5.149) 4,053 10 381 (5,251) 5,130 10,816 (5,640) 5,176 11.167 (5,997) 5,170 11,942 (6,374) 5,568 16,527 (8,842) 7,685 17,723 (9,482) 8,241 18,648 (9.977) 8,671 214 1,902 135 266 12.177 92 6.706 5.276 531 23.956 93 6,667 5,165 484 22.969 93 6.669 5.084 469 22.373 95 9,324 6,243 578 28.066 211 8,676 5.795 682 31,974 226 9,303 6.214 731 34,286 238 9,789 6,539 769 36,077 19 Gross Property, Plant & Equipment 20 Accumulated Depreciation 21 Net Property, Plant & Equipment 22 23 Long-term Investments 24 Goodwill 25 Other intangibles 26 Other Long-Term Assets 27 Total Assets 28 29 LIABILITIES 30 Accounts Payable 31 Accrued Exp. 32 Short-term Borrowings 33 Curr. Port of LT Debt 34 Other Current Liabilities 85 Total Current Liabilities 36 37 Long-Term Debt 38 Pension & Other Post-Retire. Benefits 39 Def. Tax Liability, Non-Curr 40 Other Non-Current Liabilities 11 Total Liabilities 1,359 419 1,806 675 1,662 670 1.511 775 1,695 819 778 126 609 4,032 2,477 995 886 692 945 5,287 2,656 1,067 950 742 1,014 5,669 2.795 1,123 1,000 781 1,067 5,965 513 719 3,010 843 673 3,797 715 488 3,535 79 397 2,762 1,895 479 560 5,944 7.535 532 2.450 738 15,052 5,975 495 2,449 809 13,283 6.200 359 2.545 883 12.749 9,297 255 2,979 941 17,507 8,560 552 2.994 1,183 18,485 9,180 591 3,210 1,269 19,800 9,659 622 3,378 1,335 20,834 Ho 13,263 12,749 17,507 18,465 19,800 20,834 42 4,307 6.813 (1,351) (90) 9,691 43 4,355 8,349 (3 093) (45) 9.608 45 4,378 9,776 (3,674) 16 10.541 66 5.781 10,670 (2.911) (130) 13,475 71 6,200 11,442 (3 122) (140 14,450 74 6.523 12.039 Start pro for (3 285) (147) 15.205 41 Total Liabilities 5,944 15,052 42 43 Common Stock 39 42 44 Additional Paid In Capital 2,292 4,257 45 Retained Earnings 4.999 5,748 46 Treasury Stock (1021) (1,010) 47 Comprehensive Inc. and Other (108) (147) 48 Total Common Equity 6,201 8.890 49 50 Minority interest 32 14 51 52 Total Equity 6,233 8,904 53 54 Total Liabilities And Equity 12.177 23.956 55 56 57 Balance Sheet (Common Sized, i.e., each account is expressed as a % of total assets for that year) 15 16 1a 33 6 30 9,706 9.624 10.559 13,509 14,486 15.242 22.969 22.373 28.066 31,974 34,286 36,077 relained e Average Average across Sep-30-2017 5 years USD % Restated Oct-03-2015 USD Sep-28-2013 USD 1 Sep-27-2014 USD Oct-01-2016 USD 9.40% 0.01% 9.418 1.83%, 0.00% 1.83% 3.00% 0.01% 3.00% 1.56% 0.02% 1.58% 1.13%. 0.01% 1.14% 3.38% Average 0.01% % of total 3.39% assets 801088 7.85% five 7.85% years 12.29' 12.29% 7.03% 7.03% 7.05% % 7.05% 6.89% 6.89% 5.97% 5.97% Balance Sheet as of: 58 59 Currency 60 in Millions of the reported currency. exceot per share items 61 ASSETS 62 Cash And Equivalenta 63 Short Term Investments 64 Total Cash & ST Investments 65 66 Accounts Receivable 67 Total Recelvables 68 69 Inventory 70 Other Current Assets 71 Total Current Assets 72 73 Gross Property, Plant & Equipment 74 Accumulated Depreciation 75 Net Property, Plant & Equipment 76 77 Long-term Investmente 78 Goodwill 79 Other Intangibles 80 Other Long-Term Assels 81 Total Assets 82 23.13% 1.18% 46.02% 13.67% 3.44% 25.97% 12.53% 0.84% 23.43% 12.21% % 1. 1796 % 21.85% 11.54% 3.64% 22.30% 14.62% 2.05% 27.91% % 75.57% -42.28% 33.29% 43.33% -21.92% % 21.41% 47.09% -24.55% 22.53% 49.91% -26.80% 23.11% 42.55% -22.71% 19.84% 51.69% % -27.65% 24.04% 1.76% 15.62% 1.13% 2.18% 100.00% 0.38%. 27.99% 22.02% 2.22% 100.00% 0.40% 29.03% 22.50% 2.11% 100.00% 0.42% 29.81% 22.72% 2. 10% 100.00% 0.34%. 33.22% 22.24% 2.06% 100.00% 0.66% 27.13% 18.12% 2.13% 100.00% 7.24% 2.92% 6.75% 3.46% 6.05% 2.92% 2.77% 0.46% % 2.17% 14.37% 0.35% 1.77% 12.35% 7.75% 3.11% 2.77% 2.16% 2.96% 16.53% 3.11% 2.12% 15.39% 26.01% 2.16% 10.66% 3.52% 57.74% 27.71% % 1.60% 11.38% 3.95% 56.98% 33.13% 0.92% 10.61% 3.35% 62.38% 26.77% 1.72% 9.36% 3.70% 57.75% 0.18% 18.75% 29.66% -6.01% -0.39% 42.19% 0.19% 19.47% 37.31% -13.82% -0 20% 42.94% 0.16% 15.60% 34.83% -13.09% 0.06% 37.56% 0.21% 18.08% 33.37% -9.11% -0.41% 42.15% 0.07% 0.07% 0.06% 0.10%. 83 LIABILITIES 84 Accounts Payable 11.16% 7.54% 85 Accrued Exp 3.44% 2.82% 86 Short-term Borrowings 87 Curr. Part of LT Debt 4.21% 2.68% 88 Other Current Liabilities 5.90% 2.81% 89 Total Current Liabilities 24.72% 15.85% 90 91 Long-Term Debt 15.56% 31.45% 92 Pension & Other Post-Retire. Benefits 2.22% 93 Det. Tax Liability, Non-Curr, 3.93% 10.23% 94 Other Non-Current Liabilities 4.60% 3.08% 95 Total Liabilities 48.81% 62.83% 96 97 Common Stock 0.32% 0.18% 98 Additional Paid in Capital 18.82% 17.77% 99 Retained Earnings 41.05% 23.99% 100 Treasury Stock -9.38% -4.22% 101 Comprehensive Inc. and Other -0.89% -0.61% 102 Total Common Equity 50.92% 37.11% 103 104 Minority Interest 0.26% 0.06% 105 106 Total Equity 51.19% 37.17% 107 108 Total Liabilities And Equity 100.00% 100.00% 109 110 111 Balance Sheet (Indexed, i.e., each account value expressed as a % of its base (FY 2013) year) Balance Sheet as of: 112 Sep-28-2013 Sep-27-2014 113 Currency USD USD 114 in Millions of the reported currency, except per share items. 115 ASSETS 116 Cash And Equivalents 100.00% 38.25% 117 Short Term Investments 100.00% 100.00% 118 Total Cash & ST Investments 100.00% 38.31% 119 120 Accounts Receivable 100.00% 112.49% 121 Total Receivables 100.00% 112.49% 122 123 Inventory 100.00% 116.22% 124 Other Current Assets 100.00% 572.22% 125 Total Current Assets 100.00% 111.01% 42.26% 43.02% 37.62% 42.25% 100.00% 100.00% 100.00% 100.00% Restated Oct-03-2015 USD Oct-01-2016 USD Sep-30-2017 USD 60.09% 200.00% 60.21% 30.48% 400.00% 30.80% 27.77% 300.00% 28.01% 108.22% 108.22% 103.01% 103.01% 111.89% 111.89% 102.17% 134.03% 96.02% % 96.99% 181.25% 87.22% 114.98% 710.42% 111.67% 100.00% 111.01% 96.02% 87.22% 111.67% 100.00% 100.00% 100.00% 112.81% 101.98% 126.57% 117.54% 109.54% 127.71% 121.35% 116.47% 127.56% 129.78% 123.79% 137.38% 100.00% 100.00% 100.00% 100.00% 100.00% 42.99% 352.58% 3823.19% 199.62% 196.73% 43.46% 350.53% 3744.93% 181.95% 188.63% 43.46% 350.63% 3684.06% 176.32% 183.73% 44.39% 490.22% 4523.91% 217.29% 230.48% 100.00% 100.00% 132.89% 161.10% 122.30% 159.90% 111.18% 184.96% 124 94% 195.47% 100.00% 100.00% 100.00% 125.34% 93.60% 126.15% 139.38% 67.87% 117.44% 15.40% 55.22% 91.76% 24.95% 84.70% 133.95% 125 Total Current Assets 126 127 Gross Property, Plant & Equipment 128 Accumulated Depreciation 129 Net Property, Plant & Equipment 130 131 Long-term Investments 132 Goodwill 133 Other Intangibles 134 Other Long-Term Assets 135 Total Assets 136 137 LIABILITIES 138 Accounts Payable 139 Accrued Exp. 140 Short-term Borrowings 141 Curr. Port of LT Debt 142 Other Current Liabilities 143 Total Current Llabilities 144 145 Long-Term Debt 146 Pension & Other Post-Retire. Benefits 147 Def. Tax Liability, Non-Curr. 148 Other Non-Current Liabilities 149 Total Llabilities 150 151 Common Stock 152 Additional Paid In Capital 153 Retained Earnings 154 Treasury Stock 155 Comprehensive Inc. and Other 156 Total Common Equity 157 158 Minority interest 159 160 Total Equity 161 162 Total Llabilities And Equity 163 164 165 166 100.00% 397.63% 315.30% 327.18% 490.61% 100.00% 100.00% 100.00% 511.48% 131.79% 253.23% 511.27% 144.46% 223.13% 531.32% 157.68% 214.49% 621.92% 168.04% 294.53% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 107.69% 185.73% 114.98% 98.92% 136.11% 143.36% 107,69% 187.91% 136.29% 135.26% 83.33% 156.28% 110.26% 190.01% 166.99% 302.94% 41.67% 154.94% 115.38% 191.01% 195.56% 359.84% -14.81% 169.99% 100.00% 43.75% 46 88% 50.00% 56.25% 100.00% 142.85% 155.72% 154.40% 169.40% 100.00% 196.73% 188.63% 183.73% 230.48% Pro Forma Balance Sheet 12 months 12 months 12 months Sep-30- Sep-30- Sep-30 Sep-30-2017 2018E 2019E 2020E USD USD USD USD Restated Oct-03-2015 USD Sep-27-2014 USD Oct-01-2016 USD 1 Tyson Foods, Inc. (NYSE:TSN) >Balance Sheet 3 Balance Sheet (as stated) ( Balance Sheet as of: : 4 Sep-28-2013 5 Currency USD 6 in milions of the reported currency, except per share items. 7 ASSETS 8 Cash And Equivalents 1,145 9 Short Term Investments 1 10 Total Cash & ST Investments 1,146 11 12 Accounts Receivable 1,497 13 Total Receivables 1,497 14 15 Inventory 2,817 16 Other Current Assets 144 17 Total Current Assets 5,604 438 1 439 688 2 690 349 4 4 353 318 3 321 1,082 3 1,085 1,160 3 1,164 1,221 4 1,224 1.684 1,684 1,620 1,620 1.542 1,542 1.675 1,675 2.509 2,509 2,691 2,691 2,831 2,831 5,011 3.274 824 6.221 2,878 193 5,381 2.732 261 4.888 3.239 1,023 6,258 4.673 657 8,925 705 5,273 741 10,070 9,570 9,202 (5.149) 4,053 10 381 (5,251) 5,130 10,816 (5,640) 5,176 11.167 (5,997) 5,170 11,942 (6,374) 5,568 16,527 (8,842) 7,685 17,723 (9,482) 8,241 18,648 (9.977) 8,671 214 1,902 135 266 12.177 92 6.706 5.276 531 23.956 93 6,667 5,165 484 22.969 93 6.669 5.084 469 22.373 95 9,324 6,243 578 28.066 211 8,676 5.795 682 31,974 226 9,303 6.214 731 34,286 238 9,789 6,539 769 36,077 19 Gross Property, Plant & Equipment 20 Accumulated Depreciation 21 Net Property, Plant & Equipment 22 23 Long-term Investments 24 Goodwill 25 Other intangibles 26 Other Long-Term Assets 27 Total Assets 28 29 LIABILITIES 30 Accounts Payable 31 Accrued Exp. 32 Short-term Borrowings 33 Curr. Port of LT Debt 34 Other Current Liabilities 85 Total Current Liabilities 36 37 Long-Term Debt 38 Pension & Other Post-Retire. Benefits 39 Def. Tax Liability, Non-Curr 40 Other Non-Current Liabilities 11 Total Liabilities 1,359 419 1,806 675 1,662 670 1.511 775 1,695 819 778 126 609 4,032 2,477 995 886 692 945 5,287 2,656 1,067 950 742 1,014 5,669 2.795 1,123 1,000 781 1,067 5,965 513 719 3,010 843 673 3,797 715 488 3,535 79 397 2,762 1,895 479 560 5,944 7.535 532 2.450 738 15,052 5,975 495 2,449 809 13,283 6.200 359 2.545 883 12.749 9,297 255 2,979 941 17,507 8,560 552 2.994 1,183 18,485 9,180 591 3,210 1,269 19,800 9,659 622 3,378 1,335 20,834 Ho 13,263 12,749 17,507 18,465 19,800 20,834 42 4,307 6.813 (1,351) (90) 9,691 43 4,355 8,349 (3 093) (45) 9.608 45 4,378 9,776 (3,674) 16 10.541 66 5.781 10,670 (2.911) (130) 13,475 71 6,200 11,442 (3 122) (140 14,450 74 6.523 12.039 Start pro for (3 285) (147) 15.205 41 Total Liabilities 5,944 15,052 42 43 Common Stock 39 42 44 Additional Paid In Capital 2,292 4,257 45 Retained Earnings 4.999 5,748 46 Treasury Stock (1021) (1,010) 47 Comprehensive Inc. and Other (108) (147) 48 Total Common Equity 6,201 8.890 49 50 Minority interest 32 14 51 52 Total Equity 6,233 8,904 53 54 Total Liabilities And Equity 12.177 23.956 55 56 57 Balance Sheet (Common Sized, i.e., each account is expressed as a % of total assets for that year) 15 16 1a 33 6 30 9,706 9.624 10.559 13,509 14,486 15.242 22.969 22.373 28.066 31,974 34,286 36,077 relained e Average Average across Sep-30-2017 5 years USD % Restated Oct-03-2015 USD Sep-28-2013 USD 1 Sep-27-2014 USD Oct-01-2016 USD 9.40% 0.01% 9.418 1.83%, 0.00% 1.83% 3.00% 0.01% 3.00% 1.56% 0.02% 1.58% 1.13%. 0.01% 1.14% 3.38% Average 0.01% % of total 3.39% assets 801088 7.85% five 7.85% years 12.29' 12.29% 7.03% 7.03% 7.05% % 7.05% 6.89% 6.89% 5.97% 5.97% Balance Sheet as of: 58 59 Currency 60 in Millions of the reported currency. exceot per share items 61 ASSETS 62 Cash And Equivalenta 63 Short Term Investments 64 Total Cash & ST Investments 65 66 Accounts Receivable 67 Total Recelvables 68 69 Inventory 70 Other Current Assets 71 Total Current Assets 72 73 Gross Property, Plant & Equipment 74 Accumulated Depreciation 75 Net Property, Plant & Equipment 76 77 Long-term Investmente 78 Goodwill 79 Other Intangibles 80 Other Long-Term Assels 81 Total Assets 82 23.13% 1.18% 46.02% 13.67% 3.44% 25.97% 12.53% 0.84% 23.43% 12.21% % 1. 1796 % 21.85% 11.54% 3.64% 22.30% 14.62% 2.05% 27.91% % 75.57% -42.28% 33.29% 43.33% -21.92% % 21.41% 47.09% -24.55% 22.53% 49.91% -26.80% 23.11% 42.55% -22.71% 19.84% 51.69% % -27.65% 24.04% 1.76% 15.62% 1.13% 2.18% 100.00% 0.38%. 27.99% 22.02% 2.22% 100.00% 0.40% 29.03% 22.50% 2.11% 100.00% 0.42% 29.81% 22.72% 2. 10% 100.00% 0.34%. 33.22% 22.24% 2.06% 100.00% 0.66% 27.13% 18.12% 2.13% 100.00% 7.24% 2.92% 6.75% 3.46% 6.05% 2.92% 2.77% 0.46% % 2.17% 14.37% 0.35% 1.77% 12.35% 7.75% 3.11% 2.77% 2.16% 2.96% 16.53% 3.11% 2.12% 15.39% 26.01% 2.16% 10.66% 3.52% 57.74% 27.71% % 1.60% 11.38% 3.95% 56.98% 33.13% 0.92% 10.61% 3.35% 62.38% 26.77% 1.72% 9.36% 3.70% 57.75% 0.18% 18.75% 29.66% -6.01% -0.39% 42.19% 0.19% 19.47% 37.31% -13.82% -0 20% 42.94% 0.16% 15.60% 34.83% -13.09% 0.06% 37.56% 0.21% 18.08% 33.37% -9.11% -0.41% 42.15% 0.07% 0.07% 0.06% 0.10%. 83 LIABILITIES 84 Accounts Payable 11.16% 7.54% 85 Accrued Exp 3.44% 2.82% 86 Short-term Borrowings 87 Curr. Part of LT Debt 4.21% 2.68% 88 Other Current Liabilities 5.90% 2.81% 89 Total Current Liabilities 24.72% 15.85% 90 91 Long-Term Debt 15.56% 31.45% 92 Pension & Other Post-Retire. Benefits 2.22% 93 Det. Tax Liability, Non-Curr, 3.93% 10.23% 94 Other Non-Current Liabilities 4.60% 3.08% 95 Total Liabilities 48.81% 62.83% 96 97 Common Stock 0.32% 0.18% 98 Additional Paid in Capital 18.82% 17.77% 99 Retained Earnings 41.05% 23.99% 100 Treasury Stock -9.38% -4.22% 101 Comprehensive Inc. and Other -0.89% -0.61% 102 Total Common Equity 50.92% 37.11% 103 104 Minority Interest 0.26% 0.06% 105 106 Total Equity 51.19% 37.17% 107 108 Total Liabilities And Equity 100.00% 100.00% 109 110 111 Balance Sheet (Indexed, i.e., each account value expressed as a % of its base (FY 2013) year) Balance Sheet as of: 112 Sep-28-2013 Sep-27-2014 113 Currency USD USD 114 in Millions of the reported currency, except per share items. 115 ASSETS 116 Cash And Equivalents 100.00% 38.25% 117 Short Term Investments 100.00% 100.00% 118 Total Cash & ST Investments 100.00% 38.31% 119 120 Accounts Receivable 100.00% 112.49% 121 Total Receivables 100.00% 112.49% 122 123 Inventory 100.00% 116.22% 124 Other Current Assets 100.00% 572.22% 125 Total Current Assets 100.00% 111.01% 42.26% 43.02% 37.62% 42.25% 100.00% 100.00% 100.00% 100.00% Restated Oct-03-2015 USD Oct-01-2016 USD Sep-30-2017 USD 60.09% 200.00% 60.21% 30.48% 400.00% 30.80% 27.77% 300.00% 28.01% 108.22% 108.22% 103.01% 103.01% 111.89% 111.89% 102.17% 134.03% 96.02% % 96.99% 181.25% 87.22% 114.98% 710.42% 111.67% 100.00% 111.01% 96.02% 87.22% 111.67% 100.00% 100.00% 100.00% 112.81% 101.98% 126.57% 117.54% 109.54% 127.71% 121.35% 116.47% 127.56% 129.78% 123.79% 137.38% 100.00% 100.00% 100.00% 100.00% 100.00% 42.99% 352.58% 3823.19% 199.62% 196.73% 43.46% 350.53% 3744.93% 181.95% 188.63% 43.46% 350.63% 3684.06% 176.32% 183.73% 44.39% 490.22% 4523.91% 217.29% 230.48% 100.00% 100.00% 132.89% 161.10% 122.30% 159.90% 111.18% 184.96% 124 94% 195.47% 100.00% 100.00% 100.00% 125.34% 93.60% 126.15% 139.38% 67.87% 117.44% 15.40% 55.22% 91.76% 24.95% 84.70% 133.95% 125 Total Current Assets 126 127 Gross Property, Plant & Equipment 128 Accumulated Depreciation 129 Net Property, Plant & Equipment 130 131 Long-term Investments 132 Goodwill 133 Other Intangibles 134 Other Long-Term Assets 135 Total Assets 136 137 LIABILITIES 138 Accounts Payable 139 Accrued Exp. 140 Short-term Borrowings 141 Curr. Port of LT Debt 142 Other Current Liabilities 143 Total Current Llabilities 144 145 Long-Term Debt 146 Pension & Other Post-Retire. Benefits 147 Def. Tax Liability, Non-Curr. 148 Other Non-Current Liabilities 149 Total Llabilities 150 151 Common Stock 152 Additional Paid In Capital 153 Retained Earnings 154 Treasury Stock 155 Comprehensive Inc. and Other 156 Total Common Equity 157 158 Minority interest 159 160 Total Equity 161 162 Total Llabilities And Equity 163 164 165 166 100.00% 397.63% 315.30% 327.18% 490.61% 100.00% 100.00% 100.00% 511.48% 131.79% 253.23% 511.27% 144.46% 223.13% 531.32% 157.68% 214.49% 621.92% 168.04% 294.53% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 107.69% 185.73% 114.98% 98.92% 136.11% 143.36% 107,69% 187.91% 136.29% 135.26% 83.33% 156.28% 110.26% 190.01% 166.99% 302.94% 41.67% 154.94% 115.38% 191.01% 195.56% 359.84% -14.81% 169.99% 100.00% 43.75% 46 88% 50.00% 56.25% 100.00% 142.85% 155.72% 154.40% 169.40% 100.00% 196.73% 188.63% 183.73% 230.48%
