Margin Accounting for Stocks: an Excel Classroom Exercise
17 Pages Posted: 20 Apr 2006
Date Written: March 6, 2007
Abstract
This paper illustrates the mechanics of buying stock on margin with the ability to account for buying or selling more of the same stock as the price changes (assuming one uses the same broker). This latter component allows the student to see how the margin set for stock purchases at different prices interact. Further, it is very easy to demonstrate how margin calls become frequent when a stock price plummets. This compliments much of what is now being taught with trading simulation software and student managed funds.
Keywords: Margin, Student-managed Funds, Excel, Pedagogy
JEL Classification: G10
Suggested Citation: Suggested Citation
Arnold, Thomas M., Margin Accounting for Stocks: an Excel Classroom Exercise (March 6, 2007). Available at SSRN: https://ssrn.com/abstract=897272 or http://dx.doi.org/10.2139/ssrn.897272
Feedback
Feedback to SSRN
If you need immediate assistance, call 877-SSRNHelp (877 777 6435) in the United States, or +1 212 448 2500 outside of the United States, 8:30AM to 6:00PM U.S. Eastern, Monday - Friday.