Home » Courses » Financial Modeling-Apparel Sector
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:
· 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.
Niharika Raut, Mumbai
View More . . .View Less . . .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.
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.
| 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 |
| 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 |
| 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 |
