what are the formulas I should be plugging in and what should I be putting Into solver I can not get it to work

I do not know how they got those answers in the questions

Your company gives workers a starting salary of $60,000 and an annual raise $1,500. On average, workers stay with the company for 20 years. The relevant discount rate is 3%. A. What is the present value of the cost of a worker? ($1,082,846) B. If the company wants to keep the starting salary $60,000 and the present value of the cost of one worker at $1,000,000, what should be the amount of an annual raise? ($847) C. If the company wants to keep the annual raise $1,500 and the present value of the cost of one worker at $1,000,000, what should be the amount of a starting salary? ($54,431) D. The firm decides to give workers a raise a constant growth (%) instead of the constant annual dollar amount ($1,500). If the company wants to keep the starting salary $60,000 and the present value of the cost of one worker at $1,000,000, what should be the annual growth rate for the starting salary $60,000? (1.31%) Submit your Excel file. Organize your answers as shown below (only the first five years are shown as a hint). Note that the numerical answers that you are supposed to get if you set up the questions correctly are highlighted yellow. All questions require the NPV function, and questions B-D require Solver. Nm 00 A B question A 2 PV $1,082,846 3 Year 1 $60,000 5 2 $61,500 3 $63,000 7 4 $64,500 8 5 $66,000 D E question B question C question D $1,000,000 $1,000,000 $1,000,000 $847 $1,500 1.31% $60,000 $54,431 $60,000 $60,847 $55,931 $60,785 $61,693 $57,431 $61,580 $62,540 $58,931 $62,386 $63,387 $60,431 $63,202 zrnn A Your company gives workers a starting salary of $60,000 and an annual raise $1,500. On average, workers stay with the company for 20 years. The relevant discount rate is 3%. A. What is the present value of the cost of a worker? ($1,082,846) B. If the company wants to keep the starting salary $60,000 and the present value of the cost of one worker at $1,000,000, what should be the amount of an annual raise? ($847) C. If the company wants to keep the annual raise $1,500 and the present value of the cost of one worker at $1,000,000, what should be the amount of a starting salary? ($54,431) D. The firm decides to give workers a raise a constant growth (%) instead of the constant annual dollar amount ($1,500). If the company wants to keep the starting salary $60,000 and the present value of the cost of one worker at $1,000,000, what should be the annual growth rate for the starting salary $60,000? (1.31%) Submit your Excel file. Organize your answers as shown below (only the first five years are shown as a hint). Note that the numerical answers that you are supposed to get if you set up the questions correctly are highlighted yellow. All questions require the NPV function, and questions B-D require Solver. Nm 00 A B question A 2 PV $1,082,846 3 Year 1 $60,000 5 2 $61,500 3 $63,000 7 4 $64,500 8 5 $66,000 D E question B question C question D $1,000,000 $1,000,000 $1,000,000 $847 $1,500 1.31% $60,000 $54,431 $60,000 $60,847 $55,931 $60,785 $61,693 $57,431 $61,580 $62,540 $58,931 $62,386 $63,387 $60,431 $63,202 zrnn A