Option #1: Capital Gain and Loss Calculation Murphy Smith has the following stock transactions for 2017. Name Date Purchased Basis Date Sold Sales Proceeds Apex Corp. 1/23/1986 7,250 7/22/2017 4,500 Blue Corp. 4/20/2017 14,000 9/13/2017 17,500 Coral Corp. 8/23/2010 10,750 10/12/2017 15,300 Diamond Corp 5/19/2017 5,230 10/12/2017 12,400 Electric Corp. 8/20/2017 7,300 11/14/2017 3,500 Based on the information in above table, answer the following questions: (a) What is Murphys net short-term capital gain or loss from these transactions? (b) What is Murphys net long-term capital gain or loss from these transactions? (c) What is Murphys net gain or loss from these transactions? (d) Based on (a) through (c), complete Murphys Schedule D. Requirements Clearly identify the requirements being addressed. Show all calculations within the cells of an MS Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well; no hard coding of solutions. Submit a single MS Excel file for grading. Review the grading rubric, which can be accessed in the Module 6 Materials folder, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

Name	Date Purchased	Basis	Date Sold	Sales Proceeds
Apex Corp.	1/23/1986	7,250	7/22/2017	4,500
Blue Corp.	4/20/2017	14,000	9/13/2017	17,500
Coral Corp.	8/23/2010	10,750	10/12/2017	15,300
Diamond Corp	5/19/2017	5,230	10/12/2017	12,400
Electric Corp.	8/20/2017	7,300	11/14/2017	3,500