on part B of this Excel. I`m trying to do what if formulas. I`m very confused can
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66776842b6bc0_50666776842941ba.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66776843263f7_5076677684302cdc.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66776843773eb_507667768435a2c4.jpg)
on part B of this Excel. I`m trying to do "what if" formulas.
I`m very confused can an expert help me fix my formulas in part B please
the has a defined benefit plan that specifies annual retirement benefits equal toSet %X Service YearsXFinal Year's Salary
I`m asked to develop a model that will calculate the Service Cost, Interest and Projected Benefit Obligation at the end of each year for one employee. PBO increases each year for service cost and interest.After retirement, benefits are paid and PBO is reduced.the model should be flexible, but you can have it set for a maximum number of years.To test your model, you should make up assumptions.
For example, you expect to retire in 40 years after 40 years of service.You expect to live 20 years after retirement.You expect your salary to be $200,000 your final year of work and the set% is 1%.The settlement rate (discount rate) is estimated to be 4%.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66776843cc31c_50766776843aa02e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6677684436d69_5086677684418115.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6677684498b94_508667768446e900.jpg)