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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
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

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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education