Name Date

1-2 •

Exercises
1. Use the trading data for Friday, October 20 and Friday, October 27 to answer the questions.

a. What was the difference between the high and the low prices on October 20?
High - Low = Difference
$40.10 - $36.77 = $ _______
b. On October 27, what was the actual volume of Discovery Inc. shares posted?
Write the volume in numerals.
Volume = 23,600 x 100 = _______
c. At what price did Discovery Inc. close on October 19?
Closing price October 19 = Last - Chg =
$38.50 - $1.56 = $ _______
d. Use the October 1 9 closing price from above and the October 20 opening price to find
the difference in prices as a percent increase. Round to the nearest hundredth percent.
Percent increase = ((open - close) / Close) x 100 =
(($37.22 - $36.94)/$36.94) = 0.00757 x 100 = _____%
e. On October 21, Discovery Inc. announced that they would close one of their
manufacturing plants. This resulted in a drop in their stock price. It closed at $32. Express
the net change from October 20 to October 21 as a percent, rounded to the nearest tenth
of a percent.
Net change as percent: (Oct 21 closing price - Oct 20 closing price)/Oct 20 closing price =
(($32 - $38.50)/$38.50) = -0.1688 x 100 = ________%
f. On October 28, Discovery Inc. announced that they would not be closing the plant. This
news caused the price of their stock to rise. It closed at $48.20. Express the net change
from October 27 to October 28 as a percent, rounded to the nearest tenth of a percent.
Net change as percent: (Oct 28 closing price - Oct 27 closing price)/Oct 27 closing price =
(($48.20 - $42.00)/$42.00) = 0.1476 x 100 = ________%
g. Explain why the 52-week high and 52-week low numbers are the same in both charts.
It is the same because the prices during the week did not increase to an amount greater than the
52-week high and did not decrease to an amount lower than the 52-week low.
h. Examine the closing on October 27. One year earlier, one share
price of Discovery Inc.
closed at 30% higher than that amount. What was the closing price one year earlier?
Closing price one year later = Oct 27 closing price x 130%
$42 x 1.30 = $ _________

0 2011 Cen age Learning, All Rights Reserved, May not be scanned, copied
or duplicated or posted to a publicly accessible website, in whole or in part. Financial Algebra Workbook 1-2 3
Name Date

2. Write each of the following volumes using complete numerals.

a. Sales in 100s: 82567 b. Sales in 100s: 321.78 c. sales in 1000s: 12856
82567 x 100 = ________ 321.78 x 100 = __________ 12856 x 1000 = __________

d. Sales in IOOOs: 6478.98 e. sales in 100,000s: 35495.235 f. Sales in

6478.98 x 1000 = ________ 35495.235 x 100,000 = _________ 3.2 x 100,000 = __________

Use the spreadsheet to answer the Exercises 3 — 7. Use the left side of the equation to indicate
in which cell to store the formula.

B c
4Volume;
1 *2S€oZk
1000

American Bicycle
2
ABC corp. 34.89 3.02 31.87 12345

S 36
General Hospital
4
GHI Incorporated 14.7 -0.28 14.98 8123

5 JunipeÄåh'ås2

Middle Network
6
MNO Offices 75 -0.6 75.45 2637

7 VriFIQQLteen:•« 1

Southern Texas
8 23754.2
STU Underwriters 54.92 -3.37

9
VWX;;
3. Write a formula that will convert the volume given in 100s into a volume given in 1000s.

a. Juniper Kansas b. Detroit Energy

H5 = G5 x 100 H3 = G3 x 100
1000 1000
4. Write a formula that will store the exact volume for each stock in column l.

a. Valley Windmill b. Middle Network

I9 = H9 x 1000 I6 = H6 x 1000

5. Write a formula to determine the close on August 20 for each of the following.

a. Southern Texas b. Prince Queen Resalers

F8 = C8 - D8 F7 = C7 - D7

6. Write a formula to determine the percent change for each of the following.

a. ABC b. GHI
E2 = D2/F2 E4 = D4/F4

7. Calculate each net change.

a. MNO b. vwx
D6 = E6 x F6 D9 = E9 x F9

4 Financial Algebra Workbook 1-2 0 2011 Cengage Learning. All Rights Resewed. May not be scanned,
or duplicated. or posted to a publicly accessible website, in whole