Unit 3 Assignment:
Using an Excel spreadsheet, show the calculation of your gain or loss for each security for the week. Make sure you show a dollar return calculation and a percentage return calculation.
Be especially careful on the computation of the gain/loss on the stock you purchased on margin. If you wish, you may sell none, one, or two (but no more) of your holdings.
Replace any stocks you sell on the same terms (long or short).
An accompanying 1-2-page Word document addresses the checklist items below.
Checklist:
Discuss why you took the actions you did in your portfolio, with particular attention to your reasoning behind holding or selling specific stocks.
Make special note of any observations you made when analyzing your calculations.
Also, invest in one mutual fund and one exchange-traded fund this week, again limiting your investment in each to $50,000. Include in your report this week the price of the investments made, including the $25 commission and your justification for the purchases. Incorporate these buys in your spreadsheet.
