1 page conclusion and 2 slides narrated PPT

profileRock$tarGirl
Financials.xlsx

Sheet1

Company Name Baldwin Chester Andrews
Total Assests $ 230,202 $ 88,975 $ 94,224
Total Liabilities $ 80,568 $ 8,901 $ 27,691
Total Equity $ 149,634 $ 80,074 $ 66,533
Emergency Loan
Market Share 29.3% 15.2% 16.4%
Stock Market
Closing Price $ 52.61 $ 41.28 $ 35.53
Outstanding shares 5,366,132 3,321,693 3,350,156
Market Cap (millions) $ 282 $ 137 $ 119
Book Value $ 27.88 $ 24.11 $ 19.86
Cumulative R&D Cycle Time -70% -14% -65%
Top Products Year 8 Low Tech
Name  Price Units Sold Potential Sold Stock Out Age Performance Size Reliability Sales Budget Customer Accessibility Promo Budget Customer Awareness Customer Satisfaction
Able $33.00 1,972 1,728 No 4.5 7.8 12.1 20,000 $1,650 100% $1,400 100% 34
Cake $32.00 1,749 1,492 No 2.5 7.2 13.2 20,000 $600 100% $1,400 100% 38
Baker $35.00 1,357 1,390 Yes 1.8 8.8 11.2 20,000 $1,900 100% $1,900 100% 40
Cone $35.00 1,079 918 Yes 2.6 10.4 11.1 17,050 $2,000 100% $1,400 100% 26
Bold $35.00 891 1,351 Yes 1.8 8.8 11.2 20,000 $1,900 100% $1,900 100% 39
Top Products year 8 High Tech
Name Price Units Sold  Potential Sold Stock Out Age Performance Size Reliability Sales Budget Customer Accessibility Promo Budget Customer Awareness Customer Satisfaction
Bid $45.00 1,513 1,363 Yes 1.7 13 7 23,000 $1,900 100% $1,900 100% 54
Adam $44.00 1,193 1,284 Yes 1.8 13 7 23,000 $1,050 98% $1,400 100% 51
Bead $45.00 1,187 1,395 Yes 1.6 13 7 23,000 $1,900 100% $1,900 100% 55
Cone $35.00 448 248 Yes 2.6 10.4 11.1 17,050 $2,000 100% $1,400 100% 7
Baker $35.00 176 179 Yes 1.8 8.8 11.2 20,000 $1,900 100% $1,900 100% 1
Bold $35.00 123 185 Yes 1.8 8.8 11.2 20,000 $1,900 100% $1,900 100% 1
Chester Performance by Year Round 0/2019 Round 1/2020 Round 2/2021 Round 3/2022 Round 4/2023 Round 5/2024 Round 6/2025 Round 7/2026 Round 8/2027
Stars N/A 5 4 (Profit) 5 0 4 (Em. Loan) 3 (Sales/profit) 4 (cont margin) 5
Total Assests $ 20,903 $ 25,476 $ 32,776 $ 53,068 $ 87,367 $ 59,930 $ 57,908 $ 58,508 $ 88,975
Total Liabilities $ 8,054 $ 8,376 $ 9,386 $ 14,836 $ 45,796 $ 13,262 $ 10,647 $ 6,773 $ 8,901
Total Equity $ 12,850 $ 17,100 $ 23,390 $ 38,232 $ 41,571 $ 46,668 $ 47,260 $ 51,735 $ 80,074
Stock Market
Closing Price $ 11.16 $ 17.92 $ 19.59 $ 25.51 $ 7.10 $ 18.26 $ 20.84 $ 25.56 $ 41.28
Outstanding shares 2,000,000 2,000,000 2,167,448 2,596,134 2,842,103 2,842,103 2,842,103 2,770,129 3,321,693
Market Cap (millions) $ 22 $ 36 $ 42 $ 65 $ 20 $ 52 $ 59 $ 71 $ 137
Book Value $ 6.42 $ 8.55 $ 10.79 $ 14.73 $ 14.63 $ 16.42 $ 16.63 $ 18.68 $ 24.11
Sales $ 40,800 $ 52,491 $ 57,980 $ 82,513 $ 75,360 $ 82,528 $ 40,278 $ 79,931 $ 109,440
Profit $ 2,490 $ 4,251 $ 3,289 $ 6,443 $ (2,141) $ 5,097 $ 592 $ 5,975 $ 14,239
Contribution Margin 19.97% 25.09% 29.87% 35.09% 34.55% 40.24% 41.78% 35.01% 37.49%
Stock Price $ 11.16 $ 17.92 $ 19.59 $ 25.21 $ 7.10 $ 18.26 $ 20.84 $ 25.56 $ 41.28
Emergency Loan $ - 0 $ - 0 $ - 0 $ - 0 $ 29,077.00 $ 2,531.00 $ - 0 $ - 0 $ - 0
Market Share 16.7% 18.7% 18.1% 22.0% 17.6% 17.1% 7.4% 12.8% 15.2%
Expected growth in ten years at current percentage rates
low tech market size 5040 5544 6098 6708 7379 8117 8929 9822 10804 11884 13073 14380 15818 17400 19140 21054 23159 25475 28023
low tech demand growth 10% 10% 10% 10% 10% 10% 10% 10% 10%
high tech market size 2160 2592 3110 3732 4479 5375 6450 7740 9288 10217 11238 12362 13599 14958 16454 18100 19910 21901 24091
high tech demand growth 20% 20% 20% 20% 20% 20% 20% 20% 20%