beBee background
Professionals
>
Accounting / Finance
>
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

See professionals near Singapore

Other users who are called sandy

Jobs near Singapore

  • WHITE ROOK ADVISORY PTE. LTD.

    Admin and Team Coordinator

    2 days ago

    WHITE ROOK ADVISORY PTE. LTD. Singapore

    Roles & Responsibilities · White Rook Advisory ), is proudly headquartered in Singapore and aims to be a leading advisory firm with a unique Asia focus. It provides clients with strategic thinking and It provides clients with strategic thinking and program execution across a full ...

  • Helius

    Chief Data Officer

    4 weeks ago

    Helius Singapur, Singapore $120,000 - $180,000 per year

    Responsibilities · - Design and develop new features from scratch using React Native · - Collaborate with the design team to create scalable and reusable UI components · - Translate wireframes and designs into high-quality code · - Gather feedback from users, analyze metrics, and ...

  • Advanced Micro Devices, Inc.

    Senior Program Manager

    3 days ago

    Direct apply
    Advanced Micro Devices, Inc. Bedok, Singapore

    Back · **Senior Program Manager (Operations Management)**: · - Singapore, Singapore · - Engineering · - 40248 · mail_outline · Get future jobs matching this search · *** · **Job Description**: · **WHAT YOU DO AT AMD CHANGES EVERYTHING** · - We care deeply about transforming lives ...

See jobs in Singapore