7-2 Project: Company Accounting Workbook and Summary Report

Competencies

In this project, you will demonstrate your mastery of the following competencies:

Record and present financial information by applying the appropriate framework and guidelines of accounting for business transactions

Determine asset accounts and their disclosure in the financial statements

Determine liability and equity accounts and their disclosure in the financial statements

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. The business owners have also asked you to summarize the companys performance based on the financial statements.

Directions

Company Accounting Workbook

Use accepted accounting principles to follow and record your business transactions for a three-month period from the first step of the accounting cycle through the reporting process. You will build on your work from Milestones One and Two to complete your workbook using the Company Accounting Workbook Template (linked in the What to Submit section).

Your completed accounting workbook will consist of journal entries for each transaction and postings of transactions to account ledgers. You will develop a trial balance from ledger balances and adjust revenue and expense accounts, as necessary, to ensure that revenues and expenses are reported in the appropriate period under the accrual accounting method. The adjusted trial balance will be used to prepare the income statement, the statement of owners equity, and the balance sheet. After the preparation of the financial statements, closing entries will be entered to transfer earnings to equity and prepare temporary accounts for the new accounting period.

Use the instructions below to complete your workbook.

Record Financial Data: Use accepted accounting principles to accurately capture business transactions for October, November, and December using the data provided in the accounting data appendix (linked in the Supporting Materials section). You will need to address the following:

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 data from the Inventory Valuation tab of the company accounting workbook.

Accrual Basis: Apply the accrual basis of accounting and prepare adjusting entries to ensure accurate accounting for expenses that lack transactions in the current period.

Unadjusted Trial Balance: Prepare the unadjusted trial balance portion of the Trial Balance tab of the company accounting workbook, ensuring that the total debits and credits match.

Adjusting Entries: Prepare the Adjusting Entries tab of the company accounting workbook.

Adjusted Trial Balance: Prepare the adjusted trial balance on the Trial Balance tab, ensuring that the debit and credit totals match.

Financial Statements: Create financial statements using appropriate methods based on accepted accounting principles. Be sure to prepare these financial statements in the order listed, as there are important interdependencies among them.

Income Statement: Prepare the income statement using the adjusted trial balance.

Statement of Owners Equity: Prepare the statement of owners equity using the adjusted trial balance.

Balance Sheet: Prepare the balance sheet using the adjusted trial balance.

Closing Entries: Complete the Closing Entries tab of the company accounting workbook by closing all temporary income statement amounts to create closing entries.

Post-Closing Trial Balance: Prepare the Post-Closing Trial Balance tab of the company accounting workbook in preparation for the next accounting period.

Summary Report

After you have completed preparing all the financial statements, analyze the statements and write a short report summarizing your findings. Use the template provided in the What to Submit section to complete your report.

Summary: Write a summary of what the financial statements indicate about the companys financial health and performance.

Purpose: What kind of information would these financial statements provide to various aspects of the business?

Analysis: What is the companys cash position, its net income as a percentage of sales, and its current liabilities to current assets position?

What to Submit

To complete this project, you must submit the following:

Company Accounting Workbook Spreadsheet

Your workbook should be completed and submitted as a Microsoft Excel file based on the template provided.

Project Summary Report Word Document

Use this template to submit a 1- to 2-page Word document summarizing the financial statements you created.

Supporting Materials

The following resources support your work on the project:

Resource: Accounting Data Appendix Word Document

This resource includes all of the existing financial information needed to complete your project.

Tutorial: Infobase Microsoft Excel Tutorial

This tutorial from Infobase provides helpful information on how to use the basic features of Microsoft Excel. Use the table of contents to select the tutorials that best suit your needs.

Try it now!

Get 20% Discount on This Paper

Type of paper needed:

Pages:

Academic level:

We'll send you the first draft for approval by at

Total price:

$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Ace Writing Center has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At Ace Writing Center, Nowadays, students normally have extremely busy schedules. You will note that some of them have to take on some evening or weekend jobs in order to get some income that can help them to sustain in college or in the university. This can deny them a chance to write all the essays given. Others usually get bombarded with a lot of work by their lecturers. This can still delay such students from working on all their essays. However, some of them usually try to work on all these essays but end up delivering their work late. This can prevent them from graduating since most lecturers are strict on deadlines. If you want to write a business essay, the wise way is to hire an outstanding essay writing service like us, so that you can get the best results. If you are keen, you will note that many companies usually overcharge their customers. Some of them are there only to make money. And in reality, they really don’t care to build a long term commitment with students. You should not choose such companies. You should take your time and choose a reliable company to work with. Ace Writing Center is the ultimate solution for you. We have been offering our writing service for more than 7 years. This is a clear indication that you will get quality essay writing service. We have a wide range of writers who can work on any business essay that you might have. We believe in doing extensive research so that we can provide quality work to all our clients. .

Admissions

Admission and Business Papers

Have you ever had to write an admission essay for college? The majority of students face the same issues when applying to a university or college and many in such situations decide they need professional help to cope with this matter. They get in a situation when the deadline keeps coming closer but lack motivation to start because they are just not sure if their writing skills are strong enough. We have a solution for you! Ace Writing Center is the best admission essay writing service with a large professional team and years of experience in providing high-quality papers to students of all levels and faculties. The mission of our team is to help students make their dreams of entering a good college come true and that’s what we offer!.

Editing

Editing and Proofreading

Sometimes all the words for your paper just flow out of your mind and into your fingers. You type quickly at your keyboard and there they are, your beautiful words right there on the screen. But you have no idea how to polish it up. You may be wishing there was a paper writing service that offered this type of writing service. Look no more! Here at Ace Writing Center, we offer you an editing and proofreading option that you can't find anywhere else..

Coursework

College Essay Writing

In case you are familiar Ace Writing Center, you know the way to distinguish a better company from a cheap one exactly. First of all, poor service website does not have a sufficient support. We think support team is an essential part of success; it has to answer all clients’ questions and be a connecting link between clients and their writers. On our web-service you will get answers about anything you need and your writer will receive all your instructions, assignments and requirements exactly and swiftly. A writing service that we run has got a flexible pricing system that will save you from senseless wastes and many bonus systems that let you sparing money for something important for you.