Kimmel_Accounting_4e_ExcelWorkingPapers_AppE

Kimmel_Accounting_4e_ExcelWorkingPapers_AppE - Name Section...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Name Section Date Appendix E Brief Exercises BEE-1 Date 1 Jan 1 2 3 4 July 1 5 6 7 BEE-2 8 Aug 1 9 10 11 Dec 1 12 13 14 15 BEE-3 16 Dec 31 17 18 19 31 20 21 22 BEE-4 23 Dec 31 24 25 26 27 BEE-5 28 29 30 31 32 33 34 35 BEE-6 36 Date 37 Dec 31 38 39 40 Account Titles Debit Credit Debit Credit Balance Sheet Income Statement Account Titles 544 544 ief Exercises 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 544 544 Name Section Date BEE-7 1 2 3 4 5 6 7 8 9 10 BEE-8 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Appendix E Brief Exercises Concluded Balance Sheet Balance Sheet 545 545 Exercises Concluded 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 545 545 Name Section Date Appendix E Exercises 1 and 2 EE-1 Date 1 (a) 2 Jan 1 3 4 5 July 1 6 7 8 1 9 10 11 12 (b) 13 Dec 31 14 15 Account Titles Debit Credit Account Titles Debit Credit EE-2 Date 1 (a) 2 Feb 1 3 4 5 July 1 6 7 8 Sept 1 9 10 11 12 13 Dec 1 14 15 16 (b) 17 18 19 20 546 546 ises 1 and 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 546 546 Name Section Date Appendix E Exercises 3 and 4 EE-3 Date 1 Jan 1 2 3 4 July 1 5 6 7 Dec 1 8 9 10 11 12 31 13 14 15 Account Titles Debit Credit Account Titles Debit Credit EE-4 Date 1 (a) 2 Jan 1 3 4 5 Dec 31 6 7 8 31 9 10 11 12 (b) 13 14 15 16 17 18 19 20 547 547 x E Exercises 3 and 4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 547 547 Name Section Date Appendix E Exercises 5 and 6 EE-5 Date 1 (a) 2 Mar 18 3 4 5 June 30 6 7 8 Dec 31 9 10 11 12 (b) 13 Jan 1 14 15 16 June 15 17 18 19 Dec 31 20 21 22 Account Titles 2012 Debit Credit Account Titles Debit Credit EE-6 Date 1 (a) 2 Dec 31 3 4 5 6 (b) 7 8 9 10 11 12 13 Balance Sheet Income Statement 548 548 ises 5 and 6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 1 2 3 4 5 6 7 8 9 10 11 12 13 548 548 Name Section Date Appendix E Exercise 7 Lynette, Inc. (a) Date 1 Dec 31 2 3 Account Titles Debit (b) LYNETTE, INC. Balance Sheet (Partial) December 31, 2012 1 2 3 4 5 6 (c) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 549 Credit 549 ppendix E Exercise 7 Lynette, Inc. 1 2 3 1 2 3 4 5 6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 549 549 Name Section Date Appendix E Exercise 8 Redfield Company (a) Date 1 Dec 31 2 3 4 5 Dec 31 6 7 8 Account Titles Trading Securities Debit Available for Sale Securities (b) REDFIELD COMPANY Balance Sheet (Partial) December 31, 2012 1 2 3 4 5 6 7 8 9 10 REDFIELD COMPANY Partial Income Statement For the Year Ended December 31, 2012 1 2 3 4 5 550 Credit 550 E Exercise 8 ld Company 1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 550 550 Name Section Date Appendix E Problem 1 Knuth Farms (a) & (b) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 2012 Jan 1 Account Titles Debit July 1 Dec 31 2015 Jan 1 1 July 1 Dec 31 (b) Dec 31 2012 (c) KNUTH FARMS Partial Balance Sheet December 31, 2012 1 2 3 4 5 6 7 8 551 Credit 551 ppendix E Problem 1 Knuth Farms 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 1 2 3 4 5 6 7 8 551 551 Name Section Date Appendix E Problem 2 Sarah Company (a) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 1 2 3 4 5 6 7 8 9 Date Feb 1 Account Titles Debit Mar 1 Apr 1 July 1 Aug 1 Sept 1 Oct 1 1 STOCK INVESTMENTS DEBT INVESTMENTS 552 Credit 10 552 E Problem 2 ah Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 1 2 3 4 5 6 7 8 9 552 10 552 Name Section Date Appendix E Problem 2 Concluded Sarah Company (b) Security 1 2 3 4 5 6 7 Dec 31 8 9 10 Cost Adjusting Entry (c ) SARAH COMPANY Partial Balance Sheet December 31, 2012 1 2 3 4 5 (d) 1 2 3 4 5 553 Fair Value 553 Problem 2 Concluded Sarah Company 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 1 2 3 4 5 553 553 Name Section Date Appendix E Problem 3 Maxell Associates (a) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 1 2 3 4 5 6 7 Date 2012 July 1 Account Titles Debit Aug 1 Sept 1 Oct 1 Nov 1 Dec 15 31 STOCK INVESTMENTS 2012 Jan 1 Bal. 108,000 554 Credit 554 E Problem 3 ll Associates 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 1 2 3 4 5 6 7 554 554 Name Section Date Appendix E Problem 3 Concluded Maxell Associates (b) Security 1 2 3 4 5 6 7 8 9 Dec 31 10 11 12 Cost Adjusting Entry (c) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 MAXELL ASSOCIATES Partial Balance Sheet December 31, 2012 Assets Liabilities and Stockholders' Equity 555 Fair Value 555 Problem 3 Concluded Maxell Associates 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 555 555 Name Section Date Appendix E Problem 4 Coakley Company Cost Method Date 1 (a) 2 Jan 1 3 4 5 June 30 6 7 8 Dec 31 9 10 11 12 13 14 Account Titles 2012 Debit Credit Equity Method Date 1 (b) 2 Jan 1 3 4 5 June 30 6 7 8 Dec 31 9 10 11 31 12 13 14 15 16 17 18 19 20 21 Account Titles 2012 Debit 556 Credit 556 E Problem 4 ey Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 556 556 Name Section Date Appendix E Problem 4 Concluded Coakley Company (c) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Cost Method 557 Equity Method 557 Problem 4 Concluded Coakley Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 557 557 Name Section Date Appendix E Problem 5 Maple Company (a) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date Jan 20 Account Titles Debit 28 30 Feb 8 18 July 30 Sept 6 Dec 1 (b) 1 2 3 4 5 6 7 8 9 10 11 1/1 Bal. INVESTMENT IN WICKHAM INC. COMMON STOCK 73,500 INVESTMENT IN KERRY CORPORATION COMMON STOCK 1/1 Bal. 84,000 558 Credit 558 E Problem 5 le Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 1 2 3 4 5 6 7 8 9 10 11 558 558 Name Section Date Appendix E Problem 5 Concluded Maple Company (b) (Continued) INVESTMENT IN H. KELSO CORPORATION PREFERRED STOCK 1/1 Bal. 33,600 INVESTMENT IN M. MCLAIN CORPORATION COMMON STOCK (c) Security 1 2 3 4 5 6 Dec 31 7 8 Cost Adjusting Entry (d) 1 2 3 4 5 6 7 8 9 10 11 12 MAPLE COMPANY Partial Balance Sheet December 31, 2012 Assets Liabilities and Stockholder's Equity 559 Fair Value 559 Problem 5 Concluded Maple Company 1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 9 10 11 12 559 559 Name Section Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Appendix E Problem 6 Texton Corporation TEXTON CORPORATION Balance Sheet December 31, 2012 Assets 560 560 E Problem 6 Corporation 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 560 560 Name Section Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Appendix E Problem 6 Concluded Texton Corporation TEXTON CORPORATION Balance Sheet (continued) December 31, 2012 Liabilities and Stockholders' Equity 561 561 Problem 6 Concluded Texton Corporation 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 561 561 ...
View Full Document

Ask a homework question - tutors are online