please do in excel

( 30 points) HC established an early retirement program as part of its corporate restructuring. At the close of the voluntary sign-up period, 70 employees had elected early retirement. As a result of these early retirements, the company incurs the following obligations over the next four years: The cash requirements (in thousands of dollars) are due at the beginning of each year. The corporate treasurer must determine how much money must be set aside today to meet the four yearly financial obligations as they come due. The financing plan for the retirement program includes investments in government bonds as well as savings. The investments in government bonds are limited to three choices: The government bonds have a par value of $1,000, which means that even with different market prices each bond pays $1,000 at maturity. The rates shown are based on the par value. For purposes of planning, the treasurer assumed that any funds not invested in bonds will be placed in one-year C/D and earn interest at an annual rate of 1% for the first two years and 1.5% for the rest years. 'Q4 Answer" for your