This course covers financial models that apply the new concepts and theories from the finance textbook to real life when managers and investors need to make essential and reliable financial decisions. The basic concepts and functions in information technology and statistics are combined with financial theories to design data processing models to make critical decisions in portfolio management, project risk assessment, option valuation, and hedging. With the support of informatics software in finance, the ability to calculate and process data in financial models is solved quickly and efficiently. Therefore, this is a practical subject with a very high practical significance. The subject focuses on Excel and VBA applications for financial models of 4 critical areas of knowledge, including (1) Corporate financial models. (2) Optimal portfolio models and simulations. (3) Options pricing models and simulations. (4) bond pricing models, investment strategy calculations, and interest rate maturity structures. The course also provides skills related to basic programming in the VBA language to help students build autonomy and expand their knowledge related to quantitative finance to serve career goals and personal development.