Who is this guy John?

Pricing Derivatives

Valuing equity

Develop MS Excel

Spreadsheets for MS Excel

Javascripts used on this site!

My Resume

Check out these links

Back to the main page

Email me

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.
     

You are number