Sensitivity analysis in financial modeling is best described as which of the following?
Opening subject page...
Loading your content
CPA Bar Quiz
Practice Evaluate Sensitivity And Scenario Analysis in CPA Bar with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.
Question 1 / 20
0 of 20 answered
Sensitivity analysis in financial modeling is best described as which of the following?
This quiz focuses on Evaluate Sensitivity And Scenario Analysis, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA Bar.
Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.
Sensitivity analysis in financial modeling is best described as which of the following?
Explanation: Sensitivity analysis examines how changes in individual input assumptions affect a model's output. By varying one assumption at a time while holding others constant, analysts identify which inputs are most influential and where errors would have the greatest consequences. Option B describes Monte Carlo simulation. Option C describes scenario analysis. Option D describes budget variance analysis.
A project's base-case NPV is 120,000.Sensitivityanalysisshowsthateach118,000. What is the NPV if the discount rate increases by 2 percentage points?
Explanation: NPV impact = 2 x 18,000=36,000 reduction. NPV at higher rate = 120,000−36,000 = $84,000. This assumes a linear relationship between the discount rate and NPV, which sensitivity analysis typically uses for small changes around the base case. Option A applies only a 1% change. Option C applies a 3% change. Option D adds rather than subtracts the rate impact.
A company's base-case operating income is 500,000(revenue3,000,000, variable cost ratio 60%, fixed costs $700,000). If revenue declines 10% while all other assumptions remain constant, what is operating income?
Explanation: New revenue = 3,000,000x0.90=2,700,000. Variable costs = 2,700,000x601,620,000. Operating income = 2,700,000−1,620,000 - 700,000=380,000. The 120,000declineinoperatingincome(500,000 - 380,000)reflectsthecontributionmarginlostonthe300,000 revenue decline: 300,000x40120,000. Option A applies a much larger impact. Option B deducts only the revenue decline without applying the variable cost offset. Option D uses an incorrect variable cost calculation.
Using the same base case (revenue 3,000,000,fixedcosts700,000), if the variable cost ratio increases from 60% to 65% while all other assumptions remain constant, what is operating income?
Explanation: Variable costs at 65% = 3,000,000x0.65=1,950,000. Operating income = 3,000,000−1,950,000 - 700,000=350,000. The 5-percentage-point increase in the variable cost ratio costs 3,000,000x5150,000, reducing operating income from 500,000to350,000. Option A is the unchanged base case. Option B is incorrect - higher variable costs reduce, not increase, operating income. Option C uses a 4.5% change rather than 5%.
A DCF model produces an NPV of 2,400,000ata10200,000 for each 1-percentage-point change in the discount rate. What is the NPV at a 12% discount rate?
Explanation: NPV at 12% = 2,400,000−(2x200,000) = 2,400,000−400,000 = 2,000,000.Eachpercentage−pointincreaseinthediscountratereducesNPVby200,000; a 2-point increase reduces it by 400,000.OptionBaddsinsteadofsubtracts.OptionCappliesa400,000 reduction per percentage point rather than the stated $200,000. Option D applies only a 1-point reduction.
A project requires an initial investment of 1,200,000andgeneratesannualcashflowsfor5years.ThePVannuityfactorat10280,000. What is the NPV under the pessimistic scenario?
Explanation: PV of pessimistic cash flows = 280,000x3.791=1,061,480. NPV = 1,061,480−1,200,000 = -138,520.Underthepessimisticscenario,theprojectdoesnotrecoveritsinitialinvestmentattherequiredrateofreturn.OptionAisthebase−caseNPV(approximately400,000 x 3.791 - $1,200,000). Option B applies the correct magnitude but wrong sign. Option C has the correct magnitude but wrong sign.
Using the same project data (initial investment 1,200,000,PVannuityfactor3.791at10520,000?
Explanation: PV of optimistic cash flows = 520,000x3.791=1,971,320. NPV = 1,971,320−1,200,000 = 771,320.OptionBisthebase−caseNPV(400,000 x 3.791 - 1,200,000=316,400). Option C applies an incorrect annuity factor. Option D uses a different cash flow figure.
An acquisition model shows positive NPV only in the best-case scenario. Both the base-case and worst-case NPVs are negative. Management argues the acquisition should proceed because the best case is achievable. Which concern is most significant?
Explanation: When a positive NPV appears only in the best-case scenario while both the base case and worst case are negative, the investment creates value only under the most optimistic assumptions. The base case typically represents the most likely outcome; if it shows negative NPV, the expected outcome of the investment is value destruction. Management's confidence does not change the probability structure of the scenarios. Option A sets an inappropriately low bar by requiring only one positive scenario. Option C is incorrect; NPV is the standard method for acquisition evaluation. Option D treats subjective management confidence as an analytical substitute.
A pricing sensitivity analysis (variable cost 30/unit,fixedcosts90,000) shows: at 40/unitwith10,000unitssold,contributionmargin100,000; at 44/unitwith9,000unitssold,126,000; at 48/unitwith7,500unitssold,135,000; at 52/unitwith6,000unitssold,132,000. Which price maximizes operating income?
Explanation: Operating income = Contribution margin - Fixed costs. At 40:100,000 - 90,000=10,000. At 44:126,000 - 90,000=36,000. At 48:135,000 - 90,000=45,000. At 52:132,000 - 90,000=42,000. The 48pricemaximizesoperatingincomeat45,000 because it achieves the highest total contribution margin (135,000).Pricingsensitivityanalysisofthistypeshowsthattheoptimalpriceisnotthehighestprice(whichlosestoomuchvolume)northelowest(whichsacrificescontributionmarginperunit).OptionAproducesthelowestoperatingincome(10,000). Option D produces lower operating income (36,000)thanthemaximum.OptionCproducesslightlyloweroperatingincome(42,000) than the maximum.
Two capital projects have similar base-case NPVs. Across all scenarios tested, Project A's NPV ranges from -50,000to+300,000. Project B's NPV ranges from -400,000to+500,000. Which conclusion best incorporates the scenario analysis results?
Explanation: Scenario analysis adds risk dimension to the NPV comparison. Project A stays close to positive NPV across all scenarios (−50Kto+300K), indicating resilience. Project B's wide range (−400Kto+500K) indicates much higher variance - the best case is better but the worst case is far more damaging. For risk-averse organizations or those with constrained capital, the limited downside of Project A may be more valuable than the higher upside of Project B. Option A selects based on upside alone without considering risk. Option C applies an unrealistic guarantee standard. Option D ignores the valuable information in the scenario range analysis.
Sensitivity analysis reveals that revenue is the most important NPV driver (a 10% shortfall reduces NPV by 65%). The revenue forecast was prepared by the same sales team that will be evaluated on achieving those targets. Which concern does this raise?
Explanation: Combining high sensitivity with a potential source of bias creates elevated model risk. When the assumption that most affects the outcome is prepared by individuals who benefit from optimistic targets, the forecast may be systematically overstated - not necessarily through dishonesty but through natural optimism bias. The appropriate response is an independent review, comparison to market data, or deliberate downside scenario testing of the revenue assumption. Option A correctly notes operational relevance but ignores the bias risk. Option B treats high sensitivity as a model defect. Option C incorrectly limits the concern to publicly reporting companies.
A two-way sensitivity analysis of a DCF model shows NPV is positive in all 9 cells at a 10% discount rate, but negative in 6 of 9 cells at a 12% discount rate. What is the most analytically appropriate conclusion?
Explanation: The two-way analysis reveals that the project's positive NPV depends heavily on the discount rate assumption. A relatively modest change from 10% to 12% - plausible if interest rates rise or the project's risk is reassessed - flips 6 of 9 scenarios from positive to negative. This is precisely the kind of insight scenario analysis is designed to provide: the project is not robustly positive but conditionally positive depending on a key assumption. The appropriate response is to carefully validate whether 10% is the right rate and understand what could cause it to change. Option A accepts the base-case result without acknowledging the identified sensitivity. Option B overreacts to a stress test. Option D dismisses valuable findings without justification.
A company's five-year plan assumes oil prices of 75perbarrel.Sensitivityanalysisshowsthat95 per barrel oil would increase annual operating costs by 8,000,000,eliminatingtheprojectedoperatingincomeof6,000,000 and creating a $2,000,000 operating loss. Which risk management response is most appropriate?
Explanation: A $20 per barrel increase in oil price (a plausible market movement) completely eliminates operating income and creates a loss. This is a material, plan-threatening sensitivity that demands a formal risk management response. Hedging through commodity futures or options can lock in a portion of oil costs; cost reduction programs can partially offset exposure; and contingency plans specify what management will do if prices rise. Proceeding without a response plan would leave the company exposed to a foreseeable and potentially severe disruption. Option A ignores the sensitivity finding. Option B is a disproportionate response to a commodity price risk. Option C dismisses a plausible scenario.
Sensitivity analysis of an annual budget (operating income 800,000)shows:a1400,000; a 5% SGA reduction increases it by 300,000;a10150,000. Which conclusion best integrates these findings for risk management prioritization?
Explanation: A 1% gross margin decline reduces operating income by 400,000−halfthetotalbudgetof800,000. This is the highest-impact sensitivity in the analysis. By comparison, a 5% SGA reduction generates 300,000,anda10150,000. Risk management resources should be directed proportionally to impact: gross margin deserves the most attention, with pricing, product mix, and COGS all key monitoring areas. Option A dismisses all three sensitivities as acceptable without noting the gross margin's disproportionate impact. Option B is incorrect; gross margin is also partially controllable through pricing and cost management. Option C incorrectly ranks interest rate sensitivity above the more impactful gross margin sensitivity.
A two-way sensitivity table shows: NPV = 850,000ata10620,000 at a 12% discount rate and 5% revenue growth. What is the estimated impact on NPV of a 1-percentage-point increase in the discount rate, holding revenue growth constant?
Explanation: The sensitivity table moves from a 10% to a 12% discount rate - a 2-percentage-point change, not 1. Total NPV impact over 2 points = 620,000−850,000 = -230,000.Impactper1percentagepoint=−230,000 / 2 = -115,000.Higherdiscountratesreducethepresentvalueoffuturecashflows,loweringNPV.OptionAincorrectlystatesthedirectionaspositive.OptionBappliesthefull2−pointNPVchange(−230,000) to a 1-point question, overstating the impact by a factor of two. Option C overstates the impact further beyond the total 2-point change.
Scenario analysis differs from one-way sensitivity analysis in that scenario analysis:
Explanation: Scenario analysis develops complete, internally consistent pictures of the future by simultaneously adjusting multiple interdependent variables. For example, a recession scenario would lower revenue, reduce margins, and increase borrowing costs together - a combination that reflects how the world actually works. Sensitivity analysis isolates one variable at a time to measure its individual impact. Option A describes sensitivity analysis. Option C is incorrect; scenario analysis is widely used in capital budgeting. Option D describes expected value calculation, not scenario analysis.
A break-even sensitivity analysis shows the project becomes unviable (NPV = 0) when annual cash flows fall to 316,840.Thebase−caseannualcashflowis400,000. What is the maximum percentage decline in cash flows the project can sustain before it becomes unviable?
Explanation: Maximum decline = (Base case - Break-even) / Base case = (400,000−316,840) / 400,000=83,160 / $400,000 = 20.8%. This metric tells management how much cushion exists between the expected cash flow and the minimum required for the project to break even on a present value basis. Option A uses an incorrect numerator. Option B and D result from different base amounts.
A company develops three revenue scenarios for Year 3: best case 8,000,000(256,000,000 (55% probability), worst case $4,000,000 (20% probability). What is the probability-weighted expected revenue?
Explanation: Expected revenue = (0.25 x 8,000,000)+(0.55x6,000,000) + (0.20 x 4,000,000)=2,000,000 + 3,300,000+800,000 = 6,100,000.Theexpectedvalueexceedsthebasecase(6,000,000) because the best-case upside (8M)islargerinabsolutetermsthantheworst−casedownside(4M), and the probabilities are not symmetric. Option A is the unweighted base case. Option B uses incorrect probability weights. Option D averages only the best and base cases.
A budget model is highly sensitive to market growth: at 8% growth, operating income is 2,000,000;at4800,000; at 0% growth, it becomes a $400,000 loss. Which analytical response is most appropriate?
Explanation: The wide range of operating income outcomes (2Mprofitto400K loss) for a 8-percentage-point range in market growth reveals high operating leverage and significant structural sensitivity. The appropriate analytical response is to stress-test cost flexibility: which costs are fixed in the short term vs. reducible, and what triggers would initiate cost reduction actions? This is actionable risk management. Option B avoids the risk signal. Option C is an extreme overcorrection based on the worst-case scenario. Option D dismisses a material planning risk.
A market entry scenario analysis produces: optimistic NPV 5,000,000(201,200,000 (50% probability), pessimistic NPV -2,500,000(30850,000. Management states: 'The positive expected NPV means we should proceed.' Which concern is most important?
Explanation: Expected NPV = (0.20 x 5M)+(0.50x1.2M) + (0.30 x -2.5M)=1M + 0.6M−0.75M = 0.85M.WhiletheexpectedNPVispositive,a302,500,000 is a material risk. If the downside loss would cause serious financial hardship, constrain other investment options, or exceed the risk appetite of the organization, the positive expected value alone may not be sufficient justification. Risk capacity and risk tolerance matter alongside expected value. Option A is incorrect; the calculation is correct. Option C overstates expected NPV as always definitive. Option D introduces unsupported optimism.