"CAPSIM" CORE
Can anyone pleassseee help our team to get rid out from emergency loan? We're in round 6 now and need suggestions!! We have no idea how to get into normal plzzz help us We wanna be in better position. How much common stock should I issue?
CAPSIMCore ZP100118_1 Round 3 -2024 Report Contents Section 1 Research and Development Section 4 Production Section 6 Product Financials Section 2 Marketing Low Tech Section 5 Finance Section 7 Custom Modules Section 3 Marketing High Tech 0.1 High Level Overview Andrews Baldwin Cheste Digby Erie Ferris Average $80,110 $109,040 $62,140 Sales $41,492 $54,431 $26,005 $61,762 Profit $2,139 $1,650 ($1,530) ($2,734) $6,076 $5,019 $1,770 33.63% 26.91% 21.62% 20.20% 27.42% 28.85% 26.44% Contribution Margin $8.15 $3.35 $2.20 $13.18 $23.60 $9.95 Stock Price $9.23 $11,247 $12,551 $3,101 $10,111 Emergency Loan SO $10,843 $22,926 11.1% 14.6% 21.5% 7.0% 29.2% 16.6% 16.7% Market Share Section 1 | Research and Development 1.2 Low Tech 1.3 High Tech Expectations Expectations Importance Customer Buying Criteria Importance Customer Buying Criteria $15.00 - $35.00 41% Positioning Performance 9.5 Size 10.5 33% Price 29% 29% Age 3 Years Age 0 Years 25% Reliability 14,000 - 20,000 Hours 21% Price $25.00 - $45.00 17,000 - 23,000 Hours 13% Positioning Performance 6.3 Size 13.7 Reliability 1.5 Product List 1.4 Perceptual Map Name Performance Size Reliability Age Revision Date 20 Able 7.0 12.9 17,000 4.3 February 13, 2024 Baker 6.0 13.3 18,000 2.3 May 3, 2024 Bead 10.2 9 9 23,000 0.9 January 20, 2024 14 Cake 5.8 13.6 18,150 3.9 April 28, 2023 12 Cedar 3.6 10.5 13.050 10 October 5, 2024 10 Cone R 8 11.2 20,000 0.8 March 18, 2024 Dart 9.0 10.7 20,500 September 11, 2024 Daze 6.4 13.6 21,000 5:1 November 25, 2018 Easy 6.3 13.7 17,000 12 June 9, 2024 Eat 6.4 13.6 21,000 5.1 November 25, 2018 2 4 6 8 10 12 14 16 18 20 Edge 9.5 10.5 18,000 1.0 July 5, 2024 Performance Fast 6.8 13.2 19,000 2.4 March 26, 2024 Future 10.2 9.8 21,000 0.9 June 21, 2024Section 2 | Marketing Low Tech 2.1 Customer Buying Criteria 2.3 Market Share Expectations Importance Price $15.00 - $35.00 41% Ferris Andrews Age 3 Years 29% 14.8 9 15.3 % Reliability 14,000 - 20,000 Hours 21% Positioning Performance 6.3 Size 13.7 9% 2.2 Demand Information Baldwin 15.2 % 2024 Total Market Size 6,708 5,708 Erie 2024 Total Units Sold 23.5 9 2025 Demand Growth Rate 10% Chester Digby 22.1 9% 9.0 9% Andrews . Baldwin O Chester @ Digby @ Erie @ Ferris 2.4 Top Products Customer Units Sold Potential Stock Sales Customer Prom Customer Name Price Out Age Performance Size Reliability Sold Budget Accessibility Budget Awareness Satisfaction 31% 23 Cake $32.50 1,415 1.391 $1,800 No 3.9 5.8 13.6 18,150 $1,80 53% $2,250 100% 16 Able $34.00 62% 1,028 1,033 NO 12.9 17,000 $2,000 75% 18 Baker $33.50 1.018 1,000 NO 23 13.3 18,000 $1,400 35% $1,400 74% 20 Fast $34.50 992 973 No 24 6.8 13.2 19,000 $1,150 42% $1,150 Eat $35.00 884 868 No 6.1 6.4 13.6 21,000 $1,500 78% $1,400 100% 14 Easy $32.50 696 771 Yes 1.2 6.3 13.7 17,000 $2,000 78% $2,000 92% 18 Daze $34.00 $1,200 73% 10 606 595 No 6.4 13.6 21,000 $1,200 31% 10.5 13,050 $1,20 53% $1,20 59% 0 Cedar $39.75 40 40 NO 8.6 N Cone $38.25 30 38 Yes 0.8 8.8 11.2 20,000 $1,900 53% $1,900 69%Section 3 | Marketing High Tech 3.1 Customer Buying Criteria 3.3 Market Share Expectations Importance Positioning Performance 9.5 Size 10.5 33% Andrews 5.2% 29% Ferris Age 18.1 96 Baldwin Price $25.00 - $45.00 25% 13.4 % Reliability 17,000 - 23,000 Hours 13% 3.2 Demand Information 2024 Total Market Size 3,732 2024 Total Units Sold 3,732 20% Chester 2025 Demand Growth Rate 22.5 % Erie 36.6 9 Digby 4.3 % Andrews . Baldwin @ Chester @ Digby @ Erie @ Ferris 3.4 Top Products Prom Customer Customer Name Price Units Sold Potential Stock Sales Customer Age Performance Size Reliability Sold Out Budget Accessibility Budget Awareness Satisfaction 80% $2,000 92% 34 Edge $45.00 845 771 No 9.5 10.5 18,000 $1,80 $1,900 69% 35 Cone $38.25 564 686 Yes 11.2 20,000 $1,900 62% 50% 17 Future $45.00 406 408 NO 0.9 10.2 9.8 21,000 $1,400 61% $1,400 $2,000 46% $2,000 70% 22 Bead $45.00 307 263 No 0.9 10.2 9.9 23,000 92% 16 Easy $32.50 294 292 Yes 1.2 6.3 13.7 17,000 $2,000 80% $2,000 Fast $34.50 268 235 No 2.4 6.8 13.2 19,000 $1,150 61% $1,150 74% 100% Eat $35.00 226 197 NO 6.1 6.4 13.6 21,000 $1,500 80% $1,400 46% $1,400 75% Baker $33.50 194 169 No 2.3 13.3 18,000 $1,40 12.9 17,000 $2,000 53% $2,250 100% Able $34.00 193 178 No 4,3 81% Cake $32.50 159 140 No 5.8 13.6 18,150 $1,800 62% $1,800 3.9 $1,20 Daze $34.00 159 139 No 64 13.6 21,000 $1,200 39% 73% 116 101 No 8 6 10.5 13,050 $1,200 62% $1,200 59% Cedar $39.75Section 4 | Production Production vs Capacity 1,485 Andrews 950 1,708 Baldwin 1,400 2,921 2,150 Chester 1,287 Digby 1,450 3,763 2,400 Erie 1,980 Ferris 1,400 2250 2500 2750 3000 3250 3500 3750 4000 2000 250 500 750 1000 1250 1500 1750 Production Capacity 4.1 Plant Information Name Primary Segment Units Produced Units Sold Inventory Price Material Cost Labor Cost Contribution Margin Auto. Next Round Capacity Next Round Plant Utilization $34.00 $12.25 $9.10 33.6% 1,200 158% 265 Able Low Tech 1,48 1,220 29.7% 800 138% Baker Low Tech 1.089 1,212 283 $33.50 $11.18 $11.11 $20.28 $11.68 18.7% 2.6 600 104% Bead High Tech 619 307 312 $45.00 3 1.250 152% 1.584 1,574 58 $32.50 $10.71 $11.44 29.7% Cake Low Tech 750 107% 743 157 994 $39.75 $15.12 $12.6 -23.6% 1.5 Cedar High Tech 150% $15.06 15.7% 16 400 Cone High Tech 594 594 $38.25 $16.67 0% 3.4 800 0% 0 $42.00 $0.00 $0.00 Dart High Tech 0 163% 707 $34.00 $12.14 $11.64 20.2% 1,000 Daze Low Tech 765 N CO 1,287 125% $32.50 $10.74 $12.79 28.4% 850 Easy Low Tech 190 990 $11.87 23.5% 3.5 1,100 200% Low Tech 1,782 301 $35.00 $12.14 Eat 1,109 750 143% N 990 345 145 $45.00 $17.48 $13.35 30.6% Edge High Tech 31.1% 1,200 $12.34 $10.58 3.5 145% Fast Low Tech 1,436 1,260 176 $34.50 138% 406 138 $13.20 23.6%% 600 545 $45.00 $19.78 Future High TechSection 5 | Finance 5.1 Income Statement Andrews Baldwin Chester Digby Erie erris $41,492 $54,431 $80, 110 $26,005 $109,040 $61,762 Sales Variable Costs $15,737 $20,859 $9,831 $39,138 Direct Material $30,284 $24,205 Direct Labor $11,102 $16,925 $29,022 $8.849 $37,099 $18,699 $699 $1,999 $2.071 Inventory Carry $3,484 $2,900 $1.041 $43,945 Total Variable Costs (Labor, Material, Carry) $27,538 $39,782 $62,789 $20,752 $79,138 Contribution Margin $13,954 $14,649 $17,321 $5,253 $29,902 $17,817 Period Costs Depreciation $2,400 $1,616 $2,431 $2,245 $2,960 $2,160 SG&A $120 $969 $694 $945 R&D $390 $700 Promotions $2,250 $3,400 $4,900 $1,700 $5,400 $2,550 $2,000 $3,400 $4,900 $1,700 $5,300 $2,550 Sales $760 $987 $1,48 $415 $1,979 $1,082 Administration Total Period Costs $7,530 $9,793 $14,682 $6,754 $16,584 $9,042 $4.855 $8,775 Net Margin $6,424 $2,639 ($1,502) $13,318 Other (Fees/Write-offs/Bonuses/Relocation Fee) $645 $39 $690 $100 SO $212 EBIT $5,779 $4,817 $1,949 ($1,602 $13,318 $8,563 $2,422 $2,226 $4,303 $2,605 $3,780 $683 Interest (Short term/Long Term) $3,338 $2,758 Taxes $1,175 $907 ($824) ($1,472) SO $124 10 Profit Sharing $44 $34 Net Profit $2,139 $1.650 ($1,530) ($2,734) $6,076 $5,019 5.2 Cash Flow Statement Andrews Baldwin Chester Digby Erie Ferris Starting Cash Position $3,861 SO SO $2,116 $1,043 $7,770 Cash From Operations Net Income(Loss) $2,139 $1,650 ($1,530) ($2,734) $6,076 $5,019 Adjustment For Non-Cash Items Depreciation $2,400 $1,616 $2,431 $2,245 $2,960 $2,160 Extraordinary Gains/Losses/Write-offs SO $24 SO SO SO $175 Changes In Current Assets And Liabilities ($83) $1,623 $2,032 ($80) $2,551 $1,277 Accounts Payable $5,825) ($7,012) ($15,827) $12,636) $20,889) $8,674) Inventory Accounts Receivable ($131) ($1,142) ($2,041) $944 ($1,984) ($728) ($771) Net Cash From Operations ($1,501) $3,242) ($14,936) ($12,260) ($11,286) Cash From Investing ($12,440) ($1,680) ($6,560) ($6,540) ($9,480) ($7,600) Net Plant Improvements Cash From Financing SO SO SO SO ($836) Dividends Paid Sales Of Common Stock SO SO $3,000 $2,000 $O Purchase Of Common Stock $O SO SO SO SO SO SO Cash From Long-Term Debt Issued $12,900 $10,800 SO SO ($1,000) SO so SO ($2,500) Early Retirement Of Long-Term Debt Retirement Of Current Debt ($9,700) ($5,325) ($11,148) $1,867) ($2,367) $O Cash From Current Debt Borrowing $9,000 SO $8,000 $4,000 SO SO Cash From Emergency Loan SO $11,247 $10,843 $12,551 $22,926 $3, 101 Net Cash From Financing $12,200 $4,922 $21,496 $16,685 $19,723 $601 SO SO SO SO SO SO Effect Of Exchange Rates SO ($2,116) ($7,770) Net Change In Cash ($1,741) SO ($1,043) Ending Cash Position $2,120 SO SO SO SO5.3 Balance Sheet Andrews Baldwin Chester Digby Erie Ferris $2,120 SO SO SO SO Cash SO Accounts Receivable $3,410 $4,474 $6,584 $2,137 $8,962 $5,076 Inventory $5,825 $16,656 $29,030 $17,262 $24,170 $8,674 Current Assets $11,356 $21,130 $35,614 $19,400 $33,132 $13,751 Plant and Equipment $36,000 $24,240 $36,460 $33,680 $44,400 $32,400 Accumulated Depreciation ($9,731) ($8,336) ($10,097) ($8,965) ($11, 108) ($9,680) Fixed Assets $26,269 $15,904 $26,363 $24,715 $33,292 $22,720 Total Assets $37,625 $37,034 $61,977 $44,114 $66,424 $36,471 Accounts Payable $2,685 $3,687 $6,175 $2,574 $7,983 $4,239 Current Debt $9,00 $11,247 $18,843 $16,551 $22,926 $3,101 Current Liabilities $11,685 $14,929 $25,019 $19,125 $30,909 $7,341 Long-Term Liabilities $12,957 $4,357 $15,633 $4,333 $4,333 $1,991 Total Liabilities $24,642 $19,286 $40,652 $23,459 $35,242 $9,332 Common Stock $2,323 $2,32 $8,72 $6,323 $10,023 $2,323 Retained Earnings $10,660 $15,425 $12,602 $14,332 $21,159 $24,816 Total Equity $12,983 $17,748 $21,325 $20,656 $31,182 $27,13 Total Liabilities & Equity $37,625 $37,034 $61,977 $44,114 $66,424 $36,471 5.4 Stock Market Summary Company Closing Price Change Shares Outstanding Market Cap Book Value EPS Dividend Yield P/E Andrews $9.23 $6.04 2,000,000 $18m $6.49 $1.07 0.00 0% 8.63 Baldwin $8.15 $2.13) 2,000,000 $16m $8.87 $0.83 $0.00 9.88 $3.35 ($6.71) 2,564,142 $9m $8.32 $0.60) $0.00 1% -5.61 Chester Digby $2.20 ($15.09) 2,262,372 $5m $9.13 ($1.21) $0.00 1% -1.82 Erie $13.18 ($2.52 2,611,908 $34m $11.94 $2.33 $0.32 2.4% 5.67 Ferris $23.60 $0.71 2,000,000 $47m $13.57 $2.51 $0.00 0% 9.40 5.5 Stock Price $30 22.89 23.6 $20 17.53 17.28 15.7 14.24 13.18 11,16 9.96 10.28 $10 9.23 6.35 3.18 2 2 50 2022 2023 2024 2025 2026 2027 2028 2021 Andrews + Baldwin Chester Digby Erie Ferris 5.6 Bond Market Summary Company Series Face Value Yield Closing Price S&P Rating 13.082027 $57,17 12.91% $100.71 C Andrews 11.682034 $12,900,000 12.35% $93.96 C 12.082025 $756,869 11.95% $100.45 CCC Baldwin 13.052027 $2,600,00 12.54% $103.63 CCC 10.052032 $1,000,000 10.82% $92.42 CCC 12.052025 $1,733,333 12.08% $99.38 C 13.052027 $2,600,000 12.91% $100.71 C Chester 10.052032 $500,000 11.51% $86.91 C $10,800,000 $92.31 C 11.382034 12.24%% 12.082025 $1,733,333 11.96% $100.36 CCC Digby 13.052027 $2,600,000 12.57% $103.39 CCC 12.052025 $1,733,333 11.96% $100.36 CCC Erie 13.052027 $2,600,000 12.57% $103.39 CCC 13.052027 $1,990,924 11.78% $110.40 AAA Ferris Next Year's Prime Rate: 7% 5.7 Net Profit\fSection 6 | Product Financials 6.1 Andrews Income Statement Able Total $41,492 $41,492 Sales $27,538 $27,538 Variable Cost $7,530 $7,530 Fixed Cost $6,424 $6.424 Net Margin Other (Fees, Writeoffs) $645 Long Term Interest $1,504 Taxes & Tariffs $1,175 Profit Sharing $44 Net Profit $2,139 6.2 Baldwin Income Statement Baker Bead Total $54,431 Sales $40,619 $13,812 Variable Cost $28,546 $11,236 $39,782 $4,833 $9,793 Fixed Cost $4,960 Net Margin $7,239 ($2,384) $4,855 Other (Fees, Writeoffs) $39 Long Term Interest $529 Taxes & Tariffs $907 Profit Sharing $34 Net Profit $1,650 6.3 Chester Income Statement Cake Cedar Cone Total Sales $51,165 $6,221 $22,724 $80,110 Variable Cost $35,948 $7,691 $19,150 $62,789 Fixed Cost $6,046 $3.876 $4,759 $14,682 Net Margin $9.171 ($5,346) ($1,185) $2.639 Other (Fees, Writeoffs) $690 Long Term Interest $1,816 Taxes & Tariffs ($824) Profit Sharing SO Net Profit ($1,530) 6.4 Digby Income Statement Daze Dart Total $26,005 SO $26,005 Sales $20,752 Variable Cost $20,752 $6,754 Fixed Cost $4,015 $2,739 Net Margin $1,238 ($2,739) ($1,502) Other (Fees, Writeoffs) $100 Long Term Interest $546 Taxes & Tariffs ($1,472) Profit Sharing SO Net Profit ($2,734) 6.5 Erie Income Statement Eat Edge Easy Total $32,180 $109,040 Sales $38,831 $38,029 Variable Cost $29,697 $26,393 $23,048 $79,138 $16,584 Fixed Cost $5,071 $5,699 $5,814 Net Margin $4,062 $5,937 $3,319 $13,318 Other (Fees, Writeoffs) SO Long Term Interest $546 Taxes & Tariffs $3,338 Profit Sharing $124 Net Profit $6,0766.6 Ferris Income Statement Fast Future Total Sales $43,470 $18,292 $61,762 $29,963 $13,981 $43,945 Variable Cost $4,892 $4,150 $9,042 Fixed Cost Net Margin $8,614 $161 $8,775 Other (Fees, Writeoffs) $212 Long Term Interest $259 Taxes & Tariffs $2,758 Profit Sharing $102 Net Profit $5,019Section 7 | Custom Modules 7.1 Workforce Summary Erie Ferris Andrews Baldwin Chester Digby 348 632 250 794 387 227 Number of Employees 272 144 278 446 154 511 115 First Shift 70 186 96 283 83 0% 0% Second Shift 0% 0% 0% 0% 10.0% Overtime % 10.0% 10.0% 10.0% 10.0% 10.0% 343 156 Turnover Rate 280 25 23 171 New Employees 0 0 23 Separated Employees 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Productivity Index
