Chapter_3_Short_Sale

Chapter_3_Short_Sale - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Short Sales Action or Formula Ending Return on for Column B St Price Investment Initial Investment $50,000.00 Enter data 60.00% Initial Stock Price $100.00 Enter data $170.00 -140.00% Number of Shares Sold Short 1,000 (B4/B9)/B5 160.00 -120.00% Ending Stock Price $70.00 Enter data 150.00 -100.00% Cash Dividends Per Share $0.00 Enter data 140.00 -80.00% Initial Margin Percentage 50.00% Enter data 130.00 -60.00% Maintenance Margin Percentage 30.00% Enter data 120.00 -40.00% 110.00 -20.00% Return on Short Sale 100.00 0.00% Capital Gain on Stock $30,000.00 B6*(B5-B7) 90.00 20.00% Dividends Paid $0.00 B8*B6 80.00 40.00% Net Income $30,000.00 B13-B14 70.00 60.00% Initial Investment $50,000.00 B4 60.00 80.00% Return on Investment 60.00% B15/B16 50.00 100.00% 40.00 120.00% Margin Positions 30.00 140.00% Margin Based on Ending Price 114.29% (B4+(B5*B6)-B14-(B6*B7))/(B6*B7) 20.00 160.00% 10.00 180.00% Price for Margin Call $115.38 (B4+(B5*B6)-B14)/(B6*(1+B10)) LEGEND: Enter data Value calculated
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/19/2011 for the course FIN 3300 taught by Professor Sherbo during the Spring '11 term at Denver.

Page1 / 2

Chapter_3_Short_Sale - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online