Digby's balance sheet has $83,694,000 in equity. Next year they expect Assets to increase by $4,000,000 and Liabilities to decrease by $2,000,000. If that happens, what will be Digby's book value? Select: 1 $77,694,000 $89,693,000 $35,226,000 $85,693,000
COMPXM INQUIRER Page 1 Front Page Page 2 Stocks & Bonds Page 3 Financial Summary Page 4 Production Analysis Annual Report Andrews Page 5 Thrift Segment Analysis Page 6 Core Segment Analysis Page 7 Nano Segment Analysis Page 8 Elite Segment Analysis Annual Report Baldwin Page 9 Market Share Page 10 Perceptual Map Page 11 HR/TQM Report Annual Report Chester PRINT 1/24 Annual Report Digby COMPXM INQUIRER Top " Round: 4 Dec. 31, 2018 Andrews Digby a Student: Baldwin Chester Selected Financial Statistics ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % COMPXM INQUIRER ht 2/24 Andrews 10.6% 1.09 11.6% 2.5 29.5% $0 $243,928,853 $55,574,422 $25,883,531 $73,735,557 14.3% 49.4% Baldwin 3.5% 0.75 2.6% 2.2 5.8% $0 $170,945,692 $24,232,484 $5,927,791 $11,441,101 12.9% 40.5% Chester 16.3% 1.43 23.3% 1.7 39.3% $0 $211,882,905 $59,753,200 $34,499,008 $84,080,163 6.7% 42.3% Digby 5.9% 0.74 4.4% 2.4 10.5% $0 $149,147,778 $27,989,671 $8,759,865 $12,610,494 10.7% 43.8% Page 1 COMPXM INQUIRER Top Round: 4 Stocks & Bonds December 31 , 2018 Stock Market Summary Company Andrews Baldwin Chester Digby Close $140.41 $38.45 $146.23 $35.82 Change $20.06 $6.40 $46.82 $11.71 Shares 1,884,338 3,077,844 1,812,344 3,343,529 MarketCap ($M) $265 $118 $265 $120 Book Value $46.54 $33.38 $48.47 $25.03 EPS $13.74 $1.93 $19.04 $2.62 Dividend $10.00 $0.00 $13.98 $2.81 Yield 7.1% 0.0% 9.6% 7.8% P/E 10.2 20.0 7.7 13.7 Bond Market Summary Company Andrews Baldwin Chester Digby Series# 11.2S2021 11.9S2022 10.9S2025 10.7S2026 13.3S2027 13.3S2028 12.4S2022 11.9S2024 12.5S2025 13.1S2026 13.8S2027 11.2S2024 11.5S2025 11.6S2026 12.6S2027 11.3S2021 12.5S2022 12.5S2023 12.5S2024 12.9S2025 13.4S2026 14.2S2027 Face $8,837,000 $7,072,000 $14,722,000 $43,623,000 $31,402,000 $20,006,000 $3,991,173 $15,600,742 $17,783,553 $34,005,206 $15,841,870 $4,405,854 $1,307,561 $16,345,552 $5,503,277 $692,743 $14,665,611 $7,981,720 $9,473,587 $14,407,694 $34,400,432 $2,182,064 Yield 12.1% 12.8% 12.7% 12.8% 14.0% 14.0% 12.9% 12.9% 13.2% 13.5% 13.8% 11.7% 11.9% 12.0% 12.3% 12.1% 13.1% 13.2% 13.3% 13.6% 13.8% 14.1% Close$ 92.84 93.05 85.55 83.47 95.11 94.84 95.90 92.57 94.39 96.73 100.00 95.91 96.83 97.04 102.11 93.51 95.35 94.52 93.80 94.87 96.76 100.49 S&P CC CC CC CC CC CC CCC CCC CCC CCC CCC BBB BBB BBB BBB CC CC CC CC CC CC CC Next Year's Prime Rate 9.00% COMPXM INQUIRER 3/24 Page 2 3/28/2015 COMPXM INQUIRER Top Round: 4 December 31, 2018 Financial Summary Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for noncash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations Andrews Baldwin Chester Digby $5,928 $17,509 ($686) ($2,495) $11,293 ($535) $31,014 $0 $0 $31 $0 $0 ($9,792) ($26,459) $30,422 $0 $34,499 $9,371 ($139) ($99) ($5,358) ($2,438) $35,836 $0 ($25,345) $0 ($4,044) $0 ($3,634) ($21,330) $22,277 $0 $8,760 $16,453 ($711) ($3,050) $15,423 ($302) $36,572 Cash flows from investing activities Plant improvements (net) Cash flows from financing activities Dividends paid Sales of common stock Purchase of common stock Cash from long term debt issued Early retirement of long term debt Retirement of current debt Cash from current debt borrowing Cash from emergency loan $25,884 $18,944 $0 ($272) $8,724 ($215) $53,065 ($46,080) ($18,843) $0 ($11,935) $20,006 $0 $0 $0 $0 $0 ($9,379) $0 $0 $0 ($9,014) ($29,311) $27,149 $0 Net cash from financing activities Net change in cash position ($10,773) ($3,787) ($5,798) $25,216 ($32,077) $3,759 ($20,555) $16,017 Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Plant and equipment Accumulated Depreciation Total Fixed Assets Total Assets Andrews $17,186 $21,386 $0 $38,571 $284,160 ($99,945) $184,215 $222,786 Baldwin $47,662 $14,050 $8,707 $70,420 $262,640 ($105,318) $157,322 $227,741 Chester $31,678 $17,415 $26,105 $75,198 $140,560 ($67,839) $72,721 $147,919 Digby $52,286 $12,259 $0 $64,545 $246,800 ($111,076) $135,724 $200,269 $9,424 $0 $125,662 $135,086 $19,531 $68,169 $87,700 $222,786 $7,350 $30,422 $87,223 $124,995 $52,502 $50,244 $102,747 $227,741 $10,235 $22,277 $27,562 $60,074 $8,192 $79,653 $87,845 $147,919 $5,623 $27,149 $83,804 $116,576 $50,467 $33,226 $83,694 $200,269 Andrews $243,929 $123,386 $18,944 $34,845 $11,179 $55,574 $14,941 $14,222 $528 $25,884 Baldwin $170,946 $101,762 $17,509 $21,979 $5,463 $24,232 $14,927 $3,257 $121 $5,928 Chester $211,883 $122,305 $9,371 $14,228 $6,226 $59,753 $5,595 $18,955 $704 $34,499 Digby $149,148 $83,838 $16,453 $15,943 $4,924 $27,990 $14,238 $4,813 $179 $8,760 Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Owners' Equity Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TQM, Bonuses) EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit COMPXM INQUIRER http://ww2.capsim.c Page 3 4/24 COMPXM INQUIRER Top Round: 4 December 31, 2018 Production Analysis Production Information Primary Segment Name Art Ate Attic Axe Ate2 Attic2 Art2 Boat Best Bam Bell Bit Bolt Cone Creak Cat Cell Don Drum Dart Deal Units Unit Inven Sold tory Core Nano Elite Thrift Nano Elite Core 1,662 990 1,089 1,196 1,089 1,089 1,089 Thrift Thrift Nano Elite Core Core 5/24 Price Material Cost Labor Cost 1.6 1.5 1.5 1.7 1.2 1.2 1.2 22000 26000 26000 20000 26000 26000 22000 11.4 13.7 16.4 9.3 13.9 17.0 13.0 8.6 4.0 6.5 10.7 3.7 6.2 7.6 $26.00 $36.00 $37.00 $16.00 $37.00 $35.00 $25.00 $9.09 $12.50 $12.60 $7.16 $12.67 $12.91 $9.96 $3.79 $4.15 $4.29 $3.79 $4.29 $4.29 $4.29 1,250 1,500 900 850 1,040 1,040 1,000 800 1,050 1,150 198% 198% 127% 125% 1,550 1,750 1,150 1,350 115% 93% 133% 114% 10.0 10.0 8.0 8.0 67% 86% 143% 99% 133% 138% 7.0 7.0 7.0 7.0 16% 0% 35% 15% 91% 124% 136% 99% 136% 136% 136% Plant Utiliz. 1,200 1,000 1,000 1,200 1,000 1,000 1,000 10.0 10.0 7.0 7.0 8.0 8.0 100% 100% 29% 26% 46% 44% 41% 45% 8.1 8.1 8.1 8.1 8.1 8.1 8.1 0% 0% 44% 0% 35% 39% 42% 38% 45% 44% $1.37 $1.29 $4.34 $4.10 Auto mation Capacity Next Next Round Round 0% 25% 37% 0% 37% 37% 37% 49% 45% 36% 46% 33% 38% $6.63 $6.63 $5.91 $5.87 $6.69 $6.82 $9.03 $9.64 47% 54% 54% 32% 54% 51% 43% $1.24 $1.24 $5.69 $4.96 $4.18 $4.23 $13.04 $13.82 $13.28 $13.83 $15.00 $15.00 $23.00 $25.00 $5.93 $7.14 $11.83 $12.62 $8.63 $8.38 $34.00 $34.00 $37.00 $37.00 10.4 10.2 7.0 7.5 $15.00 $17.00 $28.00 $34.00 $19.00 $20.00 2.4 4.9 2.1 4.6 9.6 9.8 12.3 13.0 10.7 9.8 2.6 5.4 7.6 8.0 15.1 18.2 15.5 18.0 17000 17000 18000 20000 9.3 10.2 14.4 17.8 12.2 11.9 23000 25000 23000 25000 2.6 2.6 1.6 1.6 14000 16000 18000 20000 16000 16000 1.3 1.6 1.4 1.3 6/10/2018 6/10/2018 12/14/2018 12/14/2018 3.2 4.1 1.0 1.0 1.0 1.0 9/13/2018 8/21/2018 8/13/2018 8/21/2018 0 0 0 0 Size Coord COMPXM INQUIRER Pfmn Coord 12/20/2017 12/7/2015 12/21/2018 12/21/2018 12/14/2018 12/14/2018 263 298 350 399 1,901 1,976 1,888 1,903 MTBF 0 0 255 235 0 0 1,828 1,422 1,363 1,377 Thrift Thrift Core Core Age Dec.31 5/8/2018 8/20/2018 8/2/2018 7/30/2018 7/21/2018 9/5/2018 9/1/2018 0 0 0 0 0 0 0 1,357 1,560 1,328 871 1,444 1,492 Nano Elite Nano Elite Revision Date 2nd Shift & Contr. Over Marg. time Page 4 3 COMPXM INQUIRER Top Round: 4 Thrift Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Thrift Statistics 7,746 7,710 25.8% Next Year's Segment Growth Rate 1. 2. 3. 4. Price Reliability Ideal Position Age December 31, 2018 11.0% Thrift Customer Buying Criteria Expectations $14.00 26.00 MTBF 1400020000 Pfmn 9.3 Size 10.7 Ideal Age = 3.0 Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Name Drum Don Boat Axe Best Bolt Art Bit Dart Market Units Sold to Share Seg 24% 1,865 24% 1,834 17% 1,320 15% 1,183 14% 1,049 3% 212 2% 136 1% 107 0% 4 Revision Date Stock Out 6/10/2018 YES 6/10/2018 YES 12/20/2017 YES 7/30/2018 YES 12/7/2015 YES 12/14/2018 YES 5/8/2018 YES 12/14/2018 YES 12/14/2018 YES COMPXM INQUIRER http://ww2.capsim.c Pfmn Coord 9.8 9.6 9.3 9.3 10.2 11.9 11.4 12.2 12.3 Size Coord 10.2 10.4 10.7 10.7 9.8 8.0 8.6 7.6 7.0 List Price $15.00 $15.00 $15.00 $16.00 $17.00 $20.00 $26.00 $19.00 $23.00 MTBF 17000 17000 14000 20000 16000 16000 22000 16000 18000 Age Dec.31 2.60 2.65 3.25 1.69 4.11 0.96 1.61 0.96 1.56 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,300 83% $1,600 83% 67 $1,300 83% $1,600 83% 69 $1,200 72% $1,000 78% 46 $1,400 100% $4,500 97% 96 $1,200 72% $1,000 78% 36 $1,200 62% $900 78% 2 $1,400 100% $2,250 97% 10 $1,200 67% $900 78% 0 $1,300 83% $1,400 83% 0 Page 5 6/24 COMPXM INQUIRER Top Round: 4 Core Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Core Statistics 9,778 9,743 32.6% Next Year's Segment Growth Rate 1. 2. 3. 4. Price Age Reliability Ideal Position December 31, 2018 10.0% Core Customer Buying Criteria Expectations $20.00 32.00 Ideal Age = 2.0 MTBF 1600022000 Pfmn 12.6 Size 7.4 Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Deal Dart Art Bit Bolt Art2 Best Drum Don Boat Ate Axe Market Units Sold to Share Seg 19% 1,895 19% 1,880 16% 1,526 14% 1,337 13% 1,280 11% 1,072 5% 510 1% 110 1% 67 0% 37 0% 15 0% 12 COMPXM INQUIRER http:/ 7/24 Revision Date Stock Out 12/14/2018 YES 12/14/2018 YES 5/8/2018 YES 12/14/2018 YES 12/14/2018 YES 9/1/2018 YES 12/7/2015 YES 6/10/2018 YES 6/10/2018 YES 12/20/2017 YES 8/20/2018 YES 7/30/2018 YES Pfmn Coord 13.0 12.3 11.4 12.2 11.9 13.0 10.2 9.8 9.6 9.3 13.7 9.3 Size Coord 7.5 7.0 8.6 7.6 8.0 7.6 9.8 10.2 10.4 10.7 4.0 10.7 List Price $25.00 $23.00 $26.00 $19.00 $20.00 $25.00 $17.00 $15.00 $15.00 $15.00 $36.00 $16.00 MTBF 20000 18000 22000 16000 16000 22000 16000 17000 17000 14000 26000 20000 Age Dec.31 1.57 1.56 1.61 0.96 0.96 1.17 4.11 2.60 2.65 3.25 1.46 1.69 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,300 83% $1,400 81% 52 $1,300 83% $1,400 81% 53 $1,400 100% $2,250 100% 55 $1,200 67% $900 73% 37 $1,200 62% $900 73% 39 $1,400 89% $2,500 100% 71 $1,200 72% $1,000 73% 10 $1,300 83% $1,600 81% 3 $1,300 83% $1,600 81% 2 $1,200 72% $1,000 73% 0 $1,400 100% $2,250 100% 0 $1,400 100% $4,500 100% 0 Page 6 COMPXM INQUI Top Round: 4 Nano Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Nano Statistics 6,164 6,164 20.6% Next Year's Segment Growth Rate 1. 2. 3. 4. Ideal Position Price Age Reliability December 31, 2018 14.0% Nano Customer Buying Criteria Expectations Pfmn 14.5 Size 2.3 $28.00 40.00 Ideal Age = 1.0 MTBF 1800024000 Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name Cone Cat Bam Ate2 Ate Attic Attic2 Cell Art2 Dart Deal Market Units Sold to Share Seg 27% 1,657 21% 1,315 21% 1,313 16% 966 13% 809 1% 49 0% 21 0% 15 0% 10 0% 4 0% 3 COMPXM INQUIRER 8/24 Revision Date Stock Out 9/13/2018 8/13/2018 12/21/2018 7/21/2018 YES 8/20/2018 YES 8/2/2018 YES 9/5/2018 YES 8/21/2018 9/1/2018 YES 12/14/2018 YES 12/14/2018 YES Pfmn Coord 15.1 15.5 14.4 13.9 13.7 16.4 17.0 18.0 13.0 12.3 13.0 Size Coord 2.4 2.1 2.6 3.7 4.0 6.5 6.2 4.6 7.6 7.0 7.5 List Price $34.00 $37.00 $28.00 $37.00 $36.00 $37.00 $35.00 $37.00 $25.00 $23.00 $25.00 MTBF 23000 23000 18000 26000 26000 26000 26000 25000 22000 18000 20000 Age Dec.31 1.27 1.36 1.02 1.24 1.46 1.48 1.20 1.35 1.17 1.56 1.57 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,400 92% $1,100 80% 66 $1,400 92% $1,000 80% 51 $1,200 73% $2,400 74% 56 $1,400 89% $2,500 100% 58 $1,400 100% $2,250 100% 56 $1,400 100% $2,250 100% 0 $1,400 89% $2,500 100% 0 $1,400 91% $1,000 80% 0 $1,400 89% $2,500 100% 0 $1,300 83% $1,400 12% 0 $1,300 83% $1,400 12% 0 Page 7 3 COMPXM INQUIRER Top Round: 4 Elite Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Elite Statistics 6,297 6,297 21.0% Next Year's Segment Growth Rate 1. 2. 3. 4. Age Price Ideal Position Reliability December 31, 2018 16.0% Elite Customer Buying Criteria Expectations Ideal Age = 0.0 $30.00 42.00 Pfmn 17.7 Size 5.5 MTBF 2000026000 Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Creak Cell Attic2 Attic Bell Cone Ate Ate2 Cat Bam Art2 Deal Market Units Sold to Share Seg 23% 1,422 22% 1,362 17% 1,068 17% 1,039 14% 871 3% 171 3% 166 2% 123 1% 48 0% 15 0% 7 0% 5 COMPXM INQUIRER http:/ 9/24 Revision Date Stock Out 8/21/2018 8/21/2018 9/5/2018 YES 8/2/2018 YES 12/21/2018 9/13/2018 8/20/2018 YES 7/21/2018 YES 8/13/2018 12/21/2018 9/1/2018 YES 12/14/2018 YES Pfmn Coord 18.2 18.0 17.0 16.4 17.8 15.1 13.7 13.9 15.5 14.4 13.0 13.0 Size Coord 4.9 4.6 6.2 6.5 5.4 2.4 4.0 3.7 2.1 2.6 7.6 7.5 List Price $34.00 $37.00 $35.00 $37.00 $34.00 $34.00 $36.00 $37.00 $37.00 $28.00 $25.00 $25.00 MTBF 25000 25000 26000 26000 20000 23000 26000 26000 23000 18000 22000 20000 Age Dec.31 1.63 1.35 1.20 1.48 1.03 1.27 1.46 1.24 1.36 1.02 1.17 1.57 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,400 92% $1,000 87% 54 $1,400 91% $1,000 87% 50 $1,400 89% $2,500 100% 73 $1,400 100% $2,250 100% 56 $1,200 72% $2,400 74% 37 $1,400 92% $1,100 87% 0 $1,400 100% $2,250 100% 8 $1,400 89% $2,500 100% 7 $1,400 92% $1,000 87% 0 $1,200 73% $2,400 74% 0 $1,400 89% $2,500 100% 1 $1,300 83% $1,400 5% 0 Page 8 COMPXM INQU Top Round: 4 Market Share Report Industry Unit Sales % of Market Art Ate Attic Axe Ate2 Attic2 Art2 Total Boat Best Bam Bell Bit Bolt Total Cone Creak Cat Cell Total Don Drum Dart Deal Total Actual Market Share in Units Thrift Core Nano Elite 7,710 25.8% 9,743 32.6% 6,164 20.6% 6,297 21.1% 1.8% 15.3% 15.7% 0.1% 0.0% 0.1% 13.1% 0.8% 2.6% 16.5% 17.1% 11.0% 26.9% 15.7% 0.3% 0.2% 30.1% 2.0% 17.0% 0.1% 38.2% 17.1% 13.6% 0.4% 5.2% 1.4% 2.8% 34.9% 13.7% 13.1% 32.5% Total 29,914 100.0% 5.5% 3.3% 3.6% 4.0% 3.6% 3.6% 3.6% 27.4% 21.3% 0.2% 13.8% 21.3% 14.1% 4.5% 5.2% 4.4% 2.9% 4.8% 5.0% 26.9% 26.9% 2.7% 22.6% 0.8% 21.6% 47.7% 6.1% 4.8% 4.6% 4.6% 20.0% 0.1% 0.1% 6.3% 6.6% 6.3% 6.4% 25.6% 21.3% 0.3% 48.5% 23.8% 24.2% 0.1% 48.0% COMPXM INQUIRER 10/24 December 31, 2018 0.7% 1.1% 19.3% 19.4% 40.6% 0.1% 0.0% 0.1% Units Demanded % of Market Art Ate Attic Axe Ate2 Attic2 Art2 Total Boat Best Bam Bell Bit Bolt Total Cone Creak Cat Cell Total Don Drum Dart Deal Total Potential Market Share in Units Thrift Core Nano Elite 7,746 25.8% 9,778 32.6% 2.1% 18.0% 0.2% 29.5% 0.2% 31.6% 22.0% 40.5% 13.9% 10.7% 0.3% 4.1% 1.1% 2.4% 28.1% 11.1% 11.7% 27.3% Total 29,984 100.0% 6,164 20.6% 6,297 21.0% 19.3% 0.9% 3.9% 19.2% 21.8% 0.5% 0.3% 42.8% 2.7% 24.4% 0.2% 50.4% 17.5% 0.2% 11.1% 17.5% 11.3% 3.7% 4.1% 3.6% 2.3% 3.9% 4.4% 22.1% 22.0% 2.2% 18.1% 0.6% 17.3% 38.2% 5.0% 3.8% 3.7% 3.7% 16.2% 0.1% 0.1% 5.4% 5.5% 5.1% 5.0% 21.0% 17.5% 0.2% 39.7% 20.2% 20.0% 40.3% 0.6% 0.9% 15.7% 15.2% 32.3% 0.1% 0.1% 6.4% 4.8% 4.2% 7.7% 5.0% 5.2% 7.3% 40.7% Page 9 COMPXM INQUIRER Top Round: 4 Perceptual Map December 31, 2018 Perceptual Map for All Segments Andrews Name Art Ate Attic Axe Ate2 Attic2 Art2 Pfmn 11.4 13.7 16.4 9.3 13.9 17.0 13.0 Size 8.6 4.0 6.5 10.7 3.7 6.2 7.6 Baldwin Revised 5/8/2018 8/20/2018 8/2/2018 7/30/2018 7/21/2018 9/5/2018 9/1/2018 Name Boat Best Bam Bell Bit Bolt Digby Name Don Drum Dart Deal Pfmn 9.6 9.8 12.3 13.0 Size 10.4 10.2 7.0 7.5 htt 11/24 Size 10.7 9.8 2.6 5.4 7.6 8.0 Chester Revised 12/20/2017 12/7/2015 12/21/2018 12/21/2018 12/14/2018 12/14/2018 Name Cone Creak Cat Cell Pfmn 15.1 18.2 15.5 18.0 Size 2.4 4.9 2.1 4.6 Revised 9/13/2018 8/21/2018 8/13/2018 8/21/2018 Revised 6/10/2018 6/10/2018 12/14/2018 12/14/2018 COMPXM INQUIRER Pfmn 9.3 10.2 14.4 17.8 12.2 11.9 Page 10 COMPXM INQUIRER Top HR/TQM Repor Round: 4 December 31, 2018 HUMAN RESOURCES SUMMARY Needed Complement Andrews 469 Baldwin 385 Chester 529 Digby 259 Complement 469 385 529 259 1st Shift Complement 2nd Shift Complement 384 85 307 78 331 198 217 42 Overtime% 0.0% 0.0% 0.0% 0.0% Turnover Rate 6.6% 6.0% 10.0% 8.0% 31 117 23 209 53 74 21 192 Recruiting Spend $5,000 $5,000 $0 $2,500 Training Hours Productivity Index 80 117.8% 80 129.4% 0 100.0% 40 117.9% $185 $585 $139 $1,044 $53 $370 $72 $960 New Employees Separated Employees Recruiting Cost Separation Cost Training Cost $750 $616 $0 $207 $1,520 $1,798 $423 $1,239 $31.04 2,500 Total HR Admin Cost $31.04 2,500 $31.04 2,500 $31.04 2,500 2.0% 5.0% 2.0% 5.0% 2.0% 5.0% 2.0% 5.0% Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise Starting Negotiation Position Wages Benefits Profit Sharing Annual Raise Ceiling Negotiation Position Wages Benefits Profit Sharing Annual Raise Adjusted Labor Demands Wages Benefits Profit Sharing Annual Raise Strike Days TQM SUMMARY Process Mgt Budgets Last Year CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase COMPXM INQUIRER h 12/24 Andrews Baldwin Chester Digby $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,500 $1,500 $0 $0 $0 $1,500 $0 $0 $1,250 $1,250 $1,250 $0 $1,250 $1,250 $0 $1,500 $0 $0 $1,000 $1,000 $1,000 $1,000 $10,000 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 $0 $0 $750 $750 $5,500 11.80% 14.00% 40.01% 60.02% 14.40% 6.07% 0.28% 0.00% 60.02% 2.35% 9.48% 14.00% 40.01% 0.00% 12.78% 10.20% 4.39% 0.00% 34.91% 10.57% Page 11 3 COMPXM INQUIRER PRINT Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?XM=1&studentkey=1114318&simid=C59559&Round=8&Report=CapCourier|AnnReport# 13/24 COMPXM INQUIRER Top Annual Report Round: 8 Andrews Dec. 31, 2018 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $17,186 $21,386 $0 2018 Common Size 7.7% 9.6% 0.0% $284,160 ($99,945) $38,572 17.3% 127.5% 44.9% $238,080 ($81,001) $184,215 82.7% $157,079 $222,786 100.0% $207,947 $9,424 $0 $125,662 4.2% 0.0% 56.4% $9,697 $0 $105,656 $19,531 $68,169 $135,086 60.6% 8.8% 30.6% $115,353 2017 $20,973 $21,171 $8,724 $50,868 Total Liabilities Total Equity $87,700 39.4% $92,594 Total Liab. & O. Equity $222,786 100.0% $207,947 Common Stock Retained Earnings $22,420 $70,174 Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: Dividends Paid Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cash from financing activities Net change in cash position Closing cash position 2017 $35,363 $15,872 $0 $1,375 ($6,797) ($4,078) $53,065 ($46,080) ($18,843) $0 ($11,935) $20,006 $0 $0 $41,736 ($13,885) $0 ($6,115) $31,402 $0 ($11,300) ($10,773) ($3,787) $17,186 $102 $958 $20,973 ($40,880) Page 1 Annual Report http://ww2.capsim.com 2018 $25,884 $18,944 $0 ($272) $8,724 ($215) 14/24 COMPXM INQUIRER Top Annual Report (Product Name:) Round: 8 Andrews Art Ate 2018 Income Statement Attic Axe Ate2 Attic2 Sales $43,201 $35,646 $40,300 $19,133 $40,300 $38,121 Variable Costs: Direct Labor $7,272 $4,113 $4,668 $4,541 $4,668 $4,668 Direct Material $15,611 $12,352 $13,730 $8,487 $13,886 $13,959 Inventory Carry $0 $0 $0 $0 $0 $0 Total Variable $22,883 $16,465 $18,398 $13,028 $18,554 $18,627 Contribution Margin $20,318 $19,181 $21,901 $6,105 $21,746 $19,494 Period Costs: Depreciation $3,072 $2,560 $2,560 $3,072 $2,560 $2,560 SG&A: R&D $353 $642 $592 $584 $559 $687 Promotions $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 Sales $2,250 $2,250 $2,250 $4,500 $2,500 $2,500 Admin $390 $322 $364 $173 $364 $344 Total Period $7,465 $7,174 $7,166 $9,728 $7,383 $7,491 Net Margin $12,853 $12,007 $14,735 ($3,623) $14,363 $12,003 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year's current debt, including short term debt, long term notes that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. 2018 Total $243,929 Common Size 100.0% $34,597 $88,789 $0 $123,386 14.2% 36.4% 0.0% 50.6% $0 $120,543 49.4% $0 $0 $0 $0 $0 $0 $18,944 $4,092 $9,800 $18,750 $2,203 $53,789 7.8% 1.7% 4.0% 7.7% 0.9% 22.1% $0 $66,754 27.4% $11,179 $55,574 $0 $14,941 $14,222 $528 $25,884 4.6% 22.8% 0.0% 6.1% 5.8% 0.2% 10.6% Art2 Na $27,229 $4,668 $10,764 $0 $15,432 $0 $0 $0 $0 $0 $11,798 $2,560 $675 $1,400 $2,500 $246 $7,381 $4,416 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report http://ww2.cap Dec. 31, 2018 15/24 3 COMPXM INQUIRER PRINT Annual Report http://ww2.capsim.com/cgibin 16/24 COMPXM INQUIRER Top Annual Report Round: 8 Baldwin Dec. 31, 2018 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $47,662 $14,050 $8,707 2018 Common Size 20.9% 6.2% 3.8% $262,640 ($105,318) $70,419 30.9% 115.3% 46.2% $262,640 ($87,809) $157,322 69.1% $174,831 $227,741 100.0% $230,792 $7,350 $30,422 $87,223 3.2% 13.4% 38.3% $9,845 $26,459 $97,700 $52,502 $50,244 $124,995 54.9% 23.1% 22.1% $134,004 2017 $22,446 $13,515 $20,000 $55,961 Total Liabilities Total Equity $102,746 45.1% $96,788 Total Liab. & O. Equity $227,741 100.0% $230,792 Common Stock Retained Earnings $52,471 $44,317 Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: Dividends Paid Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cash from financing activities Net change in cash position Closing cash position $31,014 $0 $0 $31 $0 $0 ($9,792) $3,963 ($5,798) $25,216 $47,662 2017 ($1,087) $17,509 $0 $3,118 ($18,348) ($2,025) ($833) ($45,380) $0 $16,623 $0 $15,842 $0 ($7,029) $25,436 ($20,777) $22,446 Page 1 Annual Report http://ww2.capsim.com/c 2018 $5,928 $17,509 ($686) ($2,495) $11,293 ($535) 17/24 3 COMPXM INQUIRER Top Annual Report (Product Name:) Round: 8 Baldwin Boat Best 2018 Income Statement Bam Bell Bit Bolt Sales $20,360 $26,513 $37,196 $29,601 $27,427 $29,849 Variable Costs: Direct Labor $2,063 $2,707 $7,881 $4,619 $6,110 $6,318 Direct Material $8,232 $11,762 $15,567 $10,938 $12,227 $12,294 Inventory Carry $0 $0 $541 $504 $0 $0 Total Variable $10,295 $14,469 $23,988 $16,061 $18,337 $18,612 Contribution Margin $10,065 $12,043 $13,208 $13,540 $9,090 $11,237 Period Costs: Depreciation $3,833 $4,600 $2,040 $1,927 $2,635 $2,475 SG&A: R&D $0 $0 $985 $985 $966 $966 Promotions $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 Sales $1,000 $1,000 $2,400 $2,400 $900 $900 Admin $271 $353 $495 $394 $365 $398 Total Period $6,305 $7,153 $7,120 $6,906 $6,066 $5,938 Net Margin $3,761 $4,890 $6,088 $6,635 $3,023 $5,299 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year's current debt, including short term debt, long term notes that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. 2018 Total $170,946 Common Size 100.0% $29,698 $71,020 $1,045 $101,762 17.4% 41.5% 0.6% 59.5% $0 $69,183 40.5% $0 $0 $0 $0 $0 $0 $17,509 $3,902 $7,200 $8,600 $2,277 $39,488 10.2% 2.3% 4.2% 5.0% 1.3% 23.1% $0 $29,695 17.4% $5,463 $24,232 $3,711 $11,215 $3,257 $121 $5,928 3.2% 14.2% 2.2% 6.6% 1.9% 0.1% 3.5% Na Na $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report http://ww2.capsim.com/cgibin Dec. 31, 2018 18/24 3 COMPXM INQUIRER PRINT Annual Report http://ww2.capsim 19/24 COMPXM INQUIRER Top Annual Report Round: 8 Chester Dec. 31, 2018 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $31,678 $17,415 $26,105 2018 Common Size 21.4% 11.8% 17.6% $140,560 ($67,839) $75,198 50.8% 95.0% 45.9% 2017 $27,919 $14,977 $20,747 $63,643 $140,560 ($58,468) $72,721 49.2% $82,092 $147,919 100.0% $145,735 $10,235 $22,277 $27,562 6.9% 15.1% 18.6% $10,334 $21,330 $31,336 $8,192 $79,653 $60,074 40.6% 5.5% 53.8% $63,000 Total Liabilities Total Equity $87,845 59.4% $82,735 Total Liab. & O. Equity $147,919 100.0% $145,735 Common Stock Retained Earnings $8,613 $74,122 Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: Dividends Paid Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cash from financing activities Net change in cash position Closing cash position $35,836 $0 ($25,345) $0 ($4,044) $0 ($3,634) $946 ($32,077) $3,759 $31,678 2017 $22,044 $9,371 $0 $2,244 ($15,779) ($2,003) $15,878 ($23,400) ($5,328) $0 ($2,385) $5,503 $0 ($9,193) ($11,402) ($18,924) $27,919 Page 1 Annual Report http://ww2.capsim.com/cgib 2018 $34,499 $9,371 ($139) ($99) ($5,358) ($2,438) 20/24 3 COMPXM INQUIRER Top Annual Report (Product Name:) Cone Round: 8 Chester Creak 2018 Income Statement Cat Cell Na N Sales $62,154 $48,351 $50,432 $50,946 $0 $0 Variable Costs: Direct Labor $12,241 $9,436 $8,508 $8,482 $0 $0 Direct Material $23,494 $19,611 $18,261 $19,140 $0 $0 Inventory Carry $618 $731 $824 $960 $0 $0 Total Variable $36,353 $29,778 $27,592 $28,582 $0 $0 Contribution Margin $25,801 $18,573 $22,840 $22,364 $0 $0 Period Costs: Depreciation $2,571 $1,813 $2,380 $2,607 $0 $0 SG&A: R&D $710 $645 $623 $645 $0 $0 Promotions $1,400 $1,400 $1,400 $1,400 $0 $0 Sales $1,100 $1,000 $1,000 $1,000 $0 $0 Admin $559 $435 $454 $458 $0 $0 Total Period $6,339 $5,293 $5,857 $6,110 $0 $0 Net Margin $19,462 $13,280 $16,983 $16,254 $0 $0 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year's current debt, including short term debt, long term notes that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. Na 2018 Total $211,883 Common Size 100.0% $38,667 $80,505 $3,133 $122,305 18.2% 38.0% 1.5% 57.7% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $89,578 42.3% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $9,371 $2,622 $5,600 $4,100 $1,906 $23,599 4.4% 1.2% 2.6% 1.9% 0.9% 11.1% $0 $65,979 31.1% $6,226 $59,753 $2,361 $3,233 $18,955 $704 $34,499 2.9% 28.2% 1.1% 1.5% 8.9% 0.3% 16.3% $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report http://ww2.capsim.com/cgibi Dec. 31, 2018 21/24 3 COMPXM INQUIRER PRINT Annual Report http://ww2.c 22/24 COMPXM INQUIRER Top Annual Report Round: 8 Digb Dec. 31, 2018 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $52,286 $12,259 $0 2018 Common Size 26.1% 6.1% 0.0% $246,800 ($111,076) $64,545 32.2% 123.2% 55.5% $246,800 ($94,622) $135,724 67.8% $152,178 $200,269 100.0% $215,826 $5,623 $27,149 $83,804 2.8% 13.6% 41.8% $8,673 $29,311 $93,529 $50,467 $33,226 $116,576 58.2% 25.2% 16.6% $131,513 2017 $36,269 $11,956 $15,423 $63,648 Total Liabilities Total Equity $83,693 41.8% $84,313 Total Liab. & O. Equity $200,269 100.0% $215,826 Common Stock Retained Earnings $50,467 $33,846 Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: Dividends Paid Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cash from financing activities Net change in cash position Closing cash position $36,572 $0 ($9,379) $0 $0 $0 ($9,014) ($2,162) ($20,555) $16,017 $52,286 2017 $520 $16,453 $0 $1,188 ($14,480) $444 $4,125 ($20,800) $0 $10,828 $0 $2,182 $0 ($13,366) ($356) ($17,031) $36,269 Page 1 Annual Report http://ww2.capsim.com/ 2018 $8,760 $16,453 ($711) ($3,050) $15,423 ($302) 23/24 3 COMPXM INQUIRER Top Annual Report (Product Name:) Round: 8 Digby Don Drum 2018 Income Statement Dart Deal Na Na Sales $28,513 $29,633 $43,429 $47,572 $0 $0 Variable Costs: Direct Labor $2,799 $3,121 $8,293 $7,964 $0 $0 Direct Material $12,591 $13,460 $17,148 $18,461 $0 $0 Inventory Carry $0 $0 $0 $0 $0 $0 Total Variable $15,390 $16,582 $25,441 $26,426 $0 $0 Contribution Margin $13,123 $13,051 $17,988 $21,147 $0 $0 Period Costs: Depreciation $4,753 $5,367 $2,913 $3,420 $0 $0 SG&A: R&D $446 $446 $966 $966 $0 $0 Promotions $1,300 $1,300 $1,300 $1,300 $0 $0 Sales $1,600 $1,600 $1,400 $1,400 $0 $0 Admin $367 $381 $559 $612 $0 $0 Total Period $8,466 $9,094 $7,138 $7,698 $0 $0 Net Margin $4,657 $3,957 $10,850 $13,449 $0 $0 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year's current debt, including short term debt, long term notes that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. 2018 Total $149,148 Common Size 100.0% $22,177 $61,661 $0 $83,838 14.9% 41.3% 0.0% 56.2% $0 $65,310 43.8% $0 $0 $0 $0 $0 $0 $16,453 $2,824 $5,200 $6,000 $1,919 $32,396 11.0% 1.9% 3.5% 4.0% 1.3% 21.7% $0 $32,914 22.1% $4,924 $27,990 $3,366 $10,871 $4,813 $179 $8,760 3.3% 18.8% 2.3% 7.3% 3.2% 0.1% 5.9% Na Na $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report http://ww2.capsim.com/c Dec. 31, 2018 24/24
