3 walt disney sleeping beauty bonds

8/13/2019 3 Walt Disney Sleeping Beauty Bonds

1/10

Sleeping Beauties Basic Spreadsheet

Calendar Relative Cash Flow Interest Year Year per $100 Rate

1993 0 6.55%1994 1 7.55 7.08591995 2 7.55 6.65031996 3 7.55 6.24151997 4 7.55 5.85781998 5 7.55 5.49771999 6 7.55 5.15972000 7 7.55 4.84252001 8 7.55 4.54482002 9 7.55 4.26552003 10 7.55 4.00322004 11 7.55 3.75722005 12 7.55 3.5262

2006 13 7.55 3.30942007 14 7.55 3.1062008 15 7.55 2.9152009 16 7.55 2.73582010 17 7.55 2.56772011 18 7.55 2.40982012 19 7.55 2.26172013 20 7.55 2.12262014 21 7.55 1.99222015 22 7.55 1.86972016 23 7.55 1.75482017 24 7.55 1.6469

2018 25 7.55 1.54562019 26 7.55 1.45062020 27 7.55 1.36152021 28 7.55 1.27782022 29 7.55 1.19922023 30 7.55 1.12552024 31 7.55 1.05632025 32 7.55 0.99142026 33 7.55 0.93042027 34 7.55 0.87322028 35 7.55 0.81962029 36 7.55 0.76922030 37 7.55 0.72192031 38 7.55 0.67752032 39 7.55 0.63592033 40 7.55 0.59682034 41 7.55 0.56012035 42 7.55 0.52572036 43 7.55 0.49332037 44 7.55 0.4632038 45 7.55 0.4346

1993 Carliss Y. Baldwin


2/10

2039 46 7.55 0.40782040 47 7.55 0.38282041 48 7.55 0.35922042 49 7.55 0.33722043 50 7.55 0.31642044 51 7.55 0.297

2045 52 7.55 0.27872046 53 7.55 0.26162047 54 7.55 0.24552048 55 7.55 0.23042049 56 7.55 0.21622050 57 7.55 0.2032051 58 7.55 0.19052052 59 7.55 0.17882053 60 7.55 0.16782054 61 7.55 0.15752055 62 7.55 0.14782056 63 7.55 0.13872057 64 7.55 0.13022058 65 7.55 0.12222059 66 7.55 0.11472060 67 7.55 0.10762061 68 7.55 0.1012062 69 7.55 0.09482063 70 7.55 0.0892064 71 7.55 0.08352065 72 7.55 0.07842066 73 7.55 0.07352067 74 7.55 0.0692068 75 7.55 0.06482069 76 7.55 0.06082070 77 7.55 0.05712071 78 7.55 0.05362072 79 7.55 0.05032073 80 7.55 0.04722074 81 7.55 0.04432075 82 7.55 0.04152076 83 7.55 0.0392077 84 7.55 0.03662078 85 7.55 0.03432079 86 7.55 0.03222080 87 7.55 0.03032081 88 7.55 0.0284

2082 89 7.55 0.02662083 90 7.55 0.0252084 91 7.55 0.02352085 92 7.55 0.0222086 93 7.55 0.02072087 94 7.55 0.01942088 95 7.55 0.01822089 96 7.55 0.01712090 97 7.55 0.016



3/10


4/10

Sleeping Beauties Present Valueas a Function of the Interest Rate

Calendar Relative Cash Flow Interest Present Year Year per $100 Rates Values

1993 0 2% $339.201994 1 7.55 3% $243.781995 2 7.55 4% $186.991996 3 7.55 5% $150.611997 4 7.55 6% $125.761998 5 7.55 7% $107.851999 6 7.55 8% $94.382000 7 7.55 9% $83.892001 8 7.55 10% $75.502002 9 7.55 11% $68.642003 10 7.55 12% $62.922004 11 7.55 13% $58.082005 12 7.55 14% $53.932006 13 7.55 15% $50.332007 14 7.55 16% $47.192008 15 7.55 17% $44.412009 16 7.55 18% $41.942010 17 7.55 19% $39.742011 18 7.55 20% $37.752012 19 7.55 100% $7.552013 20 7.55 500% $1.512014 21 7.55 1000% $0.762015 22 7.552016 23 7.552017 24 7.55

2018 25 7.552019 26 7.552020 27 7.552021 28 7.552022 29 7.552023 30 7.552024 31 7.552025 32 7.552026 33 7.552027 34 7.552028 35 7.552029 36 7.55

2030 37 7.552031 38 7.552032 39 7.552033 40 7.552034 41 7.552035 42 7.552036 43 7.552037 44 7.552038 45 7.55



5/10

2039 46 7.552040 47 7.552041 48 7.552042 49 7.552043 50 7.552044 51 7.55

2045 52 7.552046 53 7.552047 54 7.552048 55 7.552049 56 7.552050 57 7.552051 58 7.552052 59 7.552053 60 7.552054 61 7.552055 62 7.552056 63 7.552057 64 7.552058 65 7.552059 66 7.552060 67 7.552061 68 7.552062 69 7.552063 70 7.552064 71 7.552065 72 7.552066 73 7.552067 74 7.552068 75 7.552069 76 7.552070 77 7.552071 78 7.552072 79 7.552073 80 7.552074 81 7.552075 82 7.552076 83 7.552077 84 7.552078 85 7.552079 86 7.552080 87 7.552081 88 7.55

2082 89 7.552083 90 7.552084 91 7.552085 92 7.552086 93 7.552087 94 7.552088 95 7.552089 96 7.552090 97 7.55



6/10

2091 98 7.552092 99 7.552093 100 107.55



7/10

Maturity

Cash Flow per $100 Present ValueCalenda Relative SleepingNapping Interest Sleeping Napping

Year Year BeautiesBeauties Rates Beauties Beauties

1993 0 2% $339.20 $149.851994 1 7.55 7.55 3% $243.78 $138.811995 2 7.55 7.55 4% $186.99 $128.791996 3 7.55 7.55 5% $150.61 $119.691997 4 7.55 7.55 6% $125.76 $111.411998 5 7.55 7.55 7% $107.85 $103.861999 6 7.55 7.55 7.55% $100.00 $100.002000 7 7.55 7.55 8% $94.38 $96.982001 8 7.55 7.55 9% $83.89 $90.692002 9 7.55 7.55 10% $75.50 $84.952003 10 7.55 107.55 11% $68.64 $79.682004 11 7.55 12% $62.92 $74.862005 12 7.55 13% $58.08 $70.432006 13 7.55 14% $53.93 $66.362007 14 7.55 15% $50.33 $62.612008 15 7.55 16% $47.19 $59.162009 16 7.55 17% $44.41 $55.982010 17 7.55 18% $41.94 $53.042011 18 7.55 19% $39.74 $50.322012 19 7.55 20% $37.75 $47.802013 20 7.552014 21 7.552015 22 7.552016 23 7.55

2017 24 7.552018 25 7.552019 26 7.552020 27 7.552021 28 7.552022 29 7.552023 30 7.552024 31 7.552025 32 7.552026 33 7.552027 34 7.552028 35 7.55



8/10


$0.00

$50.00

$100.00

$150.00

$200.00

2% 4% 6% 8% 10% 12% 14% 16% 18% 20%

P r e s e n

t V a

l u e

Interest Rate

Present Value of a 100-year and a 10-yearBond as a Function of the Interest Rate


9/10

Interest Rates Bond Value2% 339.203% 243.784% 186.995% 150.616% 125.767% 107.858% 94.389% 83.89

10% 75.5011% 68.6412% 62.9213% 58.0814% 53.9315% 50.3316% 47.1917% 44.4118% 41.94

19% 39.7420% 37.75

100% 7.55500% 1.51

1000% 0.76


10/10

InterestSleepingBeauty

NappingBeauties

2.00% 339.20 149.853.00% 243.78 138.814.00% 186.99 128.795.00% 150.61 119.696.00% 125.76 111.417.00% 107.85 103.867.55% 100.00 100.008.00% 94.38 96.989.00% 83.89 90.69

10.00% 75.50 84.9511.00% 68.64 79.6812.00% 62.92 74.8613.00% 58.08 70.4314.00% 53.93 66.36

15.00% 50.33 62.6116.00% 47.19 59.1617.00% 44.41 55.9818.00% 41.94 53.0419.00% 39.74 50.3220.00% 37.75 47.80

3 walt disney sleeping beauty bonds

Documents