EasyFinance

中文

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