Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B D E F G H 1 date year month myield_ind myield_usa ner_usd cpi_ind cpi_usa carry 2 1/30/2004 2004 1 4.23 0.83 45.27

image text in transcribedimage text in transcribed

A B D E F G H 1 date year month myield_ind myield_usa ner_usd cpi_ind cpi_usa carry 2 1/30/2004 2004 1 4.23 0.83 45.27 109.00 186.30 0.035 3 2/27/2004 2004 2 4.26 0.94 45.24 109.00 186.70 0.072 4 3/31/2004 2004 3 4.21 0.94 43.60 109.00 187.10 0.012 5 4/30/2004 2004 4 4.29 0.81 44.50 109.00 187.40 0.013 6 5/31/2004 2004 5 4.38 0.93 45.47 110.00 188.20 0.021 7 6/30/2004 2004 6 4.32 1.08 46.06 111.00 188.90 0.023 8 7/30/2004 2004 7 4.39 1.24 46.47 112.00 189.10 0.034 9 8/31/2004 2004 8 4.43 1.42 46.35 113.00 189.20 0.039 10 9/30/2004 2004 9 4.80 1.47 45.95 113.00 189.80 0.046 11 10/29/2004 2004 10 5.12 1.72 45.39 114.00 190.80 0.052 12 11/30/2004 2004 11 5.07 2.04 44.64 113.00 191.70 0.059 13 12/31/2004 2004 12 5.18 1.85 43.46 113.00 191.70 0.027 14 1/31/2005 2005 1 4.89 2.01 43.72 114.00 191.60 0.030 15 2/28/2005 2005 2 5.04 2.48 43.68 113.00 192.40 0.024 16 3/31/2005 2005 3 5.14 2.61 43.75 113.00 193.10 0.030 17 4/29/2005 2005 4 5.05 2.67 43.54 114.00 193.70 0.020 18 5/31/2005 2005 5 5.07 2.76 43.70 114.00 193.60 0.028 19 6/30/2005 2005 6 5.26 2.97 43.49 114.00 193.70 0.023 20 7/29/2005 2005 7 5.13 3.22 43.48 116.00 194.90 0.003 21 8/31/2005 2005 8 5.12 3.36 44.15 117.00 196.10 0.021 22 9/30/2005 2005 9 5.19 3.11 44.02 117.00 198.80 -0.006 23 10/31/2005 2005 10 5.31 3.73 45.16 118.00 199.10 -0.002 24 11/30/2005| 2005 11 5.62 3.94 45.93 119.00 198.10 0.037 A B C D E 1 Date year month sp500 sp500 return F G nifty50 nifty50 return 2 Jan-00 2000 1 1394.46 -2.01% 1546.20 3 Feb-00 2000 2 1366.42 9.67% 1654.80 H |bovespa 7.02% 16388.27 -7.64% 17660.20 J K L M bovespa return real_us real return inr_usd inr return 7.76% 1.78 -0.11% 43.61 0.02% 0.91% 1.78 0.00% 43.62 0.09% 4 Mar-00 2000 3 1498.58 5 Apr-00 2000 4 1452.43 -3.08% -2.19% 1406.55 1528.45 -7.98% 17820.37 -12.81% 1.78 0.00% 43.66 2.11% -1.86% 15537.60 -3.74% 1.78 0.00% 44.58 0.22% 6 May-00 2000 5 1420.60 2.39% 1380.45 6.59% 14956.61 11.84% 1.78 0.00% 44.68 0.69% 7 Jun-00 2000 6 1454.60 -1.63% 1471.45 -9.42% 16727.95 -1.63% 1.78 0.00% 44.99 1.80% 8 Jul-00 2000 7 1430.83 6.07% 1332.85 4.60% 16454.60 5.42% 1.78 0.00% 45.80 0.59% 9 Aug-00 2000 8 1517.68 -5.35% 1394.10 -8.78% 17346.70 -8.18% 1.78 0.00% 46.07 1.58% 10 Sep-00 2000 9 1436.51 -0.49% 1271.65 -7.78% 15928.39 -6.66% 1.78 0.00% 46.80 0.09% 11 Oct-00 2000 10 1429.40 -8.01% 1172.75 8.13% 14867.23 -10.63% 1.78 0.00% 46.84 -0.19% 12 Nov-00 2000 11 1314.95 0.41% 1268.15 -0.36% 13287.39 14.84% 1.78 0.00% 46.75 -0.73% 13 Dec-00 2000 12 1320.28 3.46% 1263.55 8.56% 15259.29 15.82% 1.78 0.00% 46.41 0.43% 14 Jan-01 2001 1 1366.01 -9.23% 1371.70 -1.48% 17672.77 -10.08% 1.78 0.00% 46.61 0.06% 15 Feb-01 2001 2 1239.94 -6.42% 1351.40 -15.04% 15891.41 -9.14% 1.78 0.00% 46.64 0.47% 16 Mar-01 2001 3 1160.33 7.68% 1148.20 -2.00% 14438.45 3.32% 1.78 0.00% 46.86 0.28% 17 Apr-01 2001 4 1249.46 0.51% 1125.25 3.79% 14917.54 -1.79% 1.78 0.00% 46.99 0.11% 18 May-01 2001 5 1255.82 -2.50% 1167.90 -5.14% 14649.98 -0.62% 1.78 0.00% 47.04 0.26% 19 Jun-01 2001 6 1224.38 20 Jul-01 2001 7 1211.23 21 22 Aug-01 2001 8 00 22 Sep-01 2001 9 23 Oct-01 2001 10 24 Nov-01 2001 1133.58 1040.94 1059.78 11 1139.45 -1.07% 1107.90 -6.41% 1072.85 -8.17% 1053.75 1.81% 913.85 7.52% 971.90 0.76% 1067.15 -3.16% 14559.79 -5.53% 1.78 0.00% 47.16 -0.02% -1.78% 13754.16 -13.28% 12840.60 -6.64% 1.78 0.00% 47.15 1.51% -17.17% 1.78 0.00% 47.86 0.23% 6.35% 10635.74 6.85% 1.78 0.00% 47.97 0.04% 9.80% 11364.71 13.79% 1.78 0.00% 47.99 0.40% -0.76% 12931.71 4.99% 1.78 0.00% 48.18 0.83%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture capital and the finance of innovation

Authors: Andrew Metrick

2nd Edition

9781118137888, 470454709, 1118137884, 978-0470454701

More Books

Students also viewed these Finance questions

Question

Why is the financial structure of a company important? Explain.

Answered: 1 week ago