Question is how do I create cell reference for this?? The answers are correct. just dont know how to use the FX in Excel to make it caluate itself. Looking for the answer for $192.31

Problem 3-6 Suppose the risk-free interest rate is 4%.

a. Having $200 today is equivalent to having what amount in one year?

b. Having $200 in one year is equivalent to having what amount today?

c. Which would you prefer, $200 today or $200 in one year? Interest rate 4.00%

a. Having $200 today is equivalent to having what amount in one year?

Amount today $200.00

Value in 1 year $208.00

b. Having $200 in one year is equivalent to having what amount today?

Amount in 1 year $200.00

Value today $192.31

c. Which would you prefer, $200 today or $200 in one year? I would prefer $200 Today

Requirements 1. In cell D15, by using cell references, calculate the future value (1 pt.). 2. In cell D21, by using cell references, calculate the present value (1 pt.). 3. To decide whether you should prefer an amount today or the same amount in one year, in cell D25, type either Today or In one year (1 pt.).