 |
 |
 |
 |
 |
 |
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.
|
 |
|
|
|
 |
|
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. |
|
|
|
|
|

|
 |