Question

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 22^nd 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.

Answer 1

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	jeff jeffy Next > < Previous 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 Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions 4) Cost per equivalent unit of direct materials and conversion (4 marks) The cost per equivalent... We usually write numbers in decimal form (or base 10), meaning numbers are composed using 10... Consider a saturated solution of the salt MX3, which M is a metal cation with a... Energyshot is a new energy drink that is about to be introduced into the global market.... Problem 1: During the month, EKM Enterprise purchased $100,000 in raw material on account, used $150,000... An electron is accelerated inside a parallel plate capacitor. The electron leaves the negative plate with... There is a region with a constant magnetic field 6.31T . The magnetic field is directed... ADVERTISEMENT About @ 2020 WizEdu