Please show the Excel formulas in the cells! by the command Control + ~

worth today? 3. You win a lottery and have a choice of receiving $1,000,000 today or $2,000,000 in five years. If your discount rate is 10% which choice will give you a higher Present Value? Which choice will give you a higher Future Value? Make a data presentation for this problem and calculate the answers by formulae to prove your answer. (Assume the interest rate equals the discount rate.)