Quick Excel for Financial Modeling
What you'll 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.
Requirements
- Basic proficiency with accounting and Excel.
Description
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.
Course content
- Preview04:12
- Preview09:18
- 12:28Building a Model Template
- 13:03Projecting the Income Statement
- 16:37Projecting the Balance Sheet
- 14:22Projecting Cash Flows
- 13:58Advanced Financial Modeling
- 07:48BONUS LESSON: Top 5 Excel Features for Financial Modellers
Instructors
Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.
Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.
Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.
A financial executive and corporate director with a broad base of experience working as a financial leader, catalyst, operator and steward in a number of public and private companies operating in a broad array of industries, with a deep background as a financial, consulting, and accounting educator providing professional development services to Big 4 Public Accounting Firms, universities, and professional institutes.
Specialties:Leadership, finance, accounting, mergers and acquisitions, auditing, instructional design, facilitation and instruction, authoring, decision analysis