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
Get step-by-step solutions from verified subject matter experts
