Description
Welcome to the "Project Finance Mastery" course, where we embark on a journey to unravel the complexities of project finance. In this dynamic learning experience, participants will delve into the fundamental principles and practical applications that underpin successful project financing. Whether you are a budding finance professional, an entrepreneur, or someone keen on understanding the intricacies of funding major projects, this course is designed to equip you with the knowledge and skills essential for navigating the world of project finance.
Our course begins with a foundational exploration of project finance basics, offering a solid theoretical framework. We then seamlessly transition into the practical aspects, providing hands-on exercises and real-world examples to deepen your understanding. From market analysis to financial modeling, each section is crafted to ensure a holistic learning experience.
This course includes
- 40+ hours on-demand video
- Unlimited Access, Anytime, on mobile and TV
- Certificate of completion
Project Finance Basics
This section serves as the cornerstone, introducing learners to the core concepts of Project Finance. Participants will gain a thorough understanding of market analysis, project feasibility, cost estimation, and financial projections. Assumptions for financial projections and the calculation of a company's source of income are explored. The focus is on laying a solid theoretical foundation for project financing.
Project Finance Practical
Building on the theoretical knowledge from Section 1, this practical section immerses learners in real-world scenarios. Through exercises and examples, participants delve into the intricacies of bank financing terms, equity components valuation, market risk premiums, and the cost of debt and equity. The section emphasizes a hands-on approach, allowing participants to navigate complexities in areas such as retail banking, amortization schedules, and equity installment settlements.
Project Finance Modeling
The final section of the course is dedicated to honing the skill of project finance modeling. Participants are guided through the practical steps of creating detailed financial models, covering everything from feasibility analysis to sensitivity analysis. The focus is on developing competence in constructing comprehensive models, including cash flow analysis, IRR and NPV calculations, and ratio analysis. By the end of this section, participants will be well-equipped to handle the intricacies of project financial modeling.
Course Curriculum
- Accessing MS Excel (2:41)
- MS Excel Startup Screen (2:27)
- Understanding the Ribbon (3:03)
- Cells in Excel (1:18)
- Worksheet Essentials (3:10)
- Saving the File (1:14)
- Formatting Cells (14:23)
- Custom Cell Styles (6:12)
- Custom Number Formatting in Excel (11:39)
- More on Custom Number Formatting (10:59)
- Custom Formats of Data (13:33)
- The BEDMAS Order of Mathematical Operations (9:04)
- Mathematical Operations without Functions (9:43)
- Mathematical Operations without Functions Continued (11:38)
- IF Function (10:32)
- More on IF Function (8:25)
- Importing Data and Calculations (10:46)
- Working with the Count Function (12:40)
- Conditional Counts - CountIF Function (4:58)
- Working with the Sum Function (14:02)
- Finding the Average (11:17)
- Conditional Average - Average IFS Function (8:31)
- Finding the Maximum Value Using the MAX Function (8:36)
- Finding the Minimum Value Using the MINFS Function (8:04)
- Determining Proportions and Updating a Calculation (10:06)
- Conditional Formatting (18:24)
- More on Conditional Formatting (7:47)
- Working with Tables (13:03)
- Formatting Table (13:31)
- Filtering and Sorting of Data (9:40)
- Freeze and Split (11:18)
- Printing and Layouts in Excel (9:51)
- Pivot Tables (7:50)
- Creating Custom Tables (8:58)
- Organizing Pivot Tables (8:35)
- Column Chart (10:32)
- Bar Chart (8:03)
- Line Chart (14:24)
- Pie Chart (10:27)
- Map Chart (6:46)
- Common Errors in Excel (11:12)
- More on Common Errors (13:42)
- Logical Function - IF (8:21)
- AND OR and XOR Functions (8:41)
- IFS Function - Example 1 (6:25)
- IFS Function - Example 2 (9:02)
- SWITCH Function (10:17)
- Other Logical Functions (8:20)
- Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
- Date Functions - TODAY DAY (9:36)
- MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
- EDATE and EOMONTH Functions (8:38)
- YEARFRAC Function (7:19)
- Joining Data using CONCAT and TEXTJOIN (9:59)
- LEN FIND LEFT RIGHT TRIM (10:26)
- Using UNIQUE and TRANSPOSE (11:27)
- TEXT Function (10:00)
- CHOOSE Function (10:46)
- More on CHOOSE Function (6:34)
- VLookUp Function (12:47)
- HLOOKUP Function (5:12)
- Index Function (10:31)
- Match Function (9:24)
- XLOOKUP and XMATCH Functions (8:43)
- Using the OFFSET Function (8:49)
- OFFSET Function - Total and Average Score (9:29)
- OFFSET Function - Highest and Lowest Score (8:57)
- OFFSET Function - Year to Month Sales (11:01)
- OFFSET Function - Quarterly and Half-Month Sales (6:39)
- Naming of Cell (12:30)
- Naming a Range (10:01)
- Text to Columns (6:35)
- Grouping Tabs and Subtotal Function (12:47)
- Working with Hyperlinks (11:17)
- Data Validation (11:00)
- Data Validation Continued (11:14)
- Custom Data Validation (12:17)
- Generating Random Numbers (6:10)
- Custom Views (10:34)
- Protecting Worksheet and Workbook (17:36)
- PivotTable - Advanced Features (10:02)
- More on Advanced Features (6:50)
- Slicers and Timelines (6:43)
- Solver (11:37)
- Data Tables (10:42)
- More on Data Tables (9:53)
- Goal Seek (8:43)
- Combo Charts (13:51)
- More on Combo Charts (12:11)
- Sparklines (8:10)
- Waterfall Chart (9:37)
- Box Chart (12:48)
- Whisker Chart (11:29)
- TreeMap and Sun Burst Charts (11:53)
- Radar Chart (7:55)
- Scroll Bar (10:00)
- Spin Button and Radio Button (10:52)
- Form Control Application (10:01)
- Form Control Application Continued (5:32)
- Data Entry Form (3:44)
- Case Study Overview (8:34)
- AND-OR (6:56)
- SUM-MOD-SUMIF (9:38)
- SUMIFS-AVERAGEIF-AVERAGEIFS (8:47)
- VLOOKUP-INDEX-MATCH (8:58)
- HLOOKUP-LEFT-RIGHT-MID-LEN (12:13)
- Histogram (10:00)
- Sparklines (5:16)
- Thermometer Chart (6:55)
- Scatter Plot (5:56)
- Creating a Pivot Table (9:30)
- Advanced usage of Pivot Tables (6:02)
- Using What If Analysis (6:00)
- Data Tables (7:48)
- Department Data Validation (8:47)
- Introduction to Macros (8:06)
- Continuing with Macros (9:15)
- Running a Macro (7:42)
- Recorder Problems (11:30)
- Using Message Boxes (7:36)
- Message Box Statement (5:35)
- An Introduction To Financial Accounting (0:48)
- Purpose Of Financial Statements (3:16)
- Explaining A Business Cycle (2:16)
- Accounting For Income Statement (9:31)
- Accounting For Balance Sheet 1 (7:47)
- Accounting For Balance Sheet 2 (9:53)
- Accounting For Balance Sheet 3 (6:24)
- Accounting For Cash Flows (5:20)
- Conclusion (0:28)
- Financial Statements - Fiscal Year Vs Calendar Year (6:34)
- Income Statement Format (8:23)
- Calculating Profit Margins (2:33)
- Non Recurring Items (9:10)
- Changes In Accounting Estimates (3:00)
- Final Remarks (3:09)
- Revenue Recognition Percentage Completion and Completed Contract (11:30)
- Revenue Recognition Installment Method and Cost Recovery (6:22)
- Depreciation Expense (10:40)
- Downloading Colgates Income Statement (12:21)
- Analyst Format Of Colgate-S Income Statement (3:17)
- Formatting The Income Statement (2:39)
- Investigating The Non-Recurring Charges (4:58)
- Seperating non-recurring Items (7:07)
- Comparision Of Margins - Before And After Adjustments (3:34)
- Introduction to Balance Sheet (3:35)
- Introduction to Current Assets (1:56)
- Cash And Cash Equivalents (3:30)
- Cash And Cash Equivalents - Colgate, PandG, Microsoft (6:05)
- Accounts Receivables (1:50)
- Accounts Receivables Case Study (10:36)
- Inventory (3:02)
- Inventory - Case Study (2:08)
- Inventory - Lcm (5:52)
- Inventory - Colgate (2:27)
- Inventory Valuations (8:33)
- Inventory Valuation - Recap (2:59)
- Prepaid Expenses (2:23)
- Other Current Assets - Colgate (1:39)
- Financial Reporting Standards (7:42)
- Current Liabilities (2:18)
- Current Liabilities - Colgate (4:51)
- Long Term Assets (7:50)
- Introduction to Goodwill (6:37)
- Pooling Method Of Accounting (1:51)
- Purchase Method Of Accounting (9:09)
- Goodwill Impairment (3:56)
- Long Term Investments Part 1 (3:03)
- Long Term Investments part 2 (7:31)
- Long Term Investments - Example (2:53)
- Long Term Liabilities (5:52)
- Long Term Liabilities - Risk Profile (3:28)
- Introduction to Shareholder-s Equity (6:39)
- Common Stock - Par Value And Apic (4:31)
- Treasury Stock or Shares (4:48)
- Retained Earnings and Dividends (4:30)
- Additional Other Comprehensive Income (6:30)
- Introduction to Preference Shares (3:56)
- Macdonald-S Shareholder-S Equity (3:08)
- Dividends - Types (2:34)
- Cash And Property Dividend - Example (5:32)
- Stock Dividends (3:37)
- Small and Large Stock Dividends - Example (5:42)
- Stock Split (3:06)
- Introduction To Cash Flows (7:19)
- Cfo - Direct Method (6:05)
- Cfo - Direct Method - Continued (9:33)
- Cfo - Direct Method - Example (7:46)
- Cfo - Indirect Method (5:37)
- Cfo - Indirect Method - Example (5:22)
- Cfi (8:09)
- Cff (0:59)
- Comprehensive Example - Cfo - Direct Method - 1 (8:09)
- Comprehensive Example - Cfo - Direct Method - 2 (3:48)
- Comprehensive Example - Cfo - Indirect Method (5:59)
- Comprehensive Example - Cfi (4:12)
- Comprehensive Example - Cff (3:05)
- Comprehensive Example - Ending Cash Balance (2:09)
- Horizontal and Vertical Analysis (7:05)
- Income Statement - Horizontal and Vertical Analysis - Example (8:01)
- Balance Sheet - Vertical Analysis - Example (6:37)
- Introduction to Ratio Analysis (2:24)
- Activity Ratios (6:24)
- Activity Ratios - Receivables Turnover (4:37)
- Activity Ratios - Inventory and Payables Turnover (6:45)
- Activity Ratios - Cash Conversion Cycle Discussion (4:53)
- Activity Ratios - Working Capital and Fixed Asset Turnover (6:09)
- Liquidity Ratios (8:31)
- Solvency Ratios (5:48)
- Profitability Ratios (8:37)
- Comprehensive Example - Activity Ratio - Cash Conversion - Part 1 (10:24)
- Comprehensive Example - Activity Ratio - Cash Conversion - Part 2 (4:53)
- Comprehensive Example - Activity Ratio - Working Capital and Fixed Asset Turnover (4:53)
- Comprehensive Example - Liquidity Ratios (5:48)
- Comprehensive Example - Solvency Ratios (8:50)
- Comprehensive Example - Profitability Ratios (8:17)
- ROE (9:08)
- ROE Example (9:12)
- Dividends Payout Ratio (3:42)
- Introduction to Income Taxes - Part 1 (10:53)
- Introduction to Income Taxes - Part 2 (6:29)
- Sources of Deferred Taxes (1:22)
- Deferred Tax Liabilities - Example - Part 1 (10:28)
- Deferred Tax Liabilities - Example - Part 2 (6:11)
- Deferred Tax Liabilities - Example - Part 3 (6:11)
- Deferred Tax Assets - Example (7:08)
- Temporary and Permanent Difference (5:48)
- Valuation Allowance - Deferred Tax Assets (5:53)
- Tax Base - Deferred Taxes (4:27)
- Effect of Changes in Tax Rates on Deferred Taxes (4:31)
- Introduction To Project Finance, Learning Objectives And Overview (2:25)
- What Is Project Finance (11:30)
- Project Finance Continued (8:40)
- Estimating The Cost Of The Project (3:42)
- Feasibility Analysis - Part 1 (5:04)
- Feasibility Analysis - Part 2 (7:11)
- Means Of Finance (4:01)
- Risk Analysis And Mitigation (6:14)
- Important Ratios In Project Finance (5:29)
- Introduction To Project Finance Modeling (3:15)
- Assumptions - Project Model & Steps (5:02)
- Assumptions - Operating (6:31)
- Assumptions - Expenses And Equity (5:22)
- Revenue Indicators And Assumptions (6:22)
- Calculating Operating Revenues (11:53)
- Operating Cost & Tax Calculations (6:01)
- Calculating Project Cost (6:03)
- Calculating Debt Drawals (5:28)
- Idc And Circular Loops (7:13)
- Land Building And Civil Works (8:05)
- Misc Fixed Assets (4:16)
- Idc Allocation (5:54)
- Completing The Income Statement (4:15)
- Calculating Principal Repayments (4:12)
- Completing The Balance Sheet (7:17)
- Completing The Cash Flow Statements (8:03)
- Calculating Dscr (6:07)
- Calculating Project Irr (5:48)
- Calculating Npv (2:27)
- Formatting The Project Model (8:06)
- Sensitivity Analysis - Interest Rate And Irr (5:38)
- Sensitivity Analysis - Parking Charges And Irr (3:52)
- Preparing A Project Finance Report (4:15)
- Conclusion Of Project Finance (3:37)
- Introduction to Project Finance (10:46)
- Agenda (11:33)
- InfraStructure in India (2:22)
- Types of Projects (7:48)
- Tipical Project Statges (5:32)
- Characteristics of Project Finance (8:18)
- Risk and Mtigants (4:55)
- Example of Risk and Mitigants (12:00)
- More on Risk and Mitigants (6:49)
- More on Risk and Mitigants Continues (6:03)
- Implicit Political Risk in Project Finance (9:19)
- Repayment in Project Finance (9:11)
- Example of Pricing in Project Finance (10:57)
- Example of Pricing in Project Finance Continues (9:47)
- Basic and Date Function in Project Finance (5:21)
- More on Date Function in Project Finance (7:15)
- H Lookup in Project Finance (8:37)
- Pivot Table in Project Finance (9:24)
- Working with BOT Scheme in Project Finance (12:00)
- More on BOT Scheme (10:53)
- Revenues and Bot Cost in BOT Scheme (11:46)
- Revenues and Bot Cost in BOT Scheme Continues (11:16)
- Case Study Example in Project Finance (7:39)
- How to Find Date in Bot Revenue Scheme (9:41)
- Concept of Swap Agreement (6:51)
- Forward Rate Agreement (6:47)
- Costing on Total Project (5:38)
- Calculating in New Derivatives (7:24)
- Cash Waterfall Model (4:46)
- Internal Rate of Return (4:32)
- More on Cash Waterfall Model (6:35)
- Cashfow for Internal Rate of Return (6:56)
- Net Cashflow in IRR (5:42)
- BECK Cashflow in IRR (8:20)
- Calculating Cashflow in IRR (5:24)
- Cashflow for KAP in IRR (6:05)
- Net Cashflow Statements (6:49)
- Contents (1:22)
- Introduction to Project Finance (5:12)
- Features of Project Finance (7:08)
- Project Fin vs Corporate Fin (2:43)
- Project Finance Structure (1:51)
- Importance of Project Finance (1:20)
- Types of Project Finance (9:32)
- Steps in Project Implementation (3:16)
- Project Cost (10:58)
- What is Feasibility Analysis (6:24)
- Understand Feasibility Analysis (8:41)
- Manpower Feasibility (5:29)
- Economic Feasibility (6:15)
- Valuation and Financial Feasibility (7:36)
- Valuation and Financial Feasibility Continues (8:40)
- Purchasing Power Adjustments (6:16)
- Means of Financing (4:52)
- Risk Analysis (9:20)
- Ratio and Fin Analysis (8:50)
- Break Even Analysis (7:20)
- Sensitivity Analysis (8:26)
- Current Ratio (5:21)
- Debt Equity Ratio (7:55)
- Creditors Turnover Ratio (7:24)
- Project Finance Modeling (1:27)
- Steps of PFM (11:08)
- Complete the Assumptions (3:35)
- Working on Cash Flow (6:54)
- Working on Cash Flow Continues (8:10)
- Calculate EBT (10:44)
- Balance sheet (5:09)
- Working on IRR and NPV (4:27)
- Ratio Analysis (8:15)
- Ratio Analysis Continues (7:53)
Conclusion:
Upon completion of the course, learners will possess a robust understanding of Project Finance from both theoretical and practical perspectives. This comprehensive approach ensures that participants are not only familiar with the fundamental principles but also adept at applying them in real-world scenarios, making them valuable assets in the field of project financial management.
Requirements
- Willingness to understand how project finance analysis works: If you’re willing to understand this domain in detail, this is the right course for you.
- Basic knowledge of finance, accounting, & excel: We will teach you all three here at an advanced level. But still, if you have the fundamentals ready, you would be able to extract the best out of this course.
Target Audience
- Finance Professionals: Individuals working in finance-related roles, including analysts, managers, and executives, seeking to enhance their knowledge and skills in project finance for better decision-making.
- Aspiring Project Managers: Those aiming to understand the financial intricacies of project management and project finance, enabling them to make informed decisions and contribute to successful project implementation.
- Entrepreneurs and Business Owners: Individuals involved in business ventures or planning projects, wanting to grasp the financial aspects of project development, feasibility, and financing for effective project execution.
- Students and Graduates: Finance and business students or recent graduates aspiring to build a strong foundation in project finance, providing a competitive edge in the job market.
- Banking and Investment Professionals: Professionals in banking and investment sectors interested in expanding their expertise in project finance, gaining insights into funding structures and risk management.