Envision the Future: Financial Modeling Using Excel

Learn to develop a financial projection/forecast including an income statement, balance sheet, and cash flow statement

Instructed by Blair Cook

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • Use a disciplined approach for using Excel to develop financial analysis
  • Prepare financial projections of the income statement, balance sheet, and statement of cash flows

In this course we are going learn how to financially model a business using Excel.  Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes.  In this course, we are going to concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow.  We will use an approach that keeps model integrity and credibility top of mind throughout development.

  • You should have a basic level of proficiency with Excel.
  • You should be familiar with accounting principles and financial ratios
  • Finance Students
  • Financial Analysts
  • Finance Managers
  • Financial Professionals
  • Accountants
View More...

Section 1 : Introduction to the Course

  • Lecture 1 :
  • I’ll go over the broad topics we’ll cover in the course, as well as review the supplemental material and assignments. I’ll also touch on why the course will help you and what you’ll get out of it once you’ve completed it.

Section 2 : Planning your financial model

  • Lecture 1 :
  • Planning your financial model
  • In this lesson, I’m going to emphasize the importance of planning your financial model before you begin. Excel is a wonderful tool, but without a little upfront planning discipline, it can quickly spiral out-of-control and create a nightmare for you to maintain and anyone else to review.

Section 3 : Building your model template

  • Lecture 1 :
  • Building your model template
  • In this lesson, I’m going to talk about how you set up your model template for each of the financial statements. You’ll follow along with your own version of the template.

Section 4 : Projecting the income statement

  • Lecture 1 :
  • Projecting the income statement
  • In this lesson, you and I will walk through preparing a projected income statement by documenting our assumptions and calculations and referencing them into our income statement template.

Section 5 : Projecting the balance sheet

  • Lecture 1 :
  • Projecting the balance sheet
  • In this lesson, you and I will walk through preparing a projected balance sheet by documenting our assumptions and calculations and referencing them into our income statement template.

Section 6 : Projecting cash flows

  • Lecture 1 :
  • Projecting cash flows
  • In this lesson, you and I will walk through preparing a projected cash flow statement by documenting our assumptions and calculations and referencing them into our income statement template. We will discuss the importance of setting up reconciliations and integrity checks throughout your financial model.

Section 7 : Advanced financial modeling

  • Lecture 1 :
  • Advanced financial modeling
  • In this lesson, we will look at some advanced modelling tips, for instance, what do you do when you have multiple divisions or subsidiaries to model.

Section 8 : Excel feature for financial modellers

  • Lecture 1 :
  • Excel feature for financial modellers
  • In this lesson, I’m going to show you 5 Excel features you may never heard of that I find helpful when I’m building a financial model.

Blair Cook,

Blair is a many-time corporate director, CFO, author, speaker, educator, innovator, and thought leader. His educational videos of accounting and finance have million of views on YouTube. He has keynoted and spoken at national conferences from New York to Toronto. Along with Jen, he co-hosts CPA Canada’s podcast series “CPA Success Podcast.” He works with real businesses to experiment with theories and practices developed both in the academic and real world. He then shares these experiences and stories with others of what works, what doesn’t, and what was learned. He is the author of The Illiterate Executive: An Executive’s Handbook for Mastering Financial Acumen.
View More...
ms-excel-basic-to-advanced-level

MS Excel Basic to Advanced Level

By : Ramzan Rajani

Lecture 15

learn-ms-excel-from-basic-to-advance

Learn MS Excel From Basic to Advanc...

By : Ashwini Bissa

Lecture 14

odoo-purchases-sales-inventory-with-accounting-modules

Odoo: Purchases, Sales, Inventory w...

By : Quantic Statistics R spatial analysis

Lecture 13

how-to-carry-out-term-loan-appraisal-as-banker

How to carry out Term Loan Appraisa...

By : CA N Raja Natarajan

Lecture 39

accounting-basics-in-66-minutes

Accounting Basics in 66 Minutes

By : CA N Raja Natarajan

Lecture 13

how-to-carry-out-financial-analysis-as-a-banker

How to carry out Financial Analysis...

By : CA N Raja Natarajan

Lecture 25

Buy

$250

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Forget Password