Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 EarnedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started