How to Build a Financial Model in Excel - Tutorial | Corporate Finance Institute

Learn how to build a financial model in Excel with part 1 of our video course! In this course, you will learn to build a financial model from scratch by working in Excel and following along with the video. After completing the course and all quizzes, you will obtain your Financial Modeling Certificate from the Corporate Finance Institute. Enroll in the FULL course to earn your certificate and advance your degree: corporatefinanceinstitute.com

Chapters:
00:00 - Building a Financial Model: Part 1
00:28 - Key Structure for Model Building
01:14 - Modeling Best Practice
02:52 - The Inherent Tension in Model Building
03:55 - Model Inputs
09:40 - Data Validation Exercise
09:57 - Model Processing
11:31 - Model Outputs
13:03 - Protecting a Worksheet
14:59 - Protecting Model Data Exercise
15:17 - A Financial Forecast Modeling Framework
16:49 - Forecasting Revenue
22:31 - Income Statement Forecast Exercise

FREE COURSES & CERTIFICATES

Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:

► Introduction to Corporate Finance: loom.ly/us5oJEw
► Excel Fundamentals: loom.ly/4KnYciU
► Accounting Fundamentals: loom.ly/xHJgJO4
► Reading Financial Statements: loom.ly/2wrcPw8
► Fixed Income Fundamentals: loom.ly/DZdjDA0

About Corporate Finance Institute: CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the world's top universities, investment banks, accounting firms, and operating companies.

By taking our courses, you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical, with step-by-step instructions to help you become a first-class financial analyst.

Explore CFI courses: courses.corporatefinanceinstitute.com/collectio…

Join us on social media!
LinkedIn: linkedin.com/company/corporate-finance-institut…
Facebook: facebook.com/corporatefinanceinstitute.cfi
Instagram: instagram.com/corporatefinanceinstitute