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

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 21E
icon
Related questions
Question
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: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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Types of business entities
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College