A B 1 Purchase price per share $57 2 Total commission $35 3 Dividend at year 1 $1.80 4 Dividend at second year $1.93 5 Number of shares bought 100 6 Total purchase price =B5*B1 7 Purchase price with commission =B6+B2 8 Selling price at the end of second year $59 9 Total selling price |=B8*B5 10 Commission on selling $44 11 Selling price net of commission =B9-B10 12 Total dividend in year 1 =B3*B5 13 Total dividend in year 2 =B4*B5 14 (a) Dividend yield at purchase =B12/B6 15 (b) Dividend yield at sale =B13/B9 16 (c) Total return |=B11+B12+B13-B7 17 Holding period return 18 (d) Annualized holding period yield =B16/B7 =(1+B17)^(1/2)-1
A B 1 Purchase price per share $57 2 Total commission $35 3 Dividend at year 1 $1.80 4 Dividend at second year $1.93 5 Number of shares bought 100 6 Total purchase price =B5*B1 7 Purchase price with commission =B6+B2 8 Selling price at the end of second year $59 9 Total selling price |=B8*B5 10 Commission on selling $44 11 Selling price net of commission =B9-B10 12 Total dividend in year 1 =B3*B5 13 Total dividend in year 2 =B4*B5 14 (a) Dividend yield at purchase =B12/B6 15 (b) Dividend yield at sale =B13/B9 16 (c) Total return |=B11+B12+B13-B7 17 Holding period return 18 (d) Annualized holding period yield =B16/B7 =(1+B17)^(1/2)-1
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:A
B
1
Purchase price per share
$57
2
Total commission
$35
3
Dividend at year 1
$1.80
4 Dividend at second year
$1.93
5
Number of shares bought
100
6
Total purchase price
=B5*B1
7
Purchase price with commission
=B6+B2
8
Selling price at the end of second year
$59
9
Total selling price
|=B8*B5
10
Commission on selling
$44
11
Selling price net of commission
=B9-B10
12
Total dividend in year 1
=B3*B5
13
Total dividend in year 2
=B4*B5
14
(a) Dividend yield at purchase
=B12/B6
15
(b) Dividend yield at sale
=B13/B9
16
(c) Total return
|=B11+B12+B13-B7
17
Holding period return
18
(d) Annualized holding period yield
=B16/B7
=(1+B17)^(1/2)-1
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education