Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Offering a nice Tip for anyone who completes this :-) just leave your cashapp Overview In previous modules, you examined the initial stages of the

Offering a nice Tip for anyone who completes this :-) just leave your cashapp

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.

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Accounting Data Appendix:

https://pastebin.com/QNaYEUHJ

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Attached Spreadsheet:

https://pastebin.com/Rww2F6aq

https://pastebin.com/RLtA00KH

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Explain how to handle conflict effectively.

Answered: 1 week ago

Question

_ 3x2 + 7x + 11 5 8X3 + X 9

Answered: 1 week ago