Q.1 just find only Return on investment?!

Q.2 just find Return on investment and return with no margin?!

E6 fo B D E A 1 2 Short Sales 3 4 Initial Investment 5 Initial Stock Price 6 Number of Shares Sold Short 7 Ending Stock Price 8 Cash Dividends Per Share 9 Initial Equity Percentage 10 Maintenance Margin Percentag 11 12 Return on Short Sale 13 Capital Gain on Stock 14 Dividends Paid 15 Net Income 16 Initial Investment 17 Return on Investment 18 19 Margin Positions 20 Margin Based on Ending Price 21 22 Price for Margin Call 23 24 25 Action or Formula Ending Return on for Column B St Price Investment $500,000.00 $100.00 $170.00 1.40% 10,000 (B4/B9)/B5 160.00 $70.00 Enter data 150.00 $0.00 140.00 50.00% 130.00 30.00% 120.00 110.00 100.00 $300,000.00 B6*(B5-B7) 90.00 50.00 B8 B6 80.00 $300,000.00 B13-B14 70.00 $500,000.00 B4 60.00 60.00% B15/B16 50.00 40.00 30.00 114.29%84+(B5*36)-814-(B6*8711/(16*87) 20.00 10.00 $115.38 (B4-B5-B6)-B14)/(16*(1+B10}) LEGEND: Enter data Value calculated comment Buying on Margin Initial Equity Investment Amount Borrowed Initial Stock Price Shares Purchased Ending Stock Price Cash Dividends During Hold Per. Initial Equity Percentage Maintenance Margin Percentage D Action or Formula Ending Return on Return with for Column B St Price Investment No Margin $500,000.00 $500,000.00 (B4/B10)-B4 $20.00 2.1% 100.1% $100.00 Enter data 35.00 10000 (B4/B10WB6 50.00 $100.00 Enter data 65.00 $5.40 80.00 50.00% 95.00 30.00% 110.00 125.00 8.00% 140.00 6 155.00 170.00 185.00 $0.00 B7 (B8-B6) 200.00 $54,000.00 B7B9 $20,000.00 B5' (B14/12)'B13 ROI with/with $34,000.00 B17+B18-B19 120.00 $500,000.00 B4 300.COM 6.8% B20/B21 Rate on Margin Loan Holding Period in Months Return on Investment Capital Gain on Stock Dividends Interest on Margin Loan Net Income InitialInvestment Return on Investment OOON Margin Call: Margin Based on Ending Price Price When Margin Call Ocours 50.00%|B788)-B5/B7B8) $71.43 B5/B7-1B11B7) 40 20.00 Return on Stock without M 5.4% (B8-B6)+B91/36 520.00 50.00 50.00 95.00 BuyingOnMargin ShortSales +