Penn foster bookkeeping final project

Financial Accounting, Business Accounting ANd You, Pennfoster , Graded Project

The goal of this graded project is to create the following financial statements for J & L Accounting, Inc.:

Balance sheet

Income statement

Statement of retained earnings

Post-closing trial balance

The financial statements must be created in one Microsoft Word document (.doc or .docx file). Alternatively, an Excel workbook may be used (.xls or .xlsx file). The Word or Excel file will be uploaded for grading.

INSTRUCTIONS

Read the following instructions thoroughly before beginning your work. This will help you to become familiar with what
is involved in the project. Some students start on the project right away, thinking they’ll save time. Those students tend to get stuck and spend more time working through the project than is necessary. The material you need to know in order

to complete the project has been covered in the textbook and the assigned exercises and problems. If you understand the chapters and completed the assigned homework problems, you should have no problem with the project.

The project is to be done by hand with a pencil and paper. Use the blank forms provided. At the end of the project, you’ll be given instructions for creating and uploading the financial statements in a Word or Excel file for grading.

27

Graded Project

Graded Project

Note: The formatting of financial statements is important. They follow Generally Accepted Accounting Principles (GAAP), which creates a uniformity of financial statements for analyz- ing. This allows for an easier comparison, as all businesses follow GAAP. Therefore, the financial statements should be created exactly the same way shown or referenced in the text- book. Failure to do so will result in a loss of points.

The project references “debits equaling credits.” This is a fundamental principle of accounting that mustn’t be violated. Doing so is not acceptable under any circumstance. Debits not equaling credits allows for “cooking of the books,” which is presenting false information. It also allows for embezzlement, which is theft by management or employees. If debits don’t equal credits, the cause may be a lack of understanding of accounting principles, such as those presented in the text- book and assigned homework problems, or a lack of focus and concentration when making journal entries, posting to ledger accounts, or completing math. Remember—instructors are available to help you with material you may be struggling with. Mistakes of the lack-of-focus variety are best corrected by going back over the work until the error is found.

The accounting equation must balance on the balance sheet. This is another fundamental principle of accounting that can’t be violated and if so is completely unacceptable. When the equation doesn’t balance and the numbers are “fudged,” this is easily detectable by someone who knows accounting. If your debits equal your credits and you understand which general ledger accounts belong on which financial state- ments, then the accounting equation should balance. It’s really all about understanding the concepts and applying

that understanding.

The following financial statements are provided from the prior accounting period for J & L Accounting, Inc.:

a) Post-closing trial balance
b) Balance sheet
c) Income statement
d) Statement of retained earnings

28

Financial Accounting

ACCOUNT TITLE

Cash, Business Checking Accounts Receivable Prepaid Rent
Vehicles

Accumulated Depreciation, Vehicles Equipment
Accumulated Depreciation, Equipment Accounts Payable

Common Stock Retained Earnings Dividends
Service Revenue Advertising Expense Rent Expense

Office Supplies Expense Telephone Expense Utilities Expense Depreciation Expense

TOTALS

DEBIT

20,500.00

48,000.00

3,600.00

BALANCE CREDIT

12,000.00

600.00

38,000.00 21,500.00

J & L Accounting, Inc. Post-Closing Trial Balance December 31, 2014

page32image8896 page32image9056 page32image9216
72,100.00

72,100.00

Lesson 2

29

ASSETS

Cash, Business Checking Accounts Receivable Prepaid Rent
Vehicles

Less: Accumulated Depreciation, Vehicles Equipment
Less: Accumulated Depreciation, Equipment

TOTAL ASSETS

LIABILITIES

Accounts Payable

TOTAL LIABILITIES

STOCKHOLDERS’ EQUITY

Common Stock Retained Earnings

TOTAL STOCKHOLDERS’ EQUITY

TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY

48,000.00 12,000.00 3,600.00 600.00

20,500.00 0.00 0.00

36,000.00 3,000.00

59,500.00

0.00

0.00

38,000.00 21,500.00

59,500.00

59,500.00

J & L Accounting, Inc. Balance Sheet
As of December 31, 2014

page33image9992 page33image10152 page33image10312 page33image10472 page33image10632 page33image10792 page33image10952 page33image11112 page33image11272
30

Financial Accounting

REVENUES

Service Revenue

EXPENSES

Advertising Expense Rent Expense
Office Supplies Expense Telephone Expense Utilities Expense Depreciation Expense TOTAL EXPENSES

NET INCOME

10,275.00

J & L Accounting, Inc.
Income Statement
For the Month Ending December 31, 2014

2,300.00 1,000.00 300.00 750.00 3,200.00 1,100.00

8,650.00 1,625.00

page34image6800 page34image6960 page34image7120
Lesson 2

31

Retained Earnings, December 1, 2014 Add: Net Income
Subtotal
Less: Dividends

Retained Earnings, December 31, 2014

19,875.00 1,625.00 21,500.00 0.00 21,500.00

J & L Accounting, Inc. Statement of Retained Earnings
For the Month Ending December 31, 2014

page35image4360 page35image4520 page35image4680 page35image4840
32

Financial Accounting

1)Using the following blank forms (make as many copies
as necessary), set up the general ledger accounts for the general ledger and insert the beginning balances for the accounts from the post-closing trial balance. The balances from the post-closing trial balance become the beginning balances of the accounts for the next account period.

page36image6296
DATE

ITEM

POST REF.

page36image8512 page36image9128
DEBIT

CREDIT

BALANCE

DEBIT

CREDIT

Lesson 2

33

page37image3072
DATE

ITEM

POST REF.

page37image5288 page37image5904
DEBIT

CREDIT

BALANCE

DEBIT

CREDIT

34

Financial Accounting

2) Journalize the following transactions in the general jour- nal using the following blank form (make as many copies as needed). When making journal entries, each individ- ual journal entry’s debits should equal its credits. (The amount for a journal entry can be incorrect or the entry can be incorrect. However, the debits still have to equal the credits even though the entry is incorrect. If the jour- nal entry is incorrect, it can be corrected later when making adjusting/correcting journal entries. For exam- ple, if the amount is supposed to be $1,100, and for some reason the amount of $1,010 is recorded, this is acceptable—although incorrect, it can be corrected later.) The total of the debits must always equal the total of the credits for each journal entry—always. This is a funda- mental GAAP that cannot be violated.

On January 1, 2015, a payment in cash for $12,000 is made for prepaying rent for the entire year 2015.

On January 4, 2015, accounting services are performed and payment is received in cash for the amount of $1,900.

On January 9, 2015, a payment in cash for advertising is made in the amount of $850.

On January 10, 2015, office supplies are purchased in the amount of $75 with cash.

On January 14, 2015, accounting services are performed and payment is received in cash for the amount of $2,725.

On January 20, 2015, the telephone bill for the amount of $660 is received and paid with cash.

On January 20, 2015, the utilities bill for $2,925 is received. The bill won’t be paid until it is due on February 15, 2015.

On January 27, 2015, accounting services are performed on account in the amount of $3,750.

On January 28, 2015, a payment in cash for $1,500 is made for a bill from an advertising agency.

Lesson 2

35

page39image4672
DATE

ACCOUNTS

POST REF.

page39image6888
Dr.

page39image8064
Cr.

36

Financial Accounting

3) Post the general journal entries from the journal to the corresponding general ledger accounts, paying particular attention to the posting being made (debit or credit). Use the Post Ref. column to ensure that each line item of the journal entries is posted correctly to each general ledger account. Posting from the journal to the general ledger is nothing more than rearranging the information. If the debits equal the credits for a particular journal entry and the information is posted correctly, the total of the debits should equal the total of the credits in the general ledger.

4) Calculate the balances in the general ledger accounts. (Use an Excel spreadsheet or a printing calculator, and run the numbers several times for accuracy. Often, deb- its won’t equal credits on the trial balance because a hand-held calculator is used and the math is done only once. Using a hand-held calculator can introduce errors. This is why an Excel spreadsheet is recommended. However, if a hand-held calculator is all that’s available to you, be sure to do the math enough times that you know the cal- culations are accurate.) To calculate the balances in the ledger accounts, you’ll need to do the following:

1) Add the debits.

2) Add the credits.

3) Subtract the larger amount from the other, or, alternatively, keep the running balance of the amount in the account and whether it’s a debit or credit on the ledger.

5) Create an unadjusted trial balance from the balances in the general ledger accounts. (Once again, be very careful when doing the math. When calculating the totals of the debit and credit columns, they should be equal. If not, do not continue until the debits equal the credits. An error has been made and must be found and corrected from the previous steps.) See page 129 of the text for an example of an unadjusted trial balance. Use the following blank form.

Lesson 2

37

ACCOUNT

DEBIT

page41image5032
CREDIT

page41image6096


































38

Financial Accounting

6) Journalize the following adjusting journal entries in the general journal, being sure that the debits equal the credits:

Calculate and make the adjustment for the amount of pre-paid rent that has been used.

Make an adjusting journal entry in the amount of $1,000 for depreciation of the vehicles.

Make an adjusting journal entry in the amount of $100 for depreciation of the equipment.

7) Post the adjusting journal entries to the respective gen-

eral ledger accounts, again being sure that the postings are to the correct debit or credit side and that the Post Ref. column is used.

8) Calculate the new balances in the general ledger accounts. Create an adjusted trial balance from the balances in
the general ledger accounts using the same blank form provided in step 5 when you created the unadjusted trial balance. See Exhibit 3-3 on page 114 in your textbook for an example of an adjusted trial balance. Make sure the math is correct and that the debit column is equal
to the credit column. If not, don’t continue until the error has been found.

9) Create the income statement for J & L Accounting, Inc. using the information from the adjusted trial balance. Use the following blank form to create the income statement. Its format should be the same as the format used for the statement provided at the beginning of the project for the prior accounting period.

Lesson 2

39

page43image976 page43image1136 page43image1296 page43image1456 page43image1616 page43image1776 page43image1936 page43image2096 page43image2256 page43image2416 page43image2576 page43image2736 page43image2896 page43image3056 page43image3216 page43image3376 page43image3536 page43image3696 page43image3856 page43image4016 page43image4176 page43image4336 page43image4496 page43image4656 page43image4816 page43image4976 page43image5136 page43image5296 page43image5456 page43image5616 page43image5776 page43image5936 page43image6096 page43image6256 page43image6416 page43image6576 page43image6736 page43image6896 page43image7056 page43image7216 page43image7376 page43image7536 page43image7696 page43image7856 page43image8016 page43image8176 page43image8336 page43image8496 page43image8656 page43image8816 page43image8976 page43image9136 page43image9296
40

Financial Accounting

10) Create the closing journal entries in the general journal to close the revenue, expense, and dividend accounts to the retained earnings account, paying attention to debits equaling credits.

11) Post the closing journal entries to the respective general ledger accounts.

12) Calculate the balances in the general ledger accounts.

13) Create a post-closing trial balance from the balances
in the general ledger accounts using the same blank form that was provided in step 5 when you created the unadjusted trial balance. The post-closing trial balance should be in the same format as the post-closing trial balance provided at the beginning of the project for the prior accounting period. Make sure the math is correct and that the debit column is equal to the credit column. If not, don’t continue until the error has been found.

14) Create the balance sheet for J & L Accounting, Inc. using the information from the post-closing trial balance. If the debits equal the credits from the previous work and the closing entries were made properly, then the accounting equation should balance on the balance sheet. If the assets don’t equal the liabilities plus stockholders’ equity, an error has been made that needs to be corrected. The bal- ance of the accounting equation is another fundamental GAAP principle that can’t be violated. Use the following form to create the balance sheet. Its format should be the same as the format of the statement provided at the beginning of the project for the prior accounting period.

Lesson 2

41

page45image976 page45image1136 page45image1296 page45image1456 page45image1616 page45image1776 page45image1936 page45image2096 page45image2256 page45image2416 page45image2576 page45image2736 page45image2896 page45image3056 page45image3216 page45image3376 page45image3536 page45image3696 page45image3856 page45image4016 page45image4176 page45image4336 page45image4496 page45image4656 page45image4816 page45image4976 page45image5136 page45image5296 page45image5456 page45image5616 page45image5776 page45image5936 page45image6096 page45image6256 page45image6416 page45image6576 page45image6736 page45image6896 page45image7056 page45image7216 page45image7376 page45image7536 page45image7696 page45image7856 page45image8016 page45image8176 page45image8336 page45image8496 page45image8656 page45image8816 page45image8976 page45image9136 page45image9296
42

Financial Accounting

15) Create the statement of retained earnings for J & L Accounting, Inc. using the ending balance from the statement of retained earnings from the prior period
and the net income from the income statement for the January accounting period. (No dividends were paid out during the month of January.) Follow the same format from the statement of retained earnings at the beginning of the graded project for the prior accounting period using the blank form on the following page.

Having created the balance sheet, the income statement,
the statement of retained earnings, and the post-closing trial balance on the blank forms that were provided, the financial statements must now to be typed up in a Microsoft Word document and saved as a .doc or .docx file. Microsoft Excel can also be used (saving the file with the extension .xls or .xlsx). Each financial statement should be on its own page (or worksheet). The name of the file should include your stu- dent ID number and the graded project exam number, such as “21512345_061579.docx” as an example.

Insert tables in the Word document if you feel you need them to format the financial statements. Alternatively, space and tab in Word to get the formatting of the statements set up correctly. Formatting is important. Also, keep in mind that points will be deducted for incorrect capitalization, spelling, underlining and double underlining, as well as for improper headings, dates, indentations, and columns.

Create all of the financial statements in one file. Submission of more than one file will result in the project being returned as ungraded. Submission of only one file is important for tracking and grading purposes.

Images or scanned images of the financial statements pasted into a Word document will also result in the project being returned as ungraded. This prevents the ability to “mark up” the file, and financial statements that are handwritten are generally considered unprofessional.

Only the financial statements are required. Submitted journals, ledgers, or unadjusted/adjusted trial balances will not be evaluated.

PLAGIARISM

Plagiarism is taking any part of a published piece of work and using it as your own.

Plagiarism is unacceptable at Penn Foster College. This is a reminder of the expectation to which all Penn Foster College students are held. Per your Student Handbook, students are expected to conduct themselves with the highest academic and ethical standards. Failure to do so results in disciplinary action.

Lesson 2

45

GRADING CRITERIA

The grading criteria for the project are as follows:
The formatting of the four financial statements is worth 10

points each for a total of 40 points (4