Excel

Top Project Finance Modeling Shortcuts (Windows and Mac)

Top Project Finance Modeling Shortcuts (Windows and Mac)

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

Excel | Financial Modeling

How to Model a Debt Service Reserve Facility (DSRF)

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

Financial Model User Guide - Advanced Renewable Energy Model

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

Debt Sizing with Target DSCR - Project Finance

Debt Sizing with Target DSCR - Project Finance

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

Excel | Financial Modeling

How to Build a Financial Model in Excel?

How to Build a Financial Model in Excel?

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

Excel | Financial Modeling

YEARFRAC Function - Financial Modeling

YEARFRAC Function - Financial Modeling

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

Excel | Financial Modeling

Project Finance Modeling in Excel

Project Finance Modeling in Excel

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

Excel | Financial Modeling | Valuation

MATCH Function - Financial Modeling

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?

How to model an interest rate barrier?

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

Accounting | Excel | Financial Modeling | Valuation

How to build a project finance model from scratch?

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

LOOKUP Function - Financial Modeling

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

Excel | Financial Modeling

OFFSET Function - Financial Modeling

OFFSET Function - Financial Modeling

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

Excel | Financial Modeling

How to model seasonality of renewable energy revenues?

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

INDEX Function - Financial Modeling

INDEX Function - Financial Modeling

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

Excel | Financial Modeling

NORMINV Function - 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?

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?

How to use flags in financial models?

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

Excel | Financial Modeling

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

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

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?

How to use the Name Manager in Excel?

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

Excel | Financial Modeling | VBA

How to break a circular reference in Excel?

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?

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

How to use the Goal Seek Function in Excel

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

Excel | Financial Modeling

XNPV Function - Financial Modeling

XNPV Function - Financial Modeling

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

Excel | Financial Modeling | Valuation

XIRR Function - Financial Modeling

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?

How to Land a Financial Modeling Job?

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

Excel | Financial Modeling

How to become a Project Finance Analyst?

How to become a Project Finance Analyst?

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

Excel | Financial Modeling | Renewables

How to Consider Seasonality in Excel?

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?

How to find a circular reference in Excel?

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

Excel | Financial Modeling | VBA

« Back to Blog

Renewables Valuation Analyst (RVA) Certification

Become a world-class financial modeler within the renewable energy sector and push your career to the next level.

Explore RVA Certification