Financial Modeling with Excel Training in Bogota

 Venue Details

Please contact us at

Financial Modeling with Excel Training in Bogota

Learners: 187
Financial Modeling with Excel Training in Bogota
Rated 5/5 based on 422 votes 12564

Financial Modeling with Excel Classroom Training in Bogota

13th - 15th Feb 2019

USD 1590
USD 1390


Upto: 31st Jan 2019


 Next Schedules

19th - 21st Mar 2019
EBD: 12th Feb 2019

24th - 26th Apr 2019
EBD: 19th Mar 2019

22nd - 24th May 2019
EBD: 23rd Apr 2019

17th - 19th Jun 2019
EBD: 16th May 2019

Group Discounts

3 participants-5%, 5 participants-10%, >=10 participants-15%

Financial modeling is the task of building a financial model, or the process of using a financial model for financial decision making and analysis. Financial modeling is used to do historical analysis of a company’s performance, and to do projections of its financial performance into the future. Project finance is another area that lends itself to financial models. A project (such as a real estate investment or a new factory) can be analyzed using a financial model. It does not have to be complete business.

Financial Modeling is not just for the accountant or financial consultant, who are called upon to develop financial projections, but also for business owners and managers. With improved user interfaces and heavy use of graphics, it is now feasible for non-technical people to use a financial model to test options and make decisions based on the projected impact on profits and cash flow.

  • Overview of financial modeling
  • Understanding projections
  • Excel best practices foundation and exercises
  • Useful Excel shortcuts and functions
  • Gathering historical documents / information
  • Preparation of Income and Cash Flow statements and Balance Sheet
  • Ratio Analysis
  • Du Pont Analysis
  • Financial Statement Analysis
  • Valuation of Companies
  • Valuation of IPOs
  • Valuation of Merger & Acquisitions
  • Valuation of Bonds
  • Valuation of Equity
  • Leverage Buyout Analysis (LBOs)
  • Sensitivity/Scenario Analysis
  • Monte Carlo Simulation
  • Case Study
  • Software Analysts
  • Finance Managers
  • Risk Managers
  • Chief Financial Officer
  • Credit Managers
  • Buyout Specialists
  • Financial Analysts
  • Financial Controllers

Any people who are graduates, post-graduates, Engineers and MBA finance, FRM degree holders.

  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
  • An understanding of the Internet and web-page functionality.