Text = Text + "Real Time Financial Swap Trading/Hedging System"
Text = Text + crlf + crlf
Text = "System automates the pricing, marking to market, and hedging of a portfolio of financial "
Text = Text + "swaps. In addition, there is a live link to market data via a network server. And finally, "
Text = Text + "daily profit and loss information is uploaded to the mainframe for comparison to the back "
Text = Text + "office system. "
Text = Text + crlf + crlf
Text = Text + "This application utilizes a number of advanced Excel features such as access to external "
Text = Text + "databases through macro driven SQL statements passed to Q+E via DDE calls. It also "
Text = Text + "incorporates a set of DLL routines written in 'C' accessible via macro linkage."
Text = Text + crlf + crlf
Text = Text + "The system is deployed globally. Users reside in New York, London, and Tokyo."
Applications(1) = Text
Text = Text + "Client Presentation System"
Text = "Developed for an investment management firm in Boston as a marketing tool, this system "
Text = Text + "enables the principals of the firm to communicate their approach to money management "
Text = Text + "by interactively developing a number of scenario based horizon analyses at the client's "
Text = Text + "location. The application was developed using Excel and runs on a 16 mhz 386SX "
Text = Text + "portable computer. The client is able to:"
Text = Text + crlf + crlf + " * establish his or her view of future interest and foreign exchange rates;"
Text = Text + crlf + crlf + " * develop a model portfolio of multi-currency fixed income securities;"
Text = Text + crlf + crlf + " * pick a currency allocation (i.e. how the clients portfolio should be distributed by currency), and"
Text = Text + crlf + crlf + " * select a horizon period."
Text = Text + crlf + crlf
Text = Text + "These choices are then used to forecast the value of the portfolio at the horizon and break "
Text = Text + "the results down between returns earned from bonds vs. currency speculation. Using a "
Text = Text + "library of DLLs, the system is able to produce horizon results in a matter of seconds. The "
Text = Text + "client can then easily modify the financial scenario and portfolio, rerun the analysis, and "
Text = Text + "compare the results of one run to another. This application relies heavily on the use of "
Text = Text + "charts which depict client vs market views, and horizon analysis results."
Applications(2) = Text
Text = Text + "Liability Management System"
Text = "Developed as a marketing tool for a major New York investment banking firm, the "
Text = Text + "system is used to evaluate portfolios of debt obligation. Different types of debt "
Text = Text + "instruments are modeled to measure a common set of results and test alternative "
Text = Text + "strategies. Using this system, the investment banking firm has been able to show clients "
Text = Text + "how they can restructure debt service in order to lower costs and improve overall "
Text = Text + "corporate profitability. The firm uses the application in its New York, London, and "
Text = Text + "Tokyo offices. "
Applications(3) = Text
Text = Text + "Asset Based Swap System"
Text = "A state of the art system which prices and values a number of complex synthetic "
Text = Text + "securities. The application handles various financial structures which are derived by "
Text = Text + "coupling an asset (e.g. a corporate bond) with a swap. By doing this, synthetic floating "
Text = Text + "rate or fixed rate instruments can be created and marketed to the investment community. "
Text = Text + crlf + crlf
Text = Text + "The system relies heavy on 'C' written subroutines called from Excel macros. In "
Text = Text + "addition, several calculators have been incorporated into the system. These allow the "
Text = Text + "trader to quickly determine the trade-offs which exist between the costs of individual "
Text = Text + "structure components and the final price for the package. This unique and powerful "
Text = Text + "feature enables the client to respond quickly to market movements in order to lock in "
Text = Text + "profit on prospective deals."
Applications(4) = Text
Text = Text + "Financial Allocation System"
Text = "Developed for one of the Regional Bell Operating Companies (RBOC), this system "
Text = Text + "compares corporate financial results under varying common cost assumptions. As a result "
Text = Text + "of FCC regulations, all RBOCs are required to allocate expenses which are common to "
Text = Text + "their regulated and non-regulated companies in a prescribed way. Unfortunately, these "
Text = Text + "allocation rules are not always consistent with true economic costs. This Excel system "
Text = Text + "enables the client to change allocation assumptions quickly and measure the results for "
Text = Text + "the regulated, unregulated and total corporate financials. The system is used by the "
Text = Text + "marketing organization in order to determine the financial impact of providing "
Text = Text + "unregulated services. Financial statements are constructed reflecting varying views and "
Text = Text + "scenarios."
Applications(5) = Text
Text = Text + "Profit and Loss Analysis System"
Text = "This system was developed in order to compare the back office and trading desk views of "
Text = Text + "financial interest rate and currency swap profit and loss. It retrieves and reconciles data "
Text = Text + "from a mainframe back office system and a PC-based trading system. Spot data for two "
Text = Text + "points in time (e.g. daily, weekly, monthly, etc.) from each system is linked together and "
Text = Text + "compared for each transaction. The transactions can then be organized in any order. "
Text = Text + "Transactions with large back office/trading desk discrepancies are viewed using a ZOOM "
Text = Text + "feature, where all of the relevant data associated with a suspicious trade can be "
Text = Text + "instantaneously transferred to an analysis model. From there, a determination of probable "
Text = Text + "errors is made, with resulting corrections implemented. The system has increased the "
Text = Text + "client's ability to control the trading operation."
Applications(6) = Text
Text = Text + "LDC Debt Trading and Analysis System"
Text = "One of the first of its kind, this system keeps track LDC debt trading activity and interest "
Text = Text + "information, and generates daily profit/ loss reports. In addition to monitoring trading "
Text = Text + "activity, the system maintains a database of information for securities, daily marks, "
Text = Text + "accrued interest, financing data, payments/receipts, and counterparty/ contact listings. "
Text = Text + "Written in Excel and using DDE to communicate with Q+E, the system updates various "
Text = Text + "database files in such a manner that the data can be combined, segmented and analyzed in "
Text = Text + "a number of ways without sacrificing the integrity of the original data. After daily "
Text = Text + "profit/loss statements are produced, the system generates detailed interest accounting "
Text = Text + "reports which are uploaded to the mainframe accounting system."
Applications(7) = Text
Text = Text + "P&L SWAP Reconciliation System"
Text = "Excel-based system used to reconcile all weekly profit/loss discrepancies between a PC-"
Text = Text + "based trading inventory system and a mainframe accounting system. The system accepts "
Text = Text + "a wide variety of mainframe data which is compared to the trading system on a "
Text = Text + "transaction-by-transaction basis. The system allows for the 'point and click' creation of a "
Text = Text + "wide variety of data views which expedites the process of reconciling and closing the "
Text = Text + "financial books for each accounting period."
Applications(8) = Text
Text = Text + "LDC Graphical Analysis System"
Text = "Designed for an Emerging Markets Trading group of a major investment banking firm, "
Text = Text + "the system uses Excel and Q&E to track and graph daily market information for LDC "
Text = Text + "debt instruments. Traders use the system to review trends and abnormalities in LDC "
Text = Text + "market behavior over time. The system features an intuitive user interface which allows "
Text = Text + "for the creation of multi-security graphs and a variety of views from a minimal number "
Text = Text + "of mouse clicks. Graphs based on price, coupon, yield, and a variety of other relavent "
Text = Text + "variables are easily produced."
Applications(9) = Text
End Sub
Sub SetBiographiesText ()
Dim Text As String, crlf As String
crlf = Chr$(13) + Chr$(10)
Biographies(0) = BiographiesText
Rem Michael Landau
Text = "Michael has been designing, developing, and implementing computer based "
Text = Text + "solutions for more than 20 years. During that time he has developed systems "
Text = Text + "at all levels of the corporate data processing architecture using a variety of "
Text = Text + "tools. His systems are used daily by numerous Fortune 500 companies for "
Text = Text + "solving complex business problems. Michael was a pioneer in the Personal "
Text = Text + "Computing industry, having begun a software business in 1979 utilizing this "
Text = Text + "technology to improve corporate results through increased revenue "
Text = Text + "production and/or decreased operational expenses."
Text = Text + crlf + crlf
Text = Text + "Recent systems developed include:"
Text = Text + crlf + crlf + " * Swap Trading System"
Text = Text + crlf + crlf + " * Swap Hedging System"
Text = Text + crlf + crlf + " * Swap Pricing System"
Text = Text + crlf + crlf + " * Synthetic Securities Tracking and P/L System"
Text = Text + crlf + crlf + " * Synthetic Floater Advanced Calculator"
Text = Text + crlf + crlf + " * Client Portfolio Presentation System"
Text = Text + crlf + crlf + " * Financial Allocation System"
Text = Text + crlf + crlf + " * Business Planning and Analysis System"
Text = Text + crlf + crlf
Text = Text + "Prior to forming Landau & Associates, Michael was Director of Strategic "
Text = Text + "Planning at AT&T's Computer System Division. During this time he had "
Text = Text + "responsibility for the development of the financial services, education, and "
Text = Text + "international markets. In addition he was Senior Vice President and Chief "
Text = Text + "Operating Officer of The Ventus Group, a Washington, D.C. based "
Text = Text + "consulting firm specializing in Soviet technology based joint ventures."
Text = Text + crlf + crlf
Text = Text + "Mr. Landau has extensive experience in all aspects of computing at the PC, "
Text = Text + "workstation, and mainframe levels in the corporate data processing "
Text = Text + "architecture. In recognition of his expertise, Microsoft has designated him a "
Text = Text + "Consulting Relations Partner."
Text = Text + crlf + crlf
Text = Text + "Michael holds a Bachelor of Science degree in Economics and a Masters of "
Text = Text + "Science degree in Quantitative Analysis from New York University."
Biographies(1) = Text
Rem Suzie Akers
Text = "Suzzie Akers Biography"
Biographies(2) = Text
Rem Brad Crysel
Text = "Brad has developed numerous PC/Windows based applications for "
Text = Text + "leading corporate clients. His applications solve complex business "
Text = Text + "problems using state of the art computing tools and are specifically "
Text = Text + "designed to be easy to use. "
Text = Text + crlf + crlf
Text = Text + "Systems developed include:"
Text = Text + crlf + crlf + " * Swaps Trading System"
Text = Text + crlf + crlf + " * Comptroller Profit/Loss Comparison System"
Text = Text + crlf + crlf + " * LDC Trading System"
Text = Text + crlf + crlf + " * Interest Tracking System"
Text = Text + crlf + crlf + " * Cash Management System"
Text = Text + crlf + crlf + " * Stockholder Tax & Accounting System"
Text = Text + crlf + crlf
Text = Text + "Each of these systems are Windows based, following industry "
Text = Text + "standards for user interface and therefore integrate seamlessly with the "
Text = Text + "clients' existing environment."
Text = Text + crlf + crlf
Text = Text + "Prior to joining Landau & Associates Brad worked at Morgan Stanley "
Text = Text + "& Co. in the Fixed Income Division. Brad held positions of increasing "
Text = Text + "responsibility in the Swaps Trading Group. During this time Brad "
Text = Text + "developed expertise in a number of financial products traded in "
Text = Text + "international markets. These include Interest Rate and Currency "
Text = Text + "Swaps, Forward FX contracts, Libor based Eurodollar futures "
Text = Text + "contracts, trading confirmation and documentation procedures. Brad "
Text = Text + "has a unique blend of knowledge of front and back office "
Text = Text + "trading/system requirements."
Text = Text + crlf + crlf
Text = Text + "Brad attended Auburn University, Regent's College in London, and "
Text = Text + "graduated from the University of Virginia with a Bachelor of Arts. "
Biographies(3) = Text
Rem Stephen Jasko
Text = "Stephen has been developing PC/Windows and Workstation based business "
Text = Text + "applications since 1984. His applications solve complex business problems "
Text = Text + "covering a wide range of disciplines. Stephen's applications utilize state of "
Text = Text + "the art computing tools and features intuitive graphical user interfaces. "
Text = Text + crlf + crlf
Text = Text + "Systems developed include:"
Text = Text + crlf + crlf + " * Comptroller Profit/Loss Reconciliation System"
Text = Text + crlf + crlf + " * LDC Analysis System"
Text = Text + crlf + crlf + " * Swap Hedge Analysis System"
Text = Text + crlf + crlf + " * Private Line Bill Reconciliation System"
Text = Text + crlf + crlf + " * Market Data Inventory Control System"
Text = Text + crlf + crlf + " * Telecom Complaint Tracking System"
Text = Text + crlf + crlf + " * Corporate Budget Consolidation"
Text = Text + crlf + crlf
Text = Text + "These systems were developed using industry standard software "
Text = Text + "development tools and methodologies. In addition, they were designed to "
Text = Text + "seemlessly and easily access data which resides in various levels of the "
Text = Text + "corporate data processing architecture."
Text = Text + crlf + crlf
Text = Text + "Prior to joining Landau & Associates Stephen worked at Merrill Lynch, Dun "
Text = Text + "& Bradstreet, and AT&T. During this time he developed a wide range of "
Text = Text + "experiences in telecom finance management, financial budgeting and "
Text = Text + "forecasting, order processing, automated bill reconciliation, econometric "
Text = Text + "modeling, statistical evaluation of billing data, direct mail marketing, and "
Text = Text + "other financially oriented business functions."
Text = Text + crlf + crlf
Text = Text + "Mr. Jasko has extensive experience in all aspects of computing at the PC, "
Text = Text + "workstation, and mainframe levels in the corporate data processing "
Text = Text + "architecture."
Text = Text + crlf + crlf
Text = Text + "Stephen earned a Bachelor of Science degree in Computer Science at "
Text = Text + "Montclair State and a Masters of Business Administration in Finance from "
Text = Text + "Rutgers University."
Biographies(4) = Text
Rem Jean Hagmann
Text = "Jean Hagmann Biography"
Biographies(5) = Text
End Sub
Sub SetOverviewText ()
Dim Text As String, crlf As String
crlf = Chr$(13) + Chr$(10)
Overview(0) = OverviewText
Text = "Landau & Associates, formed in 1987, is dedicated to the philosophy that the "
Text = Text + "effective use of today's technology leads to significant improvements in business "
Text = Text + "results. We design, develop and implement systems that lead to enhanced "
Text = Text + "revenues and reduced expenses. "
Text = Text + crlf + crlf
Text = Text + "The emergence of the Personal Computing market has led to an explosion of "
Text = Text + "sophisticated software applications that transform inexpensive desktop computing "
Text = Text + "into a wide variety of business tools. Today, the average business has a host of "
Text = Text + "desktop computers that have more number crunching power than most Mainframe "
Text = Text + "Computers had several decades ago. Unfortunately, users exploit only a fraction of "
Text = Text + "this power."
Text = Text + crlf + crlf
Text = Text + "Landau & Associates understand the importance of providing a full range of "
Text = Text + "services to its clients:"
Text = Text + crlf + crlf + " * Technology Assessment"
Text = Text + crlf + crlf + " * System Specifications"
Text = Text + crlf + crlf + " * Software Design"
Text = Text + crlf + crlf + " * Software Development"
Text = Text + crlf + crlf + " * System Documentation"
Text = Text + crlf + crlf + " * Operational Conversion"
Text = Text + crlf + crlf + " * System Integration and Implementation"
Text = Text + crlf + crlf + " * Training"
Text = Text + crlf + crlf + " * Ongoing Support"
Text = Text + crlf + crlf
Text = Text + "We have developed desktop computing systems which address business needs "
Text = Text + "ranging from Fixed Income Trading to Inventory Control. Our team has a proven "
Text = Text + "record of solving all types of business and organizational problems by integrating "
Text = Text + "today's advanced hardware and software technologies."
Text = Text + crlf + crlf
Text = Text + "Our data processing experience includes expertise in PCs, Workstations, "
Text = Text + "Mainframes, and Networks. The firm's software expertise includes, but is not "
Text = Text + "limited to, Microsoft Windows, UNIX, C, C++, APL, SyBase, FORTRAN, "
Text = Text + "VBasic, Excel, Word for Windows, DBase IV, Clipper, MS-DOS, etc."
Text = Text + crlf + crlf
Text = Text + "Landau & Associates has been designated a Microsoft Consulting Relations "
Text = Text + "Partner."
Overview(1) = Text
End Sub
Sub SetServicesText ()
Dim Text As String, crlf As String
crlf = Chr$(13) + Chr$(10)
Services(0) = ServicesText
Text = Text + "Technology Assessment"
Text = "A full review of your operations from the perspective of technology use. We will:"
Text = Text + crlf + crlf + " * evaluate your current hardware and software computing environment;"
Text = Text + crlf + crlf + " * identify major business activities that lend themselves to automation;"
Text = Text + crlf + crlf + " * assess the degree to which your current technology base is effectively utilized, and"
Text = Text + crlf + crlf + " * make recommendations concerning better use of existing technology and opportunities for using or employing additional hardware and/or software to improve business results."
Services(1) = Text
Text = Text + "System Specifications"
Text = "Time spent efficiently gathering and refining system requirements increases the "
Text = Text + "likelihood of a successful development program. We have extensive experience in "
Text = Text + "this area and will draw upon it to:"
Text = Text + crlf + crlf + " * analyze and specify the various tasks which the system will automate;"
Text = Text + crlf + crlf + " * describe the user interfaces and their associated data items, and"
Text = Text + crlf + crlf + " * describe the outputs of the system;"
Text = Text + crlf + crlf + " * define the performance requirements of the system;"
Text = Text + crlf + crlf + " * identify how the system will behave under a varying set of conditions;"
Text = Text + crlf + crlf + " * arrive at the detailed hardware, software, and networking requirements of the system."
Services(2) = Text
Text = Text + "Software Design"
Text = "Given the System Specifications, a plan will be developed to implement your "
Text = Text + "requirements. This service covers the following:"
Text = Text + crlf + crlf + " * selection of an appropriate hardware platform;"
Text = Text + crlf + crlf + " * selection of appropriate development software;"
Text = Text + crlf + crlf + " * a blueprint of interactions between various components of the system;"
Text = Text + crlf + crlf + " * identification and description of specific data items and procedures, and"
Text = Text + crlf + crlf + " * specific description and flow of each task to be automated."
Services(3) = Text
Text = Text + "Software Development"
Text = "This service can range from modifying existing software to the creation of custom "
Text = Text + "software using industry standard development tools. Specifically, Landau & "
Text = Text + "Associates offers the following services:"
Text = Text + crlf + crlf + " * development of software templates;"
Text = Text + crlf + crlf + " * development of command macros to customize existing software packages;"
Text = Text + crlf + crlf + " * linkage of existing software packages to accomplish a stated task;"
Text = Text + crlf + crlf + " * development of custom software where existing software packages are not available, or are impractical to use."
Services(4) = Text
Text = Text + "System Documentation"
Text = "At Landau & Associates, we believe in providing three levels of documentation so "
Text = Text + "that the system will be easy to use and maintain. They are:"
Text = Text + crlf + crlf + " * system documentation;"
Text = Text + crlf + crlf + " * hard-copy documentation for the client, and"
Text = Text + crlf + crlf + " * on-line documentation."
Services(5) = Text
Text = Text + "Operational Conversion"
Text = "The conversion to a new way of doing business is frequently overlooked. Not "
Text = Text + "paying attention to this phase of systems development can often lead to additional "
Text = Text + "cost or even an inability to use the system. We offer the following services:"
Text = Text + crlf + crlf + " * procedural modifications;"
Text = Text + crlf + crlf + " * record conversion;"
Text = Text + crlf + crlf + " * batch validation;"
Text = Text + crlf + crlf + " * parallel run comparison, and"
Text = Text + crlf + crlf + " * condition testing and system modification."
Services(6) = Text
Text = Text + "System Integration and Implementation"
Text = "Once the components of the system have been testing and verified as working "
Text = Text + "correctly, they must be integrated into your existing computing environment. This "
Text = Text + "will require one or more of the following:"
Text = Text + crlf + crlf + " * hardware links to other computing platforms such as servers and mainframes;"
Text = Text + crlf + crlf + " * software links to external databases, information sources, and analytics; "
Text = Text + crlf + crlf + " * modifications of operational procedures and staffing, and "
Text = Text + crlf + crlf + " * testing and modification of the system as required."
Services(7) = Text
Text = Text + "Training"
Text = "Landau & Associates offers a wide range of training services. They include:"
Text = Text + crlf + crlf + " * training on the use of custom developed applications;"
Text = Text + crlf + crlf + " * training on the use of commercial software packages;"
Text = Text + crlf + crlf + " * custom training based on specific user requirements, and"
Text = Text + crlf + crlf + " * training developers to customize commercial packages."
Text = Text + crlf + crlf
Text = Text + "See the Training Catalog for a listing of currently available courses."
Services(8) = Text
Text = Text + "Ongoing Support"
Text = "We do not consider our job done once the project development and training has "
Text = Text + "concluded. Landau & Associates stands ready to assist you in the continuing job "
Text = Text + "of making your technology investment pay off. We fully support each system and "
Text = Text + "help you further identify opportunities for improving business results. Specifically, "
Text = Text + "we provide the following services:"
Text = Text + crlf + crlf + " * hot-line arrangements;"
Text = Text + crlf + crlf + " * periodic training visits, and"
Text = Text + crlf + crlf + " * upgraded for hardware and/or software."
Text = Text + crlf + crlf
Text = Text + "In addition, we publish the Landau & Associates Newsletter quarterly that keeps "
Text = Text + "you abreast of what is happening in the world of computing and its impact on your "
Text = Text + "business."
Services(9) = Text
End Sub
Sub SetTrainingText ()
Dim Text As String, crlf As String
crlf = Chr$(13) + Chr$(10)
Training(0) = TrainingText
Text = Text + "Introduction to Microsoft Excel"
Text = "An Introduction to the use of Microsoft Excel. This course "
Text = Text + "is designed to help the new user become comfortable "
Text = Text + "using Excel by providing in class assignments which "
Text = Text + "illustrate the basic skills required for the use of "
Text = Text + "spreadsheets in the business environment."
Training(1) = Text
Text = Text + "Excel Basics for Lotus 1-2-3 Users"
Text = "This course goes beyond the simple conversion of Lotus 1-"
Text = Text + "2-3 commands to Excel. Class assignments in a laboratory "
Text = Text + "setting are used to illustrate methods which maximize the "
Text = Text + "capabilities of Excel which do not exit in Lotus. Users are "
Text = Text + "introduced to techniques which will help them increase "
Text = Text + "their productivity."
Training(2) = Text
Text = Text + "Productive Financial Modeling in Excel"
Text = "Class assignments in a laboratory setting are used to "
Text = Text + "illustrate Excel financial modeling capabilities which can "
Text = Text + "drastically increase productivity in the workplace. This "
Text = Text + "course covers topics specific to financial modeling such as "
Text = Text + "goal seeking, solver functions, charting, financial functions, "
Text = Text + "database usage, consolidation, and an overview of "
Text = Text + "Excel/Word for Windows integration."
Training(3) = Text
Text = Text + "Automating Tasks in Excel"
Text = "The course goes beyond the 'macro record' feature to "
Text = Text + "teach users how to maximize the benefits of the Excel "
Text = Text + "macro language. Topics include writing command macros "
Text = Text + "to automate repetive tasks, function macros which add "
Text = Text + "user defined functions to Excel, creating add-in "
Text = Text + "worksheets, and the creation of template worksheets. "
Text = Text + "Class assignments in a laboratory setting are used to "
Text = Text + "illustrate Excel's ability to automate a variety of tasks. "
Training(4) = Text
Text = Text + "Excel Macros for Lotus 1-2-3 Users"
Text = "Class assignments in a laboratory setting take the users "
Text = Text + "beyond the built in translation feature found in Excel and "
Text = Text + "highlight the fundamental differences which exist between "
Text = Text + "the two macro languages."
Training(5) = Text
Text = Text + "Applications Development in Excel"
Text = "Excel provides a robust macro environment which can "
Text = Text + "allow for the cost efficient development of application "
Text = Text + "prototypes and complete applications. Class assignments "
Text = Text + "in a laboratory setting illustrate proven techniques which "
Text = Text + "can be used to create a wide variety of applications."