Question

In: Finance

Professor, In trying to apply my knowledge in the real world, I am trying to create...

Professor,

In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this.

I am trying to do the following: plan a retirement schedule between the ages of 22 and 68, in which I would deposit 25% of my income each year. The income starts at 80,000 with an annual growth rate of 5% and, to be realistic, assuming an interest rate of 2.5%. I will assume for simplicity that I receive my first salary ($80,000) when I turn 22, and my last salary when I turn 68. As soon as I receive a salary, I will save 25% of it.

I would like to know (1) how much I will have in my retirement account when I turn 68, immediately after the last deposit, and (2) what single deposit made on my 22nd birthday would give the same account balance when I turn 68.

However, this raises issues, as if I try to use the equation for the present value of a growing annuity with a 5% growth rate and 2.5% discount rate, r-g will yield a negative number. Also, I could not find online how to do this on my HP 10bII+ financial calculator and I don't want to manually enter 47 payments.

Do you know how I could overcome this obstacle?

All the best,

Jimmy

Unfortunately, I forgot to reply Jimmy’s email and I would like to get back to him as soon as possible. I want to answer Jimmy’s questions using the formulas we learned in class (not the calculator or Excel). Can you help me draft a response? You may use the calculator or Excel for calculations, but I want to send Jimmy the formula solution.

Solutions

Expert Solution

Age Salary (increasing at 5% YoY) Amount Invested (Salary * 25%) Future Value on 68th birthday
22                                         80,000                                               20,000                                            62,277
23                                         84,000                                               21,000                                            63,796
24                                         88,200                                               22,050                                            65,352
25                                         92,610                                               23,153                                            66,946
26                                         97,241                                               24,310                                            68,579
27                                       102,103                                               25,526                                            70,251
28                                       107,208                                               26,802                                            71,965
29                                       112,568                                               28,142                                            73,720
30                                       118,196                                               29,549                                            75,518
31                                       124,106                                               31,027                                            77,360
32                                       130,312                                               32,578                                            79,247
33                                       136,827                                               34,207                                            81,180
34                                       143,669                                               35,917                                            83,160
35                                       150,852                                               37,713                                            85,188
36                                       158,395                                               39,599                                            87,266
37                                       166,314                                               41,579                                            89,394
38                                       174,630                                               43,657                                            91,575
39                                       183,361                                               45,840                                            93,808
40                                       192,530                                               48,132                                            96,096
41                                       202,156                                               50,539                                            98,440
42                                       212,264                                               53,066                                          100,841
43                                       222,877                                               55,719                                          103,300
44                                       234,021                                               58,505                                          105,820
45                                       245,722                                               61,430                                          108,401
46                                       258,008                                               64,502                                          111,045
47                                       270,908                                               67,727                                          113,753
48                                       284,454                                               71,113                                          116,528
49                                       298,677                                               74,669                                          119,370
50                                       313,610                                               78,403                                          122,281
51                                       329,291                                               82,323                                          125,264
52                                       345,755                                               86,439                                          128,319
53                                       363,043                                               90,761                                          131,449
54                                       381,195                                               95,299                                          134,655
55                                       400,255                                             100,064                                          137,939
56                                       420,268                                             105,067                                          141,303
57                                       441,281                                             110,320                                          144,750
58                                       463,345                                             115,836                                          148,280
59                                       486,513                                             121,628                                          151,897
60                                       510,838                                             127,710                                          155,602
61                                       536,380                                             134,095                                          159,397
62                                       563,199                                             140,800                                          163,285
63                                       591,359                                             147,840                                          167,267
64                                       620,927

Related Solutions

Professor, In trying to apply my knowledge in the real world, I am trying to create...
Professor, In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this. I am trying to do the following: plan a retirement schedule between the ages of 22 and 68, in which I would deposit 25% of my income each year. The income starts at 80,000 with an annual growth rate...
In trying to apply my knowledge in the real world, I am trying to create a...
In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this. I am trying to do the following: plan a retirement schedule between the ages of 25 and 70, in which I would deposit 20% of my income each year. The income starts at 80,000 with an annual growth rate of...
I am working on a project for my Computer Science course. I am trying to create...
I am working on a project for my Computer Science course. I am trying to create a Battleship game where a user names two coordinates on a grid and is then told whether this results in a "Hit" or a "Miss". Once the ship has been hit a certain number of times (based on the size of the ship) the ship is sunk. I have written all the code but it now fails to execute when I try to run...
I am trying to create my own doubly linkedlist class and here is what I have...
I am trying to create my own doubly linkedlist class and here is what I have so far. my addfirst is adding elements forever and ever, and I could use some help. This is in C++. Please help me complete my doubly linkedlist class. the addfirst method is what I would like to complete. #ifndef DLLIST_H #define DLLIST_H #include "node.h" #include using namespace std; template class DLList { private:     Node* head = nullptr;     Node* tail = nullptr;    ...
1. I am trying to determine the level of measurement of my data type? I am...
1. I am trying to determine the level of measurement of my data type? I am looking for advice on Nominal, Ordinal, Interval, and Ratio 2. Does the data set have any categorical variables? I am trying to Describe the data set below in very general terms? This data consist of 8 variables: Which are GRE Scores, TOEFL Scores, University Rating, Statement of Purpose, Letter of Recommendation Strength, Undergraduate GPA, . Research Experience, and Chance of Admit. Name Type Description...
I am trying to start saving for retirement. I am investing all my cash into the...
I am trying to start saving for retirement. I am investing all my cash into the S&P 500, which will assume consistently 9.8% interest, compounded annually. I initially put a lump sum of $100 into my account, and I will deposit $10 every second week. a) After 10 years, how much money will I have invested? b) After 10 years, if I sold all of my stocks, how much money will I have in my account? c) After 25 years,...
Hi I am having the following problem. At the moment I am trying to create a...
Hi I am having the following problem. At the moment I am trying to create a bode plot for the following function. G(s)=(Ks+3)/((s+2)(s+3)) Note: Not K(s+2)! I then want to plot multiple bode plots for various values of K. Eg. 1,2,3, etc. I am having two separate issues. 1. How do I define the TF with a constant K in the location required (a multiple of s in the numerator) 2. How do I create multiple bode plots for values...
I am trying to create a classified balance sheet and I am unsure what is involved...
I am trying to create a classified balance sheet and I am unsure what is involved when reporting the current assets, liabilities and owners equity?
This is my code for python. I am trying to do the fourth command in the...
This is my code for python. I am trying to do the fourth command in the menu which is to add an employee to directory with a new phone number. but I keep getting error saying , "TypeError: unsupported operand type(s) for +: 'dict' and 'dict". Below is my code. What am I doing wrong? from Lab_6.Employee import * def file_to_directory(File): myDirectory={}       with open(File,'r') as f: data=f.read().split('\n')    x=(len(data)) myDirectory = {} for line in range(0,199):      ...
this is my code in python I am trying to open a file and then print...
this is my code in python I am trying to open a file and then print the contents on my console but when i run it nothing prints in the console def file_to_dictionary(rosterFile): myDictionary={}    with open(rosterFile,'r') as f: for line in f: myDictionary.append(line.strip()) print(myDictionary)             return myDictionary    file_to_dictionary((f"../data/Roster.txt"))      
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT