Welcome to John's (Janusz) Finance Page (wersja polska coming soon). I have
recently updated my site to include two new
areas, greater amounts of infomation in older
areas, and increased user friendliness. If you
have any problems e-mail me.
Finance
Tutorials and Files
I have been
asked countless times to provide a generic discounted cash flow model (DCF) and
it has finally arrived here. In addition to the DCF,
Spreadsheets Page, and my
Excel Development section, I have posted two tutorial reports. The
first report is based on derivative pricing
theories. This report gives an introduction to
three of the more popular theories, and goes into
detail regarding how the application of generated
algorithms can help price the models more
effectively. The second report is a large equity
valuation that was needed to value a divestiture
of a consolidated subsidiary. It includes an
overview, analysis of comparable companies, and
valuations based on multiples, divisional, and
discounted cash flow methods. This report is
contained in an Excel spreadsheet and a Microsoft
word file.
Excel
Development
One of the
new areas of my site is called Excel Development.
This area contains information on how to develop
Microsoft Excel into self contained programs that
run independently of the Excel window, but
acutally communicate with excel via Visual Basic.
I have recently developed an extensive program
for a large mutual fund company, and am in the
process of develping other programs for use
within the financial industry. On this page you
will find a demo download of my program called FOCARB, and tonnes of
infomation about Excel Development.
About Me, Resume, Feedback
You
will find that my site offers tonnes of
information on various finance related topics,
and you will also find infomation on myself. If
you are interested in finding more about me, be
sure to view my extended resume
(you require a password), my dossier, and my links.
Also, please fill out an interactive feedback form.
This will allow you to give valuable feedback for
my site.