VTA's consulting work incorporates the use of high quality financial models whether for forecasting operations of start-up leasing projects (LeaseEx 2000), providing day-to-day consumer finance transaction support to a range of financial institutions (CapInvest) or rating leasing projects using VTA's proprietary tool (LeaseIndex). Model building is second nature to VTA.

Model building empowers an enterprise to map a real-life situation to a PC (regardless of functional area) so that the dimensions of a situation are explored and decision making is optimal.

"Financial Modeling is the process of building a clay model of a situation by (a) decomposing a situation into constituent variables; (b) establishing relationships amongst variables; and (c) manipulating variables, with a view to examining the dimensions of a situation and to establish basis for decision making."
Models provide the scientific basis for decision making whether in Human Resources, Marketing, Accounting, Treasury, Finance, Astronomy, Shipping, Manufacturing, Mining, Stock Broking, Mortgage Banking, or whatever - a situation needs to be decomposed into its constituent variables and mapped to a Model so that variables are manipulated for enterprise objectives.

"Whether you are a one-man show, NASA, a financial institution, a manufacturing or mining company, a laboratory, a university, a think-tank, or whatever, your operations will require the use of financial models - VTA's technical abilities and proprietary model building techniques will assist you in building models that are perfectly suited to your requirements. VTA employs Microsoft Objects and the firm's proprietary IPO framework to build models for you".

VTA assists enterprises to develop sophisticated models for a wide variety of situations:
 
• Monte Carlo Simulation Models
• Quality Control Models
• Forecasting Models
• Econometric Models
• Resource Planning Models
• Budgeting Models, Financial Statements Models
• Pricing Models
• Option Pricing, M&A, and other specialized Models
• Financial Evaluation Models, whether long-term or short-term
• Working Capital Forecasting Models
• Human Resources Models
• Treasury Models
• Accounting Models
• Statistical Models
• Models analyzing results of experiments
• Data Entry Models
• Data Analysis Models

VTA espouses its in-house "IPO" methodology in developing models - situation variables and tasks are categorized into "Inputs", "Processing" and "Outputs"."

Most enterprises are unaware that the best modeling tool is not the Million-dollar software that they have already invested in which is probably very good for capturing and retrieving large sets of data but unsuitable for numerical analysis. VTA employs proprietary modeling techniques that employ Microsoft Excel Objects and custom user-interfaces. Not only is this approach exceptionally cost-efficient, (a) it accesses the functionality of Excel's numerical engine which obviates the need to redevelop functionality; (b) the solution does not require costly investment since it operates on the Microsoft Office platform.

"The Financial Modeling Program was awesome. Viswanath has a wealth of knowledge and experience in Excel and Visual Basic and I was encouraged to explore and learn more about a whole new dimension of programming using Advanced Excel and Visual Basic. Viswanath is a guru in the field and presents the topic with zest and enthusiasm and I believe that all participants, past and future, will be challenged to explore and operate at a different level in their future career. I am a CA in South Africa, very involved in Financial Modeling and this course gives you the material and encouragement to use the power of Excel and Visual Basic to enhance and simplify your work."

Paul Swart
Finance Director
Outokumpu Technology (Pty) Ltd


"I enjoyed the manner in which the course material was set out. The trainer took us from the definition and concept of financial modeling, through advanced excel formula to an introduction of Visual Basic. This helped me understand exactly what could be done in both Excel and Visual Basic. The examples provided helped with much needed practice. Vish has a super knowledge of Excel and Visual Basic and he managed to convey this to his audience. With the training and some self study I am convinced that I will be able to build magnificent financial models in the future!"

Desiree Schreiber-Lok
Group Financial Manager
Transman (Pty) Ltd


 
There are seven distinct phases in developing a model (some may be rolled into other phases or while some may not be required):

Analysis
 
Understanding the requirements for a model.
Interaction
 
Translating preliminary thoughts into tangibles via interaction with end-user to ensure that activities are properly aligned with end-user expectations.
Coding
 
Writing of code and development of Graphical User Interface Elements to transform ideas into a working model.
Documentation
 
Development of documentation to provide information on features of the application.
Packaging
 
Developing an installation package for the application when the application needs to be distributed.
Security
 
Developing and embedding security procedures into the application when the application is made available via licensing or usage is restricted.
Training
  Providing hands-on training in the use of the model.
 
   

©2005-2007 /Vish Tumu Associates - Designed by Essel
1