In: Finance
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.
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 SolutionsProfessor, 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
Latest Questions
ADVERTISEMENT
|