Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Financial Statements Modeling 2020 Learn With A Professional
Rating: 4.5 out of 5(161 ratings)
1,101 students
Created byLuis Romero
Last updated 9/2020
English

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

Course content

4 sections70 lectures4h 49m total length
  • What You'll Need For This Course0:14
  • Welcome to Romero Mentoring0:47
  • How to Take This Course0:43
  • Meet Your Instructor0:40

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