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?

  1. 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.
  2. 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.
  3. 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.
  4. 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

Rishabh Pugalia
Rishabh Pugalia
  • 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


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.

Get started now!