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

1. Equity with Loan Value total dollar value
2. Initial Margin total dollar value
3. Excess Liquidity total dollar value
4. Margin calculation:(Initial Margin/ Equity with Loan Value)

The table should also contain grand totals summarized of each column.

Alice account table is :

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:

Account	name	Equity with Loan Value total dollar value	/ Initial Margin total dollar value	Excess Liquidity total dollar value) and the grand total
account1	Alice
Total

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 Stock2 100 USD 192,580 19.258 21.003 -17,442 0 No 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 Stock9 0 USD 0 0.473 0.00 0 No Stock10 8,000 USD 579,840 72.48 69.916 20,512 0 No Stock11 21,200 USD 1,535,516 72.43 66.173 132,661 0 No Stock 12 60,000 USD 1,173,000 19.55 25.579 -361,695 0 No Stock13 10,500 USD 1,923,600 183.20 237.775 -573,035 0 No Stock15 250 USD 26,006 1.04 8.155 -177,862 0 No Stock17 100 USD 19,214 1.921 11.645 -97,229 0 No Stock20 25,000 USD 2,347,853 93.914 85.367 213,679 0 No Stock21 3,000 USD 142,540 0.475 1.364 -266,427 0 No Stock24 16,000 USD 1,935,840 120.99 116.272 75,489 0 No Stock23 700 USD 1,988,700 2841.00 2206.617 444,068 0 No Stock203 17,500 USD 5,704,825 325.99 309.951 280,695 0 No Stock266 30,000 USD 1,844,700 61.49 53.676 234,431 0 No Stock2032 24,000 USD 1,535,280 63.97 68.178 -100,990 0 No