Dividends per share Lightfoot Inc., a software development firm, has stock outstanding as follows: 38,000 shares of cumulative preferred 1% stock, $135 par and 101,000 shares of $145 par common. During its first four years of operations, the following amounts were distributed as dividends: first year, $33,000; second year, $66,000; third year, $72,000; fourth year, $115,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers. in the questions below. X Open spreadsheet Determine the dividends per share on each class of stock for each of the four years. Round your answers to the nearest cent. If no dividends are paid in a given year, enter "0". Preferred stock (dividends per share) $ Common stock (dividends per share) $ 1st Year $ $ 2nd Year $ $ 3rd Year $ $ 4th Year
Dividends per share Lightfoot Inc., a software development firm, has stock outstanding as follows: 38,000 shares of cumulative preferred 1% stock, $135 par and 101,000 shares of $145 par common. During its first four years of operations, the following amounts were distributed as dividends: first year, $33,000; second year, $66,000; third year, $72,000; fourth year, $115,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers. in the questions below. X Open spreadsheet Determine the dividends per share on each class of stock for each of the four years. Round your answers to the nearest cent. If no dividends are paid in a given year, enter "0". Preferred stock (dividends per share) $ Common stock (dividends per share) $ 1st Year $ $ 2nd Year $ $ 3rd Year $ $ 4th Year
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:Dividends per share
Lightfoot Inc., a software development firm, has stock outstanding as follows: 38,000 shares of cumulative preferred 1% stock, $135 par and 101,000 shares of $145 par
common. During its first four years of operations, the following amounts were distributed as dividends: first year, $33,000; second year, $66,000; third year, $72,000;
fourth year, $115,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers
in the questions below.
X
Open spreadsheet
Determine the dividends per share on each class of stock for each of the four years. Round your answers to the nearest cent. If no dividends are paid in a given year,
enter "0".
Preferred stock (dividends per share) $
Common stock (dividends per share) $
1st Year
$
$
2nd Year
$
3rd Year
$
$
4th Year

Transcribed Image Text:File
B22
5
6
7
8
9
10
11
12
14
15
16
17
Home
1 ~
25
26
27
Par value
Common stock:
Insert
Cumulative preferred stock:
Shares outstanding
Dividend right
1st year
2nd year
Arial
X ✓ fx
3rd year
4th year
Shares outstanding
Par value
Dividends distributed:
A
1
Dividends per share
2 Lightfoot Inc., software development firm, has stock outstanding and dividends distributed as follows:
18
19
20
21
22 Preferred stock
23
Common stock
24
Draw
Page Layout
DATA
10
Formulas
1st Year
1st Year
B 68 - A
38,000
1%
$135
Data
101,000
$145
$33,000
$66,000
$72,000
$115,000
с
Review
2nd Year
View Help
2nd Year
Evab
Dividends Per Share
+
Using formulas and cell references, perform the required analysis, and input your answers into the Dividends Per Share columns. Transfer the numeric results for
the green entry cells (B22:E23) into the appropriate fields in CNOWV2 for grading.
Formulas
Editing
Currency
D
3rd Year
$ ✓
3rd Year
5000
00
E
4th Year
4th Year
F
εν του
Comm
Ov
Expert Solution

Introduction:
Dividend is a reward given by the company to its shareholders. It can be in the form of cash or otherwise.
The question requires to calculate dividend per share of both preferred stock and common stock.
The working is shown below:
Trending now
This is a popular solution!
Step by step
Solved in 6 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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