# Project #32447 - business ip2

FINC390-1402B-01 Introduction to Corporate Finance
Task Name: Phase 2 Individual Project
Deliverable Length: Word document of 500–800 words with attached Excel spreadsheet showing calculations
Details:

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

Now that you have demonstrated a reasonable understanding of the time value of money concept, you will now have an opportunity to apply this knowledge to an extension of the previous tasks. In the Phase 1 IP, you calculated the estimated future costs of 3 lifestyles based on 3% inflation and the number of years until you reach age 67. In this task, you will complete the retirement plan that you started in the previous phase using the annuity concepts presented in this phase.

• First, you will need to estimate the life expectancy of the retiree.
• You 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 table 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%).
• Basic: Current cost = \$45,000
• Comfortable: Current cost = \$90,000
• Luxury: Current cost = \$150,000
• Now, using the second table, you can calculate the annual contribution that needs to be made to have each required amount at retirement.
• To determine the annual contribution, use the amount you calculated above as the future value, the market rate of return from Phase 1 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 12.0% 23 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.

Note: You can find information about the top 500 stocks at this Web site.

Reference

S&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.

Points Possible: 150
Date Due: Monday, Jun 02, 2014
Objective:
• Demonstrate an understanding of the time value of money
• Demonstrate the ability to perform interest rate calculations for single and multiple time period cash flows.
• Demonstrate the ability to calculate the future value and present value of annuities.

 Subject Business Due By (Pacific Time) 06/06/2014 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews