help me solve these please with the correct formulas

Choosing a lottery payout option Congratulations! You've won a state lottol The state lottery offers you the following (after-tax) payout options: \begin{tabular}{|l|r|} \hline Option \#1: & $14,500,000 six years from now \\ \hline Option \#2: & $2,200,000 at the end of each year for the next six years \\ \hline Option #3: & $12,500,000 four years from now \\ \hline \end{tabular} Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 11 from the Instructions tab or if you type the numbers in, you will be marked wrong. Requirement Assuming that you can earn 6% on your funds, which option would you prefer? a. For each of the three Options, use a single Excel formula function PV. b. Make sure all answers are positive values. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Cick Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsheet with feedback (Always use cell references and formulas where appropriate to recelve full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)