Premium Essay

Spreadsheet Modelling

In: Computers and Technology

Submitted By ElenaKlim
Words 715
Pages 3
Word Count: 587
This is my own unaided work .
Word Count: 587 .

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 life working scenarios.
As I seen how important and beneficial this study is, the question is why don’t all the users have them skills? And the answer lays with the management. As (Michelle L.F. Cheong , Thin-Yin Leong, 2009) write in their article that business management do not realise the importance of the spreadsheet modelling and so do not put any emphasis on its improvement and…...

Similar Documents

Premium Essay


...Spreadsheet Analysis & Modeling MIS-505 Questions for Final Exam 1. What is name range? How can ranges be named? What are its uses? 2. What is lookup in Excel? What are the different kinds of lookup functions? What are its uses? 3. What is Index function? Write down the procedure of index function. What are its uses? 4. What is Match function? How you can write an Index and Match functions in a nested way? What are its uses? 5. Describe different kinds of text functions in Excel (such as left, right, mid). 6. How can you put date in Excel? What are its uses? 7. What is NETWORKINGDAYS function in Excel? What is NETWORKINGDAYS.INT function in Excel? What are its uses? 8. What is workday and WORKDAY.INT functions in Excel? What are its uses? 9. What is Net Present Value? How do NPV and XNPV function work in Excel? What are its uses? 10. What is internal rate of return (IRR)? How do IRR, XIRR, and MIRR work in Excel? What are its uses? 11. What is present value? How does PV function work? What are its uses? 12. What is Future Value? How does FV function work? What are its uses? 13. Write down the functions of PMT, PPMT, IPMT. How can you use these functions to prepare a loan amortization schedule? 14. Write down the function of IF Statement, AND, OR and XOR. 15. Describe different Time functions. What are its uses? 16. What is What If Analysis? Describe different kind of what if analysis. What are its uses...

Words: 474 - Pages: 2

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

...Advanced Modelling in Finance using Excel and VBA Mary Jackson and Mike Staunton JOHN WILEY & SONS, LTD Chichester ž New York ž Weinheim ž Brisbane ž Singapore ž Toronto 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......

Words: 57326 - Pages: 230

Premium Essay

Test Bank Modelling

...Managerial Decision Modeling w/ Spreadsheets, 3e (Balakrishnan/Render/Stair) Chapter 1 Introduction to Managerial Decision Making 1.1 Chapter Questions 1) Which of the following variables is considered random or probabilistic? A) future interest rates B) last year's advertising budget C) last week's sales data D) historical stock prices E) historical interest rates Answer: A Page Ref: 3 Topic: Types of Decision Models Difficulty: Moderate 2) Which of the following variables is considered non-random or deterministic? A) next year's cash flow projections B) future interest rates C) last year's income D) projected value of the euro next week E) projected NASDAQ index Answer: C Page Ref: 2 Topic: Types of Decision Models Difficulty: Moderate 3) Determining how much the solution will change if there are changes in the input data is part of: A) model formulation B) model solution C) model interpretation D) model development E) model assessment Answer: C Page Ref: 7 Topic: Steps Involved in Decision Modeling Difficulty: Easy 4) If all the variables in a model are under the control of the decision maker, then the model is considered to be: A) probabilistic B) random C) mathematical D) schematic E) deterministic Answer: E Page Ref: 2 Topic: Types of Decision Models Difficulty: Easy 5) Which of the following models is a picture or drawing of reality? A) physical model B) schematic......

Words: 2269 - Pages: 10

Premium Essay

Spreadsheet Modeling

... SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing......

Words: 49278 - Pages: 198

Free Essay

Business Computing Excel Spreadsheet

...Used: * Microsoft Excel 2007 (Home edition) * Microsoft Word 2008: (License No: 92464-513-2506215-12994) * Microsoft Expression Web (Student version) Attached Files: * Business Report.docx * Spreadsheet Assignment.xlsm * Website files * home.html * about.html * sit.html * work.html * registration.html * locate.html * contact.html * Formulae sheets Attempted the High Distinction Level Table of Contents 1.0 Executive Summary 3 2.0 Business Problem Opportunity 4 3.0 Recommendations (based on ‘What-if’ analysis) 5 3.1 Production targets 5 3.2 Fixed costs 5 3.3 Sales 6 4.0 Appendices 7 4.1 User instructions 7 1.0 Executive Summary Classic Offices is a company that manufactures and sells chairs. The recent recession of 2009 had a negative global effect on markets all over the world and Classic Offices was adversely affected too. Along with vital information such as income and commission figures, the increment of fixed costs and reduction of profits have been captured in the form of this user-friendly spreadsheet. This spreadsheet has been designed with the consideration of Classic Offices’ internal users in mind. To make interpretation of the spreadsheet easier: * Different years have been colour coded * Appropriate command buttons (e.g. ‘Home’, ‘Print’) are accompanied with icons Internal users of Classic Offices (mainly employees) will be able......

Words: 1137 - Pages: 5

Premium Essay


...Strengths and Weaknesses of Each Spreadsheet (Teacher) Aims to help the teacher: * Recording Results * Tracking the Learners’ Progress Strengths: One of the strengths of the teacher’s spreadsheet was the use of conditional formatting. Conditional formatting was helpful by easily presenting data, by formatting a range of cells depending on certain grades or scores means that analysing and categorising data will much easier with a visual representation and the teacher can make more accurate conclusions. The way the tables are laid out, and by defining a range is very useful for a teacher when it comes to neatly organising a spreadsheet with many tables of class’s results. By defining a range means that tables are easy to input into formulae, and will help reduce errors. AutoSum is very beneficial to a teacher because it simply adds up an entire column without having to add each cell individually. This saves a lot of time, and helps reduce errors, especially if there is lots of students’ data. Weaknesses: Macros are not included in the spreadsheet, which would’ve been very useful for a teacher. Macros stop repetitive tasks being completed over and over again. This is useful as it saves a lot of time to the teacher, e.g. if they click a customised button which filters data or changes sheets. This will also improve the usability of the spreadsheet and make the data input easier. Goal seek, which also isn’t included in the spreadsheet, would also be very......

Words: 1576 - Pages: 7

Premium Essay

Business Spreadsheets

...Business Spreadsheets. Name: Course: Instructor: Institution: Date of submission: 1) Calculate X-Bar-Bar, R-Bar, and associated control limits using the data in the table above.  From the data we have, the X-Bar-Bar number can be seen at the top set of results titled Centre x-bar bar = 5.1 a. The R-Bar result is the “Center” result the bottom set of data is R-Bar. Therefore R-Bar = 1.083 2) Create X-Bar•R (Average & Range) Control Charts from the data in the table above.  The X-Bar Control Chart is shown below Control limits for the x - chart are: Control limits = x- bar ± A2 (MR) Control limits = 5.1 ± 0.729 *1.083 Control limits = 4.31 to 5.89 Control limits ranges between 4.31 to 5.89 The R Control Chart is shown below Control limits for R- chart are: Upper control limits = (MR) * D4 Upper control limits = 2.282 *1.083 Upper control limits = 2.47 Lower control limit = D3 * MR Lower control limit = 0 * 1.083 Lower control limit = 0 3) Discuss notable out-of-control conditions displayed in the completed X-Bar•R (Average & Range) Control Charts. We consider points outside the control limits. We do not consider runs, set of points within certain regions. From the X-Bar control chart, we can see that two points 19 and 21 are above the upper control limit. From the R-Chart we can see that one point, 18 is above the upper control limit. 4. If...

Words: 890 - Pages: 4

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

Premium Essay

Spreadsheet Problem

...Cumberland Industries' financial planners must forecast the company's financial results for the coming year. The forecast for many items will be based on sales, and any additional funds needed will be obtained as notes payable. a. Assuming the historical trend continues, what will sales be in 2010? Base your forecast on a spreadsheet regression analysis of the 2004-2009 sales data above, and include the summary output of the regression in your answer. By what percentage are sales predicted to increase in 2010 over 2009? Is the sales growth rate increasing or decreasing? Here are the company's historical sales. Hint: Use the Trend function to forecast sales for 2010. Year Sales Growth Rate 2004 129,215,000 2005 180,901,000 40.0% 2006 235,252,000 30.0% 2007 294,065,000 25.0% 2008 396,692,000 34.9% 2009 455,150,000 14.7% 2010 515,465,267 % Increase in Predicted Sales for 2010 over 2009: 2009 Sales 455,150,000 2010 Sales 515,465,267 % increase 13.25% Note: This growth rate has been declining over time. b. Cumberland’s management believes that the firm will actually experience a 20 percent increase in sales during 2010. Construct 2010 pro forma financial statements. Cumberland will not issue any new stock or long-term bonds. Assume Cumberland will carry forward its current amounts of short-term investments and notes payable, prior to calculating AFN. Assume that any Additional Funds Needed (AFN) will be raised as notes payable (if AFN is...

Words: 616 - Pages: 3

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