Financial Modelling

The benefits to using spreadsheet modeling for financial management and valuation are undisputed in the world of finance. Our training on Financial modeling will provide you with the skills you need to build models and provide you with practical financial modeling techniques. This two-day course provides a hands-on introduction to three essential classes of financial models: corporate finance models, risk management models, and structured finance models. Participants will be introduced to the theory, accounting and technical implementation of all three types of models. Applications covered for each class of model are: • Corporate finance: ratio analysis of financial statements; pro-forma projections; entity and project valuation • Risk management: discount rate risk; probabilistically-measured risk • Structured finance: mortgage-backed securities (MBS); generalized asset-backed securities. Anyone who needs a basic understanding of the main financial models in use today. This includes: managers who are exposed to one or more of these model types; workers making a career transition into finance, or into a new area of the finance industry; recent graduates who want to jump start their career growth in the finance industry; and students who are new to finance or modeling.PROGRAMME CONTENTS: DAY- 11.Spreadsheets for Designing Financial Loans and Repayment Schedule2.Spreadsheets for Loan Amortisation3.Use of Spreadsheets in Quantitative TechniquesDAY - 21. Modelling financial statements2.Valuation Models3.Risk Models & Value at Risk4.Counter party Credit Risk & Interest Rate Products Modelling