Premium Essay

Spreadsheet Modelling

In: Computers and Technology

Submitted By ElenaKlim
Words 715
Pages 3
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 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

Lec2 Material

...CHAPTER 1 What Is Financial Modelling? here are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly. A few years ago, we put together a Plum Solutions survey about the attitudes, trends, and uses of financial modelling, asked respondents “What do you think a financial model is?” Participants were asked to put down the first thing that came to mind, without any research or too much thinking about it. I found the responses interesting, amusing, and sometimes rather disturbing. Some answers were overly complicated and highly technical: n T n n n n “Representation of behaviour/real-world observations through mathematical approach designed to anticipate range of outcomes.” “A set of structured calculations, written in a spreadsheet, used to analyse the operational and financial characteristics of a business and/or its activities.” “Tool(s) used to set and manage a suite of variable assumptions in order to predict the financial outcomes of an opportunity.” “A construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A......

Words: 17366 - Pages: 70

Free Essay

Social Parameters

...Objective: Operations Research is the science of decision making and the art of decision modelling. It is a set of quantitative tools used by the managers to take decisions and formulate their business strategies. The basic objective of this course is to provide an understanding of the important techniques used in decision making. A certain level of mathematical hands-on expertise will be required to ensure understanding of the tools in operations research. At the end of the course you are expected to • Formulate real world decision making situations as mathematical optimisation problems • Solve linear programming problems • Be able to understand what the solution means • Understand basic concepts of transportation, assignment and integer programming problems. Reference [1] F.S.Hillier and M.S.Hillier, Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, Tata McGraw-Hill, New Delhi,. [2] H.A.Taha, Operations Research An Introduction, Prentice Hall of India Private Limited, New Delhi. [3] Hiller and Lieberman, Introduction to Operations Research, Tata McGraw Hill, New York,. [4] N. Balakrishnan, B. Render and R.M.Stair, Managerial Decision Modeling With Spreadsheets, Pearson Education. Objective: Operations Research is the science of decision making and the art of decision modelling. It is a set of quantitative tools used by the managers to take decisions and formulate their business strategies. The......

Words: 373 - Pages: 2

Premium Essay

Assignment Brief#

...Level 3 Extended Diploma in Business | Unit 42: Spreadsheet Modelling | Learner name | Assessor name | Martyna Litvinaite | Irene McCourt Francesse Mooney | Date issued | Hand in deadline | Submitted on | 15/09/14 | Task 1 15/10/14 Task 2 12/12/14 Task 3 20/03/15 Task 4 29/05/15 | 15/10/1410/12/14 | | | Assignment title | GamerWorld | In this assessment you will have opportunities to provide evidence against the following criteria. Indicate the page numbers where the evidence can be found. | Criteria reference | To achieve the criteria the evidence must show that the learner is able to: | | Task no. | | Evidence | P1 | * explain how spreadsheets can be used to solve complex problems | | 1 | | Pages1-2 | P2P3M1 | * develop a complex spreadsheet model to meet particular needs * use formulae, features and functions to process information * refine a complex spreadsheet model by changing rules and values | | 2 | | 2 Spreadsheets | P4P5P6P8M2M3 | * use appropriate tools to present data * customise the spreadsheet model to meet a given requirement * use automated features in the spreadsheet model to meet a given requirement * export the contents of the spreadsheet model to an alternative format * analyse and interpret data from a spreadsheet model * compare different automation methods | | 2 | | | P1P7P9M4D1D2 | * test a spreadsheet model to ensure that it is fit for......

Words: 302 - Pages: 2

Premium Essay

Estimating Needs

...Objective: Further experience and knowledge in project management and estimating. Qualifications: Received diploma in the Mechanical Engineering program at NAIT. Obtained various technical and project management skills. Proficient in various computer programs including Microsoft Office, design programs such as Mastercam, AutoCAD and 3-D Inventor modelling. Education: Mechanical Engineering Technologist, NAIT April 30, 2010 Completion Date • Learnt principles of the design process and effective ways of creating professional reports, documents and drawings. • Experience building reports, programs, charts and spreadsheets with Microsoft Office. • Principles of Six Sigma, ISO 9001, Statistical Process Control, Production Planing Processes and Continuous Quality Improvements. • Operations Management, experience in Forecasting, Scheduling, Capacity Planning, Inventory Control and Supervision. • Experience in bidding procedure and accurate financial documentation related to products manufacturing. • Proficient in programs such as o Microsoft Word, Excel, Visio, Power Point and Publisher. o Master Cam o AutoCAD and 3-D Modelling Inventor. Geomatics Engineering Technologist, NAIT April 30, 2006 Completion Date • Introduced to AutoCAD, learnt design process and report documentation related to the Alberta Land Surveying criteria. • Completed courses related to basic survey calculations within the field. • Completed H2S training, first aid and construction......

Words: 408 - Pages: 2

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): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com 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

Free Essay

2013 Aff 2851

...MonashUniversity Semester Two Examination 2013 Faculty of Business and Economics Department of Accounting and Finance EXAM CODES: AFF2851 TITLE OF PAPER: ACCOUNTING INFORMATION SYSTEMS & FINANCIAL MODELLING EXAM DURATION: 3 hours READING TIME: 10 minutes THIS PAPER IS FOR STUDENTS STUDYING AT: (office use only - tick where applicable)  Berwick  Clayton  Peninsula  Distance Education  Other (specify)  Caulfield Gippsland  Sunway  Open Learning During an exam, you must not have in your possession a book, notes, paper, calculator, pencil case, mobile phone or other material/item which has not been authorised for the exam or specifically permitted as noted below. Any material or item on your desk, chair or person will be deemed to be in your possession. You are reminded that possession of unauthorised materials in an exam is a disciplinable offence under Monash Statute 4.1. AUTHORISED MATERIALS CALCULATORS  YES  NO (If YES, only calculators with an 'approved for use' Faculty label are permitted) OPEN BOOK  YES  NO SPECIFICALLY PERMITTED ITEMS  YES  NO if yes, items permitted are: This paper consists of two (2) parts printed on a total offourteen (14) pages, plus a multiple choice answer sheet. Part A has twenty (20) multiple choice questions. The answers to Part A should be entered on the multiple choice answer sheet provided. Part B has four (4)sets of written answer questions. Students must attempt to answer ALL...

Words: 1037 - Pages: 5

Premium Essay

Atit

...Module number: U51001 Module title: Key Business Competences Contents Module introduction 1 Semester plan synopsis 2 Module syllabus 3 Week 1 – Module Introduction 7 Week 2: Operations with numbers 8 Week 3: Understanding Data 16 Week 4 – Charts and Graphing in Excel 31 Week 5 – Summarising data 45 Week 6 Reading Week 57 Week 7 & 8 – Principles of elementary modelling 58 Week 9 & 10 – Financial Modelling (1) 69 Week 11 & 12 – Financial Modelling (2) 81 Week 13 – Modelling and Data handling in business 97 Week 14 – Revision Week 107 Week 15 – In-class Test 108 Assessment details 109 Regulations 110 A note on equal opportunities and diversity 114 Module introduction Introduction This module ensures that all students have the necessary numerical skills to proceed with the rest of their degree in Business and related fields. As a compulsory module it must be passed and a maximum of three attempts can be made to pass it, with a resit opportunity for each attempt. Past student comments on the module “Yes it is really enjoyable – I liked the course” “The lecturers are very helpful and friendly” “The handbook is really informative” “Very clear and well explained” “It is very interesting but at the same time very complex” “Maybe make the lectures and seminars more interactive” “Quickly go over the initial mathematics and spend more time on the more complex parts of the module” ...

Words: 27701 - Pages: 111

Premium Essay

Budget Analysis

...Mid-term Test Class 9: Markov chain Introduction to stochastic processes, markov chains, transition probability matrix, steadystate probabilities. Text: Handouts and WW 17.1, 17.2, 17.3 Class 10: Decision theory Decision making under uncertainty, Decision criteria, Decision Tree Text: BRs 8.1, 8.2, 8.3, 8.4, 8.6 Class 11: Decision theory (contd.) Decision making under risk, EVPI, EVSI Text: 8.5, 8.8, 8.9 Class 12: Travelling Salesman Problem Optimization model formulation, solution approaches, Branch and bound algorithm Text: handouts and WW 9.6 Class 13: Case Study / Revision Class 14: Case study / Revision Software packages: MS Excel Text book 1. (BRS) Balakrishnan N, Render B, Stair Jr. RM (2007) Managerial decision modelling with spreadsheets (2nd Ed.), Pearson education. 2. (WW) Winston, W.L.: Operations Research - Applications and Algorithms (4th ed.), Thomson (India) Internal assessment scheme: (25 Marks) 1. Quiz and test: 10 2. Assignment / Term paper / Homework: 10 3. Class participation: 05 Topics covered in other section: Management Science- Basic concepts and it’s role in decision making, Queueing theory, Basic Inventory models, PERT/CPM ...

Words: 354 - Pages: 2

Premium Essay

Toyota Case Study

................................................................... 15   2.4   Question 3 ................................................................................................... 16   2.5   Question 4 ................................................................................................... 18   2.6   Question 5 ................................................................................................... 18   2.7   Question 6 ................................................................................................... 19   2.8   Conclusion .................................................................................................. 20   3   Business Planning & Modelling ............................................................................... 21   3.1   Introduction ................................................................................................. 21   3.2   Question 1 ................................................................................................... 22   3.3   Question 2 ................................................................................................... 23   3.4   Question 3 ................................................................................................... 24   3.5   Conclusion .................................................................................................. 29   References ....

Words: 12355 - Pages: 50

Premium Essay

Cash Management Modeling

...Lakewood Laser Skincare and all business cash budgets really do matter. The business owner who does not pay attention might have a rude surprise when they run out of cash or applies to the bank for renewal of loans. One of the many advantages of utilizing Excel financials or an accounting software program is that updating is calculated automatically by simply completing a new data input. This helps business owners quickly get a handle on the financial strength and capabilities of their business. Creating and Calculating Cash Balances Sheets The first step in creating a multiproduct, multi-period, spreadsheet-based budget is setting up a clear and understandable Data Input Sheet. This sheet will summarize the assumptions and estimates for the entire budget for business like Lakewood Laser Skincare. By putting them in one place, you make it easy for those less familiar with spreadsheets to get into the budget and change their assumptions. It also makes it easy to adjust the budget based on management discussions, to create best- and worst-case scenarios, and to perform variance analyses using the “What If” analyses forecasting the end of the period. The specific details of how you create the Data Input Sheet are up to you and to those who’ll be inputting the data, but there are a few things that will make things easier later in the budgeting process. When showing data for different periods of time, such as the quarterly sales forecasts, it’s horizontal rather than vertical.......

Words: 795 - Pages: 4

Premium Essay

Risk

...area Data warehouse OLAP servers Data marts • • • • What is OLAP? Dimensional modelling vs. 3 NF modelling Data Marts ROLAP/MOLAP servers What is OLAP? • Acronym for “On-line analytical processing” • A decision support system (DSS) that support ad-hoc querying, i.e. enables managers and analysts to interactively manipulate data. The idea is to allow the users to easy and quickly manipulate and visualise the data through multidimensional views, i.e. different perspectives. e fic of quarter Service Quarter Facts Office product Kimball: Dimensional modelling Dimensional modelling Service Dimension Service Key Service group S1 Local call Group A S2 Intern. call Group A S3 SMS Group B S4 WAP Group C Time Dimension Date/ Key 991011 991012 Month 9910 9910 Quarter 4 - 99 4 - 99 Year 99 99 1 Fact table - Transactions C210 C210 C212 C213 C214 S1 S3 S2 S1 S4 F11 F11 F13 F13 F13 991011 991011 991011 991011 991012 Sum 25:00 05:00 89:00 12:00 08:00 Number of calls 3 1 1 1 1 1 0..* 0..* 0..* 0..* Sales Dimension Key F11 F12 F13 Seller Anders C Lisa B Janis B Office Sundsvall Sundsvall Kista Customer Dimension 1 Key C210 C211 C212 C213 C214 Customer Anna N Lars S Erik P Danny B Åsa S Address Stockholm Malmö Rättvik Stockholm Stockholm Region Stockholm Skåne Dalarna Stockholm Stockholm Income group B B C A A 1 Dimensional modelling Service Dimension Service Key Service group S1 Local call Group A S2 Intern. call......

Words: 2902 - Pages: 12

Premium Essay

Evaluate the the Contribution of Life

...usage of an MIS is that it can help managers make vital decisions about the business and monitor the progress and flow of the business. They can help high up members of staff understand the ins and outs of the business without in depth knowledge of the numerical information involved. An MIS is vital in most modern companies, but the information provided to the system has to be accurate and up to data in order for it to become truly effective and efficient. The data in the system can be used to compare different sets of data from other companies and previous years, detecting trends and spotting niche areas. Data that has been previously entered can be analysed and used to anticipate future events, this is called forecasting or predictive modelling. However the uses of an MIS can be limited, typically they are less reliable when dealing with non numerical data and the quality, reliability and validity of the information produced by the system entirely dependent on the quality, reliability and validity of the information entered into the system in the first place. Information systems are designed to improve the overall day to day running of a business, there are several key elements which can effect these information systems, they are; * Data * People * Hardware * Software * Communications Data An information system runs on the data that is inputted into it, thus all data entered must be accurate, valid, reliable and timely in order to contribute to an......

Words: 6601 - Pages: 27

Premium Essay

Courses on Probability Theory

...module aims to describe and analyse the general finance topics and introduces students to implement basic computational approaches to financial problems using Microsoft Excel. It stresses the fundamentals of finance; provides students with a knowledge and understanding on the key finance subjects such as money market, return metric, portfolio modelling, asset pricing, etc.; and equips students with the essential techniques applied in financial calculations. Contents: 1. Lecture Topic 1: Money Market Instrument : Introduction to the course; Interest rate types; Forward-forward rate; Forward rate agreement; Hedging strategies using FRAs; Swaps; Zero-coupon rate and Yield curve. 2. Lecture Topic 2: Econometrics for Finance 1: Regression Analysis 3. Lecture Topic 3: Econometrics for Finance 2: Time Series Analysis and Forecasting. 4. Lecture Topic 4: Return and Performance Evaluation: Single period returns: discrete, continuous, real, nominal, domestic, foreign; Multiperiod buy and hold returns of an asset; Multiperiod buy-and-hold returns of a portfolio; Portfolio Performance Measurement. 5. Lecture Topic 5: Portfolio Modelling: Expected return (mean return) and variance of a portfolio. Mean-variance efficient frontier. Capital market line (CML), Capital asset pricing model (CAPM), Arbitrage pricing theory (APT), Fama–French three-factor model. Main textbook: B. Steiner (2008), Mastering Financial Calculation, Second Edition, FT Press. Final Marks:......

Words: 1425 - Pages: 6

Premium Essay

Resume

... |2011 | | | | | | |PROJECT MANAGEMENT SOFTWARE | |MICROSOFT PROJECT |8 |5 |2010 | |TEAM MANAGER |1 |5 |2002 | | | | | | |DATA MODELLING TOOL | |ERWIN |10 |5 |2010 | |VISIO |8 |5 |2011 | |OTHERS | | | | |MS OFFICE |12 |5 |2011 | Employment History 1.  2nd February 2006 – up to now Netsoft Ltd –...

Words: 2182 - Pages: 9

Free Essay

Energy Drink

...rates in binomial grids and callable bonds Buffer lecture 15: Misc, Tips and tricks for the exam. 11 / 17 5 Curriculum Primary literature • Benninga Financial modeling, uses Excel, 3. ed. MIT • Exercises Secondary (optional) literature • Jackson and Staunton, Advanced modelling in finance using Excel and VBA, Wiley • Supplementary chapters, see General information document 12 / 17 What you should know already Ask me what to do, if you are not familiar with; • Portfolio theory, Option pricing, Bond analysis • Very basic spreadsheet knowledge (else buy one of the “Learn Excel in 10 min”-books) • Basic matrix algebra, optimization and statistics (incl linear regression). 13 / 17 6 Popular question: How much VBA? VBA (Visual basic application) There is a bit of VBA many places in the course, • Some VBA is OPTIONAL • Most VBA is “on top” of Excel implementation • Reason: Your backgrounds and abilities are very different How much VBA at the exam? Max 10% will require VBA, probably less. • Grade 10 possible with very basic VBA knowledge 14 / 17 What you will NOT learn We use Excel as an extended pocket calculator, NOT: • For making fancy spreadsheets • For developing applications for other people Comment to VBA-aficionados: From now on, it affects the grade negatively if “interface programming” features make it harder for Censor and I to get an overview of the exam-answer/”term paper”. (It usually does!) 15 /......

Words: 851 - Pages: 4