• Conduct lease encumbered valuations on aircraft transactions and aircraft portfolios, considering aircraft type liquidity and vintage, contractual or projected lease rate, lessee credit quality, remaining lease term and return conditions. Help build valuation models for aircraft future base values.• Collect and analyse historical aircraft transactions. Items recorded include purchase and sale price, monthly lease rate, maintenance reserves, security deposits, and financing information… Show more • Conduct lease encumbered valuations on aircraft transactions and aircraft portfolios, considering aircraft type liquidity and vintage, contractual or projected lease rate, lessee credit quality, remaining lease term and return conditions. Help build valuation models for aircraft future base values.• Collect and analyse historical aircraft transactions. Items recorded include purchase and sale price, monthly lease rate, maintenance reserves, security deposits, and financing information (loans, swaps, EETC and ABS). Analyses mainly focus on the calculation of investor returns and the impact of Covid-19 on aircraft pricing and lease rates.• Conduct in-depth forward-looking research and credit analysis on airlines, by analysing key financial and operating metrics, macroeconomic factors, development strategies, management performances, and shareholding structure. Show less

• Analysed equity indexes such as TAIEX, S&P500, FTSE100, and MSCI by building class module with 100 technical indicators, which can be used for Excel VBA, Python, and MATLAB• Manipulated data from Bloomberg and FactSet using SQL to generate weekly global market reports and index performances for the entire investment division• Created a detailed manual of technical indicators for the investment division

• Audited independently eleven groups for the creation of annual reports in the high-tech industries, the construction industries and the retail sales industries• Managed in generating annual reports and answering accounting inquiries for two corporations in the high-tech sector

• Coordinated with other lecturers to improve the quality of lectures and led members to organise a series of events to promote the club (member increased by 295%)• Designed complex lectures to promote the understanding of financial markets and the causes of the financial crisis for high school students in Taiwan