Performing Sensitivity Analysis Using Toprank Product

1968 words - 8 pages

The increase in recent years in the sophistication, power, and user-friendliness of spreadsheets such as Microsoft Excel has meant that more decision makers are building their own spreadsheet models to help them in their decision making. These models however are only as good as two things. Firstly, the data that goes into the model, and secondly, the logic of the relationships built into the model. Inaccurate input data values or faulty logic can only produce bad results, especially if the inaccurate data values are the key or critical variables (Beaman, Ratnatunga, Krueger, and Mudalige, 2002). Obviously, more care should be taken when estimating an input variable to which the output is ...view middle of the document...

The decision maker may then decide whether it is appropriate to concentrate on those variables. As well as allowing the decision maker to determine the key variables in a decision, sensitivity analysis can be used to determine the margin of error in decisions involving those variables (Beaman et al., 2002). In addition, it could also possibly help to highlight faulty logic in that any results of a sensitivity analysis must "make sense". In other words, the model builder should look closely at the logic of any model if a sensitivity analysis highlights a particular input variable as key given that all other indications such as previous company knowledge, "gut feel", etc are that it is not (Beaman et al., 2002).Sensitivity analysis can be performed using either a spreadsheet package, a financial modeling language, a "decision support", or an "add-in" to spreadsheet package. The least efficient, but probably most common approach, is to use a spreadsheet package to repeat the scenario (what-if) analysis process over and over again. For each repetition of this process, the value of one input variable is changed and the results recorded. This process is repeated for a range of values for that input variable, and then the whole process is repeated for any other input variable that the decision maker wishes to vary. By comparing the relative differences in the results as each of these input variables are varied, the decision maker is able to identify those input variables that cause the largest change in the output result; that is, the high sensitivity or critical variables in that decision situation (Beaman et al., 2002).There is also one other way to do sensitivity analysis within standard Microsoft Excel, which is the semi-automatic process of varying the values assigned to input variables. The command to do this is Data Table. Microsoft Excel's Data Table command allows the decision maker to vary one (or two) input variable/s to identify the effect that this change has on one (or more) formulas (ie. output results) of interest. The "table" output from this command shows the decision maker the sensitivity of the results to one (or two) input variable/s (Beaman et al., 2002). The dialogue box for Excel's Data Table command is shown in Figure 1.Figure 1. Microsoft Excel's Data Table Dialogue BoxAnd, as a result from the use of this Data Table command, Microsoft Excel will (semi) automatically produce a what-if table. From this table, the decision maker could analyze which variable, between the two variables, that is more sensitive to the result. The sample result of the Data Table command is shown in Figure 2.Figure 2. Sample Result of the Data Table CommandBut, unfortunately, performing sensitivity analysis using this standard Microsoft Excel's command is very inefficient. The first reason is because it is a table, it is not as easy to read as the graphical outputs produced by another methods. And, the second reason is because that the Data Table...

Other Essays Like Performing Sensitivity Analysis Using Toprank Product

Dec Analysis Paper

4497 words - 18 pages , Finance, HR and Cost Management. This composition was certified by the board and, as other functions started voicing concerns over the weighting of the different attributes, we tried addressing those concerns by performing a so-called sensitivity analysis. This tool can be used to answer such questions such as: “What would the result have looked like, had - 16 we assigned more weight to a certain variable?”. Perhaps not surprisingly so, the

The Arguments About Foreign Project Valuation

2470 words - 10 pages SENSITIVITY ANALYSISSensitivity analysis is the process of varying the assumptions underlying a decision to determine the decision's sensitivity to those assumptions. It enables managers to assess how responsive NPV is to changes in key variables that are used to calculate it (Drury 1996). Some of the factors that influence the NPV of multinationals are taxes, exchange rates, estimating the terminal value of a project using different

Fin415 Week 3 Problem Set

676 words - 3 pages usually offer higher reward but high opportunities for losses. Using probability distributions, the techniques aide financial professional across many industries mitigate risk to grow and sustain profitability. Determining probable variations between independent and dependent variables represents sensitivity analysis. This technique relies on specific boundaries based on multiple input variables to determine the interest rates changes and their

Mba 540 Week 3 Risk Analysis

1349 words - 6 pages “NPV is the inability to account for flexibility or uncertainty after the project decision” (12manage, 2009). Besides a higher initial capital outlay for the internal Dig-image project over the external W-Comm project, the project life is shorter for the internal proposal. The risk involved in buying untested technology goes beyond the basic risk approach and uses the sensitivity analysis approach to analyze the impact of risk on capital budgets

Marketing Plan for Bosh Washing Machine

5515 words - 23 pages the Uk market and increase customer awareness of Bosch energy saving product. Its segmentation of the market looks at the psychographic (lifestyle) ,social demographic and behaviourist of customer. It equally looks at B2B and B2C market. The target market and its position where also discussed in the analysis. Based on the size of the market and its target customers, it is expected to increase revenue to 4.6 percent over last year report


1738 words - 7 pages for classroom use. Managing Economic Exposure Restructuring to reduce economic exposure, e.g.: a.Increase sensitivity of revenues to exchange rate movements. b.Decrease sensitivity of expenses to exchange rate movements. (Exhibit 12.3 & 12.4) Expediting the Analysis with Computer Spreadsheets Determining the sensitivity of cash flows (ignoring tax effects) to alternative exchange rate scenarios can be expedited by using a computer to

Business Economics

951 words - 4 pages , controllers are asked to prepare budget for the complete year through using realistic approach. Deviation in the budget occurs due to sensitivity of variables. Probability is very useful and important technique used in the forecasting process. Controllers use statistics and probability technique to reduce uncertainty and variance in the data. Although probability is very useful in the forecasting but when controllers inaccurately assign

Accounting 101

843 words - 4 pages • Benefits o Stock market prices react with a high degree of efficiency to published information about a firm o An implication of highly efficient capital market is that analysts and investors have more difficulty finding undervalued or overvalued securities. Association between earnings and share price • Performing financial analysis that relies on analysis, forecasting and valuation of key accounting measures can be very rewarding

Variance Analysis

665 words - 3 pages the report consider the hospital size and utilization of the services offered by the hospital. When performing a variance analysis, relationships can be identified. Favorable (positive) and unfavorable (negative) correlations are critical in business planning. An example would be, variance analysis may show that when sales for product a rise in sales for product B. This type of relationship may be used for success of other products (Cross, N.d

Management Accounting Fundamentals

2681 words - 11 pages achieve a desired target net profit figure. Compute the break-even point for a multiple product company, and explain the effects of shifts in the sales mix on contribution margin and the break-even point. Explain cost-volume-profit with uncertainty. Design a worksheet to perform a sensitivity analysis on CVP. Level 1 4.7 Break-even analysis  Level 1 4.8 CVP considerations in choosing a cost structure  Level 1 4.9


572 words - 3 pages Three methods that can be used to express CVP relationships: - Equation - Contribution margin - Graph methods ABC systems apply equally well to manufacturing, merchandising and service companies. ABC information is useful for the: -Pricing and product mix - Cost reduction and process improvement - Product design - Decisions for planning and managing activities Describe sensitivity analysis. How has the advent of the

Related Papers

Tasty Foods Corp. (B) Essay

4339 words - 18 pages and the market. However the products stand alone risk is not closely correlated with the other two forms of risk. This is because Tasty Foods has identified that there is a market for their product and consumers, willing that the economy allows for it, will spend money on their product. 2. a. Sensitivity analysis shows how much the net present value of a project will change in response to a given change in an input, such as unit sales. This

Consumer Is Boss Essay

3638 words - 15 pages Sensitivity test – This test will indicate Price Sensitivity of Volume for Tide powder at different price points. i.e. if we changed the price of Tide, what would be the effect on Tide sales volume? 5000 7 Source of Volume Analysis for Surf powder – Detailed understanding from a panel of 2000 Households. Their purchases are continuously monitored over time. Analysis of their purchasing behavior will reveal from which brands Surf is sourcing its

Industrial Profitability Essay

456 words - 2 pages necessarily those that have the same form as the existing products but those that perform the same function. Threat of substitution can come not from customers switching to another product but from utilizing technologies that allow them to do without, or use less of the existing products.Two factors determine the power of buyers: price sensitivity and relative bargaining power. Price sensitivity determines the extent to which buyers care to bargain on

Cultural Sensitivity Essay

1386 words - 6 pages and indulging in activities like that to be inappropriate and unethical for the society. Hence, marketing of alcohol in US would be more beneficial for the business as compared to the western parts of India. This shows that cultural differences do play a major role in the sales and consumption of any product in the international market. Another instance that highlights the role of cultural sensitivity in the marketing sector