8. You will deposit $2,000 today. It will grow for 6 years at 10% interest compounded semiannually. You will then withdraw the funds annually over the next 4 years. The annual interest rate is 8%. Your annual withdrawal will be:

9. After 10 years, 100 shares of stock originally purchased for $500 was sold for $900. What was the yield on the investment? Choose the closest answer.

These require excel formulas to be used. and im not very confident with them

for 8 i got

$1,084.41

9 i can not figure out.