Name: Introduction To Financial Modeling Course and Training- Henry Harvin® in Detroit | Henry Harvin
Uploaded: 2021-03-13 14:24:51
Description: Financial Modeling & Valuation Analyst is the Core Skill across all Finance Domains | Hands-on Training on Excel Workbooks | Most in-demand Prerequisites for Finance professionals in India | Industry relevant content | Case-studies based hand-on training

Module 1: MS Excel Tips
In this module the candidate will learn about creating a Financial Model Template, Formatting the Data, Imported File, converting text to numerical using text to columns, using the referencing framework, Converting Data into a tabular format, and Identifying High- profit sales using conditional formatting.
- Understanding and creating a Financial Model template
- Case: Formatting the data, summarizing, and creating a presentable format
- Formatting the imported file with text to columns
- Getting the relevant information from a string of data using Left, Trim
- Converting text to numerical using text to columns
- Using referencing framework (usage of $) to effectively use formulas
- Summarize the sum of sales with Pivot Tables
- Converting data into a tabular format
- Identify high-profit sales using conditional formatting
- Quiz Module 1
Module 2: Financial Statement and Ratios Analysis
In this module the candidate will learn about Financial Statements, Financial Reporting Mechanics, Balance Sheets, Inventories, Ratio Analysis of Industries, DU Points and Preparation of Financial Analysis reports on an Industry
- Introduction to Financial Statement Analysis
- Financial Reporting Mechanics
- Understanding Income Statement, Balance Sheet, Cash Flow Statement
- Financial Analysis Techniques
- Inventories, Long-Lived Assets
- Non-Current Liabilities
- Financial Statement Application
- Ratio analysis of Industries
- Du point Analysis
- Peer to peer analysis
- Preparation of Financial Analysis report on an industry
- Quiz Module 2
Module 3: Financial Management and Corporate Finance
In this module, the candidate will learn Financial Management and Corporate Finance, which includes understanding Time Value Financing, Cost of Capital, and Measure of Leverage.
- Time value of money
- Long term financing
- Cost of capital
- Measure Of Leverage
- Quiz Module 3
Module 4: Project Finance Modeling
In this module, the candidate will learn about Project Finance Modelling, which lays emphasis on Stages of project, Life of Project, Cash Flow Waterfall, and Resolving Circular Reference.
- Why Project evaluations
- Stages of project
- Construction & development phase
- Funding during investment phase
- Costs during the investment phase
- Life of project; decision making
- Cash flow waterfall
- Resolving circular reference
- Quiz Module 4
Module 5: Equity Research Modeling
In this module, the candidate will learn about Equity Research Modelling, which includes, Understanding of how to prepare Financial Statement, Analysis of Revenue and Costs, Project Future Financial Statements, Valuation of Discounted Cash Flow Method, and Preparing Presentation Sheet.
- Prepare Financial Statement
- Analyze Revenue and Costs
- Forecast Revenues, Costs, Debt, etc.
- Project Future Financial Statements
- Performa Adjustments, Compute Margins/Ratios
- Valuation- Discounted Cash Flow Method (DCF), Others
- Prepare Presentation Sheet, Company Overview, Sector Overview
- Quiz Module 5
Module 6: Financial Reporting Writing
In this module, the candidate will learn about Financial Report Writing and introduction of Different sectors such as telecom, IT, Oil and Gas, etc.
- Report Writing: On the basis of Financial Modeling,
- Overview of different sectors such as retail, telecom, IT, Oil & Gas, etc.
- Quiz Module 6
Module 7: Cash Flow Statement
- Three Statement Model (Operating Activities, Investing Activities, Financing Activities)
- Operating Cash flow
- Investing Cash flow
- Financing Cash flow
- Cash Balance
Module 8: Modeling Practice
In this module, a candidate will learn and comprehend about various aspects of modeling practise. H/She will learn about Modeling cost Build-up, Modeling Revenue Build-up, Modeling assumptions for future action, and more submodules.
- Data Collection and Data Structuring
- Preliminary Scrutiny of the Data and Information
- Understand the Business Model and Operating Model
- Modeling the Historical Statement
- Modeling Assumptions for Future Action
- Modeling Revenue Build-up – projecting the future revenues
- Modeling Cost Build-up – projecting the future cost
- Modeling the Asset Schedule
- Modeling the Depreciation Schedule – Book and Income Tax Depreciation
- Working Capital and Term Loan Modeling – Debt Infusion
- Tax Modeling, MAT, and MAT credit
- Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payable
- Equity Modeling – Equity Infusion
- Modeling Paid Up Capital and Share Premium Account
- Modeling Retained Earning Schedule
- Modeling the Financial Statements, Ratio Analysis
- WACC and Cost of Equity Analysis
- Performing Valuation using DCF (FCFF and Enterprise Value) and Comparable Analysis (Relative Valuation)
- Performing Sensitivity/Scenario Analysis
- Comparing the Valuation Summary using Different Parameters on a football field
- Quiz Module 7
Module 9: Miscellaneous Practice
This module will inform a candidate of the miscellaneous practice that help alongside other componenets to run a business smoothly.
- Data Collection from Public Sources
- Understanding the Business Profile of the Compan
- Modeling Revenue and Expenses Drivers
- Modeling Income Statement
- Modeling Implied EBITDA
- Balance Sheet Projections
- Cash Flow Statement Projection
- Performing Valuation and Sensitivity Analysis
- Calculating Enterprise Value and Implied Market capitalization
- Quiz Module 8

Financial Modeling & Valuation Analyst (FMVA) Course Certification in Detroit

09 Dec 2024

70 Hours

09 Dec 2024

70 Hours

Book a Live Class, For Free!

Accreditations & Affiliations

Know the complete offerings of our Financial Modeling Course in Detroit

Key Highlights

70 Hours of Instructor-Led Sessions

23 Hours of Live Interactive Doubt Solving Sessions

12 Hours of Live Master Sessions by Industry Experts

192 Hours of Self-Paced Learning

Job-Ready Portfolio of 7 Capstone Projects

78 Auto-Graded Assessments

14+ Industry Case Studies

105 Guided Hands-On Exercises

7+ Assignments and Mini Projects

2 Mock Interviews and 2 Hackathons

Get 1-Year Gold Membership of Henry Harvin® Finance Academy

Get a guaranteed Internship with Henry Harvin® and in top MNCs like J.P. Morgan, Accenture & many more via Forage

Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting

5 Hours of Mentorship by Industry Experts

Earn Certification of Course from Henry Harvin®, Govt of India recognized & Award-Winning Institute and NSDC Certification

Key Highlights

70 Hours of Instructor-Led Sessions

23 Hours of Live Interactive Doubt Solving Sessions

12 Hours of Live Master Sessions by Industry Experts

192 Hours of Self-Paced Learning

Job-Ready Portfolio of 7 Capstone Projects

78 Auto-Graded Assessments

14+ Industry Case Studies

105 Guided Hands-On Exercises

7+ Assignments and Mini Projects

2 Mock Interviews and 2 Hackathons

Get 1-Year Gold Membership of Henry Harvin® Finance Academy

Get a guaranteed Internship with Henry Harvin® and in top MNCs like J.P. Morgan, Accenture & many more via Forage

Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting

5 Hours of Mentorship by Industry Experts

Earn Certification of Course from Henry Harvin®, Govt of India recognized & Award-Winning Institute and NSDC Certification

Our Placement Stats

Access the best jobs in the industry

You Get 10-In-1 Program

About Financial Modeling Course in Detroit

AGOTA™ Framework

Trainers at Henry Harvin®

Alumni Status

Uses of Financial Modeling

Gold Membership Benefits

Learning Benefits

Recognitions of Henry Harvin® Education

Career Benefits

Curriculum For Financial Modeling Course in Detroit

Module 1: MS Excel Tips

Module 2: Financial Statement and Ratios Analysis

Module 3: Financial Management and Corporate Finance

Module 4: Project Finance Modeling

Module 5: Equity Research Modeling

Module 6: Financial Reporting Writing

Module 7: Cash Flow Statement

Module 8: Modeling Practice

Module 9: Miscellaneous Practice

Admission Closes On 09 Dec 2024

Upcoming Cohort

Henry Harvin® Ranks #1

Starts in 6 day. 09 Dec 2024

Upcoming Cohorts

Skills Covered

Tools Covered

Financial Modeling Course Trainers

Sameep

Certifications

Get Ahead with Henry Harvin® Financial Modeling Course in Detroit Certification

What you'll Learn in this course

Development and Analysis of Financial Model

Advanced Financial Techniques

Formatting of Excel Sheets

Mechanics of Financial Reporting

Creating Income Statement

Application of Financial Statement and Ratio Analysis