3 Statement Integrated Financial Modeling

Master financial modeling on how to create a 3 statement financials of any company forecasting the future financial projections of the business.

Categories Finance
5.00(1 Ratings)

What I will learn?

  • Reading 3 important financial statements
  • Establishing the linkages between financial statements
  • Calculating key financial ratios
  • Forecasting techniques for business metrics
  • Projecting financial statements
  • Linkage between Income Statement and Balance Sheet
  • Linkage between Balance Sheet and Cash Flows Statement
  • Linkage between Income Statement and Cash Flows Statement

Course Curriculum

Financial Modeling – Build a forward looking integrated financial model of a company

  • 02:11
  • 01:14
  • Download the illustration exercise for the course
  • The six steps to forecasting a financial model
    02:57
  • Step 1: Capturing historical IS & BS
    08:01
  • Step 2a: Calculating historical IS ratios
    12:21
  • Step 2b: Calculating historical BS ratios
    06:40
  • Step 3a: Extrapolating future IS ratios
    10:17
  • Step 3b: Extrapolating future BS ratios
    05:01
  • Quick recap of what we have do so far
    01:28
  • Step 4a: Forecasting future income statement
    12:01
  • Step 4b: Forecasting future balance sheet – assets side
    07:17
  • Step 4c: Forecasting the future balance sheet – liabilities side
    12:57
  • What are the components of cash flow statement?
    06:18
  • Step 5a: Calculating the cash flow from operations
    13:54
  • Step 5b: Calculating the cash flow from investments
    07:34
  • Step 5c: Calculating the cash flow from financing
    07:53
  • Step 5d: Calculating the cash balance at end of year
    03:04
  • Step 6: Integrating the balance sheet with cash flows statement
    02:20
  • Recap: What did we learn in this module?
    01:49
  • Practice Assignment #1: DIFFICULTY LEVEL – HARD
    00:00
  • Solution to Practice Assignment #1
    00:00

Student Feedback

Excellent
1
Very Good
0
Average
0
Poor
0
Terrible
0
5.0
1 Review

Good integrated financial model explained step by step

Requirements

  • None. We will teach everything from scratch.

Material Includes

  • 30 day access
  • 1.5 hours on-demand video
  • Access on mobile
  • Certificate of Completion

Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked at McKinsey in the Strategy and Corporate Finance practice. He is also the founder of the website skillfinlearning.com which creates online programs in Business, Finance and Data Analysis topics. At Skillfin Learning, we believe we can change the way we adults learn.

FAQ's

Why is this course free?

Our instructors do spend a good amount of time to create this course so the quality is not compromised. Yet they have partnered with us to provide their knowledge without any cost so that you can have access to the courses free.

How long do I have access to this course?

You will have 1 month access to this online program to complete and get the certification for the same. After 1 month, your course access will automatically stop. So we recommend that you complete this course within the overall time since it is a short course of 1-1.5hr.

Will I get a certificate for the course?

Yes we do provide a certification for the course on completing and taking a short assessment for the same in the form of a quiz.

Can I upload my certification online?

Yes, we will provide a LinkedIn verifiable certificate in different formats that you can add on your social media profile to get access to more opportunities. For example, You can add the certificate under the certification section of LinkedIn where recruiters look at to understand the different skills you possess.

I want to ask something else. How to contact you?

Please feel free to drop an email at [email protected] for any specific queries you may have. We will be more than happy to hear from you.

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
ashish_agarwal
2 months ago
Good integrated financial model explained step by step

Pick a plan

Enrollment validity: Membership Wise
5.00(1 Ratings)

3 Statement Integrated Financial Modeling

Categories Finance

What I will learn?

  • Reading 3 important financial statements
  • Establishing the linkages between financial statements
  • Calculating key financial ratios
  • Forecasting techniques for business metrics
  • Projecting financial statements
  • Linkage between Income Statement and Balance Sheet
  • Linkage between Balance Sheet and Cash Flows Statement
  • Linkage between Income Statement and Cash Flows Statement

Course Curriculum

Financial Modeling – Build a forward looking integrated financial model of a company

  • 02:11
  • 01:14
  • Download the illustration exercise for the course
  • The six steps to forecasting a financial model
    02:57
  • Step 1: Capturing historical IS & BS
    08:01
  • Step 2a: Calculating historical IS ratios
    12:21
  • Step 2b: Calculating historical BS ratios
    06:40
  • Step 3a: Extrapolating future IS ratios
    10:17
  • Step 3b: Extrapolating future BS ratios
    05:01
  • Quick recap of what we have do so far
    01:28
  • Step 4a: Forecasting future income statement
    12:01
  • Step 4b: Forecasting future balance sheet – assets side
    07:17
  • Step 4c: Forecasting the future balance sheet – liabilities side
    12:57
  • What are the components of cash flow statement?
    06:18
  • Step 5a: Calculating the cash flow from operations
    13:54
  • Step 5b: Calculating the cash flow from investments
    07:34
  • Step 5c: Calculating the cash flow from financing
    07:53
  • Step 5d: Calculating the cash balance at end of year
    03:04
  • Step 6: Integrating the balance sheet with cash flows statement
    02:20
  • Recap: What did we learn in this module?
    01:49
  • Practice Assignment #1: DIFFICULTY LEVEL – HARD
    00:00
  • Solution to Practice Assignment #1
    00:00

Student Feedback

Excellent
1
Very Good
0
Average
0
Poor
0
Terrible
0
5.0
1 Review

Good integrated financial model explained step by step

Pick a plan

Enrollment validity: Membership Wise

A course by

Material Includes

  • 30 day access
  • 1.5 hours on-demand video
  • Access on mobile
  • Certificate of Completion

Requirements

  • None. We will teach everything from scratch.
This content is for Premium and Trial members only.
Login Join Now