Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 32 Minute(s)
Language
English
Taught by
DealMaker Financial Training
Rating
Course Overview
Eliminate circular references and enhance your model's calculation performance by 10x or more!
WORK IN PROJECT FINANCE???
I BET YOU HAVE NO IDEA WHAT TIMESAVING IMPROVEMENTS YOU'RE MISSING...!!!
Any of the following sound familiar???
You drive yourself crazy trying to model without tripping another circular reference
You have to wait for AGES for your model to solve ONE scenario
You have to wait longer than the age of the Universe to solve MULTIPLE scenarios
You groan whenever assumptions are updated (*ahem* corrected!) because you have to wait and solve everything again!
You have NO idea how to use your model to solve for input values which achieve target outcomes, because Goalseek doesn't work in your CopyPaste macro model!
The reason you have all these time costs is because circular logic BREAKS EXCEL
The solutions most people know about are slow, and often used poorly, which slow down calculations even MORE!
But there's no avoiding it. You HAVE to use circular logic in non-recourse debt and project finance modeling .
WHY? Because it affects one of the single most important questions you and your work are being used to answer: HOW MUCH DEBT CAN A PROJECT RAISE???
So let me ask you....
What would it be worth to you, to be able to do those tasks 5x faster...???
Let's be clear... that means a 30 minute model run finishes in 6 minutes!
What if I told you, you could calculate 10x faster...???
Your 30 minute calculations complete in just 3 minutes!!!
For those of you using long-life models time and time again, these timesavings will be HUGE.
They will radically redefine the amount of time consumed by your work!
This course will cover industry-standard best-practice approaches
They are the same ones taught by top course providers like Mazars/Corality and EY...
But *this* course also adds the extra details that will help you use these techniques in the most efficient way possible!
This course will teach you mathematical secrets which will allow you to Solve circular models for any input!
Yes! You WILL be able to use this solution even in a models which have copypaste macros in them!
You will learn a method which is faster and more robust than running your model through endless copypaste-goalseek loops!
Best of all, this method lets you keep a SIMPLE copy-paste macro at the heart of your model!
This course will go beyond best practice - if you can handle it!
You will learn advanced methods that go far beyond what they have time to teach you in standard courses.
This could be a real challenge but if you succeed, your models will:
Calculate 10x faster or more
Not need manually macro triggers
Your models will work like a normal Excel file without circularity breaks
You will be able to use Excel's Goalseek to backsolve again
You will also be coached to use this knowledge responsibly with professional awareness
You'll learn how to understand and assess the tradeoffs that come with choosing between standard and advanced solutions so you can apply the one that is best suited to your current project.
Obviously, this is a highly specialised course, but if you model non-recourse debt or project finance deals, circular problems are probably the bane of your life...
Yelling "I'M MAD AS HELL" won't help you... but taking this course WILL!
Course Content
- 5 section(s)
- 40 lecture(s)
- Section 1 Introduction & VBA study preparations!
- Section 2 Mastering the VBA editor
- Section 3 Mastering the "breakpoint method" for handling circular calculations
- Section 4 Backsolving breakpoint models - without Goalseek
- Section 5 Handling circular calculations 10x FASTER, WITHOUT manual macro triggers
What You’ll Learn
- Excel VBA, Advanced project finance modeling, VBA for circular problems in project finance
Skills covered in this course
Reviews
-
LLuis Eduardo Meneses Cornejo
The best classes! I had been looking for a course with UDFs for my job as financial modeler in Mexico City and I've found the answers here. Please make more content related to taxes and NOLs with UDFs! Thanks
-
小小野 勇一
I would think that there is no other course such as this high-level and unique lecture. Thank you very much.
-
HHaris Karamovic
The course is right, but I need to make one remark regarding the course, and I believe that this could be a fantastic course. It's necessary to take more explanations regarding starting positions in sheets, e.g., tables, and fields. For some students who try to learn for the first time VBA, its problematic to find tables, and for an economist is also hard to connect, and we are losing a lot of time looking for table matches. It would be good to spend some 20 min and try to explain how you mark the table for your codes.
-
MMiguel Pereira
1. Additional pdfs to summarize key concepts would help to "make it stick". 2. Simple excel excercises with circular calculations would be helpful to practice writing the first VBA lines.
