Percentage of Net Sales (will be used only with last year)

Regression Analysis (will be used with last 5 year)

In order to project the forecast, we will calculate geometric average growth rate in Net sales.

how to calculate Percentage of Net Sales only with last year?

and Regression Analysis will be used with last 5 year?

In order to project the forecast, we should calculate geometric average growth rate in Net sales?

468 Income Statement Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SG&A Expense Research & Development Other SG&A SGA Growth EBIT Unusual Expense Non Operating Income/Expense Non-Operating Interest Income Equity in Affiliates (Pretax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Pretax Income Pretax Income Growth Pretax Margin Income Tax Income Tax - Current Domestic Income Tax - Current Foreign Income Tax - Deferred Domestic Consolidated Net Income Net Income Net Income Growth Net Margin Net Income After Extraordinaries Net Income Available to common EPS (Basic) EPS (Basic) Growth Basic Shares Outstanding EPS (Diluted) EPS (Diluted) Growth Diluted Shares Outstanding EBITDA EBITDA Growth EBITDA Margin EBIT 2020 2019 2018 2017 2016 77,867 71,965 70,848 62,761 59,387 8. 20% 1.58% 12.89% 5.68% 34,460 30,025 27,295 23,775 23,425 22,221 19,199 18,210 15,646 15,635 12,239 10,826 9,085 8,129 7,790 10,482 9,204 7,520 6,7526,266 1,757 1,622 1,565 1,377 1,524 14.77% 10.00% 14.81% 1.49% 43,407 41,940 43,553 38,986 35,962 3.50% -3.70% 11.71% 8.41% 55.75% 19,736 19,512 20,356 20,539 21,149 13,556 13,362 13,584 13,080 12,747 6,180 6,150 6,772 7,459 8,402 1.15% -4.15% -0.89% -2.88% 23,671 22,428 23,197 14,813 1,120 -227 158 1,755 1,677 720 1,409 308 3,865 349 272 483 438 441 222 2,164 -38 629 489 646 733 28.63% 4.49% -27.55% -11.87% 291 961 964 959 868 -338 472 496 313 135 25,078 24,058 23,317 20,352 12,936 4.24% 3.18% 14.57% 57.33% 32.21% 4,179 3,010 2,264 10,751 2,620 1,166 1,428 2,775 8,334 1,332 1,244 1,060 1,097 899 756 1,769 522 - 1,608 1,518 532 20,899 21,048 21,053 9,601 10,316 20,899 21,048 21,053 9,601 10,316 -0.71% -0.02%v119.28% -6.93% 26.84% 20,899 21,048 21,053 9,601 10,316 20,899 21,048 21,053 9,601 10,316 4.94 4.71 4.48 1.99 2.12 4.95% 5.04%V125. 13% -6.13% 4,199 4,417 4,611 4,701 4,730 4.94 4.71 4.48 1.99 2.12 4.95%5.07%v125.53% -6.16% 4,232 4,473 4,701 4,835 4,875 35,910 33,254 32,282 26,576 22,603 7.99% 3.01% 21.47% 17.58% 46.12% 23,671 22,428 23, 1971 14,813 384 Balance Sheet Cash & Short Term Investments Cash Only Short-Term Investments Cash & Short Term Investments Growth Cash & ST Investments/Total Assets Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt/Doubtful Accounts Other Receivables Accounts Receivable Growth Accounts Receivable Turnover Inventories Finished Goods Work in Progress Raw Materials Other Current Assets Miscellaneous Current Assets Total Current Assets Net Property, Plant & Equipment Property, Plant & Equipment - Gross Buildings Machinery & Equipment Construction in Progress Accumulated Depreciation Total Investments and Advances LT Investment. Affiliate Companies Other Long-Term Investments Long-Term Note Receivable Intangible Assets Net Goodwill Net Other intangibles Other Assets Tangible Other Assets Total Assets Assets - Total Growth Asset Turnover Return On Average Assets Liabilities & Shareholders' Equity All values USD Millions. ST Debt & Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt Accounts Payable Accounts Payable Growth Income Tax Payable Other Current Liabilities Accrued Payroll Miscellaneous Current Liabilities Total Current Liabilities Current Ratio 2020 2019 2018 2017 2016 23,895 13,123 11,650 14,002 17,099 5,865 4,194 3,019 3,433 5,560 18,030 8.929 8,631 10,569 11,539 82.08% 12.64%N-16.80% 18.11% 15.61% 9.61% 9.10% 11.36% 15.09% 7,352 7,735 6,884 5,678 5,074 6,782 7,659 6,722 5,607 4,690 6,782 7,659 6,755 5,632 4,727 -33 -25 -37 570 76 162 71 -4.95% 12.36%21.24% 11.90% 10.59 9.3 10.29 11.05 11.7 8,427 8,744 7,253 6,983 5,553 1,512 1,679 1,929 2,032 1,668 6,007 6,225 4,511 4,213 3,190 908 840 813 738 695 7,575 1,637 3,000 2,837 7,782 7,575 1,637 3,000 2,837 7,782 47,249 31,239 28,787 29,500 35,508 58,690 57,65550,483 41,823 36,518 136,335V130,976 115,825 101,10990,452 37,536 37,743 30,954 27,391 26,627 79,384 74,901 66,721 57,192 52,608 18,811 17,704 18,150 16,526 11,217 77,645 73,321 65,342 59,286 53,934 8,894 7,243 9,430 12,291 15,322 3,322 3,517 4,602 4,387 4,426 5,572 3,726 4,828 7,904 10,896 157 554 479 860 299 35,997 37,103 36,349 37,134 23,593 26,971 26,276 24,513 24,389 14,099 9,026 10,82 11,836 12,745 9,494 872 1,521 1,313 801 1,180 872 1,521 1,313 801 1,180 (153,091 1136,524 1127,963 123,2491113,327 12.13% 6.69% 3.82% 8.76% 0.54 14.43% 500 2020 2019 2018 2017 2016 2,677 3,868 1,261 1,776 4,634 173 175 37 25 21504 3,693 761 1,739 4,609 5,581 4,128 3,824 2,928 2,475 35.20% 2.95% 30.60% 18.30% 756 575 366 1,400 329 15,740 13,739 11,175 11,317 12,864 6,499 5,953 5,322 5,226 4.965 9,241 7,786 5,853 6,091 7,899 24,754 22,310 16,626 17,421 20,302 1911 1.41 1.73 1.69 1.75 468 Income Statement Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SG&A Expense Research & Development Other SG&A SGA Growth EBIT Unusual Expense Non Operating Income/Expense Non-Operating Interest Income Equity in Affiliates (Pretax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Pretax Income Pretax Income Growth Pretax Margin Income Tax Income Tax - Current Domestic Income Tax - Current Foreign Income Tax - Deferred Domestic Consolidated Net Income Net Income Net Income Growth Net Margin Net Income After Extraordinaries Net Income Available to common EPS (Basic) EPS (Basic) Growth Basic Shares Outstanding EPS (Diluted) EPS (Diluted) Growth Diluted Shares Outstanding EBITDA EBITDA Growth EBITDA Margin EBIT 2020 2019 2018 2017 2016 77,867 71,965 70,848 62,761 59,387 8. 20% 1.58% 12.89% 5.68% 34,460 30,025 27,295 23,775 23,425 22,221 19,199 18,210 15,646 15,635 12,239 10,826 9,085 8,129 7,790 10,482 9,204 7,520 6,7526,266 1,757 1,622 1,565 1,377 1,524 14.77% 10.00% 14.81% 1.49% 43,407 41,940 43,553 38,986 35,962 3.50% -3.70% 11.71% 8.41% 55.75% 19,736 19,512 20,356 20,539 21,149 13,556 13,362 13,584 13,080 12,747 6,180 6,150 6,772 7,459 8,402 1.15% -4.15% -0.89% -2.88% 23,671 22,428 23,197 14,813 1,120 -227 158 1,755 1,677 720 1,409 308 3,865 349 272 483 438 441 222 2,164 -38 629 489 646 733 28.63% 4.49% -27.55% -11.87% 291 961 964 959 868 -338 472 496 313 135 25,078 24,058 23,317 20,352 12,936 4.24% 3.18% 14.57% 57.33% 32.21% 4,179 3,010 2,264 10,751 2,620 1,166 1,428 2,775 8,334 1,332 1,244 1,060 1,097 899 756 1,769 522 - 1,608 1,518 532 20,899 21,048 21,053 9,601 10,316 20,899 21,048 21,053 9,601 10,316 -0.71% -0.02%v119.28% -6.93% 26.84% 20,899 21,048 21,053 9,601 10,316 20,899 21,048 21,053 9,601 10,316 4.94 4.71 4.48 1.99 2.12 4.95% 5.04%V125. 13% -6.13% 4,199 4,417 4,611 4,701 4,730 4.94 4.71 4.48 1.99 2.12 4.95%5.07%v125.53% -6.16% 4,232 4,473 4,701 4,835 4,875 35,910 33,254 32,282 26,576 22,603 7.99% 3.01% 21.47% 17.58% 46.12% 23,671 22,428 23, 1971 14,813 384 Balance Sheet Cash & Short Term Investments Cash Only Short-Term Investments Cash & Short Term Investments Growth Cash & ST Investments/Total Assets Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt/Doubtful Accounts Other Receivables Accounts Receivable Growth Accounts Receivable Turnover Inventories Finished Goods Work in Progress Raw Materials Other Current Assets Miscellaneous Current Assets Total Current Assets Net Property, Plant & Equipment Property, Plant & Equipment - Gross Buildings Machinery & Equipment Construction in Progress Accumulated Depreciation Total Investments and Advances LT Investment. Affiliate Companies Other Long-Term Investments Long-Term Note Receivable Intangible Assets Net Goodwill Net Other intangibles Other Assets Tangible Other Assets Total Assets Assets - Total Growth Asset Turnover Return On Average Assets Liabilities & Shareholders' Equity All values USD Millions. ST Debt & Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt Accounts Payable Accounts Payable Growth Income Tax Payable Other Current Liabilities Accrued Payroll Miscellaneous Current Liabilities Total Current Liabilities Current Ratio 2020 2019 2018 2017 2016 23,895 13,123 11,650 14,002 17,099 5,865 4,194 3,019 3,433 5,560 18,030 8.929 8,631 10,569 11,539 82.08% 12.64%N-16.80% 18.11% 15.61% 9.61% 9.10% 11.36% 15.09% 7,352 7,735 6,884 5,678 5,074 6,782 7,659 6,722 5,607 4,690 6,782 7,659 6,755 5,632 4,727 -33 -25 -37 570 76 162 71 -4.95% 12.36%21.24% 11.90% 10.59 9.3 10.29 11.05 11.7 8,427 8,744 7,253 6,983 5,553 1,512 1,679 1,929 2,032 1,668 6,007 6,225 4,511 4,213 3,190 908 840 813 738 695 7,575 1,637 3,000 2,837 7,782 7,575 1,637 3,000 2,837 7,782 47,249 31,239 28,787 29,500 35,508 58,690 57,65550,483 41,823 36,518 136,335V130,976 115,825 101,10990,452 37,536 37,743 30,954 27,391 26,627 79,384 74,901 66,721 57,192 52,608 18,811 17,704 18,150 16,526 11,217 77,645 73,321 65,342 59,286 53,934 8,894 7,243 9,430 12,291 15,322 3,322 3,517 4,602 4,387 4,426 5,572 3,726 4,828 7,904 10,896 157 554 479 860 299 35,997 37,103 36,349 37,134 23,593 26,971 26,276 24,513 24,389 14,099 9,026 10,82 11,836 12,745 9,494 872 1,521 1,313 801 1,180 872 1,521 1,313 801 1,180 (153,091 1136,524 1127,963 123,2491113,327 12.13% 6.69% 3.82% 8.76% 0.54 14.43% 500 2020 2019 2018 2017 2016 2,677 3,868 1,261 1,776 4,634 173 175 37 25 21504 3,693 761 1,739 4,609 5,581 4,128 3,824 2,928 2,475 35.20% 2.95% 30.60% 18.30% 756 575 366 1,400 329 15,740 13,739 11,175 11,317 12,864 6,499 5,953 5,322 5,226 4.965 9,241 7,786 5,853 6,091 7,899 24,754 22,310 16,626 17,421 20,302 1911 1.41 1.73 1.69 1.75