Excel File Edit View Insert Format Tools Data Window Help 35% Sun 10:22 PM Tony Laaksonen Q AutoSave OFF AS#10-Systematic RiskData(FIN3582) Home Insert Draw Page Layout Formulas Data Review View AS#8: FS Returns & Gl Calibri (Body) 12 A A Paste B UMSL U I Share Comments Conditional Formatting Insert General 4 $ % 508 .00 0 Format as Table Cell Styles Delete Editing Ideas Format H6 fx A C D G H | J K L 202 Account Hor 2 Ann B E F FP#1: On 15-Sep a Malaysian investor buys, on margin, Mitsui stock trading on the Tokyo Stock Exchange, denominated in JPY. FP#2: On 15-Sep a Japanese investor shorts Mitsui stock trading on the Malaysian Stock Exchange, Kuala Lumpur denominated in Malaysian ringgit. 3 Dashboard Syll 4 Portfolio Date Security Position Margin Dis 5 Foreign Portfolio #1 Matsui (JPY) Long IM = 52% Currency Yen (JPY) Courses Purchase 15-Sep 6,290.69375 MM = 45% 95.81 JPY/USD 6 Mo 33 Groups Date of Record 16-Oct 7 Pag Dividend payment 20-Oct 14.49 8 Gra Liquidation 10-Nov 6,714.84375 101.33 JPY/USD 9 Calendar Peo 10 Foreign Portfolio #2 Short 15-Sep Matsui (MYR) RM 314.5345 Short IM = 59% Ringgit (MYR) 4.2815 MYR/USD Cha 11 Inbox ? Help Me God 14 Date of Record 16-Oct MM = 48% 12 Dividend payment 20-Oct RM 0.7245 13 Liquidation 10-Nov RM 335.742 4.7866 MYR/USD Net 15 16 17 God 18 K- God Descriptions Data + MAR 15 A TR 3 W P PNG + 100% Excel File Edit View Insert Format Tools Data Window Help 35% Sun 10:22 PM Tony Laaksonen Q AutoSave OFF AS#10-Systematic RiskData(FIN3582) Home Insert Draw Page Layout Formulas Data Review View AS#8: FS Returns & Gl Verdana 12 A A Paste UMSL B I U Share Comments Conditional Formatting Insert General 4 $ % 9 .00 0 Format as Table Cell Styles Delete Editing Ideas Format E18 fx A B C E F G H J K L M N 202 Table 10.2 Data Inputs for Risk Evaluation 1 Account Hor t Date Mitsui in JPY () Mitsui in Ringgit (RM) Nikki 400 Index Ann 2 Kuala Lumpur JPY/USD MYR/USD Index MYR FX Index JPY FX Index MYR/JPY JPY/MYR Dashboard 0 15-Sep 6290.69 314.5345 1962.87 1768.11 95.81 4.2815 85.635 91.68 0.044687 22.37767 3 Syll 1 22-Sep 6,616.14 330.8069 1999.49 1782.91 93.15 4.5345 84.892 91.78 4 Dis Courses 2 29-Sep 7,070.38 353.5188 2016.42 1732.44 90.64 4.5161 5 Mo 3 6-Oct 33 6 6,539.13 326.9563 1964.16 1717.25 96.27 4.8979 84.016 85.839 91.9 91.65 Groups Pag 7 Gra 8 4 13-Oct 6,681.58 334.0791 1953.25 1756.73 99.32 5.005 85.729 5 20-Oct 6,390.70 319.5352 2043.63 1777.98 104.73 5.1215 87.811 6 27-Oct Calendar 6,547.04 327.3519 2056.61 1770.06 105.67 4.9909 88.127 91.66 91.39 91.35 9 Peo 7 3-Nov 6,613.23 330.6613 2092.79 1785.37 103.48 4.6484 86.455 91.57 0.04868 20.54251 0.049825 20.07041 0.050877 19.65536 0.050393 19.84416 0.048902 20.44909 0.047231 21.17253 0.044921 22.26142 10 Cha 8 10-Nov 6714.84 335.7420 2035.92 1793.52 101.33 4.7866 80.635 92.42 0.047238 21.16951 11 Inbox ? Help K- Me 12 God 13 14 15 16 Net 17 18 God 19 20 God Descriptions Data + MAR 15 3 W P PNG A + 100%