Course Description:-

INTRODUCTION:

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

Pre-Requisites for Project Finance Modeling Training:

• Basic Computer Knowledge
• Passion to Learn
• Basic idea about Financial Modeling

Target audience for Project Finance Modeling Training

• 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
• Project Finance Modeling Training 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 modeling –

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 area 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.

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

CURRICULUM

Section 1: Basic Excel

1. Getting Started Ribbons Quick Access Toolbar
2. Getting Started Surfing Excel HELP Function
3. Excel Case Study
4. Data Entry in Excel
5. Populating the Case Study in Excel
6. Calculations Addition Subtract Multiply Division
7. Formulas SUM MAX MIN AVERAGE
8. Formatting Number Formats
9. Formatting Table Formats
10. Updating a Calculation
11. Percentages and Absolute References
12. Conditional Formatting
13. IF Function
14. COUNTIF Function
15. SUMIF Function
16. Creating Charts and Graphs
17. Create Pie Charts
18. Sorts
19. Filter
20. Pivot Table
21. Freeze and Split
22. Presentation Table Formats
23. Presentation Indents and Formatting Charts
24. Printing the Worksheet
25. Printing Headers and Titles
26. Shortcuts Formatting and Navigation
27. Shortcuts Selection Data and Formula
28. Common Errors
29. Download all Excel and PDF files

Section 2: Advanced Excel

1. Office Button and Paste Function
2. Spark lines Custom Ribbons and Screenshots
3. Conditional Formatting and Equation Editor
4. Paste Special
5. Logical functions IF AND OR
6. Arithmetic functions MAX MIN ABS etc
7. COUNT COUNTIF COUNTA COUNTBLANK
8. Cell Information ISERROR ISBLANK etc
9. CHOOSE Function
10. VLOOKUP Function
11. HLOOKUP Function
12. MATCH INDEX
13. Database functions DSUM DAVERAGE DCOUNT
14. OFFSET Function Part 1
15. OFFSET Function Part 2
16. FORECAST Function
17. One Dimensional Data Tables
18. Two dimensional Data Tables
19. Solver
20. Goal Seek
21. Array Function Introduction
22. Array Function Row and Columns
23. Array Function TRANSPOSE
24. Array Function FREQUENCY
25. PROPER UPPER LOWER LEFT RIGHT MID
26. FIND CLEAN REPT CONCATENATE
27. Pivot Tables
28. Pivot Table Filter Slicer
29. Pivot Charts
30. Naming a Cell and a Range
31. Naming Dynamic Ranges
32. Auditing Toolbar
33. Watch Window
34. Group Boxes and Options Button
35. Check Boxes
36. List Boxes and Combo Boxes
37. Scroll Bar and Spinners
38. Text to Columns
39. Grouping Tabs
40. SUBTOTAL Function
41. Hyperlinks
42. Data Validation
43. Random Numbers
44. Custom View
45. Protecting Worksheet and Workbook
46. Excel 2010 Spark lines
47. Range Charts Type 1 Part a
48. Range Charts Type 1 Part b
49. Range Charts Area Type 2 Part a
50. Range Charts Area Type 2 Part b
51. Funding Graph
52. Two Axis Graphs
53. Scenario Graphs Part 1
54. Scenario Graphs Part 2
55. Average Line
56. Bar to Pie chart
57. Combo Charts
58. Creating Histogram
59. Invert Negatives
60. Scrolling Chart part 1
61. Scrolling Chart part 2

Section 3: Project Finance – modeling

1. Project Finance Introduction
2. Parties to Project Finance
3. Documentation Part 1
4. Documentation Part 2
5. Project Finance vs Corporate Finance
6. Project Finance vs Structured Finance
7. Human Appraisal
8. Market Appraisal Technical Appraisal
9. Financial Feasibility
10. Land and Building
11. Plant and Machinery
12. Other costs and Preliminary expenses
13. Preoperative Expenses
14. Means of Finance
15. Projections with Analysis and Evaluation
16. DCF based approach
17. NonDCF based approach
18. Construction Phase risk
19. Operation phase risk
20. Market risk
21. Ratios for project evaluation 1
22. Ratios for project evaluation 2
23. Break Even Analysis
24. IRR Calculation
25. BEP Calculation
26. Other ratios
27. Calculation of ratios
28. Sensitivity Analysis
29. Assumptions 1
30. Assumptions 2
31. Project Cost Calculation
32. Capex Schedule 1
33. Capex Schedule 2
34. Capex Schedule 3
35. Capex Schedule 4
36. Capex Schedule 5
37. Capex Schedule 6
38. Income Statement Projections
39. Depreciation Schedule 1
40. Depreciation Schedule 2
41. Working Capital Projections 1
42. Working Capital Projections 2
43. Tax Calculation
44. Calculating Cash Flows
45. Balance Sheet
46. Ratio Analysis
47. Sensitivity Analysis
48. Preparing a Project Finance Report

For any query give a miss call:

08587999769