SLIDE 13 Discounted Cash Flow ‐ Example
PsychoCeramic Science, Inc. – Prepare a net present
Discounted Cash Flow Example
worth analysis using an interest rate of 13% and an inflation rate of 2%
$50 $105 $115 $90 $97 $75 $82 $65 $35 1 3 9 1 1 1 1 2 1 4 1 8 1 6 1 7 1 9 1 5 $90 $125 $100 $90
NPV = ‐$125,000‐$100,000(1+0.13+.02)‐1‐$90,000((1+0.13+.02)‐2 +$50 000((1+0 13+ 02)‐3 + + ($65 000+$35 000)((1+0 13+ 02)‐10 +$50,000((1+0.13+.02) + ….+ ($65,000+$35,000)((1+0.13+.02) = $17,996.77 Since NPV >0, select the project
25
Discounted Cash Flow ‐ Example Discounted Cash Flow Example
A B C D E F G
Discount Factor
NPV Inflation Year Inflow Outflow Net Flow
1/(1 + i + p)t
D x E Rate (p) 2010* 0.00 125,000.00 -125,000.00 1.0000
0.02 2010 0.00 100,000.00 -100,000.00 0.8696
0.02 2011 0.00 90,000.00
0.7561
0.02 2012 50,000.00 0.00 50,000.00 0.6575 32,875.81 0.02 2013 120,000.00 15,000.00 105,000.00 0.5718 60,034.09 0.02 2014 115 000 00 0 00 115 000 00 0 4972 57 175 32 0 02 2014 115,000.00 0.00 115,000.00 0.4972 57,175.32 0.02 2015 105,000.00 15,000.00 90,000.00 0.4323 38,909.48 0.02 2016 97,000.00 0.00 97,000.00 0.3759 36,465.89 0.02 2017 90 000 00 15 000 00 75 000 00 0 3269 24 517 63 0 02 2017 90,000.00 15,000.00 75,000.00 0.3269 24,517.63 0.02 2018 82,000.00 82,000.00 0.2843 23,309.52 0.02 2019 65,000.00 65,000.00 0.2472 16,067.01 0.02 2019 35,000.00 35,000.00 0.2472 8,651.46 0.02 , , , Total 759,000.00 360,000.00 399,000.00 17,996.77
26