BUSI 402 Ch 8

BUSI 402 Ch 8 - Chapter 8: Using Data Tables and Excel...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 8: Using Data Tables and Excel Scenarios for What-If Analysis I. Level 1: Using Data Tables to Perform Break-Even and Sensitivity Analysis a. Break-even analysis – a type of what-if analysis that concentrates on an activity at or around the point at which a product breaks even. The point at which the expenses of creating and selling the product are equal to the revenue it produces, or where the profit is $0. b. Sensitivity analysis – another type of what-if analysis that attempts to examine how sensitive the results of an analysis are to changes in the assumptions b.i. How tolerant the projected results are of changes in those estimates and assumptions c. Data table – a range of cells containing values and formulas. When you change the values, the data table shows you how those changes affect the results of the formulas c.i. Allow you to organize and present the results of multiple what-if analyses d. Input cells – cells containing values that can vary e. Result cells – contain formulas that involve the input cells in their calculations
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

BUSI 402 Ch 8 - Chapter 8: Using Data Tables and Excel...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online