Word document of 700–1,000 words with attached Excel Spreadsheet showing calculations.Your next assignment as a financial management intern is to apply the knowledge that you acquired while engaging in the time value of money discussion that you had with your colleagues. In this task, you will be building the foundation for a retirement plan using the concepts presented in this phase.· First, you will need to estimate the future cost of 3 lifestyles assuming an inflation rate of 3% and the number of years before you turn 67 years old. o Comfortable lifestyle current cost is approximately $100,000/year. PV of Life Style (Given)Average Rate of Inflation (RATE)Years to Retirement (NPER)Find FV of Life Style$100,000 3.0% · Next, you will need to estimate the 5-year average rate of return of the stock market (you should use the top 500 stocks, which can be researched at finance Web sites). o At this rate of return, how long would it take for an investment to double? Top 500 Stocks Value 5 yrs. ago (PV)Top 500 Stocks Value Now (FV) Number of Periods (NPER)5-Year Return on Top 500 Stocks (RATE) 5 · If an individual needed the following amounts to retire, how much would he or she have to invest today at the rate of return that you calculated in the previous step, assuming he or she will turn 67 in the same year you do? o $3,000,000 FV of Account (Given)5-Year Return on Top 500 Stocks (RATE)Years to Retirement (NPER)Find PV of Investment$ 3,000,000 · Now, you will need to estimate the life expectancy of the retiree. o Use 90 years of age as an estimate. · Now, you can subtract the life expectancy of the retiree from 67 (the retirement age) and use the first of the 2 tables below to calculate the required amount at retirement to support the following lifestyles adjusted for inflation (hint: the inflation adjusted amounts will be the payment as you will be calculating the present value of this annuity using a rate of return of 12%)· Now, using the second table, you can calculate the annual contribution that needs to be made to have each required amount at retirement. o To determine the annual contribution, use the amount that you calculated above as the future value, the market rate of return from section 2 as interest rate, and number of periods as 67 minus your current age. FV of Life Style (PMT)Given Expected Rate of Return (RATE)Years in Retirement (NPER)Required Value at Retirement (Find PV of Annuity) 12.0%23 FV of Account (Use PV of Annuity from above)5-Year Return on Top 500 Stocks (Rate)Years to Retirement (NPER)Annual Contribution Required to meet goal (Find PMT) · After completing the required calculations, explain your results in a Word Document and attach the spreadsheet showing your work. Be sure to explain the following: o The difference between present and future valueso How the present value and future value calculations are calculated and relatedo The difference between compounding and discounting Note: You can find information about the top 500 stocks at this Web site.ReferenceS&P 500 index chart. (2014). Retrieved from the Yahoo! Finance Web site: http://finance.yahoo.com/echarts?s=%5egspc+interactive#symbol=^gspc;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=;Be sure to document your paper with in-text citations, credible sources, and list of references used in proper APA format.
by admin | Sep 23, 2022 | Business & Finance | 0 comments
Word document of 700–1,000 words with attached Excel Spreadsheet showing calculations.Your next assignment as a…
A professional Academic Service Provider
Distinguished Writers Ensure Accountability, Confidentiality, High-Quality, and Timely Execution
Distinguished Writers comprises of well-trained professionals striving to give our clients an awesome experience. We engage with our customers throughout the learning process to ensure they are comfortable with both their classwork and homework in order to achieve excellent grades. The team is well-balanced across different fields to suit our clients. Our diversified fields include article writing, thesis proposals, project management, coursework, essay writing, and dissertations among others.Fundamental Values
1. Accountability: The company values professionalism in all our undertakings. As such, we interact transparently with our customers.
2. Confidentiality: The company does not disclose anything to third-parties, and our interactions with customers remain confidential.
3. High-Quality The products are thoroughly proofread and counter-checked to ensure they meet the expected quality levels.
Guarantees
4. Quality is a Guarantee: Our writers are accurately matched with their area of expertise to ensure proper quality is maintained. We are also equipped with adequate software to guarantee error-free products.
5. Money Back Policy: As a client-oriented service, we offer 100% refund for the following: if we received a double payment from you; if you placed similar orders twice (or more) and paid for all of them; the writer has not been assigned; you asked to cancel the order within 20 minutes after placing it; an e-Check payment has been sent (the Dispute Manager will contact you accordingly). Other cases involve a comprehensive investigation by the Dispute Department and feedback given within 24 hours. We value our customers; therefore, the process will be fair, fast, and precise.
5 .Free Revisions: You can request for revisions at no additional cost. Nonetheless, this does not include complete change of the initial order instructions and if it is not past ten days upon your approval.
6. 24/7 Customer Support: Our support staff are always online to provide any assistance when needed
Ordering Process
NOTE: If you have any question, always contact our support team before the commencement of your project. ALL THE BEST”:
Recent Comments