Financial Modeling Workshop

Audience

  • Credit analysts
  • Chief financial officers
  • Financial analysts
  • Managers of all branches of the economy
  • Employees responsible for budget planning, writing company
  • Professionals responsible for project appraisal from banks and financial institutions
  • Professionals from corporate finance/ projects division of corporate
  • Financial Intermediaries involved in syndication of project finance
  • Project finance consultants

Course Outline

Course Objectives:
The course is designed to cover the following key objectives:

  • Appreciate the difference between what makes a good model and a bad one
  • Follow a logical, structured and disciplined approach towards model building
  • Build a model (or significant parts of one) from start to finish
  • Learn how to translate key financial and commercial aspects into Excel
  • Understand better how to tailor the outputs of the model towards end users and interpret the results
  • Improve knowledge of Excel functionality
  • Learn ways to reduce the incidence of modeling errors

Pre-requisites:
Some prior knowledge and experience is assumed. For example, participants should have:

  • The ability to navigate easily around Excel’s menu options
  • Working knowledge of financial statements and rudimentary accounting
  • A basic understanding of leading approaches towards financial Modeling

Course Outline:

Module 1: Assumptions build-up

Module 2: Building automated timeline

Module 3: Timing and Event activation Flags

Module 4: Revenue Buildup (PPA / Merchant Sale) with YoY escalation in prices

Module 5: Capex Schedule

Module 6: Use of BASE Analysis

Module 7: Amortization/Depreciation schedule

Module 8: Interest during Construction (IDC) – to be capitalized

Module 9: Waterfall Structure of funding

Module 10: Incorporating Revolver Balance & Minimum Cash Balances

Module 11: Debt schedules & repayment

Module 12: Working Capital schedule & Linkages

Module 13: Building iterative calculation for Interest

Module 14: Others: IRR, NPV, Ratios, What If Analysis, Relevant Shortcuts

Click here to view detail course content

  • 10% Early Bird Discount if enrolled on or before 11 June 2018.
  • 15% Discount on group registration of 4 or more participants
  • 20% Discount on corporate group registration of 8 or more participants

Payment can be made using Debit card/Credit Card/NEFT/Cheque.

Fees is inclusive of laptop, lunch and participation certificate.

Note:

*Pragati Software reserves the rights to postpone any program due to insufficient nomination.

Show

Fees : Rs. 16000 + 18% GST

Date : Batch I: 16-17 June 2018 Batch II: 14-15 July 2018

Duration : 2 Days

Location : Mumbai

© 2017 Pragati Software Pvt. Ltd. All Rights Reserved.

Enquiry