CAPSIM BALDWIN competitiion R1 - Round: 1 Dec. 31, 2021...

This preview shows page 1 - 4 out of 15 pages.

Round: 1Dec. 31,2021C121285AndrewsLeimiaojie CHENXiangdong GUZhizhen HUANGPeigen PUDi WANGZiran ZHANGBaldwinYip Ming CHAUFuk Wai CHENGYanyan LUOJames Horace TOKa Fai TSUIShuk Ching WONGChesterChongfeng Evan CHENShengjun Brooke HEShulin Forest HESicong Chris WANGWen Wen WUWei Tara ZHANGDigbyGeneric02 2020Generic03 2020Choi Teng HOWun Yin Michel LAUYiwen Yvette LIJiangning ZHOUErieQiong Joany CHENYan DAIHengyuan Harris FENXiaofeng Ben FUZijun Michael MAIChuanzi Amber ZHOUFerrisSelected Financial StatisticsAndrewsBaldwinChesterDigbyErieFerrisROS-3.9%-0.4%-4.1%-0.5%-5.4%-6.1%Asset Turnover0.911.190.810.980.860.91ROA-3.6%-0.5%-3.3%-0.5%-4.6%-5.6%Leverage2.31.92.91.93.02.4ROE-8.2%-0.9%-9.4%-1.0%-13.9%-13.5%Emergency Loan$12,369,785$0$33,707,280$0$18,436,648$0Sales$111,905,570$134,920,565$108,085,520$111,501,871$108,585,034$120,882,027EBIT$1,477,187$4,741,007$4,143,040$4,845,820$807,541($2,752,194)Profits($4,407,949)($570,695)($4,395,478)($594,217)($5,837,311)($7,351,185)Cumulative Profit($219,442)$3,617,812($206,971)$3,594,290($1,648,804)($3,162,678)SG&A / Sales19.2%17.8%12.9%14.3%19.3%20.9%Contrib. Margin %27.8%27.0%25.4%26.7%27.3%27.6%CAPSTONE ® COURIERPage 1
Stock & BondsC121285Round: 1Dec. 31, 2021Stock Market SummaryCompanyCloseChangeSharesMarketCap($M)Book ValuePer ShareEPSDividendYieldP/EAndrews$18.38($15.87)2,291,939$42$23.36($1.92)$0.000.0%-9.6Baldwin$30.92($3.33)2,399,957$74$25.45($0.24)$0.000.0%-130.6Chester$6.02($28.23)2,087,582$13$22.30($2.11)$0.000.0%-2.9Digby$30.88($3.37)2,399,957$74$25.44($0.25)$0.000.0%-125.2Erie$9.27($24.99)2,000,000$19$21.05($2.92)$0.000.0%-3.2Ferris$19.62($14.63)2,399,957$47$22.62($3.06)$0.000.0%-6.4Bond Market SummaryCompanySeries#FaceYieldClose$S&PCompanySeries#FaceYieldClose$S&PAndrewsDigby11.0S2022$6,950,00011.1%98.67CC11.0S2022$6,950,00011.0%99.73BB12.5S2024$13,900,00012.5%100.00CC12.5S2024$13,900,00012.1%102.92BB14.0S2026$20,850,00013.3%105.34CC14.0S2026$20,850,00012.7%109.90BB11.3S2031$8,000,00012.1%93.36CC11.3S2031$3,000,00011.3%100.00BBBaldwinErie11.0S2022$6,950,00011.0%99.73BB11.0S2022$6,950,00011.2%98.06C12.5S2024$13,900,00012.1%102.92BB12.5S2024$13,900,00012.7%98.35C14.0S2026$20,850,00012.7%109.90BB14.0S2026$20,850,00013.6%102.80CChesterFerris12.5S2024$13,817,48812.7%98.59C11.0S2022$6,950,00011.2%98.49CC14.0S2026$20,850,00013.6%103.16C12.5S2024$13,900,00012.6%99.53CC14.0S2026$20,850,00013.4%104.61CC11.3S2031$18,994,00012.2%92.31CCNext Year's Prime Rate7.50%CAPSTONE ® COURIERPage 2
Financial SummaryC121285Round: 1Dec. 31, 2021Cash Flow Statement SurveyAndrewsBaldwinChesterDigbyErieFerrisCashFlows from operating activitiesNet Income(Loss)($4,408)($571)($4,395)($594)($5,837)($7,351)Adjustment for non-cash items:Depreciation$6,667$6,560$9,080$7,827$7,680$8,685Extraordinary gains/losses/writeoffs$537$457($33)$240$170$532Changes in current assets and liablilitiesAccounts payable$1,395$2,011$1,552$1,232$2,401$713Inventory($19,635)($8,065)($21,968)($16,293)($35,696)($2,551)Accounts Receivable($10,088)($2,782)($576)($857)($617)($1,628)Net cash from operations($25,533)($2,391)($16,341)($8,446)($31,900)($1,600)Cash flows from investing activitiesPlant improvements(net)($8,270)$5,810($26,800)($8,640)($4,970)($32,685)Cash flows from financing activitiesDividends paid$0$0$0$0$0$0Sales of common stock$10,000$13,700$3,000$13,700$0$13,700Purchase of common stock$0$0$0$0$0$0Cash from long term debt issued$8,000$0$0$3,000$0$18,994Early retirement of long term debt$0$0($7,000)$0$0$0Retirement of current debt$0$0$0$0$0$0Cash from current debt borrowing$0$2,000$10,000$0$15,000$10,000Cash from emergency loan$12,370$0$33,707$0$18,437$0Net cash from financing activities$30,370$15,700$39,707$16,700$33,437$42,694Net change in cash position($3,434)$19,119($3,434)($386)($3,434)$8,409Balance Sheet SurveyAndrewsBaldwinChesterDigbyErieFerrisCash$0$22,553$0$3,048$0$11,843Accounts Receivable$18,395$11,089$8,884$9,165$8,925$9,936Inventory$28,253$16,683$30,586$24,910$44,314$11,168Total Current Assets$46,648$50,325$39,470$37,123$53,238$32,946Plant and equipment$110,800$98,400$140,600$117,400$115,200$135,320Accumulated Depreciation($33,867)($35,360)($47,013)($40,960)($42,213)($35,985)Total Fixed Assets$76,933$63,040$93,587$76,440$72,987$99,335Total Assets$123,582$113,365$133,056$113,563$126,225$132,281Accounts Payable$7,978$8,594$8,135$7,815$8,984$7,296Current Debt$12,370$2,000$43,707$0$33,437$10,000Total Current Liabilities$20,348$10,594$51,842$7,815$42,421$17,296Long Term Debt$49,700$41,700$34,667$44,700$41,700$60,694Total Liabilities$70,048$52,294$86,510$52,515$84,121$77,990Common Stock$28,360$32,060$21,360$32,060$18,360$32,060Retained Earnings

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 15 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Dr. Chang

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture