Walt Disney - Yen Financing

Description
An excel spreadsheet showing the workings of Walt Disney Yen financing case

Disney Bank Loan Principal value 15000 Fees 112.5 Final value 14887.5 Semi annual Interest Rate 0.0375 Time Period 20 annual rate 0.075 Periods Yen 3.804% 7.753% 0 14887.5 1 -562.5 2 -562.5 3 -562.5 4 -562.5 5 -562.5

IRR Annual

6 -562.5

7 -562.5

8 -562.5

9 -562.5

10 -562.5

11 -562.5

12 -562.5

13 -562.5

14 -562.5

15 -562.5

16 -562.5

17 -562.5

18 -562.5

19 -562.5

20 -15562.5

Disney Period ECU Yen 0 -78.499 14445.15 1 -483.226 2 7.3 -483.226 3 -483.226 4 7.3 -483.226 5 -483.226 6 7.3 -483.226 7 -483.226 8 7.3 -483.226 9 -483.226 10 7.3 -1808.14 11 -1764.65 12 23.3 -1721.16 13 -1677.67 14 21.84 -1634.18 15 -1590.69 16 20.38 -1547.2 17 -1503.71 18 18.92 -1460.22 19 -1416.73 20 17.46 -1520.45 9.47% 7.01% Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 YTM

Utility ECU 80 -7.35 -7.35 -7.35 -7.35 -7.35 -23.35 -21.88 -20.41 -18.94 -17.47 9.19% Yen -14445.2 483.226 483.226 483.226 483.226 483.226 483.226 483.226 483.226 483.226 1808.141 1764.65 1721.16 1677.67 1634.179 1590.689 1547.199 1503.708 1460.218 1416.728 1520.45 7.01%

YTM



doc_342059837.xls