Question

14
without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.00)

a | b | c | d | e | f | g | h
1 symbol | stock | february 25 close | change | % change | february 24 close | volume in 1000s | volume in 100s
2 aapl | apple inc. | 96.76 | 0.66 | | 96.1 | 27,303 |
3 bbw | built - a - bear workshop inc. | 13.98 | 0.03 | 0.22% | | 168 |
4 ctb | cooper tire & rubber co. | 40.3 | 1.04 | | 39.26 | 727 |
5 f | ford motor co | 12.39 | 0.37 | | | 31,951 |
6 intc | intel corp | 28.8 | | −1.90% | | 26,432 |
7 msft | microsoft corp | 51.18 | | −2.80% | 52.65 | 26,695 |
8 ntgr | netgear inc. | 39.66 | 0.59 | 1.50% | | 228 |
9 yhoo | yahoo inc. | 31.36 | | 1.30% | | 19,842 |

write a formula to determine the percent change for each of the following. use the left side of the equation to indicate in which cell to store the formula.

a. apple inc. blank ×
b. cooper tire & rubber co. blank ×

Explanation:

Part a: Apple Inc. (Row 2)

Step1: Recall Percent Change Formula

Percent Change = \(\frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%\)
For Apple, New Close (Feb 25) is in C2, Old Close (Feb 24) is in F2. Percent Change cell is E2.

Step2: Construct the Formula

In cell E2, the formula is \(\text{E2} = \frac{\text{C2} - \text{F2}}{\text{F2}} \times 100\) (or in spreadsheet terms, =((C2-F2)/F2)*100 to get percentage)

Step1: Recall Percent Change Formula

Percent Change = \(\frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%\)
For Cooper Tire, New Close (Feb 25) is in C4, Old Close (Feb 24) is in F4. Percent Change cell is E4.

Step2: Construct the Formula

In cell E4, the formula is \(\text{E4} = \frac{\text{C4} - \text{F4}}{\text{F4}} \times 100\) (or in spreadsheet terms, =((C4-F4)/F4)*100)

Answer:

\(\text{E2} = \frac{\text{C2} - \text{F2}}{\text{F2}} \times 100\) (or spreadsheet formula: =((C2-F2)/F2)*100)

Part b: Cooper Tire & Rubber Co. (Row 4)