Create a table to show Alice's Margin data that shows a summarize the following into a five-column table containing The

[answerhappygod]

Create a table to show Alice's Margin data that shows a
summarize the following into a five-column table containing
The table should also contain grand totals summarized of each
column.
Alice account table is :

Create A Table To Show Alice S Margin Data That Shows A Summarize The Following Into A Five Column Table Containing The 1 (118.9 KiB) Viewed 56 times

Create A Table To Show Alice S Margin Data That Shows A Summarize The Following Into A Five Column Table Containing The 2 (159.8 KiB) Viewed 56 times

Create A Table To Show Alice S Margin Data That Shows A Summarize The Following Into A Five Column Table Containing The 3 (85.08 KiB) Viewed 56 times

My question is: what the table should look like and what kind of
data should use and calculate?Please show the specific data in the
above data set.
the professor's hint is "what you need to calculate is the
margin of the differences between the three column (Equity with
Loan Value – total dollar value/ Initial Margin – total dollar
value/ Excess Liquidity – total dollar value) and the grand total
"
And the professor thinks table should look like:
I'm wondering whether the Margin column is not shown in the
final table. How to calculate and what kinds of data should be put
in what kind of location in the above table the professor
recommends.
Account Portfolio Financial Instrument Description Position Currency Market Value Market Price Average Price Unrealized P&L Realized P&L Liquidate Last Stock1 100 USD 192,580 19.258 21.003 -17,442 0 No Stock2 6,000 USD 1,254,000 209.00 210.777 -10,657 0 No Stock3 86,000 USD 2,875,840 33.44 41.349 -680,122 0 No Stock4 2,500 USD 1,765,490 706.196 484.571 554,063 0 No Stock5 3,200 USD 3,868,276 1208.836 1020.507 602,656 0 No Stock6 95,000 CAD 3,837,570 40.395 23.352 1,619,136 0 No Stock8 0 USD 0 1.252 0.00 0 No 0 USD 0.473 0.00 0 No Stock9 Stock10 8,000 USD 72.48 69.916 20,512 0 No Stock11 21,200 USD 0 579,840 1,535,516 1,173,000 1,923,600 72.43 66.173 132,661 0 No Stock12 60,000 USD 19.55 25.579 -361,695 0 No Stock13 10,500 USD 183.20 237.775 -573,035 0 No Stock15 250 USD 26,006 1.04 8.155 -177.862 0 No Stock17 USD 1.921 -97,229 0 No 100 25,000 3,000 19,214 2,347,853 11.645 85.367 Stock20 USD 93.914 0 No USD 0.475 1.364 0 No Stock21 Stock24 16,000 USD 120.99 116.272 0 142,540 1,935,840 1,988,700 5,704,825 2 2 2 2 2 2 2 2 Stock23 700 USD 2841.00 213,679 -266,427 75,489 444,068 280,695 234,431 -100,990 2206.617 0 No Stock203 17,500 USD 325.99 309.951 0 30,000 USD 61.49 53.676 0 Stock266 Stock2032 1,844,700 1,535,280 24,000 USD 63.97 68.178 0
Account Balance Parameter Total Securities Net Liquidation Value 52,871,054 USD 52,871,054 USD Net Liquidation Uncertainty 0 USD n/a Equity with Loan Value 52,321,711 USD 52,321,711 USD Securities Gross Position Value 52,851,246 USD 52,851,246 USD Cash 25,473 USD 25,473 USD MTD Interest 0 USD 0 USD Pending Debit Card Charges 0 USD 0 USD Account Margin Parameter Total Securities Current Initial Margin 17,104,372 USD 17,104,372 USD Post-Expiry Margin @ Open (predicted) 0 USD 0 USD Current Maintenance Margin 17,081,076 USD 17,081,076 USD Projected Look Ahead Initial Margin 17,104,372 USD 17,104,372 USD Projected Look Ahead Maintenance Margin 17,081,076 USD 17,081,076 USD Projected Overnight Initial Margin 17,104,372 USD 17,104,372 USD Projected Overnight Maintenance Margin 17,081,076 USD 17,081,076 USD
Available for Trading Parameter Total Securities Current Available Funds 35,217,340 USD 35217,340 USD Current Excess Liquidity 35,240,636 USD 35,240,636 USD Post-Expiry Excess (predicted) O USD 0 USD Look Ahead Available Funds 35,217,340 USD 35,217,340 USD Look Ahead Excess Liquidity 35,240,636 USD 35,240,636 USD Overnight Available Funds 35,217,340 USD 35,217,340 USD Overnight Excess Liquidity 35,240,636 USD 35,240,636 USD Buying Power 117,391,132 USD n/a Leverage n/a 1.00 Look Ahead Next Change @ 09:30:00 n/a / Market Value Currency Total Cash MTD Interest Stock Options Futures FOPs Dividends Receivable Net Liquidation Value Unrealized P&L Realized P&L CAD 11,272 0 3,837,570 0 0 0 0 17,100 3,865,943 1,619,136 0 USD 16,730 0 49,306,500 549,343 16,320 0 0 49,872,572 826,485 0 Total (in USD) 25,473 0 52,282,976 549,343 16,320 0 0 13.263 52,871,054 2,082,311 0 Account FX Portfolio Financial Instrument Description Position Market Value Market Price Average Price Unrealized P&L Realized P&L Liquidate Last USD.CAD -1,212,005 -1,562,638 1.28930 1.26907 -24,518 0 No