Self-paced course

Self-paced course

Intro to Financial Modeling

Intro to Financial Modeling

Rating 4.3

318 reviews

318 reviews

318 reviews

Course Description

This is a beginner-friendly, project-based course designed to help you build financial modeling literacy.

We’ll start with an introduction to the financial modeling landscape, including common definitions, key players, types of models, and general standards and best practices.

From there we’ll introduce the concept of flows and balances, and discuss how these elements form the basis for all types of financial models.

Last but not least we’ll dive into three statement modeling, which forms the foundation for more advanced financial modeling techniques. We’ll introduce key accounting principles, review common examples of balance sheets, income statements and cash flow models, and discuss how retained earnings and net cash tie these statements together.

Throughout the course you’ll play the role of a Financial Modeling Consultant for Sarah’s Bakery, a small bakery operating in London. Your role is to help Sarah build some basic models to assess the financial health and profitability of her business, using the tools and techniques you learn throughout the course.

If you’re a data analyst or aspiring finance professional looking for an introduction to the world of financial modeling, this is the course for you.

Course Description

This is a beginner-friendly, project-based course designed to help you build financial modeling literacy.

We’ll start with an introduction to the financial modeling landscape, including common definitions, key players, types of models, and general standards and best practices.

From there we’ll introduce the concept of flows and balances, and discuss how these elements form the basis for all types of financial models.

Last but not least we’ll dive into three statement modeling, which forms the foundation for more advanced financial modeling techniques. We’ll introduce key accounting principles, review common examples of balance sheets, income statements and cash flow models, and discuss how retained earnings and net cash tie these statements together.

Throughout the course you’ll play the role of a Financial Modeling Consultant for Sarah’s Bakery, a small bakery operating in London. Your role is to help Sarah build some basic models to assess the financial health and profitability of her business, using the tools and techniques you learn throughout the course.

If you’re a data analyst or aspiring finance professional looking for an introduction to the world of financial modeling, this is the course for you.

Course Content

9.75 video hours

Skills you'll learn in this course

Structure three‑statement models that forecast revenue & cash flow

Build dynamic assumptions & scenarios with Excel best practices

Evaluate projects using NPV, IRR & sensitivity analysis

Present clear outputs for investors & executive stakeholders

Meet your instructors

Enrique Ruiz

Sr. Learning Experience Designer

Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.

Student reviews

I found this course to be a great introduction to financial modelling. As an operations manager, the finance team provided with Excel sheets using the Actuals vs. Budget model. I'd never thought about how the finance put the report together. But by completing this course, I've learned so much about financial models and I'm feeling much more confident about creating a simple financial model together. Giles was great at providing the information in a clear and structured manner.

Andrew Hubbard

The missing piece to that puzzle! Great Introduction to Financial Modelling, this really is a nice detailed course. Giles guides you all the way through, step by step! Loved it! Really beneficial for anyone interested in learning or to better understand the basics to Financial modelling. Highly worth checking out, certainly left me wanting more 😎

Sean Tom Ryan (STR)

Included learning paths

Course credential

You’ll earn the course certification by completing this course and passing the assessment requirements

Intro to Financial Modeling

Intro to Financial Modeling

CPE Accreditation

CPE Credits:

0

Field of Study:

Information Technology

Delivery Method:

QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: May 25, 2023

Course Description

This is a beginner-friendly, project-based course designed to help you build financial modeling literacy.

We’ll start with an introduction to the financial modeling landscape, including common definitions, key players, types of models, and general standards and best practices.

From there we’ll introduce the concept of flows and balances, and discuss how these elements form the basis for all types of financial models.

Last but not least we’ll dive into three statement modeling, which forms the foundation for more advanced financial modeling techniques. We’ll introduce key accounting principles, review common examples of balance sheets, income statements and cash flow models, and discuss how retained earnings and net cash tie these statements together.

Throughout the course you’ll play the role of a Financial Modeling Consultant for Sarah’s Bakery, a small bakery operating in London. Your role is to help Sarah build some basic models to assess the financial health and profitability of her business, using the tools and techniques you learn throughout the course.

If you’re a data analyst or aspiring finance professional looking for an introduction to the world of financial modeling, this is the course for you.

Course Description

This is a beginner-friendly, project-based course designed to help you build financial modeling literacy.

We’ll start with an introduction to the financial modeling landscape, including common definitions, key players, types of models, and general standards and best practices.

From there we’ll introduce the concept of flows and balances, and discuss how these elements form the basis for all types of financial models.

Last but not least we’ll dive into three statement modeling, which forms the foundation for more advanced financial modeling techniques. We’ll introduce key accounting principles, review common examples of balance sheets, income statements and cash flow models, and discuss how retained earnings and net cash tie these statements together.

Throughout the course you’ll play the role of a Financial Modeling Consultant for Sarah’s Bakery, a small bakery operating in London. Your role is to help Sarah build some basic models to assess the financial health and profitability of her business, using the tools and techniques you learn throughout the course.

If you’re a data analyst or aspiring finance professional looking for an introduction to the world of financial modeling, this is the course for you.

Curriculum

1

Orientation & Benchmark Assessment

1

Orientation & Benchmark Assessment

1

Orientation & Benchmark Assessment

5

CASE STUDY #1: Revenue Forecast

5

CASE STUDY #1: Revenue Forecast

5

CASE STUDY #1: Revenue Forecast

7

CASE STUDY #2: Capex

7

CASE STUDY #2: Capex

7

CASE STUDY #2: Capex

9

CASE STUDY #3: Linking Three Statement Models

9

CASE STUDY #3: Linking Three Statement Models

9

CASE STUDY #3: Linking Three Statement Models

10

Final Assessment

10

Final Assessment

10

Final Assessment

Meet your instructors

Enrique Ruiz

Sr. Learning Experience Designer

Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.

Student reviews

I found this course to be a great introduction to financial modelling. As an operations manager, the finance team provided with Excel sheets using the Actuals vs. Budget model. I'd never thought about how the finance put the report together. But by completing this course, I've learned so much about financial models and I'm feeling much more confident about creating a simple financial model together. Giles was great at providing the information in a clear and structured manner.

Andrew Hubbard

The missing piece to that puzzle! Great Introduction to Financial Modelling, this really is a nice detailed course. Giles guides you all the way through, step by step! Loved it! Really beneficial for anyone interested in learning or to better understand the basics to Financial modelling. Highly worth checking out, certainly left me wanting more 😎

Sean Tom Ryan (STR)

Included learning paths

Course credential

You’ll earn the course certification by completing this course and passing the assessment requirements

Intro to Financial Modeling

Intro to Financial Modeling

CPE Accreditation

CPE Credits:

0

Field of Study:

Information Technology

Delivery Method:

QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: May 25, 2023

More courses you may like

READY TO GET STARTED

Sign Up Today and Start Learning For Free

READY TO GET STARTED

Sign Up Today and Start Learning For Free

READY TO GET STARTED

Sign Up Today and Start Learning For Free