Question: Question 5 in the assignment entailed borrowing (asset 4 was the risk-free asset) to invest in asset 1. In other words, you were margin trading

Question 5 in the assignment entailed borrowing (asset 4 was the risk-free asset) to invest in asset 1. In other words, you were margin trading to invest in asset 1.

a) Calculate your margin at the end of every month. When, if ever, do you receive a margin call?Uusing the excel to solve the above question, thanks!
How can I calculate the margin and margin call?

short $100 of asset 4 and use those $100 plus $100 to invest in asset 1 Date Asset 1 Asset 4 Sum Return rate 12 month return Year Annual return 192612 200 -100 100 1927 0.577769901 192701 199.88 -100.25 99.63 -0.0037 1928 0.697386191 0.081 -0.0004 0.0067 1929 1930 1931 192702 207.589068 -99.889038 107.70003 192703 215.6800801 -108.02313 107.65695 192704 216.3043439 -107.926092 108.3782516 192705 228.5480569 -108.703386 119.8446706 192706 234.0806106 -120.156267 113.9243438 192707 244.3905024 -114.266117 130.1243855 192708 265.3756719 -130.488734 134.886938 192709 282.6151126 -135.170201 147.444912 192710 282.1800725 -147.813524 134.3665483 192711 286.4157343 -134.648718 151.7670163 192712 309.8778939 -152.100904 157.7769901 0.1058 -0.0494 0.1422 1932 1933 -0.439181405 -0.569511946 -0.775712453 -0.402961688 0.98245136 0.013202065 1.037370163 0.696262736 -0.603836604 1934 1935 1936 0.0366 0.0931 -0.0887 0.1295 0.0396 1937 1938 1939 0.387800022 -0.014712153 0.577769901 short $100 of asset 4 and use those $100 plus $100 to invest in asset 1 Date Asset 1 Asset 4 Sum Return rate 12 month return Year Annual return 192612 200 -100 100 1927 0.577769901 192701 199.88 -100.25 99.63 -0.0037 1928 0.697386191 0.081 -0.0004 0.0067 1929 1930 1931 192702 207.589068 -99.889038 107.70003 192703 215.6800801 -108.02313 107.65695 192704 216.3043439 -107.926092 108.3782516 192705 228.5480569 -108.703386 119.8446706 192706 234.0806106 -120.156267 113.9243438 192707 244.3905024 -114.266117 130.1243855 192708 265.3756719 -130.488734 134.886938 192709 282.6151126 -135.170201 147.444912 192710 282.1800725 -147.813524 134.3665483 192711 286.4157343 -134.648718 151.7670163 192712 309.8778939 -152.100904 157.7769901 0.1058 -0.0494 0.1422 1932 1933 -0.439181405 -0.569511946 -0.775712453 -0.402961688 0.98245136 0.013202065 1.037370163 0.696262736 -0.603836604 1934 1935 1936 0.0366 0.0931 -0.0887 0.1295 0.0396 1937 1938 1939 0.387800022 -0.014712153 0.577769901

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

just question 1 the information needed is attached calculates a range of possible valuations which prospective purchasers might make for the ordinary shares of the company, based on the following...

please help before 1145am TAT Question 5 (16 marks) Andrew has $1,000,000 to invest in a risk-free asset, Stock BB, Stock TC and Stock MT respectively. By investing all money, he aims to create a...

Need help with finance investment homework. Deadline is in 15 hours. Thank you. 1 Investments - Finance 460AB Homework #4, Due Friday February 10, 2017 at 6 PM For all assignments: Please place your...

The last exam will cover these 3 tests plus a few small quizzes. The attached should give you a good idea of the material. Let me know if you have any questions. You can see which I got correct with...

Please provide excel spreadsheet detailing how you got to the multiple choice answer. I am trying to get ahead and understand each of the practiceproblems in prep for a exam so it would be very...

Hey i need you help with my Portfolio final report. i get some of them and want you to finish it, i will upload the professor sample report, and half of my work, plus the week 4 and week 5 report...

Hey, you answered some questions a while ago but 5 of them were wrong. Is that possible for you make them right? Here are the questions: Red highlighting means wrong. QUESTION 1 An implication of the...

Must give a thumb like if answered all questions correctly. Many thanks! Case 2 Derivatives Asset Management You are a fund manager in Derivatives Asset Management Fund (2322.HKU). You manage a...

I'm working on Question #5 (parts a and b) and do not have a good understanding of Put Warrant or Convertible Bonds. I'm able to find some information on line as to what they are, however, it is...

A $10,000 Nova Chemicals Corp. bond carrying an 8% coupon is currently priced to yield 7% compounded semiannually until maturity. If the bond price abruptly falls by $250, what is the change in the...

Carmel Department Store uses the retail inventory method. On December 31, 2011, the following information relating to the inventory was gathered: Compute the ending inventory value at December 31,...

Given the following information what is the total expected investment yield rate, y 0 ? ( lgnoring the time value of money ) You expect to hold the investment for five years with the NOI unchanged...

Question 1 9 A ( n ) is one when parties have not performed their agreement. executed contract executory contract express contract exculpatory contract unenforceable contract

When you observe the nonverbal behavior of others, what do you notice first?

How do you communicate intimacy nonverbally?

Recently, the author of this excellently written text had a female student from Saudi Arabia enrolled in his class. At one of their first meetings, the author extended his hand to her in greeting....