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.

Please 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.

a) Discuss the rationale behind holding or selling specific stocks in your portfolio.
b) Analyze the gain/loss calculations for each security.
c) Justify the purchases of one mutual fund and one exchange-traded fund.
d) Incorporate the purchases in your spreadsheet.