MGt325 assignment

The writing assignment should include an analysis of an investment or investment class such as the individual stock of a company, stocks in general, bonds, mutual funds, real estate, or alternative investments such as gold. Detailed instructions on the writing assignment should be included as part of the syllabus.Turnitin.com must be utilized for any writing assignments (other than in-class writing or discussion questions in an online course). The use of Turnitin should be administered through the course shell in LearningStudio. For any writing assignment, details on formatting, as well as the use of Turnitin, must be included in the teaching syllabus.Writing Assignment: Project: “Saving for Retirement and Asset Allocation”Instructors must assign at least one project. This assignment should include the use of the following Excel functions (or similar functions for another spreadsheet): FV, PV, PMT, RATE, NPER, NPV, AVERAGE, STDEV, and IRR. Detailed instructions should be included as part of the syllabus.Project Instructions:Write a 5 – 10 page paperonthe following:Assume that you are 30 years old and you plan to accumulate $1 million by your retirement date, which is 30 years from now. Also, assume that you plan to live for 25 years after retirement – that is, until age 85. You plan to make 30 annual deposits of equal amount in your bank to save for retirement. The bank pays 10% interest annually. Assume inflation is 0%. Your paper must address the following questions:a. How much do you plan to deposit annually to accumulate $1 million for your retirement?b. How much will be your retirement payment (benefit) be?c. What factor(s) can you change to reduce your annual deposits while improving your annual retirement benefit?d. How would you allocate your investment among the following primary asset classes, equities (stocks), fixed income (bonds), real estate, gold, and money market (cash)? Please note that your asset allocation should be based whether you are a conservative investor, a moderate investor, or an aggressive investor.e. What objective would you pursuing in your investment? Capital appreciation or capital preservation? Your risk tolerance?f. What investment constraints to consider when making your investment decisions? Liquidity, time horizon (age), regulatory and legal, and tax considerations?Your paper must include, but not limited to, the following:1. Title Page2. Abstract3. Introduction:Discuss what the paper is about. Please include discussion of Time Value of Money.4. Methodology:Discuss what method or technical you plan to use to solve the problem5. Analysis:- Discuss how much you should invest each year to accumulate $1,000,000.- Discuss how much you will earn in your retirement- Discuss variable(s) you could change to reduce your annual deposits while improving your annual retirement benefit?- Discuss the asset allocation of your investment. Please make sure to justify your asset allocation.- Discuss the objective you plan to pursue in your investment. Please justify the selection of your objective.- Discuss any investment constraints that affect your asset allocation6. Conclusion:Based on your analysis, are you happy with your investment decisions? If so, why?7. References: A minimum of 5 references in APA is required.Paper FormatYour paper must be typed, double spaced, using Times New Roman font of size 12 and submitted in Microsoft Word. All external sources must be cited using APA format. Your references must also follow APA format. Your final report must also include a cover page containing the title of the assignment, student’s name, professor’s name, course title, and the assignment date. Please be advised that the cover page, references, and appendixes are not included in the required assignment page length.