Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

VBA for Project Finance Models | Circular Debt Calculations

Eliminate circular references and enhance your model's calculation performance by 10x or more!
4.5
4.5/5
(42 reviews)
241 students
Created by

8.7

Classbaze Grade®

7.7

Freshness

9.0

Popularity

8.9

Material

Eliminate circular references and enhance your model's calculation performance by 10x or more!
Platform: Udemy
Video: 4h 32m
Language: English
Next start: On Demand

Best Financial Modeling classes:

Classbaze Rating

Classbaze Grade®

8.7 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

7.7 / 10
This course was last updated on 6/2020.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

9.0 / 10
We analyzed factors such as the rating (4.5/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

8.9 / 10
Video Score: 8.2 / 10
The course includes 4h 32m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 50 minutes of 107 Financial Modeling courses on Udemy.
Detail Score: 9.1 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
37 resources.
0 exercise.
0 test.

In this page

About the course

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!

What can you learn from this course?

✓ Excel VBA
✓ Advanced project finance modeling
✓ VBA for circular problems in project finance

What you need to start the course?

• Knolwedge of project finance modeling
• Strong Excel skills

Who is this course is made for?

• Analysts/modelers with 6 months or more experience or more in project finance
• Students following on from my project finance course

Are there coupons or discounts for VBA for Project Finance Models | Circular Debt Calculations ? What is the current price?

The course costs $199.99.
The average price is $30.3 of 107 Financial Modeling courses. So this course is -560% cheaper than the average Financial Modeling course on Udemy.

Will I be refunded if I'm not satisfied with the VBA for Project Finance Models | Circular Debt Calculations course?

YES, VBA for Project Finance Models | Circular Debt Calculations has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

At the moment we could not find an available financial aid for VBA for Project Finance Models | Circular Debt Calculations.

Who will teach this course? Can I trust DealMaker Financial Training?

DealMaker Financial Training has created 5 courses that got 2,246 reviews which are generally positive. DealMaker Financial Training has taught 13,230 students and received a 4.4 average review out of 2,246 reviews. Depending on the information available, we think that DealMaker Financial Training is an instructor that you can trust.
Financial modeling and Excel VBA training
DealMaker is a professional training brand developed by Roderick McKinley, CFA, a business and finance professional with a passion for Excel and learning.He has used Excel in business applications over 9 years. Major successes in that period include developing global power-sector forecasts for Bloomberg; winning contracts in a competitive bid process in Chile for wind farms valued at over $2bn, and financing a $585m wind deal.
Outside of business Roderick has had a longstanding engagement with education having taught at secondary school, presented to university undergraduates, and providing professional training and CFA coaching in the workplace.
DealMaker brings together both professional and educational experiences to create a top-level teaching product accessible to internet students world-wide.
Browse all courses by on Classbaze.

8.7

Classbaze Grade®

7.7

Freshness

9.0

Popularity

8.9

Material

Platform: Udemy
Video: 4h 32m
Language: English
Next start: On Demand

Classbaze recommendations for you