Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In three years, assuming the competitive environment remains unchanged, how many units of Bell will Baldwin be selling in the Nano market segment? 638 560

In three years, assuming the competitive environment remains unchanged, how many units of Bell will Baldwin be selling in the Nano market segment?

  • 638

  • 560

  • 431

  • 715

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Round 0 Dec. 31 2019 Report COMP. X MB INQUIRER Andrews Baldwin Chester Digby Selected Financial Statistics Andrews Baldwin Chester Digby ROS 12.3% 9.2 5.7% B.6% Asset Tumover 132 1.28 0.91 0194 ROA 16.3% 11.8 8.15 8.1% Leverage (Assets/Equity 1.7 1.9 27 2.4 ROE 283 22.4% 13.8 19.2 SO SO 80 SO Emergency Loan Sales $183 290,917 $119.521.454 $131,509,005 $118,899, 130 ERIT 9.405 230 $21.50.617 $21,073,280 $23.774,069 Pronts 520,101,345 $11.052,967 57.459.277 $10.204.711 Cumulative Profit SO 50 $0 SO SOLA Sales 79 10.3% 11.236 0.7% 33,796 Contrib. Margin 34.1 333 38.8% Percent of Sales S Market Share 1254 Digby 22.3% 100 Andrews 30.6 Other SGA Depr Var Costs Profit 75 son Chester 247 Andrews Ch Baldwin 22.4 Markut Share information is provided on Page 7 COMP-XMO INQUIRER Page 1 Annual Report TOP Round 0 Dec. 31 2019 Annual Report Chester C59559 Balance Sheet ASSETS 2019 2018 Common Size Cash $31.900 22% $36,749 $10.809 78% $9,777 Accounts Receivable Inventory $10,003 73% $7,845 Total Current Assets $63.372 36.8% $54,371 Plant & fiquipment $142.000 08.6% $127.100 DEFINITIONS: Common Size: The Cormon size column sniply represents each item as a percentage of of assets for that year, Cash: Your end of year cash position Accounts Recolvable: Reichstag between delivery and payment of your products, inventories. The current value of your inventory across all products. A zero indicates your company locked ouUrmet demand wound of course, tak to your competitors Plant & Equipment: The curent value of your plant. Accum Deprec: The total oculated depreciation from your plant Acets Payable: What the company currently owes suppliers to materials and services Current Dote: The debt the companys obligated to pay during the next year of operations. It includes emergency on used to keep your company vend you run out of cash during the year Long Term Debt: The company's long term debt is in the form of bonds, and thus 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 instead of paying to Shareholders as dividends Accumulated Depreciation (551,265) 35.4% (541,738) Total Fixed Assets 301.835 63.2W $5,362 Total assets $145,007 100W $139,733 LIABILITIES & OWNERS' EQUITY Accounts Payable $7.283 5% $5.826 Current Dobit 529.231 20.2% $22,161 Long Term Debt $53,845 37.1% $51.904 500.350 623% $79.891 524690 17 $24,690 Total Liabilities Common Stock Ratained Earnings Total Equity Total Liab & Equity $29,950 20.7% $35,152 564,648 377 550 842 $145,007 100% $130,733 Cash Flow Statement Cash Flows from Operating Activities: 2019 2018 Notico (LSS) $10,427 The Cash Flow Statement is what happened in the Cash Account during the year. Cash ection was postive numbers and cash withdrawal negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When give showed posts you we forced to seek emergency ludne. For example, les we bed and you find your crying an abundance of es wenty, the report wo show the worse invertory Agregative cash flow too much unexpected inventory could use your wow chale your arting cash widforce you to be for money to keep your company to $7450 $9,827 $8.473 50 SO $1,457 (57) s7Ta Cash Flow Summary Chester (52.758) ($1.002) $14,653 (5562) Deprecation Extraordinary wossewwiders Accounts Payable Inventory Accounts Receivable Netcash from operations Net Cash Flows from investing Activities Plant improvements Cash Flows from Financing Activities Dividends paid Sales of Common Stock Purchase of Common Stock 20 $18,327 ($15.800) ($18.602) JOM ( (S. ($12.653) $0 SO 50 $0 59474 (57533) $7.070 $7.98 $0 Cash from long term del Retirement of long term det Change in current debit) Nel cash from financing wis Nel change in cash position Closing cash position 10 (55.250) (56.180) (63,642) (147) (56.445) $51.00 $30,700 Operations Investment Finance Chy. Cash Annual Report Page 1 TOP Round 0 Deci 31 2019 Annual Report Digby 2019 Income Statement Na Na Na Dug Deal Total Na Dino Dome Product Name Common Size '! $0 100% Sales $21.689 $34,898 $21.130 $0 50 5118.899 $41476 Variable Costs: Direct Labor $10,009 $4,401 20.43 $4,874 $4.326 $0 $0 SO $24.211 $9,177 $8,423 SO $12,102 $0 $0 $0 Direct Material $18,096 $47.798 40.2% $26 Inventory Carry $375 $26 $346 $0 $0 $0 $0 $772 0.6% $28,731 $13.952 513.095 $0 SO 0120 $0 $72,781 SO $17,003 $17505 57.737 $12,745 $8,041 SO SO SO SO $40.118 38.8% Total Vanabis Contribution Margin Period Costs: Depreciation $2.800 $2.507 $1,500 $1,387 SO $0 $8.293 TN R&D $1,000 5928 $857 $985 SO so SO $3,772 32% Promotions $950 $950 5950 5950 SO $0 sa so $3,800 32N Sales SE00 SO $0 $0 $0 $3,900 3.3% $1,000 $522 $1,000 5626 $1,300 $319 Admin $327 50 SO SO SO $1,794 1.8% Total Period $4 365 54213 $ SO SO $0 $21.50 18.1% $6,272 $11,323 56,110 $6,635 Not Margin $3,312 $3.228 $0 $0 50 $0 $24.6.80 20.7% Other $784 07 EBIT 523,774 20% Short Term Interest $2.64 2.3% Long Term interest 42% Taxes Definitions: Sales: Unil sales times list price Direct Labor: Labor costs incurred to produce the product that was sold, Inventory Camry Cost the cost o carry unsold goods in Inventory Depreciation Calolated on straightine 15-year depreciation of plant value RAD Costs: RAD department expenditures for each product. Admin: Administration overheads estimated at 1.8% of sales Promotions. The promotion budget for each product Sales: The sales force budoet for each product. Other Charges not included in other categones such as Fees, Wite Ofts, and TOM, The fees include money paid to wovestment bankers and brokerage tem to issue new stocks or bonds plus consulting for your instructor might assess Write otside the loss you might experience when you sell capacity or liquidata wontory as the result of minating a production line. If the amount appears as negative amount, then you chilly made money on the liquidation of capacity or inventory EBIT: Garrings Before Wrest and Taxes Short Term Interest Interest expense based on last year's current debt, including short term det, long term notes that have become due, and emergency loans Long Term Interest interest paid on outstanding bonds. Taxes: Income tax based upon a tax rahe Profit Sharing Profis shared with employees under the labor contract Prof: usinterest, , and profit shang $5,070 5607 $200 14.78 Profit Sharing 0.2 Net Profit $10.205 HON Variables Margins con 50 40 30% 10 0 Deal NA Ding O NA Dome Dug NA NA Round 0 Dec. 31 2019 Annual Report Baldwin Baldwin C59559 2019 Income Statement Product Name Bell Bit Bolt Buzz Na Na Na Na Total Common Size Sales $33,790 $16,537 $35,490 $33,690 SO $0 $0 so $119.521 100% Variable Costs: Direct Labor $10 426 $3,352 $8,268 $6.999 SO SO $0 so $29,014 24.3% Direct Material $14,542 $6,083 $14.547 $13.678 SO $0 SO $0 $48,851 40.9% Inventory Carry $241 $388 $514 $556 $0 $0 $0 $0 $1,800 1.5% Total Variable $25,210 $9,822 $21233 $0 SO $0 SO $79,695 66.7% $23, 420 $12,000 Contribution Margin $9,589 $6,714 $12,463 $0 $0 SO SO $39.825 33.3% Period Costs: $1.292 $1,213 $1473 $1647 $0 SO SO $5,625 4.7% Depreciation RAD $876 $963 $988 $939 SO $0 $0 $3,765 3.2% Promotions $1,100 $1.100 $1,100 $0 SO $0 $4.400 3.7% $1,100 $400 Sales $400 $1,200 $1,200 50 SO SO 8 8 8 8 8 8 8 $3,200 27% Admin $262 $128 $276 SO $0 90 $928 0.8 Total Penod $3,930 $3,804 $5.037 $5,147 $0 SO SO 15% $17.919 $21,907 Net Margin $4,658 $2,910 $7.024 $7,316 $0 SO SO $0 18.3% Other $318 0.3% EBIT $21.500 18.1% Short Term Interest $1,794 1.5% Long Term Interest $2.443 2 5.15 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: RAD 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 TOM. The fees include money paid to investment bankers and brokerage is to issue new stocks or bonds plus consulting fees your instructor might assess. Write of indikide the loss you might experience when you sel capacity of liquidate inventory as the result of eliminating a production line of the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory EBIT: Earrings Before Interest and Taxes Short Term Interest: Interest expense based on last year's curent del cluding short term debt, long terms at have become due, and emergency loans, Long Term Interest: Interest paid on outstanding bonds, Taxes Income tax based upon a tax rate, Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT in interests and profit sharing Taxes Profit Sharing $6,074 2220 0.2 Net Profit $11,054 9.2 Variables Margins 50 30 10 0% Bell NA Bolt Bit NA Buzz NA NA Annual Report TOP Annual Report Round 0 Dec. 31 2019 Baldwin C59559 Balance Sheet ASSETS 2019 2018 Common Size 20.7% Cash $19,378 $9,156 $8,048 59.824 10.5% $14.997 16% $15.246 $44,199 47.2% $32.450 Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed Assets $84 380 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 Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment: The Current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services Current Debt: The debt the company is obligated to pay during the next year of operations. It Includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 90.2% $77.880 (529,397) ($35.023) -37.4% 52.8% $48,483 $49,357 $ $93.566-L 100% $90,932 $6.382 $5,452 6.8% 19.6% $18,303 $19,512 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Tots Lab & O. Equity 20.9% 472% $10,691 $20.061 $ 536 204 $44,197 $9.001 9.7% $9.494 $40.200 43% $35.234 $49.00 528 $44,728 $93.556 100% $80,932 2019 2018 $11,054 $7.850 $5,192 $5,625 $0 SO S90 $249 (5351) (53.818) $470 ($1,776) $16,082 $9,352 Cash Flow Statement Cash Flows from Operating Activities: : The Cash Flow Statement examines what happened in the Cash Account during the year. Cash Net income (Loss) wjections 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 Depreciation positives you are forced to seek emergency funding. For example, sales are bad and you find Extraordinary gairlosses/writers 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 Accounts Payable Inhows, exhaust your starting cash and force you to beg for money to keep your company afat Inventory Accounts Receivable Cash Flow Summary Baldwin N Net cash from operations 20 Cash Flows from investing Activities: Plant improvements 19 an Cash Flows from Financing Activities : Dividends paid SO Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term det Change in eurent detinet) Nel cash from finanvang activities Net change in cash position Closing cash position ($6,500) ($12.220) (54.520) (54.034) 30 50 ($1,157 52,428 ($1.002) $5.788 (56.335) 57.612 50 3731 (52.034) 5641 $10.223 $19.378 $9,156 Operations Finance Che Cash Annual Report Page 1 Annual Report TOP Annual Report Round 0 Dec. 31 2019 Baldwin C59559 Balance Sheet ASSETS 2019 2018 Common Size 20.7% Cash $19,378 $9,156 $8,048 59.824 10.5% $14.997 16% $15.246 $44,199 47.2% $32.450 Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed Assets $84 380 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 Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment: The Current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services Current Debt: The debt the company is obligated to pay during the next year of operations. It Includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 90.2% $77.880 (529,397) ($35.023) -37.4% 52.8% $48,483 $49,357 $ $93.566-L 100% $90,932 $6.382 $5,452 6.8% 19.6% $18,303 $19,512 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Tots Lab & O. Equity 20.9% 472% $10,691 $20.061 $ 536 204 $44,197 $9.001 9.7% $9.494 $40.200 43% $35.234 $49.00 528 $44,728 $93.556 100% $80,932 2019 2018 $11,054 $7.850 $5,192 $5,625 $0 SO S90 $249 (5351) (53.818) $470 ($1,776) $16,082 $9,352 Cash Flow Statement Cash Flows from Operating Activities: : The Cash Flow Statement examines what happened in the Cash Account during the year. Cash Net income (Loss) wjections 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 Depreciation positives you are forced to seek emergency funding. For example, sales are bad and you find Extraordinary gairlosses/writers 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 Accounts Payable Inhows, exhaust your starting cash and force you to beg for money to keep your company afat Inventory Accounts Receivable Cash Flow Summary Baldwin N Net cash from operations 20 Cash Flows from investing Activities: Plant improvements 19 an Cash Flows from Financing Activities : Dividends paid SO Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term det Change in eurent detinet) Nel cash from finanvang activities Net change in cash position Closing cash position ($6,500) ($12.220) (54.520) (54.034) 30 50 ($1,157 52,428 ($1.002) $5.788 (56.335) 57.612 50 3731 (52.034) 5641 $10.223 $19.378 $9,156 Operations Finance Che Cash Annual Report Page 1 Round 0 Dec. 31 2019 Annual Report Andrews C59559 2019 Income Statement Product Name Ace Awe Art Ant Na Na Na Na Total Common Size Sales $36,835 $35,573 $58,475 $32,408 $0 $0 SO SO $163.291 100% Variable Costs Direct Labor $9.424 $7,613 $10 BOS $16.283 SO SO SO SO $44,125 27% Direct Material $14,346 $12,553 $11,537 $21,869 SO SO $O $60,305 36.9% Inventory Carry $826 $686 $1491 $135 8 8 8 8 8 SO $0 $0 SO $3,138 1.9% Total Variable $24,506 $20,852 $23.832 $38 288 SO SO so $107,568 65.9% Contribution Margin $12,239 $11,556 $11,741 $20,187 $0 SO so $55,723 34.1% Period Costs: Depreciation $1.068 $1,047 $2 200 $2,080 SO SO I SO SO $6.455 4% R&D $809 $881 $0 $0 SO SO SO SO $1.750 1.1% Promotions $1,200 $1,200 $1200 $1.200 SO SO $0 SO $4,800 2.9% Sales $1,000 $1,000 $2.000 $1,000 SO SO $0 so $5,000 3.1% 0.8% Admin $200 5255 $280 $450 SO $0 SO $0 Total Period $4426 $4,382 $5,740 $4,740 SO $0 SO SO $1,283 $ $19.288 $36,435 11.8% Net Margin $7.813 ST.173 $6,001 $15,448 SO $0 $0 $0 22.3 3 Other $29 0% EBIT $36.406 22.3 Short Term Interest 0.9% $1,493 $3,357 2.1% Long Term Interest Taxes $11,045 6.8% Definitions: Sales: Unil sales tumes 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: Calolated 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 categones such as Fees, Write Offs, and TOM. 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 ofts 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. Earrings 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 $410 0.3% Profit Sharing Net Profit $20,101 12.3 Variables Margins 40% 30% 20% 10% ON Ace NA Awe Art Ant NA NA NA Round Dec. 31 2019 059559 Annual Report Andrews Balance Sheet 2019 2018 ASSETS Common Size 25.5 $31.910 $31,543 Cash 100% $13.445 $13,421 Accounts Recevable 21.23 $14,796 $20,149 Inventory Total Current Assets 57 6N $60.151 $71,113 78.4% $93,304 $90,824 Plant & Equipment Accumulated Depreciation -30% (537.954) (544,409) DEFINITIONS: Common Size: The common se column simply represents each item as a percentage of total assets for that year. Cash: Your end of year cash position Accounts Receivable: Reflects the lag between delivery and payment of your products, Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment. The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company, Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 424% $52,415 $88.350 Total Fixed Assets 5123,527 100% $115.500 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable $8,781 $9,516 7.7% 12 YN 55.725 $15.717 Current Debt $34.742 $27,200 22N Long Term Debt $52,442 42.5 $49,248 Total Liabilities $12,080 9.8% $12443 Common Stock Retained Earnings $50,004 47 8 $53,80S $71,034 57.5% $66.251 Total Equity $123.527 100% $115.500 Total Lab. &0. Equity Cash Flow Statement 2019 2018 Cash Flows from Operating Activities: Net Income (Los) $20.101 $21,787 Depreciation $8.455 $6.220 The Cash Flow Statement examines what happened in the Cash Account during the year. Cash jections 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, sales are bad and you find yourself carrying an abundance of excess wwentory, the report would show the increase in ay as afuge negative cash flow. Too much unexpected inventory could cutstrip your ws, exhaust your starting cash and force you to beg for money to keep your company afloat. SO SO Extraordinary gain/losses writeoffs Accounts Payable $735 $2,083 Inventory ($11.353) (54,044) Accounts Receivable $23 ($2.891) Cash Flow Summary Andrews $15,962 $23,158 20 Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: (53,520) ($1,820 10 Dividends paid ($13,333) (57.49) $0 $0 Sales of Common Stock Purchase of Common Stock ($1.935) ($541) $0 SO Cash from long term debt Retirement of long term debt (87,513) $0 59,902 (52,070) 10 ($ 10,560) Change in current debt (net) Net cash from financing activities Not change in cash position Closing cash position ($12,809) ($307) $31.543 $ $10.770 $31,010 200 Operations Investment Finance Chg. Cash Annual Report Page 1 Human Resources Summary Andrews Baldwin Chester Digby 804 483 539 308 Needed Complemen Complement 804 483 539 so 1st Shit Complement 525 37 316 200 2nd Shili Complement 279 112 223 138 Overtime 0.0% 0.ON OOK 0.0% 10.0% 10.0% 8.25 60% 140 92 112 54 Tumover Rale New Employees Separated Employees Recruiting Spend Training Hours 0 0 0 0 SO $2.500 $5.000 0 0 40 80 Productivity Index 100.0% 100 ON 1004N 117.6 Recruiting Cost 5140 $92 $300 $124 Separation Cost DO SO SO $0 SO SO $431 5037 Training Cost Total HR Adren Cost 5140 $92 $821 $902 Labor Contract Next Year I Wages 525 53 525.63 $25.63 $2853 Bev 2.600 2.500 2.500 2.500 Prof Shang 2.0 2.0 20 20% Arnul R 5.ON 5.0% 5.0 50 TOM Summary Andrews Baldwin Chester Digby 50 $0 SO $0 SO Process Mgt Budgets Last Year CP Systems Vendor Quality rative Trang Channel Support frystems Con Engineering UNEP Green Program SO SO $$$$$s 50 30 50 50 30 50 30 50 30 50 TOM Budgets Last Year Benchmarking Quay Function Deployment CC Ung Trang GEM TOEM Bustamaties Expedis 50 88888 50 88888 30 30 50 30 so ODON Cumulative impact Material Cost Reduction Labor Cool Reduction Red RAD Tre Reduction de Costa Demand increase 0.00% 0.00% 0.00% O BOX 0.00 0.00% 0.00 OOON 0.00% ODON 0.00% ODON ODOW OOON 0.00% 0.00 000 COMP-XMO INQUIRER Page 11 20 19 15 Arti Cell 14 1 12 Old Gutid cond sem 10 LLAWS Dome TACO 0 2 8 14 16 18 20 10 12 Performance Andrews Baldwin Name Pin Chester SO Revised Name Size Revised Name Ace 10.3 Pfm Pimn 36 Sie 78 11/2010 Revised Bell 0.6 11/12/2019 Cell Awe 60 124 0.8 11/14/2019 14.0 12/11/2019 Bit 113 10 12/13/2019 City Art 2 AO 13.8 15 4/13/2017 12/19/2010 Bolt 102 7.8 12/22/2019 Cone Ant YO 8.8 110 124 12/2016 12/3/2019 Bu 122 08 12/6/2019 Cute 0.3 115 11/19 2010 Digby Name Pinn Size Revised W212020 Deal 52 148 Dino 7.8 11/30/2010 Dome 0.7 12/22/2010 Dug 17 10.3 11/11/2019 COMP-XME INQUIRER Page 10 Elite Statisitos Accessibility Elite 3.470 3,476 Total Industry Unit Demand Actual Industry Unit Sales Segment of Total Industry Next Year's Segment Growth Rate Andrews 18.45 16N Baldwin Elite Customer Buying Criteria Expectations Importance 1. Age Ideal Age 0.0 345 Chester 2. Price $30.00 - 4200 24% 3 Ideal Position Pimn 11.7 Sure 103 22 4. Reliability MTBF 20000-26000 20% Digby ON 20% 40% 601 BOX 1001 Perceptual Map For Elite Actual vs Potential Market Share Elite 20 18 18 40 14 AN 12 19 Do Ace 20 1ON 2 09 U Andrews Bwin Cher Digby 4 14 10 20 to 18 Performance Actual Potential Top Products in Elite Segment Markel Units Sold to Share Seg 10% 011 Revision Date Stock Out Pimn Coord Size Coord List Price MTBF Age Dec 31 Name Promo Budget Cust. Awareness Sales Budget Cust Accessibility Dec. Cust. Survey Ae 124 98 142 00 20000 1.09 $1.200 77% 11/14/2010 12/2010 $ 1 000 20 Du 17 304 122 98 1.00 51.100 10 51,200 IN 10 Dug 10 MO 19/2010 11.7 103 $39.00 25000 $35.00 20000 53 00 25000 1.12 $950 52 $1.300 10 MO 110 104 1.91 51,100 72% 12/12010 12/10/2011 And 200 $ $100 $1.000 76 124 $3200 22000 2.24 SIN 100 102 TA 1.04 TON 12/27/2010 A 2019 51,00 11 $3700 28000 34000 24000 201 103 $1,200 51.100 $1.200 $1.100 $950 BIN ar 1.12 TIN $1000 11 282 90 5000 25000 2.10 $400 Do 54 182 107 11/12/2019 12/22/2010 11/10/2010 12/2010 MIN 11 3 85 3100 1000 11 12000 20000 110 2700 000 $1.no BO TON Cone 2 54 1.21 51.no 100 TON Nano Statisitos Accessibility Nano 3,040 3.648 Total Industry Un Demand Actuality Unt Sales Segment of Total nusty Next Year's Segment Orowth Rate Andrews 10 3N 14% Dan Nano Customer Buying Criteria Expectations Importance 35 1. Meal Position Pinn 0.7 Sira $28.00 40.00 Chester 2. Price 27N 20N 3. Age 4. Relahitty Ideal Ago 10 MTOR 18000-2000 ON Digby ON ION 20N SON 40% 60 CON YON Perceptual Map For Nano Actual vs Potential Market Share Nano 20 SON 10 40 14 Anl Cutd Gone 301 10 e- Dohl 20N 101 4 2 ON 0 0 Andrews Baldwin Chester 2 Doty 16 10 18 20 10 12 Performance Actual Potential Top Products in Nano Segment Market Units sold to Share Seg Stock Out Name Pm Coord Sure Coord List Price MTBF Age Dec.31 Promo Budget Cust. Awareness Dee. Cust Survey Revision Date 12/22/2010 11/2010 12/22/2010 Cust Accessibility MIN 000 102 TB 104 337.00 23000 54000 24000 TON Sales Budget 51.200 31,000 5000 44 30 103 $1,100 81.200 78 YON 1.12 1.07 42 De 404 3950 431 2.10 $1,100 37 43 1400 Art IN 80 7.0 200 11/12/2010 12/10/2016 2/2010 BON $1.000 10 200 122 2.24 105 125 240 $31.00 18000 $10.00 23000 33200 22000 330.000000 52000 20000 $35.00 20000 $27.00 16000 42.000000 BIN AN BIN 20 Cute Dug 51.200 51.100 31.050 5050 10 31200 5000 /2019 TV10 12/2010 11/14/2019 230 17 103 12 51,00 12 110 31.050 31200 1600 2N 101 DO 18 1.00 2 12/1/2019 104 51.100 TEN 5400 13 a E ES Core Statisites Accessibility Core Total Industry Unit Demand 6,676 Actual Industry Unit Sales 6,670 Andrews Segment of Total Industry 35.3% Next Year's Segment Growth Rate 10% Baldwin Core Customer Buying Criteria LU Expectations Importance 1. Price $20.00 - 32.00 46% Chester 2 Age Ideal Age 20 20% el! 18% 3. Reliability 4. Ideal Position MTBF 10000-22000 Pim 7. Sure 122 16% Digoy 20N 40 GON BON 100% Perceptual Map For Core Actual vs Potential Market Share Core 20 40 10 116 30 14 12 20 10 10 0 I 0 Andrews Baldwin Chester Digby 14 10 18 20 10 12 Performance Actual Potential Top Products in Core Segment Revision Date Stock Out Name Pimn Coord 7.8 Size Coord List Price MTBF Age Dec.31 Promo Budget Cust. Awareness Market Units Sold to Share Seg 21 1.360 18% Sales Budget $1,000 Cust. Accessibility Dec. Cust. Survey Dino 3950 21 33 AN 7.6 122 12.4 11.5 $22.00 16000 $ $3200 22000 520.00 20000 2.24 BON $1.000 RSS 27 151 900 23 $1.200 $1.050 1.25 639 5000 N 18 Cone 15 DTB 11/30/2019 12/10/2018 11/19 2019 12/3/2019 27/2000 4/11/2017 1112/2010 110 $27.00 15000 121 31.050 3600 18 De 10N 00 148 1 52000 14000 3.40 D Art 52000 20000 51.200 TON $1,000 52.000 500 B 20 $30 DO 2000 413 270 2.10 7 62 31.100 51.050 3800 SN 22 21 15-4 12/10/2019 12/11/2010 12/22/2019 00 140 2.70 $19.00 17000 51900 17000 $3100 1000 13500 20000 31.050 63 27 BS 3950 5600 1.07 1.12 D Dug 103 11.300 0 COMP-XMO INQUIRER Page 6 Andrews Baldwin Chester Digby 4.751 Units Produced 5,594 3,317 5.941 Production Information Primary Segment Units Sold Revision Date Unit Inventory Pfm Coord Ago Dec.31 MTBF Material Cost Size Coord Labor Cost Capacity Next 2nd Shift & Overtima Name Contr. Marg Automation Noxt Round Plant Utiliz Price Round Ace Nano 921 267 11/9/2019 1.1 24000 10.3 78 $40.00 $16.13 $10.29 33% 42% 4.0 728 14156 Awo Elite 772 219 11/14/2019 1.1 20000 124 9.8 $42.00 $16.81 $9.80 36% 22% 4.0 714 1219 Art Thrift 1.368 761 4/13/2017 5.1 20000 4,9 15.1 $26.00 $8.13 $7.90 33% 90% 6.0 1.130 188% Ant Core 1,827 54 12/10/2018 22 22000 7.6 124 $32.00 $11.60 $8.96 35% 50% 5.0 1,200 149% Boll Nano 1,127 91 11/12/2019 22 23000 B.G 96 $30.00 $13.98 $9.50 25% 93% 50 570 1915 B Elite 438 149 12/13/2019 1.9 25000 11.8 10.4 $38.00 $15.87 $7.73 41% 0% 6.0 700 645 Bolt Nano 950 215 12/22/2019 1.0 23000 10.2 7.8 $37.00 $15.79 $8.50 34% 27% 50 850 125% Buzz Elita 804 194 12/6/2010 1.0 25000 122 9.8 $39.00 $16.39 $7.95 37% 6% 5.0 950 105% Coll Thrill 1,338 240 12/11/2010 2.8 17000 6.0 14,0 $19.00 58.40 $4.03 41% 33% 80 1,050 132% City Thrift 1,071 200 12/10/2010 20 17000 6.2 138 $19.00 $8.61 $4.22 379 57% 8.0 1,250 156% Cond Core 1.287 162 12/3/2019 12 18000 8.6 $11.68 S738 30% 93% 6.0 900 191% 110 $27.00 11.5 $28.00 Cute Core 1.414 87 11/19/2019 1.2 20000 9.3 $12.39 S7 38 30% 93% 6.0 950 191% Deal Thrift 1.730 22 6/27/2020 35 14000 5.2 14.8 $20.00 $6.65 $2.82 51% 100% 9.0 1,000 198% Dino Core 1.885 14 11/30/2019 1.2 16000 7.8 122 522.00 $10.01 $5.64 31% 100% 7.0 1,150 198% Dome Nano 700 161 42/22/2019 1.1 18000 9.7 8.5 $31.00 $13.64 $6.24 36% 25% 6.0 750 124% Dug Ente 604 137 41/6/2010 1.1 20000 11.7 10.3 $35.00 $14.36 $7.09 38% BX 50 B00 107% COMP-XM@ INQUIRER Page 4 Round 0 Dec. 31 2019 Report COMP. X MB INQUIRER Andrews Baldwin Chester Digby Selected Financial Statistics Andrews Baldwin Chester Digby ROS 12.3% 9.2 5.7% B.6% Asset Tumover 132 1.28 0.91 0194 ROA 16.3% 11.8 8.15 8.1% Leverage (Assets/Equity 1.7 1.9 27 2.4 ROE 283 22.4% 13.8 19.2 SO SO 80 SO Emergency Loan Sales $183 290,917 $119.521.454 $131,509,005 $118,899, 130 ERIT 9.405 230 $21.50.617 $21,073,280 $23.774,069 Pronts 520,101,345 $11.052,967 57.459.277 $10.204.711 Cumulative Profit SO 50 $0 SO SOLA Sales 79 10.3% 11.236 0.7% 33,796 Contrib. Margin 34.1 333 38.8% Percent of Sales S Market Share 1254 Digby 22.3% 100 Andrews 30.6 Other SGA Depr Var Costs Profit 75 son Chester 247 Andrews Ch Baldwin 22.4 Markut Share information is provided on Page 7 COMP-XMO INQUIRER Page 1 Annual Report TOP Round 0 Dec. 31 2019 Annual Report Chester C59559 Balance Sheet ASSETS 2019 2018 Common Size Cash $31.900 22% $36,749 $10.809 78% $9,777 Accounts Receivable Inventory $10,003 73% $7,845 Total Current Assets $63.372 36.8% $54,371 Plant & fiquipment $142.000 08.6% $127.100 DEFINITIONS: Common Size: The Cormon size column sniply represents each item as a percentage of of assets for that year, Cash: Your end of year cash position Accounts Recolvable: Reichstag between delivery and payment of your products, inventories. The current value of your inventory across all products. A zero indicates your company locked ouUrmet demand wound of course, tak to your competitors Plant & Equipment: The curent value of your plant. Accum Deprec: The total oculated depreciation from your plant Acets Payable: What the company currently owes suppliers to materials and services Current Dote: The debt the companys obligated to pay during the next year of operations. It includes emergency on used to keep your company vend you run out of cash during the year Long Term Debt: The company's long term debt is in the form of bonds, and thus 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 instead of paying to Shareholders as dividends Accumulated Depreciation (551,265) 35.4% (541,738) Total Fixed Assets 301.835 63.2W $5,362 Total assets $145,007 100W $139,733 LIABILITIES & OWNERS' EQUITY Accounts Payable $7.283 5% $5.826 Current Dobit 529.231 20.2% $22,161 Long Term Debt $53,845 37.1% $51.904 500.350 623% $79.891 524690 17 $24,690 Total Liabilities Common Stock Ratained Earnings Total Equity Total Liab & Equity $29,950 20.7% $35,152 564,648 377 550 842 $145,007 100% $130,733 Cash Flow Statement Cash Flows from Operating Activities: 2019 2018 Notico (LSS) $10,427 The Cash Flow Statement is what happened in the Cash Account during the year. Cash ection was postive numbers and cash withdrawal negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When give showed posts you we forced to seek emergency ludne. For example, les we bed and you find your crying an abundance of es wenty, the report wo show the worse invertory Agregative cash flow too much unexpected inventory could use your wow chale your arting cash widforce you to be for money to keep your company to $7450 $9,827 $8.473 50 SO $1,457 (57) s7Ta Cash Flow Summary Chester (52.758) ($1.002) $14,653 (5562) Deprecation Extraordinary wossewwiders Accounts Payable Inventory Accounts Receivable Netcash from operations Net Cash Flows from investing Activities Plant improvements Cash Flows from Financing Activities Dividends paid Sales of Common Stock Purchase of Common Stock 20 $18,327 ($15.800) ($18.602) JOM ( (S. ($12.653) $0 SO 50 $0 59474 (57533) $7.070 $7.98 $0 Cash from long term del Retirement of long term det Change in current debit) Nel cash from financing wis Nel change in cash position Closing cash position 10 (55.250) (56.180) (63,642) (147) (56.445) $51.00 $30,700 Operations Investment Finance Chy. Cash Annual Report Page 1 TOP Round 0 Deci 31 2019 Annual Report Digby 2019 Income Statement Na Na Na Dug Deal Total Na Dino Dome Product Name Common Size '! $0 100% Sales $21.689 $34,898 $21.130 $0 50 5118.899 $41476 Variable Costs: Direct Labor $10,009 $4,401 20.43 $4,874 $4.326 $0 $0 SO $24.211 $9,177 $8,423 SO $12,102 $0 $0 $0 Direct Material $18,096 $47.798 40.2% $26 Inventory Carry $375 $26 $346 $0 $0 $0 $0 $772 0.6% $28,731 $13.952 513.095 $0 SO 0120 $0 $72,781 SO $17,003 $17505 57.737 $12,745 $8,041 SO SO SO SO $40.118 38.8% Total Vanabis Contribution Margin Period Costs: Depreciation $2.800 $2.507 $1,500 $1,387 SO $0 $8.293 TN R&D $1,000 5928 $857 $985 SO so SO $3,772 32% Promotions $950 $950 5950 5950 SO $0 sa so $3,800 32N Sales SE00 SO $0 $0 $0 $3,900 3.3% $1,000 $522 $1,000 5626 $1,300 $319 Admin $327 50 SO SO SO $1,794 1.8% Total Period $4 365 54213 $ SO SO $0 $21.50 18.1% $6,272 $11,323 56,110 $6,635 Not Margin $3,312 $3.228 $0 $0 50 $0 $24.6.80 20.7% Other $784 07 EBIT 523,774 20% Short Term Interest $2.64 2.3% Long Term interest 42% Taxes Definitions: Sales: Unil sales times list price Direct Labor: Labor costs incurred to produce the product that was sold, Inventory Camry Cost the cost o carry unsold goods in Inventory Depreciation Calolated on straightine 15-year depreciation of plant value RAD Costs: RAD department expenditures for each product. Admin: Administration overheads estimated at 1.8% of sales Promotions. The promotion budget for each product Sales: The sales force budoet for each product. Other Charges not included in other categones such as Fees, Wite Ofts, and TOM, The fees include money paid to wovestment bankers and brokerage tem to issue new stocks or bonds plus consulting for your instructor might assess Write otside the loss you might experience when you sell capacity or liquidata wontory as the result of minating a production line. If the amount appears as negative amount, then you chilly made money on the liquidation of capacity or inventory EBIT: Garrings Before Wrest and Taxes Short Term Interest Interest expense based on last year's current debt, including short term det, long term notes that have become due, and emergency loans Long Term Interest interest paid on outstanding bonds. Taxes: Income tax based upon a tax rahe Profit Sharing Profis shared with employees under the labor contract Prof: usinterest, , and profit shang $5,070 5607 $200 14.78 Profit Sharing 0.2 Net Profit $10.205 HON Variables Margins con 50 40 30% 10 0 Deal NA Ding O NA Dome Dug NA NA Round 0 Dec. 31 2019 Annual Report Baldwin Baldwin C59559 2019 Income Statement Product Name Bell Bit Bolt Buzz Na Na Na Na Total Common Size Sales $33,790 $16,537 $35,490 $33,690 SO $0 $0 so $119.521 100% Variable Costs: Direct Labor $10 426 $3,352 $8,268 $6.999 SO SO $0 so $29,014 24.3% Direct Material $14,542 $6,083 $14.547 $13.678 SO $0 SO $0 $48,851 40.9% Inventory Carry $241 $388 $514 $556 $0 $0 $0 $0 $1,800 1.5% Total Variable $25,210 $9,822 $21233 $0 SO $0 SO $79,695 66.7% $23, 420 $12,000 Contribution Margin $9,589 $6,714 $12,463 $0 $0 SO SO $39.825 33.3% Period Costs: $1.292 $1,213 $1473 $1647 $0 SO SO $5,625 4.7% Depreciation RAD $876 $963 $988 $939 SO $0 $0 $3,765 3.2% Promotions $1,100 $1.100 $1,100 $0 SO $0 $4.400 3.7% $1,100 $400 Sales $400 $1,200 $1,200 50 SO SO 8 8 8 8 8 8 8 $3,200 27% Admin $262 $128 $276 SO $0 90 $928 0.8 Total Penod $3,930 $3,804 $5.037 $5,147 $0 SO SO 15% $17.919 $21,907 Net Margin $4,658 $2,910 $7.024 $7,316 $0 SO SO $0 18.3% Other $318 0.3% EBIT $21.500 18.1% Short Term Interest $1,794 1.5% Long Term Interest $2.443 2 5.15 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: RAD 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 TOM. The fees include money paid to investment bankers and brokerage is to issue new stocks or bonds plus consulting fees your instructor might assess. Write of indikide the loss you might experience when you sel capacity of liquidate inventory as the result of eliminating a production line of the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory EBIT: Earrings Before Interest and Taxes Short Term Interest: Interest expense based on last year's curent del cluding short term debt, long terms at have become due, and emergency loans, Long Term Interest: Interest paid on outstanding bonds, Taxes Income tax based upon a tax rate, Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT in interests and profit sharing Taxes Profit Sharing $6,074 2220 0.2 Net Profit $11,054 9.2 Variables Margins 50 30 10 0% Bell NA Bolt Bit NA Buzz NA NA Annual Report TOP Annual Report Round 0 Dec. 31 2019 Baldwin C59559 Balance Sheet ASSETS 2019 2018 Common Size 20.7% Cash $19,378 $9,156 $8,048 59.824 10.5% $14.997 16% $15.246 $44,199 47.2% $32.450 Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed Assets $84 380 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 Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment: The Current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services Current Debt: The debt the company is obligated to pay during the next year of operations. It Includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 90.2% $77.880 (529,397) ($35.023) -37.4% 52.8% $48,483 $49,357 $ $93.566-L 100% $90,932 $6.382 $5,452 6.8% 19.6% $18,303 $19,512 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Tots Lab & O. Equity 20.9% 472% $10,691 $20.061 $ 536 204 $44,197 $9.001 9.7% $9.494 $40.200 43% $35.234 $49.00 528 $44,728 $93.556 100% $80,932 2019 2018 $11,054 $7.850 $5,192 $5,625 $0 SO S90 $249 (5351) (53.818) $470 ($1,776) $16,082 $9,352 Cash Flow Statement Cash Flows from Operating Activities: : The Cash Flow Statement examines what happened in the Cash Account during the year. Cash Net income (Loss) wjections 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 Depreciation positives you are forced to seek emergency funding. For example, sales are bad and you find Extraordinary gairlosses/writers 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 Accounts Payable Inhows, exhaust your starting cash and force you to beg for money to keep your company afat Inventory Accounts Receivable Cash Flow Summary Baldwin N Net cash from operations 20 Cash Flows from investing Activities: Plant improvements 19 an Cash Flows from Financing Activities : Dividends paid SO Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term det Change in eurent detinet) Nel cash from finanvang activities Net change in cash position Closing cash position ($6,500) ($12.220) (54.520) (54.034) 30 50 ($1,157 52,428 ($1.002) $5.788 (56.335) 57.612 50 3731 (52.034) 5641 $10.223 $19.378 $9,156 Operations Finance Che Cash Annual Report Page 1 Annual Report TOP Annual Report Round 0 Dec. 31 2019 Baldwin C59559 Balance Sheet ASSETS 2019 2018 Common Size 20.7% Cash $19,378 $9,156 $8,048 59.824 10.5% $14.997 16% $15.246 $44,199 47.2% $32.450 Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed Assets $84 380 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 Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment: The Current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services Current Debt: The debt the company is obligated to pay during the next year of operations. It Includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 90.2% $77.880 (529,397) ($35.023) -37.4% 52.8% $48,483 $49,357 $ $93.566-L 100% $90,932 $6.382 $5,452 6.8% 19.6% $18,303 $19,512 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Tots Lab & O. Equity 20.9% 472% $10,691 $20.061 $ 536 204 $44,197 $9.001 9.7% $9.494 $40.200 43% $35.234 $49.00 528 $44,728 $93.556 100% $80,932 2019 2018 $11,054 $7.850 $5,192 $5,625 $0 SO S90 $249 (5351) (53.818) $470 ($1,776) $16,082 $9,352 Cash Flow Statement Cash Flows from Operating Activities: : The Cash Flow Statement examines what happened in the Cash Account during the year. Cash Net income (Loss) wjections 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 Depreciation positives you are forced to seek emergency funding. For example, sales are bad and you find Extraordinary gairlosses/writers 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 Accounts Payable Inhows, exhaust your starting cash and force you to beg for money to keep your company afat Inventory Accounts Receivable Cash Flow Summary Baldwin N Net cash from operations 20 Cash Flows from investing Activities: Plant improvements 19 an Cash Flows from Financing Activities : Dividends paid SO Sales of Common Stock Purchase of Common Stock Cash from long term debt Retirement of long term det Change in eurent detinet) Nel cash from finanvang activities Net change in cash position Closing cash position ($6,500) ($12.220) (54.520) (54.034) 30 50 ($1,157 52,428 ($1.002) $5.788 (56.335) 57.612 50 3731 (52.034) 5641 $10.223 $19.378 $9,156 Operations Finance Che Cash Annual Report Page 1 Round 0 Dec. 31 2019 Annual Report Andrews C59559 2019 Income Statement Product Name Ace Awe Art Ant Na Na Na Na Total Common Size Sales $36,835 $35,573 $58,475 $32,408 $0 $0 SO SO $163.291 100% Variable Costs Direct Labor $9.424 $7,613 $10 BOS $16.283 SO SO SO SO $44,125 27% Direct Material $14,346 $12,553 $11,537 $21,869 SO SO $O $60,305 36.9% Inventory Carry $826 $686 $1491 $135 8 8 8 8 8 SO $0 $0 SO $3,138 1.9% Total Variable $24,506 $20,852 $23.832 $38 288 SO SO so $107,568 65.9% Contribution Margin $12,239 $11,556 $11,741 $20,187 $0 SO so $55,723 34.1% Period Costs: Depreciation $1.068 $1,047 $2 200 $2,080 SO SO I SO SO $6.455 4% R&D $809 $881 $0 $0 SO SO SO SO $1.750 1.1% Promotions $1,200 $1,200 $1200 $1.200 SO SO $0 SO $4,800 2.9% Sales $1,000 $1,000 $2.000 $1,000 SO SO $0 so $5,000 3.1% 0.8% Admin $200 5255 $280 $450 SO $0 SO $0 Total Period $4426 $4,382 $5,740 $4,740 SO $0 SO SO $1,283 $ $19.288 $36,435 11.8% Net Margin $7.813 ST.173 $6,001 $15,448 SO $0 $0 $0 22.3 3 Other $29 0% EBIT $36.406 22.3 Short Term Interest 0.9% $1,493 $3,357 2.1% Long Term Interest Taxes $11,045 6.8% Definitions: Sales: Unil sales tumes 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: Calolated 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 categones such as Fees, Write Offs, and TOM. 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 ofts 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. Earrings 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 $410 0.3% Profit Sharing Net Profit $20,101 12.3 Variables Margins 40% 30% 20% 10% ON Ace NA Awe Art Ant NA NA NA Round Dec. 31 2019 059559 Annual Report Andrews Balance Sheet 2019 2018 ASSETS Common Size 25.5 $31.910 $31,543 Cash 100% $13.445 $13,421 Accounts Recevable 21.23 $14,796 $20,149 Inventory Total Current Assets 57 6N $60.151 $71,113 78.4% $93,304 $90,824 Plant & Equipment Accumulated Depreciation -30% (537.954) (544,409) DEFINITIONS: Common Size: The common se column simply represents each item as a percentage of total assets for that year. Cash: Your end of year cash position Accounts Receivable: Reflects the lag between delivery and payment of your products, Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, tal to your competitors. Plant & Equipment. The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company'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 company, Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends 424% $52,415 $88.350 Total Fixed Assets 5123,527 100% $115.500 Total assets LIABILITIES & OWNERS' EQUITY Accounts Payable $8,781 $9,516 7.7% 12 YN 55.725 $15.717 Current Debt $34.742 $27,200 22N Long Term Debt $52,442 42.5 $49,248 Total Liabilities $12,080 9.8% $12443 Common Stock Retained Earnings $50,004 47 8 $53,80S $71,034 57.5% $66.251 Total Equity $123.527 100% $115.500 Total Lab. &0. Equity Cash Flow Statement 2019 2018 Cash Flows from Operating Activities: Net Income (Los) $20.101 $21,787 Depreciation $8.455 $6.220 The Cash Flow Statement examines what happened in the Cash Account during the year. Cash jections 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, sales are bad and you find yourself carrying an abundance of excess wwentory, the report would show the increase in ay as afuge negative cash flow. Too much unexpected inventory could cutstrip your ws, exhaust your starting cash and force you to beg for money to keep your company afloat. SO SO Extraordinary gain/losses writeoffs Accounts Payable $735 $2,083 Inventory ($11.353) (54,044) Accounts Receivable $23 ($2.891) Cash Flow Summary Andrews $15,962 $23,158 20 Net cash from operations Cash Flows from Investing Activities: Plant Improvements Cash Flows from Financing Activities: (53,520) ($1,820 10 Dividends paid ($13,333) (57.49) $0 $0 Sales of Common Stock Purchase of Common Stock ($1.935) ($541) $0 SO Cash from long term debt Retirement of long term debt (87,513) $0 59,902 (52,070) 10 ($ 10,560) Change in current debt (net) Net cash from financing activities Not change in cash position Closing cash position ($12,809) ($307) $31.543 $ $10.770 $31,010 200 Operations Investment Finance Chg. Cash Annual Report Page 1 Human Resources Summary Andrews Baldwin Chester Digby 804 483 539 308 Needed Complemen Complement 804 483 539 so 1st Shit Complement 525 37 316 200 2nd Shili Complement 279 112 223 138 Overtime 0.0% 0.ON OOK 0.0% 10.0% 10.0% 8.25 60% 140 92 112 54 Tumover Rale New Employees Separated Employees Recruiting Spend Training Hours 0 0 0 0 SO $2.500 $5.000 0 0 40 80 Productivity Index 100.0% 100 ON 1004N 117.6 Recruiting Cost 5140 $92 $300 $124 Separation Cost DO SO SO $0 SO SO $431 5037 Training Cost Total HR Adren Cost 5140 $92 $821 $902 Labor Contract Next Year I Wages 525 53 525.63 $25.63 $2853 Bev 2.600 2.500 2.500 2.500 Prof Shang 2.0 2.0 20 20% Arnul R 5.ON 5.0% 5.0 50 TOM Summary Andrews Baldwin Chester Digby 50 $0 SO $0 SO Process Mgt Budgets Last Year CP Systems Vendor Quality rative Trang Channel Support frystems Con Engineering UNEP Green Program SO SO $$$$$s 50 30 50 50 30 50 30 50 30 50 TOM Budgets Last Year Benchmarking Quay Function Deployment CC Ung Trang GEM TOEM Bustamaties Expedis 50 88888 50 88888 30 30 50 30 so ODON Cumulative impact Material Cost Reduction Labor Cool Reduction Red RAD Tre Reduction de Costa Demand increase 0.00% 0.00% 0.00% O BOX 0.00 0.00% 0.00 OOON 0.00% ODON 0.00% ODON ODOW OOON 0.00% 0.00 000 COMP-XMO INQUIRER Page 11 20 19 15 Arti Cell 14 1 12 Old Gutid cond sem 10 LLAWS Dome TACO 0 2 8 14 16 18 20 10 12 Performance Andrews Baldwin Name Pin Chester SO Revised Name Size Revised Name Ace 10.3 Pfm Pimn 36 Sie 78 11/2010 Revised Bell 0.6 11/12/2019 Cell Awe 60 124 0.8 11/14/2019 14.0 12/11/2019 Bit 113 10 12/13/2019 City Art 2 AO 13.8 15 4/13/2017 12/19/2010 Bolt 102 7.8 12/22/2019 Cone Ant YO 8.8 110 124 12/2016 12/3/2019 Bu 122 08 12/6/2019 Cute 0.3 115 11/19 2010 Digby Name Pinn Size Revised W212020 Deal 52 148 Dino 7.8 11/30/2010 Dome 0.7 12/22/2010 Dug 17 10.3 11/11/2019 COMP-XME INQUIRER Page 10 Elite Statisitos Accessibility Elite 3.470 3,476 Total Industry Unit Demand Actual Industry Unit Sales Segment of Total Industry Next Year's Segment Growth Rate Andrews 18.45 16N Baldwin Elite Customer Buying Criteria Expectations Importance 1. Age Ideal Age 0.0 345 Chester 2. Price $30.00 - 4200 24% 3 Ideal Position Pimn 11.7 Sure 103 22 4. Reliability MTBF 20000-26000 20% Digby ON 20% 40% 601 BOX 1001 Perceptual Map For Elite Actual vs Potential Market Share Elite 20 18 18 40 14 AN 12 19 Do Ace 20 1ON 2 09 U Andrews Bwin Cher Digby 4 14 10 20 to 18 Performance Actual Potential Top Products in Elite Segment Markel Units Sold to Share Seg 10% 011 Revision Date Stock Out Pimn Coord Size Coord List Price MTBF Age Dec 31 Name Promo Budget Cust. Awareness Sales Budget Cust Accessibility Dec. Cust. Survey Ae 124 98 142 00 20000 1.09 $1.200 77% 11/14/2010 12/2010 $ 1 000 20 Du 17 304 122 98 1.00 51.100 10 51,200 IN 10 Dug 10 MO 19/2010 11.7 103 $39.00 25000 $35.00 20000 53 00 25000 1.12 $950 52 $1.300 10 MO 110 104 1.91 51,100 72% 12/12010 12/10/2011 And 200 $ $100 $1.000 76 124 $3200 22000 2.24 SIN 100 102 TA 1.04 TON 12/27/2010 A 2019 51,00 11 $3700 28000 34000 24000 201 103 $1,200 51.100 $1.200 $1.100 $950 BIN ar 1.12 TIN $1000 11 282 90 5000 25000 2.10 $400 Do 54 182 107 11/12/2019 12/22/2010 11/10/2010 12/2010 MIN 11 3 85 3100 1000 11 12000 20000 110 2700 000 $1.no BO TON Cone 2 54 1.21 51.no 100 TON Nano Statisitos Accessibility Nano 3,040 3.648 Total Industry Un Demand Actuality Unt Sales Segment of Total nusty Next Year's Segment Orowth Rate Andrews 10 3N 14% Dan Nano Customer Buying Criteria Expectations Importance 35 1. Meal Position Pinn 0.7 Sira $28.00 40.00 Chester 2. Price 27N 20N 3. Age 4. Relahitty Ideal Ago 10 MTOR 18000-2000 ON Digby ON ION 20N SON 40% 60 CON YON Perceptual Map For Nano Actual vs Potential Market Share Nano 20 SON 10 40 14 Anl Cutd Gone 301 10 e- Dohl 20N 101 4 2 ON 0 0 Andrews Baldwin Chester 2 Doty 16 10 18 20 10 12 Performance Actual Potential Top Products in Nano Segment Market Units sold to Share Seg Stock Out Name Pm Coord Sure Coord List Price MTBF Age Dec.31 Promo Budget Cust. Awareness Dee. Cust Survey Revision Date 12/22/2010 11/2010 12/22/2010 Cust Accessibility MIN 000 102 TB 104 337.00 23000 54000 24000 TON Sales Budget 51.200 31,000 5000 44 30 103 $1,100 81.200 78 YON 1.12 1.07 42 De 404 3950 431 2.10 $1,100 37 43 1400 Art IN 80 7.0 200 11/12/2010 12/10/2016 2/2010 BON $1.000 10 200 122 2.24 105 125 240 $31.00 18000 $10.00 23000 33200 22000 330.000000 52000 20000 $35.00 20000 $27.00 16000 42.000000 BIN AN BIN 20 Cute Dug 51.200 51.100 31.050 5050 10 31200 5000 /2019 TV10 12/2010 11/14/2019 230 17 103 12 51,00 12 110 31.050 31200 1600 2N 101 DO 18 1.00 2 12/1/2019 104 51.100 TEN 5400 13 a E ES Core Statisites Accessibility Core Total Industry Unit Demand 6,676 Actual Industry Unit Sales 6,670 Andrews Segment of Total Industry 35.3% Next Year's Segment Growth Rate 10% Baldwin Core Customer Buying Criteria LU Expectations Importance 1. Price $20.00 - 32.00 46% Chester 2 Age Ideal Age 20 20% el! 18% 3. Reliability 4. Ideal Position MTBF 10000-22000 Pim 7. Sure 122 16% Digoy 20N 40 GON BON 100% Perceptual Map For Core Actual vs Potential Market Share Core 20 40 10 116 30 14 12 20 10 10 0 I 0 Andrews Baldwin Chester Digby 14 10 18 20 10 12 Performance Actual Potential Top Products in Core Segment Revision Date Stock Out Name Pimn Coord 7.8 Size Coord List Price MTBF Age Dec.31 Promo Budget Cust. Awareness Market Units Sold to Share Seg 21 1.360 18% Sales Budget $1,000 Cust. Accessibility Dec. Cust. Survey Dino 3950 21 33 AN 7.6 122 12.4 11.5 $22.00 16000 $ $3200 22000 520.00 20000 2.24 BON $1.000 RSS 27 151 900 23 $1.200 $1.050 1.25 639 5000 N 18 Cone 15 DTB 11/30/2019 12/10/2018 11/19 2019 12/3/2019 27/2000 4/11/2017 1112/2010 110 $27.00 15000 121 31.050 3600 18 De 10N 00 148 1 52000 14000 3.40 D Art 52000 20000 51.200 TON $1,000 52.000 500 B 20 $30 DO 2000 413 270 2.10 7 62 31.100 51.050 3800 SN 22 21 15-4 12/10/2019 12/11/2010 12/22/2019 00 140 2.70 $19.00 17000 51900 17000 $3100 1000 13500 20000 31.050 63 27 BS 3950 5600 1.07 1.12 D Dug 103 11.300 0 COMP-XMO INQUIRER Page 6 Andrews Baldwin Chester Digby 4.751 Units Produced 5,594 3,317 5.941 Production Information Primary Segment Units Sold Revision Date Unit Inventory Pfm Coord Ago Dec.31 MTBF Material Cost Size Coord Labor Cost Capacity Next 2nd Shift & Overtima Name Contr. Marg Automation Noxt Round Plant Utiliz Price Round Ace Nano 921 267 11/9/2019 1.1 24000 10.3 78 $40.00 $16.13 $10.29 33% 42% 4.0 728 14156 Awo Elite 772 219 11/14/2019 1.1 20000 124 9.8 $42.00 $16.81 $9.80 36% 22% 4.0 714 1219 Art Thrift 1.368 761 4/13/2017 5.1 20000 4,9 15.1 $26.00 $8.13 $7.90 33% 90% 6.0 1.130 188% Ant Core 1,827 54 12/10/2018 22 22000 7.6 124 $32.00 $11.60 $8.96 35% 50% 5.0 1,200 149% Boll Nano 1,127 91 11/12/2019 22 23000 B.G 96 $30.00 $13.98 $9.50 25% 93% 50 570 1915 B Elite 438 149 12/13/2019 1.9 25000 11.8 10.4 $38.00 $15.87 $7.73 41% 0% 6.0 700 645 Bolt Nano 950 215 12/22/2019 1.0 23000 10.2 7.8 $37.00 $15.79 $8.50 34% 27% 50 850 125% Buzz Elita 804 194 12/6/2010 1.0 25000 122 9.8 $39.00 $16.39 $7.95 37% 6% 5.0 950 105% Coll Thrill 1,338 240 12/11/2010 2.8 17000 6.0 14,0 $19.00 58.40 $4.03 41% 33% 80 1,050 132% City Thrift 1,071 200 12/10/2010 20 17000 6.2 138 $19.00 $8.61 $4.22 379 57% 8.0 1,250 156% Cond Core 1.287 162 12/3/2019 12 18000 8.6 $11.68 S738 30% 93% 6.0 900 191% 110 $27.00 11.5 $28.00 Cute Core 1.414 87 11/19/2019 1.2 20000 9.3 $12.39 S7 38 30% 93% 6.0 950 191% Deal Thrift 1.730 22 6/27/2020 35 14000 5.2 14.8 $20.00 $6.65 $2.82 51% 100% 9.0 1,000 198% Dino Core 1.885 14 11/30/2019 1.2 16000 7.8 122 522.00 $10.01 $5.64 31% 100% 7.0 1,150 198% Dome Nano 700 161 42/22/2019 1.1 18000 9.7 8.5 $31.00 $13.64 $6.24 36% 25% 6.0 750 124% Dug Ente 604 137 41/6/2010 1.1 20000 11.7 10.3 $35.00 $14.36 $7.09 38% BX 50 B00 107% COMP-XM@ INQUIRER Page 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial Theory and Corporate Policy

Authors: Thomas E. Copeland, J. Fred Weston, Kuldeep Shastri

4th edition

321127218, 978-0321179548, 321179544, 978-0321127211

Students also viewed these Finance questions