Answer & Explanation:ACC-120.PDF PR 11-4 B-Hamilton.xlsx There is a spreadsheet that you can use as the format. I started putting some info in. The Pr 11-4B is the spreadsheet you will use and the other paper is the assignment. You are just doing PR 11-4B. Thanks in advance. Someone that knows what they are doing, will be able to do it in no time.
pr_11_4_b_hamilton.xlsx
acc_120.pdf
acc_120.pdf
pr_11_4_b_hamilton.xlsx
Unformatted Attachment Preview
Problem 11-4B
Name:
Section:
Score:
Key Code:
Angela Hamilton
ACC-120
41%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. In T accounts, only final balances will be graded.
Enter a zero for the final balance if appropriate.
1., 2.
Common Stock
Jan. 1 Bal.
3.100.000
15.500.000
Jan. 1 Bal.
Treasury Stock
288.000
300.000
Dec. 31 Bal.
Dec. 31 Bal.
Paid-In Capital from Sale of Trea
Paid-In Capital in Excess of Stated Value
Jan. 1 Bal.
1.240.000
Stock Dividends Distribut
Dec. 31 Bal.
Retained Earnings
Jan. 1 Bal.
4.875.000
775.000
Dec. 31 Bal.
Stock Dividends
288.000
0
Dec. 31 Bal.
Cash Dividends
Dec. 31 Bal.
2.
Jan. 15
Cash Dividends Payable
Cash
Mar. 15
Cash
Treasury Stock
Paid-In Capital from Sale of Treasury Stock
234.775
0
3.
Apr. 13
Cash
Common Stock
Paid-In Capital in Excess of Stated Value
June 14
Stock Dividends
Stock Dividends Distributable
Paid-In Capital in Excess of Stated Value
July 16
Stock Dividends Distributable
Common Stock
Oct. 30
Treasury Stock
Cash
Dec. 30
Cash Dividends
Cash Dividends Payable
31
Income Summary
Retained Earnings
31
Retained Earnings
Stock Dividends
Cash Dividends
NAV-GO ENTERPRISES INC.
Retained Earnings Statement
For the Period Ended December 31, 2014
Retained earnings (January 1, 2014)
Net income
Less: Cash dividends
Stock dividends
Increase in retained earnings
Retained earnings (December 31, 2014)
4.
NAV-GO ENTERPRISES INC.
Balance Sheet
December 31, 2014
Stockholders’ Equity
Paid-in capital:
Common stock, $8 stated value
(900,000 shares authorized, 844,600 shares issued)
$ 4.875.000
$
775.000
Excess of issue price over stated value
From sale of treasury stock
Total paid-in capital
Retained earnings
Total
Deduct treasury stock (50,000 shares at cost)
Total stockholders’ equity
Treasury Stock
Capital from Sale of Treasury Stock
Dec. 31 Bal.
tock Dividends Distributable
Dec. 31 Bal.
0
Stock Dividends
288.000
Cash Dividends
234.775
Problem 11-4B
Name:
Section:
Score:
Key Code:
Angela Hamilton
ACC-120
41%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. In T accounts, only final balances will be graded.
Enter a zero for the final balance if appropriate.
1., 2.
Common Stock
Jan. 1 Bal.
3,100,000
15,500,000
Jan. 1 Bal.
Treasury Stock
288,000
300,000
Dec. 31 Bal.
Dec. 31 Bal.
Paid-In Capital from Sale of Trea
Paid-In Capital in Excess of Stated Value
Jan. 1 Bal.
1,240,000
Stock Dividends Distribut
Dec. 31 Bal.
Retained Earnings
Jan. 1 Bal.
4,875,000
775,000
Dec. 31 Bal.
Stock Dividends
288,000
0
Dec. 31 Bal.
Cash Dividends
Dec. 31 Bal.
2.
Jan. 15
Cash Dividends Payable
Cash
Mar. 15
Cash
Treasury Stock
Paid-In Capital from Sale of Treasury Stock
234,775
0
3.
Apr. 13
Cash
Common Stock
Paid-In Capital in Excess of Stated Value
June 14
Stock Dividends
Stock Dividends Distributable
Paid-In Capital in Excess of Stated Value
July 16
Stock Dividends Distributable
Common Stock
Oct. 30
Treasury Stock
Cash
Dec. 30
Cash Dividends
Cash Dividends Payable
31
Income Summary
Retained Earnings
31
Retained Earnings
Stock Dividends
Cash Dividends
NAV-GO ENTERPRISES INC.
Retained Earnings Statement
For the Period Ended December 31, 2014
Retained earnings (January 1, 2014)
Net income
Less: Cash dividends
Stock dividends
Increase in retained earnings
Retained earnings (December 31, 2014)
4.
NAV-GO ENTERPRISES INC.
Balance Sheet
December 31, 2014
Stockholders’ Equity
Paid-in capital:
Common stock, $8 stated value
(900,000 shares authorized, 844,600 shares issued)
$ 4,875,000
$
775,000
Excess of issue price over stated value
From sale of treasury stock
Total paid-in capital
Retained earnings
Total
Deduct treasury stock (50,000 shares at cost)
Total stockholders’ equity
Treasury Stock
Capital from Sale of Treasury Stock
Dec. 31 Bal.
tock Dividends Distributable
Dec. 31 Bal.
0
Stock Dividends
288,000
Cash Dividends
234,775
…
Purchase answer to see full
attachment
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more