Xiwen(Pansy) Pan

Experience

• 

  China Securities Co., Ltd

  Jul 2021 - Aug 2021

  Investment Banking PTA

  • Collected data from financial statements by constructing Natural Language Processing pipeline (Python) and developed financial analysis framework for fundamental performance of corporate including calculation and monitoring of financial indicators with Python regarding asset-liability structure, cash flows, profitability. • Conducted due diligence on corporate credit, legal relationship risk and restricted assets; concluded 3 major findings that issuer has liquidity risk including large proportion of restricted assets, large interest-bearing liabilities, rising debt ratios, and made risk warnings by estimating 0.17 million expected loss with PD of 0.07%, EAD of 290 million and LGD of 84%. • Wrote bond prospectuses for 3 municipal corporations with 356 million dollars, and successfully raised funds with the lowest interest rate of national comparable bonds. Show less

• 

  China Securities Co., Ltd

  Jun 2022 - Aug 2022

  Research And Development Intern

  • Collected and processed industry data in several financial databases through Python; built real-time dashboard (SQL,Tableau) for tracking data of macroeconomy, industry and market (Technology, Media and Telecom). • Conducted in-depth analysis (Python) of industry market size, industry competitors and profit model for TMT group; completed 3industry research reports on Digital Currency, Internet Data Center, and Meta Universe; reports were published on Wind financial terminal (Most comprehensive financial platform in China). • Built financial models (P/E, DCF) for valuation analysis (VBA) and predicted stock price trend of sector; provided long-term investment advice for institutional clients in secondary market. Show less

• 

  Phalanx Analysis Group

  Aug 2023 - Sept 2023

  Risk Management Intern

  • Conducted background research and collected data (Bloomberg) by constructing Natural Language Processing pipeline; wrote in- depth analysis and built real-time dashboard (SQL,Tableau) employed TAM and VaR. • Utilized financial models including IRR and Payback Period calculations (VBA) and NPV to simulate cash flows and financial condition, offering insights into investment feasibility of 4 million project. • Identified potential risks, applied scenario test (Python) for simulation and conducted analysis on multifaceted risks. Show less