Excel File Edit View Insert Format Tools Data Window Help ! )) 18% . Sun 10:05 PM owner Q E E-Bikes Financial and Sales Data-2 Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share Cut 141 Arial 10 A- A =1 Wrap Text General AutoSum Copy * Fill Paste Merge & Center $ % 2 00 1.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H17 A C D E G H K L M N 0 P Q R S T U V W X Y This worksheet shows the number of Dirt Bikes motorcycles sold between 2016 and 2020. 26 WN - Worksheet name: Sales Amounts are in units sold Sales by Model Model 2016 2017 2018 2019 2020 8 Enduro 250 1201 1663 2291 2312 21951 iEnduro 550 2832 3290 3759 4078 36471 10 Moto 300 1755 1932 2454 2615 2627! 11 Moto 450 463 598 661 773 823! 12 TOTAL 6251 7483 9165 9778 92921 13 14 15 16 17 18 x I Sales Financial Statements International + Select destination and press ENTER or choose Paste + 100%Excel File Edit View Insert Format Tools Data Window Help ! )) 19% Sun 10:05 PM owner Q E E-Bikes Financial and Sales Data-2 Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share Cut 14#1 AutoSum Arial 10 A- A = Wrap Text General Copy * Fill Paste Merge & Center $ % 2 60 1.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter @ Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates G14 + XVfx A B C D E G H K L M N 0 P Q R S T U Consolidated Satements of Income (in thousands) 26 2020 2019 2018 Revenue 8 Net sales 60,144 64,063 61,529 Cost of goods sold 45,835 43,155 41,072 10 Gross profit/(loss) 14,309 20,908 20,457 11 Gross margin 12 13 Operating expenses 14 Sales and markering ,733 4,537 3,944 15 Engineering and product development 3,141 2.992 2.339 16 General and administrative 1,913 1,601 1,392 17 Total operating expenses 9,787 9,130 7,675 18 Operating income/loss 4,522 11,778 12,782 19 20 Other income/expense Interest income/expense 1,747 175 BO 22 Other income/(expense) 6,254 -2,914 -3,080 23 Income before provision for income taxes 15 9.039 9,782 24 Income taxes 1,459 1,729 535 25 Net income/(loss) 1,444 7,310 9,247 26 Net margin 27 28 Summary Balance Sheet Data 29 30 At December 31 2020 2019 2018 31 Current assets 32 Cash and cash equivalents 6,994 7,197 6,891 33 Accounts reveivable 3,083 12.981 12,872 34 Inventories 6,315 5,931 5,843 35 Total current assets 26,392 26,109 25,606 36 37 Property plant, and equipment 36,920 34,515 32,002 38 Other assets 1,765 1,903 1,834 39 Total assets 65,077 62,527 59,442 40 41 Current liabilities 42 Accounts payable 8,943 8,694 7,592 43 Accrued expenses and other liabilities 10,877 9,382 B,654 44 Total current liabilities 19,820 18,076 16,246 45 46 Long-term debt 9,772 9.335 8,890 47 Total liabilities 29,592 27.414 25,136 48 49 Shareholders' equity 35485 35113 34306 50 Total liabilities + shareholders' equity 65,077 62,527 59,442 51 Sales Financial Statements International + Select destination and press ENTER or choose Paste + 100%Excel File Edit View Insert Format Tools Data Window Help ! )) 19% Sun 10:05 PM owner Q E-Bikes Financial and Sales Data-2 Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share Cut Arial 10 A- A = Wrap Text General 141 AutoSum Copy * Fill Paste B Merge & Center Conditional Format Cell Insert Delete Format $ % 2 60 Format Sort & Formatting as Table Styles Clear Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates X V fix This worksheet shows number of Dirt Bikes' domestic vs. interational motorcycles sold between 2016-2020 A C E M P Q R S T U V W X Y This worksheet shows number of Dirt Bikes' domestic vs. interational motorcycles sold between 2016-2020 26 Worksheet name: Domestic vs. International Sales Amounts are in units sold Domestic vs. International Sales 2016 2017 2018 2019 2020 Domestic 5723 6843 8254 8889 8530 International 528 640 911 889 762 9 TOTAL 5251 7483 9165 9778 9292 10 % International 8.4% 8.6% 9.9% 9.1% B.2% 11 12 13 14 15 X Sales Financial Statements International + Select destination and press ENTER or choose Paste + 100%