Conducted an in-depth financial analysis, covering key metrics such as Revenue, Revenue Growth Rate, EBITDA, Net Profit Attributable, and ROE. Employed the DCF model, enriched by insights from leading Chinese securities firms, arriving at a more grounded stock price estimate of around ¥1875, challenging some overvalued perspectives. Leveraged Excel to holistically evaluate Kweichow Moutai's production cycle, historical base wine output, distribution channels, and product sales structures, predicting the company's future saleable products and refining revenue andprofit projections. Compiled a comprehensive 25-page analysis report, encompassing industry background, company history, and financial performance, backed by advanced Excel techniques for business analysis. Transformed intricate financial data into clear, visual presentations, ensuring clearer communication and understanding among supervisors and team members.

 Performed regression analysis and visualizations using Excel and Tableau to draw insights about potential investment and partnership opportunities. Implemented creative search strategies to source opportunities in the hybrid work area, profiled and evaluated startups based on investment criteria, and ensured database integrity by checking for duplicates. Collected and analyzed various indicators of a deal's potential. Evaluated the potential for a good investment or partnership and justified decisions with clear, coherent, and compelling rationale. Provided a comprehensive rating of startups based on the analysis. Synthesized all research and analysis into a cohesive and persuasive final presentation. Created a 7-10 slide deck and delivered a 4-minute presentation showcasing the culmination of the externship projects. Successfully met all task submission by the tight deadlines and received positive feedback and 'stars' from the Program Manager based on evaluation criteria.