Assume that you can buy U.S. Coal for $20 per share, either paying cash or buying on margin. The initial margin requirement is 50 percent, and the maintenance margin is 30 percent. U.S. Coal pays $0.25 per share in annual dividends. The margin interest cost is 6 percent. Using the spreadsheet format illustrated, calculate the $ gain or loss on both a cash basis and on a margin basis for 100 shares assuming possible ending prices for the stock as illustrated. The projected holding period is six months. Also calculate the percentage gain or loss on the initial investment for both a cash basis and a margin basis. Note that the holding period is expressed as part of a year

Please calculate for 100 and 500 shares thanks

b. If you buy 500 shares instead of 100 shares, with all other parameters the same, would the percentage return on investment change? \begin{tabular}{|l|r|c|c|c|c|} \hline & & Ending Price \$ Gain (L) Cash \% Ret. On Inv \$ Gain (L) Margin \% Ret. on Inv \\ \hline Purchase price & 20 & 5 & & \\ \hline Number of shares purchased & 100 & 10 & & \\ \hline Annual dividend & & 15 & & \\ \hline Total investment if purchased for cash & & 20 & & \\ \hline Initial margin requirement (decimal) & 0.5 & 25 & & \\ \hline Mainten. margin requirement (decimal) & 0.3 & 30 & & \\ \hline Annual margin interest rate & & 35 & & \\ \hline Initial investment if bought on margin & & 40 & & \\ \hline Amount borrowed if bought on margin & & 45 & & \\ \hline Holding period as \% of a year & & 50 & & \\ \hline Holding period ann. margin int. rate & & & & \\ \hline \end{tabular}