Excel > Margin Call Calculations
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel > Margin Call Calculations as PDF for free.
More details
- Words: 125
- Pages: 1
Initial Portfolio Value Your Initial Equity (Margin) Maintenance Margin Requirement Portfolio Value to Trigger Margin Call Your Equity at Time of Margin Call Portfolio % Loss at Time of Margin Call
Margin Call Examples Example 1 Example 2 Example 3 Example 4 Example 5 20,000 50,000 100,000 75,000 12,000 10,000 30,000 50,000 40,000 10,000 25% 30% 30% 35% 30% 13,333.33 28,571.43 71,428.57 53,846.15 2,857.14 3,333.33 8,571.43 21,428.57 18,846.15 857.14 33.33% 42.86% 28.57% 28.21% 76.19%
To figure the portfolio value that will trigger a margin call:
V2 =
IM % −1 ×V1 MM % −1
Where: IM% = Initial Equity as a % of Portfolio Value MM% = Required Minimum Equity % V1 = Initial Value of Portfolio V2 = Portfolio Value To Trigger Margin Call
Margin Call Examples Example 1 Example 2 Example 3 Example 4 Example 5 20,000 50,000 100,000 75,000 12,000 10,000 30,000 50,000 40,000 10,000 25% 30% 30% 35% 30% 13,333.33 28,571.43 71,428.57 53,846.15 2,857.14 3,333.33 8,571.43 21,428.57 18,846.15 857.14 33.33% 42.86% 28.57% 28.21% 76.19%
To figure the portfolio value that will trigger a margin call:
V2 =
IM % −1 ×V1 MM % −1
Where: IM% = Initial Equity as a % of Portfolio Value MM% = Required Minimum Equity % V1 = Initial Value of Portfolio V2 = Portfolio Value To Trigger Margin Call
Related Documents
Excel > Margin Call Calculations
October 2019 16
Excel 2003 Advanced Calculations
May 2020 12
Hydraulic Conversions + Calculations Excel
June 2020 3
Margin
November 2019 35
Calculations
June 2020 17