Top Project Finance Modeling Shortcuts (Windows and Mac)

Lukas Duldinger, CFA, RVA 01/18/2024 6:00am 6 minute read

Excel | Financial Modeling

Renewable Energy Financing: The Art of Asset Structuring

Lukas Duldinger, CFA, RVA 11/23/2023 6:00am 12 minute read

Energy | Financial Modeling | Renewables | Valuation

Understanding KPIs for Renewable Energy Projects

Lukas Duldinger, CFA, RVA 11/16/2023 6:00am 9 minute read

Accounting | Energy | Financial Modeling | Renewables | Valuation

Pay-as-produced PPA vs. Baseload PPA

Lukas Duldinger, CFA, RVA 04/11/2023 6:00am 9 minute read

Energy | Financial Modeling | Renewables | PPA

How to Model a Debt Service Reserve Facility (DSRF)

Lukas Duldinger, CFA, RVA 10/18/2024 6:00am 9 minute read

Accounting | Excel | Financial Modeling | Project Finance

Mini-Perm Loans: The Game-Changer for Project Finance

Lukas Duldinger, CFA, RVA 03/22/2024 6:00am 15 minute read

Financial Modeling | Renewables | Valuation

Letter of Credit (LoC) in Renewable Energy Project Finance

Lukas Duldinger, CFA, RVA 03/15/2024 6:00am 14 minute read

Energy | Renewables | PPA

What is a Power Purchase Agreement (PPA)?

Lukas Duldinger, CFA, RVA 02/07/2024 6:00am 8 minute read

Energy | Renewables | PPA

Financial Model User Guide - Advanced Renewable Energy Model

Lukas Duldinger, CFA, RVA 02/01/2024 6:00am 151 minute read

Accounting | Energy | Excel | Financial Modeling | Renewables | Valuation | VBA

Green Bonds: Revolutionizing Renewable Energy Financing

Lukas Duldinger, CFA, RVA 11/11/2023 6:00am 12 minute read

Renewables

Financial Modeling and Valuation of Renewables

Lukas Duldinger, CFA, RVA 04/14/2023 6:00am 6 minute read

Financial Modeling | Renewables | Valuation

Debt Sizing with Target DSCR - Project Finance

Lukas Duldinger, CFA, RVA 04/13/2023 6:00am 6 minute read

Excel | Financial Modeling

Internal Rate of Return (IRR) - Project Finance

Lukas Duldinger, CFA, RVA 04/12/2023 6:00am 5 minute read

Financial Modeling | Valuation

DSRA | Debt Service Reserve Account

Lukas Duldinger, CFA, RVA 03/01/2023 6:00am 8 minute read

Accounting | Financial Modeling

Solar Project Finance Modeling

Lukas Duldinger, CFA, RVA 02/28/2023 6:00am 8 minute read

Financial Modeling | Renewables | Valuation

Renewable Energy Project Finance Modeling

Lukas Duldinger, CFA, RVA 02/27/2023 6:00am 7 minute read

Financial Modeling | Renewables

ESG Analyst | Financial Modeling | Renewable Energy

Lukas Duldinger, CFA, RVA 02/26/2023 6:00am 9 minute read

Energy | Financial Modeling | Renewables

How to Build a Financial Model in Excel?

Lukas Duldinger, CFA, RVA 02/25/2023 6:00am 7 minute read

Excel | Financial Modeling

Loan Life Coverage Ratio (LLCR) - Project Finance

Lukas Duldinger, CFA, RVA 02/24/2023 6:00am 6 minute read

Accounting | Financial Modeling | Valuation

YEARFRAC Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/23/2023 6:00am 6 minute read

Excel | Financial Modeling

Project Finance Deal - Contractual Relations

Lukas Duldinger, CFA, RVA 02/22/2023 6:00am 6 minute read

Energy | Renewables

Levered vs. Unlevered Return - Project Finance

Lukas Duldinger, CFA, RVA 02/21/2023 6:00am 6 minute read

Financial Modeling | Valuation

Net Present Value (NPV) - Project Finance

Lukas Duldinger, CFA, RVA 02/20/2023 6:00am 6 minute read

Financial Modeling | Valuation

Payback Period - Project Finance

Lukas Duldinger, CFA, RVA 02/19/2023 6:00am 4 minute read

Financial Modeling | Valuation

Project Finance Modeling in Excel

Lukas Duldinger, CFA, RVA 02/18/2023 6:00am 5 minute read

Excel | Financial Modeling | Valuation

Cash on Cash Return (CoC) - Project Finance

Lukas Duldinger, CFA, RVA 02/17/2023 6:00am 5 minute read

Financial Modeling | Valuation

Sources and Uses of Funds - Project Finance Modeling

Lukas Duldinger, CFA, RVA 02/16/2023 6:00am 3 minute read

Accounting | Financial Modeling | Valuation

MATCH Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/15/2023 6:00am 3 minute read

Excel | Financial Modeling

How to model an interest rate barrier?

Lukas Duldinger, CFA, RVA 02/14/2023 6:00am 3 minute read

Accounting | Excel | Financial Modeling | Valuation

What are Guarantees of Origin (GoOs)?

Lukas Duldinger, CFA, RVA 02/13/2023 6:00am 4 minute read

Energy | Renewables

How to build a project finance model from scratch?

Lukas Duldinger, CFA, RVA 02/12/2023 6:00am 3 minute read

Excel | Financial Modeling | Renewables

LOOKUP Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/11/2023 6:00am 5 minute read

Excel | Financial Modeling

OFFSET Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/10/2023 6:00am 3 minute read

Excel | Financial Modeling

What is Project Finance - Financial Modeling?

Lukas Duldinger, CFA, RVA 02/09/2023 6:00am 6 minute read

Energy | Financial Modeling | Renewables

EPCM vs EPC agreement - what's the difference?

Lukas Duldinger, CFA, RVA 02/08/2023 6:00am 5 minute read

Energy | Renewables

What is renewable energy and how to model it?

Lukas Duldinger, CFA, RVA 02/08/2023 6:00am 4 minute read

Energy | Renewables

How to model seasonality of renewable energy revenues?

Lukas Duldinger, CFA, RVA 02/08/2023 6:00am 3 minute read

Energy | Excel | Financial Modeling | Renewables

AC vs DC - what's the difference?

Lukas Duldinger, CFA, RVA 02/07/2023 6:00am 5 minute read

Energy | Renewables

How to model a Major Maintenance Reserve Account (MMRA)?

Lukas Duldinger, CFA, RVA 02/07/2023 6:00am 3 minute read

Accounting | Financial Modeling | Renewables

INDEX Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/04/2023 6:00am 3 minute read

Excel | Financial Modeling

NORMINV Function - Financial Modeling

Lukas Duldinger, CFA, RVA 02/03/2023 6:00am 3 minute read

Energy | Excel | Financial Modeling | Renewables

What is degradation and how to model it?

Lukas Duldinger, CFA, RVA 02/02/2023 6:00am 3 minute read

Energy | Excel | Financial Modeling | Renewables

How to use flags in financial models?

Lukas Duldinger, CFA, RVA 02/01/2023 6:00am 4 minute read

Excel | Financial Modeling

Debt Service Coverage Ratio (DSCR)

Lukas Duldinger, CFA, RVA 01/31/2023 6:00am 4 minute read

Financial Modeling | Renewables

How to model a Debt Service Reserve Account (DSRA)?

Lukas Duldinger, CFA, RVA 01/30/2023 6:00am 4 minute read

Accounting | Excel | Financial Modeling | Renewables

EOMONTH Function - Financial Modeling

Lukas Duldinger, CFA, RVA 01/29/2023 6:00am 4 minute read

Excel | Financial Modeling

How to use the Name Manager in Excel?

Lukas Duldinger, CFA, RVA 01/28/2023 6:00am 3 minute read

Excel | Financial Modeling | VBA

What's the purpose of a shareholder loan?

Lukas Duldinger, CFA, RVA 01/27/2023 6:00am 4 minute read

Accounting | Financial Modeling | Valuation

How to break a circular reference in Excel?

Lukas Duldinger, CFA, RVA 01/26/2023 6:00am 5 minute read

Excel | Financial Modeling | VBA

Goal Seek in VBA: How to automate Goal Seek in Excel?

Lukas Duldinger, CFA, RVA 01/25/2023 6:00am 6 minute read

Excel | Financial Modeling | Valuation | VBA

How to use the Goal Seek Function in Excel

Lukas Duldinger, CFA, RVA 01/24/2023 6:00am 3 minute read

Excel | Financial Modeling

How to value a wind farm or solar plant?

Lukas Duldinger, CFA, RVA 01/23/2023 6:00am 4 minute read

Financial Modeling | Renewables | Valuation

XNPV Function - Financial Modeling

Lukas Duldinger, CFA, RVA 01/22/2023 6:00pm 4 minute read

Excel | Financial Modeling | Valuation

XIRR Function - Financial Modeling

Lukas Duldinger, CFA, RVA 01/21/2023 4:00pm 3 minute read

Excel | Financial Modeling | Valuation

How to Land a Financial Modeling Job?

Lukas Duldinger, CFA, RVA 01/20/2023 6:00am 9 minute read

Excel | Financial Modeling

Top Financial Modeling Interview Questions

Lukas Duldinger, CFA, RVA 01/19/2023 6:00am 13 minute read

Financial Modeling

How to become a Finance Project Manager?

Lukas Duldinger, CFA, RVA 01/18/2023 6:00am 7 minute read

Financial Modeling

How to become a Project Finance Analyst?

Lukas Duldinger, CFA, RVA 01/17/2023 6:00am 9 minute read

Excel | Financial Modeling | Renewables

Building a Financial Model in Excel

Lukas Duldinger, CFA, RVA 01/16/2023 6:00am 5 minute read

Financial Modeling | Renewables

What companies are in the finance field?

Lukas Duldinger, CFA, RVA 01/15/2023 6:00am 9 minute read

Financial Modeling | Renewables

How to Consider Seasonality in Excel?

Lukas Duldinger, CFA, RVA 01/14/2023 6:00am 7 minute read

Excel | Financial Modeling | Renewables

How to find a circular reference in Excel?

Lukas Duldinger, CFA, RVA 01/13/2023 6:00am 7 minute read

Excel | Financial Modeling | VBA

CFADS| Project Finance | Renewable Energy

Lukas Duldinger, CFA, RVA 01/12/2023 6:00am 6 minute read

Accounting | Financial Modeling

Detriments of the Merit Order - Surging Electricity Prices

Lukas Duldinger, CFA, RVA 04/18/2022 12:48pm 4 minute read

Energy | Financial Modeling | Renewables

How to model PPA offtake agreements?

Lukas Duldinger, CFA, RVA 03/07/2022 9:00am 4 minute read

Energy | Financial Modeling | Renewables

How to model sculpted debt financing with DSCR target?

Lukas Duldinger, CFA, RVA 03/05/2022 12:00pm 3 minute read

Financial Modeling | Renewables

How to model P50, P75, and P90 energy yield?

Lukas Duldinger, CFA, RVA 03/05/2022 12:00pm 9 minute read

Energy | Financial Modeling | Renewables

What are full load hours and what is a capacity factor?

Lukas Duldinger, CFA, RVA 03/05/2022 9:00am 3 minute read

Energy | Renewables

What's the difference between kW and kWh?

Lukas Duldinger, CFA, RVA 03/04/2022 12:00pm 5 minute read

Energy | Renewables