Question

In: Finance

Given the below pension assumptions (same as the previous question), answer the following question. Starting salary...

Given the below pension assumptions (same as the previous question), answer the following question.

Starting salary 77,000
Annual salary increase 2.00%
Years of employment 30
Vesting rate 1.75%
Return on investments 6.00%
Years of retirement 20

What is your anticipated retirement benefit each year?

Solutions

Expert Solution

Following is the given data:

Given data
Starting salary 77,000
Annual salary increase 2.00%
Years of employment 30
Vesting rate 1.75%
Return on investments 6.00%
Years of retirement 20

Now, we calculate the Retirement sum by first calculating the value of each year's contribution in Year 30 and then summing up all the investments, to find the total sum on retirement, in the following manner,

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Annual salary 77,000        78,540        80,111        81,713        83,347        85,014        86,715        88,449        90,218        92,022        93,863        95,740        97,655        99,608        1,01,600        1,03,632        1,05,704        1,07,819        1,09,975        1,12,174        1,14,418        1,16,706        1,19,040        1,21,421        1,23,850        1,26,327        1,28,853        1,31,430        1,34,059        1,36,740
Amount vested            1,348          1,374          1,402          1,430          1,459          1,488          1,518          1,548          1,579          1,610          1,643          1,675          1,709          1,743             1,778             1,814             1,850             1,887             1,925             1,963             2,002             2,042             2,083             2,125             2,167             2,211             2,255             2,300             2,346             2,393
Value at retirement            7,301          7,026          6,761          6,506          6,260          6,024          5,796          5,578          5,367          5,165          4,970          4,782          4,602          4,428             4,261             4,100             3,946             3,797             3,653             3,516             3,383             3,255             3,132             3,014             2,900             2,791             2,686             2,584             2,487             2,393
Total sum on retirement       1,32,464

Lastly, we calculate the annuity payment for 20 years of retirement, in the following manner:

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Yearly annuity payment          11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549        11,549           11,549           11,549           11,549           11,549           11,549           11,549

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

The table below shows the GPA and starting salary for 14 statistical analysts. GPA Starting Salary...
The table below shows the GPA and starting salary for 14 statistical analysts. GPA Starting Salary 2.07 47979 3.56 48758 3.17 48832 3.43 47592 1.12 45628 3.64 48971 1.96 46018 1.33 45164 2.62 46439 1.75 45446 3.86 50815 1.7 47075 3.48 48788 1.8 45747 a. Identify the scatter plot for the data. Select your answer from one of the following options. a.Graph A b.Graph B c.Graph C b. Use the Google Sheets command =CORREL to find the correlation coefficient r....
Consider the linear program given below (almost the same as the previous problem - the only...
Consider the linear program given below (almost the same as the previous problem - the only difference is that the right hand side of the first constraint has been increased from 10 to 11): Decision variables: A, B, C, and D Objective: maximize 3 A + 5 B + C +2 D Constraints: A + B + C + D <= 11 A – B = 0 A + B – C – D <= 0 Solve it using Excel....
As in the previous question: Quantity demanded for good A is given by the following: Q(A)...
As in the previous question: Quantity demanded for good A is given by the following: Q(A) = 100 - 0.2P(A) - 0.1P(B)-0.5Y, where P(A) is the price of good A, P(B) is the price of good B, and Y is consumer income. What is the cross price elasticity of demand for good A with respect to a change in the price of good B when Q(A)=2 and P(B)=4? Question 7 options: E=-0.2*P(B)/Q(A)= -0.2*4/2 E=-0.2* Q(A)/ P(B)= -0.2*2/4 E=-0.1* Q(A)/ P(B)=...
Given the following research topic, answer the question below: Are there differences in university GPA and...
Given the following research topic, answer the question below: Are there differences in university GPA and persistence rates between who enrolled in first-year seminars compared to those who did not enroll in first-year seminars? g. Consider the extraneous variable campus living arrangement. Describe how you could control this extraneous variable through homogeneous grouping. h. Suggest one additional extraneous variable and one way to control it.
Given the following research topic, answer the question below: Are there differences in university GPA and...
Given the following research topic, answer the question below: Are there differences in university GPA and persistence rates between who enrolled in first-year seminars compared to those who did not enroll in first-year seminars? a. What is the dependent variable(s)? b. Are there any other dependent variables that might be of interest in this study? c. What is the independent variable? Identify levels of the variable. d. Why is this an example of ex post facto research? e. Consider the...
Use the following statements to answer the question below: 1. Two firms experiencing exactly the same...
Use the following statements to answer the question below: 1. Two firms experiencing exactly the same economic events could report different net income while both correctly following generally accepted accounting principles. 2. Only finance and accounting professionals need to understand accounting principles. 3. Cash flow is what matters to a firm and its investors; therefore, the statement of cash flows is the only financial statement that investors need consider. 4. The book value of a firm’s equity is an accurate...
Use the data given below to answer the following question(s). The following table exhibits the age...
Use the data given below to answer the following question(s). The following table exhibits the age of second-hand furniture and the corresponding prices. Use the table to answer the following question(s). (Hint: Use scatter diagram and XLMiner where necessary.) Number of Years Values 2 1856 14 348 7 1020 5 1530 10 349 8 780 9 653 3 1830 10 750 6 1300 Q1. What is the relationship between the age of the furniture and their values? _ _________________ Q2....
3. The data given below for Alabama city in 2019, answer the following question and show...
3. The data given below for Alabama city in 2019, answer the following question and show your calculation Export $300 Import $350 Personal consumption expenditures (C) $2,000 Government expenditure on goods and services (G) $1,100 Gross private investment (I) $1,300 Taxes $1000 Fractional Unemployment rate 2.3% Structural Unemployment rate 1.5% Cyclical unemployment rate -0.3% Reserve Ratio (RR) 20% Deposit at Banks $2000 Price level (P.L) 120 a. What is the value of Net Export? b. Is country borrowing from or...
QUESTION 1 Study the information given below and answer each of the following questions independently: •          ...
QUESTION 1 Study the information given below and answer each of the following questions independently: •           Calculate the margin of safety (as a percentage). •           Calculate the number of units that must be sold if the company desires an operating profit of $1 350 000. •           Suppose the company wants to spend $120 000 more on advertising and reduce the selling price by $4 per unit, with the expectation that the sales volume will increase by 20%. Is this a...
Question 1 The mean starting salary of job with certain degree is unknown. Based on a...
Question 1 The mean starting salary of job with certain degree is unknown. Based on a sample of starting salary of 25 employees, the mean salary turns out to be $45,750/year. Assume that the population of all starting salaries follows a normal distribution with standard deviation $9125. To find a 95% confidence interval estimate of mean staring salary, what interval estimate will you use? Group of answer choices T-interval Z-interval Question 2 The mean starting salary of job with certain...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT