Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page...

Transcribed Image Text:

Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page Layout 5 Formulas PS#2Data(FIN3582)-1 Data Review View Calibri (Body) 12 A A Paste BI U L10 fx Conditional Formatting General Format as Table $ % 9 00 Cell Styles 98% Sat 9:40 PM Tony Laaksonen Q A Update Later Microsoft AutoUpdate Update is ready to be installed. Restart App Delete Editing Ideas Format A B t Date 2 0 15-Mar C Sinopec (CNY) 483.8609 D Sinopec (PEN) 232.2222 E Beijing Mkt F Boisa de Valores G USD/CNY H J K L M N USD/PEN SDRs 144.96 16855.81 0.1506 0.3138 1.3955 3 1 22-Mar 482.1381 231.3894 146.8 15980.55 0.1502 0.3003 1.3353 4 2 29-Mar 477.2908 229.0631 145.91 15642.24 0.1519 0.2793 1.5869 5 3 6-Apr 476.5604 228.7126 143.93 15902.87 0.1575 0.2985 1.3578 6 4 13-Apr 486.0558 233.2696 142.5 16476.77 0.1524 0.3205 1.5363 7 5 20-Apr 493.8247 236.9981 139.73 16660.15 0.1558 0.3079 1.1238 8 6 27-Apr 478.8181 229.796 137.61 16110.41 0.1558 0.2626 1.3812 6 7 3-May 470.6507 225.8764 139.99 15961.09 0.1376 0.3299 1.2515 10 8 10-May 448.1408 215.0733 11 Chinese Co. price denominated 12 13 in yuan Holding Period Chinese Co. price denominated in sol 131.67 Chinese 15444.44 0.1468 0.3011 1.8312 Stock Market Index Peruian Stock Market Index CNY = China's yuan PEN = Peru's New Currency Index sol 0 14 Positions Established Positions 15-Mar 8 10-May 15 Liquidated 16 Descriptions Data MAR 3 7 + 100% 1 PAGES 3 Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page Layout 5 Formulas Calibri (Body) 12 A A Paste B I C20 A fx Portfolio 1 2 3 PS#2Data(FIN3582)-1 Data Review View Conditional Formatting General Format as Table $ % 9 00 Cell Styles v 98% Sat 9:41 PM Tony Laaksonen Q Microsoft AutoUpdate A Update Later Update is ready to be installed. Restart App L Delete Format Editing Ideas B D E F Date Security Position Margin Security FX G Domestic Country H FOREIGN PORTFOLIO#1 On 15-Mar a Chinese investor buys, on margin, Sinopec stock trading in Peru denominated in PEN Long Margin | IM = 55% PEN MM = 59% 4 Foreign Portfolio #1 15-Mar Sinopec Date of Record 16-Apr 5 6 Divident payment 20-Apr Div = 1.3409 7 Liquidate Position 10-May Sinopec Sell 8 China FOREIGN PORTFOLIO#2 On 15-Mar a Peruvian investor shorts Sinopec stock trading in Beijing, denominated in CNY. 9 10 Foreign Portfolio#2 15-Mar Div 2.7888 Date of Record 11 16-Apr 12 Divident payment 20-Apr Short IM = 62% MM = 60% CNY 13 Liquidate Position 10-May Sinopec Buy 14 Sinopec is a Chinese company. PEN = Peruvian New Sol, CNY = Chinese Yuan 15 16 17 18 19 Descriptions Data 3 MAR 7 Peru J K + 100% 1 PAGES 3 Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page Layout 5 Formulas PS#2Data(FIN3582)-1 Data Review View Calibri (Body) 12 A A Paste BI U L10 fx Conditional Formatting General Format as Table $ % 9 00 Cell Styles 98% Sat 9:40 PM Tony Laaksonen Q A Update Later Microsoft AutoUpdate Update is ready to be installed. Restart App Delete Editing Ideas Format A B t Date 2 0 15-Mar C Sinopec (CNY) 483.8609 D Sinopec (PEN) 232.2222 E Beijing Mkt F Boisa de Valores G USD/CNY H J K L M N USD/PEN SDRs 144.96 16855.81 0.1506 0.3138 1.3955 3 1 22-Mar 482.1381 231.3894 146.8 15980.55 0.1502 0.3003 1.3353 4 2 29-Mar 477.2908 229.0631 145.91 15642.24 0.1519 0.2793 1.5869 5 3 6-Apr 476.5604 228.7126 143.93 15902.87 0.1575 0.2985 1.3578 6 4 13-Apr 486.0558 233.2696 142.5 16476.77 0.1524 0.3205 1.5363 7 5 20-Apr 493.8247 236.9981 139.73 16660.15 0.1558 0.3079 1.1238 8 6 27-Apr 478.8181 229.796 137.61 16110.41 0.1558 0.2626 1.3812 6 7 3-May 470.6507 225.8764 139.99 15961.09 0.1376 0.3299 1.2515 10 8 10-May 448.1408 215.0733 11 Chinese Co. price denominated 12 13 in yuan Holding Period Chinese Co. price denominated in sol 131.67 Chinese 15444.44 0.1468 0.3011 1.8312 Stock Market Index Peruian Stock Market Index CNY = China's yuan PEN = Peru's New Currency Index sol 0 14 Positions Established Positions 15-Mar 8 10-May 15 Liquidated 16 Descriptions Data MAR 3 7 + 100% 1 PAGES 3 Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page Layout 5 Formulas Calibri (Body) 12 A A Paste B I C20 A fx Portfolio 1 2 3 PS#2Data(FIN3582)-1 Data Review View Conditional Formatting General Format as Table $ % 9 00 Cell Styles v 98% Sat 9:41 PM Tony Laaksonen Q Microsoft AutoUpdate A Update Later Update is ready to be installed. Restart App L Delete Format Editing Ideas B D E F Date Security Position Margin Security FX G Domestic Country H FOREIGN PORTFOLIO#1 On 15-Mar a Chinese investor buys, on margin, Sinopec stock trading in Peru denominated in PEN Long Margin | IM = 55% PEN MM = 59% 4 Foreign Portfolio #1 15-Mar Sinopec Date of Record 16-Apr 5 6 Divident payment 20-Apr Div = 1.3409 7 Liquidate Position 10-May Sinopec Sell 8 China FOREIGN PORTFOLIO#2 On 15-Mar a Peruvian investor shorts Sinopec stock trading in Beijing, denominated in CNY. 9 10 Foreign Portfolio#2 15-Mar Div 2.7888 Date of Record 11 16-Apr 12 Divident payment 20-Apr Short IM = 62% MM = 60% CNY 13 Liquidate Position 10-May Sinopec Buy 14 Sinopec is a Chinese company. PEN = Peruvian New Sol, CNY = Chinese Yuan 15 16 17 18 19 Descriptions Data 3 MAR 7 Peru J K + 100% 1 PAGES 3