21 Aug Excel@Investing One of the unique features of futures contracts is that they hav
Excel@Investing
One of the unique features of futures contracts is that they have only one source of return—the capital gains that can accrue when price movements have an upward bias. Remember that there are no current cash flows associated with this financial asset. These instruments are known for their volatility due to swings in prices and the use of leverage upon purchase. With futures trading done on margin, small amounts of capital are needed to control relatively large investment positions.
Assume that you are interested in investing in commodity futures—specifically, oats futures contracts. Refer to the contract terms of oats: “OATS (CBOT) 5000 bu.; cents per bushel.” Suppose you had purchased 5 December oats contracts at the settlement price of 186.75. The required amount of investor capital to be deposited with a broker at the time of the initial transaction is 5.35% of a contract’s value. Create a spreadsheet to model and answer the following questions concerning the investment in futures contracts.
Questions
a.What is the total amount of your initial margin for the five contracts?
b.What is the total amount of bushels of oats that you control?
c.What is the purchase price of the oats commodity contracts you control according to the December settlement date?
d.Assume that the December oats actually settled at 186.75, and you decide to sell and take your profit. What is the selling price of the oats commodity contracts?
e.Calculate the return on invested capital earned on this transaction. (Remember that the return is based on the amount of funds actually invested in the contract rather than on the value of the contract itself.)
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.