Text entry
Text entry
Text entry
Amount
Amount
Amount
Text entry
Amount
Text entry
Total capital stock
Additional paid-in capital
Formula
Amount
Formula
Amount
Formula
Formula
Total paid-in capital
Account title
Text entry
Less: Account title
Total stockholders’ equity
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
E11-9, Prepare a stockholders’ equity section.
$1,600,000
Paid-in Capital in Excess of Par Value—Preferred Stock
Common Stock ($2 stated value)
Treasury Stock—Common (12,000 shares)
Retained Earnings
Preferred Stock (8%, $100 par, noncumulative)
Paid-in Capital in Excess of Stated Value—Common Stock
72,000
1,334,000
Instructor:
Course:
Name:
Date:
Capital stock
Paid-in capital
The following stockholders’ equity accounts, arranged alphabetically, are in the ledger of Roder Corporation at
December 31, 2014.
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Instructions
600,000
1,050,000
45,000
Stockholders’ equity
December 31, 2014
Partial Balance Sheet
RODER CORPORATION
Amount
KimFin_7e_SET_Ch11.xlsx, Page 1 of 6 Page(s), 4/15/202211:52 AM
Additional paid-in capital
4,629,000
3,295,000
45,000
$2,200,000
8% Preferred stock, $100 par value, noncumulative,
Partial Balance Sheet
1,334,000
Paid-in Capital in Excess of Par Value—Preferred Stock
1,050,000
45,000
Paid-in Capital in Excess of Stated Value—Common Stock
Capital stock
Paid-in capital
Stockholders’ equity
December 31, 2014
600,000
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
RODER CORPORATION
Treasury Stock—Common (12,000 shares)
Retained Earnings
Preferred Stock (8%, $100 par, noncumulative)
Common Stock ($2 stated value)
72,000
Primer on Using Excel in Accounting by Rex A Schildhouse
E11-9, Prepare a stockholders’ equity section.
$1,600,000
The following stockholders’ equity accounts, arranged alphabetically, are in the ledger of Roder Corporation at
December 31, 2014.
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Instructions
Name:
Solution
Date:
Instructor:
Course:
KimFin_7e_SET_Ch11.xlsx, Page 2 of 6 Page(s), 4/15/202211:52 AM
par
2.
3.
4.
5.
Name:
Date:
Instructor:
Course:
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P11-6A, Prepare a stockholders’ equity section.
On January 1, 2014, Kessler Inc. had these stockholders’ equity balances.
Common Stock,
$1.00
2,000,000
shares
$600,000
authorized,
600,000
shares issued and outstanding)
Paid-in Capital in Excess of Par Value
1,500,000
1.
Issued
50,000
shares of
$1.00
Retained Earnings
700,000
During 2014, the following transactions and events occurred.
par value common stock for
$3.00
per share.
Issued
60,000
shares of common stock for cash at
$4.00
per share.
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Purchased
20,000
shares of common stock for the treasury at
$3.80
per share.
Declared and paid a cash dividend of
$207,000
Earned net income of
$410,000
Instructions:
Title
Amount
KESSLER INC.
Partial Balance Sheet
December 31, 2014
Stockholders’ equity
Title
Amount
Additional paid-in capital
Title
Amount
Title
Formula
Paid-in capital
Calculation as desired
Calculation as desired
Calculation as desired
Title
Formula
Less: Title
Amount
Title
Formula
KimFin_7e_SET_Ch11.xlsx, Page 3 of 6 Page(s), 4/15/202211:52 AM
par
2.
3.
4.
5.
Name:
Solution
Date:
Instructor:
Course:
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P11-6A, Prepare a stockholders’ equity section.
On January 1, 2014, Kessler Inc. had these stockholders’ equity balances.
Common Stock,
$1.00
2,000,000
shares
$600,000
authorized,
600,000
shares issued and outstanding)
Paid-in Capital in Excess of Par Value
1,500,000
1.
Issued
50,000
shares of
$1.00
Retained Earnings
700,000
During 2014, the following transactions and events occurred.
par value common stock for
$3.00
per share.
Issued
60,000
shares of common stock for cash at
$4.00
per share.
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Purchased
20,000
shares of common stock for the treasury at
$3.80
per share.
Declared and paid a cash dividend of
$207,000
Earned net income of
$410,000
Instructions:
Additional paid-in capital
2,490,000
3,393,000
KESSLER INC.
Partial Balance Sheet
December 31, 2014
Stockholders’ equity
Common stock, $1.00 par value, 2,000,000 shares authorized,
710,000* shares issued, and 690,000 shares outstanding
$710,000
Paid-in capital
KimFin_7e_SET_Ch11.xlsx, Page 4 of 6 Page(s), 4/15/202211:52 AM
par (
1.
2.
3.
4.
5.
Name:
Date:
Instructor:
Course:
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P11-6B, Prepare a stockholders’ equity section.
On January 1, 2014, Ferris Inc. had these stockholder equity balances.
Common Stock,
$5.00
2,000,000
shares
$3,000,000
authorized,
600,000
shares issued and outstanding)
Paid-in Capital in Excess of Par Value
1,800,000
Retained Earnings
810,000
During 2014, the following transactions and events occurred.
$9.00
per share.
Issued
60,000
shares of common stock for cash at
$9.50
per share.
Issued
75,000
shares of
$5.00
par value common stock for
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Purchased
25,000
shares of common stock for the treasury at
$10.00
per share.
Declared and paid a cash dividend of
$284,000
Earned net income of
$860,000
Instructions:
Title
Amount
FERRIS INC.
Partial Balance Sheet
December 31, 2014
Stockholders’ equity
Title
Amount
Additional paid-in capital
Title
Amount
Title
Formula
Paid-in capital
Text Entry
Formula
Less: Text Entry
Amount
Title
Formula
Calculation as desired
KimFin_7e_SET_Ch11.xlsx, Page 5 of 6 Page(s), 4/15/202211:52 AM
par (
1.
2.
3.
4.
5.
Name:
Solution
Date:
Instructor:
Course:
Financial Accounting, Seventh Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P11-6B, Prepare a stockholders’ equity section.
On January 1, 2014, Ferris Inc. had these stockholder equity balances.
Common Stock,
$5.00
2,000,000
shares
$3,000,000
authorized,
600,000
shares issued and outstanding)
Paid-in Capital in Excess of Par Value
1,800,000
Retained Earnings
810,000
During 2014, the following transactions and events occurred.
$9.00
per share.
Issued
60,000
shares of common stock for cash at
$9.50
per share.
Issued
75,000
shares of
$5.00
par value common stock for
Prepare the stockholders’ equity section of the balance sheet at December 31, 2014.
Purchased
25,000
shares of common stock for the treasury at
$10.00
per share.
Declared and paid a cash dividend of
$284,000
Earned net income of
$860,000
Instructions:
6,045,000
7,431,000
FERRIS INC.
Partial Balance Sheet
December 31, 2014
Stockholders’ equity
Common stock, $5.00 par value, 2,000,000 shares authorized,
735,000* shares issued, and 710,000 shares outstanding
$3,675,000
Additional paid-in capital
Paid-in capital
KimFin_7e_SET_Ch11.xlsx, Page 6 of 6 Page(s), 4/15/202211:52 AM