{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right Arrow Icon
Aircraft S/N Variable Cost Learning curve 1 15 0.9 2 13.5 3 12.69308979 4 12.15 5 11.74480083 6 11.42378082 7 11.15921751 8 10.935 9 10.74096857 10 10.57032074 11 10.41828778 12 10.28140273 13 10.15706949 14 10.04329576 15 9.938520766 16 9.8415 17 9.75122588 18 9.666871712 19 9.587751206 20 9.513288668 21 9.442996659 22 9.376458998 23 9.313317646 24 9.25326246 25 9.196023095 26 9.141362538 27 9.089071902 28 9.038966183 29 8.990880793 30 8.94466869 31 8.900197995 32 8.85735 33 8.816017483 34 8.776103292 35 8.737519134 36 8.700184541 37 8.664025979 38 8.628976086 39 8.594973003 40 8.561959802 41 8.529883973 42 8.498696993 43 8.468353929 44 8.438813098 45 8.410035768 46 8.381985882 47 8.354629826 48 8.327936214 49 8.301875695 50 8.276420785 51 8.251545714 52 8.227226285 53 8.203439753 54 8.180164712 55 8.157380991 56 8.135069565 57 8.113212466 58 8.091792713 59 8.070794238 60 8.050201821 61 8.030001036 62 8.010178196 63 7.990720302 64 7.971615 65 7.95285054 66 7.934415735 67 7.916299929 68 7.898492963 69 7.880985145 70 7.863767221 71 7.846830352 72 7.830166087 73 7.813766342 74 7.797623381 75 7.781729793 76 7.766078477 77 7.750662625 78 7.735475703 79 7.720511443 80 7.705763821 81 7.691227053 82 7.676895576 83 7.662764039 84 7.648827294 85 7.635080384 86 7.621518536 87 7.608137149 88 7.594931789 89 7.581898178 90 7.569032191 91 7.556329845 92 7.543787294 93 7.531400823 94 7.519166844 95 7.507081885 96 7.495142593 97 7.48334572 98 7.471688126 99 7.46016677 100 7.448778707 872.1153038 101 7.437521086 102 7.426391142 103 7.415386198 104 7.404503656 105 7.393740997 106 7.383095778 107 7.372565626 108 7.362148241 109 7.351841386 110 7.341642892 111 7.331550649 112 7.321562608 113 7.311676777 114 7.30189122 115 7.292204052 116 7.282613442 117 7.273117608 118 7.263714814 119 7.254403372 120 7.245181639 121 7.236048012 122 7.227000932 123 7.218038881 124 7.209160376 125 7.200363976 126 7.191648272 127 7.183011892 128 7.1744535 129 7.165971789 130 7.157565486 131 7.149233347 132 7.140974161 133 7.132786743 134 7.124669936 135 7.116622612 136 7.108643667 137 7.100732024 138 7.09288663 139 7.085106457 140 7.077390499 141 7.069737772 142 7.062147317 143 7.054618192 144 7.047149478 145 7.039740277 146 7.032389708 147 7.025096911 148 7.017861043 149 7.01068128 150 7.003556814 151 6.996486855 152 6.98947063 153 6.982507379 154 6.975596362 155 6.968736851 156 6.961928133 157 6.95516951 158 6.948460298 159 6.941799827 160 6.935187439 161 6.92862249 162 6.922104348 163 6.915632393 164 6.909206018 165 6.902824627 166 6.896487635 167 6.890194469 168 6.883944565 169 6.877737371 170 6.871572346 171 6.865448957 172 6.859366682 173 6.853325009
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}