Q.1Find Return on investment & return with no margin

Q.2

Q.2Find Return on investment

There are two questions answer them

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 Action or Formula for Column B $500,000.00 $500,000.00 (B4/B10)-B4 $100.00 Enter data 10000 (B4/B10)/B6 $100.00 Enter data $5.40 50.00% 30.00% 8.00% Rate on Margin Loan Holding Period in Months 6 Return on Investment Capital Gain on Stock Dividends Interest on Margin Loan Net Income Initial Investment $0.00 $54,000.00 $20,000.00 $34,000.00 $500,000.00 B7*(B8-B6) B7*B9 B5*(B14/12) *B13 B17+B18-B19 B4 Return on Investment 6.8% B20/B21 Margin Call: Margin Based on Ending Price Price When Margin Call Occurs 50.00% ((B7*B8)-B5)/(B7*B8) $71.43 B5/(B7-(B11*B7)) Return on Stock without Margin 5.4% ((B8-B6) +B9)/B6 B 4 BuyingOnMargin ShortSales + Ready OBI D E F G H rmula nB Ending Return on Return with St Price Investment No Margin B4 $20.00 ta 35.00 B6 50.00 65.00 80.00 95.00 110.00 125.00 140.00 155.00 170.00 185.00 36) 200.00 ROI with/without Margin -) *B13 -B19 120.000 100.00 21 23 Sex A Short Sales Initial Investment Initial Stock Price Number of shares Sold Short Ending Stock Price Cash Dividends Per Share Initial Equity Percentage Maintenance Margin Percentage Action or Formula for Column B $500,000.00 $100.00 10,000 (B4/B9/B5 $70.00 Enter data $0.00 50.00% 30.00% B6*(B5-B7) B8*B6 Return on Short Sale Capital Gain on Stock Dividends Paid Net Income Initial Investment Return on Investment $300,000.00 $0.00 $300,000.00 $500,000.00 60.00% B13-B14 B4 B15/B16 Margin Positions Margin Based on Ending Price 114.29% (B4+(B5*B6)-B14-(B6*B7))/(16*B7) e Price for Margin Call $115.38 (B4+(B5*B6)-B14)/(16*(1+B10)) Buying On Margin ShortSales eady D E H nula B Ending Return on St Price Investment $170.00 160.00 Return o 150.00 120.00% 140.00 100.00% 130.00 80.00% 120.00 60.00% 110.00 100.00 40.00% 90.00 20.00% 80.00 0.00% 70.00 $170.00 60.00 00 097 140.00 130.00 150.00 00 OZI 50.00 Ret 40.00 30.00 B7))/(B6*B7) 20.00 10.00 -6*(1+B1011 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 Action or Formula for Column B $500,000.00 $500,000.00 (B4/B10)-B4 $100.00 Enter data 10000 (B4/B10)/B6 $100.00 Enter data $5.40 50.00% 30.00% 8.00% Rate on Margin Loan Holding Period in Months 6 Return on Investment Capital Gain on Stock Dividends Interest on Margin Loan Net Income Initial Investment $0.00 $54,000.00 $20,000.00 $34,000.00 $500,000.00 B7*(B8-B6) B7*B9 B5*(B14/12) *B13 B17+B18-B19 B4 Return on Investment 6.8% B20/B21 Margin Call: Margin Based on Ending Price Price When Margin Call Occurs 50.00% ((B7*B8)-B5)/(B7*B8) $71.43 B5/(B7-(B11*B7)) Return on Stock without Margin 5.4% ((B8-B6) +B9)/B6 B 4 BuyingOnMargin ShortSales + Ready OBI D E F G H rmula nB Ending Return on Return with St Price Investment No Margin B4 $20.00 ta 35.00 B6 50.00 65.00 80.00 95.00 110.00 125.00 140.00 155.00 170.00 185.00 36) 200.00 ROI with/without Margin -) *B13 -B19 120.000 100.00 21 23 Sex A Short Sales Initial Investment Initial Stock Price Number of shares Sold Short Ending Stock Price Cash Dividends Per Share Initial Equity Percentage Maintenance Margin Percentage Action or Formula for Column B $500,000.00 $100.00 10,000 (B4/B9/B5 $70.00 Enter data $0.00 50.00% 30.00% B6*(B5-B7) B8*B6 Return on Short Sale Capital Gain on Stock Dividends Paid Net Income Initial Investment Return on Investment $300,000.00 $0.00 $300,000.00 $500,000.00 60.00% B13-B14 B4 B15/B16 Margin Positions Margin Based on Ending Price 114.29% (B4+(B5*B6)-B14-(B6*B7))/(16*B7) e Price for Margin Call $115.38 (B4+(B5*B6)-B14)/(16*(1+B10)) Buying On Margin ShortSales eady D E H nula B Ending Return on St Price Investment $170.00 160.00 Return o 150.00 120.00% 140.00 100.00% 130.00 80.00% 120.00 60.00% 110.00 100.00 40.00% 90.00 20.00% 80.00 0.00% 70.00 $170.00 60.00 00 097 140.00 130.00 150.00 00 OZI 50.00 Ret 40.00 30.00 B7))/(B6*B7) 20.00 10.00 -6*(1+B1011