hUSE EXCEL PLEASE

You are presented with two options: Option AAn annual payment of $1,000 for four years at the end of each year, and $1,200 for an additional ten years starting at the end of the fifth year. Option B - A one-time lump-sum payment of $10,000 at the end of the first year. If the annual interest rate is 6%, which option would you prefer? (show your work) [1points]