Syste
m (Hardware/Software)
Requirements
Operating
Software | Windows XP or
Higher
| Processor | Minim
um P4 or Higher
| RAM | 1 GB or
Higher
| Browser | Any
| Recommended Internet
Speed | Minimum 1MBPS
| Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionFinancial Modeling includes professionally forecasting future financial statements like Income Statements, Balance Sheets & Cash Flows. A financial model consists of one or more input parameters along with data and formulas that are used to perform calculations or make predictions. By changing the values of the input parameters, you can do "what-if" studies to see what happens when the inputs change. A Financial Model can help you in decision making whether to make investment in a company. It could also be used to represent the performance of a business, a project, or any other investment. Useful tools that allow business options and risks to be evaluated in a cost-effective manner against a range of assumptions. Helps in identifying optimal solutions and evaluating financial returns. This awesome course will deal with the followings:
Learn professional analyst's accounting to evaluate historical and current trends of a company in excel.
Effectively forecast trends and performance of the firm using analyst's tool like horizontal analysis, vertical analysis and ratio analysis.
Learn complex financial modeling by identifying and utilizing key business drivers and integrating them into a three statement forecasting model for a generic company.
Learn to efficiently build the financial model from scratch.
This course has 4 Financial Sector Modeling i.e. IT Sector, Education Sector, Oil & Gas Sector, Pharma Sector along with a General Sector Modeling. So, all together you get 5 sector modelings in this course.
This course requires knowledge in Microsoft Excel and Financial Accounting. If you are new to them, please find them here at Microsoft Excel and Financial Accounting.
Course Curriculum
Section1:Financial Modeling Using Excel - Overview
Lecture1:Financial Modeling Using Excel - Overview
Section2:Financial Modeling using Excel
Lecture2:
Section 2 - Download All Excel Files
Lecture3:What is Financial Modeling
Lecture4:Snapshot of Financial Model
Lecture5:Looking at the Assumptions
Lecture6:Calculating the Historical Ratios
Lecture7:Projecting Income Statement - Revenues
Lecture8:Projecting Income Statement - Costs
Lecture9:Calculating the Turnover Ratios
Lecture10:Forecasting the Working Capital
Lecture11:Working Capital Flow Diagram
Lecture12:BASE Equation & Projecting Capital Expenditure
Lecture13:Projecting Depreciation - Part 1
Lecture14:Projecting Depreciation - Part 2
Lecture15:Depreciation Schedule Flow Diagram
Lecture16:BASE Equation & Projecting Intangibles
Lecture17:Projecting Amortization
Lecture18:Amortization Schedule Flow Diagram
Lecture19:Projecting Other Long Term Items
Lecture20:Other Long Term Schedule Flow Diagram
Lecture21:BASE Equation & Shareholders Equity I
Lecture22:BASE Equation & Shareholders Equity II
Lecture23:Projecting Share-Repurchase/Buy Back and effect of Stock Options
Lecture24:Shareholders Equity Schedule Flow Diagram
Lecture25:Projecting Outstanding Shares
Lecture26:Completing the Cash Flow Statements
Lecture27:Projecting Debt - Short term and Long
Lecture28:Concept of Cash Sweep Revolver & Ending
Lecture29:Debt Schedule Flow Diagram
Lecture30:Important - Understanding the Circular Reference in Detail
Quiz1:Quiz 1
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace