Assume a hypothetical age (Use Age 24) . Assume you would like to invest in a zero-coupon bond in order to have $500,000 in your retirement account when you get to the retirement age of 67. You found a zero-coupon bond yielding 5 percent semiannually. The face value of this bond is $5,000.

The maturity of this bond is 67 minus hypothetical age (Age 24)

Using age 24, estimate how much you must invest today to achieve your goal of having $500,000 in your retirement account at age 67.

Please show work on Excel.