Prepare journal entries for all the transactions

Reference no: EM132301068

Question: Prepare financial statements using the attached excel file. All data is in the excel file.

Computer Depot is a major computer store chain with locations across North America, Europe, and Africa. The company is preparing to report on business transactions that occurred during January.

Download the Excel spreadsheet for Computer Depot in the module folder. The spreadsheet includes the following tabs:

1. Transactions - Details the transactions that occurred in the month of January

2. Journal - General journal for the company

3. Ledger - General ledger for relevant accounts

4. Trial Balance - Template for unadjusted and adjusted trial balances

5. IS - Income Statement template

6. SE - Statement of Stockholders' Equity template

7. BS - Balance Sheet template

8. CF - Statement of Cash Flows template.

Required: Part A: • Prepare journal entries for all the transactions occurring in January

• Post entries to the general ledger

• Prepare the unadjusted trial balance as of January 31st

• Prepare adjusting entries at January 31st

• Post adjusting entries to the general ledger

• Prepare the adjusted trial balance as January 31st

• Prepare and post closing entries and prepare trial balance at February 1st

• Prepare the four primary financial statements on January 31st

• Include a ratio analysis of your company and include the industry averages. Calculate at least one ratio from each category listed: Liquidity, Solvency, and Profitability, and provide an explanation on what it means to the company.

Part B: In your current position as financial accounting manager, it is your turn to present the financial statements at the monthly leadership meeting. Prepare a PowerPoint presentation (at least four slides but) analyzing the company's financial performance for the month of January.

Information related to above question is enclosed below:

Attachment:- ExerciseFile_Computer_Depot.rar

Reference no: EM132301068

Questions Cloud

Most critical thing to consider when forming a team : Explain how this may or may not be different from what you thought prior to your reading. Give an example of a time when you were on a team that was well formed

Define ways in which a government budget deficit hurts : Explain two ways in which a government budget deficit hurts a future worker. Explain your answer and support with concepts of knowledge in macroeconomics.

Critically discuss all the types of breach of contract : BUSS 1004 Business Law Assignment - Middle East College, Oman. Critically discuss all the types of breach of contract under Oman Commercial law

Describe all mba entrepreneurship topics : Describe all MBA Entrepreneurship topics usually thought at university?

Prepare journal entries for all the transactions : Prepare journal entries for all the transactions occurring in January. Prepare the unadjusted trial balance as of January 31st. Prepare adjusting entries.

Checking the financial records for accuracy : Describe a process for collating and checking the financial records for accuracy.

Food and beverage expenses : Food and Beverage expenses were $12,128 and Labor expenses were $14,553. Other operating expenses were $10,642.

Ceremonies as expressions of their corporate culture : Corporate or organizational culture is the set of values, beliefs, understandings, and norms shared by those who are its members.

Identify a famous whistle blower : Identify a famous whistle blower. Describe some attribute, as well as the situation, dilemmas whether they should confirms. One page single space.

User Account

All Pages