could you okease do it in excel

4. Today is 1/1/2020. You have received a new job offer. The compensation package for the next two years is as follows: Your salary is $200,000 per year. The salary will be paid bi-weekly (assume one year has 52 weeks). You will receive a one-time $20,000 sign on bonus after six months of joining the company. This bonus will be paid immediately on the completion of the six-month period. You are offered a performance based bonus, a 15% bonus of the annual salary if you are working actively at the time of the payout of the bonus. This bonus will be paid at the end of each year. Suppose you will invest all the compensation to a fund that earns an APR of 6%, compounded bi- weekly What is the present value on 1/1/2020 for the two-year compensation package