H
Husky
I am looking for an excel spreadsheet that would help me caclualte the margin
call amount in an account. For example, if a client invests $10,000 and the
assets have a loan value of 50%, he has a margin of $5,000. Now if he invests
this $5,000.00 into assets that have a loan value of 25%, he has an
additional margin of $1,250.00. And if he invests this available margin of
$1,250 into assets that have a loan value of 50%, he has addition 625 margin
available and so an. So I was wondering a spreadsheet would be available to
help me caclulate how much margin would be available if the excess margin is
also invested.
Thank you,
call amount in an account. For example, if a client invests $10,000 and the
assets have a loan value of 50%, he has a margin of $5,000. Now if he invests
this $5,000.00 into assets that have a loan value of 25%, he has an
additional margin of $1,250.00. And if he invests this available margin of
$1,250 into assets that have a loan value of 50%, he has addition 625 margin
available and so an. So I was wondering a spreadsheet would be available to
help me caclulate how much margin would be available if the excess margin is
also invested.
Thank you,