I need help creating the following from the data below:

1. July Journal
2. August Journal
3. September Journal
4. T accounts
5. Trial Balance
6. Adjusting entries
7. Income Statement
8. Statement of retained earnings
9. Balance Sheet
10. Closing Entries
11. Post-Closing Trial Balance
12. Reversing Entries

Overview: In this milestone, you will move through the first four steps of Final Project I by creating the monthly journal entries and general ledger accounts in

your accounting workbook. The monthly journal entries are how businesses input financial activities into their accounting systems. The values from these entries

are posted to the general ledger.

Prompt: Your dog, Peyton, has severe allergies and cannot have the usual store-bought dog treats. You have been making homemade treats for him that are allnatural and hypoallergenic. Over the past year, you have been making and selling these treats out of your home, and you have been quite successful. You now

have an opportunity to open your own dog treat bakery. You have decided on a corporate form of business and have named your company Peyton Approved.

To complete Milestone One, use accepted accounting principles to follow and record your business transactions for a three-month period. You will find the

provided data for your workbook in the appendix at the end of this document. The data have been separated from the prompt so that you can more easily view

the full scope of the assignment. Links have been provided to help you locate the information you need as you move through each step.

Specifically, the following critical elements must be addressed:

I. Record financial data that accurately captures business transactions according to accepted accounting principles.

A. Step One: Complete the July Journal Entries tab in your workbook using the Step One data in the appendix.

B. Step Two: Complete the August Journal Entries tab in your workbook using the Step Two data in the appendix.

C. Step Three: Complete the September Journal Entries tab in your workbook using the Step Three data and updated scenario information in the

appendix. Note that there was an additional line of products added this month, so you must first complete the Inventory Valuation tab in your

workbook and then copy the journal entries from the inventory evaluation page into your journal for this month to ensure the impact of

merchandising is reflected in your reporting.

The following critical element is not graded:

D. Step Four: Transfer posted entries to T accounts.

Rubric

Guidelines for Submission: Your completed accounting workbook should have all tabs fully and accurately populated in the provided Excel template.

Critical Elements Evident (100%) Not Evident (0%) Value

Record Financial Data: Step One Completes the July Journal Entries tab Does not complete the July Journal Entries

tab

33.33

Record Financial Data: Step Two Completes the August Journal Entries tab Does not complete the August Journal

Entries tab

33.33

Record Financial Data: Step Three Completes the September Journal Entries tab Does not complete the September Journal

Entries tab

33.34

Total 100%

Appendix: Workbook Data for Milestone One

Step One Data (Click on the link to return to the prompt.)

The following events occur in July, 2018:

July 1: You take $10,000 from your personal savings account and buy common stock in Peyton Approved.

July 1: Purchase $6,500 in baking supplies from vendor, on account.

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

July 7: Enter into a lease agreement for bakery space. The agreement is for 1 year. The rent is $1,500 per month, and the last months rent payment of

$1,500 is required at time of lease agreement. The payment was made in cash. Lease period is effective July 1, 2018, through June 30, 2019.

July 10: Pay $375 to the county for a business license.

July 11: Purchase a cash register for $250 (deemed to be not material enough to qualify as depreciable equipmentuse misc. exp.).

July 13: You have baking equipment, including an oven and mixer, which you have been using for your home-based business and will now start using in

the bakery. You estimate that the equipment is currently worth $6,000, and you transfer the equipment into the business in exchange for additional

common stock. The equipment has a 5-year useful life.

July 13: Pay $200 for business cards/flyers/posters/ads to use for advertising.

July 14: Pay $300 for office supplies.

July 15: Hire part-time helper to be paid $12 per hour. Pay periods are the 1st through the 15th and 16th through the end of the month, with paydays

being the 20th for the first pay period and the 5th of the following month for the second pay period. (No entry is required on this date; it is here for

informational purposes only.)

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

July 31: Pay $2,400 for a 12-month insurance policy. Policy effective dates are August 1, 2018, through July 31, 2019.

July 31: Accrue wages earned for employee for period of 16th through 31st of July (Wage calculations table provided below).

July 31: Total July bakery sales were $15,000. $5,000 of these sales are on accounts receivable.

Step Two Data (Click on the link to return to the prompt.)

The following events occur in August, 2018:

August 5: Paid employee for period ending 7/31.

August 8: Receive payments from customers towards accounts receivable in amount of $3,800.

August 10: Paid July telephone bill.

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

August 15: Accrue wages earned for employee from period of 1st through 15th of August (Wage calculations table provided below).

August 15: Pay rent on bakery space.

August 18: Receive payments from customers towards accounts receivable in amount of $3,000.

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

August 20: Pay employee for period ending 8/15.

August 22: $300 in office supplies purchased.

August 31: Received telephone bill for August in amount of $75. Payment is due on September 10.

August 31: Accrue wages earned for employee for period of August 16th through August 31st (Wage calculations table provided below).

August 31: August bakery sales total $20,000. $7,500 of this total is on accounts receivable.

Step Three (Click on the link to return to the prompt.)

Updated Scenario: Many customers have been asking for more hypoallergenic products, so in September you start carrying a line of hypoallergenic shampoos on

a trial basis. The following information relates to the purchase and sales of the shampoo:

You use the perpetual inventory method. Although you could use the following valuation methods FIFO, LIFO, or weighted average, you choose to use

the FIFO method.

Data: The following events occur in September, 2018:

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

September 5: Pay employee for period ending 8/31.

September 7: Purchase merchandise for resale. See Inventory Valuation tab for details.

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

September 10: Pay August telephone bill.

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

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

September 15: Accrue employee wages for period of September 1 through September 15.

September 15: Pay rent on bakery space: $1,500.

September 15: Record merchandise sales transaction. See Inventory Valuation tab for details.

September 15: Record impact of sales transaction on COGS and the inventory asset. See Inventory Valuation tab for details.

September 20: Pay employee for period ending 9/15.

September 20: Purchase merchandise inventory for resale to customers. See Inventory Valuation tab for details.

September 24: Record sales of merchandise to customers. See Inventory Valuation tab for details.

September 24: Record impact of sales transaction on COGS and the inventory asset. See Inventory Valuation tab for details.

September 30: Purchase merchandise inventory for resale to customers. See Inventory Valuation tab for details.

September 30: Accrue employee wages for period of September 16th through September 30th

September 30: Total September bakery sales are $20,000. $6,000 of these sales are on accounts receivable.

Wage calculation data:

Month Hours Rate Pay

31 Jul. 10 12 120

15 Aug. 40 12 480

31 Aug. 35 12 420

15 Sep. 38 12 456

30 Sep. 40 12 480

FIFO USE THIS ONE FOR THE SEPTEMBER ENTRIES Date Purchases 7-Sep 10 $ 6.00 $ 60.00 Sales Dr Cr Ending Inventory 6.00 $ 60.00 10 $ 60.00 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 Purchases 9/7: 10 bottles purchased at $6 9/20: 20 bottles purchased at $6.10 9/30: 25 bottles purchased at $6.05 Sales - selling price, $8.50 a bottle 9/15: 8 bottles 9/24: 18 bottles 15-Sep 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 20-Sep 20 $ 6.10 $ 122.00 68.00 2 $ 20 $ 22 6.00 $ 6.10 $ 12.00 122.00 134.00 15-Sep Cash (8 x $8.50) Merchandise Sales Record sale of inventory 68.00 $ 24-Sep 48.00 2 $ 16 $ 6.00 $ 6.10 $ 12.00 97.60 109.60 4 $ 6.10 $ 24.40 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Recorded the cost of goods sold 48.00 30-Sep 25 $ 6.05 $ 151.25 122.00 4 $ 25 $ 20-SepMerchandise Inventory (20 x $6.10 ) Cash 122.00 6.10 $ 24.40 6.05 $ 151.25 $ 175.65 $ 175.65 29 55 $ 333.25 26 $ 157.60 29 153.00 24-Sep Cash (18 x 8.50) Merchandise Sales Record sale of inventory 153.00 109.60 24-Sep Cost of Goods Sold (2 x $6)+(16 x $6.10) Merchandise Inventory Recorded the cost of goods sold 109.60 151.25 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 LIFO Sales 60.00 Purchases 10 $ 6.00 $ Ending Inventory 10 $ 6.00 $ 60.00 7-Sep 60.00 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 15-Sep 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 68.00 20-Sep 20 $ 6.10 $ 122.00 15-Sep Cash (8 x $8.50) Merchandise Sales Record sale of inventory 2 $ 6.00 $ 12.00 20 $ 6.10 $ 122.00 22 $ 134.00 68.00 48.00 24-Sep 18 $ 6.10 $ 109.80 12.00 15-Sep Cost of Goods Sold (8 x $6) Merchandise Inventory Record inventory reduction due to sale 2 $ 6.00 $ 2 $ 6.10 $ 4 $ 48.00 12.20 24.20 122.00 20-Sep Merchandise Inventory (20 x $6.10) Cash 30-Sep 25 $ 6.05 $ 151.25 122.00 2 $ 6.00 $ 12.00 2 $ 6.10 $ 12.20 25 $ 6.05 $ 151.25 29 $ 175.45 29 $ 175.45 153.00 24-Sep Cash (18 x 8.50) Merchandise Sales Record sale of inventory 153.00 55 $ 333.25 26 $ 157.80 109.80 24-Sep Cost of Goods Sold (18 x $6.10) Merchandise Inventory Record inventory reduction due to sale 109.80 151.25 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 Sales 60.00 weighted average 7-Sep Purchases 10 $ 6.00 $ Ending Inventory 10 $ 6.00 $60 60.00 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 15-Sep 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 68.00 20-Sep 20 $ 6.10 $ 122.00 15-Sep Cash (8 x $8.50) Merchandise Sales Record sale of inventory 2 $ 6.00 $ 12.00 20 $ 6.10 $ 122.00 per unit 22 $ 134.00 $6.09 68.00 48.00 24-Sep 18 $ 6.09 $ 109.62 4 $ 24.38 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Record inventory reduction due to sale 48.00 30-Sep 25 $ 6.05 $ 151.25 4 $ 25 $ 6.05 $ 151.25 29 $ 151.25 $5.22 122.00 20-Sep Merchandise Inventory (20 x $6.10) Cash 55 $ 333.25 26 157.62 122.00 153.00 24-Sep Cash (18 x 8.50) Merchandise Sales Record sale of inventory 153.00 109.62 24-Sep Cost of Goods Sold (18 x $6.09) Merchandise Inventory Record inventory reduction due to sale 109.62 151.25 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25