Skip to Content
Member Login
Username:
*
Password:
*
Remember me
Trouble signing in?
Reset your password
On-Demand CPE Courses
Audit & Accounting
Finance
Tax
Ethics (NASBA)
Careers
Human Resources (HR)
Marketing
Operations
Internal Audit
Excel
Leadership & Mgmt.
Other Study Areas
Productivity & Tech
Risk Management
Browse All 1,800+ Courses
Micro Certifications Program
Sarbanes-Oxley (SOX) Certification
Professional Bookkeeping Certification
Revenue Recognition Certification
Internal Controls and Internal Audit Certification
Accounts Payable Management Certification
The Controllership Series Certification
Corporate Cyber Security Certification
Accounts Payable Certification
Browse All 40+ Certification
120+ Webinars
Browse all Upcoming Events
Support
CPE Credentials
Whitepapers
Blogs
Platform Tour
How to Videos
FAQs
Become an Instructor
Contact Us
Ask Illumeo AI Search
Free Trial
Login
×
My Info
My Dashboard
Completed Activity
My Products
My Orders
Logout
Member Login
Username:
*
Password:
*
Remember me
Trouble signing in?
Reset your password
CPE Courses
On-Demand CPE Courses
Audit & Accounting
Finance
Tax
Ethics (NASBA)
Careers
Human Resources (HR)
Internal Audit
Excel
Leadership & Mgmt.
Productivity & Tech
Risk Management
Other Study Areas
Browse CPE Courses
Browse Premium CPE Courses
Browse Premium+ CPE Courses
Browse Whole CPE Library
Micro Certification Programs
Sarbanes-Oxley (SOX) Certification
Professional Bookkeeping Certification
Revenue Recognition Certification
Internal Controls and Internal Audit Certification
Accounts Payable Management Certification
The Controllership Series Certification
Corporate Cyber Security Certification
Accounts Payable Certification
Browse All 40+ Certification
120+ Webinars
Browse all Upcoming Events
Browse all Premium CPE Events
Browse all Premium+ CPE Events
Pricing
Premium+ CPE Subscription
365 days, Unlimited Credits
1800+ Courses with 130+ Webinars
Premium & Premium+ Content
Buy Now for $399
Premium CPE Subscription
365 days, Unlimited Credits
1700+ Courses with Premium Content
Compliance Tracker
Buy Now for $299
On Demand CPE Subscription
365 days, Unlimited Credits
1,600+ CPE Courses & Webinars
Compliance Tracker
Buy Now for $199
Webinar CPE Subscription
120 hours of Live CPE in year
Premium & Regular CPE Webinars
4 hours from 85+ Ethics courses
Buy Now for $199
Enterprise/Team Subscription
365 days, Unlimited Credits
1700+ Courses with Premium Content
Comp. Tracker, User Mgt. & Reports
Buy Now for $199 / User
(Min. 3 Users)
Ask Illumeo AI Search
Free Trial
Login
course
Financial Modeling Using Excel
(678)
4.492625
1629
Enrolled
1.5
Hours
(On-Demand)
1.5 CPE
Free Trial
Get access to this and
12
other free courses
Free
View Course Overview for Available CPE and Access Options
Course Overview
Next Lesson:
Planning your Financial Model
Blair Cook
Director of Clarke Inc
Course Overview
CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
4:07
PREVIEW:
Course Overview
Financial Modeling Using Excel
Planning your Financial Model
9:19
Building a Model Template
12:29
Projecting the Income Statement
13:13
Projecting the Balance Sheet
16:37
Projecting Cash Flows
14:22
Advanced Financial Modeling
13:58
Conclusion/Bonus Lesson
BONUS LESSON: Top 5 Excel Features for Financial Modelers
7:49
Continuous Play
Financial Modeling Using Excel
1:31:50
Lesson and Solutions
Start and Solution 2
XLSX
Start and Solution 3
XLSX
Start and Solution 4
XLSX
Start and Solution 5
XLSX
Start and Solution 6
XLSX
SUPPORTING MATERIALS
Slides: Financial Modeling Using Excel
PDF
Financial Modeling Using Excel Glossary/Index
PDF
REVIEW & TEST
REVIEW QUESTIONS
quiz
FINAL EXAM
exam