Saturday, 10 November 2012

FINANCIAL MODELING



Financial  modelling  is a course for those people  who already have a working knowledge of using Excel. But if you don’t know excel yet, you don’t need to worry as some training firms do start the process of training in excel knowledge before proceeding to the main course
Though most people don’t know about this course a lot have lost jobs they are capable of doing due to their inability to use the excel work sheet
 The course uses your Excel skills to build a lifelike model which forecasts the future performance of a company. The course also introduces a number  of important accounting issues which has to do with Working with different Excel program versions
Feature differences between different Pivot Table  formats from version 2007

which includes the Pivot Table Field List
  • Add fields
  • Rearrange fields
  • Remove fields
  • Change the PivotTable Field List view
  • Filter data before adding it to the report
  • Switch between automatic or manual updating of the report layout
  • Select individual cells
  • Select an entire report
  • Select all items in a field
  • Select item labels, data, or both
  • Select all instances of a single item
  • Select one instance of an item
  • Select multiple items
  • Select subtotals and totals


From the few topics given above on excel, financial modeling go more indept  into corperate finance
Covering such topics as

  • Future value
  • Present value
  • Net  present value.
  • The internal rate of return (IRR
  • What does IRR mean? Loan tables and investment amortization
  • Saving for the future buying a car for Mario
  • Saving for the future more realistic problems
  • And much more
Who is financial modeling for?
Managers,
Accountants
Financial analyst
Or it may also apply to individuals
generally  in  administration 
The cost  of financial modeling differs from one training firm to another ranging from $300 to $1000
Exam;I have not heard of any exam for financial modeling though there may be one

hope this has broaden your knowledge enough to know the right path to follow..

0 comments:

Post a Comment