College Pal
Connecting to a pal for your paper
  • Home
  • Place Order
  • My Account
    • Register
    • Login
  • Confidentiality Policy
  • Samples
  • How It Works
  • Guarantees

Sms or Whatsapp only : US:+12403895520

 

email: [email protected]
August 9, 2022

In previous modules, you examined the initial stages of the accounting cycle and practiced journalizing financial transactions. In Milestone One, you will complete the first part of your co

Uncategorized

 

Overview

In previous modules, you examined the initial stages of the accounting cycle and practiced journalizing financial transactions. In Milestone One, you will complete the first part of your course project to demonstrate your ability to accurately record financial data, which will continue to be used to complete other parts of the project.

Scenario

You are a certified public accountant (CPA) who is working with a small bakery to prepare their financial statements for three months of the current fiscal year. Because the company is a startup and so small, the accounting is done manually in Microsoft Excel. You have been given the accounts and information you need to prepare their financial statements, but you will need to use the accounting cycle to report accurate information to the finance department.

Prompt

Record Financial Data: Use accepted accounting principles to accurately capture business transactions for October, November, and December in the Company Accounting Workbook Template Spreadsheet using the data provided in the Accounting Data Appendix Word Document.

Specifically, you must address the following rubric criteria:

  • Accuracy: Prepare entries that are accurate in that they fully reflect the appropriate information.
  • Completeness: Prepare entries that are complete for each month, including transferring posted entries to T accounts.
  • Inventory Valuation: Prepare entries for the month of December to reflect the new line of products offered by the company, which includes using the entries from the “Inventory Valuation” tab to complete your journal for the month of December.

Guidelines for Submission

Using the provided template, submit your company accounting workbook with the following portions completed: October, November, and December journal entries; the “T Accounts” tab; and the “Inventory Valuation” tab. This should be completed and submitted using Microsoft Excel. Please note that there are drop-down menus embedded in the “Accounts” columns as well as formulas throughout the spreadsheet to help you complete the workbook without accidentally introducing errors.

  • attachment

    ACC201AccountingDataAppendix11.docx

  • attachment

    ACC201CompanyAccountingWorkbookTemplate1.xlsx

SNHU logo

Accounting Data Appendix

1. The following events occurred in October:

October 1: The business owner used $25,000 from their personal savings account to buy common stock in their company.

October 1: Purchased $8,500 worth of baking supplies from vendor, on account.

October 3: The company borrowed $10,000 in cash, in exchange for a two-year, 6% note payable. Interest and the principal are repayable at maturity.

October 7: Entered into a lease agreement for bakery space. The agreement is for one year. The rent is $1,500 per month; the last month’s rent payment of $1,500 is required at the time of the lease agreement. The payment was made in cash. Lease period is effective October 1 of this year through September 30 of the next.

October 10: Paid $375 to the county for a business license.

October 11: Purchased a cash register for $250 (deemed to be not material enough to qualify as depreciable equipment).

October 13: The owner has baking equipment, including an oven and mixer, which they have been using for their home-based business and will now start using in the bakery. You estimate that the equipment is currently worth $5,000, and you transfer the equipment into the business in exchange for additional common stock. The equipment has a five-year useful life.

October 13: Paid $200 for business cards and flyers to use for advertising.

October 14: Paid $300 for office supplies.

October 15: Hired a part-time helper to be paid $12 per hour. One pay period is the first of the month through the fifteenth, and the other is the sixteenth through the end of the month. Paydays are the twentieth for the first pay period and the fifth of the following month for the second pay period. (No entry required on this date—for informational purposes only.)

October 30: Received telephone bill for October in amount of $75. Payment is due on November 10.

October 31: Paid $1,200 for a 12-month insurance policy. Policy effective dates are November 1 through October 31.

October 31: Accrued wages earned for employee for period of October 16 through October 31. (See Wage Calculation Data table at the end of this document.)

October 31: Total October bakery sales were $15,000 ($5,000 of these sales on accounts receivable).

2. The following events occurred in November:

November 5: Paid employee for period ending October 31.

November 8: Received payments from customers toward accounts receivable in amount of $3,800.

November 10: Paid October telephone bill.

November 15: Purchased additional baking supplies in amount of $5,000 from vendor, on account.

November 15: Accrued wages earned for employee from period of November 1 through November 15. (See Wage Calculation Data table at the end of this document.)

November 15: Paid rent on bakery space.

November 18: Received payments from customers toward accounts receivable in amount of $1,000.

November 20: Paid $8,500 toward baking supplies vendor payable.

November 20: Paid employee for period ending November 15.

November 22: Purchased $300 in office supplies.

November 30: Received telephone bill for November in amount of $75. Payment is due on December 10.

November 30: Accrued wages earned for employee for period of November 16 through November 30. (See Wage Calculation Data table at the end of this document.)

November 30: November bakery sales total was $20,000 ($7,500 of this total on accounts receivable).

3. Many customers have been asking for more allergy-friendly products, so in December the bakery started carrying a line of gluten-free products on a trial basis. The information below relates to the purchase and sales of the new products.

Use the perpetual inventory method with the FIFO valuation method. Please see the “Inventory Valuation” tab in your workbook for purchase and sales information.

The following events occurred in December:

December 1: Paid dividends to self in amount of $10,000.

December 5: Paid employee for period ending November 30.

December 7: Purchased merchandise for resale. See the “Inventory Valuation” tab for details.

December 8: Received payments from customers toward accounts receivable in amount of $4,000.

December 10: Paid November telephone bill.

December 11: Purchased baking supplies in amount of $7,000 from vendor on account.

December 13: Paid on supplies vendor account in amount of $5,000.

December 15: Accrued employee wages for period of December 1 through December 15.

December 15: Paid rent on bakery space $1,500.

December 15: Recorded merchandise sales transaction. See the “Inventory Valuation” tab for details.

December 15: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details.

December 20: Paid employee for period ending December 15.

December 20: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details.

December 24: Recorded sales of merchandise to customers. See the “Inventory Valuation” tab for details.

December 24: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details.

December 30: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details.

December 31: Accrued employee wages for period of December 16 through December 31.

December 31: Total December bakery sales were $25,000 ($6,000 of these sales on accounts receivable).

4. On December 31, the following adjustments must be made:

· Depreciation of baking equipment transferred to company on October 13. Assume half month of depreciation in October using the straight-line method. Assume no salvage value.

· Accrue interest for note payable. Assume a full month of interest for October. (6% annual interest on $10,000 loan)

· Record insurance used for the year.

· Actual baking supplies on hand as of December 31 are $1,100.

· Office supplies on hand as of December 31 are $50.

Wage Calculation Data

Month

Hours

Rate

Pay

31-Oct

10

12

120

15-Nov

40

12

480

30-Nov

35

12

420

15-Dec

38

12

456

31-Dec

40

12

480

,

Chart of 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.
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 Cost of Goods Sold 303
Prepaid Insurance 104 Interest Payable 204
Baking Equipment 105
Office Supplies 106
Accounts Receivable 107
Accumulated Depreciation 108
Merchandise Inventory 109 Revenue Accounts
Acct #
Bakery Sales 401
Merchandise Sales 402
Expense Accounts
Acct #
Baking Supplies Expense 501
Rent Expense 502
Insurance Expense 503
Misc. Expense 504
Business License Expense 505
Advertising Expense 506
Wages Expense 507
Telephone Expense 508
Interest Expense 509
Depreciation Expense 510
Office Supplies Expense 511
Cash
Baking Supplies
Prepaid Rent
Prepaid Insurance
Baking Equipment
Office Supplies
Accounts Receivable
Accumulated Depreciation
Merchandise Inventory
Notes Payable
Accounts Payable
Wages Payable
Interest Payable
Common Stock
Dividends
Bakery Sales
Merchandise Sales
Baking Supplies Expense
Rent Expense
Insurance Expense
Misc. Expense
Business License Expense
Advertising Expense
Wages Expense
Telephone Expense
Interest Expense
Depreciation Expense
Office Supplies Expense
Cost of Goods Sold

October Journal Entries

A Company
General Journal Entries
October, 20xx
Date Accounts Debit Credit
1-Oct $
$
1-Oct
3-Oct
7-Oct
10-Oct
11-Oct
13-Oct
13-Oct
14-Oct
30-Oct
31-Oct
31-Oct
31-Oct
Total – 0 – 0 <== Do the debits equal the credits? (they should)

November Journal Entries

A Company
General Journal Entries
November, 20xx
Date Accounts Debit Credit
Total – 0 – 0 <== Do the debits equal the credits? (they should)

December Journal Entries

A Company
General Journal Entries
December, 20xx
Date Accounts Debit Credit
Be sure to review the Inventory Valuation tab (Columns M-P) for all Inventory related journal entries as they are given to you!
Total – 0 – 0 <== Do the debits equal the credits? (they should)

Inventory Valuation

FIFO
Purchases Sales Ending Inventory Purchases
Date No. of Items Unit Price Total Price No. of Items Unit Price Total Price No. of Items Unit Price Total Price Date Microsoft: Below are the journal entries for each inventory related transaction! All you need to do is copy and paste it into the correct dates on the December Journal tab! Dr Cr 12/7: 10 boxes purchased at $6
7-Dec 10 $ 6.00 $ 60.00 10 $ 6.00 $ 60.00 7-Dec Merchandise Inventory (10 x $6) 60.00 12/20: 20 boxes purchased at $6.10
Cash 60.00 12/30: 25 boxes purchased at $6.05
15-Dec 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 Purchased inventory Sales – selling price, $8.50 a box
12/15: 8 boxes
20-Dec 20 $ 6.10 $ 122.00 2 $ 6.00 $ 12.00 15-Dec Cash (8 x $8.50) 68.00 12/24: 18 boxes
20 $ 6.10 $ 122.00 Merchandise Sales Revenue 68.00
22 $ 134.00 Record sale of inventory
24-Dec 2 $ 6.00 $ 12.00 15-Dec Cost of Goods Sold (8 X $6) 48.00
16 $ 6.10 $ 97.60 4 $ 6.10 $ 24.40 Merchandise Inventory 48.00
18 $ 109.60 Recorded the cost of goods sold
30-Dec 25 $ 6.05 $ 151.25 4 $ 6.10 $ 24.40 20-Dec Merchandise Inventory (20 x $6.10 ) 122.00
25 $ 6.05 $ 151.25 Cash 122.00
29 $ 175.65
Net Inventory 55 $ 333.25 26 $ 157.60 29 $ 175.65 24-Dec Cash (18 x 8.50) 153.00
Merchandise Sales Revenue 153.00
Record sale of inventory
24-Dec Cost of Goods Sold (2 x $6)+(16 x $6.10) 109.60
Merchandise Inventory 109.60
Recorded the cost of goods sold
30-Dec Merchandise Inventory (25 x $6.05) 151.25
Cash 151.25

T-Accounts – autofill

date Cash date date Notes Payable date Business License exp Common Stock
1-Oct $ $ – 0 3-Oct 10-Oct $ – 0 $ 1-Oct
3-Oct $ – 0 $ – 0 13-Oct
$ – 0 7-Oct $ – 0 $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
$ – 0 10-Oct $ – 0 $ – 0 $ – 0
$ – 0 11-Oct
$ – 0 13-Oct
$ – 0 14-Oct
$ – 0 31-Oct
31-Oct $ – 0
$ – 0 5-Nov
8-Nov $ – 0
$ – 0 10-Nov
18-Nov $ – 0
$ – 0 15-Nov
$ – 0 20-Nov Accounts Rec.
$ – 0 20-Nov 31-Oct – 0
$ – 0 22-Nov – 0 8-Nov
30-Nov $ – 0 – 0 18-Nov
$ – 0 1-Dec 30-Nov – 0
$ – 0 5-Dec – 0 8-Dec
$ – 0 7-Dec 31-Dec – 0
8-Dec $ – 0
$ – 0 10-Dec $ – 0 $ – 0
$ – 0 13-Dec $ – 0
$ – 0 15-Dec
15-Dec $ – 0
$ – 0 20-Dec
$ – 0 20-Dec
24-Dec $ – 0
$ – 0 30-Dec
31-Dec $ – 0
$ – 0 $ – 0
$ – 0
Misc. expense Baking equipment Advertising expense
11-Oct $ – 0 13-Oct $ – 0 13-Oct $ – 0
$ – 0 $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
$ – 0 $ – 0 $ – 0
Baking supplies Office supplies Rent expense
1-Oct $ – 0 14-Oct $ – 0 7-Oct $ – 0
15-Nov $ – 0 22-Nov $ – 0 15-Nov $ – 0
11-Dec $ – 0 15-Dec $ – 0
$ – 0 $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
$ – 0 $ – 0 $ – 0
Prepaid rent Prepaid insurance Bakery Sales
7-Oct $ – 0 31-Oct $ – 0 $ – 0 31-Oct
$ – 0 30-Nov
$ – 0 31-Dec
$ – 0 $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
$ – 0 $ – 0 $ – 0
Accounts payable Salary and wages expense Salaries and wages payable
$ – 0 1-Oct 31-Oct $ – 0 $ – 0 31-Oct
$ – 0 31-Oct 15-Nov $ – 0 5-Nov $ – 0
10-Nov $ – 0 30-Nov $ – 0 $ – 0 15-Nov
$ – 0 15-Nov 15-Dec $ – 0 20-Nov $ – 0
20-Nov $ – 0 31-Dec $ – 0 $ – 0 30-Nov
$ – 0 30-Nov 5-Dec $ – 0
10-Dec $ – 0 $ – 0 $ – 0 $ – 0 15-Dec
$ – 0 11-Dec $ – 0 20-Dec $ – 0
13-Dec $ – 0 $ – 0 31-Dec
$ – 0 $ – 0
$ – 0
$ – 0 $ – 0
$ – 0
Telephone expense Dividends COGS
30-Oct $ – 0 1-Dec $ – 0 15-Dec $ – 0
30-Nov $ – 0 $ – 0 $ – 0 24-Dec $ – 0
$ – 0 $ – 0 $ – 0 $ – 0 $ – 0
$ – 0 $ – 0
Merchandise Sales Revenue Merch. Inv. FIFO
$ – 0 15-Dec 7-Dec $ – 0
$ – 0 24-Dec $ – 0 15-Dec
20-Dec $ – 0
$ – 0 $ – 0 $ – 0 24-Dec
$ – 0 30-Dec $ – 0
$ – 0 $ – 0
$ – 0

Adjusting Entries

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Fraud is intentional deceit or trickery that results in a misstatement of the financial statements. Management is responsible for taking steps to reduce the risk of fraud. After quite a few On the morning of September 11, 2001, two airplanes, American Airlines Flight 11 and United Airlines Flight 175, collided into the north and south towers (the main Twin Towers?) of the Worl

Related Posts

Uncategorized

Unit 2: Common Assessment/Project Part A Start Assignment

Uncategorized

Person-Centered and Experiential Therapy

Uncategorized

Read the Instructions for the Population Health Assessment & Prevention ?Download Instructions for the Population Health Assessment & Prevention

Why Choose Us

Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices

At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that?

Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals.

We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science.

Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles.

They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers.

They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases.

Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count.

Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top.

From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications.

Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work.

How Our Website Works

Get an Essay from Us

College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients.

Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE.

Step 1
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. 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. Deadline range from 6 hours to 30 days.

Step 2
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Pricing and Discounts
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.

Recent Posts

  • Cluster Analysis Problem
  • Building a Resume
  • DeSigning a Nursing Informatics Project for Your Organization
  • Creating a Skill Development Plan
  • The purpose of this assignment is to strengthen your research skills, enhance your presentation skills, and expand your knowledge
College Pal

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

A Company
Adjusting Journal Entries
20XX
Date Accounts Debit Credit
31-Dec Depreciation Expense
Accumulated Depreciation
<== Interest adjustment goes here
<== Interest adjustment goes here
<== Insurance adjustment goes here
<== Insurance adjustment goes here
<== Baking supplies adjustment goes here