Excel Dna For Project Finance Modeling

From Scratch to Pro: Master Project Finance Modeling for Renewables and Navigate from IM to NPV, IRR, CoC, and DSCR.

What you'll learn

Ability to use Excel effectively for financial modeling purposes

Learn how to build a fully integrated 3-statement model from scratch

Hands-on exercises and real-world case study based on a wind farm project

Develop the proficiency and confidence to apply modeling skills

Master essential return KPIs, including Internal Rate of Return (IRR), Net Present Value (NPV), Cash-on-Cash (CoC), and Debt Service Coverage Ratio (DSCR)

Learn how to analyze and interpret key KPIs under various scenarios, enabling you to make informed decisions and assess risk and return profiles

Gain a deep understanding of financial concepts integral to project finance

Gain a competitive edge and stand out from your peers

Explore energy-related topics such as P50, P75, and P90 energy yields, full load hours, and Power Purchase Agreements (PPAs)

Gain expertise in modeling renewable energy projects

Requirements

Excel 2013, 2016, 2019, 2021 or Excel 365 loaded on your computer.

No previous financial modeling or project finance experience needed. You will learn everyting you need to know.

Description

Excel DNA Unleashed!Learn the secrets to becoming a project finance modeling expert with Excel at your fingertips. Whether you're a financial analyst, energy industry enthusiast, or aspiring finance professional, this comprehensive course will equip you with the Excel DNA essential for excelling in project finance modeling.Your Roadmap to Project Finance Modeling ExpertiseExcel Expertise: Dive deep into Excel's functions, formulas, and shortcuts tailored for project finance modeling. From SUMIF and OFFSET to NORM.INV and more, you'll harness the full potential of Excel.Project Finance Essentials: Explore the core principles of project finance modeling, from building models from scratch to arriving at NPV, IRR, CoC, and DSCR.Efficiency with Excel Shortcuts: Transform into an Excel wizard using essential shortcuts for project finance modeling. Save time, reduce errors, and enhance your modeling confidence.Financial Metrics Insight: Develop a profound understanding of key financial metrics and their interpretation, equipping you to make informed decisions in project finance.Project Finance Best Practices: Discover industry-leading practices for structuring project finance models, impressing stakeholders with precise and visually appealing models.Renewable Energy Insights: Dive into renewable energy-related topics such as P50, P75, and P90 energy yields, full load hours, the difference between MW and MWh, Power Purchase Agreements (PPA), Engineering, Procurement, and Construction (EPC), and other related terminology.Hands-On Learning: Immerse yourself in real-world scenarios by constructing a basic financial model from scratch. Starting with the Information Memorandum (IM), navigate through NPV, IRR, CoC, and DSCR analysis, bridging theory with practical application.Integrated Financial Statements: Understand the integrity of the three financial statements (Cash Flow Statement, Income Statement, and Balance Sheet) and how they work together harmoniously to provide a comprehensive financial overview.Course Highlights:Real-World Case Study: Gain practical experience by building a basic project finance model for a wind farm project based on an industry-standard Information Memorandum (IM).Expert Guidance: Benefit from insights and guidance from an industry professional with extensive experience in project finance modeling.Excel Shortcut Cheat Sheet: Receive a downloadable Excel shortcut cheat sheet, your key to efficiency.Certification: Upon course completion, receive a certificate showcasing your Excel DNA for Project Finance Modeling.Unleash your Excel DNA and embark on a journey to master project finance modeling. Enroll today and elevate your skills for a successful career in finance and infrastructure investments.

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Lecture 2 Course Objective

Lecture 3 Learning Outcomes

Section 2: Project Finance Basics

Lecture 4 Project Finance Basics

Lecture 5 Role of a Special Purpose Vehicle (SPV) in Project Finance

Lecture 6 Differentiation of Equity Investors and Debt Providers (Lenders)

Lecture 7 Non-Recourse Financing in Project Finance

Lecture 8 Navigating the Due Diligence Process in Project Finance

Section 3: Introduction to Case Study & Analysis Tasks

Lecture 9 Introduction to the Case Study & Information Memorandum

Lecture 10 Case Study - Analysis Tasks

Section 4: Introduction to Excel for Financial Modeling

Lecture 11 Benefits of Using Shortcuts

Lecture 12 Mastering the Name Manager in Excel

Lecture 13 Excel: EOMONTH() Function

Lecture 14 Excel Start File - Basic Formatting & Technical Inputs

Lecture 15 Construction & Operation Dates

Lecture 16 Harnessing the Power of Flags in Financial Models

Lecture 17 Excel: IF(), AND() & OR() Function

Lecture 18 Model Timeline & Conditional Formatting

Lecture 19 Model Currency

Section 5: Model Inputs & Renewable Energy Basics

Lecture 20 Engineering, Procurement, and Construction (EPC) Agreement

Lecture 21 Construction & Development Costs

Lecture 22 Excel: ISBLANK() Function

Lecture 23 Excel: OFFSET() Function

Lecture 24 Integrating Multiple Scenarios into the Model

Lecture 25 MW vs. MWh: Clarifying the Difference

Lecture 26 Unveiling Full Load Hours

Lecture 27 Comparing P50, P75, and P90 Energy Yield

Lecture 28 Standard Uncertainty and its Influence on Energy Yield Distribution

Lecture 29 Excel: NORM.INV() Function

Lecture 30 Excel: SUMIF() Function

Lecture 31 Power Generation & Revenue Inputs

Lecture 32 Power Purchase Agreements (PPAs) and Their Variants

Lecture 33 PPA Inputs & Inflation Assumptions

Lecture 34 Construction Payment Plan, Conditional Formatting & First Checks

Lecture 35 Electricity Price Forecast

Lecture 36 Implementing Integrity, Signal & Master Check

Lecture 37 Operational Expenditures (Opex) - Fixed Costs Inputs

Lecture 38 Operational Expenditures (Opex) - Variable Costs Inputs

Lecture 39 Debt Inputs

Lecture 40 Equity & Tax Inputs

Section 6: Understanding the Financial Statements: CFS, I/S, and BS

Lecture 41 Interlinking the Financial Statements CFS, I/S, and BS

Lecture 42 Understanding the Cash Flow Statement (CFS)

Lecture 43 Undertanding the Income Statement (I/S)

Lecture 44 Understanding the Balance Sheet (BS)

Section 7: Uses & Sources of Funds

Lecture 45 Excel: MIN() Function

Lecture 46 Uses of Funds

Lecture 47 Sources of Funds

Section 8: Electricity Generation & Revenues

Lecture 48 Excel: SUMPRODUCT() Function

Lecture 49 Electricity Generation & Generation Allocation

Lecture 50 Excel: INDEX() Function

Lecture 51 Excel: MATCH() Function

Lecture 52 Excel: LOOKUP() Function

Lecture 53 Revenue Prices & Total Revenue

Section 9: Operational Expenditures (Opex)

Lecture 54 Operational Expenditures (Opex) Flags

Lecture 55 Operational Expenditures (Opex) Real Terms

Lecture 56 Operational Expenditures (Opex) Nominal Terms

Section 10: Depreciation, Amortization, Goodwill, and Corporate Taxes

Lecture 57 Understanding Depreciation, Amortization, and Goodwill

Lecture 58 Income Statement, Depreciation, Amortization, and Goodwill

Lecture 59 Balance Sheet & Corporate Taxes

Section 11: Senior Debt & Equity

Lecture 60 Senior Debt

Lecture 61 Interpreting the Debt Service Coverage Ratio (DSCR)

Lecture 62 Excel: AVERAGE() Function

Lecture 63 Modeling the Debt Service Coverage Ratio (DSCR)

Lecture 64 Excel: ROUND() Function

Lecture 65 Equity Funding & Balance Sheet Check

Lecture 66 Excel: MAX() Function

Lecture 67 Cash Account, Dividend Distribution, and Interlinking CFS, IS & BS

Section 12: Return Metrics & Case Study Scenario Analysis

Lecture 68 Understanding the Internal Rate of Return (IRR)

Lecture 69 Excel: XIRR() Function

Lecture 70 Modeling the Internal Rate of Return (IRR)

Lecture 71 Interpreting the Net Present Value (NPV)

Lecture 72 Excel: XNPV() Function

Lecture 73 Modeling the Net Present Value (NPV)

Lecture 74 Understanding Cash-on-Cash Return (CoC)

Lecture 75 Modeling the Cash-on-Cash Return (CoC)

Lecture 76 Case Study Scenario Analysis

Lecture 77 Final Financial Model Wrap-Up & Additional Case Study Exercises

This project finance modeling course is meant for all levels from beginner to advanced. Power users should skip basic theory chapters.,The content is geared towards financial modeling and financial analysis used in project finance, infrastructure investing, investment banking, private equity, and more.