determine the following from 2005-2021
1) Managerial Balance Sheet 2) Days payable 3) days receivable 4) days inventories 5) NSF, NLF, and the liquidity ratios
Cash 2005 8,034 688 0 279 9,001 1,254 17 10,272 116 Accounts Receivable Inventory Other CA Total CA Fixed Assets Other LT assets Total Assets Accounts Payable Short term debt Other CL Total CL Long term debt Other LT Liab. Sharh. Equity Total 2006 11.244 1,322 0 474 13,040 5,319 115 18,473 211 0 1,094 1,305 0 129 17,040 18,473 2007 14,219 2,162 0 908 17,289 7,845 201 25,335 2008 15,846 2,642 0 1,690 20,178 11,155 434 31,767 178 0 2,124 2,302 0 1,227 28,238 31,767 2009 24,485 3,178 0 1,504 29,167 10,652 678 40,497 216 0 2,531 2,747 0 1,746 36,004 40,497 2010 34,975 4,252 0 2,335 41,562 15.582 707 57,851 483 5,826 3,687 9,996 0 1,614 46,241 57,851 2011 44,626 5,427 35 2,670 52,758 19,317 499 72,574 588 3,225 5,100 8,913 2,986 2.530 58,145 72.574 2012 48,088 7,885 505 3,976 60,454 31,333 2,011 93,798 2,012 4.222 8,103 14,337 2,988 4,758 71,715 93,798 2013 58,717 8,882 426 4,861 72,886 36,058 1,976 110.920 2,453 4,383 9,072 15,908 2,236 5,467 87,309 110,920 2014 64,395 9,383 0 4,878 78,656 47,168 3,363 129.187 1,715 4,787 10,277 16,779 3,228 5,320 103,860 129,187 2015 73,066 11,556 491 5,001 90,114 53,915 3,432 147,461 1,931 5,653 11,726 19,310 1,995 5,825 120,331 147,461 2016 86,333 14,137 268 4,670 105,408 59.887 2,202 167,497 2,041 110 14,605 16.756 3,935 7,770 139,036 167,497 2017 101,871 18,336 749 3,352 124,308 69,635 3,352 197,295 3,137 112 20.934 24,183 3,969 16,641 152,502 197,295 2018 109,140 20,838 1,107 4,591 135,676 93.686 3.430 232,792 4,378 134 30.108 34,620 4,012 16,532 177,628 232,792 2019 119,675 25,326 999 6,578 152,578 120,268 3,063 275,909 5,561 227 39,433 45,221 4,554 24,692 201,442 275,909 2020 136,694 30,930 728 5,944 174.296 140,283 5,037 319,616 5,589 1,100 50,145 56,834 13,932 26,306 222,544 319,616 2021 139,649 39,304 1,170 8,020 188,143 164,480 6,645 359,268 6,037 113 58,104 64,254 14,817 28,562 251,635 359,268 282 0 630 746 0 108 9,419 10,272 0 1,753 2,035 0 610 22,690 25,335 2020 182.527 Revenues COGS R&D Depreciation SGA Other Total expenses Operating Income Other income EBIT Interest expenses Income before taxes Tax Net Income from Ops Extraordinary Items Net Income 2005 6,139 2,320 600 257 855 90 4,121 2,017 124 2,142 0 2,142 676 1,465 0 1,465 2006 10,605 3,731 1,229 494 1,601 0 7,055 3,550 461 4,011 0 4,011 934 3,077 0 3,077 2007 16,594 5,841 2,120 809 2,741 0 11,511 5,083 592 5,675 1 5,674 1,470 4,204 0 4,204 2008 21,796 7,410 2,793 1,212 3,749 0 15,164 6,632 -779 5,853 0 5,853 1,626 4,227 0 4,227 2009 23,651 7,320 2,843 1,524 3,652 0 15,339 8,312 69 8,381 0 8,381 1,861 6.520 0 6,520 2010 29,321 9,350 3,762 1,067 4,761 0 18,940 10.381 420 10,801 5 10,796 2,291 8,505 0 8,505 2011 37,905 11,792 5,162 1,396 7,313 500 26,163 11,742 642 12,384 58 12,326 2,589 9.737 0 9,737 2012 46,039 15,188 6,083 1,988 8,946 0 32,205 13,834 719 14,553 84 14,469 2,916 11,553 -816 10,737 2013 55,519 19,212 7,137 2,781 10.986 0 40,116 15,403 577 15,980 81 15,899 2,739 13,160 -427 12.733 2014 66,001 22,168 9,832 3,523 13,982 0 49,505 16,496 864 17,360 101 17,259 3,639 13,620 516 14,136 2015 74,989 24,032 12,282 4,132 15,183 0 55,629 19,360 395 19,755 104 19,651 3,303 16,348 -522 15,826 2016 90,272 29,871 13,948 5,267 17,470 0 66,556 23,716 558 24,274 124 24,150 4,672 19,478 0 19,478 2017 110.855 39,480 16,625 6,103 19,765 2,736 84,709 26,146 1,156 27,302 109 27,193 14,531 12,662 0 12,662 2018 136.819 51,385 21,419 8,164 24,459 5,071 110,498 26,321 973 27,294 114 27,180 4,177 23,003 0 23,003 2019 161.857 61,037 26,018 10,859 28.015 1,697 127,626 34,231 5,494 39,725 100 39,625 5,282 34,343 0 34,343 71,827 27,573 12,905 28,998 0 141,303 41,224 6.971 48,195 113 48,082 7,813 40.269 0 40,269 2021 257,637 99,384 31,562 11,555 36,422 0 178,923 78,714 12,366 91,080 346 90,734 14,701 76,033 0 76,033 Cash 2005 8,034 688 0 279 9,001 1,254 17 10,272 116 Accounts Receivable Inventory Other CA Total CA Fixed Assets Other LT assets Total Assets Accounts Payable Short term debt Other CL Total CL Long term debt Other LT Liab. Sharh. Equity Total 2006 11.244 1,322 0 474 13,040 5,319 115 18,473 211 0 1,094 1,305 0 129 17,040 18,473 2007 14,219 2,162 0 908 17,289 7,845 201 25,335 2008 15,846 2,642 0 1,690 20,178 11,155 434 31,767 178 0 2,124 2,302 0 1,227 28,238 31,767 2009 24,485 3,178 0 1,504 29,167 10,652 678 40,497 216 0 2,531 2,747 0 1,746 36,004 40,497 2010 34,975 4,252 0 2,335 41,562 15.582 707 57,851 483 5,826 3,687 9,996 0 1,614 46,241 57,851 2011 44,626 5,427 35 2,670 52,758 19,317 499 72,574 588 3,225 5,100 8,913 2,986 2.530 58,145 72.574 2012 48,088 7,885 505 3,976 60,454 31,333 2,011 93,798 2,012 4.222 8,103 14,337 2,988 4,758 71,715 93,798 2013 58,717 8,882 426 4,861 72,886 36,058 1,976 110.920 2,453 4,383 9,072 15,908 2,236 5,467 87,309 110,920 2014 64,395 9,383 0 4,878 78,656 47,168 3,363 129.187 1,715 4,787 10,277 16,779 3,228 5,320 103,860 129,187 2015 73,066 11,556 491 5,001 90,114 53,915 3,432 147,461 1,931 5,653 11,726 19,310 1,995 5,825 120,331 147,461 2016 86,333 14,137 268 4,670 105,408 59.887 2,202 167,497 2,041 110 14,605 16.756 3,935 7,770 139,036 167,497 2017 101,871 18,336 749 3,352 124,308 69,635 3,352 197,295 3,137 112 20.934 24,183 3,969 16,641 152,502 197,295 2018 109,140 20,838 1,107 4,591 135,676 93.686 3.430 232,792 4,378 134 30.108 34,620 4,012 16,532 177,628 232,792 2019 119,675 25,326 999 6,578 152,578 120,268 3,063 275,909 5,561 227 39,433 45,221 4,554 24,692 201,442 275,909 2020 136,694 30,930 728 5,944 174.296 140,283 5,037 319,616 5,589 1,100 50,145 56,834 13,932 26,306 222,544 319,616 2021 139,649 39,304 1,170 8,020 188,143 164,480 6,645 359,268 6,037 113 58,104 64,254 14,817 28,562 251,635 359,268 282 0 630 746 0 108 9,419 10,272 0 1,753 2,035 0 610 22,690 25,335 2020 182.527 Revenues COGS R&D Depreciation SGA Other Total expenses Operating Income Other income EBIT Interest expenses Income before taxes Tax Net Income from Ops Extraordinary Items Net Income 2005 6,139 2,320 600 257 855 90 4,121 2,017 124 2,142 0 2,142 676 1,465 0 1,465 2006 10,605 3,731 1,229 494 1,601 0 7,055 3,550 461 4,011 0 4,011 934 3,077 0 3,077 2007 16,594 5,841 2,120 809 2,741 0 11,511 5,083 592 5,675 1 5,674 1,470 4,204 0 4,204 2008 21,796 7,410 2,793 1,212 3,749 0 15,164 6,632 -779 5,853 0 5,853 1,626 4,227 0 4,227 2009 23,651 7,320 2,843 1,524 3,652 0 15,339 8,312 69 8,381 0 8,381 1,861 6.520 0 6,520 2010 29,321 9,350 3,762 1,067 4,761 0 18,940 10.381 420 10,801 5 10,796 2,291 8,505 0 8,505 2011 37,905 11,792 5,162 1,396 7,313 500 26,163 11,742 642 12,384 58 12,326 2,589 9.737 0 9,737 2012 46,039 15,188 6,083 1,988 8,946 0 32,205 13,834 719 14,553 84 14,469 2,916 11,553 -816 10,737 2013 55,519 19,212 7,137 2,781 10.986 0 40,116 15,403 577 15,980 81 15,899 2,739 13,160 -427 12.733 2014 66,001 22,168 9,832 3,523 13,982 0 49,505 16,496 864 17,360 101 17,259 3,639 13,620 516 14,136 2015 74,989 24,032 12,282 4,132 15,183 0 55,629 19,360 395 19,755 104 19,651 3,303 16,348 -522 15,826 2016 90,272 29,871 13,948 5,267 17,470 0 66,556 23,716 558 24,274 124 24,150 4,672 19,478 0 19,478 2017 110.855 39,480 16,625 6,103 19,765 2,736 84,709 26,146 1,156 27,302 109 27,193 14,531 12,662 0 12,662 2018 136.819 51,385 21,419 8,164 24,459 5,071 110,498 26,321 973 27,294 114 27,180 4,177 23,003 0 23,003 2019 161.857 61,037 26,018 10,859 28.015 1,697 127,626 34,231 5,494 39,725 100 39,625 5,282 34,343 0 34,343 71,827 27,573 12,905 28,998 0 141,303 41,224 6.971 48,195 113 48,082 7,813 40.269 0 40,269 2021 257,637 99,384 31,562 11,555 36,422 0 178,923 78,714 12,366 91,080 346 90,734 14,701 76,033 0 76,033
