MORE STOCK INFORMATION IS ATTACHED
Currently Baldwin is paying a dividend of $17.31 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield? |
Select: 1 |
|
COMP-XM INQUIRER Page 1 Front Page Page 2 Stocks & Bonds Page 3 Financial Summary Page 4 Production Analysis Annual Report Andrews Page 1 of 28 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 Annual Report Digby PRINT http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 2 of 28 Top " Round: 4 Dec. 31, 2019 LAURA HERRERA Student: LAURA HERRERA Andrews LAURA HERRERA Baldwin Chester Digby Selected Financial Statistics ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % COMP-XM INQUIRER Andrews -0.8% 1.18 -1.0% 1.7 -1.7% $0 $157,437,115 $2,685,353 ($1,335,293) $7,734,472 7.9% 17.5% Baldwin 17.7% 1.36 24.1% 1.7 40.8% $0 $266,612,436 $81,476,039 $47,111,241 $108,374,465 5.4% 42.5% Chester 5.5% 0.75 4.1% 2.4 9.9% $0 $150,645,329 $27,012,368 $8,236,988 $13,195,075 10.2% 42.3% Digby 4.7% 0.77 3.6% 2.2 7.9% $0 $190,422,983 $29,979,827 $8,899,206 $14,483,288 11.3% 39.4% Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 3 of 28 Top Stocks & Bonds Round: 4 LAURA HERRERA December 31 , 2019 Stock Market Summary Company Andrews Baldwin Chester Digby Close $35.03 $183.98 $36.03 $42.46 Change ($8.02) $67.11 $11.42 $11.38 Shares 2,051,119 1,877,764 3,260,330 3,290,431 MarketCap ($M) $72 $345 $117 $140 Book Value $38.51 $61.52 $25.55 $34.19 EPS ($0.65) $25.09 $2.53 $2.70 Dividend $0.00 $17.31 $2.54 $0.00 Yield 0.0% 9.4% 7.0% 0.0% P/E -53.9 7.3 14.3 15.7 Bond Market Summary Company Andrews Baldwin Chester Digby Series# Face Yield Close$ S&P 11.2S2022 11.9S2023 10.9S2026 10.9S2027 $8,837,000 $7,072,000 $14,722,000 $11,960,000 11.5% 12.0% 11.6% 11.6% 97.61 99.09 94.11 93.59 BBB BBB BBB BBB 11.2S2025 11.5S2026 11.5S2027 12.8S2028 $392,349 $1,376,019 $20,200,233 $13,298,818 11.7% 11.9% 12.0% 12.5% 95.52 96.38 96.07 102.63 BBB BBB BBB BBB 12.5S2023 12.5S2024 12.5S2025 12.9S2026 13.4S2027 14.2S2028 $13,756,152 $7,975,862 $9,473,322 $14,397,660 $32,604,140 $4,293,899 13.1% 13.2% 13.3% 13.6% 13.8% 14.1% 95.35 94.52 93.80 94.87 96.76 100.49 CC CC CC CC CC CC 11.9S2025 12.6S2026 13.1S2027 13.9S2028 $11,646,037 $17,795,619 $35,570,291 $25,967,666 12.8% 13.2% 13.5% 13.8% 92.94 95.24 97.19 101.00 CCC CCC CCC CCC Next Year's Prime Rate 9.00% COMP-XM INQUIRER Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 4 of 28 Top Financial Summary Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations 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 Net cash from financing activities Round: 4 December 31, 2019 LAURA HERRERA Andrews Baldwin Chester Digby ($1,335) $47,111 $8,237 $8,899 $7,477 $0 $11,184 ($184) $16,373 ($803) $18,215 ($1,203) $539 ($14,622) ($1,031) ($8,973) $2,789 ($6,907) ($3,723) $50,270 ($559) ($1,406) ($485) $21,358 $884 ($6,864) ($940) $18,990 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($32,507) $0 ($3,539) $0 ($7,601) ($18,591) $31,947 $0 ($8,273) $0 $0 $0 ($10,524) ($29,550) $26,974 $0 $0 $5,105 $0 $0 ($17,217) ($28,034) $33,431 $0 $0 ($30,291) ($21,373) ($6,715) ($8,973) $19,979 ($15) $12,275 Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $48,737 $12,940 $32,883 $94,559 Baldwin $52,577 $21,913 $25,681 $100,172 Chester $39,724 $12,382 $12,961 $65,067 Digby $43,795 $15,651 $21,108 $80,554 Plant and equipment Accumulated Depreciation Total Fixed Assets $112,150 ($73,575) $38,575 $167,760 ($72,279) $95,481 $245,600 ($110,749) $134,851 $273,220 ($107,029) $166,191 Total Assets $133,135 $195,653 $199,918 $246,745 Accounts Payable Current Debt Long Term Debt Total Liabilities $11,559 $0 $42,591 $54,150 $12,922 $31,947 $35,267 $80,137 $7,137 $26,974 $82,501 $116,612 $9,843 $33,431 $90,980 $134,253 Common Stock Retained Earnings Total Equity $12,081 $66,904 $78,985 $10,583 $104,933 $115,516 $48,353 $34,953 $83,306 $59,223 $53,269 $112,492 Total Liabilities & Owners' Equity $133,135 $195,653 $199,918 $246,745 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 Andrews $157,437 $129,957 $7,477 $12,419 $4,900 $2,685 $4,740 ($719) $0 ($1,335) Baldwin $266,612 $153,396 $11,184 $14,323 $6,233 $81,476 $7,518 $25,885 $961 $47,111 Chester $150,645 $86,982 $16,373 $15,423 $4,855 $27,012 $14,081 $4,526 $168 $8,237 Digby $190,423 $115,423 $18,215 $21,495 $5,310 $29,980 $16,009 $4,890 $182 $8,899 Net change in cash position COMP-XM INQUIRER Page 3 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 5 of 28 Top Production Analysis Round: 4 December 31, 2019 LAURA HERRERA Production Information Primary Segment Units Sold Unit Inven tory Art Ate Attic Axe Core Nano Elite Thrift 2,128 1,475 1,054 1,516 Boat Best Bam Bell Nano Elite Nano Elite Cone Creak Camp Cell Don Drum Daft Deal Dim Dome Name Revision Date Age Dec.31 269 65 425 1,098 4/16/2019 4/15/2019 4/27/2019 4/11/2019 2,150 1,907 1,587 1,891 227 0 594 474 Thrift Thrift Core Core 1,782 1,805 2,049 1,989 Thrift Thrift Nano Elite Core Core 1,211 1,438 1,543 1,196 1,542 1,732 COMP-XM INQUIRER Labor Cost Contr. Marg. 2nd Shift & Overtime $9.86 $12.93 $13.56 $7.09 $9.78 $11.58 $10.95 $6.33 15% 17% 29% 5% 86% 100% 56% 37% 5.0 4.0 4.0 6.8 1,300 778 814 1,305 184% 198% 155% 136% $34.00 $34.00 $37.00 $37.00 $13.04 $13.82 $13.28 $13.83 $6.63 $6.63 $6.15 $6.07 42% 40% 45% 44% 100% 100% 46% 39% 7.0 7.0 7.0 7.0 1,200 900 1,300 1,400 198% 198% 145% 138% 11.8 11.6 8.4 8.9 $15.00 $15.00 $23.00 $25.00 $6.69 $6.82 $9.03 $9.64 $1.37 $1.31 $4.67 $4.43 45% 44% 39% 43% 17% 6% 83% 48% 10.0 10.0 8.0 8.0 1,500 1,650 1,200 1,450 116% 105% 182% 147% 12.1 11.2 4.0 6.8 9.0 9.4 $15.00 $17.00 $28.00 $34.00 $19.00 $20.00 $5.93 $7.14 $11.83 $12.62 $8.63 $8.38 $1.23 $1.23 $5.92 $5.37 $4.35 $4.47 49% 45% 35% 45% 31% 36% 0% 0% 76% 25% 62% 83% 10.0 10.0 7.0 7.0 8.0 8.0 1,250 1,500 1,050 1,000 1,050 1,040 83% 99% 174% 124% 160% 181% MTBF Pfmn Coord Size Coord Material Price Cost 1.7 1.9 1.8 1.9 22000 24000 26000 19800 9.7 11.3 14.1 6.7 10.7 6.0 8.7 13.3 $23.75 $30.00 $36.50 $15.95 9/13/2019 8/21/2019 8/13/2019 8/21/2019 1.3 1.6 1.4 1.3 23000 25000 23000 25000 13.8 16.9 14.2 16.7 3.8 6.3 3.5 6.0 159 176 359 378 6/10/2019 6/10/2019 12/14/2019 12/14/2019 2.6 2.6 1.6 1.6 17000 17000 18000 20000 8.3 8.5 11.0 11.7 135 274 439 283 220 150 12/20/2018 12/6/2016 12/21/2019 12/21/2019 12/14/2019 12/14/2019 3.2 4.1 1.0 1.0 1.0 1.0 14000 16000 18000 20000 16000 16000 8.0 8.9 13.1 16.5 10.9 10.6 Auto mation Capacity Next Next Round Round Plant Utiliz. Page 4 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 6 of 28 Top Thrift Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry LAURA HERRERA Thrift Statistics 7,748 7,748 25.8% Next Year's Segment Growth Rate 11.0% Thrift Customer Buying Criteria 1. 2. 3. 4. Expectations $14.00 - 26.00 MTBF 14000-20000 Pfmn 8.0 Size 12.1 Ideal Age = 3.0 Price Reliability Ideal Position Age Round: 4 December 31, 2019 Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Name Cone Creak Axe Don Drum Art Dome Dim Camp Market Share 22% 22% 20% 15% 12% 6% 3% 1% 0% Units Sold to Seg 1,708 1,690 1,516 1,169 900 461 206 95 3 COMP-XM INQUIRER Revision Date Stock Out 6/10/2019 6/10/2019 4/11/2019 12/20/2018 12/6/2016 4/16/2019 12/14/2019 12/14/2019 12/14/2019 Pfmn Coord 8.3 8.5 6.7 8.0 8.9 9.7 10.6 10.9 11.0 Size Coord 11.8 11.6 13.3 12.1 11.2 10.7 9.4 9.0 8.4 List Price $15.00 $15.00 $15.95 $15.00 $17.00 $23.75 $20.00 $19.00 $23.00 MTBF 17000 17000 19800 14000 16000 22000 16000 16000 18000 Age Dec.31 2.65 2.60 1.86 3.25 4.11 1.73 0.96 0.96 1.56 Promo Cust. AwareBudget ness $1,300 83% $1,300 83% $1,150 79% $1,200 72% $1,200 72% $1,300 81% $1,200 62% $1,200 67% $1,300 83% Sales Cust. Access- Dec. Cust. Budget ibility Survey $1,600 83% 69 $1,600 83% 67 $1,400 83% 58 $1,000 78% 46 $1,000 78% 36 $1,100 83% 19 $900 78% 2 $900 78% 0 $1,400 83% 0 Page 5 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 7 of 28 Top Core Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry LAURA HERRERA Core Statistics 9,781 9,781 32.6% Next Year's Segment Growth Rate 10.0% Core Customer Buying Criteria 1. 2. 3. 4. Expectations $20.00 - 32.00 Ideal Age = 2.0 MTBF 16000-22000 Pfmn 11.3 Size 8.8 Price Age Reliability Ideal Position Round: 4 December 31, 2019 Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Camp Cell Art Dome Dim Drum Ate Creak Cone Attic Don Market Share 21% 20% 17% 16% 15% 6% 3% 1% 1% 1% 0% Units Sold to Seg 2,041 1,978 1,666 1,526 1,447 538 302 115 74 51 42 COMP-XM INQUIRER Revision Date Stock Out 12/14/2019 12/14/2019 4/16/2019 12/14/2019 12/14/2019 12/6/2016 4/15/2019 6/10/2019 6/10/2019 4/27/2019 12/20/2018 Pfmn Coord 11.0 11.7 9.7 10.6 10.9 8.9 11.3 8.5 8.3 14.1 8.0 Size Coord 8.4 8.9 10.7 9.4 9.0 11.2 6.0 11.6 11.8 8.7 12.1 List Price $23.00 $25.00 $23.75 $20.00 $19.00 $17.00 $30.00 $15.00 $15.00 $36.50 $15.00 MTBF 18000 20000 22000 16000 16000 16000 24000 17000 17000 26000 14000 Age Dec.31 1.56 1.57 1.73 0.96 0.96 4.11 1.91 2.60 2.65 1.78 3.25 Promo Cust. AwareBudget ness $1,300 83% $1,300 83% $1,300 81% $1,200 62% $1,200 67% $1,200 72% $1,300 85% $1,300 83% $1,300 83% $1,000 68% $1,200 72% Sales Cust. Access- Dec. Cust. Budget ibility Survey $1,400 81% 53 $1,400 81% 52 $1,100 63% 42 $900 73% 39 $900 73% 37 $1,000 73% 10 $950 63% 11 $1,600 81% 3 $1,600 81% 2 $950 63% 2 $1,000 73% 0 Page 6 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 8 of 28 Top Nano Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry LAURA HERRERA Nano Statistics 6,166 6,166 20.6% Next Year's Segment Growth Rate 14.0% Nano Customer Buying Criteria 1. 2. 3. 4. Expectations Pfmn 13.2 Size 3.7 $28.00 - 40.00 Ideal Age = 1.0 MTBF 18000-24000 Ideal Position Price Age Reliability Round: 4 December 31, 2019 Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name Boat Bam Daft Ate Attic Bell Camp Cell Market Share 31% 25% 25% 18% 1% 0% 0% 0% Units Sold to Seg 1,921 1,524 1,523 1,136 37 18 5 3 COMP-XM INQUIRER Revision Date Stock Out 9/13/2019 8/13/2019 12/21/2019 4/15/2019 4/27/2019 8/21/2019 12/14/2019 12/14/2019 Pfmn Coord 13.8 14.2 13.1 11.3 14.1 16.7 11.0 11.7 Size Coord 3.8 3.5 4.0 6.0 8.7 6.0 8.4 8.9 List Price $34.00 $37.00 $28.00 $30.00 $36.50 $37.00 $23.00 $25.00 MTBF 23000 23000 18000 24000 26000 25000 18000 20000 Age Dec.31 1.27 1.36 1.02 1.91 1.78 1.35 1.56 1.57 Promo Cust. AwareBudget ness $1,400 92% $1,400 92% $1,200 73% $1,300 85% $1,000 68% $1,400 91% $1,300 83% $1,300 83% Sales Cust. Access- Dec. Cust. Budget ibility Survey $1,100 80% 66 $1,000 80% 51 $2,400 74% 56 $950 45% 33 $950 45% 0 $1,000 80% 0 $1,400 12% 0 $1,400 12% 0 Page 7 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 9 of 28 Top Elite Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry LAURA HERRERA Elite Statistics 6,299 6,299 21.0% Next Year's Segment Growth Rate 16.0% Elite Customer Buying Criteria 1. 2. 3. 4. Expectations Ideal Age = 0.0 $30.00 - 42.00 Pfmn 16.4 Size 6.9 MTBF 20000-26000 Age Price Ideal Position Reliability Round: 4 December 31, 2019 Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Best Bell Deal Attic Boat Bam Ate Daft Cell Market Share 30% 30% 19% 15% 4% 1% 1% 0% 0% Units Sold to Seg 1,907 1,873 1,196 965 229 64 37 20 7 COMP-XM INQUIRER Revision Date Stock Out 8/21/2019 YES 8/21/2019 12/21/2019 4/27/2019 9/13/2019 8/13/2019 4/15/2019 12/21/2019 12/14/2019 Pfmn Coord 16.9 16.7 16.5 14.1 13.8 14.2 11.3 13.1 11.7 Size Coord 6.3 6.0 6.8 8.7 3.8 3.5 6.0 4.0 8.9 List Price $34.00 $37.00 $34.00 $36.50 $34.00 $37.00 $30.00 $28.00 $25.00 MTBF 25000 25000 20000 26000 23000 23000 24000 18000 20000 Age Dec.31 1.63 1.35 1.03 1.78 1.27 1.36 1.91 1.02 1.57 Promo Cust. AwareBudget ness $1,400 92% $1,400 91% $1,200 72% $1,000 68% $1,400 92% $1,400 92% $1,300 85% $1,200 73% $1,300 83% Sales Cust. Access- Dec. Cust. Budget ibility Survey $1,000 87% 54 $1,000 87% 50 $2,400 74% 37 $950 45% 21 $1,100 87% 0 $1,000 87% 0 $950 45% 0 $2,400 74% 0 $1,400 5% 0 Page 8 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 10 of 28 Top Market Share Report Actual Market Share in Units Industry Unit Sales % of Market Art Ate Attic Axe Total Potential Market Share in Units Thrift 7,748 25.8% Core 9,781 32.6% Nano 6,166 20.6% Elite 6,299 21.0% Total 29,994 100.0% 6.0% 17.0% 3.1% 0.5% 18.4% 0.6% 0.6% 15.3% 20.6% 19.0% 15.9% 7.1% 4.9% 3.5% 5.0% 20.6% Art Ate Attic Axe Total 31.1% 3.6% 30.3% 1.0% 29.7% 64.7% 7.2% 6.4% 5.3% 6.3% 25.1% Boat Best Bam Bell Total 0.1% 0.1% 0.1% Cone Creak Camp Cell Total 22.0% 21.8% 0.1% 0.1% 5.9% 6.0% 6.8% 6.6% 25.4% 43.9% 0.8% 1.2% 20.9% 20.2% 43.0% 24.7% 0.3% 19.0% 0.4% 5.5% 19.3% Don Drum Daft Deal Dim Dome Total 15.1% 11.6% 24.7% 4.0% 4.8% 5.1% 4.0% 5.1% 5.8% 28.9% 1.2% 2.7% 30.6% 14.8% 15.6% 36.3% 19.6% 25.5% Boat Best Bam Bell Total 24.7% 0.3% 56.1% Cone Creak Camp Cell Total 22.0% 21.8% 0.0% 43.9% 0.8% 1.2% 20.9% 20.2% 43.0% Don Drum Daft Deal Dim Dome Total 15.1% 11.6% 0.4% 5.5% 1.2% 2.6% 30.6% 14.8% 15.6% 36.3% COMP-XM INQUIRER Round: 4 December 31, 2019 LAURA HERRERA Units Demanded % of Market Thrift 7,748 25.8% Core 9,781 32.6% Nano 6,166 20.6% Elite 6,299 21.0% Total 29,994 100.0% 6.0% 17.0% 3.1% 0.5% 18.5% 0.6% 0.6% 15.2% 19.1% 15.8% 7.1% 4.9% 3.5% 5.1% 20.6% 31.1% 3.6% 30.8% 1.0% 29.5% 64.9% 7.2% 6.5% 5.3% 6.2% 25.2% 0.1% 0.1% 0.1% 5.9% 6.0% 6.8% 6.6% 25.4% 24.7% 0.3% 18.8% 24.7% 19.1% 19.6% 25.5% 20.7% 24.7% 0.3% 56.1% 0.1% 4.0% 4.8% 5.1% 4.0% 5.1% 5.8% 28.8% Page 9 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 11 of 28 Top Perceptual Map Round: 4 December 31, 2019 LAURA HERRERA Perceptual Map for All Segments Andrews Name Art Ate Attic Axe Pfmn 9.7 11.3 14.1 6.7 Size 10.7 6.0 8.7 13.3 Baldwin Revised 4/16/2019 4/15/2019 4/27/2019 4/11/2019 Name Boat Best Bam Bell Pfmn 13.8 16.9 14.2 16.7 Size 3.8 6.3 3.5 6.0 Chester Revised 9/13/2019 8/21/2019 8/13/2019 8/21/2019 Name Cone Creak Camp Cell Pfmn 8.3 8.5 11.0 11.7 Size 11.8 11.6 8.4 8.9 Revised 6/10/2019 6/10/2019 12/14/2019 12/14/2019 Digby Name Don Drum Daft Deal Dim Dome Pfmn 8.0 8.9 13.1 16.5 10.9 10.6 Size 12.1 11.2 4.0 6.8 9.0 9.4 COMP-XM INQUIRER Revised 12/20/2018 12/6/2016 12/21/2019 12/21/2019 12/14/2019 12/14/2019 Page 10 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 12 of 28 Top HR/TQM Report LAURA HERRERA Round: 4 December 31, 2019 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 880 880 514 366 Baldwin 666 666 397 269 Chester 333 333 224 110 Digby 507 507 335 172 Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.0% 8.1% 71 14 $2,000 40 106.6% 0.0% 10.0% 134 0 $0 0 100.0% 0.0% 8.0% 27 71 $2,500 40 118.7% 0.0% 6.0% 31 53 $5,000 80 130.8% $213 $70 $704 $987 $134 $0 $0 $134 $93 $353 $267 $713 $183 $266 $811 $1,260 $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost 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 COMP-XM INQUIRER Andrews Baldwin Chester Digby $0 $0 $1,250 $1,200 $1,200 $0 $0 $0 $1,250 $1,250 $1,250 $0 $1,250 $1,250 $0 $1,500 $0 $0 $1,500 $1,500 $0 $0 $0 $1,500 $0 $0 $1,250 $0 $4,900 $0 $0 $1,250 $1,250 $6,250 $0 $0 $750 $750 $5,500 $1,500 $0 $0 $0 $6,000 0.32% 11.28% 39.50% 0.44% 8.16% 9.48% 14.00% 40.01% 0.00% 12.78% 10.20% 4.39% 0.00% 34.91% 10.57% 6.07% 0.28% 0.00% 60.02% 2.35% Page 11 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 13 of 28 PRINT Annual Report http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 14 of 28 Top Annual Report Andrews Round: 8 Dec. 31, 2019 C59559 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 end-of-year cash position. Cash Accounts Receivable: Reflects the lag between delivery Accounts Receivable and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates Inventory your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current Total Current Assets value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the Plant & Equipment company currently owes suppliers for materials and services. Accumulated Depreciation Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency Total Fixed Assets loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's Total Assets long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount LIABILITIES & OWNERS' of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to EQUITY keep instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $48,737 $12,940 $32,883 $94,560 $112,150 ($73,575) 71.0% $87,879 84.2% -55.3% $112,150 ($66,098) 29.0% $46,052 100.0% $133,931 8.7% 0.0% 32.0% $11,020 $0 $42,591 $54,150 Total Liab. & O. Equity $57,709 $11,909 $18,261 $38,575 $12,081 $66,904 Total Equity 2018 $133,135 $11,559 $0 $42,591 Total Liabilities Common Stock Retained Earnings 2019 Common Size 36.6% 9.7% 24.7% 40.7% $53,611 9.1% 50.3% $12,081 $68,239 $78,985 59.3% $80,320 $133,135 100.0% $133,931 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 Annual Report 2019 ($1,335) $7,477 $0 $539 ($14,622) ($1,031) 2018 ($1,568) $7,477 $0 $2,746 ($17,908) ($378) ($8,973) ($9,631) $0 ($3,590) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($11,300) $0 ($8,973) $48,737 ($11,300) ($24,521) $57,709 Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 15 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 16 of 28 Top Annual Report Andrews Round: 8 Dec. 31, 2019 C59559 2019 Income Statement Attic $38,468 Axe $24,180 Na $0 Na $0 Na $0 Na $0 2019 Total $157,437 Common Size 100.0% $17,085 $19,340 $194 $36,619 $11,692 $14,552 $1,269 $27,512 $10,102 $11,129 $1,845 $23,077 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $59,695 $66,315 $3,946 $129,957 37.9% 42.1% 2.5% 82.5% $7,783 $7,638 $10,956 $1,103 $0 $0 $0 $0 $27,481 17.5% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $2,253 $294 $1,300 $1,100 $669 $5,616 $1,141 $289 $1,300 $950 $586 $4,266 $1,194 $323 $1,000 $950 $509 $3,976 $2,888 $278 $1,150 $1,400 $320 $6,037 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,477 $1,184 $4,750 $4,400 $2,084 $19,895 4.7% 0.8% 3.0% 2.8% 1.3% 12.6% Net Margin $2,167 $3,372 $6,980 ($4,933) $0 $0 $0 $0 $7,585 4.8% $4,900 $2,685 $0 $4,740 ($719) $0 ($1,335) 3.1% 1.7% 0.0% 3.0% -0.5% 0.0% -0.8% (Product Name:) Sales Art $50,531 Ate $44,258 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $20,816 $21,294 $638 $42,748 Contribution Margin 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 straight-line 15-year 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. Write-offs 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. Annual Report PRINT Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 17 of 28 Annual Report http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 18 of 28 Top Annual Report Baldwin Round: 8 Dec. 31, 2019 C59559 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 end-of-year cash position. Cash Accounts Receivable: Reflects the lag between delivery Accounts Receivable and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates Inventory your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current Total Current Assets value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the Plant & Equipment company currently owes suppliers for materials and services. Accumulated Depreciation Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency Total Fixed Assets loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's Total Assets long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount LIABILITIES & OWNERS' of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to EQUITY keep instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $52,577 $21,913 $25,681 $100,171 2018 $32,598 $18,190 $18,775 51.2% $69,563 85.7% -36.9% $167,760 ($61,095) $95,481 48.8% $106,665 $195,653 100.0% $176,228 6.6% 16.3% 18.0% $10,133 $18,591 $43,052 $167,760 ($72,279) $12,922 $31,947 $35,267 Total Liabilities Common Stock Retained Earnings 2019 Common Size 26.9% 11.2% 13.1% $80,136 $10,583 $104,933 41.0% $71,776 5.4% 53.6% $10,954 $93,497 Total Equity $115,516 59.0% $104,451 Total Liab. & O. Equity $195,653 100.0% $176,228 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 Annual Report 2019 $47,111 $11,184 ($184) $2,789 ($6,907) ($3,723) 2018 $28,510 $11,184 $0 ($2,110) $11,330 ($2,726) $50,270 $46,189 $0 ($38,400) ($32,507) $0 ($3,539) $0 ($7,601) $13,356 $0 $876 $0 $13,299 $0 ($14,905) ($30,291) $19,979 $52,577 ($730) $7,059 $32,598 Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 19 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 20 of 28 Top Annual Report (Product Name:) Baldwin Bell $69,956 Na $0 Na $0 Na $0 Na $0 2019 Total $266,612 Common Size 100.0% $12,692 $26,302 $0 $38,993 $10,021 $21,182 $1,401 $32,605 $11,939 $26,322 $1,151 $39,412 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $48,899 $101,416 $3,082 $153,396 18.3% 38.0% 1.2% 57.5% $30,707 $25,835 $26,131 $30,543 $0 $0 $0 $0 $113,216 42.5% $3,024 $710 $1,400 $1,100 $548 $6,782 $2,040 $645 $1,400 $1,000 $486 $5,571 $2,947 $623 $1,400 $1,000 $441 $6,410 $3,173 $645 $1,400 $1,000 $525 $6,743 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $11,184 $2,622 $5,600 $4,100 $2,001 $25,507 4.2% 1.0% 2.1% 1.5% 0.8% 9.6% $23,925 $20,264 $19,721 $23,800 $0 $0 $0 $0 $87,709 32.9% $6,233 $81,476 $3,291 $4,227 $25,885 $961 $47,111 2.3% 30.6% 1.2% 1.6% 9.7% 0.4% 17.7% Best $64,828 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $14,247 $27,610 $529 $42,386 Contribution Margin Net Margin 2019 Income Statement Bam $58,736 Sales Boat $73,093 Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period 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 straight-line 15-year 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. Write-offs 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. Annual Report Round: 8 Dec. 31, 2019 C59559 PRINT Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 21 of 28 Annual Report http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 22 of 28 Top Annual Report Chester Round: 8 Dec. 31, 2019 C59559 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 end-of-year cash position. Cash Accounts Receivable: Reflects the lag between delivery Accounts Receivable and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates Inventory your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current Total Current Assets value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the Plant & Equipment company currently owes suppliers for materials and services. Accumulated Depreciation Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency Total Fixed Assets loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's Total Assets long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount LIABILITIES & OWNERS' of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to EQUITY keep instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $39,724 $12,382 $12,961 $65,067 $63,191 $245,600 ($94,376) $134,851 67.5% $151,224 $199,918 100.0% $214,416 3.6% 13.5% 41.3% $7,696 $29,550 $93,828 58.3% $131,074 24.2% 17.5% $48,353 $34,989 $116,612 $48,353 $34,953 Total Liab. & O. Equity $39,739 $11,897 $11,555 32.5% $7,137 $26,974 $82,501 Total Equity 2018 122.9% -55.4% $245,600 ($110,749) Total Liabilities Common Stock Retained Earnings 2019 Common Size 19.9% 6.2% 6.5% $83,306 41.7% $83,342 $199,918 100.0% $214,416 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 Annual Report 2019 $8,237 $16,373 ($803) ($559) ($1,406) ($485) 2018 $603 $16,373 $0 ($749) ($3,266) $601 $21,358 $13,562 $0 ($22,100) ($8,273) $0 $0 $0 ($10,524) ($2,576) $0 $10,366 $0 $4,294 $0 ($13,714) ($21,373) ($15) $39,724 $946 ($7,592) $39,739 Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 23 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 24 of 28 Top Annual Report Chester Round: 8 Dec. 31, 2019 C59559 2019 Income Statement Camp $47,130 Cell $49,715 Na $0 Na $0 Na $0 Na $0 2019 Total $150,645 Common Size 100.0% $2,724 $12,279 $176 $15,179 $9,548 $18,404 $587 $28,538 $8,825 $19,087 $636 $28,547 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $23,820 $61,606 $1,555 $86,982 15.8% 40.9% 1.0% 57.7% $12,009 $11,896 $18,592 $21,167 $0 $0 $0 $0 $63,664 42.3% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $4,600 $446 $1,300 $1,600 $248 $8,194 $5,060 $446 $1,300 $1,600 $251 $8,657 $3,040 $966 $1,300 $1,400 $438 $7,144 $3,673 $966 $1,300 $1,400 $462 $7,801 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $16,373 $2,824 $5,200 $6,000 $1,399 $31,796 10.9% 1.9% 3.5% 4.0% 0.9% 21.1% Net Margin $3,815 $3,239 $11,448 $13,366 $0 $0 $0 $0 $31,867 21.2% $4,855 $27,012 $3,345 $10,737 $4,526 $168 $8,237 3.2% 17.9% 2.2% 7.1% 3.0% 0.1% 5.5% (Product Name:) Sales Cone $26,726 Creak $27,075 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $2,724 $11,837 $156 $14,717 Contribution Margin 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 straight-line 15-year 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. Write-offs 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. Annual Report PRINT Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 25 of 28 Annual Report http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 26 of 28 Top Annual Report Digby Round: 8 Dec. 31, 2019 C59559 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 end-of-year cash position. Cash Accounts Receivable: Reflects the lag between delivery Accounts Receivable and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates Inventory your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current Total Current Assets value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the Plant & Equipment company currently owes suppliers for materials and services. Accumulated Depreciation Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency Total Fixed Assets loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's Total Assets long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount LIABILITIES & OWNERS' of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to EQUITY keep instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $43,795 $15,651 $21,108 $80,554 2018 $31,520 $14,711 $14,244 32.6% $60,475 110.7% -43.4% $273,220 ($88,814) $166,191 67.4% $184,406 $246,745 100.0% $244,880 4.0% 13.5% 36.9% $8,959 $28,034 $109,400 54.4% $146,393 24.0% 21.6% $54,117 $44,370 $273,220 ($107,029) $9,843 $33,431 $90,980 Total Liabilities Common Stock Retained Earnings 2019 Common Size 17.7% 6.3% 8.6% $134,254 $59,223 $53,269 Total Equity $112,492 45.6% $98,487 Total Liab. & O. Equity $246,745 100.0% $244,880 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 Annual Report 2019 $8,899 $18,215 ($1,203) $884 ($6,864) ($940) 2018 $246 $18,215 $0 $109 $3,168 ($2,774) $18,990 $18,963 $0 ($51,460) $0 $5,105 $0 $0 ($17,217) $5,397 $0 $18,331 $0 $25,968 $0 ($6,877) ($6,715) $12,275 $43,795 $37,422 $4,925 $31,520 Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 27 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016 COMP-XM INQUIRER Page 28 of 28 Top Annual Report Digby Round: 8 Dec. 31, 2019 C59559 2019 Income Statement Daft $43,201 Deal $40,673 Dim $29,303 Dome $34,632 Na $0 Na $0 2019 Total $190,423 Common Size 100.0% $2,316 $10,793 $300 $13,408 $9,244 $17,947 $929 $28,120 $6,680 $14,969 $615 $22,264 $6,805 $13,067 $340 $20,211 $7,745 $14,192 $228 $22,165 $0 $0 $0 $0 $0 $0 $0 $0 $34,490 $78,400 $2,533 $115,423 18.1% 41.2% 1.3% 60.6% $8,915 $11,036 $15,081 $18,409 $9,091 $12,467 $0 $0 $75,000 39.4% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $3,833 $0 $1,200 $1,000 $171 $6,204 $4,600 $0 $1,200 $1,000 $230 $7,030 $2,380 $985 $1,200 $2,400 $407 $7,372 $2,267 $985 $1,200 $2,400 $383 $7,234 $2,660 $966 $1,200 $900 $276 $6,002 $2,475 $966 $1,200 $900 $326 $5,867 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $18,215 $3,902 $7,200 $8,600 $1,793 $39,709 9.6% 2.0% 3.8% 4.5% 0.9% 20.9% Net Margin $2,710 $4,006 $7,710 $11,175 $3,089 $6,600 $0 $0 $35,290 18.5% $5,310 $29,980 $4,112 $11,897 $4,890 $182 $8,899 2.8% 15.7% 2.2% 6.2% 2.6% 0.1% 4.7% (Product Name:) Don $18,170 Drum $24,445 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $1,701 $7,433 $122 $9,255 Contribution Margin Sales 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 straight-line 15-year 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. Write-offs 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. Annual Report Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1277342&simid=C59... 5/9/2016