Financial Modeling in Excel – Volume 1
Financial Modeling in Excel isn’t JUST about Excel and Finance. It’s about modeling too. Excel is just a platform for modeling.
What’s included in this course?
- Timing Flags: The flag is a simple on/ off switch in the form of TRUE (1) / FALSE (0), respectively. This is ONE OF THE MOST critical modeling tricks in a Financial Model for a Project. It’s used in modeling operation start, interest during construction, depreciation, debt repayment etc.
- Circularity Switch: There are certain calculations whose variables are inter-dependent. E.g. Cash flow deficit will warrant arranging short term credit facility. In turn, it increases interest expense and hence, further cash outflow. This further deepens the cash flow deficit. Such circularity, if infected with a single error, will fill the worksheet calculations with errors. This cannot be undone. Circularity switch helps create a circuit-breaker.
- BASE Analysis or Corkscrew equation:BASE means Beginning, Addition, Subtraction, and Ending. This sequence of calculation is often used in Property, Plant and Equipment (PPE), Debt calculations etc.
- Waterfall Structure: Often, the funds of a project are used in a pre-decided sequence or a ratio. Waterfall Structure modeling helps model the impact.
Your Instructor
- Qualified Chartered Accountant
- Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
- Four years of work experience in the area of Audit, Investment Banking & Proprietary trading
- Program Director & Training Instructor – Advanced Excel, Advanced PowerPoint, Financial Modeling
- 5.5 years of work experience in Corporate Training & Workshops
- Under him, Excel Next has trained more than 6,500 professionals across 14+ cities
- Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy.
Course Curriculum
Flags - Timing & Operation
Available in
days
days
after you enroll
-
StartDownload Case Studies
-
Start001 True vs False (1:25)
-
Start002 Timing Flag - Basics (3:46)
-
Start003 Timing Flag - Advanced Demo (2:16)
-
Start004 Timing Flag - Advanced Practice - Proj Completion Dt (1:42)
-
Start005 Timing Flag - Advanced Practice 2 - Timeline (4:00)
-
Start006 Timing Flag - Advanced Practice 3 - Start Flag (3:31)
-
Start007 Timing Flag - Advanced Practice 4 - Operation Flag (1:49)
-
Start008 Timing Flag - Advanced Practice 5 - Operation Days (4:07)
-
Start009 Timing Flag - Advanced Practice 6 - Operation Yr No (1:42)
-
Start010 Timing Flag - Advanced Practice 7 - Final (3:18)
-
Start011 Recurring Events Flag - Fixed Interval (4:25)
-
Start012 Recurring Events Flag - Customised Interval (4:39)
Waterfall Structure - Funding
Available in
days
days
after you enroll
-
StartDownload Case Studies
-
Start001 What is a Waterfall Structure (0:49)
-
Start001 - Funding Waterfall Structure - Demo with logics (5:03)
-
Start002 - Funding Waterfall Structure - Equity (4:32)
-
Start003 - Funding Waterfall Structure - Debt (3:17)
-
Start004 - Funding Waterfall Structure - Grant (4:50)
Iteration & Circularity Switch
Available in
days
days
after you enroll
-
StartDownload Case Studies
-
Start001 What is a Circular Reference (1:21)
-
Start002 What is iteration in context of Circular Reference (4:03)
-
Start003 Circularity Switch or Circuit Breaker - Example 1 (4:42)
-
Start004 Circularity Switch or Circuit Breaker - Example 2 (5:13)
-
StartFinancial Modeling in Excel – Volume 1 Feedback
FAQs
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.