Business Finance - Accounting TVM Assignment
Abhiptl
Summarysheet1.docx
Time Value of Money Calculations Summary Sheet
|
Name |
|
|||
|
Your Current Age |
|
|
Sex/Gender (Male, Female, Other) |
|
|
Your Desired Age of Retirement |
|
|
Life Expectancy |
90 |
|
Annual Retirement Income Desired (in Today’s Dollars) |
|
|
Number of Years Until Retirement |
|
|
|
|
|
Length of Retirement (in Years) |
|
ASSUMPTIONS:
Zero current savings, no tax implications, 1% Management Fee Use BALANCED GROWTH % allocations mandate from Investor Profile to calculate NRR and RRR
|
Asset Allocation (%) |
|
Nominal Rate of Return After Fees (%) |
|
||||
|
Canadian Equities |
U.S. Equities |
Foreign Developed Equities |
Emerging Market Equities |
Fixed Income Securities |
|
Real Rate of Return After Fees (%) |
|
|
|
|
|
|
|
|
Inflation Rate (%) |
|
ANSWER PAGE
NRR= RRR=
Calculate future value of the income requirement given the expected inflation rate?
|
MODE |
P/Y |
C/Y |
N |
I/Y |
PV |
PMT |
FV |
|
|
|
|
|
|
|
|
|
Calculate (PV) savings required on first day of retirement to fund annual retirement income with monthly interest compounding of the Real rate of return.?
|
MODE |
P/Y |
C/Y |
N |
I/Y |
PMT |
FV |
PV |
|
|
|
|
|
|
|
|
|
Calculate monthly savings required to fund retirement goal where compounding is monthly if the nominal rate of return?
|
MODE |
P/Y |
C/Y |
N |
I/Y |
PV |
FV |
PMT |
|
|
|
|
|
|
|
|
|
I will need to save per month to reach my retirement goal.
