Transcribed Image Text
Please show how to write the formulas for these in Excel. Thatis what the assignment requires and I don't know how to do it.Thank you! All are in column D. Cell numbers that matter are notedon the left.Suppose the risk-free interest rate is 4%.a.Having $200 today is equivalent to having what amount in oneyear?b.Having $200 in one year is equivalent to having what amounttoday?c.Which would you prefer, $200 today or $200 in one year?D9Interest rate4.00%11a.Having $200 today is equivalent to having what amount in oneyear?13Amount today$200.0015Value in 1 year17b.Having $200 in one year is equivalent to having what amounttoday?19Amount in 1 year$200.0021Value todayc.Which would you prefer, $200 today or $200 in one year?25I would prefer $200.