Financial Modeling Course

Master the art for making large and complex financial decisions with our 12+ hours of high-quality video tutorial on Financial Modeling.

Bestseller
4.95 (85 ratings)
Click here for Sample Videos

What Will You Learn?

  • McDonald’s Step by Step Financial Modeling from Scratch
  • 3 Statements Forecast (Income Statement, Balance Sheet & Cash Flows)
  • Revenue Forecasts
  • Costs Forecasts
  • Working Capital Forecasts
  • Depreciation & Amortization Forecast
  • Shareholders Equity Forecast
  • Debt Forecasts
  • Financial Statement Analysis
  • Sensitivity Analysis
  • Circular References
  • Sensitivity Analysis
  • Financial Statement Analysis
  • Forecasting
  • Scenario Analysis

What Will You Get?

14+ hours of video tutorials

25+ downloadable Excel templates

Certificate of completion

One year unlimited access

Course Summary

This comprehensive and hands-on course is designed to equip you with the essential skills and knowledge needed to excel in financial modeling. Through a combination of theoretical lessons, practical exercises, and real-world case studies, you’ll take a deep dive into the understanding of financial modeling.

If you’re a finance professional looking to enhance your skills or a student aiming to kick-start your career, this course is the perfect choice and tailored to meet all your needs!

CourseOnline Financial Modeling Course
Hours14+ video hours
Core CoverageMcDonald’s Step by Step Financial Modeling from Scratch
3 Statements Forecast (Income Statement, Balance Sheet & Cash Flows)
Revenue Forecasts
Costs Forecasts
Working Capital Forecasts
Depreciation & Amortization Forecast
Shareholders Equity Forecast
Debt Forecasts
Financial Statement Analysis
Sensitivity Analysis
Circular References
Templates Downloadable?Yes, Excel templates and financial models are downloadable
Online Financial Modeling Course ValidityUnlimited access to online Financial Modeling course videos for 1 year
EligibilityAny Graduates/Post Graduates/CA/CFA
Pre-RequisitesBasic knowledge of Excel and Accounting
What Do You Get?Certificate of Completion
Certification TypeOnline Certificate
Verifiable Certificates?Yes
Type of TrainingSelf-Paced Video Course on Financial Modeling
Software RequiredExcel

Course Sample Videos

Calculating Margins

MCD Working Capital

MCD Property and Equipment

Course Content

  1. What is Financial Modeling.
  2. Top Level View of Financial Modeling.
  3. Setting up the Financial Model.
  4. Best Practices – Number and Color Coding.
  5. Best Practices – Important Tips.
  1. Understanding Historical Income Statement.
  2. Populating Historical Income Statement.
  1. Understanding MCD Balance Sheet.
  2. Populating MCD Balance Sheet.
  1. Understanding MCD Cash Flow Statement.
  2. Populating Historical Cash Flow Statement.
  1. Calculating Margins.
  1. Vertical Analysis of Income Statement.
  1. Vertical Analysis of Balance sheet.
  1. Segmental Growth Forecast.
  2. Price Volume Growth Forecast.
  3. Occupancy Based Revenue Forecast.
  4. Employee Based Forecast.
  5. Sq Feet Based Forecast.
  6. Capacity Based Forecast.
  1. Understanding MCD Revenue Segments.
  2. Populating MCD Revenue Segments.
  3. Calculating MCD Yield Per Restaurant.
  4. Projecting MCD Yield Per Restaurant.
  5. Projecting MCD Restaurants.
  6. Calculating MCD’s Projected Revenues.
  7. Linking MCD’s Revenue Forecast.
  1. Projecting MCD Operating Cost – MP4.
  2. Projecting MCD SG&A Expenses.
  3. Projecting MCD Non Operating Expense – MP4.
  4. Projecting MCD Income Tax – MP4.
  1. Understanding MCD Working Capital – MP4.
  2. Linking Historical Working Capital – MP4.
  3. Calculating MCD Accounts Receivable Turnover – MP4
  4. Calculating MCD Inventory Turnover – MP4,
  5. Calculating MCD Payables Turnover – MP4.
  6. Calculating MCD Cash Conversion Cycle – MP4.
  7. Forecasting MCD Cash Conversion Cycle – MP4.
  8. Forecasting MCD Working Capital – MP4.
  9. Linking Working Capital to Balance Sheet – MP4.
  10. Linking Working Capital to Cash Flow Statement – MP4.
  1. Depreciation and Capex Refresher – MP4.
  2. Projecting Capex – MP4.
  3. MCD Historical Property and Equipment – MP4.
  4. Projecing MCD Property and Equipment – MP4.
  5. Calculating MCD Depreciation Expense – MP4.
  6. Completing MCD Depreciation Expense – MP4.
  7. Linking Capex and Depreciation – MP4.
  1. Calculating Historical Amortization.
  2. Calculating Addition to Intangibles.
  3. Forecasting Amortization.
  4. Linking Software and Amortization.
  1. Understanding Other Long Term Assets and Liabilities.
  2. Projecting Other Assets.
  3. Projecting Other Liabilities.
  4. Linking Other Long Term Assets Liabilities.
  1. MCD Consolidated Statement of Shareholders Equity.
  2. Understanding Shareholders Equity Equation.
  3. Linking the Shareholders Equity.
  4. Projecting MCD Share Repurchase.
  5. Projecting MCD Stock Options.
  6. Projecting MCD Dividends.
  7. Projecting Share Based Compensation.
  8. Projecting Outstanding Shares.
  9. Calculating Shareholders Equity.
  10. Linking Shareholders Equity.
  1. Cash Flow from Operations.
  2. Cash Flow for Investing.
  3. Cash Flow for Financing Activities.
  4. Calculating Year End Cash Flows.
  1. Debt Forecast Foundation.
  2. Cash Available for Debt Repayments.
  3. Understanding Cash Available for Line of Credit.
  4. Forecasting Long Term Debt.
  5. McDonalds Line of Credit.
  6. Modeling Line of Credit.
  7. Forecasting Line of Credit.
  8. Interest Expense on Line of Credit.
  9. Interest Expenses on Long Term Debt.
  10. Interest Income.
  11. Linking the Financial Statements.
  12. Adjusting Debt.
  13. Circular Reference in Debt.

Financial Modeling – Certificate of Completion

Course Description

The Financial Modeling course is specifically designed to cater to the needs of both
working professionals and students, enabling them to learn valuable hands-on skills. By enrolling in this course, participants will gain practical insights into how to comprehend and construct business valuation models effectively.

The course curriculum has been meticulously crafted to strike the ideal balance
between imparting conceptual knowledge and incorporating industry best practices,
ensuring a comprehensive learning experience.

What We Offer:
  • Comprehensive Curriculum: Our course curriculum is carefully created to cover the fundamental concepts and advanced techniques of financial modeling. From financial statement analysis to forecasting and scenario analysis, you’ll gain a solid understanding in all aspects of financial modeling.
  • Hands-on Approach: We believe that the best way to learn financial modeling is through practical application. Throughout the course, you’ll have numerous opportunities to apply your knowledge by working on real-world case studies and projects. This hands-on approach will sharpen your skills and prepare you for real-world challenges with a special focus on McDonald’s, a global leader in the fast-food industry.
  • Industry Experts as Instructors: Our course is taught by experienced finance professionals who have a deep understanding of financial modeling. They bring their industry knowledge and expertise to the classroom, providing valuable insights and guidance to help you excel in your financial modeling endeavors.
  • Cutting-Edge Tools: In today’s fast-paced financial landscape, proficiency in financial modeling software is essential. Our course will familiarize you with the latest tools and software used in the industry, including Excel, VBA, and other specialized modeling platforms. You’ll gain hands-on experience using these tools, enabling you to build robust financial models efficiently.
  • Certification: Upon successful completion of the course, you’ll receive a certification, showcasing your expertise in financial modeling.

Who Is Eligible?

  • Executives, Business Planning and Strategy Executives
  • Equity Research Analysts
  • Investment Bankers
  • Portfolio Managers
  • Commercial Bankers
  • Risk Managers
  • CPA, ACCA, MBA, CFA, FRM and Commerce graduates
  • Candidates from technical background like Diploma, B. Tech or Engineering who wants to make a career in finance

Frequently Asked Questions (FAQs)

This course is suitable for all the students and working professionals who are interested in mastering financial modeling techniques and enhancing their skills in business valuation.

No. This course is suitable for both beginners and intermediate learners. You will start with learning the fundamentals and gradually progress to more advanced topics with the help of practical examples and case studies.

We primarily focus on doing financial modeling in MS Excel, which is widely used in the industry. The course will teach you numerous Excel techniques and shortcuts specific to financial analysis and modeling.

The course is curated in a step-by-step manner, covering essential concepts, practical exercises, and case studies. Each course module builds upon the previous one, allowing you to develop a strong foundation in financial modeling.

The course covers various topics, including financial statement analysis, forecasting, scenario analysis, sensitivity analysis, real-world use cases, with industry best practices.

This is a 12+ hour self-paced course, allowing you to complete it at your convenience within a reasonable timeframe. Once taken, you will get 1 year validity to the course materials, enabling you to revisit the content whenever needed.

Yes. Upon successful completion of the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and enhance your career prospects.

You can pay using different payment methods including credit cards, debit cards as well as PayPal.

Yes. Every course will conclude with MCQ-style quizzes to test your learnings throughout the course. You will be provided with a certification once you score the minimum marks required from the assessment.

Yes. Anyone from anywhere, irrespective of their geographical location, can enroll in the course.

Yes. We do offer limited-time and special occasion discounts.

You may contact us at [email protected] for course related inquiries.

Boost your career prospects and gain the skills and confidence needed to tackle complex financial analyses. Start your journey to financial modeling today!

Instructor

Dheeraj Vaidya, CFA, FRM

  • ex-JPMorgan, CLSA Equity Analyst
  • CFA, FRM Chaterholder
  • 18+ years of Training Experience

Dheeraj Vaidya, CFA, FRM, the Co-founder of WallStreetMojo, is renowned for his expertise in finance. With an impressive background as a former J.P. Morgan and CLSA Equity Analyst, he possesses a deep understanding of financial modeling, forecasting, and valuations. With a career spanning nearly two decades, Dheeraj has left an indelible mark by training and mentoring over 100,000 students and professionals worldwide. His extensive knowledge and passion for the field have made him a sought-after expert in areas such as investment banking, private equity, accounting, and more. Dheeraj’s unwavering dedication to empowering others has earned him acclaim as a visionary leader in the financial industry.

Course Reviews / Testimonials

Prateek Vohra

This course on Financial Modeling is exceptional in its ability to provide clear and logical explanations. The instructor simplifies complex formulas and makes them easily understandable. It helped me learn about the advanced features and the exercises relevant to real-life work situations. I am thoroughly enjoying discovering new aspects of financial modeling through this engaging and practical course.

Olivia Jones

I signed up for the financial modeling course, and it exceeded my expectations. The course material was comprehensive and well-structured, covering everything from fundamental to advanced methods. The instructor’s expertise and passion for the subject were evident throughout the course, making the learning process engaging and enjoyable.

Lucas Smith

Completing this financial modeling course has provided me with a comprehensive understanding of various techniques and their practical applications. Through hands-on exercises and real-world case studies explained in the course, I gained the skills and confidence to build robust financial models. It enhanced my understanding of finance and allowed me to explore new career opportunities. I highly recommend this course to everyone.

Limited Period Offer ends in:
Only 11 seats are left with this price
$79 $199 60%
Enroll Now One year unlimited access

Instructor

Dheeraj Vaidya, CFA, FRM

  • ex-JPMorgan, CLSA Equity Analyst
  • CFA, FRM Chaterholder
  • 18+ years of Training Experience