Learn Financial Modeling from Scratch - Part1

Offered byUDEMY

Learn Financial Modeling from Scratch - Part1
at
UDEMY
Overview

Confidently & quickly create your own financial models. Quickly check even complicated models prepared by others

Duration	3 hours
Total fee	₹3,200
Mode of learning	Online
Credential	Certificate

Learn Financial Modeling from Scratch - Part1
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Get a 30 days money back guarantee on the course
Get full lifetime access of the course material
Learn from 6 downloadable resources

Learn Financial Modeling from Scratch - Part1
at
UDEMY
Course details

Skills you will learn

Excel Financial modelling Forecasting

Who should do this course?

For analysts in Investment Banking, Equity research, Institutional Equities, Private Equity, etc.

What are the course deliverables?

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

More about this 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 participants to build spreadsheet based projections from a blank worksheet
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

Learn Financial Modeling from Scratch - Part1
at
UDEMY
Curriculum

Introduction

Visualizing the Final Output

Introduction - II (Key Steps Before, After and While Building a Model)

Introduction to Financial Modeling

Keyboard Shortcuts

Easy Navigation in Excel

Editing based Keyboard Shortcuts

ALT based Keyboard shortcuts

Quick Formating using Keyboard Shortcuts

Formatting Dates in MS Excel

Tracing & Auditing in Excel

Attributes of an Ideal Financial Model - Simple

Attributes of an Ideal Financial Model - Accurate, Robust, Flexible

Attributes of an Ideal Financial Model - User Friendly and Logically Flowing

Financial Modeling Best Practices - Do's & Dont's

Common Errors in Financial Modeling

Quiz on Best Practices in Financial Modeling

Walking Through the Case - I (Overview of Financials Section)

Walking Through the Case - II (Overview of Non-Financial Info)

Walking Through the Case-Study

Creating the Template Sheet

Setting up the Dashboard

Creating Template for the Financial Model

Sourcing Historicals from the Case - Balance Sheet (Assets)

Sourcing Historicals from the Case - Balance Sheet (Liabilities & Equity)

Sourcing Historicals from the Case - Income Statement

Sourcing Historicals from the Case - Other Details from Notes & Schedules

Entering (Input) Historical Financials in the Model

Learn Financial Modeling from Scratch - Part1
at
UDEMY
Faculty details

AFT

Academy of Financial Training is engaged in providing niche financial trainings to companies, educational bodies and individuals. We have been in operation since ~4 years and have trained 5,000+ candidates and have a range of marquee MNC/corporate clients including companies like GE, Hewlett-Packard, Genpact, Canon, Deutsche Bank, IL&FS, Essar Steel, amongst others. Our strength has been the robust financial training content based on years of research backed by effective delivery provided by trainers with rich work experience in the domain.