HOME > Public Semina > Course Online

 
EXCEL FINANCIAL MODELING

In actual work, every month, or even every day, we are doing the same tasks: ranking, summarizing, calculating, analyzing and making charts according to a large amount of data, the only difference is that we are using different data every time. Is there any method can make Excel?calculate and process the data for us instead of doing all these things by ourselves? The Excel?model can do the things mentioned above.
By using the Excel?financial model, you only need to input and update a few items of regenerated data and Excel?will automatically work out the outcome you want.
This course will teach you how to project these time-consuming and burdening jobs to the Excel?model, thus saving your time and improving working efficiency.


Training Objectives

Understand what an Excel?financial model is
How to build a simple, effective and safe Excel?financial model
Learn to build a DuPont model, gross margin analysis model and project financial feasibility analysis model, etc
Acquire various Excel?models that can be applied to your actual work, even without modification

 

Training Attendees

CFO, financial manager, general ledger accountant, cost analyst, financial analyst, project analyst and other financial professionals
 
 
       
Training Outline
 


How to build a financial model in Excel®
 
  • What is a simple and effective financial model?
  •  
  • Basic Excel knowledge for building a financial model
  •  
  • What kind of financial problems can be solved by models?
  •  
  • Steps in building a financial model
  •  
  • Problems that should be considered when building an Excel financial model


  • DuPont Analysis Financial Model
     
  • Theory foundation of DuPont analysis
  •  
  • How detailed should the analysis be?
  •  
  • Excel skills used in the DuPont model


  • Project Feasibility Analysis Model
     
  • What role does financial personnel play in the project?
  •  
  • Contents of project feasibility analysis
  •  
  • How to calculate the financial indexes of the project with Excel functions.
  •  
  • Excel skills used in the project feasibility analysis model


  • Gross Margin Analysis Model
     
  • Why gross margin analysis is important
  •  
  • What is volume variance?
  •  
  • How to dynamically display part of the data in one chart
  •  
  • Excel skills used in the gross margin analysis model


  • Automatic Generation of a Cash Flow Statement Model
     
  • Principle of a cash flow statement
  •  
  • How to standardize a balance sheet and an income statement
  •  
  • Other information needed in drafting a cash flow statement
  •  
  • Is the indirect method difficult?
  •  
  • Excel skills used in a cash flow statement model


  • Enterprise Management Panel Model
     
  • Which KPI should be included in the panel?
  •  
  • How to use a management panel in enterprise management
  •  
  • Excel skills used in a management panel model
  •  
                         
    City
    Day
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Dec
    Price
     
    Call For Registration:
    +86 21 58362000 810


     
     
    RECENT TRAINING


     
     
      EASYFINANCE MANAGEMENT CONSULTING CO.,LTD
    Tel:+86 21-58362000 / 15801919100  Fax +86 21-58361896  
    E-MAIL :BD@EasyFinance.com.cn
    CopyRight ® EASYFINANCE
     
    瀹㈡埛鏈嶅姟
    live chat