I need help to solve for Margin Call Price in an EXCEL Spreadsheet. Please show the formula for this problem in EXCEL.

Dee Trader opened a brokerage account and purchased 300 shares of Internet Dreams at $40 per share. She borrowed $4,000 from her broker to help pay for the purchase. The interest rate on the loan is 8%.

If the share price falls to $30 per share by the end of the year, what is the remaining margin in her account? If the maintenance margin is 30%, at what price will she receive a maintenance call?

B D E F G H 1 300 $40.00 66.67% $4,000.00 30.00% 8.00% Margin Call Problems Margin Call Price $19.05 Margin of Safety $20.95 1 2 # of Shares 3 Initial Share Price 4 Initial Margin 5 Loan 6 Maintenance Margin 7 Interest Rate 8 9 Assets: 10 Stock 11 12 Initial Margin 13 14 Price goes down (instant): 15 New Stock Price 16 Liabilities $12,000.00 Loan Equity 66.67% $4,000.00 $8,000.00 1 Year Later Problems Loan $4,000.00 Interest Rate 8% Loan Repayment $4,320.00 New Stock Price $30.00 New stock value $9,000.00 Equity $4,680.00 Return -41.500% Margin 52.000% Margin Call Price $30.00 Liabilities $9,000.00 Loan Equity 55.56% $4,000.00 $5,000.00 17 Assets: 18 Stock 19 20 New Margin 21 22 Return 23 24 Price increases (instantly): 25 26 New Stock Price 27 -37.50% $110.00