FInancial Management
robgar 1 excel spreadsheet
 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.
 Comfortable lifestyle current cost is approximately $100,000/year.
PV of Life Style  Average Rate of Inflation  Years to Retirement  Find FV of Life Style 
$100,000  3.0% 


 Next, you will need to estimate the 5year average rate of return of the stock market (you should use the top 500 stocks, which can be researched at finance Web sites).
 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)  5Year 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?
 $3,000,000
FV of Account  5Year Return on Top 500 Stocks  Years to Retirement  Find PV of Investment 
$ 3,000,000 



 Now, you will need to estimate the life expectancy of the retiree.
 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.
 To determine the annual contribution, use the amount that 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 
 12.0%  23 

FV of Account (Use PV of Annuity from above)  5Year Return on Top 500 Stocks (Rate)  Years to Retirement  Annual Contribution Required to meet goal (Find PMT) 




 7 years ago
 10
 it questions
 Export
 Writing Hw3
 i need someone to help me with a timed test online. i would like to be able to chat with a person and recieve help while i am taking the test. i will pay with a handshake and then copy and paste the questions to the online instant chat. it is statistics.
 200 word disscussion question management week 3
 math HW
 How did Reagan's family experiences embody American cultural conflicts during the 1920s?
 Week 6 managerial economics
 English assignment
 Letters for Martin writer only
****Smartwriter Only**** Financial Mgt.
Word document of 700–1,000 words with attached Excel Spreadsheet showing calculations Details: Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions …
7 years agoFInancial Management
NOT RATED 1 excel spreadsheet
 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.
 Comfortable lifestyle current …
7 years agoWord document of 700–1,000 words with attached Excel Spreadsheet showing calculations
NOT RATEDWeekly 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 …
7 years agoFinancial Management
NOT RATED700 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 …
7 years agofinancial management with excel spreadsheet
NOT RATEDPhase 2 Individual Project Deliverable Length: Word document of 700–1,000 words with attached Excel Spreadsheet showing calculations Details: Weekly tasks or assignments (Individual or Group Projects) …
7 years agofinancial management assignment for The_Writer ONLY
NOT RATEDwith attached Excel Spreadsheet showing calculations
 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 …
7 years ago