Margin (35 points)

For this section, use the excel sheet posted on Canvas. Fill in

all columns for these trades and price changes. Each item

below requires its own row in the spreadsheet.

1. You open an account with $100,000 in it.

2. You buy 20 gold futures at 1500.

3. The price of gold increases to 1510.

4. You buy 1 more gold future at 1510.

5. The price of gold increases to 1530.

6. You sell 30 gold futures at 1530.

7. The price of gold decreases to 1515.

How much money did you make?

Theres a screenshot of what the spreadsheet looks like

Margin Sheet for Canvas (1) - Excel Search lajuan Mosley M - X Comments Formulas Data Review View Help Share = AutoSave CH HUSS File Home Insert Draw Page Layout X Out Calibri 11 Paste Copy Format Painter BIU Clipboard Font A19 . X V B 3/29/2020 = AutoSum 47 AA A Wrap Text Merger Center - 0 0 0 Insert Delete Format Ideas $ 69 * $ -% Number Conditional format as Cell Formatting Table Styles Styles coming and select those Clear oder Sort & Filter Find & Select Alignment Cels dong L M N 0 1 1 GOLD FUTURES CONTRACT=100 OUNCES 2 DATE TRADE POSITION 3 3/25/2020 0 GOLD PRICE (Per Oz.) $ $4950 per Contract INITIAL MARGIN M $4500 per Contract AINTENANCE MARGIN PROFIT/LOSS ACCOUNT BALANCE $ 25,000.00 CASH BALANCE NOTES $ 25,000.00 OPENING ACCOUNT 5 3/26/2020 Buy 3 Long 3 1,500.00 $ 14,850.00 $ 13,500.00 $ - $ 25,000.00 $ 11,500.00 7 3/26/2020 3/27/2020 3/27/2020 3/28/2020 3/28/2020 17 3/29/2020 19 3/29/2020 Sheet1 Enter W BIE 1:10 PM GO 4/10/2020 Margin Sheet for Canvas (1) - Excel Search lajuan Mosley M - X Comments Formulas Data Review View Help Share = AutoSave CH HUSS File Home Insert Draw Page Layout X Out Calibri 11 Paste Copy Format Painter BIU Clipboard Font A19 . X V B 3/29/2020 = AutoSum 47 AA A Wrap Text Merger Center - 0 0 0 Insert Delete Format Ideas $ 69 * $ -% Number Conditional format as Cell Formatting Table Styles Styles coming and select those Clear oder Sort & Filter Find & Select Alignment Cels dong L M N 0 1 1 GOLD FUTURES CONTRACT=100 OUNCES 2 DATE TRADE POSITION 3 3/25/2020 0 GOLD PRICE (Per Oz.) $ $4950 per Contract INITIAL MARGIN M $4500 per Contract AINTENANCE MARGIN PROFIT/LOSS ACCOUNT BALANCE $ 25,000.00 CASH BALANCE NOTES $ 25,000.00 OPENING ACCOUNT 5 3/26/2020 Buy 3 Long 3 1,500.00 $ 14,850.00 $ 13,500.00 $ - $ 25,000.00 $ 11,500.00 7 3/26/2020 3/27/2020 3/27/2020 3/28/2020 3/28/2020 17 3/29/2020 19 3/29/2020 Sheet1 Enter W BIE 1:10 PM GO 4/10/2020