Premium Essay

Financial Modelling

In: Business and Management

Submitted By plutovich
Words 57326
Pages 230
Advanced Modelling in Finance using Excel and VBA
Mary Jackson and Mike Staunton


New York









Copyright  2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): Visit our Home Page on or All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency, 90 Tottenham Court Road, London W1P 9HE, UK, without the permission in writing of the publisher. Other Wiley Editorial Offices John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, USA Wiley-VCH Verlag GmbH, Pappelallee 3, D-69469 Weinheim, Germany John Wiley & Sons Australia Ltd, 42 McDougall Street, Milton, Queensland 4064, Australia John Wiley & Sons (Asia) Pte Ltd, 2 Clementi Loop #02-01, Jin Xing Distripark, Singapore 129809 John Wiley & Sons Canada Ltd, 6045 Freemont Blvd, Mississauga, ONT, L5R 4J3, Canada

British Library Cataloguing in Publication Data A catalogue record for this book is available from the British Library ISBN 0 471 49922 6 Typeset in 10/12pt Times by Laserwords Private Limited, Chennai, India Printed and bound in Great Britain by Bookcraft (Bath) Ltd, Midsomer–Norton This book is printed on acid-free paper responsibly manufactured from sustainable forestry, in which at least two trees are planted for each one used for paper production.

Preface Acknowledgements 1…...

Similar Documents

Premium Essay

Financial Modelling for a Strategic Investment Case

...value of Equity Shares.The shares were valued as a multiple of 5 times the weighted average EPS for last three years i.e. 2010-2012 considering qualitative factors such as diversified business model and high growth prospects based on valuation of company. The weighted average EPS for 2010-12 is 3 (approx). • Thus shares are issued to PE @ Rs150 per share (EPS 3* 5 times*face value of share 10) • PE investment enables company to raise more loans. The capital thus raised, was also used for advertising and brand building thus increasing the net sales of the company by an average of 60% • Company is raising Debt through Secured Loans hypothecated by company assets as well as Unsecured Loans and a Bank Revolver • PE exits the business in financial year end of March 2015. It offers its stake for sale in the IPO that the company has planned in May 2015 • In May 2015 the company issues an IPO. The offer is both an offer for sale and fresh issue of shares to public. The IPO will provide liquidity to PE and raise capital for further expansion of business. • Total 80,25,000 shares are issued to the public . • 20,00,000 shares belong to the PE. The proceeds from the sale of these shares will go to the PE • The additional 60,25,000 shares are issued to the public for raising capital and the proceeds will be used in further expansion of business and buying of new land, plant and machinery. • The face value of the Equity Shares of the Company is Rs. 10 each and the Issue Price is......

Words: 534 - Pages: 3

Free Essay

Modelling in Operational Research.

...Foundations of Operational Research and Business Analysis 1 Assignment 2013/14 Author: Thibaut Achard de Leluardière Abstract: Looking through the infinite number of theories and models developed in organisations, this assignment aims at finding out the founding principles of a good OR/MS model and general issues encountered in the setting-up of OR interventions. To try out and compare the insights presented, this assignment proposes to study a specific case about OR modelling in Fishery management. Fishery Management is related to the preservation of fish resources and optimisation of catch and profit of this industry, in a context of high-yield practices and increasingly more complex environmental issues present. This case applies to a large and complex system linked to today’s topics issues of sustainable development. In addition, a personal experience of analytical project related to an internship position as assistant project manager in a leading oil company is proposed to illustrate this essay. This essay concludes by giving recommendations about what could be the characteristics of an ideal portrait of OR/MS model. Introduction: In a letter addressed to English universities after the Second World War, general Pile, a popular British officer who commended the Anti-Aircraft Command, claims for men of sciences ‘able to quickly understand complex issues and to find them simple’. Thus, supporting the fast economic growth in Europe after war,......

Words: 4178 - Pages: 17

Premium Essay

Competency Modelling

...Competency modelling: A better approach in contemporary HRM practice? Introduction In the contemporary human resource management (HRM) practice, the process of human resource assessment and selection is shifting from the traditional job-based system of HRM to a newly-established competency approach. According to Dubios’ work (1998), more and more medium-sized and larger organizations are adopting the competency approach to replace the traditional job-oriented method to select and assess their employees in the USA and around the globe. This change happens mainly for the reason that the traditional job-based personnel management systems have shown a tendency to break down when jobs are dissolving under more flexible working conditions and simplification of the bureaucratic hierarchies of the contemporary organizations (Lawler, 1999). Based on the works of Nyboe (2004), in principle there are two distinct approaches to align work and competencies: to start with the work and adjust people and their qualifications to work requirements (job or production approach) or, alternatively, to start with the worker and assign tasks to workers according to their skills (competency or training approach). On one hand, in the job approach, tasks are grouped into individual jobs according to what is regarded a rational division of labor, and workers are recruited and trained to meet the requirements of those tasks. On the other hand, a competency approach has a shift of focus from...

Words: 2345 - Pages: 10

Premium Essay

System Dynamic Modelling

...1. Abstract System Dynamic Modelling is an approach to frame and solve complex problems. It is widely used for policy design and analysis. System dynamics analysis is a part of Systems Theory which is used to study the dynamic behaviour of complex systems. The theory is based on acknowledgement of the fact that the inter-relations between the various components of a model, time delays between processes are as important to analyse the behaviour of a model as is the analysis of individual components.  SD models solve the problem of simultaneity (mutual causation) by updating all variables in small time increments with positive and negative feedbacks and time delays structuring the interactions and control. In this paper, we have discussed the basic methodology of the technique, and the modelling process. Then, we have discussed the applications of SDM ranging from conventional ones like project management and science and engineering to exploring the concepts of SDM in Brand management and public health issues. 2. Historical background This technique of solving problems was developed in 1950s by Prof Jay Forrester of Massachusetts Institute of Technology, during his involvement with General Electric. He developed his insights about the foundations of engineering which helped him in the creation of system dynamics. He studied the problem of instability in GE employment. In this he did hand simulations (or calculations) of the stock-flow-feedback structure of the GE plants...

Words: 2058 - Pages: 9

Premium Essay

Financial Modelling

...Financial Reporting and Disclosure Corporate governance framework should ensure that timely and accurate disclosure is made on all material matters regarding the corporation, including the financial situation, performance, ownership, and governance of the company Importance of Corporate Governance Disclosures * Stakeholders are paying more attention to what is reported * The global financial crisis has sharpened the lens through which corporate governance structures are held to account and expectations around transparency. * To drive improvements in reputation * Public understanding of structure and activities * Relationships with the communities * Environmental issues Public disclosure is typically required, at a minimum, on an annual basis though some countries require periodic disclosure on a semi-annual or quarterly basis, or even more frequently in the case of material developments affecting the company. Companies often make voluntary disclosure that goes beyond minimum disclosure requirements in response to market demand. A strong disclosure regime that promotes real transparency is a pivotal feature of market-based monitoring of companies and is central to shareholders’ ability to exercise their ownership rights on an informed basis. Experience in countries with large and active equity markets shows that disclosure can also be a powerful tool for influencing the behaviour of companies and for protecting investors. A strong disclosure......

Words: 9232 - Pages: 37

Free Essay

Rock Physics Modelling

...Rock Physics Modelling Rock physics is an essential part of any seismic reservoir characterisation project. The rock physics may be as simple as establishing empirical relationships between rock properties or as complex as poroelastic numerical modelling. The sophistication of the modelling will depend on the objectives and the quality and availability of data. Typical objectives of rock physics modelling studies based on well log data are: 1. Quality control of the measured elastic logs: density, p-sonic and s-sonic. Demanding a consistent and meaningful rock physics model can often indicate anomalous and poor quality measurements in the elastic logs that need correction or mitigation. 2. Quality control of petrophysical interpretation. It has been suggested that empirical relationships are more reasonable to use with well log data as it is hard to establish a consistent numerical rock physics model to explain the information from various wells even though they are drilled close by and in the same formations. However, the root of these problems may lie in inconsistencies in the petrophysical interpretations. Insisting on a consistent rock physics model can often highlight inconsistencies within the petrophysical interpretations. 3. Synthesis of elastic logs where missing or the quality is poor. Once a strong relationship has been established between the petrophysical interpretation (or other well log data) and the elastic properties, prediction...

Words: 2441 - Pages: 10

Free Essay

Financial Modelling

...Advanced Financial Modeling Macros © EduPristine – Agenda  Introduction to Macros & Advanced Application Building in Excel • Introduction and context  Key Concepts in Macros  Macros as recorded Robots!  Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel  Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro  Debugging VBA code • Errors in VBA • Step into VBA  Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box  Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 2 Agenda  Introduction to Macros & Advanced Application Building in Excel • Introduction and context  Key Concepts in Macros  Macros as recorded Robots!  Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel  Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro  Debugging VBA code • Errors in VBA • Step into VBA  Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box  Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 3 Building user applications in excel requires......

Words: 4063 - Pages: 17

Premium Essay

Spreadsheet Modelling

...Word Count: 587 This is my own unaided work . SPREADSHEET mODELLING Word Count: 587 . SPREADSHEET mODELLING Spreadsheet modelling As a future financial analyst my work will be based on analysing data from company’s gathered data spreadsheets. Hence it is crucial for my own career success to understand the importance of spreadsheet modelling and its implementation. As according to (Susan Coles, Jennifer Rowley, 1996) “The decision maker’s judgement must be exercised in the interpretation of the data and the final decision making.” There is no better way of benefiting my future career than developing advanced skills in modelling Excel. As I have learned from few articles I read about this subject, there are many advantages of excelling my skills so as problems I should look out for. Firstly, studying advanced Excel modelling not only helps students to build technological knowledge but “also largely improve their practical analytical skills and abilities.”(Junying, 2010). By studying how to model spreadsheets students get a real chance to see how actual data is analysed by spreadsheet build in models and help them to further their own analytical knowledge and see how it works in real life. I think it is hugely beneficial for students in their further real...

Words: 715 - Pages: 3

Free Essay

3d Modelling

...3D MODELLING Process of developing a mathematic rep of any 3D surface of object via a specialised software. Create a new layer 1. Click Format menu » Layer. 2. In the Layer Properties Manager, click the New Layer button. a. A layer name, such as LAYER1, is automatically added to the layer list. 3. Enter a new layer name by typing over the highlighted layer name. b. A layer name can include up to 255 characters: letters, digits, and the special characters dollar sign ($), hyphen (-), and underscore (_). Use a reverse quote (`) before other special characters so that the characters are not interpreted as wild-card characters. Layer names cannot include blank spaces. 4. To change the properties, click icons. c. When you click Color, Linetype, Lineweight, or Plot Style, a dialog box is displayed. 5. (Optional) Click in the Description column and enter text. 6. Click Apply to save your changes, or click OK to save and close. Find enquire distance 1. Start the LINE command and specify the first point. 2. Move the pointing device until the rubber-band line extends at the same angle as the line you want to draw. 3. Enter a distance on the command line. The line is drawn at the length and angle you specified. How to draw a line 1. Click Draw menu » Line. 2. Specify the start point. You can use the pointing device or enter coordinate values on the command line. 3. Complete the first line segment by specifying the......

Words: 2549 - Pages: 11

Free Essay

Cfd Modelling

...level for the proposed structures so that the maximum hydropower benefits are yielded through the scheme without compromising the safety. Present study intends to investigate the same for Marala Hydropower Project (MHP) proposed on Upper Chenab Canal (UCC) off-shooting from Marala Barrage on River Chenab. In order to define the optimum crest level of the spillway such that there is no negative impact on the discharge passing capacity of the UCC head regulator, two-pronged strategy has been applied i.e. using computational flow dynamics (CFD) computer software and analytical approach. The results of modelling are first compared with the physical model of the said scheme for validation. This study will be helpful for any future hydropower development schemes on irrigation canals close to barrages. Key Words: Low Head Hydropower Development, Canal Regulation, Numerical Modelling, FLOW-3D 1. INTRODUCTION Water is diverted into a canal from a pool behind a barrage through a structure called the canal head regulator. This structure is also used as a regulation device for controlling the amount of water passing into the canal with the help of adjustable gates [1]. Spillway is one of the foremost important structures of a dam project. It enables the project to dispose off the excess water or negotiate floods in either controlled or uncontrolled manner in order to ensure the safety of the project. Spillway should be designed with utmost care and importance must......

Words: 3280 - Pages: 14

Premium Essay

Erosion Modelling

...Erosion Modelling Soil erosion is a significant environmental process that degrades the soil in which we rely on for food, fuel, clean water, carbon storage, and as a substrate for buildings and infrastructure (Quinton 2011). It is the disruption of the soil mantle – the pedosphere, or the underlying rock base – the lithosphere by the action of matter of external geomorphic factors, such as water, snow, ice, air, weathered debris, organisms and man (Zachar 1982). Both abiotic and biotic forms of erosion forms patterns that are typical for a particular area such as climate, relief, nature of the surface, activity of the organism, and activity of man (Zachar 1982). It is the degradation or aggradations of the Earth’s surface by the movement of soil material by wind, rain, overland flow and gravity (ASSIGNMENT). Problems with Erosion The movement of sediment and associated pollutants over the landscape and into water bodies is of increasing concern with respect to pollution control and environmental protection. With the expected change in climate over the coming decades, there is a need to predict how environmental problems associated with sediment are likely to be affected so that appropriate management systems can be put in place (Morgan & Nearing). Erosion can impact the productivity of agricultural, post-mining and native systems and is a sign of land degradation (ASSIGNMENT). Soil erosion acts a mechanism for transferring pollutants to surface waters and reduces...

Words: 1174 - Pages: 5

Free Essay

Modelling Football Data

...Modelling Football Data By Renzo Galea A Dissertation Submitted in Partial Fulfilment of the Requirements For the Degree of Bachelor of Science (Honours) Statistics and Operations Research as main area DEPARTMENT OF STATISTICS AND OPERATIONS RESEARCH FACULTY OF SCIENCE UNIVERSITY OF MALTA MAY 2011 Declaration of Authorship I, Renzo Galea 25889G, declare that this dissertation entitled: “Modelling Football Data”, and the work presented in it is my own. I confirm that: (1) This work is carried out under the auspices of the Department of Statistics and Operations Research as part fulfillment of the requirements of the Bachelor of Science (Hons.) course. (2) Where any part of this dissertation has previously been submitted for a degree or any other qualification at this university or any other institution, this has been clearly stated. (3) Where I have used or consulted the published work of others, this is always clearly attributed. (4) Where I have quoted from the works of others, the source is always given. With the exception of such quotations, this dissertation is entirely my own work. (5) I have acknowledged all sources used for the purpose of this work. Signature: _______________________ Date: _______________________ Abstract Renzo Galea, B.Sc. (Hons.) Department of Statistics & Operations Research May 2011 University of Malta The main goal of this dissertation is to investigate the Bayesian modelling performance......

Words: 15822 - Pages: 64

Free Essay

Dynamic Modelling of Parallel Manipulator

...analysis of the 3-DOF Parallel UPU manipulator. The 3 DOF UPU is a parallel manipulator in which the U and P notations are for universal and prismatic pairs respectively, is a well-known manipulator that provides the platform with three degrees of freedom of pure translation, pure rotation or mixed translation and rotation with respect to the base, according to the relative directions of the revolute pair axes. The pure translational parallel 3-UPU manipulators have received a great lot of attention. Over the years many studies have been reported in the literature on the kinematic analysis, workspace optimization, singularities and joint clearance influence on the platform accuracy of this manipulator. However, the evaluation of the dynamic modelling of the parallel manipulators based on the two most famous methods i.e. Newton- Euler and Lagrange’s method have not been clearly discussed so far. Therefore, this project tries to throw light on this area and covers the Newton Euler Strategy for the calculation of the dynamic model of the 3 DOF UPU Parallel Manipulator. 1. Introduction Over the last few decades the parallel manipulators have attracted the attention of lot of researchers because of their complementary characteristic with serial manipulator. The word 'Parallel’ which is used here is to point out is not in the geometrical sense. Though these links act together, but it is not implied that they are aligned as parallel lines, here parallel means that the position......

Words: 2803 - Pages: 12

Free Essay

Modelling of Modern Microprocessors

...Modelling Of Modern Microprocessors Siddhant (Author) Department of Computer Science Lovely Professional University Phagwara, India Abstract--Microprocessors are also known as a CPU or central processing unit is a complete computation engine that is fabricated on a single chip. The first microprocessor was the Intel 4004, introduced in 1971. This paper covers the evolution in microprocessors and the changes in the architecture of the microprocessor, the details of the latest microprocessors and the machines using them. The paper also discusses how the number of transistors affects the performance of processor.   A microprocessor can move data from one memory location to another. A microprocessor can make decisions and jump to a new set of instructions based on those decisions. The native language of a microprocessor is Assembly Language. The above mentioned are the three basic activities of a microprocessor. An extremely simple microprocessor capable of performing the above mentioned operations loos like: Index terms—Modern, architecture, Intel, PC, Apple. I. INTRODUCTION The microprocessor is the heart of any normal computer, whether it is a desktop machine , a server or a laptop . The first microprocessor to make a real splash in the market was the Intel 8088, introduced in 1979 and incorporated into the IBM PC (which first appeared around 1982).The microprocessor is made up of transistors. CHIPA......

Words: 1808 - Pages: 8

Free Essay

Homology Modelling

...prediction namely homology modeling, threading and ab initio prediction (Xong, 2006). Homology modeling (comparative modeling) is a computational protein structure modeling technique used to build three dimensional (3D) models of proteins of unknown structure ( the target) on the basis of a sequence similarity to proteins of known structure (the template). Two conditions must be met to build a useful model, the similarity between the target sequence and template must be detectable and a substantially correct alignment between the target and the template should be calculated. Homology modelling is possible because small changes in protein sequence result in small changes in its 3D structures. The 3D structures of proteins in a family are more conserved than their sequences, therefore if similarity is detectable at sequence level structural similarity is usually assumed (Pala, et al., 2013). Homology modelling is a multistep step sequential process involving the following procedures: Template recognition and initial alignment; alignment correction; backbone generation; loop modeling; side-chain modeling; model optimization and model validation. Template recognition and alignment This involves the selection of all protein structures related to the target sequence and the selection of those to be used as templates. The template selection involves searching the Protein structure databases such as protein data bank (PDB); SCOP; CATH and DALI for homologous proteins with......

Words: 1208 - Pages: 5