Breakeven Sensitivity Analysis
Not what you're looking for?
The expected annual free cash flow for the GPS tracker investment from problem 3-1 is computed as follows:
Revenues 1,250,000
Variable cost 750,000
Fixed expenses 250,000
Gross profit 250,000
Depreciation 100,000
Net operating income 150,000
Income tax expense 51,000
NOPAT 99,000
Plus: depreciation 100,000
Less: CAPEX
Less: working capital investment
Free cash flow 199,000
a. Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or estimates:
Base Case Estimates Values
Initial cost of equipment 1, 000,000
Project and equipment life 10 years
Salvage value of equipment 0
Working capital requirement 0
Depreciation method Straight-line
Depreciation expense 100,000
Discount rate 10.00%
Tax rate 34.00%
Unit sales 10,000
Price per unit 125.00
Variable cost per unit 75.00
Fixed costs 250,000
b. What level of annual unit sales does it take for the investment to achieve a zero NPV? Use your spreadsheet model to answer this question. (Hint: Use the Goal Seek function in Excel.)
c. If unit sales were 15% higher than the base case, what unit price would it take for the investment to achieve a zero NPV?
Purchase this Solution
Solution Summary
This solution illustrates how to build an manipulate a spreadsheet model in order to perform a sensitivity analysis on a product's sales volume and unit selling price.
Solution Preview
Please see the attached Excel 97-2003 spreadsheet. Please note ...
Purchase this Solution
Free BrainMass Quizzes
Lean your Process
This quiz will help you understand the basic concepts of Lean.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.