(Solved)Symbol Exchange ATVI AMCX EA US US US Company Name Activision


Question Description:

25

Can someone assist with the attached. Please see excel sheet for details . HW1.xls Symbol Exchange ATVI AMCX EA US US US Company Name Activision Blizzard Inc. AMC Networks Inc. Electronic Arts Inc. QTY Currency Price Paid Last Price Market Value Profit/Loss (local curr) 5000 1000 3000 USD USD USD $31.53 $68.03 $62.98 $31.19 $66.60 $64.43 $155,950.00 $66,600.00 $193,290.00 P/L % ($1,700.00) -1.0783380907 ($1,430.00) -2.1020138174 $4,350.00 2.3023181963 Margin $0.00 $0.00 $0.00 Snapshot Currency Portfolio Value Portfolio Ranking Buying Power Portfolio % Return Available Cash Interest Earned on Cash Balance Credit Interest Charged on Loan Loan Balance Accrued Interest Earned on Bonds Market Value of Long Positions Margin Requirement Market Value of Short Positions Trades Made/Remaining USD $1,001,815.74 25/26 $1,587,791.48 0.18% $585,975.74 $625.74 $0.00 $0.00 $0.00 $0.00 $415,840.00 $0.00 $0.00 3/197 Cash Related Items Market Value Portfolio Summary Cash Balance $585,975.74 Short Sale Proceeds $0.00 Loan Balance $0.00 Interest Earned on Cash $625.74 Interest Charged on Loan $0.00 Total Mark to Market Value for Futures Restricted Funds $0.00 Margin Requirements $0.00 Total Margin for Futures $0.00 Market Value of Long Positions $0.00 $415,840.00 Accrued Interest Earned on Bonds $0.00 Market Value of Short Positions $0.00 Net Market Value of all Positions Portfolio Value Percentage Return Buying Power Trades Made/Allowed $415,840.00 $1,001,815.74 0.18% $1,587,791.48 3/200 SPY ETF % Return 3.46% SPY ETF at start date 193.72 Current SPY ETF 200.43 $1,000,000.00 Beginning Cash Interest Earn Interest Charge Ending Cash $625.74 $0.00 $585,975.74 Read more

Answer

25