Note: All The Links In The Video Description Are Affiliate Links, So I Can Make Money If Visitor Purchase The Products!
Learn How To Build a Financial Model With Microsoft Excel and Develop Financial Modeling Skills.
This intensive course is designed to develop financial modeling skills through actual hands-on construction of a model, and is the online version of Training The Street’s live courses at Wall Street’s 10 largest financial institutions and at the top 20 MBA programs in the United States. You will build your own interactive financial model from “scratch.” The end goal of the course is to give participants a practitioner’s view of financial modeling by blending accounting, corporate finance and Excel skills.
The completed product is a dynamic model with 5 years of projections and 3 years of historical data, containing the following detailed statements and schedules:Income statement, balance sheet and cash flow statement
Working capital schedule, depreciation and capital expenditure schedule
Intangibles amortization schedule
Shareholders’ equity schedule and share repurchases
Debt and interest schedule with a “cash sweep”
In addition, the course will cover the following topics:
Understanding and controlling circular references
Strategies for balancing a model
Sensitivity analysis to match expected financial performance
Fundamentals of “what-if analysis” using data tables
Building a practitioner’s Discounted Cash Flow (DCF) schedule
This course also includes Training The Street’s Financial Modeling online course certification.
In front of you is the very best out-of-classroom experience possible—a distillation of all the knowledge we’ve gained from training thousands of professionals in live seminars. You will not need any other resources to become proficient at Excel-based modeling. It’s a complete, self-contained course.
You should expect to complete the course in approximately 15 – 20 hours, depending on your financial modeling skills.
This course utilizes a Windows PC based version of Excel. If you are using a Mac running a Windows operating system and also a Windows based version of Excel, this course is also applicable to you.
Training The Street, Inc. (“TTS”) owns all rights, including copyrights, in this course. This course may not be reproduced or redistributed, in whole or in part, in any format or by any means without TTS’s prior written consent.
What are the requirements?
Basic accounting and financial statement analysis
Basic understanding of Excel
What are you going to get from this course?
Over 64 lectures and 7.5 hours of content!
By the end of the course, you will be able to construct a financial model that practitioners use to analyze a company from an operating, investing, financing, and valuation perspective.
You will learn foundations of financial modeling such as proper set up of a model, creating assumptions, and writing formulas.
You will learn how to effectively and efficiently read financial disclosure to extract the information needed for financial modeling.
You will create a dynamic financial model with full supporting schedules and robust analysis.
You will learn how to troubleshoot models and how to avoid pitfalls.
What is the target audience?
Enroll Financial Modeling With Excel Course Here: http://bit.ly/FinancialModelingWithExcel
For More Video Uploads In The Future Please Subscribe To This Youtube Channel by Clicking Subscribe Button Below!
and Don’t Forget To Giving Your “LIKE” For This Video! Please Click LIKE Button Below!
Thanks For Watching The Video! See You Next Time!