Financial Statements Modeling 2020 Learn With A Professional

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
Requirements
Business Fundamentals Course (1 of 4)
You should have a strong commitment to learn
You’ll also need Excel 2007, 2010, 2013 or 2016
If you’re working on a laptop, you’ll need a simplistic external keyboard
Description
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.

Who this course is for:
Anyone pursuing a career in investment banking, accounting, private equity, hedge funds, corporate development, and business development
Anyone looking to acquire the core technical and soft skills professionals on Wall Street implement on the job
Anyone who wants a career transition into finance
Entrepreneurs who want to develop their professional skills and grow a business
Anyone looking to learn financial modeling, company valuation and stock analysis skills
Any student looking to learn advance financial analyst skills