Calculate the profit over the whole period

Assignment Help Finance Basics
Reference no: EM133070305

The current value of an S&R futures is 1000$. You buy 50 futures on the S&R and the contract size is 500$. The margin is settled on a weekly basis and the margin is 12.5% of the notional value. Margin calls are made as soon as the the margin is below 75% of the initial margin level. We assume that r = 5%. Use an Excel spreadsheet to calculate the profit over the whole period for a) Futures and b) Forward contract. Upload your Excel Spreadsheet with the detailed calculations.

Week

Futures Price

0

1000

1

1000.8758

2

1049.7287

3

1000.233652

4

1090.6103

5

1031.3506

6

1068.291831

7

943.4941

8

1000.7646

9

1000.056343

10

1000.7060

11

1000.1154

12

1000.142013

13

998.3606

14

1024.8248

15

1029.59584

16

934.9980

17

1066.0310

18

1098.829283

19

1000.8389

20

1050.2562

21

916.6526633

22

932.3819

23

1074.1541

24

1000.836095

25

1000.8536

26

1000.9763

27

1000.339745

28

1043.9483

29

1000.8804

30

942.69728

31

1000.6212

32

1099.8170

33

1097.465249

34

1014.5519

35

1000.7180

36

977.1972236

37

940.3342

38

932.2331

39

998.2996464

40

1096.6308

41

1000.4736

42

1045.876523

43

1013.5664

44

1000.1654

45

1059.384213

46

991.1452

47

1021.9621

48

964.1776909

49

1068.3488

50

1000.3349

51

1000.086655

52

1044.1540

Reference no: EM133070305

Questions Cloud

What should be your need for life insurance : You are a dual-income, no-kids family. You and your spouse have the following debts (total): mortgage, $240,000; auto loan, $50,000; credit card balance
Commute the net present value of investment : All cash ?ows, except for the initial investment, would occur at the ends of the years. Reguired: Commute the net present value of this investment.
Explain why the net buying conditional on previous day : Explain why the net buying conditional on previous day's return differ between individuals investors (Panel A) and institutional investors (Panel B)?
Questions about earnings announcement : a). When examining return reactions to earnings announcements we focused on the earnings surprise. Describe one way to define the earnings surprise.
Calculate the profit over the whole period : The current value of an S&R futures is 1000$. You buy 50 futures on the S&R and the contract size is 500$. The margin is settled on a weekly basis and the margi
Discuss the purpose of the police service : Discuss the purpose of the police service and how it is created to uphold the law fairly and firmly; to prevent crime; to pursue and bring to justice
What should be the average beta of the new stocks : A mutual fund manager has a $20 million portfolio with a beta of 2.9. The risk-free rate is 4.5%, and the market risk premium is 5%. The manager expects to rece
Comparative criminal : Discuss the purpose of the police service and how it is created to uphold the law fairly and firmly; to prevent crime;
Coupon rate for the bond : A 30-year corporate bond with interest rate of 2.5% is traded at $950. Please estimate the coupon rate for the bond given par value=$1,000.

Reviews

Write a Review

Finance Basics Questions & Answers

  How are organizational information systems

How are organizational information systems related to company strategy? How does strategy affect the information systems a company develops and uses?

  You own a stock portfolio invested 32 percent in stock q

you own a stock portfolio invested 32 percent in stock q 19 percent in stock r 38 percent in stock s and 11 percent in

  What is the value of this investment to you in 10 years

consider an investment that provides the following cash flows for 10 years no cash flows for 15 years after that 120

  What are diary mefllodologies and why are flley used

Discuss ways in which interviewers can increase flle reliability and validity of flle information flley obtain from respondents.

  What is the capm-implied discount rate of xyz

Your analyst has collected the following data on XYZ. XYZ's stock is currently trading at $52.34 per share. Its earnings per share are $1.50 and its dividends p

  What amount will james have available for a down payment

With an interest rate of 4 percent, what amount will James have available for a down payment after the five years?

  What is the component cost of new common equity

What is the component cost of new common equity if Maple's tax rate is 35% and flotation costs on new common equity are 6% before tax?

   were designed to concentrate the credit risk of a bundle

1. were designed to concentrate the credit risk of a bundle of loans on one class of investor leaving the other

  Compute the npv of the project based on the expected cash

Aston Technologies is bringing a new product to market. It will require an investment of $200,000 today. The firm expects to sell 1,000 units per year at $26 each, for the next twenty years. Expenses are zero, and you can ignore taxes. The rel..

  What is the future value-present value-effective annual rate

1. What is the future value of $2,400 in 17 years assuming an interest rate of 7.9% compounded compounded semiannually?

  Prepare the assets section of heather corporations balance

heather corporation has collected the following information related to its december 31 2012 balance sheet.accounts

  What is the project payback period

Worthington Inc. is considering a project that has the following cash flow data. What is the project's payback period?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd