Question
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
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.).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started