Your Instructor
Rishabh Pugalia | 🔗 Linkedin Profile
⭐ 4.8 Average Rating | 💬 839 Reviews |
🎓 30,000+ Classroom Students |💡 160,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12,000+ participants across PwC, EY and Deloitte over last the 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit), J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time).
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Flipkart, Uber, Tata Group etc. use these video courses to excel at work - Automation & Analytics.
Course Curriculum
-
Preview0201 Introduction of Component & Download Case Study (2:23)
-
Preview0203 Creation of Flags Part 2 (Start Date and End Date) Final (10:27)
-
Preview0202 Creation of Flags Part 1 (Holiday Expense) (6:26)
-
Preview0204 Creation of Flags Part 3 (Recurring Expense) (6:57)
-
Preview0205 Calculation of Escalation Rate (8:21)
-
Preview0206 Building Schedules using BASE Approach (4:21)
-
Preview0207 Constructing a Depreciation Cap (4:25)
-
Preview0210 Preparing a Loan Repayment Schedule (5:12)
-
Preview0208 Building a Circularity Switch (8:16)
-
Preview0211 Using VLOOKUP with True (5:37)
-
Preview0212 Calculation of IRR & NPV (10:56)
-
Preview0209 Creating a Waterfall Structure (5:53)
-
Start0301 Model Preview & Download Case Study (4:05)
-
Start0302 Project Details and Assumptions Sheet (10:40)
-
Start0305 Building the schedule for Capital Expenditure (4:44)
-
Start0303 Sheet Preview and Building Dynamic Timeline (6:43)
-
Start0304 Building the schedule for Revenue Forecast (4:59)
-
Start0305 Building the schedule for Capital Expenditure (4:44)
-
Start0306 Building the schedule for Annual & Accumulated Depreciation (5:27)
-
Start0307 Building the schedule for Financial Structure (3:59)
-
Start0308 Building the schedule for Equity (1:01)
-
Start0309 Building the schedule for Government Grant (0:59)
-
Start0310 Building the schedule for Debt (13:01)
-
Start0311 Building the schedule for Other Operational Costs (2:14)
-
Start0312 Building the schedule for Working Capital (7:00)
-
Start0313 Building the schedule for Dividend (2:52)
-
Start0314 Building the schedule for Tax (1:48)
-
Start0315 Linking the Income Statement (4:46)
-
Start0316 Linking the Balance Sheet (4:06)
-
Start0317 Linking the Cash Flow Statement (4:37)
-
Start0318 Building the schedule for Cash Surplus and Cash Overdraft (9:23)
-
Start0319 Key Concepts for the Calculation of IRR & NPV & Download Case Study (7:51)
-
Start0320 Calculating Unlevered IRR (3:59)
-
Start0321 Calculating Unlevered NPV (8:12)
-
Start0322 Calculating Levered IRR (3:25)
-
Start0323 Calculating Levered NPV (3:03)