SLIDE 17 PsychoCeramic Science, Inc. – Prepare a net present worth analysis using an interest rate of 13% and an inflation rate of 2%
16 12 13 14 15 17 21 19 20 22
$125
18
$100 $90 $50 $105 $115 $90 $97 $75 $82 $65 $35
NPW = ‐$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 = $17,996.77 Since NPW >0, select the project
Cash Flow Analysis ‐ Example
33
Cash Flow Analysis‐ Example
A B C D E F G
Discount Factor
NPW Inflation Year Inflow Outflow Net Flow
1/(1 + r + p)t
D x E Rate (p) 2013* 0.00 125,000.00 -125,000.00 1.0000
0.02 2013 0.00 100,000.00 -100,000.00 0.8696
0.02 2014 0.00 90,000.00
0.7561
0.02 2015 50,000.00 0.00 50,000.00 0.6575 32,875.81 0.02 2016 120,000.00 15,000.00 105,000.00 0.5718 60,034.09 0.02 2017 115,000.00 0.00 115,000.00 0.4972 57,175.32 0.02 2018 105,000.00 15,000.00 90,000.00 0.4323 38,909.48 0.02 2019 97,000.00 0.00 97,000.00 0.3759 36,465.89 0.02 2020 90,000.00 15,000.00 75,000.00 0.3269 24,517.63 0.02 2021 82,000.00 82,000.00 0.2843 23,309.52 0.02 2022 65,000.00 65,000.00 0.2472 16,067.01 0.02 2022 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
34