Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Chester's balance sheet has $114,186,000 in equity. Further, the company is expecting $3,000,000 in net income next year. Assuming no dividends are paid and

The Chester's balance sheet has $114,186,000 in equity. Further, the company is expecting $3,000,000 in net income next year. Assuming no dividends are paid and no stock is issued, what would their Book Value be next year?
Select: 1
$35.40
$36.33
$78.60

$18.01

image text in transcribed COMP-XM INQUIRER 1 of 25 Page Page Page Page 1 Front Page 2 Stocks & Bonds 3 Financial Summ ary 4 Production Analysis Annual Report Andrews http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Page 5 Page 6 Page 7 Page 8 Thrift Segment Analysis Core Segment Analysis Nano Segm ent Analysis Elite Segm ent Analys is Annual Report Baldwin Page 9 Market Share Page 10 Perceptual Map Page 11 HR/TQM Report Annual Report Chester Annual Report Digby PRINT 7/29/2015 8:54 AM COMP-XM INQUIRER 2 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top " Round: 4 Dec. 31, 2018 Mesha Gunter Student: Mesha Gunter Andrews Mesha Gunter 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 4.6% 1.13 5.2% 1.7 8.7% $0 $168,147,857 $17,464,126 $7,744,527 $14,211,759 9.4% 28.8% Baldwin 8.3% 0.82 6.8% 2.4 16.1% $0 $182,529,896 $39,128,397 $15,145,317 $24,424,264 8.6% 42.1% Chester 4.8% 0.78 3.7% 2.2 8.2% $0 $197,175,375 $31,406,898 $9,410,274 $16,290,429 11.1% 39.2% Digby 16.0% 1.22 19.5% 1.7 33.2% $0 $219,611,211 $62,329,612 $35,077,626 $88,551,919 6.4% 42.8% Page 1 7/29/2015 8:54 AM COMP-XM INQUIRER 3 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Round: 4 Stocks & Bonds Mesha Gunter December 31 , 2018 Stock Market Summary Company Andrews Baldwin Chester Digby Close $58.06 $47.47 $43.85 $146.04 Change $12.59 $17.82 $10.52 $42.98 Shares 2,169,828 3,334,514 3,225,518 1,897,676 MarketCap ($M) $126 $158 $141 $277 Book Value $41.03 $28.15 $35.40 $55.75 EPS $3.57 $4.54 $2.92 $18.48 Dividend $0.12 $3.72 $0.00 $12.47 Yield 0.2% 7.8% 0.0% 8.5% P/E 16.3 10.4 15.0 7.9 Bond Market Summary Company Series# Face Yield Close$ S&P 11.2S2021 11.9S2022 10.1S2026 11.9S2027 11.7S2028 $8,837,000 $7,072,000 $22,000,000 $4,000,000 $4,000,000 11.5% 12.0% 11.3% 12.1% 12.0% 97.61 99.09 89.64 98.41 97.20 BBB BBB BBB BBB BBB 12.5S2022 12.5S2023 12.5S2024 12.9S2025 13.4S2026 14.2S2027 $13,945,356 $7,975,862 $9,473,322 $14,397,660 $34,636,089 $7,929,115 13.1% 13.2% 13.3% 13.5% 13.8% 14.1% 95.63 94.85 94.17 95.28 97.22 100.99 CC CC CC CC CC CC 12.4S2022 11.9S2024 12.6S2025 13.1S2026 13.8S2027 $968,187 $15,600,633 $17,795,619 $36,340,941 $25,329,842 12.9% 12.9% 13.3% 13.5% 13.8% 95.90 92.57 94.82 96.73 100.00 CCC CCC CCC CCC CCC 11.2S2024 11.5S2025 11.6S2026 12.6S2027 $2,883,930 $1,376,019 $20,220,187 $13,646,449 11.7% 11.9% 12.0% 12.4% 95.52 96.38 96.56 101.58 BBB BBB BBB BBB Andrews Baldwin Chester Digby Next Year's Prime Rate 9.00% COMP-XM INQUIRER Page 2 7/29/2015 8:54 AM COMP-XM INQUIRER 4 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Financial Summary Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustm ent for non-cash item s: Depreciation Extraordinary gains/loss es/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations Cash flows from investing activities Plant im provements (net) Cash flows from financing activities Dividends paid Sales of comm on stock Purchase of com mon stock Cash from long term debt issued Early retirem ent of long term debt Retirem ent of current debt Cash from current debt borrowing Cash from emergency loan Net cash from financing activities Round: 4 Decem ber 31, 2018 Mes ha Gunter Andrews Baldwin Chester Digby $7,745 $15,145 $9,410 $35,078 $8,961 $0 $17,087 ($794) $18,630 ($852) $11,411 ($194) $1,533 ($25,517) ($563) ($7,841) ($924) $3,135 ($1,537) $32,112 ($388) $2,750 ($1,365) $28,186 $377 ($3,351) ($2,192) $41,127 $0 $0 $0 $0 ($260) $2,000 ($2,000) $4,000 $0 ($3,000) $3,000 $0 ($12,407) $0 $0 $0 ($10,344) ($31,290) $30,674 $0 $0 $2,399 $0 $0 ($12,646) ($29,275) $33,814 $0 ($23,663) $0 ($3,957) $0 ($5,099) ($21,619) $25,627 $0 $3,740 ($23,366) ($5,708) ($28,710) ($4,101) $8,746 $22,478 $12,417 Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $962 $13,820 $49,977 $64,759 Baldwin $51,774 $15,002 $10,595 $77,371 Chester $51,210 $16,206 $14,534 $81,950 Digby $35,511 $18,050 $27,770 $81,332 Plant and equipm ent Accum ulated Depreciation Total Fixed Assets $134,418 ($49,792) $84,626 $256,300 ($112,442) $143,858 $279,454 ($107,887) $171,567 $171,160 ($72,632) $98,528 Total Assets $149,386 $221,229 $253,518 $179,860 Accounts Payable Current Debt Long Term Debt Total Liabilities $11,447 $3,000 $45,909 $60,356 $8,326 $30,674 $88,357 $127,358 $9,482 $33,814 $96,035 $139,331 $10,319 $25,627 $38,127 $74,073 Com mon Stock Retained Earnings Total Equity $18,136 $70,894 $89,029 $51,822 $42,049 $93,871 $59,110 $55,076 $114,186 $12,113 $93,674 $105,787 Total Liabilities & Owners' Equity $149,386 $221,229 $253,518 $179,860 Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Depreciation SGA (R&D, Prom o, Sales, Adm in) Other (Fees, Writeoffs, TQM, Bonuses ) EBIT Interest (Short term , Long term) Taxes Profit Sharing Net Profit Andrews $168,148 $119,758 $8,961 $15,834 $6,130 $17,464 $5,306 $4,255 $158 $7,745 Baldwin $182,530 $105,710 $17,087 $15,743 $4,861 $39,128 $15,352 $8,322 $309 $15,145 Chester $197,175 $119,860 $18,630 $21,820 $5,458 $31,407 $16,634 $5,170 $192 $9,410 Digby $219,611 $125,533 $11,411 $14,146 $6,191 $62,330 $7,263 $19,273 $716 $35,078 Net change in cash position COMP-XM INQUIRER Page 3 7/29/2015 8:54 AM COMP-XM INQUIRER 5 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Production Analysis Round: 4 Decem ber 31, 2018 Mesha Gunter Production Information Name Prim ary Segm ent Units Unit Sold Inven tory Revis ion Date Age Dec.31 MTBF Pfmn Coord Size Coord Material Price Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Auto mation Capacity Next Next Round Round Plant Utiliz. Ark Ant Ace Awe Ape Nano Elite Thrift Elite 0 1,330 1,331 1,305 1,264 0 663 270 720 735 5/21/2015 7/29/2018 7/15/2018 9/8/2018 6/7/2018 4.9 1.4 1.4 1.6 1.1 16000 22000 26000 18000 24000 9.5 14.4 17.7 9.8 16.5 10.5 2.8 5.5 10.2 6.6 $0.00 $36.50 $38.50 $18.50 $35.00 $0.00 $13.12 $14.50 $7.55 $13.10 $0.00 $10.48 $11.39 $5.69 $10.84 0% 31% 31% 24% 26% 0% 33% 15% 15% 49% 1.0 4.0 3.0 7.0 4.0 1 1,228 1,300 1,380 1,200 0% 132% 114% 114% 148% Bit Bolt Best Brat Thrift Thrift Core Core 2,067 2,097 2,542 2,464 175 201 217 316 6/10/2018 6/10/2018 12/14/2018 12/14/2018 2.6 2.6 1.6 1.6 17000 17000 18000 20000 9.6 9.8 12.3 13.0 10.4 10.2 7.0 7.5 $15.00 $15.00 $23.00 $25.00 $6.69 $6.82 $9.03 $9.64 $1.44 $1.36 $4.77 $4.59 45% 44% 40% 42% 35% 14% 100% 67% 10.0 10.0 8.0 8.0 1,550 1,750 1,250 1,500 134% 113% 198% 165% City Cozy Cute Crimp Cake Cedar Thrift Thrift Nano Elite Core Core 1,405 1,710 1,495 826 1,906 2,044 174 263 224 240 191 10 12/20/2017 12/7/2015 12/21/2018 12/21/2018 12/14/2018 12/14/2018 3.2 4.1 1.0 1.0 1.0 1.0 14000 16000 18000 20000 16000 16000 9.3 10.2 14.4 17.8 12.2 11.9 10.7 9.8 2.6 5.4 7.6 8.0 $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.27 $5.58 $4.93 $4.52 $4.58 49% 45% 36% 46% 31% 36% 0% 6% 38% 0% 87% 100% 10.0 10.0 7.0 7.0 8.0 8.0 1,250 1,599 1,049 999 1,099 1,037 99% 105% 137% 84% 185% 198% Dim Dome Dug Drat Nano Elite Nano Elite 2,027 1,348 1,527 1,308 434 279 350 348 9/13/2018 8/21/2018 8/13/2018 8/21/2018 1.3 1.6 1.4 1.3 23000 25000 23000 25000 15.1 18.2 15.5 18.0 2.4 4.9 2.1 4.6 $34.00 $34.00 $37.00 $37.00 $13.04 $13.82 $13.28 $13.83 $6.55 $6.26 $5.76 $5.34 41% 39% 46% 45% 88% 56% 19% 0% 7.0 7.0 7.0 7.0 1,250 900 1,300 1,450 186% 154% 118% 85% COMP-XM INQUIRER Page 4 7/29/2015 8:54 AM COMP-XM INQUIRER 6 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Thrift Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segm ent % of Total Industry Mesha Gunter Thrift Statistics 7,748 7,748 25.8% Next Year's Segm ent Growth Rate 11.0% Thrift Customer Buying Criteria 1. 2. 3. 4. Expectations $14.00 - 26.00 MTBF 14000-20000 Pfm n 9.3 Size 10.7 Ideal Age = 3.0 Price Reliability Ideal Position Age Round: 4 Decem ber 31, 2018 Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Name Bit Bolt City Awe Cozy Cedar Cake Best Market Share 26% 25% 17% 14% 13% 3% 1% 0% Units Sold to Seg 1,976 1,956 1,352 1,082 1,041 228 110 4 COMP-XM INQUIRER Revision Date Stock Out 6/10/2018 6/10/2018 12/20/2017 9/8/2018 12/7/2015 12/14/2018 12/14/2018 12/14/2018 Pfm n Coord 9.6 9.8 9.3 9.8 10.2 11.9 12.2 12.3 Size Coord 10.4 10.2 10.7 10.2 9.8 8.0 7.6 7.0 List Price $15.00 $15.00 $15.00 $18.50 $17.00 $20.00 $19.00 $23.00 MTBF 17000 17000 14000 18000 16000 16000 16000 18000 Age Dec.31 2.65 2.60 3.25 1.61 4.11 0.96 0.96 1.56 Promo Cus t. AwareBudget ness $1,300 83% $1,300 83% $1,200 72% $1,300 81% $1,200 72% $1,200 62% $1,200 67% $1,300 83% Sales Cust. Acces sBudget ibility $1,600 83% $1,600 83% $1,000 78% $1,350 42% $1,000 78% $900 78% $900 78% $1,400 83% Dec. Cust. Survey 69 67 46 34 36 2 0 0 Page 5 7/29/2015 8:54 AM COMP-XM INQUIRER 7 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Core Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segm ent % of Total Industry Mesha Gunter Core Statistics 9,781 9,781 32.6% Next Year's Segm ent Growth Rate 10.0% Core Customer Buying Criteria 1. 2. 3. 4. Expectations $20.00 - 32.00 Ideal Age = 2.0 MTBF 16000-22000 Pfm n 12.6 Size 7.4 Price Age Reliability Ideal Position Round: 4 Decem ber 31, 2018 Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Best Brat Cedar Cake Cozy Awe Bolt Bit City Ape Market Share 26% 25% 19% 18% 7% 2% 1% 1% 1% 0% Units Sold to Seg 2,534 2,456 1,816 1,796 669 223 141 91 53 3 COMP-XM INQUIRER Revision Date Stock Out 12/14/2018 12/14/2018 12/14/2018 12/14/2018 12/7/2015 9/8/2018 6/10/2018 6/10/2018 12/20/2017 6/7/2018 Pfm n Coord 12.3 13.0 11.9 12.2 10.2 9.8 9.8 9.6 9.3 16.5 Size Coord 7.0 7.5 8.0 7.6 9.8 10.2 10.2 10.4 10.7 6.6 List Price $23.00 $25.00 $20.00 $19.00 $17.00 $18.50 $15.00 $15.00 $15.00 $35.00 MTBF 18000 20000 16000 16000 16000 18000 17000 17000 14000 24000 Age Dec.31 1.56 1.57 0.96 0.96 4.11 1.61 2.60 2.65 3.25 1.14 Promo Cus t. AwareBudget ness $1,300 83% $1,300 83% $1,200 62% $1,200 67% $1,200 72% $1,300 81% $1,300 83% $1,300 83% $1,200 72% $1,500 77% Sales Cust. Acces sBudget ibility $1,400 81% $1,400 81% $900 73% $900 73% $1,000 73% $1,350 20% $1,600 81% $1,600 81% $1,000 73% $1,050 20% Dec. Cust. Survey 53 52 39 37 10 10 3 2 0 0 Page 6 7/29/2015 8:54 AM COMP-XM INQUIRER 8 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Nano Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segm ent % of Total Industry Mes ha Gunter Nano Statistics 6,166 6,166 20.6% Next Year's Segm ent Growth Rate 14.0% Nano Customer Buying Criteria 1. 2. 3. 4. Expectations Pfm n 14.5 Size 2.3 $28.00 - 40.00 Ideal Age = 1.0 MTBF 18000-24000 Ideal Position Price Age Reliability Round: 4 Decem ber 31, 2018 Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name Dim Dug Cute Ant Ape Ace Drat Best Brat Market Share 30% 24% 24% 20% 1% 0% 0% 0% 0% Units Sold to Seg 1,866 1,482 1,481 1,238 57 18 18 5 3 COMP-XM INQUIRER Revision Date Stock Out 9/13/2018 8/13/2018 12/21/2018 7/29/2018 6/7/2018 7/15/2018 8/21/2018 12/14/2018 12/14/2018 Pfm n Coord 15.1 15.5 14.4 14.4 16.5 17.7 18.0 12.3 13.0 Size Coord 2.4 2.1 2.6 2.8 6.6 5.5 4.6 7.0 7.5 List Price $34.00 $37.00 $28.00 $36.50 $35.00 $38.50 $37.00 $23.00 $25.00 MTBF 23000 23000 18000 22000 24000 26000 25000 18000 20000 Age Dec.31 1.27 1.36 1.02 1.39 1.14 1.43 1.35 1.56 1.57 Promo Cus t. AwareBudget ness $1,400 92% $1,400 92% $1,200 73% $1,300 88% $1,500 77% $1,500 96% $1,400 91% $1,300 83% $1,300 83% Sales Cust. Acces sBudget ibility $1,100 80% $1,000 80% $2,400 74% $1,050 56% $1,050 56% $1,150 56% $1,000 80% $1,400 12% $1,400 12% Dec. Cust. Survey 66 51 56 44 0 0 0 0 0 Page 7 7/29/2015 8:54 AM COMP-XM INQUIRER 9 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Elite Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segm ent % of Total Industry Mesha Gunter Elite Statistics 6,299 6,299 21.0% Next Year's Segm ent Growth Rate 16.0% Elite Customer Buying Criteria 1. 2. 3. 4. Expectations Ideal Age = 0.0 $30.00 - 42.00 Pfm n 17.7 Size 5.5 MTBF 20000-26000 Age Price Ideal Position Reliability Round: 4 Decem ber 31, 2018 Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Dome Ace Drat Ape Crimp Dim Ant Dug Cute Brat Market Share 21% 21% 20% 19% 13% 3% 1% 1% 0% 0% Units Sold to Seg 1,348 1,313 1,290 1,205 826 161 92 45 14 5 COMP-XM INQUIRER Revision Date Stock Out 8/21/2018 7/15/2018 8/21/2018 6/7/2018 12/21/2018 9/13/2018 7/29/2018 8/13/2018 12/21/2018 12/14/2018 Pfm n Coord 18.2 17.7 18.0 16.5 17.8 15.1 14.4 15.5 14.4 13.0 Size Coord 4.9 5.5 4.6 6.6 5.4 2.4 2.8 2.1 2.6 7.5 List Price $34.00 $38.50 $37.00 $35.00 $34.00 $34.00 $36.50 $37.00 $28.00 $25.00 MTBF 25000 26000 25000 24000 20000 23000 22000 23000 18000 20000 Age Dec.31 1.63 1.43 1.35 1.14 1.03 1.27 1.39 1.36 1.02 1.57 Promo Cus t. AwareBudget ness $1,400 92% $1,500 96% $1,400 91% $1,500 77% $1,200 72% $1,400 92% $1,300 88% $1,400 92% $1,200 73% $1,300 83% Sales Cust. Acces sBudget ibility $1,000 87% $1,150 79% $1,000 87% $1,050 79% $2,400 74% $1,100 87% $1,050 79% $1,000 87% $2,400 74% $1,400 5% Dec. Cust. Survey 54 51 50 41 37 0 0 0 0 0 Page 8 7/29/2015 8:54 AM COMP-XM INQUIRER 10 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Market Share Report Actual Market Share in Units Potential Market Share in Units Thrift Industry Unit Sales % of Market Ant Ace Awe Ape Total Core Nano Elite Total 7,748 9,781 6,166 6,299 29,994 25.8% 32.6% 20.6% 21.0% 100.0% 20.1% 0.3% 1.5% 20.8% 19.1% 41.4% 4.4% 4.4% 4.3% 4.2% 17.4% Ant Ace Awe Ape Total 0.1% 0.1% 6.9% 7.0% 8.5% 8.2% 30.6% Bit Bolt Best Brat Total City Cozy Cute Crimp Cake Cedar Total Dim Dome Dug Drat Total 14.0% 14.0% 2.3% 0.0% 2.3% 0.9% 21.3% 0.1% 0.1% 0.1% Bit Bolt Best Brat Total 25.5% 25.2% 0.1% 50.8% 0.9% 1.4% 25.9% 25.1% 53.4% City Cozy Cute Crimp Cake Cedar Total 17.4% 13.4% 0.5% 6.8% 24.0% 1.4% 2.9% 35.3% Dim Dome Dug Drat Total COMP-XM INQUIRER Round: 4 Decem ber 31, 2018 Mesha Gunter 18.4% 18.6% 44.3% 0.2% 13.1% 24.0% 13.3% 4.7% 5.7% 5.0% 2.8% 6.3% 6.8% 31.3% 30.3% 2.6% 21.4% 0.7% 20.5% 45.1% 6.8% 4.5% 5.1% 4.4% 20.7% 24.0% 0.3% 54.6% Thrift Units Demanded % of Market Core Nano Elite Total 7,748 9,781 6,166 6,299 29,994 25.8% 32.6% 20.6% 21.0% 100.0% 20.1% 0.3% 1.5% 20.8% 0.9% 21.3% 19.1% 41.4% 4.4% 4.4% 4.3% 4.2% 17.4% 0.1% 0.1% 6.9% 7.0% 8.4% 8.1% 30.4% 13.9% 2.3% 13.9% 2.3% 25.5% 25.2% 0.1% 50.7% 0.9% 1.4% 25.7% 24.9% 53.0% 17.4% 13.4% 0.5% 6.8% 0.1% 0.1% 24.0% 1.4% 3.1% 35.3% 18.2% 19.2% 44.8% 0.2% 13.1% 24.0% 13.3% 30.3% 2.6% 21.4% 0.7% 20.5% 45.1% 24.0% 0.3% 54.6% 4.7% 5.7% 5.0% 2.8% 6.3% 7.1% 31.5% 6.8% 4.5% 5.1% 4.4% 20.7% Page 9 7/29/2015 8:54 AM COMP-XM INQUIRER 11 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Perceptual Map Round: 4 Decem ber 31, 2018 Mesha Gunter Perceptual Map for All Segments Andrews Name Ark Ant Ace Awe Ape Pfmn 9.5 14.4 17.7 9.8 16.5 Name Dim Dome Dug Drat Size 10.5 2.8 5.5 10.2 6.6 Pfmn 15.1 18.2 15.5 18.0 Baldwin Revised 5/21/2015 7/29/2018 7/15/2018 9/8/2018 6/7/2018 Name Bit Bolt Best Brat Pfmn 9.6 9.8 12.3 13.0 Size 10.4 10.2 7.0 7.5 Chester Revised 6/10/2018 6/10/2018 12/14/2018 12/14/2018 Name City Cozy Cute Crimp Cake Cedar Pfmn 9.3 10.2 14.4 17.8 12.2 11.9 Size 10.7 9.8 2.6 5.4 7.6 8.0 Revised 12/20/2017 12/7/2015 12/21/2018 12/21/2018 12/14/2018 12/14/2018 Digby COMP-XM INQUIRER Size 2.4 4.9 2.1 4.6 Revised 9/13/2018 8/21/2018 8/13/2018 8/21/2018 Page 10 7/29/2015 8:54 AM COMP-XM INQUIRER 12 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top HR/TQM Report Mesha Gunter Round: 4 Decem ber 31, 2018 HUMAN RESOURCES SUMMARY Andrews Baldwin Chester Digby Needed Complem ent 909 386 485 542 Com plem ent 910 386 485 542 1st Shift Complem ent 2nd Shift Com plement 708 202 233 153 333 152 389 153 Overtime% 0.0% 0.0% 0.0% 0.0% Turnover Rate New Em ployees 6.4% 175 8.0% 31 6.0% 29 10.0% 54 Separated Em ployees Recruiting Spend Training Hours 0 94 123 47 $5,000 $2,500 $5,000 $0 80 40 80 0 Productivity Index 116.7% 118.3% 130.3% 100.0% Recruiting Cost $1,050 $108 $175 $54 $0 $472 $616 $233 Training Cost $1,456 $309 $776 $0 Total HR Admin Cost $2,506 $888 $1,567 $287 Labor Contract Next Year Wages Separation Cost $31.04 $31.04 $31.04 $31.04 Benefits 2,500 2,500 2,500 2,500 Profit Sharing 2.0% 2.0% 2.0% 2.0% Annual Raise 5.0% 5.0% 5.0% 5.0% 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 Andrews Baldwin Chester Digby Process Mgt Budgets Last Year CPI System s Vendor/JIT Quality Initiative Training Channel Support System s Concurrent Engineering UNEP Green Program s $1,000 $1,000 $500 $1,000 $0 $200 $1,250 $1,250 $0 $1,500 $0 $0 $1,500 $1,500 $0 $0 $0 $1,500 $0 $0 $1,250 $1,250 $1,250 $0 TQM Budgets Last Year Benchm arking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sus tainability Initiatives Total Expenditures $900 $500 $500 $200 $5,800 $0 $0 $750 $750 $5,500 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 4.36% 3.51% 37.22% 26.43% 8.17% 10.20% 4.39% 0.00% 34.91% 10.57% 6.07% 0.28% 0.00% 60.02% 2.35% 9.48% 14.00% 40.01% 0.00% 12.78% Cumulative Impacts Material Cost Reduction Labor Cos t Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase COMP-XM INQUIRER Page 11 7/29/2015 8:54 AM COMP-XM INQUIRER 13 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... PRINT Annual Report 7/29/2015 8:54 AM COMP-XM INQUIRER 14 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Andrews Round: 8 Dec. 31, 2018 C59559 Balance Sheet DEFINITIONS: Common Size: The comm on size column sim ply represents each item as a percentage of total as sets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and paym ent of your products. Inventories: The current value of your inventory across all products. A zero indicates your com pany s tocked out. Unmet dem and would, of course, fall to your com petitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accum ulated depreciation from your plant. Accts Payable: What the com pany currently owes suppliers for m aterials and services . Current Debt: The debt the company is obligated to pay during the next year of operations . It includes em ergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The com pany's long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the com pany. Retained Earnings: The profits that the company chose to keep ins tead of paying to shareholders as dividends. ASSETS Cash Accounts Receivable Inventory 2018 Comm on Size 0.6% 9.3% 33.5% $962 $13,820 $49,977 Total Current Assets $64,759 Plant & Equipment Accumulated Depreciation 2017 $5,063 $13,257 $24,461 Total Fixed Assets 43.4% $42,781 90.0% -33.3% $134,418 ($49,792) $134,418 ($40,830) $84,626 56.6% $93,588 $149,386 Total Assets 100.0% $136,369 7.7% 2.0% 30.7% $9,914 $3,000 $41,909 40.4% $54,823 12.1% 47.5% $16,581 $64,965 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $11,447 $3,000 $45,909 Total Liabilities Common Stock Retained Earnings $60,356 $18,136 $70,894 Total Equity $89,030 59.6% $81,546 $149,386 Total Liab. & O. Equity 100.0% $136,369 Cash Flow Statement The Cash Flow Statement exam ines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cas h Flow Statem ent is an excellent tool for diagnos ing em ergency loans. When negative cash flows exceed positives, you are forced to s eek emergency funding. For exam ple, 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 m uch unexpected inventory could outstrip your inflows, exhaus t your starting cas h and force you to beg for m oney to keep your com pany afloat. Cash Flows from Operating Activities: Net Incom e (Loss ) Depreciation Extraordinary gains/losses /writeoffs Accounts Payable Inventory Accounts Receivable Net cas h from operations Cash Flows from Investing Activities: Plant Improvem ents Cash Flows from Financing Activities: Dividends Paid Sales of Comm on Stock Purchase of Com mon Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cas h from financing activities Net change in cash position Closing cash position Annual Report 2018 $7,745 $8,961 $0 $1,533 ($25,517) ($563) 2017 $6,595 $8,961 $0 $3,174 ($9,085) ($3,178) ($7,841) $6,468 $0 ($36,200) ($260) $2,000 ($2,000) $4,000 $0 $0 ($260) $3,500 $0 $4,000 $0 ($5,513) $3,740 ($4,101) $962 $1,726 ($28,006) $5,063 Page 1 7/29/2015 8:54 AM COMP-XM INQUIRER 15 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 7/29/2015 8:54 AM COMP-XM INQUIRER 16 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Andrews Round: 8 Dec. 31, 2018 C59559 2018 Income Statement Ace Awe Ape Na Ark Ant Na Na Sales $0 $48,531 $51,226 $24,134 $44,257 $0 $0 $0 2018 Total $168,148 Comm on Size 100.0% Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $0 $0 $0 $0 $13,987 $17,418 $1,878 $33,283 $15,242 $19,221 $841 $35,304 $7,728 $9,587 $1,146 $18,461 $13,847 $16,732 $2,132 $32,711 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $50,804 $62,957 $5,997 $119,758 30.2% 37.4% 3.6% 71.2% Contribution Margin $0 $15,248 $15,922 $5,673 $11,546 $0 $0 $0 $48,389 28.8% Period Costs: Depreciation SG&A: R&D Promotions Sales Adm in Total Period $3 $0 $0 $0 $0 $3 $1,801 $583 $1,300 $1,050 $973 $5,707 $1,880 $544 $1,500 $1,150 $1,027 $6,101 $3,517 $697 $1,300 $1,350 $484 $7,348 $1,760 $438 $1,500 $1,050 $888 $5,636 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $8,961 $2,262 $5,600 $4,600 $3,372 $24,795 5.3% 1.3% 3.3% 2.7% 2.0% 14.7% ($3) $9,541 $9,821 ($1,675) $5,910 $0 $0 $0 $23,594 14.0% $6,130 $17,464 $309 $4,997 $4,255 $158 $7,745 3.6% 10.4% 0.2% 3.0% 2.5% 0.1% 4.6% (Product Nam e:) Net Margin Definitions: Sales: Unit sales tim es 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 s traight-line 15-year depreciation of plant value. R&D Costs: R&D departm ent expenditures for each product. Admin: Adm inistration overhead is estim ated at 1.5% of sales. Promotions: The prom otion 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 firm s to issue new s tocks or bonds plus consulting fees your instructor m ight assess . Write-offs include the loss you m ight experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative am ount, then you actually m ade money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expens e based on last year's current debt, including short term debt, long term notes that have become due, and em ergency loans. Long Term Interest: Interest paid on outs tanding bonds. Taxes: Incom e tax based upon a 35% tax rate. Profit Sharing: Profits shared with em ployees under the labor contract. Net Profit: EBIT m inus interest, taxes, and profit sharing. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT Annual Report 7/29/2015 8:54 AM COMP-XM INQUIRER 17 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Baldwin Round: 8 Dec. 31, 2018 C59559 Balance Sheet DEFINITIONS: Common Size: The comm on size column sim ply represents each item as a percentage of total as sets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and paym ent of your products. Inventories: The current value of your inventory across all products. A zero indicates your com pany s tocked out. Unmet dem and would, of course, fall to your com petitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accum ulated depreciation from your plant. Accts Payable: What the com pany currently owes suppliers for m aterials and services . Current Debt: The debt the company is obligated to pay during the next year of operations . It includes em ergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The com pany's long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the com pany. Retained Earnings: The profits that the company chose to keep ins tead of paying to shareholders as dividends. ASSETS Cash Accounts Receivable Inventory 2018 Comm on Size 23.4% 6.8% 4.8% $51,774 $15,002 $10,595 Total Current Assets $77,371 Plant & Equipment Accumulated Depreciation 2017 $43,028 $13,466 $13,730 35.0% $70,224 115.9% -50.8% $256,300 ($112,442) $256,300 ($95,356) Total Fixed Assets $143,858 65.0% $160,944 Total Assets $221,229 100.0% $231,168 3.8% 13.9% 39.9% $9,251 $31,290 $99,495 57.6% $140,036 23.4% 19.0% $51,822 $39,310 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $8,326 $30,674 $88,357 Total Liabilities Common Stock Retained Earnings $127,357 $51,822 $42,049 Total Equity $93,871 42.4% $91,132 $221,229 Total Liab. & O. Equity 100.0% $231,168 Cash Flow Statement The Cash Flow Statement exam ines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cas h Flow Statem ent is an excellent tool for diagnos ing em ergency loans. When negative cash flows exceed positives, you are forced to s eek emergency funding. For exam ple, 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 m uch unexpected inventory could outstrip your inflows, exhaus t your starting cas h and force you to beg for m oney to keep your com pany afloat. Cash Flows from Operating Activities: Net Incom e (Loss ) Depreciation Extraordinary gains/losses /writeoffs Accounts Payable Inventory Accounts Receivable Net cas h from operations Cash Flows from Investing Activities: Plant Improvem ents Cash Flows from Financing Activities: Dividends Paid Sales of Comm on Stock Purchase of Com mon Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cas h from financing activities Net change in cash position Closing cash position Annual Report 2018 $15,145 $17,087 ($794) ($924) $3,135 ($1,537) 2017 $3,286 $17,087 $0 $765 ($9,464) ($264) $32,112 $11,410 $0 ($28,800) ($12,407) $0 $0 $0 ($10,344) ($616) $0 $12,878 $0 $7,929 $0 ($12,927) ($23,366) $8,746 $51,774 $7,881 ($9,510) $43,028 Page 1 7/29/2015 8:54 AM COMP-XM INQUIRER 18 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 7/29/2015 8:54 AM COMP-XM INQUIRER 19 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Baldwin Round: 8 Dec. 31, 2018 C59559 2018 Income Statement Best Brat Na Na Bit Bolt Na Na Sales $31,008 $31,459 $58,472 $61,592 $0 $0 $0 $0 2018 Total $182,530 Comm on Size 100.0% Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $3,217 $13,702 $172 $17,091 $3,323 $14,263 $202 $17,788 $12,113 $22,848 $359 $35,320 $11,308 $23,665 $539 $35,511 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,961 $74,478 $1,271 $105,710 16.4% 40.8% 0.7% 57.9% Contribution Margin $13,917 $13,671 $23,152 $26,080 $0 $0 $0 $0 $76,819 42.1% Period Costs: Depreciation SG&A: R&D Promotions Sales Adm in Total Period $4,753 $446 $1,300 $1,600 $292 $8,391 $5,367 $446 $1,300 $1,600 $296 $9,009 $3,167 $966 $1,300 $1,400 $551 $7,384 $3,800 $966 $1,300 $1,400 $580 $8,046 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,087 $2,824 $5,200 $6,000 $1,720 $32,830 9.4% 1.5% 2.8% 3.3% 0.9% 18.0% Net Margin $5,525 $4,662 $15,768 $18,034 $0 $0 $0 $0 $43,989 24.1% $4,861 $39,128 $3,804 $11,549 $8,322 $309 $15,145 2.7% 21.4% 2.1% 6.3% 4.6% 0.2% 8.3% (Product Nam e:) Definitions: Sales: Unit sales tim es 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 s traight-line 15-year depreciation of plant value. R&D Costs: R&D departm ent expenditures for each product. Admin: Adm inistration overhead is estim ated at 1.5% of sales. Promotions: The prom otion 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 firm s to issue new s tocks or bonds plus consulting fees your instructor m ight assess . Write-offs include the loss you m ight experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative am ount, then you actually m ade money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expens e based on last year's current debt, including short term debt, long term notes that have become due, and em ergency loans. Long Term Interest: Interest paid on outs tanding bonds. Taxes: Incom e tax based upon a 35% tax rate. Profit Sharing: Profits shared with em ployees under the labor contract. Net Profit: EBIT m inus interest, taxes, and profit sharing. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT Annual Report 7/29/2015 8:54 AM COMP-XM INQUIRER 20 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Chester Round: 8 Dec. 31, 2018 C59559 Balance Sheet DEFINITIONS: Common Size: The comm on size column sim ply represents each item as a percentage of total as sets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and paym ent of your products. Inventories: The current value of your inventory across all products. A zero indicates your com pany s tocked out. Unmet dem and would, of course, fall to your com petitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accum ulated depreciation from your plant. Accts Payable: What the com pany currently owes suppliers for m aterials and services . Current Debt: The debt the company is obligated to pay during the next year of operations . It includes em ergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The com pany's long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the com pany. Retained Earnings: The profits that the company chose to keep ins tead of paying to shareholders as dividends. ASSETS Cash Accounts Receivable Inventory 2018 Comm on Size 20.2% 6.4% 5.7% $51,210 $16,206 $14,534 Total Current Assets $81,950 Plant & Equipment Accumulated Depreciation 2017 $28,732 $14,842 $17,284 32.3% $60,858 110.2% -42.6% $279,454 ($107,887) $279,454 ($89,257) Total Fixed Assets $171,567 67.7% $190,197 Total Assets $253,518 100.0% $251,055 3.7% 13.3% 37.9% $9,870 $29,275 $109,532 55.0% $148,677 23.3% 21.7% $56,711 $45,666 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $9,482 $33,814 $96,035 Total Liabilities Common Stock Retained Earnings $139,331 $59,110 $55,076 Total Equity $114,186 45.0% $102,377 Total Liab. & O. Equity $253,518 100.0% $251,055 Cash Flow Statement The Cash Flow Statement exam ines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cas h Flow Statem ent is an excellent tool for diagnos ing em ergency loans. When negative cash flows exceed positives, you are forced to s eek emergency funding. For exam ple, 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 m uch unexpected inventory could outstrip your inflows, exhaus t your starting cas h and force you to beg for m oney to keep your com pany afloat. Cash Flows from Operating Activities: Net Incom e (Loss ) Depreciation Extraordinary gains/losses /writeoffs Accounts Payable Inventory Accounts Receivable Net cas h from operations Cash Flows from Investing Activities: Plant Improvem ents Cash Flows from Financing Activities: Dividends Paid Sales of Comm on Stock Purchase of Com mon Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cas h from financing activities Net change in cash position Closing cash position Annual Report 2018 $9,410 $18,630 ($852) ($388) $2,750 ($1,365) 2017 ($478) $18,630 $0 $1,519 ($6,441) ($2,319) $28,186 $10,912 $0 ($57,294) $0 $2,399 $0 $0 ($12,646) $4,539 $0 $20,196 $0 $25,330 $0 ($5,653) ($5,708) $22,478 $51,210 $39,873 ($6,510) $28,732 Page 1 7/29/2015 8:54 AM COMP-XM INQUIRER 21 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 7/29/2015 8:54 AM COMP-XM INQUIRER 22 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Chester Round: 8 Dec. 31, 2018 C59559 2018 Income Statement Cute Crimp Cake Cedar City Cozy Na Na Sales $21,079 $29,063 $41,860 $28,087 $36,213 $40,874 $0 $0 2018 Total $197,175 Comm on Size 100.0% Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $1,944 $8,600 $157 $10,700 $2,913 $12,854 $291 $16,058 $8,685 $17,498 $471 $26,654 $4,315 $10,369 $512 $15,196 $8,691 $16,136 $299 $25,126 $9,361 $16,750 $15 $26,126 $0 $0 $0 $0 $0 $0 $0 $0 $35,908 $82,208 $1,744 $119,860 18.2% 41.7% 0.9% 60.8% Contribution Margin $10,378 $13,005 $15,206 $12,890 $11,087 $14,748 $0 $0 $77,315 39.2% Period Costs: Depreciation SG&A: R&D Promotions Sales Adm in Total Period $3,833 $0 $1,200 $1,000 $226 $6,260 $4,904 $0 $1,200 $1,000 $312 $7,416 $2,378 $985 $1,200 $2,400 $450 $7,412 $2,264 $985 $1,200 $2,400 $302 $7,151 $2,784 $966 $1,200 $900 $389 $6,239 $2,467 $966 $1,200 $900 $439 $5,972 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $18,630 $3,902 $7,200 $8,600 $2,118 $40,450 9.4% 2.0% 3.7% 4.4% 1.1% 20.5% Net Margin $4,119 $5,589 $7,794 $5,740 $4,848 $8,776 $0 $0 $36,865 18.7% $5,458 $31,407 $4,159 $12,475 $5,170 $192 $9,410 2.8% 15.9% 2.1% 6.3% 2.6% 0.1% 4.8% (Product Nam e:) Definitions: Sales: Unit sales tim es 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 s traight-line 15-year depreciation of plant value. R&D Costs: R&D departm ent expenditures for each product. Admin: Adm inistration overhead is estim ated at 1.5% of sales. Promotions: The prom otion 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 firm s to issue new s tocks or bonds plus consulting fees your instructor m ight assess . Write-offs include the loss you m ight experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative am ount, then you actually m ade money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expens e based on last year's current debt, including short term debt, long term notes that have become due, and em ergency loans. Long Term Interest: Interest paid on outs tanding bonds. Taxes: Incom e tax based upon a 35% tax rate. Profit Sharing: Profits shared with em ployees under the labor contract. Net Profit: EBIT m inus interest, taxes, and profit sharing. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT Annual Report 7/29/2015 8:54 AM COMP-XM INQUIRER 23 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Digby Round: 8 Dec. 31, 2018 C59559 Balance Sheet DEFINITIONS: Common Size: The comm on size column sim ply represents each item as a percentage of total as sets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and paym ent of your products. Inventories: The current value of your inventory across all products. A zero indicates your com pany s tocked out. Unmet dem and would, of course, fall to your com petitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accum ulated depreciation from your plant. Accts Payable: What the com pany currently owes suppliers for m aterials and services . Current Debt: The debt the company is obligated to pay during the next year of operations . It includes em ergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The com pany's long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the com pany. Retained Earnings: The profits that the company chose to keep ins tead of paying to shareholders as dividends. ASSETS Cash Accounts Receivable Inventory 2018 Comm on Size 19.7% 10.0% 15.4% $35,511 $18,050 $27,770 Total Current Assets $81,331 Plant & Equipment Accumulated Depreciation 2017 $23,094 $15,858 $24,419 Total Fixed Assets 45.2% $63,371 95.2% -40.4% $171,160 ($72,632) $171,160 ($61,221) $98,528 54.8% $109,939 $179,860 Total Assets 100.0% $173,310 5.7% 14.2% 21.2% $9,943 $21,619 $43,420 41.2% $74,982 6.7% 52.1% $12,620 $85,708 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $10,319 $25,627 $38,127 Total Liabilities Common Stock Retained Earnings $74,073 $12,113 $93,674 Total Equity $105,787 58.8% $98,328 Total Liab. & O. Equity $179,860 100.0% $173,310 Cash Flow Statement The Cash Flow Statement exam ines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cas h Flow Statem ent is an excellent tool for diagnos ing em ergency loans. When negative cash flows exceed positives, you are forced to s eek emergency funding. For exam ple, 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 m uch unexpected inventory could outstrip your inflows, exhaus t your starting cas h and force you to beg for m oney to keep your com pany afloat. Cash Flows from Operating Activities: Net Incom e (Loss ) Depreciation Extraordinary gains/losses /writeoffs Accounts Payable Inventory Accounts Receivable Net cas h from operations Cash Flows from Investing Activities: Plant Improvem ents Cash Flows from Financing Activities: Dividends Paid Sales of Comm on Stock Purchase of Com mon Stock Cash from long term debt Retirement of long term debt Change in current debt (net) Net cas h from financing activities Net change in cash position Closing cash position Annual Report 2018 $35,078 $11,411 ($194) $377 ($3,351) ($2,192) 2017 $21,654 $11,411 $0 ($837) ($4,617) ($360) $41,127 $27,252 $0 ($43,300) ($23,663) $0 ($3,957) $0 ($5,099) $4,008 $0 $203 $0 $13,646 $0 ($9,437) ($28,710) $12,417 $35,511 $4,413 ($11,636) $23,094 Page 1 7/29/2015 8:54 AM COMP-XM INQUIRER 24 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 7/29/2015 8:54 AM COMP-XM INQUIRER 25 of 25 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Digby Round: 8 Dec. 31, 2018 C59559 2018 Income Statement Dug Drat Na Na Dim Dome Na Na Sales $68,907 $45,822 $56,489 $48,394 $0 $0 $0 $0 2018 Total $219,611 Comm on Size 100.0% Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $13,415 $26,047 $1,014 $40,476 $8,533 $18,681 $675 $27,890 $9,219 $20,434 $817 $30,469 $7,586 $18,285 $827 $26,698 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $38,754 $83,447 $3,332 $125,533 17.6% 38.0% 1.5% 57.2% Contribution Margin $28,431 $17,933 $26,019 $21,696 $0 $0 $0 $0 $94,078 42.8% $3,137 $710 $1,400 $1,100 $572 $6,919 $2,040 $645 $1,400 $1,000 $381 $5,465 $2,947 $623 $1,400 $1,000 $469 $6,439 $3,287 $645 $1,400 $1,000 $402 $6,734 $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,411 $2,622 $5,600 $4,100 $1,824 $25,557 5.2% 1.2% 2.5% 1.9% 0.8% 11.6% $21,511 $12,467 $19,580 $14,962 $0 $0 $0 $0 $68,521 31.2% $6,191 $62,330 $2,716 $4,546 $19,273 $716 $35,078 2.8% 28.4% 1.2% 2.1% 8.8% 0.3% 16.0% (Product Nam e:) Period Costs: Depreciation SG&A: R&D Promotions Sales Adm in Total Period Net Margin Definitions: Sales: Unit sales tim es 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 s traight-line 15-year depreciation of plant value. R&D Costs: R&D departm ent expenditures for each product. Admin: Adm inistration overhead is estim ated at 1.5% of sales. Promotions: The prom otion 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 firm s to issue new s tocks or bonds plus consulting fees your instructor m ight assess . Write-offs include the loss you m ight experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative am ount, then you actually m ade money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expens e based on last year's current debt, including short term debt, long term notes that have become due, and em ergency loans. Long Term Interest: Interest paid on outs tanding bonds. Taxes: Incom e tax based upon a 35% tax rate. Profit Sharing: Profits shared with em ployees under the labor contract. Net Profit: EBIT m inus interest, taxes, and profit sharing. Annual Report Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 7/29/2015 8:54 AM

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integrated Accounting For Windows

Authors: Dale A. Klooster, Warren Allen

6th Edition

0324664850, 9780324664850

More Books

Students also viewed these Accounting questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

4. What means will you use to achieve these values?

Answered: 1 week ago