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
- 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
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.
· 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
Mr. Romero has over a decade of professional finance, investing, and entrepreneurial experience. Mr. Romero’s passion for teaching led him to create Romero Mentoring, an EdTech platform to educate the next generation of finance professionals. Before Romero Mentoring, he founded Romero Capital, a private long/short equity fund. Before this, he served as a senior instructor at the New York School of Finance and conducted financial training programs for corporate and individual clients across the U.S., Canada, and Germany.
Before his teaching career, Mr. Romero was an equity analyst and trader at Seven Points Capital, executing long and short equity strategies. He began his career at Credit Suisse as a Mergers & Acquisitions analyst in New York, where he acquired deal experience in the technology, industrial, and health care industries. He has also worked with food & beverage and education start-ups.
Mr. Romero holds a B.B.A. in Finance and Investments with a minor in Philosophy from Baruch College, Zicklin School of Business. He was born in Santo Domingo, Dominican Republic, and grew up in the Bronx, New York.