Library

Course: Quick Excel for Financial Modeling

Quick Excel for Financial Modeling

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

In this course we 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. 

We concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We use an approach that keeps model integrity and credibility top of mind throughout development.

Who this course is for:

  • Anyone interested in finance, accounting, or related fields
Basic knowledge
  • Basic proficiency with accounting and Excel
What you will learn
  • Identify a disciplined approach for using Excel to develop financial analysis
  • Discover how to prepare financial projections of the income statement, balance sheet, and statement of cash flows
Curriculum
Number of Lectures: 11
Total Duration: 01:31:44
Introduction
  • Course Overview  
  • Planning your Financial Model  
  • Quiz: Planning  
  • Building a Model Template  
  • Quiz: Building the Template  
  • Projecting the Income Statement  
  • Quiz: Projecting the income statement  
  • Projecting the Balance Sheet  
  • Quiz: Projecting the balance sheet  
  • Projecting Cash Flows  
  • Quiz: Projecting cash flows  
  • Advanced Financial Modeling  
  • Quiz: Advanced financial modeling  
  • BONUS LESSON: Top 5 Excel Features for Financial Modellers  
Supporting Materials
  • Slides: Financial Modeling Using Excel  
  • Financial Modeling Using Excel Glossary/Index  
  • Excel Files "Start and Solution"  
Rating
Enrolled Students
(72)
Level
Intermediate
Price
$ 9.00
Course Language
English
Reviews (0)