IN APA FORMAT WITH EXCEL SHEET Financial Management cost of capital
envy313
excel_0.xlsxfv of lifestyle
| present value | 100,000 |
| years | 37 |
| Annual rate | 3% |
| Future value | $298,522.67 |
5 year return on 500 stocks
| top 500 stocks value, 5 years ago | 877.52 |
| top 500 stocks value, now | 1871.89 |
| NPER | 5 |
| RATE | 16% |
PV OF INVESTMENT
| FV OF Account | 3000000 |
| RATE | 16 |
| NPER | 37 |
| PV of investment | ($12,371.69) |
pmt
| FV of Life Style (PMT) | Given Expected Rate of Return (RATE) | Years in Retirement (NPER) | Required Value at Retirement |
| (Find PV of Annuity) | |||
| $44,556.26 | 12.00% | 23 | 694,659.03 |
| ($44,556.26) |
find pmt
| FV of Account (Use PV of Annuity from above) | 5-Year Return on Top 500 Stocks (Rate) | Years to Retirement | Annual Contribution Required to meet goal (Find PMT) |
| (NPER) | |||
| 694,659.03 | 16 | 37 | ($396.54) |
