Hewlitt Corporation established an early retirement program as part of its corporate restructuring. At the close of the voluntary sign-up period, 68 employees had elected early retirement. As a result of these early retirements, the company incurs the following obligations over the next eight years:
The csh 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 eight 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:
|Bond||Price||Rate (%)||Years to Maturity|
The government bonds have a par value of $1000, which means that even with different prices each bond pays $1000 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 savings and earn interest at an annual rate of 4%.
a) replicate the LP model in Excel and obtain the same results