Question: The first figure below shows a spreadsheet that someone created to compute the value of an initial investment of $10,000 (stored in cell C3). The

The first figure below shows a spreadsheet that someone created to compute the value of an initial investment of $10,000 (stored in cell C3). The annual interest rate is shown in cell C4.. They now want to know what the initial investment should have been for the value at the end of year 10 be $20,000. They invoked the goal seek dialog for this and the dialog is shown in the second figure below. Fill in the values they should fill in for boxes 1, 2 and 3. Enter relative addresses wherever addresses are needed and enter numbers without commas or currency signs where numbers are needed -- do not include any spaces; also remember, these are not formulas. Box 1 Question Blank 1 of 3 type your answer... Box 2 Question Blank 2 of 3 type your answer... Box 3 Question Blank 3 of 3

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 Mathematics Questions!