Financial Modeling: Link the Three Financial Statements in Excel

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Course Overview

The 3 financial statements are all linked and dependent on each other. In financial modeling, your first job is to link all three statements together in Excel, so it’s critical to understand how they’re connected. This is also a common question for investment banking interviews, FP&A interviews, and equity research interviews.

FREE COURSES & CERTIFICATES

Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:

ABOUT CORPORATE FINANCE INSTITUTE

CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world.

By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst.

 

Certification

Upon completing this course, learners will receive a verified certificate that will boost their career

Show More

Course Content

Financial Modeling: Link the Three Financial Statements in Excel

  • Download the Excel template
  • Discounted Cash Flow (DCF) Formula
  • Enterprise Value vs Equity Value
  • Overview of the Capital Markets: Key Players
  • Learn Accounting Fundamentals
  • How to Read a Financial Statement
  • Financial Analysis Fundamentals
  • How to Build a Financial Model in Excel
  • Fixed Income Fundamentals
  • Behavioral Finance Fundamentals
  • Sensitivity Analysis for Financial Modeling
  • How to Build a Forecasting Model in Excel
  • Excel Crash Course for Finance Professionals
  • Mining Financial Modeling & Valuation Course
  • eCommerce Startup Valuation
  • How to Write Macros in Excel
  • How to Calculate Net Present Value, Annuity & Perpetuity
  • Introduction to Corporate Finance
  • Advanced Excel Formulas
  • Excel Tutorial – Audit Financial Models with GO TO SPECIAL
  • Learn About All the Steps in an M&A Deal

Student Ratings & Reviews

No Review Yet
No Review Yet