Question: PLEASE SHOW USING EXCEL! Question 3 Martin's coin collection contains hundred 1955 silver dollars. Her grandparents purchased them at their face value ($50 each) in

 PLEASE SHOW USING EXCEL! Question 3 Martin's coin collection contains hundred

1955 silver dollars. Her grandparents purchased them at their face value ($50

PLEASE SHOW USING EXCEL!

Question 3 Martin's coin collection contains hundred 1955 silver dollars. Her grandparents purchased them at their face value ($50 each) in 1955. These coins have appreciated by 4.2 percent annually. How much will the collection be worth in 2020? Present value Years Interest rate Future value Question 4 Seven years ago, you invested $2,800. Today it is worth $4,215. What rate of interest did you earn? Present value Years Interest rate Future value Question 5 On your tenth birthday, you received $1,000 which you invested at 5.3 percent interest, compounded annually. Your investment is now worth $1,856. How old are you today? Present value Years Interest rate Future value Question 6 How much more money would you make on the investment that pays interest compounded annually compared to the one that pays simple interest, given the 10% interest rate, $250,000 deposit amount and 12 years? Interest rate Deposit # of years Simple interest per year Total simple interest FV with simple interest Compound interest Difference

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!