Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Calculate the current and quick ratio at the end of eachyear.Note: Round your answers to 1 decimal place.b. Assuming a 365-day year for all calculations, compute thefollowing:i. The collection pe...
-
Below are several scenarios related to control activities of a company? 1. A manufacturing company compares total sales in the current year to those in the previous year but does not compare the cost...
-
One-year Treasury bills currently earn 3.75 percent. You expected that one year from now, one-year Treasury bill rates will increase to 4.15 percent. If the unbiased expectations theory is correct,...
-
Which of the following sequence of steps most likely will be used in an efficiency evaluation study? a. Construct a system model; construct a workload model; define performance indices b. Define...
-
The Kretovich Company had a quick ratio of 1.4, a current ratio of 3.0, an inventory turnover of 6 times, total current assets of $810,000, and cash and marketable securities of $120,000. What were...
-
ga d 9. Briefly outline the provisions of the tax code relat- ing to deductibility of premiums and taxation of policy proceeds in key-person life insurance
-
Write a note on Ethics and Decision-Making.
-
: Let f RR be defined by f(x) =5x-1 for all x E R. We will prove that fis bijective in two ways. (a) First, prove that f is bijective by proving that f is one-to-one and onto. (i.e. that f satisfies...
-
What additional leadership behaviors have you found valuable in motivating team members to action and excellence? (10 pts) Discuss the impact (pros and cons) of artificial intelligence on project...
-
There are 3 identical firms that mine bauxite in Australia. The cost curve of each individual firm is given by Cj(Qj) = 9Qj2+12Qj for j = 1,2,3. Q is measured in tons. Suppose that these are the only...
-
How Starbucks utilizes basic economic tools to guide its decision making for future stores and menu. Answer the questions below and provide supporting theory, or articles to substantiate your...
-
Explain why wearable data tracking technology is so innovative in the sports world? Explain why in baseball/softball there have been so many advancements in data tracking? For sports leaders should...
-
What is earthquake disaster mitigation?
-
1. Advertising for eyeglasses _________ (increases/decreases) the price of eyeglasses because advertising promotes _________. 2. An advertisement that succeeds in getting consumers to try the product...
Study smarter with the SolutionInn App