Learn Financial Modeling from Scratch – Part1
Learn Financial Modeling from Scratch – Part1, available at $39.99, has an average rating of 4.25, with 29 lectures, 6 quizzes, based on 15 reviews, and has 32 subscribers.
You will learn about By the end of the three part program, you will be able build a financial model from a blank Excel worksheet. This includes analysing historical financial statements, noting important trends, preparing specialised calculation schedules, forecasting the financial statements This course is ideal for individuals who are Analysts in Investment Banking, Equity research, Institutional Equities, Private Equity or Professionals aspiring to be analysts in Investment Banking, Equity Research, Private Equity or Corporate Finance executives or Financial Analysts or Entrepreneurs and Businessmen It is particularly useful for Analysts in Investment Banking, Equity research, Institutional Equities, Private Equity or Professionals aspiring to be analysts in Investment Banking, Equity Research, Private Equity or Corporate Finance executives or Financial Analysts or Entrepreneurs and Businessmen.
Enroll now: Learn Financial Modeling from Scratch – Part1
Summary
Title: Learn Financial Modeling from Scratch – Part1
Price: $39.99
Average Rating: 4.25
Number of Lectures: 29
Number of Quizzes: 6
Number of Published Lectures: 29
Number of Published Quizzes: 6
Number of Curriculum Items: 35
Number of Published Curriculum Objects: 35
Original Price: $39.99
Quality Status: approved
Status: Live
What You Will Learn
- By the end of the three part program, you will be able build a financial model from a blank Excel worksheet.
- This includes analysing historical financial statements, noting important trends, preparing specialised calculation schedules, forecasting the financial statements
Who Should Attend
- Analysts in Investment Banking, Equity research, Institutional Equities, Private Equity
- Professionals aspiring to be analysts in Investment Banking, Equity Research, Private Equity
- Corporate Finance executives
- Financial Analysts
- Entrepreneurs and Businessmen
Target Audiences
- Analysts in Investment Banking, Equity research, Institutional Equities, Private Equity
- Professionals aspiring to be analysts in Investment Banking, Equity Research, Private Equity
- Corporate Finance executives
- Financial Analysts
- Entrepreneurs and Businessmen
About the Course:
Financial Modeling requires great skills in Practical
Finance, MS-Excel and Business / Industry analysis. This course is
one-step-solution which precisely covers all these areas and trains you
to build spreadsheet based projections from a blank worksheet.
So, if you are an entrepreneur preparing a business plan
for your potential investors or just a graduate dreaming to work as an
analyst at an Investment Bank, this is the program for you!
This entire Curriculum is divided into 3 different Courses
Learn Financial Modeling from Scratch – Part 1 – Current Course
Learn Financial Modeling from Scratch – Part 2
Learn Financial Modeling from Scratch – Part 3
This Course is Part – 1 of the three part series of the entire Course.
Training Materials:
Learning materials include
- Financial Modeling Case Study,
- Value-added Session Videos,
- Financial Model versions at each section-end,
- In-video prompters on Best Practices,
- Quick tips on Finance and MS Excel,
- Guide on Keyboard Short-cuts for better efficiency,
- Handbook on Basics of Excel and Basics of Finance (Coming Soon!)
Course Facilitator (Faculty):
The course is facilitated by Ashutosh Zawar, who is a
rank-holder Chartered Accountant and a Bachelor of Commerce from
University of Pune, India. He is a Co-Founder & Lead Trainer @
Academy of Financial Training. He has over 9 years of experience across
Investment Banking, Project Finance, Consulting and Training.
Ashutosh has over 1,000 hours of professional training experience.
He looks after the e-learning, multimedia content management at Academy
of Financial Training (AFT). He has been instrumental in launching
AFT’s new training programs and innovating curriculum across topics such
as Advanced Financial Modeling, Excel, Banking, Corporate Finance.
Before co-founding AFT, he worked with the Project Finance
team at IDFC, a leading financial services company in the Infrastructure
domain and the Investment Banking team at Morgan Stanley. he has worked
on sectors such as healthcare, education, tourism, telecom and energy.
His work profile included operational and financial modeling, business
appraisal, valuation analysis, drafting of terms and commercial
negotiations.
Duration:
The entire 3 part course takes about 8-10 hours of video-based learning and 20-30 hours of simultaneous self-practice on MS Excel.
Structure of the Course:
- The course guides candidates to start with a blank
Excel spreadsheet and goes on to build full-fledged forecasts of
Financial statements i.e. Balance Sheet, Income Statement and Cash flow
Statement - A real-life case-study of a manufacturing company has been considered for this program
- It
also includes important calculation schedules like Capital Expenditure,
Depreciation, Working Capital, Loan or Debt, Interest, Income Tax, Cash
balancing mechanism.
Why take this Course?
- Hundreds of classroom editions of the program
already executed and ongoing for leading banks, manufacturing companies
and b-schools. - Course content designed, recorded and edited
by professionals with rich work experience in Investment Banking, Equity
Research, Project Finance and Business Consulting domains at
world-class banks. - Focus on simplicity, accuracy and efficiency (Building quickly)
- Best practices and common errors to avoid in Financial Modeling covered
- Live support from expert trainers during and after the programs
Course Curriculum
Chapter 1: Introduction to Financial Modeling
Lecture 1: About the Program
Lecture 2: Visualizing the Final Output
Lecture 3: Introduction to Financial Modeling
Lecture 4: Introduction – II (Key Steps Before, After and While Building a Model)
Chapter 2: Keyboard Shortcuts
Lecture 1: Easy Navigation in Excel
Lecture 2: Editing based Keyboard Shortcuts
Lecture 3: ALT based Keyboard shortcuts
Lecture 4: Quick Formating using Keyboard Shortcuts
Lecture 5: Formatting Dates in MS Excel
Lecture 6: Tracing & Auditing in Excel
Chapter 3: Best Practices in Financial Modeling
Lecture 1: Attributes of an Ideal Financial Model – Simple
Lecture 2: Attributes of an Ideal Financial Model – Accurate, Robust, Flexible
Lecture 3: Attributes of an Ideal Financial Model – User Friendly and Logically Flowing
Lecture 4: Financial Modeling Best Practices – Do's & Dont's
Lecture 5: Common Errors in Financial Modeling
Chapter 4: Walking Through the Case-Study
Lecture 1: Walking Through the Case – I (Overview of Financials Section)
Lecture 2: Walking Through the Case – II (Overview of Non-Financial Info)
Chapter 5: Creating Template for the Financial Model
Lecture 1: Creating the Template Sheet
Lecture 2: Setting up the Dashboard
Chapter 6: Entering (Input) Historical Financials in the Model
Lecture 1: Sourcing Historicals from the Case – Balance Sheet (Assets)
Lecture 2: Sourcing Historicals from the Case – Balance Sheet (Liabilities & Equity)
Lecture 3: Sourcing Historicals from the Case – Income Statement
Lecture 4: Sourcing Historicals from the Case – Other Details from Notes & Schedules
Chapter 7: Calculating & Analysing Historical Trends
Lecture 1: Rationale for Analyzing Historical Trends
Lecture 2: Historical Trends – Defining Income Statement Trends
Lecture 3: Historical Trends – Calculating Expense Trends
Lecture 4: Historical Trends – Calculating Expense Trends (Fixed vs. Variable Discussion)
Lecture 5: Historical Trends – Calculating Working Capital Trends
Lecture 6: Historical Trends – Calculating Capex and Other Ratios
Instructors
-
AFT –
Premium Institute focused on Advanced Finance Programs
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 2 votes
- 4 stars: 4 votes
- 5 stars: 8 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024