Present the analysis for each year in an excel sheet.

1 How much will be the LTIP on year 6, if the bonus on year 6 is 9000.

Present your analysis in excel

2 How much will be the LTIP on year 7 if bonus is 8000,

Present your analysis in excel

3 How much will be the LTIP on year on year 8 when bonus is 6000

Present your analysis in excel

4 On year 3 if the bonus is changed to 6500 instead of 9460,then how much will be LTIP on year 3, 4, 5.

Present your analysis in excel

5 Derive a Generalized formula, in excel for 6th year bonus

Present your analysis in excel

6. design the product for this system assuming this is to be done for 1000 employees: Note that factors will be different
between 1000 employees

Make a presentation with solution design