Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Next Update: LBO Valuation!
Would you like to learn how to value a company?
Even people who don't have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model!
Attention! You will have to go through the videos and the course materials in order to obtain the promised result!
If you want to:
·deepen your Microsoft Excel modeling skills
· learn how to value a company
· understand what drives a company's value
Then this course is the right one for you!
What we offer:
·Well designed and easy to understand materials
·Detailed and comprehensible explanations
·Regular course updates
By the completion of this course you will:
·Be able to build a Cash Flow statement
·Know how to value a company
·Be able to build a Valuation model from scratch
·Know how to create a model with multiple scenarios
·Be able to perform sensitivity analysis
·Know how to create professional and good-looking advanced charts
The instructor of this course has extensive experience in Financial Modeling:
·Worked in the Financial advisory unit of a top-tier consulting firm
·Experience in M&A transactions carried out in Italy, Germany, Switzerland and Poland
·Worked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the world
·Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion
About the course:
·An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content
·No significant previous experience is needed in order to understand the course well and benefit fully from its content
·Unlimited access to all course materials
·Emphasis on learning by doing
·You can always contact us for any clarification free of charge
·Our goal is to take your Valuation skills to the next level
Make an investment that will be well rewarded in terms of career perspectives, positive feedback and personal growth.
Just go ahead and subscribe to this course! Nowadays the job market has become very competitive. If you don't acquire these skills now you will miss an opportunity to separate yourself from others. Don't risk your future success! Let's start learning together now!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Financial Modeling Fundamentals|
Horizontal vs. Vertical Financial ModelsPreview
Creating a Financial Model: Important ConsiderationsPreview
You Need These Tools Before Building a Financial Model
Matrix Integrity of Financial Models
|Section 2: Introduction to Company Valuation|
Company Valuation - Theoretical Framework
|Section 3: Learn how to build a Discounted Cash Flow model in Excel - Introduction|
Learning by Doing - Learn How to Value a Company - Introduction to Case Study 2
A Quick Summary of The Various Stages of a Complete DCF ValuationPreview
Let's Go Through The Structure the DCF Model That We Will Create in Excel
A Glimpse At the Company We Are Valuing - Cheeseco
|Section 4: Forecasting of key P&L items|
Modeling the Top Line of the Financial Model
This Is How You Can Build Flexible Financial Models in Excel
Modeling Other Items: Other Revenues and Cogs
Modeling Other Items: Operating Expenses and D&A
Modeling Other Items: Interest Expenses, Extraordinary Items and Taxes
|Section 5: Forecasting of key Balance Sheet items|
How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way
A Key Concept for Finance Practitioners - the "Days" Methodology
Learn How to Calculate "Days"Preview
How to Use "Days" in Order to Project the Future Development of Some BS Items
Forecasting Property Plant & Equipment, Other assets and Other liabilities
|Section 6: Creating clean output sheets|
Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model
Applying What We Learned in Practice - Populating the P&L Sheet
This is How you Can Create a Clean Output Balance Sheet in Your Financial Model
Completing the Output BS Sheet For the Historical Period
|Section 7: Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows|
Learn How to Calculate Unlevered Free Cash Flows
Important! It Is Always Good Practice to Reconcile UFCF to Net Cash Flow
A Very Useful Lesson! Learn How To Calculate Cash Flows
Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash in BS
The Fast and Effective Ways to Modify Multiple Cell References in Excel
|Section 8: Calculating Present Value of Cash Flows within the forecast period|
Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate
Learn How to Find The Present Value of Future Cash Flows in Financial Models
|Section 9: Calculating Continuing Value,Enterprise Value and Equity Value of the business|
Calculating Continuing Value and Enterprise Value of the Business
Final Steps! Calculate Equity Value of the Business Under Consideration
|Section 10: Additional analyses accompanying the Financial Model|
Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth
Excel tools in Practice - An Application of Goal Seek
Recap of the Financial Model with Charts and Hypothesis Testing
Congratulations! You Made It!
Introduction to Mergers & Acquisitions
365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting and Investment Banking trainings. Our goal is to provide to our students the practical instruments that they will need in order to perform successfully at their future workplace.
Microsoft Excel and PowerPoint are the top productivity tools in today's corporate world. By choosing our trainings, you will be well on your way of becoming an expert in MS Excel and PowerPoint.