This is a online course is to gain comprehensive practical understanding of Project Finance Modeling. The aim is to learn essential concepts in Project Finance Modeling. The tutorials will help you learn about basic and advanced excel lessons, project finance concepts and terminologies, calculation of ratios, project finance modeling, feasibility analysis and preparation of project finance report. For any large construction there is a huge finance that is required. One has to arrange those huge amount and they have 2 ways of financing that huge amount that is through corporate finance or project finance. Project finance is the financing of this long term, projects based upon a non-recourse or limited recourse financial structure, where the debt and equity are paid back from the cash flow generated from the project. Through this course we will understand about project finance in detail where first we will start understanding about excel and then move to understanding about project finance concepts and project finance modeling. This course will help you to have conceptual clarity and you will also be able to apply these concepts and prepare a project finance model on a live company i.e. JSW steel which will be evaluated by the Research Analyst Team of CB research
Target audience
- Heads of Project Finance
- Heads of Corporate Finance
- Heads of Structured Finance
- Treasurers
- Project Managers
- Accountants Analysts
- Sales Managers
- Students
- Investment bankers
- Fund managers
- Finance professionals
- Course highlights
Basic & Advanced Excel –
Excel being very important in a person’s life one should have a hand on excel. A project finance model is built on excel. So in order to learn to build model knowledge of excel is a must.
Through this module we will learn about functions in excel like if, and, or function, Conditional Formatting, COUNTIF and SUMIF, Freeze and Split, Data Functions, how to create Group Boxes and Options Button, Scroll Bar and Spinners. We will learn to create different graphs and charts in excel.
Project finance is only possible when the project is capable of producing enough cash which covers all debt servicing expenses and operating expenses during the entire period of debt. In order to analyze the future cash flows one prepares a project finance model. In order to prepare a model assumptions play a very important role. So through this module you will learn what the different parameters one are should look for before any assumption, how to prepare a full-fledged project finance model etc. We will also understand different project finance concepts like Project Finance Appraisal, Elements of project cost, different Decision Making Tools, Risk Analysis in Project Finance, and Important Ratios for Project Evaluation etc.