Excel File Edit View Insert Format Tools Data Window Help 35% Sun 10:22 PM Tony Laaksonen...

Transcribed Image Text:

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 9 Peo 7 3-Nov 6,613.23 330.6613 2092.79 1785.37 103.48 4.6484 86.455 10 Cha 8 10-Nov 6714.84 335.7420 2035.92 1793.52 101.33 4.7866 80.635 91.66 91.39 91.35 91.57 92.42 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 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% 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 9 Peo 7 3-Nov 6,613.23 330.6613 2092.79 1785.37 103.48 4.6484 86.455 10 Cha 8 10-Nov 6714.84 335.7420 2035.92 1793.52 101.33 4.7866 80.635 91.66 91.39 91.35 91.57 92.42 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 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%