Question: Exercise 2_no2 (FV single cash flow, finding r): Five years ago, you made a deposit of $50. The value of this deposit today is $70.13.

Exercise 2_no2 (FV single cash flow, finding r): Five years ago, you made a deposit of $50. The value of this deposit today is $70.13. What was the annual return earned on this deposit?

a.) Use the template in this problem to arrive at the answer with trial and error.

b.) Solve the problem again by solving 70.13=50*(1+r)^5 - do this by using FV function in excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Exercise 2_no2 (FV single cash flow, finding r): Five years ago, you made a deposit of $50 The value of this deposit today is $70.13. What was the annual return earned on this deposit? a.) Use the...

(FV single cash flow, finding r) Five years ago you made a deposit of $50. The value of this deposit today is $70.13. What was the annual return earned on the deposit? a. Use the template in this...

2. (FV single cash flow, finding r) Five years ago you made a deposit of $50. The value of this deposit today is $70.13. What was the annual return earned on the deposit?

Exercise 1_no1 (FV single cash flow): You just put $600 in the bank, you intend to leave it there for 10 years. If the bank pays you 15% interest per year, how much will you have at the end of 10...

Five years ago, you made a deposit of $ 5 0 . The value of this deposit today is $ 7 0 . 1 3 . What was the annual return earned on this deposit? a . ) Use the template in this problem to arrive at...

show steps in excel. Evercise 1 no1 (FV single cash flow): You just put $600 in the bank, you intend to leave it there for 10 years. If the bank pays you 15% interest per vear, how much will you have...

please help with number 2, in excel only(use template) Note: The data for these exercises can be found on the Benninga, Principles of Finance with Excel, Third Edition companion website...

Number 4 On excel using FV function! Note: The data for these exercises can be found on the Benninga, Principles of Finance with Excel, Third Edition companion website (www.oup.com/us/Benninga). 1....

please help with number 3! show work with excel Note: The data for these exercises can be found on the Benninga, Principles of Finance with Excel, Third Edition companion website...

please help with number 3 Note: The data for these exercises can be found on the Benninga, Principles of Finance with Excel, Third Edition companion website (www.oup.com/us/Benninga). 1. (FV single...

Identify the advantages and disadvantages of rules-based versus principles-based accounting standards.

Labran Jones has played for the Cleveland professional basketball team for the past eight seasons and has established himself as one of the top players in the league. He has recently become a free...

The knee joint can extend to 1 8 0 degrees normally, although some individuals can extend slightly further true or false?

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...