NPV_final_exam

NPV_final_exam - Year Total 1 2 3 4 5 6 7 8 9 10 11 12 13...

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

View Full Document Right Arrow Icon
Year RDTE Setup Sales Fixed Cost Variable CostCashflow DCF (year 1) DCF (year 0) 1 1 0 0 0 0 -1 -0.90909091 -1 2 1 0 0 0 0 -1 -0.82644628 -0.90909091 3 1 0 0 0 0 -1 -0.7513148 -0.82644628 4 1 0 0 0 0 -1 -0.68301346 -0.7513148 5 1 3 0 0 0 -4 -2.48368529 -2.73205382 6 0 0 2 0.5 0.872115304 0.627884696 0.354424542 0.389866996 7 0 0 2 0.5 0.702345616 0.797654384 0.409322823 0.450255105 8 0 0 2 0.5 0.648599549 0.851400451 0.397184594 0.436903053 9 0 0 2 0.5 0.615957054 0.884042946 0.374920508 0.412412559 10 0 0 2 0.5 0.592759038 0.907240962 0.349780665 0.384758731 11 0 0 2 0.5 0.57490025 0.92509975 0.324241819 0.356666 12 0 0 2 0.5 0.560459179 0.939540821 0.29936666 0.329303326 13 0 0 2 0.5 0.548384778 0.951615222 0.275649033 0.303213936 14 0 0 2 0.5 0.538041222 0.961958778 0.253313812 0.278645193 15 0 0 2 0.5 0.529015535 0.970984465 0.232445961 0.255690557 Total 5 3 20 5 6.182577525 0.817422475 -2.38290032 -2.62119036 NPV in Billions $ Discount Rate 0.1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 -5 -4 -3 -2 -1 0 1 2 Cashflow DCF (year 1)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Aircraft S/N Variable Cost Learning curve 1 15 0.9 2 13.5 3 12.69308979 4 12.15 5 1 .74 80 83 6 1 .42378082 7 1 .15921751 8 10.935 9 10.74096857 10 10.57032074 1 10.418287 8 12 10.28140273 13 10.15706949 14 10.04329576 15 9.93852076 16 9.8415 17 9.7512 58 18 9.6 6871712 19 9.587 51206 20 9.51328 6 8 21 9.4 29 6 59 2 9.3764589 8 23 9.313 17646 24 9.25326246 25 9.196023095 26 9.141362538 27 9.089071902 28 9.03896 183 29 8.9 08 0793 30 8.94 6 869 31 8.90 1979 5 32 8.85735 3 8.816017483 34 8.7 6103292 35 8.737519134 36 8.70 184541 37 8.6 4025979 38 8.628976086 39 8.5949730 3 40 8.561959802 41 8.5298 3973 42 8.4986969 3 43 8.468353929 4 8.438 13098 45 8.410 35768 46 8.3819858 2 47 8.354629826 48 8.327936214 49 8.301875695 50 8.276420785 51 8.251545714 52 8.2 72 6285 53 8.203439753 54 8.180164712 5 8.1573809 1 56 8.135069565 57 8.1 321246 58 8.091792713 59 8.070794238 60 8.050201821 61 8.030 01036 62 8.010178196 63 7.9 0720302 64 7.971615 65 7.95285054 6 7.934 15735 67 7.91629 929 68 7.898492963 69 7.8 0985145 70 7.8637672 1 71 7.846830352 72 7.83016 087 73 7.81376 342 74 7.797623 81 75 7.781729793 76 7.76 07847 7 7.7506 2625 78 7.735475703 79 7.72051 4 3 80 7.705763821 81 7.6912 7053 82 7.676895 76 83 7.6 2764039 84 7.648 27294 85 7.635080384 86 7.621518536 87 7.608137149 8 7.594931789 89 7.581898178 90 7.569032191 91 7.5 6329845 92 7.543787294 93 7.53140 823 94 7.51916 84 95 7.5070818 5 96 7.495142593 97 7.483 4572 98 7.47168 126 9 7.46016 7 10 7.4 87 8707 872.1 53038 101 7.437521086 102 7.426391 42 103 7.415386198 104 7.404503656 105 7.3937409 7 106 7.3830957 8 107 7.372565626 108 7.362148241 109 7.351841386 1 0 7.341642892 1 1 7.3 15 0649 1 2 7.321562608 1 3 7.31 6767 7 1 4 7.3018912 1 5 7.292 04052 1 6 7.2826134 2 1 7 7.2731 7608 1 8 7.263714814 1 9 7.254 03 72 120 7.245181639 121 7.236048012 12 7.2 70 0932 123 7.218038 81 124 7.209160376 125 7.20 363976 126 7.191648272 127 7.18301 892 128 7.174 535 129 7.165971789 130 7.157565486 131 7.14923 347 132 7.140974161 13 7.132786743 134 7.1246 9 36 135 7.1 6 2 612
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/08/2011 for the course AERO 16.810 taught by Professor Olivierdeweck during the Winter '07 term at MIT.

Page1 / 2

NPV_final_exam - Year Total 1 2 3 4 5 6 7 8 9 10 11 12 13...

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