Q5: (PV) You are the CFO of Termination, Inc. Your company has 40 employees, each earning $40,000
Fantastic news! We've Found the answer you've been seeking!
Question:
Q5: (PV) You are the CFO of Termination, Inc. Your company has 40 employees, each earning $40,000 per year. Employee salaries grow at 4% per year. Starting from next year, and every second year thereafter, of retirement. Life expectancy is twenty years after retirement, and the annual pension is paid at year-end. The return on investment is 10% per year. What is the total value of your pension liabilities? can you please answer it in Excell sheet?
Thank you
Posted Date: