Question

In: Finance

Nancy received a job offer. The annual salary is $90,000. For simplicity, assume she gets paid...

Nancy received a job offer. The annual salary is $90,000. For simplicity, assume she gets paid once a year at the end of each year. The salary is expected to increase 5% per year. If she works at the company for 28 years and the appropriate discount rate is 9% what is the present value of this offer?

Solutions

Expert Solution

Salary = Base Salary (1+r)^n

r = Increase Rate

n - No. of Years gap

Assuming $ 90000 is Todays salary.

PV of Salaries = Sum [ Salary after considering inc rate (CF )* PVF(r%, n) ]

Year Salary Today FVF @5% CF PVF @9% Disc CF
1 $ 90,000.00 1.05 $    94,500.00 0.917431 $      86,697.25
2 $ 90,000.00 1.1025 $    99,225.00 0.84168 $      83,515.70
3 $ 90,000.00 1.157625 $ 1,04,186.25 0.772183 $      80,450.90
4 $ 90,000.00 1.215506 $ 1,09,395.56 0.708425 $      77,498.57
5 $ 90,000.00 1.276282 $ 1,14,865.34 0.649931 $      74,654.59
6 $ 90,000.00 1.340096 $ 1,20,608.61 0.596267 $      71,914.97
7 $ 90,000.00 1.4071 $ 1,26,639.04 0.547034 $      69,275.89
8 $ 90,000.00 1.477455 $ 1,32,970.99 0.501866 $      66,733.66
9 $ 90,000.00 1.551328 $ 1,39,619.54 0.460428 $      64,284.71
10 $ 90,000.00 1.628895 $ 1,46,600.52 0.422411 $      61,925.64
11 $ 90,000.00 1.710339 $ 1,53,930.54 0.387533 $      59,653.14
12 $ 90,000.00 1.795856 $ 1,61,627.07 0.355535 $      57,464.04
13 $ 90,000.00 1.885649 $ 1,69,708.42 0.326179 $      55,355.26
14 $ 90,000.00 1.979932 $ 1,78,193.84 0.299246 $      53,323.88
15 $ 90,000.00 2.078928 $ 1,87,103.54 0.274538 $      51,367.04
16 $ 90,000.00 2.182875 $ 1,96,458.71 0.25187 $      49,482.01
17 $ 90,000.00 2.292018 $ 2,06,281.65 0.231073 $      47,666.16
18 $ 90,000.00 2.406619 $ 2,16,595.73 0.211994 $      45,916.94
19 $ 90,000.00 2.52695 $ 2,27,425.52 0.19449 $      44,231.91
20 $ 90,000.00 2.653298 $ 2,38,796.79 0.178431 $      42,608.72
21 $ 90,000.00 2.785963 $ 2,50,736.63 0.163698 $      41,045.10
22 $ 90,000.00 2.925261 $ 2,63,273.46 0.150182 $      39,538.86
23 $ 90,000.00 3.071524 $ 2,76,437.14 0.137781 $      38,087.89
24 $ 90,000.00 3.2251 $ 2,90,258.99 0.126405 $      36,690.17
25 $ 90,000.00 3.386355 $ 3,04,771.94 0.115968 $      35,343.74
26 $ 90,000.00 3.555673 $ 3,20,010.54 0.106393 $      34,046.72
27 $ 90,000.00 3.733456 $ 3,36,011.07 0.097608 $      32,797.30
28 $ 90,000.00 3.920129 $ 3,52,811.62 0.089548 $      31,593.73
PV of Salaries Today $15,33,164.51

Pls do rate, if the answer is correct and comment, if any further assistance is required.


Related Solutions

Linda received $90,000 in salary income for 2018. She has no dependents. Determine her income tax...
Linda received $90,000 in salary income for 2018. She has no dependents. Determine her income tax liability under each of the following independent situations: a. She files as a single individual. b. She is married and files a joint return with her spouse. Their only income is her $90,000 salary. c. She is married but files a separate
Joe Masters has received a job offer from a large wine retailer. His base salary will...
Joe Masters has received a job offer from a large wine retailer. His base salary will be $136,500. He will receive his first annual salary payment one year from the day he begins work. He will also get an immediate $50,000 bonus for joining the company. His salary will grow at 5 percent each year, starting after the first year. Mr. Masters is expected to work for 15 years. What is the present value of the offer if the discount...
Joe Masters has received a job offer from a large wine retailer. His base salary will...
Joe Masters has received a job offer from a large wine retailer. His base salary will be $136,500. He will receive his first annual salary payment one year from the day he begins work. He will also get an immediate $50,000 bonus for joining the company. His salary will grow at 5 percent each year, starting after the first year. Mr. Masters is expected to work for 15 years. What is the present value of the offer if the discount...
Dina has received a job offer from Amegy bank as branch manager. Her base salary will...
Dina has received a job offer from Amegy bank as branch manager. Her base salary will be $50,000 today. Assuming for simplicity that she will receive $50,000 today and her next annual salary with the appropriate increment one year from today. Her increment will be 5 percent each year if she performs well in the bank. Each year she will receive a bonus equal to 10 percent of her salary and her first bonus will be one year from today...
Joe Masters has received a job offer from a large wine retailer. His base salary will...
Joe Masters has received a job offer from a large wine retailer. His base salary will be $100,000. He will receive his first annual salary payment one year from the day he begins work. He will also get an immediate $50,000 bonus for joining the company. His salary will grow at 4 percent each year, starting after the first year. Each year he will also receive a bonus equal to 5 percent of his salary. Mr. Masters is expected to...
1. Sydney earned an annual income of $90,000 for a local employer. She quits her job...
1. Sydney earned an annual income of $90,000 for a local employer. She quits her job and sets up a rival company. Her annual expenses include $30,000 to rent her premises, $6,000 for the rent on equipment, and a salary of $30,000 for office help. To help finance the new business, she cashes in a bond worth $10,000 that had an annual interest payment of $500. Sydney’s implicit costs are ________. A. $90,000  B. $90,500  C. $100,000  D. $100,500 2. As production increases,...
A man gets a job with a salary of $38,900 a year. He is promised a...
A man gets a job with a salary of $38,900 a year. He is promised a $2,430 raise each subsequent year During a 9-year period his total earnings are________
Marcie quit her job as a gardener, which paid an annual salary of $63,000, and became...
Marcie quit her job as a gardener, which paid an annual salary of $63,000, and became a baker. She used $15000 out of her savings account that paid a 10% annual interest rate to buy an oven and other start-up capital. In her first year of operations, she spent $2,000 on supplies and $250 a month on rent. She earned revenue of $80,000. What are Marcie’s accounting and economic profits over the course of the year? $________ in accounting profits...
Geraldine Wolfe is a supervisor at Fantastigifts. She has an annual salary of $43,500, paid biweekly,...
Geraldine Wolfe is a supervisor at Fantastigifts. She has an annual salary of $43,500, paid biweekly, and a garnishment for consumer credit of $415. Assuming that her disposable income is 80 percent of her gross pay per period, does the garnishment follow the CCPA? If not, what is the maximum garnishment allowed for Geraldine’s consumer credit garnishment? Does the garnishment follow the CCPA?    Maximum garnishment allowed: Which of the following is true about fringe benefits? (You may select more...
Geraldine Wolfe is a supervisor at Fantastigifts. She has an annual salary of $45,000, paid biweekly,...
Geraldine Wolfe is a supervisor at Fantastigifts. She has an annual salary of $45,000, paid biweekly, and a garnishment for consumer credit of $375. Assuming that her disposable income is 80 percent of her gross pay per period, does the garnishment follow the CCPA ( Consumer Credit Protection Act)? If not, what is the maximum garnishment allowed for Geraldine’s consumer credit garnishment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT