Market Analysis: Index Values and Buying on Margin- Excel Spreadsheet is Needed

Questions/Business/ManagementMarket Analysis: Index Values and Buying on Margin- Excel Spreadsheet is Needed
I have attached the table on Word so that you can understand it
Part One: Index Values
You have been considering investing in one or more stocks listed in the Calvin Index. The following is a list of companies in the index and their relevant information:
Company Number of Shares Outstanding Market Price on January 1, 2009 Current Market Price on December 31, 2011 Czar 1,000 $1.50
$10.00
Beetls 3,000 $3.00
$11.00
Warf 5,000 $4.50
$18.00
Novit 4,000 $6.00
$3.50
Jems 1,500 $10.00
$35.00
Required: 1.Assuming there have been no stock splits during the above-noted time period, what is the value of the Calvin Index on December 31, 2011 if the index is price weighted? 2.If a value-weighted approach is used, what would be the value of the Index? 3.Describe how these index values could be used by investors.
Part Two: Buying on Margin
You are considering the purchase of 500 shares of stock in an electronics firm, X, Inc., which is currently selling for $40 per share. You could pay cash for the stock, but you could also buy the stock on margin of 35%. Because of the possible gains, buying on margin is attractive. However, you are also concerned with the possible losses if the value of the stock declines.
Required: 1.If the value of the stock increases to $50 per share, what is your percentage gain if you pay cash for the asset? What is your percentage gain if you purchase the stock with a margin of 35%? 2.If the value of the stock decreases to $25 per share, what is your percentage loss if you pay cash for the asset? What is your percentage loss if you purchase the stock with a margin of 35%? 3.Based on this information, describe the risks and benefits involved in making an investment on margin as compared to using cash.
Use good form, show all your calculations and conclusions.

Attachments
Company.doc

Join now or log in to start viewing answers.
Report DMCA

Prof_Expert4_UA 98 TUTOR Posted 180. Sold 177. Solution preview:
Part A Calvin index * Based on the above excel calculation, the calvin_index val** ** *** *** **** **** *** ***** ***** ** ******** ** ***** *** ***** * ***** ***** *** ***** ** *** ***** ** ***** ** *** ***** ***** ******** (Brealey, ***** * ***** ****** *** investors *** investors *** *** *** ***** ***** ****** ** **** *** **** ***** ****** investment ****** ***** *** ***** ******* *** **** ***** preference ****** ** **** *** ****** ** ***** ** *** *** ***** ***** *** ***** ****** ***** ***** ***** * ** ***** *** ******** ******* *** investors **** ***** **** *** ******* ***** ***** *** **** ***** ** ***** (Brealey, ***** **** * ******** * Percentage ***** **** ***** (Brealey, ***** *** percentage **** *** ***** ** ** ******* ** ** ******* ** ** *** following ******* Percentage **** *** ***** * **** * **** *** * ** ******* *** **** *** ***** ** *** *** ***** **** *** *** ****** ** *** * *** * ****** Percentage **** ** ** ******* ****** ******* (Brealey, ***** Continuing **** *** ***** ******* *** ***** **** ** ****** *** percentage **** ** ***** ** ******* *** percentage **** *** ***** ** ***** ** ******* **** * **** **** * *** * ** ******* ******** * Percentage **** ** **** ***** (Brealey, ***** Percentage **** ** ** ******* ****** *** percentage **** ***** ** *** ***** ******** ** *** ******* (Brealey, ***** ******** * *** ***** ******** ***** ***** *** ****** ***** ** *** ****** ******** ****** ** implemented **** *** **** ****** ***** *** **** environment *** ** ******* **** ***** *** ** ******* ****** ** ****** **** *** ** ******* **** ***** *** **** ******* ****** ** ***** ** **** analysis, ***** ** ****** **** percentage **** ******** ***** *** **** *** ** ******* ****** **** *** **** ******* ******* *** ******* **** (Brealey, ***** Reference ******** ** ****** Principles ** Corporate ******* *** **** McGraw-Hill *****

Attachments
Company5.doc
CompanyPart A
Calvin index
* Based on the above excel calculation, the calvin_in*** ***** ** *** *** **** **** *** ***** ***** ** ******** ** ***** *** *****
* ***** *****
*** ***** ** *** ***** ** ***** ** *** ***** ***** ******** (Brealey, *****
* ***** ****** *** investors
*** investors *** *** *** ***** ***** ****** ** **** *** **** ***** ****** investment ****** ***** *** ***** ******* *** **** ***** preference ****** ** **** *** ****** ** ***** ** *** *** ***** ***** *** ***** ****** ***** ***** ***** * ** ***** *** ******** ******* *** investors **** ***** **** *** ******* ***** ***** *** **** ***** ** ***** (Brealey, *****
**** *
******** * Percentage ***** **** ***** (Brealey, *****

Percentage **** ** ** ******* ****** ******* (Brealey, *****
Continuing **** *** ***** ******* *** ***** **** ** ****** *** percentage **** ** ***** ** *******
*** percentage **** *** ***** ** ***** ** ******* **** * **** **** * *** * ** *******
******** *
Percentage **** ** ** ******* ******
*** percentage **** ***** ** *** ***** ******** ** *** ******* (Brealey, *****
******** *
*** ***** ******** ***** ***** *** ****** ***** ** *** ****** ******** ****** ** implemented **** *** **** ****** ***** *** **** environment *** ** ******* **** ***** *** ** ******* ****** ** ****** **** *** ** ******* **** ***** *** **** ******* ****** ** ***** ** **** analysis, ***** ** ****** **** percentage **** ******** ***** *** **** *** ** ******* ****** **** *** **** ******* ******* *** ******* **** (Brealey, *****
Referencemarket.xls
****
* **** ******** * ****
**** * **** **** **** *Price: $10.00

  • We offer what we promise and unlike others our support staffs are online 24/7. We guarantee money back if you do not get value for your Money.
  • The calculator below shall help you compute your pay for this assignment or any other assignment.
  • WE OFFER 6 HRS URGENT ORDERS AS WELL

Use DISCOUNT CODE DISC15 to enjoy 15% Discount on all orders while at the order page.
Do you need any clarifications ?????????
Contact our support staff ONLINE NOW via the CHAT.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: