Financial Modeling Course

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.

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.