please use spreadsheet and show formulas

Sectie mino 9 10 PLEASE DO NOT INSERT UNES OR COLUMNS AND DO NOT COPY AND PASTE FORMULAS FROM OTHER SPREADSHEETS Use the Blue Area to do your calculations. Fill the light yellow boxes SECTION I-STOCKS (20 POINTS) Don't worry about decimals -all answer boxes were fomated automatically - highy recommended to use the excel formulas Question 1 (10 points You obtain $10,000 margin loan with 5% Interest to buy 200 shares of IBM $110. Six months later you sold all the shares at $125. During the hold period you received a total dividend of $320. What is your $ profit and return of your investment FREE CALCULATION AREA 11 12 13 14 27 28 29 30 Enter Answer OUTPUT - ANSWERS $ Profit HPRX 31 FREE CALCULATION AREA 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Question 2010 points Complete the output below Elven the information given INPUT Trading EBITDA Multiple 10.000% Shares Outstanding 120 million Total Debt 1,100 million Cash 300 million EBITDA 650 million Dividends per share 2.50 per share Risk Free Rate Market Return Beta 1.50% 11.00% 1.75OX 60.00 Analysts Avg Target Prices Enter Answer 51 OUTPUT - ANSWERS Current Trading Stock Price Stock Value Price based on Intrinsic Value Lassume this year's dividend 52 Sectie mino 9 10 PLEASE DO NOT INSERT UNES OR COLUMNS AND DO NOT COPY AND PASTE FORMULAS FROM OTHER SPREADSHEETS Use the Blue Area to do your calculations. Fill the light yellow boxes SECTION I-STOCKS (20 POINTS) Don't worry about decimals -all answer boxes were fomated automatically - highy recommended to use the excel formulas Question 1 (10 points You obtain $10,000 margin loan with 5% Interest to buy 200 shares of IBM $110. Six months later you sold all the shares at $125. During the hold period you received a total dividend of $320. What is your $ profit and return of your investment FREE CALCULATION AREA 11 12 13 14 27 28 29 30 Enter Answer OUTPUT - ANSWERS $ Profit HPRX 31 FREE CALCULATION AREA 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Question 2010 points Complete the output below Elven the information given INPUT Trading EBITDA Multiple 10.000% Shares Outstanding 120 million Total Debt 1,100 million Cash 300 million EBITDA 650 million Dividends per share 2.50 per share Risk Free Rate Market Return Beta 1.50% 11.00% 1.75OX 60.00 Analysts Avg Target Prices Enter Answer 51 OUTPUT - ANSWERS Current Trading Stock Price Stock Value Price based on Intrinsic Value Lassume this year's dividend 52