Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behavioral Finance And Investor Types

Authors: Michael M. Pompian

1st Edition

1118011503, 978-1118011508

More Books

Students also viewed these Finance questions