Excel, Python, Financial Modelling
Send a job offer directly to this candidate
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.
1.
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.
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.
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.
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
