14 Jan In your final project, you will assume the role of an accountant and complete the year-end adjustment process for your company using a provided workbook. This workbook is the first
Overview: In your final project, you will assume the role of an accountant and complete the year-end adjustment process for your company using a provided workbook. This workbook is the first deliverable (Part I) of your final project. In Part II, you will analyze the provided financials of the same company and create a report documenting your findings.
For your first milestone, you will complete certain portions of the final project workbook as described in the prompt below. You will complete the entire workbook for your next milestone, due in Module Five.
Prompt: Specifically, the following critical elements must be addressed:
- Demonstrate the year-end adjustment process.
- Prepare the adjusting journal entries in the Adjusting Entries tab in the provided workbook.
- Transfer the values from the Adjusting Entries tab to the proper cells of the Adjusting Entries columns in the Worksheet tab.
- Create the adjusted trial balance by completing the Adjusted Trial Balance columns using the Worksheets tab.
- Close temporary accounts by completing the Closing Entries tab.
- Prepare an income statement for your company by completing the Income Statement tab in the provided workbook.
Chart of Accounts
Asset Accounts | Liability Accounts | Equity Accounts | ||||
Acct # | Acct # | Acct # | ||||
Cash | 101 | Notes Payable | 201 | Common Stock | 301 | |
Baking Supplies | 102 | Accounts Payable | 202 | Dividends | 302 | |
Prepaid Rent | 103 | Wages Payable | 203 | |||
Prepaid Insurance | 104 | Interest Payable | 204 | |||
Baking Equipment | 105 | Loans Payable | 205 | |||
Office Supplies | 106 | |||||
Accounts Receivable | 107 | |||||
Accumulated Depreciation | 108 | |||||
Trademark | 109 | |||||
Leasehold Improvements | 110 | |||||
Accumulated Amortization | 111 | |||||
Revenue Accounts | ||||||
This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. | Acct # | |||||
Bakery Sales | 401 | |||||
Merchandise Sales | 402 | |||||
Expense Accounts | ||||||
Acct # | ||||||
Baking Cost of Goods Sold | 501 | |||||
Merchandise Cost of Goods Sold (FIFO) | 502 | |||||
Rent Expense | 503 | |||||
Insurance Expense | 504 | |||||
Misc. Expense | 505 | |||||
Business License Expense | 506 | |||||
Advertising Expense | 507 | |||||
Wages Expense | 508 | |||||
Telephone Expense | 509 | |||||
Interest Expense | 510 | |||||
Depreciation Expense | 511 | |||||
Amortization Expense | 512 | |||||
Office Supplies Expense | 513 |
Worksheet
Peyton Approved | |||||||
Trial Balance | |||||||
2017 | |||||||
Unadjusted trial balance | Adjusting entries | Adjusted trial balance | |||||
Account | Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | 64,713.72 | 64,713.72 | |||||
Baking Supplies | 165,250.00 | 165,250.00 | |||||
Merchandise Inventory (FIFO) | 25,750.00 | 25,750.00 | |||||
Prepaid Rent | 7,500.00 | 7,500.00 | |||||
Prepaid Insurance | 2,400.00 | 2,400.00 | |||||
Baking Equipment | 17,000.00 | 17,000.00 | |||||
Accumulated Depreciation | 3,285.72 | 3,285.72 | |||||
Leasehold Improvements | 10,000.00 | 10,000.00 | |||||
Accumulated Amortization | 2,000.00 | 2,000.00 | |||||
Trademark | 2,300.00 | 2,300.00 | |||||
Office Supplies | 1,600.00 | 1,600.00 | |||||
Accounts Receivable | 30,401.00 | 30,401.00 | |||||
Notes Payable | 10,000.00 | 10,000.00 | |||||
Interest Payable | – 0 | ||||||
Accounts Payable | 27,325.00 | 27,325.00 | |||||
Wages Payable | – 0 | ||||||
Loans Payable | 21,000.00 | 21,000.00 | |||||
Common Stock | 30,000.00 | 30,000.00 | |||||
Dividends | 20,000.00 | 20,000.00 | |||||
Bakery Sales | 335,675.00 | 335,675.00 | |||||
Merchandise Sales | 35,200.00 | 35,200.00 | |||||
Baking Cost of Goods Sold | – 0 | ||||||
Rent Expense | 90,000.00 | 90,000.00 | |||||
Interest Expense | – 0 | ||||||
Insurance Expense | – 0 | ||||||
Depreciation Expense | – 0 | ||||||
Amortization Expense | – 0 | ||||||
Misc. Expense | 2,780.00 | 2,780.00 | |||||
Office Supplies Expense | – 0 | ||||||
Business License Expense | 375.00 | 375.00 | |||||
Advertising Expense | 5,200.00 | 5,200.00 | |||||
Wages Expense | – 0 | ||||||
Telephone Expense | 3,456.00 | 3,456.00 | |||||
Merchandise COGS (FIFO) | 15,760.00 | 15,760.00 | |||||
Total | 464,485.72 | 464,485.72 | – 0 | – 0 | 464,485.72 | 464,485.72 | |
Adjusting Entries
Peyton Approved | ||||
Adjusting Journal Entries | ||||
2017 | ||||
Date | Accounts | Debit | Credit | |
31-Dec | Depreciation Expense | |||
Accumulated depreciation | ||||
31-Dec | Amortization Expense | |||
Accumulated Amortization | ||||
31-Dec | Interest Expense | |||
Interest Payable | ||||
31-Dec | Insurance Expense | |||
Prepaid Insurance | ||||
31-Dec | Baking Cost of Goods Sold | |||
Baking Supplies | ||||
31-Dec | Office Supplies Expense | |||
Office Supplies | ||||
31-Dec | Wages Expense | |||
Wages Payable | ||||
– 0 | – 0 | |||
Income Statement
Peyton Approved | ||||
Income Statement | ||||
For Year Ending 12/31/2017 | ||||
Bakery Sales | ||||
Merchandise Sales | ||||
Total Revenues | – 0 | |||
Merchandise Cost of Goods Sold (FIFO) | ||||
Baking Cost of Goods Sold | ||||
Gross Profit | – 0 | |||
Operating Expenses: | ||||
Rent Expense | ||||
Interest Expense | ||||
Insurance Expense | ||||
Depreciation Expense | ||||
Amortization Expense | ||||
Misc. Expense | ||||
Office Supplies Expense | ||||
Business License Expense | ||||
Advertising Expense | ||||
Wages Expense | ||||
Telephone Expense | ||||
Total Operating Expenses: | – 0 | |||
Net Income | – 0 | |||
Closing Entries
Peyton Approved | ||||
Closing Entries | ||||
For Year Ending 12/31/2017 | ||||
Date | Accounts | Debit | Credit | |
31-Dec | Bakery Sales | |||
Merchandise Sales | ||||
Income Summary | – 0 | |||
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. About WridemyWe are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It WorksTo make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts?All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first orderRelated TagsAcademic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA |