QR 2-7 Tech Template
xlsx
keyboard_arrow_up
School
Grand Canyon University *
*We aren’t endorsed by this school
Course
1440500
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
3
Uploaded by alyssacastillo26
Purchase Date
Stock
Shares
Price per Share
Fees
Initial Investment
8-Oct
TSLA
10
$413.98
$9.95
$4,149.75
8-Oct
AAPL
5
$115.08
$9.95
$585.35
8-Oct
MSFT
10
$209.83
$9.95
$2,108.25
Total
$6,843.35
Date
Stock
Shares
Closing Price per Share
Value
Gain/Loss
8-Oct
TSLA
10
$413.98
$4,139.80
$0.00
9-Oct
TSLA
10
$425.30
$4,253.00
$113.20
12-Oct
TSLA
10
$425.92
$4,259.20
$119.40
13-Oct
TSLA
10
$434.00
$4,340.00
$200.20
14-Oct
TSLA
10
$442.30
$4,423.00
$283.20
Enter the information in columns A, B, C and D for each of your three
stocks.
Enter a formula in cell F2 and use the fill-down feature to
complete cells F3 and F4 (don't forget to include the fees in this
formula).
Then enter a formula in cell F5 to compute the total of your
three stock purchases.
Note:
You may nee
depending on how
Date
Stock
Shares
Closing Price per Share
Value
Gain/Loss
Date
Stock
8-Oct
AAPL
5
$115.08
$575.40
$0.00
8-Oct
MSFT
9-Oct
AAPL
5
$114.97
$574.85
-$0.55
9-Oct
MSFT
12-Oct
AAPL
5
$116.97
$584.85
$9.45
12-Oct
MSFT
13-Oct
AAPL
5
$124.00
$620.00
$44.60
13-Oct
MSFT
14-Oct
AAPL
5
$121.10
$605.50
$30.10
14-Oct
MSFT
Enter the date and closing price of each stock for each date you track after the purchase date.
The template is se
that once you enter the initial price, ticker symbol and number of shares, that information will automatically appe
the cells from row 14 down.
Enter a formula in cells E14, L14, and S14 to calculate the value of each stock for each date.
Use the fill-down fea
complete these columns.
Enter a formula in cells F14, M14, and T14 to calculate the gain/loss of value for each stock as of each date.
Use t
down feature to complete these columns.
This formula should compare the value as of each date to the initial
investment near the top of column F.
You will need to use $ to lock the cell where the initial investment for each
appears.
Enter a formula in cell V14 to calculate the total gain/loss for all three stocks as
of each date.
This will be done by adding the results in the gain/loss column for
each stock. Use the fill-down feature to complete this column.
ed to add additional rows after row 18
many dates you are asked to record.
Shares
Closing Price per Share
Value
Gain/Loss
Total Gain/Loss
10
$209.83
$2,098.30
$0.00
$0.00
10
$210.58
$2,105.80
$7.50
$120.15
10
$215.81
$2,158.10
$59.80
$188.65
10
$221.40
$2,214.00
$115.70
$360.50
10
$222.86
$2,228.60
$130.30
$443.60
et up so
ear in
ature to
the fill-
stock
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Stock B
Par value
$ 40
Sale price
$ 38
Flotation cost
$ 3.50
Annual dividend
8%
Dividend payment
Proceed from sale
Cost of preferred stock
By using cell references calculate the dividend payment of preferred Stock B.
By using cell references calculate the proceeds from sale of referred stock B.
By using cell references calculate the cost of preferred stock B.
arrow_forward
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Stock E
Par value
$ 20
Sale price
$ 20
Flotation cost
$ 2.50
Annual dividend
9%
Dividend payment
Proceed from sale
Cost of preferred stock
By using cell references to the given data calucalte the dividend payment of preferred stock E.
By using cell references to the given data calculate the proceeds from sale of preferred stock E.
By using cell references to the given data calculate the cost of preferred stock E.
arrow_forward
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Stock C
Par value
$ 35
Sale price
$ 37
Flotation cost
$ 4.00
Annual dividend
$ 5.00
Proceed from sale
Cost of preferred stock
By using cell references to the given data calculate the proceeds from sale of preferred stock C.
By using cell references to the given data calucalte the cost of preferred stock C.
arrow_forward
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Solution
Stock A
Par value
$ 100
Sale price
$ 101
Flotation cost
$ 9.00
Annual dividend
11%
Dividend payment
Proceed from sale
Cost of preferred stock
by using cell references to the given data, calculate the dividend payment of preferred stock A
arrow_forward
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Solution
Stock A
Par value
$ 100
Sale price
$ 101
Flotation cost
$ 9.00
Annual dividend
11%
Dividend payment
Proceed from sale
Cost of preferred stock
By using cell references calcualte the cost of preferred stock A
arrow_forward
Preferred stock
Par value
Sale price
Flotationcost
Annual dividend
A
$ 100
$ 101
$ 9.00
11%
B
40
38
$ 3.50
8%
C
35
37
$ 4.00
$ 5.00
D
30
26
5% of par
$ 3.00
E
20
20
$ 2.50
9%
Solution
Stock A
Par value
$ 100
Sale price
$ 101
Flotation cost
$ 9.00
Annual dividend
11%
Dividend payment
Proceed from sale
Cost of preferred stock
By using cell references to the given data calculate the proceeds from sale of preferred stock A
arrow_forward
Target Share Price
Takeover Premium
Acquirer Share Price
Target Shares Outstanding
Acquirer Shares Outstanding
Given the data in the above table, calculate the share exchange ratio:
0.46
1.12
2.62
4.19
$15.50
10%
$6.50
300
700
arrow_forward
Problem #2
Share Dividends
Assume the following data:
Ordinary Shares, P100 par value, 50,000 shares issued
P5,000,000
Share Premium
200,000
2,000,000
Retained Earnings
Market Value-declaration date
150
Market Value-distribution date
170
Required:
For each of the following assumptions, prepare entries on the date of declaration and date of
рayment:
1. A 20% share dividends is declared on ordinary shares.
2. A 10% share dividends is declared on ordinary shares.
arrow_forward
a. Expected return
b. Price per share
d. New share price
e-1. Shares repurchased
e-2. New shares outstanding
g. Required return
$
$
G
15.43 %
34.68
37.08
%
arrow_forward
10-7
What is the geometric average return of a stock with the following share price history?
Year
Share price
1
$20
2
$22
3
$24
4
$26
5
$28
Select one:
a. 9.09%
b. 8.78%
c. 8.33%
d. 7.69%
e. 6.48%
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Preferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Stock B Par value $ 40 Sale price $ 38 Flotation cost $ 3.50 Annual dividend 8% Dividend payment Proceed from sale Cost of preferred stock By using cell references calculate the dividend payment of preferred Stock B. By using cell references calculate the proceeds from sale of referred stock B. By using cell references calculate the cost of preferred stock B.arrow_forwardPreferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Stock E Par value $ 20 Sale price $ 20 Flotation cost $ 2.50 Annual dividend 9% Dividend payment Proceed from sale Cost of preferred stock By using cell references to the given data calucalte the dividend payment of preferred stock E. By using cell references to the given data calculate the proceeds from sale of preferred stock E. By using cell references to the given data calculate the cost of preferred stock E.arrow_forwardPreferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Stock C Par value $ 35 Sale price $ 37 Flotation cost $ 4.00 Annual dividend $ 5.00 Proceed from sale Cost of preferred stock By using cell references to the given data calculate the proceeds from sale of preferred stock C. By using cell references to the given data calucalte the cost of preferred stock C.arrow_forward
- Preferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Solution Stock A Par value $ 100 Sale price $ 101 Flotation cost $ 9.00 Annual dividend 11% Dividend payment Proceed from sale Cost of preferred stock by using cell references to the given data, calculate the dividend payment of preferred stock Aarrow_forwardPreferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Solution Stock A Par value $ 100 Sale price $ 101 Flotation cost $ 9.00 Annual dividend 11% Dividend payment Proceed from sale Cost of preferred stock By using cell references calcualte the cost of preferred stock Aarrow_forwardPreferred stock Par value Sale price Flotationcost Annual dividend A $ 100 $ 101 $ 9.00 11% B 40 38 $ 3.50 8% C 35 37 $ 4.00 $ 5.00 D 30 26 5% of par $ 3.00 E 20 20 $ 2.50 9% Solution Stock A Par value $ 100 Sale price $ 101 Flotation cost $ 9.00 Annual dividend 11% Dividend payment Proceed from sale Cost of preferred stock By using cell references to the given data calculate the proceeds from sale of preferred stock Aarrow_forward
- Target Share Price Takeover Premium Acquirer Share Price Target Shares Outstanding Acquirer Shares Outstanding Given the data in the above table, calculate the share exchange ratio: 0.46 1.12 2.62 4.19 $15.50 10% $6.50 300 700arrow_forwardProblem #2 Share Dividends Assume the following data: Ordinary Shares, P100 par value, 50,000 shares issued P5,000,000 Share Premium 200,000 2,000,000 Retained Earnings Market Value-declaration date 150 Market Value-distribution date 170 Required: For each of the following assumptions, prepare entries on the date of declaration and date of рayment: 1. A 20% share dividends is declared on ordinary shares. 2. A 10% share dividends is declared on ordinary shares.arrow_forwarda. Expected return b. Price per share d. New share price e-1. Shares repurchased e-2. New shares outstanding g. Required return $ $ G 15.43 % 34.68 37.08 %arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning