View the step-by-step solution to:

Question

FS#2sheet.png

The question refers to the spreadsheet

above


Calculate the return on the foreign currency investment for the Peruvian investor, fx#2

FS#2sheet.png

PS#2Data(FIN3582)-1 [Protected View] - Microsoft Excel
X
File
Home
Insert
Page Layout
Formulas
Data
Review
View
v ? -5 X
i
Protected View This file originated from an Internet location and might be unsafe. Click for more details.
Enable Editing
X
A1
fx Portfolio
A
B
C
D
E
F
G
H
Portfolio
Date
Security
Position
Margin
Security
Domestic
1
FX
Country
2
FOREIGN PORTFOLIO#1
3
On 15-Mar a Chinese investor buys, on margin, Sinopec stock trading in Peru denominated in PEN
4
Foreign Portfolio#1
15-Mar
Sinopec
Long Margin
IM = 55%
PEN
China
Date of Record
16-Apr
MM = 59%
6
Divident payment
20-Apr
Div = 1.3409
Liquidate Position
10-May
Sinopec
Sell
8
FOREIGN PORTFOLIO#2
9
On 15-Mar a Peruvian investor shorts Sinopec stock trading in Beijing, denominated in CNY.
10
Foreign Portfolio#2
15-Mar
Div= 2.7888
Short
IM = 62%
CNY
Peru
11
Date of Record
16-Apr
MM = 60%
12
Divident payment
20-Apr
13
Liquidate Position
10-May
Sinopec
Buy
14
Sinopec is a Chinese company. PEN = Peruvian New Sol, CNY = Chinese Yuan
15
16
4 Descriptions Data
1III
Ready
#80 100%
+
Type here to search
O Ei
W
3:35 PM
10/13/2019

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes