Certified Accountant Program
Financial modeling is the process of creating a summary of a company's expenses and earnings in the formofaspreadsheet thatcan be used to calculate the impact of a future event or decision.
A financial model has many uses for company executives. Financial analysts most often use it to analyze and anticipate howa company's stock performance might be affected by future events or executive decisions.
Overview
- Lectures 8
- Quizzes 1
- Duration 60 hours
- Skill level Beginner
- Language English
- Students 32
- Assessments Yes
Learning Outcomes & Flexibilities
- Over 17 modules and 55.5 hours of content!
- Implement your theoretical learning practically on your own website .
- Understand Design-Based Thinking & Planning.
- Demonstrate cognitive knowledge of the skills required in conducting online research and research on online markets, as well as in identifying, assessing and selecting digital market opportunities..
- Investigate and evaluate issues in adapting to globalised markets that are constantly changing and increasingly networked.
- Interpret the traditional marketing mix within the context of a changing and extended range of digital strategies and tactics.
- Comprehend the importance of conversion and working with digital relationship marketing.
- Analyse cross-cultural and ethical issues in globalised digital markets
- One Training 9 Certifications: DSIM industry recognised certification, 7 google certifications & facebook certification.
- Build your own Website .
- Best suitable for beginners to advanced level users and who learn faster when demonstrated.
- Back up classes, in case you miss few classes.
- Batches as per your availability- Evening, Weekend, Sunday, Online .
- Doubt Clearing Session: 2 hours doubt session every month after completion of training at no charges
- INR 63,624/- Free Tools & Softwares: Lead capture plugin, WP Theme, E-commerce tools, Content builder tool, SEO Software, Push notification tool, website conversion app.
- Learn the art of making money online known to very few experts worldwide.
- In-Class & Online Classes: 2 comprehensive platforms to choose from: Live interactive online training & in-class training.
- Job assistance and interview scheduling.
Curriculum
-
1.Excel Proficiency Overview
-
1.1 Formatting of Excel Sheets
-
1.2 Advanced Modeling Techniques
-
1.3 Data Filter and Sort
-
1.4 Charts and Graphs
-
1.5 Table formula and Scenario building
-
1.6 Lookups:Vlookup
-
1.7 pivot tables
-
1.8 Use of Excel Formula Function
-
-
2. Financial Statement Analysis & Ratios
-
2.1 Introduction to Financial Statement Analysis
-
2.2 Introduction to Financial Statement Analysis
-
2.3 Understanding Income Statement, Balance Sheet, Cash Flow Statement
-
2.4 Financial Analysis Techniques
-
2.5 Inventories,Long-Lived Assets
-
2.6 Non-Current Liabilities
-
2.7 Financial Statement Application
-
2.8 Ratio analysis of industries
-
2.9 Du point Analysis
-
2.10 Peer to peer analysis
-
2.11 Preparation of Financial Analysis report on an industry
-
-
3. Financial Management & Corporate Finance
-
3.1 TIMEVALUE OF MONEY.
-
3.2 LONG TERMFINANCING
-
3.3 COST OF CAPITAL
-
3.4 MEASURE OF LEVERAGE
-
-
4. Project Finance Modeling
-
4.1 Why Project evaluations
-
4.2 Stages of project
-
4.3 Construction & development phase
-
4.4 Funding during investment phase
-
4.5 Costs duringinvestment phase
-
4.6 Life of project; decision making
-
4.7 Cash flow waterfall
-
4.8 Resolving circular reference
-
-
5. Equity Research Modeling
-
5.1 Prepare Financial Statement
-
5.2 Analyze Revenue and Costs
-
5.3 Forecast Revenues, Costs, Debt etc
-
5.4 Project Future Financial Statements
-
5.5 Performa Adjustments, Compute Margins/Ratios
-
5.6 Valuation- Discounted Cash Flow Method (DCF), Others
-
5.7 Prepare Presentation Sheet,Company Overview , Sector Overview
-
-
Part 1. Final Test120 minutes