Question: I need help with the excel spreadsheet and the word document. I have attached the rubric for the assignment. Unit 3 [MT483: Investments] Unit 3

I need help with the excel spreadsheet and the word document. I have attached the rubric for the assignment.

I need help with the excel spreadsheet and the word document. I

Unit 3 [MT483: Investments] Unit 3 Assignment: Analyzing Your Calculations For all Assignments in this course, there will be an Assignment Discussion Board for you to participate in before you start working on your Assignment. The Assignment Discussion will be graded as part of the Assignment and is required. Unit 3: Assignment Discussion Participate in the Assignment Discussion Board with your classmates before you start your paper, sharing your findings and discussing theirs. You can share your thoughts and plans for the Assignment and the choice you plan to make. Through this exchange you can fine tune your research and benefit from the insights of others. Go to the Assignment Discussion Board on the left navigation area. The Assignment Discussion will be graded as part of the Assignment and is required. Assignment Instructions Using an Excel spreadsheet show your 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). In an accompanying 1- to 2page Word document, please discuss why you took the actions you did in your Portfolio, with special attention to your reasoning behind holding or selling specific stocks. Make special note of any observations you made when analyzing your calculations. In addition, 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. Submit the annotated spreadsheet and Word document to your instructor by the end of Unit 3. Directions for Submitting Your Assignment Before you submit your Assignment, you should save your work on your computer in a location and with a name that you will remember. Make sure your Assignment is in the appropriate format (Word, Excel, PowerPoint, or other), then, when you are ready, you may submit to the Unit 3 Assignment Dropbox. Unit 3 [MT483: Investments] MT483 - Unit 3 Assignment: Analyzing Your Calculations Points Possible Assignment Discussion Participate in the Assignment Discussion Board with your classmates before you complete your paper, sharing your findings and discussing theirs. Minimum of 2 posts. 5 Content On an Excel spreadsheet and show your calculation of your gain or loss for each security for the week. Replace any stocks you sell on the same terms (long or short). Buy a mutual fund and an exchange traded fund using the given criteria. 11 Analysis show a dollar return calculation and a percentage return calculation the computation of the gain/loss on the stock you purchased on margin discuss why you took the actions you did in your Portfolio, with special attention to your reasoning behind holding or selling specific stocks and buying the funds 9 Writing Skill Sentences are clear, concise, and direct; tone is appropriate Grammar, Spelling, and APA format. 5 Total Points Earned 30 Points Earned

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!