What you'll learn:
- The essentials of financial statements modeling using Excel
- How to read and analyze SEC filings, 10K's & 10Q's reports
- Excel functions and shortcuts
- Financial statement analysis
- How to forecast an income statement
- How to forecast a balance sheet
- How to forecast a cash flow statement
- How to error-proof your financial model
- How to build scenarios
- How to forecast depreciation & amortization
- How to model a debt schedule
Shorten the learning curve. Learn the skills and gain the hands-on experience needed to become a professional analyst in weeks.
Financial statements modeling is essential and is the fundamental building block of analyzing a company through valuation methods. Students will learn how to build a dynamic financial statements projection model from scratch using real case studies, applying accounting, finance and Excel skills.
This course was carefully designed to teach students all the technical skills needed for a career in finance as a financial analyst. These skills are applied by finance professionals each day on the job. Our curriculum and content are grounded with best industry practices giving you a full immersion into the world of a professional analyst. By the end of the course, you will have a strong understanding of the financial modeling process. You will master the skills applied by professionals on Wall Street each day.
Topics Covered
· Performing due diligence
· Assumptions and model drivers
· Cash flow statements
· Financial models
· Debt schedule
· Equity analysis or equity research
· Error-proofing your financial model
Important:How to take this course: This course is part 2 of 4 video courses in our Analyst program series designed to teach you the soft and technical skills professionals apply on-the-job each day. With each of the first 3 courses, students learn principles, concepts and the practical application in the real world. You’ll compound your knowledge every step of the way in preparing for the 4th course, our full investment case analysis. Take this course serious, make a commitment to yourself to complete all 4 courses. By the end of all 4 courses, you’ll be proud of your effort and you’ll be ready to preform like a professional first day on the job or internship.
