Premium Essay


In: Miscellaneous

Submitted By fina2221
Words 3432
Pages 14
Spreadsheet Sensitivity Analysis

Spreadsheets and the Case Projects

The Dynamic Strategic Planning workbook is accompanied by a number of spreadsheet-based tools for data analysis. We have supplied these tools so that the users of this workbook can concentrate upon the use and implementation of decision analysis and strategic planning, rather than focusing upon the mechanics of the mathematics underlying their use. The current form of the spreadsheets is a consequence of a combination of factors: academic research, pedagogical design, and in-class experiences. Based upon new developments, they are being routinely improved. However, no amount of care in tool design can substitute for expertise on the part of the user. The case projects have been designed assuming that these tools will be used effectively. The purpose of this document is to assure that you, the user of these tools, are prepared to exploit them to their fullest - specifically, that you are able to make use of spreadsheet sensitivity analysis tools.
Spreadsheet Basics

Electronic spreadsheets (as opposed to the paper kind!) have revolutionized business analysis. This should be no surprise, given that one of the developers of the original tool, Visicalc, was a Harvard Business School dropout who recognized that a computer-based tool to facilitate business analysis would have made his life a little simpler at the HBS, and might even help managers when they got out into the real world. However, it took the happy historical coincidence of the personal computer, and the concomitant dispersion of computer power to every modern manager's desk, to assure the success of the concept. Conceptually, the spreadsheet is simply a representation of the original accountant's paper spreadsheet, composed of finely lined pages of labeled columns of numbers. The original concept was to provide the user...

Similar Documents

Premium Essay


...struggling in a particular area I would walk them through using their own movements step by step. While in health I taught a tradtitional stand up and talk lecture. I also made my own powerpoints, showed videos, and provided music, and example work to students. 2. How did you ensure equitable access for all of your students? The project that I assigned required students to have pictures from either magazines or the internet to paste onto a paper plate. I understand that not all students have internet access and not all students have $5 to afford a magazine so out of my own pocket I provides several magazines for the students to use. 3. How has your program of study helped you meet the needs of ALL the students you teach? Sensitivty to diversity is one of the core dispositions of the teachers college at Henderson State. In all of our teaching related classes a focus was provided, usually more than once, on sensitivity to diversity. This helped me prepare for all criteria that I might need to meet in regards to meeting the needs of all of my students. Whether it is sensitivity to race, gender, athletic ability, etc. I have been presented with these situations or scenarios in one class or another and been helped a long with providing the instruction to meet their needs 4. How do you integrate diversity and multiculturalism throughout your class curriculum. This is more difficult to do in a PE class than in other classes. I would find a......

Words: 551 - Pages: 3

Premium Essay

Linear Question Solutions

...Question 1: Describe Linear Technologies payout policy. What have they done historically? How does this compare to the dividend policy of other firms in the industry? Payout Policy: * 2 Methods: Dividend Payout and Stock Repurchase * First announced in 1992, due to positive expectations, had a top position in the industry and positive cash flows since the IPO * Signal a strong position ina risky market and the transition to a more mature state of the company * The payout ratio has been growing steadily, getting close to 25% in 2003 Why they payout? * Low interest rates offered by Linear’s High-grade securities * Investors can earn more with the dividends on their own * The company has no acquisition plans * Repurchases offset the exercise of employee stock options Question 2: What are Linear’s financing needs? How large is the dividend relative to its cash level and to the annual cash flow and investment spending of the firm? * Income statement and revenue growth stable during 1992-2002 * Boom during peak in 200-2001 (dot-com bubble) * Even in economic downfall, managed to obtain a positive net income and net cash flow * Also maintained margin with focus on variable cost * Analog semiconductors have stable and modest R&D costs, don’t need much financing * Little desire for excessive investments, cash is handled conservatively with investments in short-term debt securities Therefore: ......

Words: 756 - Pages: 4

Free Essay

The Prediction of Stress by Values and Value Conflict

...The Journal of Psychology, 2005, 139(4), 369–382 The Prediction of Stress by Values and Value Conflict DAVE BOUCKENOOGHE MARC BUELENS Department Of People and Organization Vlerick Leuven Gent Management School, Belgium JOHNNY FONTAINE Department of Personnel Management, Work, and Organizational Psychology Gent University, Belgium KARLIEN VANDERHEYDEN Department of People and Organization Vlerick Leuven Gent Management School, Belgium ABSTRACT. The authors investigated the relationships among stress, values, and value conflict. Data collected from 400 people working in a variety of companies in Flanders indicated that the values of openness to change, conservation, self-transcendence, and self-enhancement were important predictors of stress. Participants open to change reported less stress, whereas participants who had high scores on conservation, self-enhancement, and self-transcendence perceived more stress. People who reported high value conflict also experienced more stress. Separate analyses for men and women showed that there were gender differences in the relationships observed between the 4 value types and stress. These data have noteworthy theoretical and practical implications. Key words: stress, values and value conflict CONSIDERABLE SKEPTICISM AND CONFUSION exist in research on values because of the plethora of questionnaires and definitions that have been used in the past (Hofstede, 1984; Kluckhohn, 1951; Rokeach, 1973; Schwartz & Bilsky, 1987; Super,......

Words: 5613 - Pages: 23