Sensitivity

Sensitivity - NPV $1,516.74 $1,450.37 $1,450.37 $1,383.99...

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

View Full Document Right Arrow Icon
Variable Expected valuBelow 1% NPV- Percentage Above 1% NPV+ Percentage market size 10000 9900 $1,450.37  -4.38% 10100 $1,583.11  4.38% market share 0.3 0.297 $1,450.37  -4.38% 0.303 $1,583.11  4.38% price 2 1.98 $1,383.99  -8.75% 2.02 $1,649.48  8.75% variable cost 1 0.99 $1,583.11  4.38% 1.01 $1,450.37  -4.38% fixed cost 1791 1773.09 $1,556.36  2.61% 1808.91 $1,477.11  -2.61% investment 1500 1485 $1,528.32  0.76% 1515 $1,505.16  -0.76% discount rate 0.15 0.1485 $1,527.48  0.71% 0.1515 $1,506.06  -0.70% $1,516.74 
Background image of page 1

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

View Full DocumentRight Arrow Icon
Variable Expected value Below 1% market size 10000 9900 10000 10000 10000 10000 10000 10000 market share 0.3 0.3 0.297 0.3 0.3 0.3 0.3 0.3 1450.365788 price 2 2 2 1.98 2 2 2 2 1450.365788 variable cost 1 1 1 1 0.99 1 1 1 1383.993117 fixed cost 1791 1791 1791 1791 1791 1773.09 1791 1791 1583.11113 investment 1500 1500 1500 1500 1500 1500 1485 1500 1556.362943 discount rate 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.1485 1528.319261 1527.483495 revenue 6000 5940 5940 5940 6000 6000 6000 6000 costs 4791 4761 4761 4791 4761 4773.09 4791 4791 tax 309.06 298.86 298.86 288.66 319.26 315.1494 310.08 309.06 ann cash flow 899.94 880.14 880.14 860.34 919.74 911.7606 898.92 899.94
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: NPV $1,516.74 $1,450.37 $1,450.37 $1,383.99 $1,583.11 $1,556.36 $1,528.32 $1,527.48 Variable Expected value Above 1% market size 10000 10100 10000 10000 10000 10000 10000 10000 market share 0.3 0.3 0.303 0.3 0.3 0.3 0.3 0.3 1583.11113 price 2 2 2 2.02 2 2 2 2 1583.11113 variable cost 1 1 1 1 1.01 1 1 1 1649.483801 fixed cost 1791 1791 1791 1791 1791 1808.91 1791 1791 1450.365788 investment 1500 1500 1500 1500 1500 1500 1515 1500 1477.113974 discount rate 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.1515 1505.157657 1506.055458 revenue 6000 6060 6060 6060 6000 6000 6000 6000 costs 4791 4821 4821 4791 4821 4808.91 4791 4791 tax 309.06 319.26 319.26 329.46 298.86 302.9706 308.04 309.06 ann cash flow 899.94 919.74 919.74 939.54 880.14 888.1194 900.96 899.94 NPV $1,516.74 $1,583.11 $1,583.11 $1,649.48 $1,450.37 $1,477.11 $1,505.16 $1,506.06...
View Full Document

Page1 / 2

Sensitivity - NPV $1,516.74 $1,450.37 $1,450.37 $1,383.99...

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