Menu
  • Browse Courses
    • Finance
      • Financial Modeling
      • Equity Research
      • Project Finance
      • Commodities
      • Fixed Income
      • Derivatives
      • Investment Banking
      • Accounting
      • Economics
      • Private Equity
      • Credit Research
      • Corporate Finance
      • Risk Management
      • Banking & Finance
      • Finance for Non Finance
      • Technical Analysis
      • Close
    • IT
      • Development
      • IT & Software
      • Operating System
      • Design
      • IT Certification
      • SAS
      • Web Development
      • Programming Language
      • Hardware
      • Software Testing
      • Database
      • Mobile Apps
      • Software Engineering
      • E-commerce
      • Network & Security
      • Web Design
      • Animation
      • Close
    • Office Productivity
      • Excel
      • Access
      • Word
      • PowerPoint
      • Outlook
      • Mac
      • SAP
        • Technical
        • Functional
        • Close
      • Close
    • Project Management & Quality
      • Project Management
      • Quality
      • Test Prep
      • Close
    • Business
      • Marketing & Branding
      • Marketing
      • Operations
      • Management
      • General Management
      • Strategy
      • HRM
      • Engineering
      • Finishing School
      • Hospital Management
      • Insurance
      • Law
      • Close
    • Test Preparation
      • CFA
      • FRM
      • PRM
      • Close
    • Design
    • Close
Free Courses
 Pricing
Sign In
Sign In

Home » Courses » Financial Modeling-Apparel Sector

Financial-Modeling-Apparel-Sector
Financial Modeling-Apparel Sector

Description

  • Overview
  • Testimonials

Why Financial Modeling-Apparel Sector course?

Financial modeling deals with the forecasting the future financials of a company. This is a highly used and one of the important methods which is used in equity research and investment banking to analyze the financial performance of a company.

View More . . .View Less . . .

This is one of the techniques used for analyzing a stock or a company by many individual and institutional investors. Based on their analysis the decision is taken whether to buy or sell the stock of the particular company. So if you want to make your career in Equity research or Investment banking, be sure to know the nuts and bolts of Financial modeling. In this course you will learn to analyze American eagles outfitters by preparing its schedules such as depreciation schedule, shareholders equity schedule, Cost sheet, revenue build up etc. So let’s understand what are we going to learn in Financial Modeling – Retail & Apparel Sector course.

We are going to learn to create a complete financial model of American eagle outfitters. We are going to first understand the retails sector of USA. Then we are going to understand American eagles outfitters as a company. This company operates under the retail and apparel sector of America and Canada. It offers products like denims, sweaters, fleece, graphic T-shirts, footwear and accessories. It is also into personal care products for women which are sold under the brand name Aerie. Along with USA and Canada American eagles outfitters has opened its stores in international markets also. Being a debt free company, American Eagle Outfitters is considered as a top candidate for Leverage buyout also. In this course we are going to carry out the financial modeling of this company for the projected 5 years and we are going to analyze how the financials of the company change during the course of time.

In this course you will be learning:

  • Excel
  • Overview of Retail and Apparel industry of USA
  • Financial modeling of American Eagles Outfitters

Target Audience

·         Finance Students and Professionals

·         One who wants to learn Financial Modeling

·         Anyone who is interested to analyze American Eagles Outfitters which operates in the retail sector of America.

 

  • CURRICULUM

Testimonials

Niharika Raut, Mumbai

This course actually gave me enthusiasm and a new perspective towards financial modeling. The video training material was very easy in terms of explanation. I was able to grasp all the concepts easily. The course is industry relevant, thanks.

View More . . .View Less . . .
Reyaansh Sahani, Delhi

I enrolled for the edu cba’s course on Financial Modeling-Apparel Sector. I think it was a great learning experience for me. The material provided for the training is good. The course is actually the value for your money. Highly recommended.

Deepak Jain, Ahmadabad, a student of Financial Modeling-Apparel Sector course.

I was earlier not sure whether or not online courses are worth any value. But this course has led me to change my thinking. Awsuuuuum course I must say. Great way of learning financial modeling through this course and that too online.

 

  • CURRICULUM

Section 1: Basic Excel

1      Getting Started Ribbons Quick Access Toolbar
2      Getting Started Surfing Excel HELP Function
3      Excel Case Study
4      Data Entry in Excel
5      Populating the Case Study in Excel
6      Calculations Addition Subtract Multiply Division
7      Formulas SUM MAX MIN AVERAGE
8      Formatting Number Formats
9      Formatting Table Formats
10      Updating a Calculation
11      Percentages and Absolute References
12      Conditional Formatting
13      IF Function
14      COUNTIF Function
15      SUMIF Function
16      Creating Charts and Graphs
17      Create Pie Charts
18      Sorts
19      Filter
20      Pivot Table
21      Freeze and Split
22      Presentation Table Formats
23      Presentation Indents and Formatting Charts
24      Printing the Worksheet
25      Printing Headers and Titles
26      Shortcuts Formatting and Navigation
27      Shortcuts Selection Data and Formula
28      Common Errors
29      Download all Excel and PDF files

Section 2: Advanced Excel 2010

30      Office Button and Paste Function
31      Sparklines Custom Ribbons and Screenshots
32      Conditional Formatting and Equation Editor
33      Paste Special
34      Logical functions IF AND OR
35      Arithmetic functions MAX MIN ABS etc
36      COUNT COUNTIF COUNTA COUNTBLANK
37      Cell Information ISERROR ISBLANK etc
38      CHOOSE Function
39      VLOOKUP Function
40      HLOOKUP Function
41      MATCH INDEX
42      Database functions DSUM DAVERAGE DCOUNT
43      OFFSET Function Part 1
44      OFFSET Function Part 2
45      FORECAST Function
46      One Dimensional Data Tables
47      Two dimensional Data Tables
48      Solver
49      Goal Seek
50      Array Function Introduction
51      Array Function Row and Columns
52      Array Function TRANSPOSE
53      Array Function FREQUENCY
54      PROPER UPPER LOWER LEFT RIGHT MID
55      FIND CLEAN REPT CONCATENATE
56      Pivot Tables
57      Pivot Table Filter Slicer
58      Pivot Charts
59      Naming a Cell and a Range
60      Naming Dynamic Ranges
61      Auditing Toolbar
62      Watch Window
63      Group Boxes and Options Button
64      Check Boxes
65      List Boxes and Combo Boxes
66      Scroll Bar and Spinners
67      Text to Columns
68      Grouping Tabs
69      SUBTOTAL Function
70      Hyperlinks
71      Data Validation
72      Random Numbers
73      Custom View
74      Protecting Worksheet and Workbook
75      Excel 2010 Sparklines
76      Range Charts Type 1 Part a
77      Range Charts Type 1 Part b
78      Range Charts Area Type 2 Part a
79      Range Charts Area Type 2 Part b
80      Funding Graph
81      Two Axis Graphs
82      Scenario Graphs Part 1
83      Scenario Graphs Part 2
84      Average Line
85      Bar to Pie chart
86      Combo Charts
87      Creating Histogram
88      Invert Negatives
89      Scrolling Chart part 1
90      Scrolling Chart part 2
91      Download all Excel and PDF files

Section 3: Comprehensive Financial Modeling

92      What is Financial Modeling
93      Snapshot of Financial Model
94      Looking at the Assumptions
95      Calculating the Historical Ratios
96      Projecting Income Statement Revenues
97      Projecting Income Statement Costs
98      Calculating the Turnover Ratios
99      Forecasting the Working Capital
100      Working Capital Flow Diagram
101      BASE Equation Projecting Capital Expenditure
102      Projecting Depreciation Part 1
103      Projecting Depreciation Part 2
104      Depreciation Schedule Flow Diagram
105      BASE Equation Projecting Intangibles
106      Projecting Amortization
107      Amortization Schedule Flow Diagram
108      Projecting Other Long Term Items
109      Other Long Term Schedule Flow Diagram
110      BASE Equation Shareholders Equity I
111      BASE Equation Shareholders Equity II
112      Projecting ShareRepurchaseBuy Back and effect of Stock Options
113      Shareholders Equity Schedule Flow Diagram
114      Projecting Outstanding Shares
115      Completing the Cash Flow Statements
116      Projecting Debt Short term and Long
117      Concept of Cash Sweep Revolver Ending
118      Debt Schedule Flow Diagram
119      Important Understanding the Circular Reference in Detail
120      Download all Excel and PDF files

Register
  • Anytime Anywhere Access
  • HD Videos, Files, Tests & Assignments
  • Certificate of Completion

  • Application on a live company
  • Training like a Research Analyst
  • Make yourself Job ready
Related Courses

Credit-Research-Internship-Broadcasting
Credit Research Internship Broadcasting
Financial-Modeling-Automobile-Sector
Financial Modeling Automobile Sector
SAP-BASIS
SAP BASIS 
SAP---SAP-HCM
SAP – HCM Training
eduCBA © 2015
  • Blog
  • C-FAT
  • C-GAT
  • Terms and Conditions
  • Disclaimer
  • Privacy Policy
  • Shipping Policy
  • Contact Us