beBee background
Professionals
>
Singapore
sandy Zhao

sandy Zhao

Excel, Python, Financial Modelling

Accounting / Finance

Singapore

Social


About sandy Zhao:

Highly motivated final year finance student looking for more real-world experiences in a financial role. Familiar with Microsoft excel. Good at collaborating in teams. Flexible individual able to contribute to projects and keep up with ever-changing processes and procedures.

Experience

 Relevant Projects:
1. Financial Analysis of Stocks, August to October 2021
Collected stock data of JPM, NFLX and AAPL, and compared them by calculating the mean and volatility of daily price return, the correlation coefficient and determining the optimised portfolio composition with Excel, as well as evaluating the bond price, the interest rate in the yield curve, the NPV and IRR of investments and the prevailing cost of capital with Python.
2. Managerial Accounting Analysis, February to April 2022
Evaluated the organisational architecture and finance situation of a selected company in real life, including evaluating the manufacturing costs, manufacturing overhead variance, the income statement, the balance sheet and the statement of cash flow, budget planning and overhead allocation for the company.
3. Corporate Finance Analysis, August to October 2022
Prepared 2-years balance sheet from available data set of a selected company, calculated cash flow and amortising loans of the company. Analysed the effect of financial leverage on the company's net income and return on equity, determined the optimal inventory level, and prepared cash budget and short-term financial plan for the company.
4. Portfolio construction and management, February to May 2023 Evaluated a Canadian pension funds' existing asset allocation and portfolio management with the consideration of investor's expectation, risk and return, taxation, legislation, and sustainable investing principles. Proposed a sustainable strategic asset allocation for the entire portfolio of the pension funds based on the evaluation and combined market research and analysis.
Microsoft Excel, Financial Modelling, Python Programming 

Education

Bachelor of Science, Finance, Singapore University of Social Science - Singapore

Final Year student in SUSS, expected to graduate in Dec 2023. 

Lastest SGPA:  3.7/5

Lastest CGPA:3.5/5

Professionals in the same Accounting / Finance sector as sandy Zhao

Professionals from different sectors near Singapore

Other users who are called sandy

Jobs near Singapore

  • Work in company

    Head of Quant

    Newbridge

    We're seeking a skilled Quant Developer to design, develop, and implement quantitative models for derivatives pricing, risk management, and calibration. The ideal candidate will have expertise in quantitative finance, programming, and software development. · Key Responsibilities: ...

    Singapore

    3 days ago

  • Work in company

    Finance Data Analyst Intern

    Apple

    Imagine what you could do here. At Apple, new ideas have a way of becoming extraordinary products, services, and customer experiences very quickly. · ...

    Singapore

    1 month ago

  • At PwC our Financial Services Assurance Practice works with organisations to strengthen trust and transparency by building maintaining and providing trust over financial reporting in a fast changing technology-driven world Responsibilities You will be working in teams to assist y ...

    Singapore

    1 month ago