Communicating Quantitative Information. Excel Homework Social Security, Pensions Stocks and Bonds Life expectancy
Social Security, Pensions
Stocks and Bonds
Homework: Postings. Homework due after Thanksgiving. Find on-line retirement planner. Compute prediction for yourself (or for a parent) or John/Jane doe or someone made up. Make posting on experience (do not show results)
What will I have in the future starting with pv and with the system of payments described by the rest of the parameters.
=fv(rate, nper, pmt, pv, type)
Compare after 4 years: 13,172.36 vs 12000
What is the better thing to do, comparing what you are paying in terms of the value of money today. This assumes a cost of money
Go to Excel Help and read [more] examples.
Estimates are considered conservative: situation could be better, for example, if economy is good with more people earning money and paying taxes.
These estimates are from 2 years ago. Extra Credit to find current estimate.
Congressional Budget office says this will reduce growth of costs
NOTE: all of the above often called equities.
NOTE: many of these did fall in value in financial crisis, due to supply of hedge funds selling. Face value still good.
65 in Wh. male Wh. female B. male B. female
2002 16.6 19.5 14.6 18
NOTE: this data represented is life expectancy at birth: infant mortality is significant factor.
(unofficial source, but appealing presentation)
What is the significance of what parts change and what parts don't?
NO PERSONAL DATA
If you do this option, write about your choices.